 |
Lawson Insight Technical Documentation |
|
TXTAXTABLE FILE
Tax Table
The Tax Table file contains tax table information. A tax table defines a
series of up to eight tax codes to be applied to a single transaction and it
defines how each tax code will affect the taxable amount of a transaction.
The tax table code can be assigned to a transaction to create up to eight
individual tax distribution records for the transaction.
REFERENCED BY
BL121 BL123 BL202 BL290 BL80.1 TX02.1
TX03.1 TX03.2 TX140 TX300
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 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.2 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
TXT-TAX-TABLE Alpha 10 AP00.3 AP10.1
Tax Table A user-defined code for the tax table. AP10.2 AP10.5
This field represents up to eight AP10.6 AP110
individual tax codes to be applied to AP170 AP180
the same transaction. AP181 AP190
AP30.2 AP32.2
The tax table code must have already AP510 AP520
been defined using TX01.1 (Tax Code API1.1 API2.1
Master). 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 BL802
BR00.2 BR11.1
BR120 BR121
BR420 BRIP.1
CB03.2 CB10.1
CB10.3 CB191
CB20.1 CB30.1
CB500 CXCP.1
...
TXT-EFFECT-DATE Numeric 8 (yyyymmdd) AP00.3 AP10.1
Effective Date The effective date for the tax table. AP10.2 AP10.5
More than one tax table can exist with AP10.6 AP110
the same name and different effective AP170 AP180
dates. 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 BL802
BR00.2 BR11.1
BR120 BR121
BR420 BRIP.1
CB03.2 CB10.1
CB10.3 CB191
CB20.1 CB30.1
CB500 CXCP.1
...
TXT-DESCRIPTION Alpha 30 (Lower Case) AP00.3 AP10.1
Description The name or description of the tax AP10.2 AP10.5
table. 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 BL802
BR00.2 BR11.1
BR120 BR121
BR420 BRIP.1
CB03.2 CB10.1
CB10.3 CB191
CB20.1 CB30.1
CB500 CXCP.1
...
TXT-TAX-CODE1 Alpha 10 AP00.3 AP10.1
Tax Table - Tax The first tax code in the tax table. AP10.2 AP10.5
Code 1 The first tax code is used to calculate AP10.6 AP110
the sales tax based on the taxable AP170 AP180
transaction amount. The tax code must AP181 AP190
have already been defined using TX01.1 AP30.2 AP32.2
(Tax Code Master). 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 BL802
BR00.2 BR11.1
BR120 BR121
BR420 BRIP.1
CB03.2 CB10.1
CB10.3 CB191
CB20.1 CB30.1
CB500 CXCP.1
...
TXT-FLAG1 Alpha 1 AP00.3 AP10.1
Tax Distrib. Flag - This field indicates what the effect AP10.2 AP10.5
Tax Code 1 will be on taxable amounts for the next AP10.6 AP110
tax code in the table. The tax rate AP170 AP180
defined for the first tax code in the AP181 AP190
table will be calculated against the AP30.2 AP32.2
taxable amount of the transaction. AP510 AP520
API1.1 API2.1
Leave the field blank to have no effect API3.1 API4.1
on the next tax code's taxable amount. API5.1 AR08.1
AR115 AR124
Add means that the value of that AR15.4 AR190
calculation will be added to the AR20.1 AR21.1
transaction's taxable amount for the AR21.2 AR21.3
next tax code. AR24.1 AR29.2
AR30.1 AR30.2
Subtract means that the value of that AR30.4 AR42.1
tax calculation will be subtracted from AR42.2 AR42.7
the taxable amount of the transaction AR43.1 AR550
for the next tax code. AR560 AR570
+ = Add To Taxable AR575 AR580
- = Subtract From Taxable BL01.1 BL02.1
" " = No Effect On Taxable BL09.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
...
TXT-TAX-CODE2 Alpha 10 AP00.3 AP10.1
Tax Table - Tax The second tax code in the tax table. AP10.2 AP10.5
Code 2 You must have defined the tax code using AP10.6 AP110
TX01.1 (Tax Code Master). 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 BL802
BR00.2 BR11.1
BR120 BR121
BR420 BRIP.1
CB03.2 CB10.1
CB10.3 CB191
CB20.1 CB30.1
CB500 CXCP.1
...
TXT-FLAG2 Alpha 1 AP00.3 AP10.1
Tax Distrib. Flag - This field indicates what the effect AP10.2 AP10.5
Tax Code 2 will be on the taxable amounts for the AP10.6 AP110
next tax code in the table. AP170 AP180
AP181 AP190
Leave the field blank to have no effect AP30.2 AP32.2
on the next tax code's taxable amount. AP510 AP520
API1.1 API2.1
Add means that the value of that tax API3.1 API4.1
calculation will be added to the API5.1 AR08.1
transaction's taxable amount for the AR115 AR124
next tax code. AR15.4 AR190
AR20.1 AR21.1
Subtract means that the value of that AR21.2 AR21.3
tax calculation will be subtracted from AR24.1 AR29.2
the taxable amount of the transaction AR30.1 AR30.2
for the next tax code. AR30.4 AR42.1
+ = Add To Taxable AR42.2 AR42.7
- = Subtract From Taxable AR43.1 AR550
" " = No Effect On Taxable AR560 AR570
AR575 AR580
BL01.1 BL02.1
BL09.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
...
TXT-TAX-CODE3 Alpha 10 AP00.3 AP10.1
Tax Table - Tax The third tax code in the tax table. AP10.2 AP10.5
Code 3 You must have already defined the tax AP10.6 AP110
code using TX01.1 (Tax Code Master). 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 BL802
BR00.2 BR11.1
BR120 BR121
BR420 BRIP.1
CB03.2 CB10.1
CB10.3 CB191
CB20.1 CB30.1
CB500 CXCP.1
...
TXT-FLAG3 Alpha 1 AP00.3 AP10.1
Tax Distrib. Flag - This field indicates what the effect AP10.2 AP10.5
Tax Code 3 will be on taxable amounts for the next AP10.6 AP110
tax code in the table. AP170 AP180
AP181 AP190
Leave the field blank to have no effect AP30.2 AP32.2
on the next tax code's taxable amount. AP510 AP520
API1.1 API2.1
Add means that the value of that tax API3.1 API4.1
calculation will be added to the taxable API5.1 AR08.1
amount of the transaction for the next AR115 AR124
tax code. AR15.4 AR190
AR20.1 AR21.1
Subtract means that the value of that AR21.2 AR21.3
tax calculation will be subtracted from AR24.1 AR29.2
the taxable amount of the transaction AR30.1 AR30.2
for the next tax code. AR30.4 AR42.1
+ = Add To Taxable AR42.2 AR42.7
- = Subtract From Taxable AR43.1 AR550
" " = No Effect On Taxable AR560 AR570
AR575 AR580
BL01.1 BL02.1
BL09.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
...
TXT-TAX-CODE4 Alpha 10 AP00.3 AP10.1
Tax Table - Tax The fourth tax code in the tax table. AP10.2 AP10.5
Code 4 You must have already defined the tax AP10.6 AP110
code using TX01.1 (Tax Code Master). 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 BL802
BR00.2 BR11.1
BR120 BR121
BR420 BRIP.1
CB03.2 CB10.1
CB10.3 CB191
CB20.1 CB30.1
CB500 CXCP.1
...
TXT-FLAG4 Alpha 1 AP00.3 AP10.1
Tax Distrib. Flag - This field indicates what the effect AP10.2 AP10.5
Tax Code 4 will be on taxable amounts for the next AP10.6 AP110
tax code in the table. AP170 AP180
AP181 AP190
Leave the field blank to have no effect AP30.2 AP32.2
on the next tax code's taxable amount. AP510 AP520
API1.1 API2.1
Add means that the value of that tax API3.1 API4.1
calculation will be added to the taxable API5.1 AR08.1
amount of the transaction for the next AR115 AR124
tax code. AR15.4 AR190
AR20.1 AR21.1
Subtract means that the value of that AR21.2 AR21.3
tax calculation will be subtracted from AR24.1 AR29.2
the taxable amount of the transaction AR30.1 AR30.2
for the next tax code. AR30.4 AR42.1
+ = Add To Taxable AR42.2 AR42.7
- = Subtract From Taxable AR43.1 AR550
" " = No Effect On Taxable AR560 AR570
AR575 AR580
BL01.1 BL02.1
BL09.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
...
TXT-TAX-CODE5 Alpha 10 AP00.3 AP10.1
Tax Table - Tax The fifth tax code in the tax table. AP10.2 AP10.5
Code 5 You must have already defined the tax AP10.6 AP110
code using TX01.1 (Tax Code Master). 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 BL802
BR00.2 BR11.1
BR120 BR121
BR420 BRIP.1
CB03.2 CB10.1
CB10.3 CB191
CB20.1 CB30.1
CB500 CXCP.1
...
TXT-FLAG5 Alpha 1 AP00.3 AP10.1
Tax Distrib. Flag - This field indicates what the effect AP10.2 AP10.5
Tax Code 5 will be on taxable amounts for the next AP10.6 AP110
tax code in the table. AP170 AP180
AP181 AP190
Leave the field blank to have no effect AP30.2 AP32.2
on the next tax code's taxable amount. AP510 AP520
API1.1 API2.1
Add means that the value of that tax API3.1 API4.1
calculation will be added to the taxable API5.1 AR08.1
amount of the transaction for the next AR115 AR124
tax code. AR15.4 AR190
AR20.1 AR21.1
Subtract means that the value of that AR21.2 AR21.3
tax calculation will be subtracted from AR24.1 AR29.2
the taxable amount of the transaction AR30.1 AR30.2
for the next tax code. AR30.4 AR42.1
+ = Add To Taxable AR42.2 AR42.7
- = Subtract From Taxable AR43.1 AR550
" " = No Effect On Taxable AR560 AR570
AR575 AR580
BL01.1 BL02.1
BL09.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
...
TXT-TAX-CODE6 Alpha 10 AP00.3 AP10.1
Tax Table - Tax The sixth tax code in the tax table. AP10.2 AP10.5
Code 6 You must have already defined the tax AP10.6 AP110
code using TX01.1 (Tax Code Master). 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 BL802
BR00.2 BR11.1
BR120 BR121
BR420 BRIP.1
CB03.2 CB10.1
CB10.3 CB191
CB20.1 CB30.1
CB500 CXCP.1
...
TXT-FLAG6 Alpha 1 AP00.3 AP10.1
Tax Distrib. Flag - This field indicates what the effect AP10.2 AP10.5
Tax Code 6 will be on taxable amounts for the next AP10.6 AP110
tax code in the table. AP170 AP180
AP181 AP190
Leave the field blank to have no effect AP30.2 AP32.2
on the next tax code's taxable amount. AP510 AP520
API1.1 API2.1
Add means that the value of that tax API3.1 API4.1
calculation will be added to the taxable API5.1 AR08.1
amount of the transaction for the next AR115 AR124
tax code. AR15.4 AR190
AR20.1 AR21.1
Subtract means that the value of that AR21.2 AR21.3
tax calculation will be subtracted from AR24.1 AR29.2
the taxable amount of the transaction AR30.1 AR30.2
for the next tax code. AR30.4 AR42.1
+ = Add To Taxable AR42.2 AR42.7
- = Subtract From Taxable AR43.1 AR550
" " = No Effect On Taxable AR560 AR570
AR575 AR580
BL01.1 BL02.1
BL09.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
...
TXT-TAX-CODE7 Alpha 10 AP00.3 AP10.1
Tax Table - Tax The seventh tax code in the tax table. AP10.2 AP10.5
Code 7 You must have already defined the tax AP10.6 AP110
code using TX01.1 (Tax Code Master). 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 BL802
BR00.2 BR11.1
BR120 BR121
BR420 BRIP.1
CB03.2 CB10.1
CB10.3 CB191
CB20.1 CB30.1
CB500 CXCP.1
...
TXT-FLAG7 Alpha 1 AP00.3 AP10.1
Tax Distrib. Flag - This field indicates what the effect AP10.2 AP10.5
Tax Code 7 will be on taxable amounts for the next AP10.6 AP110
tax code in the table. AP170 AP180
AP181 AP190
Leave the field blank to have no effect AP30.2 AP32.2
on the next tax code's taxable amount. AP510 AP520
API1.1 API2.1
Add means that the value of that tax API3.1 API4.1
calculation will be added to the taxable API5.1 AR08.1
amount of the transaction for the next AR115 AR124
tax code. AR15.4 AR190
AR20.1 AR21.1
Subtract means that the value of that AR21.2 AR21.3
tax calculation will be subtracted from AR24.1 AR29.2
the taxable amount of the transaction AR30.1 AR30.2
for the next tax code. AR30.4 AR42.1
+ = Add To Taxable AR42.2 AR42.7
- = Subtract From Taxable AR43.1 AR550
" " = No Effect On Taxable AR560 AR570
AR575 AR580
BL01.1 BL02.1
BL09.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
...
TXT-TAX-CODE8 Alpha 10 AP00.3 AP10.1
Tax Table - Tax The eighth tax code in the tax table. AP10.2 AP10.5
Code 8 You must have already defined the tax AP10.6 AP110
code using TX01.1 (Tax Code Master). 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 BL802
BR00.2 BR11.1
BR120 BR121
BR420 BRIP.1
CB03.2 CB10.1
CB10.3 CB191
CB20.1 CB30.1
CB500 CXCP.1
...
TXT-FLAG8 Alpha 1 AP00.3 AP10.1
Tax Distrib. Flag - The taxable effect for the last tax AP10.2 AP10.5
Tax Code 8 code in the table must be blank. AP10.6 AP110
+ = Add To Taxable AP170 AP180
- = Subtract From Taxable AP181 AP190
" " = No Effect On Taxable 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 BL802
BR00.2 BR11.1
BR120 BR121
BR420 BRIP.1
CB03.2 CB10.1
CB10.3 CB191
CB20.1 CB30.1
CB500 CXCP.1
...
TXTAXTABLE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXTSET1 TAX-TABLE This index is used to access the most AP00.3 AP10.1
EFFECT-DATE* recent tax table record using a AP10.2 AP10.5
descending key. 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
...
TXTSET3 TAX-TABLE This index is used to access tax tables
EFFECT-DATE without using a descending key.
KeyChange
TXTAXTABLE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Code 1 Mast TXCODEMAST Required
TXT-TAX-CODE1 -> TCM-TAX-CODE (TCMSET1)
Code 2 Mast TXCODEMAST Required
When TXT-TAX-CODE2 != Spaces
TXT-TAX-CODE2 -> TCM-TAX-CODE
Code 3 Mast TXCODEMAST Required
When TXT-TAX-CODE3 != Spaces
TXT-TAX-CODE3 -> TCM-TAX-CODE
Code 4 Mast TXCODEMAST Required
When TXT-TAX-CODE4 != Spaces
TXT-TAX-CODE4 -> TCM-TAX-CODE
Code 5 Mast TXCODEMAST Required
When TXT-TAX-CODE5 != Spaces
TXT-TAX-CODE5 -> TCM-TAX-CODE
Code 6 Mast TXCODEMAST Required
When TXT-TAX-CODE6 != Spaces
TXT-TAX-CODE6 -> TCM-TAX-CODE
Code 7 Mast TXCODEMAST Required
When TXT-TAX-CODE7 != Spaces
TXT-TAX-CODE7 -> TCM-TAX-CODE
Code 8 Mast TXCODEMAST Required
When TXT-TAX-CODE8 != Spaces
TXT-TAX-CODE8 -> TCM-TAX-CODE
Txcodemast TXCODEMAST Required
TXT-TAX-TABLE -> TCM-TAX-CODE
|