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		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) ()
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) ()
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

×