TXTAXRATE

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
TX01.1 TX01.2 TX02.1 TX203 TX221 TX300


UPDATED BY
AC160 AC56.1 AC560 AM115 AM117 AM15.1
AM15.2 AM15.3 AM15.4 AM19.1 AM19.2 AM20.1
AM20.3 AM21.1 AM21.3 AM22.1 AM500 AM51.1
AM551 AM97.1 AP00.3 AP00.4 AP03.3 AP10.1
AP10.2 AP10.5 AP10.6 AP110 AP115 AP125
AP126 AP131 AP150 AP170 AP180 AP181
AP190 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.6 AP20.7 AP21.1 AP210 AP220 AP23.1
AP25.1 AP25.2 AP26.1 AP27.1 AP271 AP30.2
AP30.4 AP300 AP305 AP510 AP520 AP90.1
AP91.1 AP95.1 API1.1 API2.1 API3.1 API4.1
API5.1 AR08.1 AR10.1 AR15.4 AR550 ARLL.1
BR00.1 BR00.2 BR02.3 BR11.1 BR120 BR121
BR122 BR123 BR140 BR151 BR152 BR156
BR16.1 BR180 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR20.6 BR420 BR46.1 BR46.2 BR46.4
BR48.1 BR521 CB03.2 CB10.1 CB10.3 CB10.5
CB150 CB191 CB20.1 CB20.6 CB30.1 CB43.1
CB44.1 CB45.1 CB46.1 CB50.1 CB500 CB54.1
CB543 CB544 CB55.1 CB554 CX05.1 CX05.2
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CX805 CXCP.1 EE05.1
EE11.1 EE20.3 EE520 DR100 IC02.1 IC10.1
IC10.2 IC11.1 IC12.1 IC130 IC140 IC141
IC142 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC802 IC81.1 IC811 IC812 IC83.1 IC840
EX175 EX542 MX123 MX500 MA08.1 MA180
MA208 MA26.1 MA279 MA310 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA530 MA531 MA540 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAED.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD235 PO10.1 PO100
PO101 PO120 PO122 PO131 PO132 PO135
PO136 PO150 PO190 PO20.1 PO20.6 PO20.9
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.2 PO22.3 PO22.4 PO22.5 PO220 PO223
PO229 PO23.1 PO233 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO253 PO254 PO26.1 PO26.2
PO26.3 PO26.4 PO26.5 PO26.6 PO26.7 PO26.9
PO27.2 PO278 PO28.2 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 PO300 PO31.1 PO31.2 PO32.1
PO32.2 PO32.4 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.1 PO54.2 PO54.3
PO54.4 PO54.5 POCP.1 POED.1 POI3.1 POI7.1
POID.1 POIF.1 POIG.1 POII.1 POIJ.1 POIM.1
POIT.1 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 PR514 UK47.1 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ260 RQ35.1 RQ500 RQIA.1 RQIB.1 RQIC.1
RQID.1 RQIF.1 RQIG.1 RQII.1 RQIJ.1 TX03.1
TX03.2 TX140 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 WH32.5 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 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXR-TAX-CODE
Element: Tax Code
Alpha 10
This field is a user-defined code representing tax information. The tax code must be defined using TX01.1 (Tax Code Master).
TX03.1 TX03.2
TXR-PROD-TAX-CAT
Element: Prod Tax Cat
Alpha 15
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.
TX03.1 TX03.2
TXR-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
The date that the tax rate becomes effective for this tax code.
TX03.1 TX03.2
TXR-TAX-RATE
Element: Chrg Rate
Percent 7.5 (Percent)
This field represents the tax rate for this tax code.
TX03.1 TX03.2
TXR-SECONDARY-RATE
Element: Chrg Rate
Percent 7.5 (Percent)
A secondary tax rate is used when you need to split the tax rate for a single taxable transaction amount.
TX03.1 TX03.2
TXR-TAX-NAME
Element: Tax Name
Derived
This field contains the tax code name.
TXR-DISCRETION-AMT
Element: Taxable Amt
Signed 15.2
This is the taxable amount.


TXTAXRATE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXRSET1 TAX-CODE
PROD-TAX-CAT
EFFECT-DATE*
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
TXRSET2 TAX-CODE
PROD-TAX-CAT
EFFECT-DATE*
KeyChange, Subset
Where(PROD-TAX-CAT !=Spaces)
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125
TXRSET3 TAX-CODE
PROD-TAX-CAT
EFFECT-DATE*
KeyChange, Subset
WherePROD-TAX-CAT =Spaces
...
AC160 AC56.1
AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125


TXTAXRATE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Txcodemast TXCODEMAST Required
TXR-TAX-CODE->TCM-TAX-CODE


File created: Thu Jun 09 11:29:33 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.