 |
Lawson Insight Technical Documentation |
|
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
PO225 TX04.1 TX06.2 TX06.3 TX100 TX201
TX203
UPDATED BY
AP00.3 AP10.1 AP10.2 AP10.5 AP10.6 AP110
AP170 AP180 AP181 AP190 AP30.2 AP32.2
AP510 AP520 API1.1 API2.1 API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1 BL09.1 BL121 BL123 BL202
BL290 BL80.1 BL802 BR00.2 BR11.1 BR120
BR121 BR420 BRIP.1 CB03.2 CB10.1 CB10.3
CB191 CB20.1 CB30.1 CB500 CXCP.1 DT180
DT181 EE05.1 EE20.3 EE520 DR100 IC02.1
IC10.1 IC10.2 IC11.1 IC12.1 IC141 IC142
IC330 IC811 IC812 IC83.1 MA08.1 MA208
MA65.1 PO132 PO220 POED.1 POI7.1 POIF.1
POIJ.1 POIT.1 PR197 TX01.1 TX01.2 TX02.1
TX03.1 TX03.2 TX140 TX300 TX804 WH130
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TCM-TAX-CODE Alpha 10 AP00.3 AP10.1
Tax Code This field contains a code representing AP10.2 AP10.5
specific tax information. You define AP10.6 AP110
tax codes using TX01.1 (Tax Code AP170 AP180
Master). AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL121
BL123 BL202
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
...
TCM-DESCRIPTION Alpha 30 (Lower Case) AP00.3 AP10.1
Description This field contains the description of AP10.2 AP10.5
the tax code. AP10.6 AP110
AP170 AP180
AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL121
BL123 BL202
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
...
TCM-TAX-TYPE Alpha 1 AP00.3 AP10.1
Tax Type This field indicates how the tax is to AP10.2 AP10.5
be used (tax table code, stand-alone, or AP10.6 AP110
table member). AP170 AP180
T = Tax Table Code AP181 AP190
S = Stand-alone AP30.2 AP32.2
M = Table Member AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.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
BL01.1 BL02.1
BL09.1 BL121
BL123 BL202
BL290 BL80.1
BL802 BR00.2
BR11.1 BR120
BR121 BR420
BRIP.1 CB03.2
CB10.1 CB10.3
...
TXCODEMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TCMSET1 TAX-CODE This index is used to access and update AP00.3 AP10.1
tax code master records. AP10.2 AP10.5
AP10.6 AP110
AP170 AP180
AP181 AP190
AP30.2 AP32.2
AP510 AP520
API1.1 API2.1
API3.1 API4.1
API5.1 AR08.1
AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
...
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
|