Diese Datenbanktabelle besteht aus den folgenden Feldern
|
Spaltenname |
Status |
Spaltendefinition |
Fachbegriff |
Beschreibung |
|---|---|---|---|---|
|
TPKEY |
required |
VARCHAR(15) |
Reference to ZF23INVHT.HTKEY |
Unique auto generated identifier |
|
TPLFD |
required |
DECIMAL(5, 0) |
Order of Payment Term |
Reihenfolge der Zahlungsbedingungen |
|
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 |
|
In der folgenden Auflistung können die zu den Feldern passenden Geschäftsregelnummern, die XML Zielelemente und weitere Erläuterungen entnommen werden
|
Spaltenname |
XML Element |
EN16931-ID |
Beispiel |
|---|---|---|---|
|
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 |
|