The base product provides a data area C1-SEPADirectDebitPaymentInfo that contains the payment information record layout. All fields are alphanumeric.
The following table lists the fields that the C1-SDDCE extract is mapping. To see the rest of the fields, refer to the data area's schema definition.
Field Name | Description | Source / Value |
PmtInfId | Payment Information Identification | From 'Payment Information Identification' characteristic value on Obligation, where the characteristic type is defined in the SEPA Master Configuration |
PmtMtd | Payment Method | 'DD' |
PmtTpInf/SvcLvl/Cd | Service Level (Code) | ‘SEPA’ |
PmtTpInf/LclInstrm/Cd | Local Instrument (Code) | SEPA Master Configuration: generalMasterConfiguration/localInstrument (i.e. ‘CORE’) |
PmtTpInf/SeqTp | Sequence Type | Direct Debit Payment Type of the related Direct Debit Mandate. |
ReqdColltnDt | Requested Collection Date | Payment Event.Effective Date |
Cdtr/Nm | Creditor Name | SEPA Master Configuration: Derived from the Initiating Party (Person). |
Cdtr/PstlAdr | Postal Address | SEPA Master Configuration: Derived from the Initiating Party (Person). If an address exists: StrtNm is mapped to Address1, PstCd is mapped to Postal (prefixed with State code, if applicable), TwnNm is mapped to City and Ctry is mapped to Country. |
CdtrAcct/Id/IBAN | Creditor Account Identification | Bank Account.Account Number, where Bank Account is determined from the Tender Source of the Auto Pay Route Type that is associated with the C1-SDDCE extract process. |
CdtrAgt/FinInstnId/BIC | Creditor Agent BIC | Bank Account.DFI ID. where Bank Account is determine from the Tender Source of the Auto Pay Route Type that is associated with the C1-SDDCE extract process. |
CdtrSchmeId/Id/PrvtId/Othr/Id | Creditor Scheme Identification - Private Identification | SEPA Master Configuration: Derived from the Initiating Party (Person) using the Creditor ID Type specified in the master configuration. |
DrctDbtTxInf/PmtId/EndToEndId | Direct Debit Transaction: Payment Identification - End To End Identification | Payment Tender.Payment Tender ID |
DrctDbtTxInf/InstdAmt | Direct Debit Transaction: Instructed Amount | Payment Tender.Amount |
DrctDbtTxInf/DrctDbtTx/MndtRltdInf/MndtId | Direct Debit Transaction: Mandate Identification | External Mandate Reference from the active Direct Debit Mandate of the account on the tender. |
DrctDbtTxInf/DrctDbtTx/MndtRltdInf/DtOfSgntr | Direct Debit Transaction: Date of Signature | Effective Date from the active Direct Debit Mandate of the account on the tender. |
DrctDbtTxInf/DrctDbtTx/MndtRltdInf/ElctrncSgntr | Direct Debit Transaction: Electronic Signature | From the active Direct Debit Mandate of the account on the tender. |
DrctDbtTxInf/DrctDbtTx/CdtrSchmeId/Id/PrvtId/Othr/Id | Direct Debit Transaction: Creditor Scheme Identification - Private Identification | SEPA Master Configuration: Derived from the Initiating Party (Person) using the Creditor ID Type specified in the master configuration. |
DrctDbtTxInf/DbtrAgt/FinInstnId/BIC | Direct Debit Transaction: Debtor Agent's BIC | From the active Direct Debit Mandate of the account on the tender. |
DrctDbtTxInf/Dbtr/Nm | Direct Debit Transaction: Debtor Name | From the active Direct Debit Mandate of the account on the tender. |
DrctDbtTxInf/DbtrAcct/Id/IBAN | Direct Debit Transaction: Debtor Account | From the active Direct Debit Mandate of the account on the tender. |
Copyright © 2007, 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.5.2016 10:21:45 [T1_1454696505000]