ZF23INVAC - Detailed information on surcharges and discounts
This database table consists of the following fields
Column name | Status | Column definition | Technical term | Description |
|---|---|---|---|---|
ACKEY | required | VARCHAR(15) | Reference ID head | Reference to ZF23INVHT.HTKEY |
ACREF | required | INTEGER(4, 0) | Reference ID line item | Reference to the Head (“0”) or reference to ZF23INVPI.PILFD |
ACTYPE | required | CHAR(1) | Type of Allowance Charge | 0 = Document level 1 = Line level 2 = Gross price level |
ACLFD | required | DECIMAL(5, 0) | Order of the Sur/decution | Sequence of records within ACKEY, ACREF |
ACTACI | required | CHAR(5) | Indicator for allowance | |
ACTACS | optional | CHAR(1) | Calculation Order | Calculation sequence |
ACTACP | optional | DECIMAL(6, 2) | Document level allowance percentage | The percentage that may be used, in conjunction with the document level allowance base amount, to calculate the document level allowance amount. |
ACTACBAD | optional | DECIMAL(15, 4) | Document level allowance base amount | The base amount that may be used, in conjunction with the document level allowance percentage, to calculate the document level allowance amount. |
ACTACBQ | optional | DECIMAL(15, 4) | Base quantity of discount | |
ACTTEACBPU | required wenn ACTACBQ gefüllt ist. | VARCHAR(10) | UNIT pricing Base | |
ACTACBA | required | DECIMAL(15, 2) | Document level allowance amount | The amount of an allowance, without VAT. |
ACTACRC | optional | CHAR(5) | Document level allowance reason code | The reason for the document level allowance, expressed as a code. |
ACTACRF | optional | VARCHAR(200) | Document level allowance reason | The reason for the document level allowance, expressed as text. |
ACTAXT | required | CHAR(5) | Type of tax (code) | |
ACTAXCAT | required | CHAR(2) | Document level allowance VAT category code | A coded identification of what VAT category applies to the document level allowance. |
ACTAXPER | optional | DECIMAL(6, 2) | Document level allowance VAT rate | The VAT rate, represented as percentage that applies to the document level allowance. |