ZF2INVTP - Detailed information on payment terms
Column name | In use? | Status | Column definition | Column description | Technical term | Example |
|---|---|---|---|---|---|---|
| TPKEY | x | VARCHAR(15) | Internal pagination number | Internal invoice number (i-effect column) | ||
| TPLFD | x | DECIMAL(5, 0) | Order of Payment Term | Order of payment terms | ||
| TPTEXT | x | optional | VARCHAR(255) | Description of Payment Term | Terms of payment | |
| TPPAMD | x | optional | DATE '0001-01-01' | Due Date | due date of payment | 2018-12-24 |
| TPPAPMID | x | optional | VARCHAR(15) | mandate reference | Identification of the mandate reference | |
| TPPAPAHA | DECIMAL(15, 2) | Amount of instalment | Amount of the partial payment | |||
| Detailed information on payment surcharges (optional) (EXTENDED only) | ||||||
| TPPAPTD | DATE '0001-01-01' | Refernce Date of maturity | Reference date of maturity | 2018-12-18 | ||
| TPPAPTMP | INTEGER | Maturity period | Due date | 10 | ||
| TPPAPTMPU | VARCHAR(10) | Maturity period, (Unit) | Maturity period, unit | DAY | ||
| TPPAPTBA | DECIMAL(15, 2) | Basic amount of Payment surcharge | Base amount of the payment surcharge | 102.10 | ||
| TPPAPTPV | DECIMAL(6, 2) | Percentage of payment surcharge | Percentage value of the payment surcharge | 19.00 | ||
| TPPAPTAPM | DECIMAL(15, 2) | Amount of Payment surcharge | Amount of the payment surcharge | 45.00 | ||
| Detailed information on payment discounts (optional) (EXTENDED only) | ||||||
| TPPADTD | DATE '0001-01-01' | Refernce Date of maturity | Reference date of maturity | 2018-12-14 | ||
| TPPADTMP | INTEGER | Maturity period | Due date | 5 | ||
| TPPADTMPU | VARCHAR(10) | Maturity period, (Unit) | Maturity period, unit | DAY | ||
| TPPADTBA | DECIMAL(15, 2) | Base amount of the payment discount | Base amount of the payment discount | 100.00 | ||
| TPPADTPV | DECIMAL(6, 2) | Percentage of payment discount | Percentage value of the payment budget billing amount | 7.00 | ||
| TPPADTAPM | DECIMAL(15, 2) | Amount of Payment discount | Amount of the payment instalment | 21.00 | ||