TXTAXRATE – Tax Rate

System
Tax (TX)
Prefix
TXR
Primary key
TAX-CODE, PROD-TAX-CAT, EFFECT-DATE
Fields
7
Updated by
2 programs
Referenced by
413 programs

TXTAXRATE is the Tax Rate table in Lawson Tax (prefix TXR). It is indexed by TAX-CODE, PROD-TAX-CAT, EFFECT-DATE (TXRSET1); alternate indexes: TXRSET2 and TXRSET3. It is related 1:1 to TXCODEMAST. It is updated by TX03.1 and TX03.2 and referenced by AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 and 405 more. The table has 7 fields, 3 indexes and 1 documented relation.

About TXTAXRATE

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.

Fields (7)

Column = COBOL field name without the TXR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
TXR-TAX-CODE PK
TAX_CODE		Alpha 10This 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 PK
PROD_TAX_CAT		Alpha 15A 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 PK
EFFECT_DATE		Numeric 8 (yyyymmdd)The date that the tax rate becomes effective for this tax code.TX03.1, TX03.2
TXR-TAX-RATE
TAX_RATE		Percent 7.5 (Percent)This field represents the tax rate for this tax code.TX03.1, TX03.2
TXR-SECONDARY-RATE
SECONDARY_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
TAX_NAME		DerivedThis field contains the tax code name.—
TXR-DISCRETION-AMT
DISCRETION_AMT		Signed 15.2This is the taxable amount.—

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TXRSET1TAX-CODE, PROD-TAX-CAT, EFFECT-DATE*PrimaryAC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)
TXRSET2TAX-CODE, PROD-TAX-CAT, EFFECT-DATE*KeyChange, SubsetWhere (PROD-TAX-CAT != Spaces)AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)
TXRSET3TAX-CODE, PROD-TAX-CAT, EFFECT-DATE*KeyChange, SubsetWhere PROD-TAX-CAT = SpacesAC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
TxcodemastTXCODEMASTRequiredTXR-TAX-CODE → TCM-TAX-CODE

Programs

Updated by (2)

Referenced by (413)