TXTAXTABLE – Tax Table

System
Tax (TX)
Prefix
TXT
Primary key
TAX-TABLE, EFFECT-DATE
Fields
19
Updated by
402 programs
Referenced by
10 programs

TXTAXTABLE is the Tax Table table in Lawson Tax (prefix TXT). It is indexed by TAX-TABLE, EFFECT-DATE (TXTSET1). It is related 1:1 to TXCODEMAST. It is updated by AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 and 394 more and referenced by BR180, RQIA.1, TX02.1, TX03.1, TX03.2, TX04.1, TX101, TX140 and 2 more. The table has 19 fields, 1 index and 9 documented relations.

About TXTAXTABLE

The Tax Table file contains tax table information. A tax table defines a series of up to eight tax codes to be applied to a single transaction and it defines how each tax code will affect the taxable amount of a transaction. The tax table code can be assigned to a transaction to create up to eight individual tax distribution records for the transaction.

Fields (19)

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

Field / columnTypeDescription & valuesUpdated by
TXT-TAX-TABLE PK
TAX_TABLE		Alpha 10A user-defined code for the tax table. This field represents up to eight individual tax codes to be applied to the same transaction. The tax table code must have already been defined using TX01.1 (Tax Code Master).AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)The effective date for the tax table. More than one tax table can exist with the same name and different effective dates.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The name or description of the tax table.AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-TAX-CODE1
TAX_CODE1		Alpha 10The first tax code in the tax table. The first tax code is used to calculate the sales tax based on the taxable transaction amount. The tax code must have already been defined using TX01.1 (Tax Code Master).AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-FLAG1
FLAG1		Alpha 1This field indicates what the effect will be on taxable amounts for the next tax code in the table. The tax rate defined for the first tax code in the table will be calculated against the taxable amount of the transaction. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that calculation will be added to the transaction's taxable amount for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code. + = Add To Taxable " " = No Effect On Taxable
  • - Subtract From Taxable
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-TAX-CODE2
TAX_CODE2		Alpha 10The second tax code in the tax table. You must have defined the tax code using TX01.1 (Tax Code Master).AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-FLAG2
FLAG2		Alpha 1This field indicates what the effect will be on the taxable amounts for the next tax code in the table. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that tax calculation will be added to the transaction's taxable amount for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code. + = Add To Taxable " " = No Effect On Taxable
  • - Subtract From Taxable
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-TAX-CODE3
TAX_CODE3		Alpha 10The third tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master).AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-FLAG3
FLAG3		Alpha 1This field indicates what the effect will be on taxable amounts for the next tax code in the table. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that tax calculation will be added to the taxable amount of the transaction for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code. + = Add To Taxable " " = No Effect On Taxable
  • - Subtract From Taxable
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-TAX-CODE4
TAX_CODE4		Alpha 10The fourth tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master).AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-FLAG4
FLAG4		Alpha 1This field indicates what the effect will be on taxable amounts for the next tax code in the table. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that tax calculation will be added to the taxable amount of the transaction for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code. + = Add To Taxable " " = No Effect On Taxable
  • - Subtract From Taxable
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-TAX-CODE5
TAX_CODE5		Alpha 10The fifth tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master).AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-FLAG5
FLAG5		Alpha 1This field indicates what the effect will be on taxable amounts for the next tax code in the table. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that tax calculation will be added to the taxable amount of the transaction for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code. + = Add To Taxable " " = No Effect On Taxable
  • - Subtract From Taxable
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-TAX-CODE6
TAX_CODE6		Alpha 10The sixth tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master).AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-FLAG6
FLAG6		Alpha 1This field indicates what the effect will be on taxable amounts for the next tax code in the table. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that tax calculation will be added to the taxable amount of the transaction for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code. + = Add To Taxable " " = No Effect On Taxable
  • - Subtract From Taxable
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-TAX-CODE7
TAX_CODE7		Alpha 10The seventh tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master).AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-FLAG7
FLAG7		Alpha 1This field indicates what the effect will be on taxable amounts for the next tax code in the table. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that tax calculation will be added to the taxable amount of the transaction for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code. + = Add To Taxable " " = No Effect On Taxable
  • - Subtract From Taxable
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-TAX-CODE8
TAX_CODE8		Alpha 10The eighth tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master).AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)
TXT-FLAG8
FLAG8		Alpha 1The taxable effect for the last tax code in the table must be blank. + = Add To Taxable " " = No Effect On Taxable
  • - Subtract From Taxable
AC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +52 more (list truncated in source)

Indexes (1)

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

IndexKeysFlagsConditionUsed in
TXTSET1TAX-TABLE, EFFECT-DATE*PrimaryAC160, AC56.1, AC560, AM115, AM117, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)

Relations

One to one (9) — lookups and parents

RelationTableRulesConditionField map
Code 1 MastTXCODEMASTRequiredTXT-TAX-CODE1 → TCM-TAX-CODE
Code 2 MastTXCODEMASTRequiredWhen TXT-TAX-CODE2 != SpacesTXT-TAX-CODE2 → TCM-TAX-CODE
Code 3 MastTXCODEMASTRequiredWhen TXT-TAX-CODE3 != SpacesTXT-TAX-CODE3 → TCM-TAX-CODE
Code 4 MastTXCODEMASTRequiredWhen TXT-TAX-CODE4 != SpacesTXT-TAX-CODE4 → TCM-TAX-CODE
Code 5 MastTXCODEMASTRequiredWhen TXT-TAX-CODE5 != SpacesTXT-TAX-CODE5 → TCM-TAX-CODE
Code 6 MastTXCODEMASTRequiredWhen TXT-TAX-CODE6 != SpacesTXT-TAX-CODE6 → TCM-TAX-CODE
Code 7 MastTXCODEMASTRequiredWhen TXT-TAX-CODE7 != SpacesTXT-TAX-CODE7 → TCM-TAX-CODE
Code 8 MastTXCODEMASTRequiredWhen TXT-TAX-CODE8 != SpacesTXT-TAX-CODE8 → TCM-TAX-CODE
TxcodemastTXCODEMASTRequiredTXT-TAX-TABLE → TCM-TAX-CODE

Programs

Updated by (402)

Referenced by (10)