|
|
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
OE13.1 TX04.1 TX06.2 TX06.3 TX100 TX201
TX203 TX206 TX225
UPDATED BY
AC15.1 AP00.3 AP10.1 AP10.2 AP10.5 AP10.6
AP110 AP125 AP126 AP170 AP180 AP181
AP190 AP20.1 AP20.2 AP20.5 AP20.6 AP20.7
AP225 AP226 AP23.1 AP25.1 AP25.2 AP26.1
AP30.2 AP32.2 AP510 AP520 AR08.1 AR10.1
AR115 AR124 AR15.4 AR190 AR20.1 AR21.1
AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2
AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR550
AR560 AR570 AR575 AR580 AR82.1 BL02.1
BL08.1 BL09.1 BL120 BL121 BL122 BL123
BL130 BL20.1 BL20.3 BL202 BL21.2 BL21.5
BL29.1 BL29.2 BL290 BL520 BL80.1 BL802
BL820 BL902 BL92.1 BL940 CB03.2 CB10.1
CB10.3 CB191 CB20.1 CB30.1 CB500 CX05.1
CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CX805 CXCP.1
DT180 DT181 EE05.3 EE20.3 EE520 DR100
IC02.1 IC10.1 IC10.2 IC11.1 IC12.1 IC141
IC142 IC811 IC812 IC83.1 IN20.1 MA08.1
MA140 MA208 MA40.1 MA40.2 MA41.1 MA41.2
MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3
MA43.4 MA52.1 MA530 MA540 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE112
OE113 OE114 OE129 OE14.1 OE14.2 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE80.1 OE80.2 OE80.3
OE80.4 OE80.5 OE810 OE830 OE920 OE950
PBIP.1 PO100 PO120 PO121 PO122 PO123
PO132 PO20.1 PO21.1 PO21.2 PO21.5 PO21.6
PO22.1 PO22.2 PO22.3 PO220 PO225 PO25.1
PO25.3 PO25.4 PO25.7 PO28.3 PO28.8 PO31.1
PO820 PO821 RQ10.1 RQ10.3 RQ11.1 RQ20.1
RQ20.3 RQ20.4 RQ35.1 RQ500 TX01.1 TX01.2
TX02.1 TX03.1 TX03.2 TX140 TX300 TX804
TX904 TX954 TX955 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3
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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TCM-TAX-CODE Alpha 10 AC15.1 AP00.3
Tax Code This field contains a code representing AP10.1 AP10.2
specific tax information. You define AP10.5 AP10.6
tax codes using TX01.1 (Tax Code AP110 AP125
Master). AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL121
BL122 BL123
...
TCM-DESCRIPTION Alpha 30 (Lower Case) AC15.1 AP00.3
Description This field contains the description of AP10.1 AP10.2
the tax code. AP10.5 AP10.6
AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL121
BL122 BL123
...
TCM-TAX-TYPE Alpha 1 AC15.1 AP00.3
Tax Type This field indicates how the tax is to AP10.1 AP10.2
be used (tax table code, stand-alone, or AP10.5 AP10.6
table member). AP110 AP125
T = Tax Table Code AP126 AP170
S = Stand-alone AP180 AP181
M = Table Member AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
BL08.1 BL09.1
BL120 BL121
BL122 BL123
...
TXCODEMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TCMSET1 TAX-CODE This index is used to access and update AC15.1 AP00.3
tax code master records. AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
...
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
|