|
|
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
AC15.1 AP00.3 AP10.1 AP10.2 AP10.5 AP10.6
AP110 AP125 AP126 AP170 AP180 AP181
AP190 AP20.1 AP20.2 AP20.5 AP20.6 AP20.7
AP225 AP226 AP23.1 AP25.1 AP25.2 AP26.1
AP30.2 AP32.2 AP510 AP520 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 AR82.1 BL02.1
BL08.1 BL09.1 BL120 BL121 BL122 BL123
BL130 BL20.1 BL20.3 BL202 BL21.2 BL21.5
BL29.1 BL29.2 BL290 BL520 BL80.1 BL802
BL820 BL902 BL92.1 BL940 CB03.2 CB10.1
CB10.3 CB191 CB20.1 CB30.1 CB500 CX05.1
CX05.2 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CX805 CXCP.1
DT180 DT181 EE05.3 EE20.3 EE520 DR100
IC02.1 IC10.1 IC10.2 IC11.1 IC12.1 IC141
IC142 IC811 IC812 IC83.1 IN20.1 MA08.1
MA140 MA208 MA40.1 MA40.2 MA41.1 MA41.2
MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3
MA43.4 MA52.1 MA530 MA540 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE112
OE113 OE114 OE129 OE14.1 OE14.2 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE80.1 OE80.2 OE80.3
OE80.4 OE80.5 OE810 OE830 OE920 OE950
PBIP.1 PO100 PO120 PO121 PO122 PO123
PO132 PO20.1 PO21.1 PO21.2 PO21.5 PO21.6
PO22.1 PO22.2 PO22.3 PO220 PO225 PO25.1
PO25.3 PO25.4 PO25.7 PO28.3 PO28.8 PO31.1
PO820 PO821 RQ10.1 RQ10.3 RQ11.1 RQ20.1
RQ20.3 RQ20.4 RQ35.1 RQ500 TX01.1 TX01.2
TX02.1 TX140 TX203 TX300 TX804 TX904
WH130 WH132 WH190 WH20.2 WH20.7 WH222
WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3
WH32.1 WH32.2 WH32.3 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
UPDATED BY
TX03.1 TX03.2 TX956
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 TX956
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 TX956
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 TX956
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 TX956
this tax code.
TXR-SECONDARY-RATE Percent 7.5 (Percent) TX03.1 TX03.2
Secondary Rate A secondary tax rate is used when you TX956
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 AC15.1 AP00.3
PROD-TAX-CAT current tax rate record using a AP10.1 AP10.2
EFFECT-DATE* descending key. AP10.5 AP10.6
AP110 AP125
AP126 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
...
TXRSET2 TAX-CODE This index is used to access the most AC15.1 AP00.3
PROD-TAX-CAT current tax rate record for tax codes AP10.1 AP10.2
EFFECT-DATE* with a product tax category using a AP10.5 AP10.6
descending key. AP110 AP125
KeyChange, Subset AP126 AP170
Where (PROD-TAX-CAT != Spaces ) AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
...
TXRSET3 TAX-CODE This subset is used to access the most AC15.1 AP00.3
PROD-TAX-CAT recent tax rate record for a tax code AP10.1 AP10.2
EFFECT-DATE* without a product tax category using a AP10.5 AP10.6
descending key. AP110 AP125
KeyChange, Duplicates, Subset AP126 AP170
Where PROD-TAX-CAT = Spaces AP180 AP181
AP190 AP20.1
AP20.2 AP20.5
AP20.6 AP20.7
AP225 AP226
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP32.2
AP510 AP520
AR08.1 AR10.1
...
TXTAXRATE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Txcodemast TXCODEMAST Required
TXR-TAX-CODE -> TCM-TAX-CODE
|