Lawson Insight Technical Documentation |
|
TXCODEMAST
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
AM115 AM15.1 AM15.2 AM15.3 AM15.4 AM20.1
AM20.3 AM21.1 AM21.3 AM500 AM51.1 AM551
AM97.1 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 AP30.4 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 BR122 BR123
BR151 BR152 BR156 BR16.1 BR420 BR521
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 MA126 MA180
MA208 MA41.1 MA41.2 MA41.4 MA41.7 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 MA75.1 MA80.1 MAI1.1 PBIP.1
PO100 PO101 PO122 PO131 PO132 PO150
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO220 PO229 PO23.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 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.4 POED.1 POI3.1 POI7.1 POIF.1 POIG.1
POII.1 POIJ.1 POIM.1 POIT.1 PR05.1 PR05.3
PR197 PR226 PR247 PR26.1 PR47.1 PR514
UK47.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ35.1
RQ500 RQIB.1 RQIC.1 RQID.1 RQIE.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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TCM-TAX-CODE Alpha 10 AM115 AM15.1
Element: Tax Code This field contains a code representing AM15.2 AM15.3
specific tax information. You define AM15.4 AM20.1
tax codes using TX01.1 (Tax Code AM20.3 AM21.1
Master). AM21.3 AM500
AM51.1 AM551
AM97.1 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 AP30.4
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
...
TCM-DESCRIPTION Alpha 30 (Lower Case) AM115 AM15.1
Element: Description This field contains the description of AM15.2 AM15.3
the tax code. AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 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 AP30.4
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
...
TCM-TAX-TYPE Alpha 1 AM115 AM15.1
Element: Tax Type This field indicates how the tax is to AM15.2 AM15.3
be used (tax table code, stand-alone, or AM15.4 AM20.1
table member). AM20.3 AM21.1
T = Tax Table Code AM21.3 AM500
S = Stand-alone AM51.1 AM551
M = Table Member AM97.1 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 AP30.4
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
...
TXCODEMAST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TCMSET1 TAX-CODE This index is used to access and update AM115 AM15.1
tax code master records. AM15.2 AM15.3
AM15.4 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 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
...
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
|