|
|
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
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
TX140 TX203 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
UPDATED BY
TX03.1 TX03.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXR-TAX-CODE Alpha 10 TX03.1 TX03.2
Element: 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
Element: Product Tax CaA 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
Element: Date The date that the tax rate becomes
effective for this tax code.
TXR-TAX-RATE Percent 7.5 (Percent) TX03.1 TX03.2
Element: Chrg Rate This field represents the tax rate for
this tax code.
TXR-SECONDARY-RATE Percent 7.5 (Percent) TX03.1 TX03.2
Element: Chrg 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
Element: 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 AM115 AM15.1
PROD-TAX-CAT current tax rate record using a AM15.2 AM15.3
EFFECT-DATE* descending key. 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
...
TXRSET2 TAX-CODE This index is used to access the most AM115 AM15.1
PROD-TAX-CAT current tax rate record for tax codes AM15.2 AM15.3
EFFECT-DATE* with a product tax category using a AM15.4 AM20.1
descending key. AM20.3 AM21.1
KeyChange, Subset AM21.3 AM500
Where (PROD-TAX-CAT != Spaces ) 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
...
TXRSET3 TAX-CODE This subset is used to access the most AM115 AM15.1
PROD-TAX-CAT recent tax rate record for a tax code AM15.2 AM15.3
EFFECT-DATE* without a product tax category using a AM15.4 AM20.1
descending key. AM20.3 AM21.1
KeyChange, Subset AM21.3 AM500
Where PROD-TAX-CAT = Spaces 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
...
TXTAXRATE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Txcodemast TXCODEMAST Required
TXR-TAX-CODE -> TCM-TAX-CODE
|
