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
TX203


UPDATED BY
TX03.1 TX03.2 AM115 AM117 AM15.1 AM15.2
AM15.3 AM15.4 AM19.1 AM19.2 AM20.1 AM20.3
AM21.1 AM21.3 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 AP30.2 AP30.4 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 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 EE05.1 EE11.1 EE20.3
EE520 EX175 EX542 MX123 MX500 MA08.1
MA208 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA540
MAED.1 MAI1.1 PO10.1 PO136 PO190 PO300
PO520 POCP.1 POED.1 POI3.1 POI7.1 POIF.1
POIG.1 POII.1 POIJ.1 POIM.1 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 UK47.1
RQ01.1 TX01.1 TX01.2 TX02.1 TX140 TX221
TX300 TX804

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*
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
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
TXRSET2 TAX-CODE
PROD-TAX-CAT
EFFECT-DATE*
KeyChange, Subset
Where(PROD-TAX-CAT !=Spaces)
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
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
TXRSET3 TAX-CODE
PROD-TAX-CAT
EFFECT-DATE*
KeyChange, Subset
WherePROD-TAX-CAT =Spaces
...
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM20.1 AM20.3
AM21.1 AM21.3
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


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: Wed Jun 08 20:51:47 2016

Home
Contact Us



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