|
|
TXCODEMAST FILE
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
ET700 PO225 TX04.1 TX06.2 TX06.3 TX100
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 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 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 AP30.2 AP30.4 AP305 AP510
AP520 AP90.1 AP91.1 AP95.1 API1.1 API2.1
API3.1 API4.1 API5.1 AR08.1 AR10.1 AR115
AR124 AR15.4 AR190 AR20.1 AR21.1 AR21.2
AR21.3 AR24.1 AR29.2 AR30.1 AR32.1 AR34.1
AR42.1 AR42.2 AR42.7 AR43.1 AR550 AR560
AR570 AR575 AR580 ARLL.1 BL01.1 BL02.1
BL09.1 BL120 BL121 BL122 BL123 BL130
BL20.1 BL20.3 BL20.4 BL20.5 BL20.6 BL202
BL21.2 BL21.5 BL29.1 BL29.2 BL290 BL30.1
BL30.2 BL30.3 BL30.5 BL31.1 BL31.2 BL31.3
BL31.5 BL31.7 BL32.1 BL32.2 BL32.3 BL32.4
BL520 BL80.1 BL802 BL820 BL92.1 BR00.1
BR00.2 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 CB150 CB191
CB20.1 CB30.1 CB43.1 CB44.1 CB45.1 CB46.1
CB50.1 CB500 CB54.1 CB543 CB544 CB55.1
CB554 CXCP.1 DT180 DT181 EE05.1 EE20.3
EE520 ET175 ET542 IC02.1 IC11.1 IC12.1
IC130 IC330 IC811 IC812 MX123 MX500
MA08.1 MA180 MA208 MA279 MA310 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MA530 MA531 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA63.1 MA65.1
MA66.2 MA66.3 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PD235
PO10.1 PO100 PO101 PO120 PO122 PO131
PO132 PO135 PO136 PO150 PO190 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO220 PO223 PO229 PO23.1 PO233 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO253 PO254
PO26.1 PO27.2 PO278 PO29.1 PO30.1 PO30.2
PO30.3 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 PO536 PO54.1 PO54.2 PO54.3 PO54.4
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 UK47.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQIB.1 RQIC.1 RQID.1
RQIF.1 RQIG.1 RQII.1 RQIJ.1 TX01.1 TX01.2
TX02.1 TX03.1 TX03.2 TX140 TX221 TX300
TX804 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 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 Alpha 10 AC160 AC56.1
Element: Tax Code This field contains a code representing AC560 AM115
specific tax information. You define AM117 AM15.1
tax codes using TX01.1 (Tax Code AM15.2 AM15.3
Master). AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 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 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
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TCM-DESCRIPTION Alpha 30 (Lower Case) AC160 AC56.1
Element: Description This field contains the description of AC560 AM115
the tax code. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 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 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
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TCM-TAX-TYPE Alpha 1 AC160 AC56.1
Element: Tax Type This field indicates how the tax is to AC560 AM115
be used (tax table code, stand-alone, or AM117 AM15.1
table member). AM15.2 AM15.3
T = Tax Table Code AM15.4 AM19.1
S = Stand-alone AM19.2 AM20.1
M = Table Member AM20.3 AM21.1
AM21.3 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 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
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
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 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
...
TXCODEMAST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|
