ZF23INVTP - Detailed information on payment terms
This database table consists of the following fields
Column Name | Status | Column definition | Technical term | Description |
|---|---|---|---|---|
TPKEY | required | VARCHAR(15) | Reference to ZF23INVHT.HTKEY | Unique auto generated identifier |
TPLFD | required | DECIMAL(5, 0) | Order of Payment Term | Order of payment terms |
TPTEXT | optional | VARCHAR(2048) | Payment terms | A textual description of the payment terms that apply to the amount due for payment (Including description of possible penalties). |
TPPAMD | optional | DATE '0001-01-01' | Payment due date | The date when the payment is due. |
TPPAPMID | optional | VARCHAR(1000) | DIRECT DEBIT | A group of business terms to specify a direct debit. |
Mandate reference identifier | Unique identifier assigned by the Payee for referencing the direct debit mandate. | |||
TPPAPAHA | optional | DECIMAL(15, 2) | Partial payment amount | |
TPPAPTD | optional | DATE '0001-01-01' | Maturity Reference Date, value | |
TPPAPTMP | optional | INTEGER(4, 0) | Due date period basis | The period for the due date, e.g. as a number of days (15 days) |
TPPAPTMPU | required wenn TPPAPTMP gefüllt ist. | VARCHAR(15) | Maturity Period, Unit code | |
TPPAPTBA | optional | DECIMAL(15, 2) | Payment penalty base amount | |
TPPAPTPV | optional | DECIMAL(6, 2) | Payment penalty percentage | |
TPPAPTAPM | optional | DECIMAL(15, 2) | Payment penalty amount | |
TPPADTD | optional | DATE '0001-01-01' | Maturity Reference Date, value | |
TPPADTMP | optional | INTEGER(4, 0) | Due date period basis | The period for the due date, e.g. as a number of days (15 days) |
TPPADTMPU | optional | VARCHAR(10) | Maturity Period, Unit code | |
TPPADTBA | optional | DECIMAL(15, 2) | Payment discount base amount | |
TPPADTPV | optional | DECIMAL(6, 2) | Payment discount percentage | |
TPPADTAPM | optional | DECIMAL(15, 2) | Payment discount amount |
The following list contains the business rule numbers corresponding to the fields, the XML target elements and further explanations.
Column name | XML Element | EN16931-ID | Example |
|---|---|---|---|
TPTEXT | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:Description | BT-20 | This element may contain multiple lines and multiple terms. |
TPPAMD | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:DueDateDateTime/udt:DateTimeString | BT-9 | The payment due date reflects the due date of the net payment. For partial payments it states the first net due date. The corresponding description of more complex payment terms can be stated in BT-20 Payment terms. |
TPPAPMID | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement | BG-19 | This group may be used to give prior notice in the invoice that payment will be made through a SEPA or other direct debit initiated by the Seller, in accordance with the rules of the SEPA or other direct debit scheme. |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:DirectDebitMandateID | BT-89 | Used in order to pre-notify the Buyer of a SEPA direct debit. | |
TPPAPAHA | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:PartialPaymentAmount | BT-X-275 | |
TPPAPTD | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:ApplicableTradePaymentPenaltyTerms/ram:BasisDateTime/udt:DateTimeString | BT-X-276 | |
TPPAPTMP | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:ApplicableTradePaymentPenaltyTerms/ram:BasisPeriodMeasure | BT-X-277 | |
TPPAPTMPU | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:ApplicableTradePaymentPenaltyTerms/ram:BasisPeriodMeasure/@unitCode | BT-X-278 | |
TPPAPTBA | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:ApplicableTradePaymentPenaltyTerms/ram:BasisAmount | BT-X-279 | |
TPPAPTPV | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:ApplicableTradePaymentPenaltyTerms/ram:CalculationPercent | BT-X-280 | |
TPPAPTAPM | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:ApplicableTradePaymentPenaltyTerms/ram:ActualPenaltyAmount | BT-X-281 | |
TPPADTD | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:ApplicableTradePaymentDiscountTerms/ram:BasisDateTime/udt:DateTimeString | BT-X-282 | |
TPPADTMP | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:ApplicableTradePaymentDiscountTerms/ram:BasisPeriodMeasure | BT-X-283 | |
TPPADTMPU | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:ApplicableTradePaymentDiscountTerms/ram:BasisPeriodMeasure/@unitCode | BT-X-284 | |
TPPADTBA | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:ApplicableTradePaymentDiscountTerms/ram:BasisAmount | BT-X-285 | |
TPPADTPV | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:ApplicableTradePaymentDiscountTerms/ram:CalculationPercent | BT-X-286 | |
TPPADTAPM | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradePaymentTerms/ram:ApplicableTradePaymentDiscountTerms/ram:ActualDiscountAmount | BT-X-287 |