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
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 API6.2 AR08.1 AR10.1 AR15.4 AR550
ARLL.1 BR00.1 BR00.2 BR00.4 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 EE52.2 EE520
DR100 IC02.1 IC10.1 IC10.2 IC11.1 IC12.1
IC130 IC140 IC141 IC142 IC145 IC243
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 MA126 MA180
MA208 MA26.1 MA278 MA279 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
MA53.1 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 PD570
PO04.1 PO04.2 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO135
PO136 PO15.1 PO15.2 PO15.4 PO150 PO17.1
PO190 PO192 PO195 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.2 PO22.3 PO22.4 PO22.5 PO220
PO222 PO223 PO224 PO225 PO229 PO23.1
PO230 PO233 PO234 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO251 PO253 PO254 PO26.1
PO26.2 PO26.3 PO26.4 PO26.5 PO26.6 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO278 PO28.2 PO280 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 PO529 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 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ11.3
RQ11.4 RQ11.5 RQ12.1 RQ13.1 RQ13.2 RQ260
RQ35.1 RQ44.1 RQ500 RQ810 RQIA.1 RQIB.1
RQIC.1 RQID.1 RQIF.1 RQIG.1 RQII.1 RQIJ.1
TX01.1 TX01.2 TX02.1 TX04.1 TX100 TX101
TX140 TX203 TX221 TX300 TX804 TXI1.1
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


UPDATED BY
TX03.1 TX03.2

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 02:33:16 2016

Home
Contact Us



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