Tax Table
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.
REFERENCED BY
| BR180 | RQIA.1 | TX02.1 | TX03.1 | TX03.2 | TX04.1 |
| TX101 | TX140 | TX221 | TX300 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY |
|---|---|---|
| TXT-TAX-TABLE Element: Tax Table | Alpha 10 A 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). |
|
| TXT-EFFECT-DATE Element: 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. |
|
| TXT-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The name or description of the tax table. |
|
| TXT-TAX-CODE1 Element: Tax Code | Alpha 10 The 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). |
|
| TXT-FLAG1 Element: Flag1 | Alpha 1 This 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 - = Subtract From Taxable " " = No Effect On Taxable |
|
| TXT-TAX-CODE2 Element: Tax Code | Alpha 10 The second tax code in the tax table. You must have defined the tax code using TX01.1 (Tax Code Master). |
|
| TXT-FLAG2 Element: Flag1 | Alpha 1 This 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 - = Subtract From Taxable " " = No Effect On Taxable |
|
| TXT-TAX-CODE3 Element: Tax Code | Alpha 10 The third tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master). |
|
| TXT-FLAG3 Element: Flag1 | Alpha 1 This 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 - = Subtract From Taxable " " = No Effect On Taxable |
|
| TXT-TAX-CODE4 Element: Tax Code | Alpha 10 The fourth tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master). |
|
| TXT-FLAG4 Element: Flag1 | Alpha 1 This 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 - = Subtract From Taxable " " = No Effect On Taxable |
|
| TXT-TAX-CODE5 Element: Tax Code | Alpha 10 The fifth tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master). |
|
| TXT-FLAG5 Element: Flag1 | Alpha 1 This 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 - = Subtract From Taxable " " = No Effect On Taxable |
|
| TXT-TAX-CODE6 Element: Tax Code | Alpha 10 The sixth tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master). |
|
| TXT-FLAG6 Element: Flag1 | Alpha 1 This 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 - = Subtract From Taxable " " = No Effect On Taxable |
|
| TXT-TAX-CODE7 Element: Tax Code | Alpha 10 The seventh tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master). |
|
| TXT-FLAG7 Element: Flag1 | Alpha 1 This 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 - = Subtract From Taxable " " = No Effect On Taxable |
|
| TXT-TAX-CODE8 Element: Tax Code | Alpha 10 The eighth tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master). |
|
| TXT-FLAG8 Element: Flag1 | Alpha 1 The taxable effect for the last tax code in the table must be blank. + = Add To Taxable - = Subtract From Taxable " " = No Effect On Taxable |
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||
|---|---|---|---|---|---|---|---|---|---|
| TXTSET1 |
TAX-TABLE EFFECT-DATE* |
|
|||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Code 1 Mast | TXCODEMAST |
Required
| |||||||||
| Code 2 Mast | TXCODEMAST |
Required
| |||||||||
| Code 3 Mast | TXCODEMAST |
Required
| |||||||||
| Code 4 Mast | TXCODEMAST |
Required
| |||||||||
| Code 5 Mast | TXCODEMAST |
Required
| |||||||||
| Code 6 Mast | TXCODEMAST |
Required
| |||||||||
| Code 7 Mast | TXCODEMAST |
Required
| |||||||||
| Code 8 Mast | TXCODEMAST |
Required
| |||||||||
| Txcodemast | TXCODEMAST |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.