TXCODEMAST

Tax Code Master

The Tax Code Master file contains tax codes, descriptions, and the tax types that define how the tax code is to be used.

REFERENCED BY
TX04.1 TX06.2 TX06.3 TX101 TX201 TX203


UPDATED BY
AC160 AC56.1 AC560 AM115 AM117 AM15.1
AM15.2 AM15.3 AM15.4 AM19.1 AM19.2 AM20.1
AM20.3 AM21.1 AM21.3 AM22.1 AM500 AM51.1
AM551 AM97.1 AP00.3 AP00.4 AP03.3 AP10.1
AP10.2 AP10.5 AP10.6 AP110 AP115 AP125
AP126 AP131 AP150 AP170 AP180 AP181
AP190 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.6 AP20.7 AP21.1 AP210 AP220 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP271 AP30.2
AP30.4 AP300 AP305 AP510 AP520 AP90.1
AP91.1 AP95.1 API1.1 API2.1 API3.1 API4.1
API5.1 API6.2 AR08.1 AR10.1 AR15.4 AR550
ARLL.1 BR00.1 BR00.2 BR00.4 BR02.3 BR11.1
BR120 BR121 BR122 BR123 BR140 BR151
BR152 BR156 BR16.1 BR180 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BR20.6 BR420 BR46.1
BR46.2 BR46.4 BR48.1 BR521 CB03.2 CB10.1
CB10.3 CB10.5 CB150 CB191 CB20.1 CB20.6
CB30.1 CB43.1 CB44.1 CB45.1 CB46.1 CB50.1
CB500 CB54.1 CB543 CB544 CB55.1 CB554
CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CX805
CXCP.1 EE05.1 EE11.1 EE20.3 EE52.2 EE520
DR100 IC02.1 IC10.1 IC10.2 IC11.1 IC12.1
IC130 IC140 IC141 IC142 IC145 IC243
IC330 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC802
IC81.1 IC811 IC812 IC83.1 IC840 EX175
EX542 MX123 MX500 MA08.1 MA126 MA180
MA208 MA26.1 MA278 MA279 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA540 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA69.1 MA70.1
MA75.1 MA80.1 MAED.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD235 PD570
PO04.1 PO04.2 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO135
PO136 PO15.1 PO15.2 PO15.4 PO150 PO17.1
PO190 PO192 PO195 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.2 PO22.3 PO22.4 PO22.5 PO220
PO222 PO223 PO224 PO225 PO229 PO23.1
PO230 PO233 PO234 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO251 PO253 PO254 PO26.1
PO26.2 PO26.3 PO26.4 PO26.5 PO26.6 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO278 PO28.2 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.1 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO529 PO536 PO54.1
PO54.2 PO54.3 PO54.4 PO54.5 POCP.1 POED.1
POI3.1 POI7.1 POID.1 POIF.1 POIG.1 POII.1
POIJ.1 POIM.1 POIT.1 PR05.1 PR05.3 PR226
PR247 PR26.1 PR47.1 PR514 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ11.3
RQ11.4 RQ11.5 RQ12.1 RQ13.1 RQ13.2 RQ260
RQ35.1 RQ44.1 RQ500 RQ810 RQIA.1 RQIB.1
RQIC.1 RQID.1 RQIF.1 RQIG.1 RQII.1 RQIJ.1
TX01.1 TX01.2 TX02.1 TX03.1 TX03.2 TX100
TX140 TX221 TX300 TX804 TXI1.1 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TCM-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. You define tax codes using TX01.1 (Tax Code Master).
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TCM-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the description of the tax code.
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TCM-TAX-TYPE
Element: Tax Type
Alpha 1
This field indicates how the tax is to be used (tax table code, stand-alone, or table member).
T = Tax Table Code
S = Stand-alone
M = Table Member
C = Calculated Rate
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
AP126 AP131
AP150 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TCM-STATUS
Element: Status
Numeric 1

0 = Active
1 = Inactive


TXCODEMAST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TCMSET1 TAX-CODE
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125


TXCODEMAST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Txtaxcode TXTAXCODE
TCM-TAX-CODE->TAC-TAX-CODE
  TAC-COMPANY
Txtaxrate TXTAXRATE
TCM-TAX-CODE->TXR-TAX-CODE
  TXR-PROD-TAX-CAT
  TXR-EFFECT-DATE


File created: Thu Jun 09 02:33:11 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.