ZF2INVAC - Detailed information on markups and markdowns
Header - surcharges and discounts at document level
Column name | In use? | Status | Column definition | Column description | Technical term | Example |
|---|---|---|---|---|---|---|
| ACKEY | x | VARCHAR(15) | Internal pagination number | Internal invoice number (i-effect column) | ||
| ACREF | x | DECIMAL(5, 0) | Reference ID to the Specified Table | Reference to the tables (i-effect column) | 0 = Header level | |
| ACTYPE | x | CHAR(1) | Type of Allowance Charge | Type of surcharge/discount | 0 = Surcharge/discount at header level | |
| ACLFD | x | DECIMAL(5, 0) | Order of the Sur/decution | Order of surcharges and discounts (i-effect column) | ||
| ACTACI | x | required | CHAR(5) | Switch for Sur/deduction | Switch for increase/decrease | |
| ACTACS | x | optional | CHAR(1) | Calculation Order | Calculation sequence | |
| ACTACP | x | optional | DECIMAL(6, 2) | Discount Percentage | Percentage surcharge or discount at document level | |
| ACTACBAD | x | optional | DECIMAL(15, 4) | Basic amount of discount | Basic amount of the surcharge or discount at document level | |
| ACTACBQ | DECIMAL(15, 4) | Base quantity of discount | Base quantity of the discount | |||
| ACTTEACBPU | VARCHAR(10) | UNIT pricing Base | Unit of the price base quantity | |||
| ACTACBA | x | required | DECIMAL(15, 2) | Amount of Sur/deduction | amount of the surcharge or discount at document level | |
| ACTACRC | x | optional | CHAR(5) | Reason of Sur/deduction(Code) | Code for the reason for the surcharge or discount at document level | |
| ACTACRF | x | optional | VARCHAR(200) | Reason of Sur/deduction(Free text) | Reason for the surcharge or discount at document level | |
ACTAXT | x | required | CHAR(5) | Type of Tax | Code for the VAT category of the surcharge or deduction at document level | |
ACTAXCAT | x | required | CHAR(2) | Tax category | Code for the VAT category of the surcharge or deduction at document level | |
ACTAXPER | x | optional | DECIMAL(6, 2) | Tax rate | VAT rate for the surcharge or discount at document level |
Items - deductions at invoice item level
Column name | In use? | Status | Column definition | Column description | Technical term | Example |
|---|---|---|---|---|---|---|
| ACKEY | x | VARCHAR(15) | Internal pagination number | Internal invoice number (i-effect column) | ||
| ACREF | x | DECIMAL(5, 0 | Reference ID to the Specified Table | Reference to the tables (i-effect column) ZFINVOICPI (PIREF) | ||
| ACTYPE | x | CHAR(1) | Type of Allowance Charge | Type of surcharge/discount | 1 = Addition/deduction at item level | |
| ACLFD | x | DECIMAL(5, 0) | Order of the Sur/decution | Order of surcharges and discounts (i-effect column) | ||
| ACTACI | x | required | CHAR(5) | Switch for Sur/deduction | Switch for increase/decrease | |
| ACTACS | CHAR(1) | Calculation Order | Calculation sequence | |||
| ACTACP | DECIMAL(6, 2) | Discount Percentage | Percentage surcharge/discount at invoice item level | |||
| ACTACBAD | DECIMAL(15, 4) | Basic amount of discount | Basic amount of the surcharge/discount at invoice item level | |||
| ACTACBQ | DECIMAL(15, 4) | Base quantity of discount | Base quantity of the discount | |||
| ACTTEACBPU | VARCHAR(10) | UNIT pricing Base | Unit of the price base quantity | |||
| ACTACBA | x | required | DECIMAL(15, 2) | Amount of Sur/deduction | Betrag des Zu-/Abschlags auf Ebene der Rechnungsposition | |
| ACTACRC | VARCHAR(5) | Reason of Sur/deduction(Code) | Code for the reason for the surcharge/discount at invoice item level | |||
| ACTACRF | VARCHAR(200) | Reason of Sur/deduction(Free text) | Reason for the surcharge/discount at invoice item level | |||
ACTAXT | CHAR(5) | Type of Tax | Code for the VAT category of the surcharge or deduction at document level | |||
ACTAXCAT | CHAR(2) | Tax category | Code for the VAT category of the surcharge or deduction at document level | |||
ACTAXPER | DECIMAL(6, 2) | Tax rate | VAT rate for the surcharge or discount at document level |