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 |
Item - discounts 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 | optional | CHAR(5) | Switch for Sur/deduction | Switch for increase/decrease | |
| ACTACS | CHAR(1) | Calculation Order | Calculation sequence | |||
| ACTACP | x | optional | DECIMAL(6, 2) | Discount Percentage | Percentage surcharge/discount at invoice item level | |
| ACTACBAD | x | optional | 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 | Amount of the surcharge/discount at invoice item level | |
| ACTACRC | x | optional | VARCHAR(5) | Reason of Sur/deduction(Code) | Code for the reason for the surcharge/discount at invoice item level | |
| ACTACRF | x | optional | 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 |
Position - discounts on the level of the gross price of the item (detailed information on surcharges and discounts)
Column name | 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 | 2 = Surcharge/discount on gross price level of the article | |
| ACLFD | x | DECIMAL(5, 0) | Order of the Sur/decution | Order of surcharges and discounts (i-effect column) | ||
| ACTACI | x | optional | 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 or discount | |||
| ACTACBAD | DECIMAL(15, 4) | Basic amount of discount | Basic amount of the surcharge or discount | |||
| 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 | Discount on the article price | |
| ACTACRC | VARCHAR(5) | Reason of Sur/deduction(Code) | Code for the reason for the increase or reduction | |||
| ACTACRF | VARCHAR(200) | Reason of Sur/deduction(Free text) | Reason for the surcharge or discount at document level Reason for the surcharge/deduction (free text) | |||
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 |