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. |
|
PTBUYFAN |
optional |
VARCHAR(128) |
Name of the debited account |
Account name of the account to be debited (SEPA direct debit). Available from ZUGFeRD 2.5 (EXTENDED profile, i-effect 3.1.18). |
|
PTDACSPID |
optional |
VARCHAR(128) |
Debited account service provider name |
Name of the financial institution servicing the account to be debited. Available from ZUGFeRD 2.5 (EXTENDED profile, i-effect 3.1.18). |
|
PTDACSPBIC |
optional |
VARCHAR(128) |
Debited account service provider ID |
Identifier (e.g. BIC) of the financial institution servicing the account to be debited. Available from ZUGFeRD 2.5 (EXTENDED profile, i-effect 3.1.18). |
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 |
Info |
|---|---|---|---|---|
|
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 |
|
|
|
PTBUYFAN |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans/ram:PayerPartyDebtorFinancialAccount/ram:AccountName |
BT-216 |
The name of the payment account, at a payment service provider, from which payment should be made |
from ZUGFeRD 2.5 (EXTENDED) |
|
PTDACSPID |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans/ram:PayerSpecifiedDebtorFinancialInstitution |
BT-215-00 |
An identifier for the payment service provider where a payment account is located |
from ZUGFeRD 2.5 (EXTENDED) |
|
PTDACSPBIC |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeSettlementPaymentMeans/ram:PayerSpecifiedDebtorFinancialInstitution/ram:BICID |
BT-215 |
Such as a BIC or a national clearing code where required. No identification scheme to be used |
from ZUGFeRD 2.5 (EXTENDED) |