 |
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
AP125 AP126 AP131 AP170 AP180 AP181
AP190 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.6 AP20.7 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP32.2 AP510 AP520 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 AR30.2
AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR550
AR560 AR570 AR575 AR580 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 IC28.1 IC330 IC811 IC812 IC83.1
IC840 MA08.1 MA180 MA208 MA41.1 MA41.2
MA41.4 MA43.1 MA43.2 MA43.3 MA43.4 MA43.5
MA43.7 MA43.8 MA43.9 MA530 MA531 MA540
MA60.2 MA60.3 MA60.5 MA61.1 MA65.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MAI1.1 PBIP.1
PO100 PO101 PO122 PO131 PO132 PO150
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO220 PO23.1 PO25.1 PO25.2 PO25.6 PO25.7
PO25.8 PO27.2 PO27.3 PO27.4 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO54.4 POED.1
POI3.1 POI7.1 POIE.1 POIF.1 POIG.1 POII.1
POIJ.1 POIT.1 PR197 RQ10.1 RQ10.2 RQ10.3
RQ11.1 RQ35.1 RQ500 RQIB.1 RQIC.1 RQIF.1
RQIG.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 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 AP125 AP126
Master). AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 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 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
BR00.2 BR11.1
...
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
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 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 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
BR00.2 BR11.1
...
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). AP125 AP126
T = Tax Table Code AP131 AP170
S = Stand-alone AP180 AP181
M = Table Member AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 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 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR550
AR560 AR570
AR575 AR580
BR00.2 BR11.1
...
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
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP32.2 AP510
AP520 API1.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
|