 |
Lawson Insight Technical Documentation |
|
TXTAXRATE FILE
Tax Rate
The Tax Rate file stores tax rates in effect for a specific tax code. You
must define a tax rate for a tax code before the tax code can be applied to a
transaction.
REFERENCED 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
TX140 TX203 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
UPDATED BY
TX03.1 TX03.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXR-TAX-CODE Alpha 10 TX03.1 TX03.2
Tax Code This field is a user-defined code
representing tax information. The tax
code must be defined using TX01.1 (Tax
Code Master).
TXR-PROD-TAX-CAT Alpha 15 TX03.1 TX03.2
Product Tax Category A product tax category lets you
determine the tax rate by item grouping.
You can override the tax rate for items
that could be taxable in one taxing
authority but not another, for example.
Define product tax categories in the
Inventory Control system.
TXR-EFFECT-DATE Numeric 8 (yyyymmdd) TX03.1 TX03.2
Effective Date The date that the tax rate becomes
effective for this tax code.
TXR-TAX-RATE Percent 7.5 (Percent) TX03.1 TX03.2
Tax Rate This field represents the tax rate for
this tax code.
TXR-SECONDARY-RATE Percent 7.5 (Percent) TX03.1 TX03.2
Secondary Rate A secondary tax rate is used when you
need to split the tax rate for a single
taxable transaction amount.
TXR-TAX-NAME Derived
Tax Name This field contains the tax code name.
TXTAXRATE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXRSET1 TAX-CODE This index is used to access the most AP00.3 AP10.1
PROD-TAX-CAT current tax rate record using a AP10.2 AP10.5
EFFECT-DATE* 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
...
TXRSET2 TAX-CODE This index is used to access the most AP00.3 AP10.1
PROD-TAX-CAT current tax rate record for tax codes AP10.2 AP10.5
EFFECT-DATE* with a product tax category using a AP10.6 AP110
descending key. AP170 AP180
KeyChange, Subset AP181 AP190
Where (PROD-TAX-CAT != Spaces ) 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
...
TXRSET3 TAX-CODE This subset is used to access the most AP00.3 AP10.1
PROD-TAX-CAT recent tax rate record for a tax code AP10.2 AP10.5
EFFECT-DATE* without a product tax category using a AP10.6 AP110
descending key. AP170 AP180
KeyChange, Subset AP181 AP190
Where PROD-TAX-CAT = Spaces 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
...
TXTAXRATE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Txcodemast TXCODEMAST Required
TXR-TAX-CODE -> TCM-TAX-CODE
|