ZF23INVPT - Payment orders
This database table consists of the following fields
Column Name | Status | Column definition | Technical term | Description |
|---|---|---|---|---|
PTKEY | required | VARCHAR(15) | Reference to ZF23INVHT.HTKEY | Unique auto generated identifier |
PTLFD | required | DECIMAL(5, 0) | Sequence |
|
PTPAYTYP | required | CHAR(5) | Payment means type code | The means, expressed as code, for how a payment is expected to be or has been settled. |
PTPAYINF | optional | VARCHAR(75) | Payment means text | The means, expressed as text, for how a payment is expected to be or has been settled. |
PTATSPMID | required | INTEGER(4, 0) | Payment card primary account number | The Primary Account Number (PAN) of the card used for payment. |
PTATSPMCH | optional | VARCHAR(1000) | Payment card holder name | The name of the payment card holder. |
PTBUYIBAN | required | VARCHAR(45) | DIRECT DEBIT | A group of business terms to specify a direct debit. |
Debited account identifier | The account to be debited by the direct debit. | |||
PTCREIBAN | optional | VARCHAR(45) | Payment account identifier | A unique identifier of the financial payment account, at a payment service provider, to which payment should be made. |
PTCREFAN | optional | VARCHAR(75) | Payment account name | The name of the payment account, at a payment service provider, to which payment should be made. |
PTCREFANR | optional | VARCHAR(25) | National account number (not SEPA) | |
PTSELBBIC | required | VARCHAR(15) | Payment service provider identifier | An identifier for the payment service provider where a payment account is located. |
PTNETWID | optional | VARCHAR(50) | Payment card primary account number | The Primary Account Number (PAN) of the card used for payment. In accordance with card payments security standards, an invoice should never include a full card primary account number. |
PTPAPMID | optional | VARCHAR(50) | Unique identifier | Unique identifier assigned by the Payee for referencing the direct debit mandate. Used in order to pre-notify the Buyer of a SEPA direct debit. |
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 |
|---|---|---|---|
PTPAYTYP | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans/ram:TypeCode | BT-81 | Entries from the UNTDID 4461 code list [6] shall be used. Distinction should be made |
PTPAYINF | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans/ram:Information | BT-82 | Such as cash, credit transfer, direct debit, credit card, etc. |
PTATSPMID | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans/ram:ApplicableTradeSettlementFinancialCard/ram:ID | BT-87 | In accordance with card payments security standards an invoice should never include a full card primary account number. At the moment PCI Security Standards Council has defined following: The first 6 digits and last 4 digits are the maximum number of digits to be shown. |
PTATSPMCH | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans/ram:ApplicableTradeSettlementFinancialCard/ram:CardholderName | BT-88 | |
PTBUYIBAN | /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:SpecifiedTradeSettlementPaymentMeans/ram:PayerPartyDebtorFinancialAccount/ram:IBANID | BT-91 | ||
PTCREIBAN | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans/ram:PayeePartyCreditorFinancialAccount/ram:IBANID | BT-84 | Such as IBAN (in case of SEPA payment) or a national account number. |
PTCREFAN | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans/ram:PayeePartyCreditorFinancialAccount/ram:AccountName | BT-85 | |
PTCREFANR | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans/ram:PayeePartyCreditorFinancialAccount/ram:ProprietaryID | BT-84-0 | Use IBANID when appropriate, otherwise use ProprietaryID |
PTSELBBIC | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans/ram:PayeeSpecifiedCreditorFinancialInstitution/ram:BICID | BT-86 | Such as a BIC or a national clearing code where required. No identification scheme to be used. |
PTNETWID | Invoice;cac:PaymentMeans;cac:CardAccount;cbc:NetworkID | BG-18 | |
PTPAPMID | Invoice;cac:PaymentMeans;cac:PaymentMandate;cbc:ID | BT-89 |