|
Column name |
Status |
Column definition |
Technical term |
Column description |
XML Element |
EN16931-ID |
Example |
|---|---|---|---|---|---|---|---|
|
TPKEY |
required |
VARCHAR(15) |
Internal pagination number |
Internal invoice number (i-effect column) |
|
|
|
|
TPLFD |
required |
DECIMAL(5, 0) |
Order of Payment Term |
Order of payment terms |
|
|
|
|
TPTEXT |
optional |
VARCHAR(255) |
Description of Payment Term |
Terms of payment |
Description |
BT-20 |
|
|
TPPAMD |
optional |
DATE '0001-01-01' |
Due Date |
Due date of payment |
DueDateDateTime |
BT-9 |
24.12.2018 |
|
TPPAPMID |
optional |
VARCHAR(15) |
mandate reference |
Identification of the mandate reference |
DirectDebitMandateID |
BG-19, BT-89 |
|
|
TPPAPAHA |
optional |
DECIMAL(15, 2) |
Amount of instalment |
Amount of the instalment |
PartialPaymentAmount |
|
|
|
TPPAPTD |
optional |
DATE '0001-01-01' |
Refernce Date of maturity |
Reference date of maturity |
BasisDateTime |
|
18.12.2018 |
|
TPPAPTMP |
optional |
INTEGER |
Maturity period |
Due date period |
BasisPeriodMeasure |
|
10 |
|
TPPAPTMPU |
Required if TPPAPTMP is filled. |
VARCHAR(10) |
Maturity period, (Unit) |
Due date period, unit |
unitCode |
|
DAY |
|
TPPAPTBA |
optional |
DECIMAL(15, 2) |
Basic amount of Payment surcharge |
Basic amount of the payment surcharge |
BasisAmount |
|
102.10 |
|
TPPAPTPV |
optional |
DECIMAL(6, 2) |
Percentage of payment surcharge |
Percentage value of the payment surcharge |
CalculationPercent |
|
19.00 |
|
TPPAPTAPM |
optional |
DECIMAL(15, 2) |
Amount of Payment surcharge |
Amount of the payment surcharge |
ActualPenaltyAmount |
|
45.00 |
|
TPPADTD |
|
DATE |
|
|
|
|
|
|
TPPADTMP |
|
INTEGER |
|
|
|
|
|
|
TPPADTMPU |
|
VARCHAR(10) |
|
|
|
|
|
|
TPPADTBA |
|
DECIMAL(15,2) |
|
|
|
|
|
|
TPPADTPV |
|
DECIMAL(6,2) |
|
|
|
|
|
|
TPPADTAPM |
|
DECIMAL(15,2) |
|
|
|
|
|