| 2.1 PaymentInformationIdentification
| |
| Node "Document/CstmrDrctDbtInitn/PmtInf/PmtInfId" |
TEXT ( 'Company' ) + "-" + TEXT ( 'Collection:_Run_number' ) + "-" + TEXT ( 'Direct_debit_type' ) |
| 2.2 PaymentMethod
| |
| Node "Document/CstmrDrctDbtInitn/PmtInf/PmtMtd" |
"DD" |
| 2.3 BathhBooking |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/BtchBookg" |
TRUE |
| 2.9 ServiceLevel Code |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/PmtTpInf/SvcLvl/Cd" |
"SEPA" |
| 2.12 LocalInstrument Code |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/PmtTpInf/LclInstrm/Cd" |
HEADER ('SEPA:_Schema') |
| 2.14 SequenceType |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/PmtTpInf/SeqTp" |
CASE ( 'Direct_debit_type', 207801, "FRST", 207802, "RCUR", 207803, "FNAL", 207804, "OOFF", "" ) |
| 2.18 RequestedCollectionDate |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/ReqdColltnDt" |
'Process_date' |
| 2.19 Creditor Name |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/Cdtr/Nm" |
REMOVEDIACRITICS ( DBQUERY (RETURN-FIELD = admdat.adm-name, adm-nr = 'Company' ) ) |
| 2.20 CreditorAccount Identification |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/CdtrAcct/Id/IBAN" |
DBQUERY ( RETURN-FIELD = journl.bank_acc_nr, adm_nr = 'Company', journal_nr = 'Journal_number' ) |
| 2.21 CreditorAgent FinancialInstitutionIdentification |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/CdtrAgt/FinInstnId/BIC" |
DBQUERY ( RETURN-FIELD = bnkacc.swift-address, adm-nr = 'Company', bank-acc-nr = DBQUERY ( RETURN-FIELD = journl.bank_acc_nr, adm_nr = 'Company', journal_nr = 'Journal_number' ) , curr-code = "EUR" ) |
| 2.24 ChargeBearer |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/ChrgBr" |
"SLEV" |
| 2.27 CreditorSchemaIdentification Identification |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/CdtrSchmeId/Id/PrvtId/Othr/Id" |
'Enterprise_ID' |
| Node "Document/CstmrDrctDbtInitn/PmtInf/CdtrSchmeId/Id/PrvtId/Othr/SchmeNm/Prtry" |
"SEPA" |
| 2.28 DirectDebitTransactionInformation |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf" |
'Collection:_Type' <> 204203 |
| 2.31 PaymentIdentification EndToEndIdentification |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/PmtId/EndToEndId" |
TEXT ( 'Collection:_Run_number' ) + "-" + TEXT ( 'Debtor' ) + "-" + TEXT ( 'Invoice_number' ) |
| 2.44 InstructedAmount |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/InstdAmt" |
'Amount:_DC' |
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/InstdAmt/Ccy" |
"EUR" |
| 2.45 Chargebearer |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/ChrgBr" |
"SLEV" |
| 2.48 MandateIdentification |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/DrctDbtTx/MndtRltdInf/MndtId" |
'Mandate_reference' |
| 2.49 DateOfSignature |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/DrctDbtTx/MndtRltdInf/DtOfSgntr" |
'Date:_Signature' |
| 2.50 AmendmentIndicator |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/DrctDbtTx/MndtRltdInf/AmdmntInd" |
IF ( OR ( 'Mandate_reference_(Original)' > "" , 'Bank_account_(Original)' > "" ) , TRUE , FALSE ) |
| 2.51 AmendmentInformationDetails |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/DrctDbtTx/MndtRltdInf/AmdmntInfDtls" |
OR ( 'Mandate_reference_(Original)' > "" , 'Bank_account_(Original)' > "") |
| 2.52 OriginalMandateIdentification |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/DrctDbtTx/MndtRltdInf/AmdmntInfDtls/OrgnlMndtId" |
'Mandate_reference_(Original)' |
| 2.53 OriginalCreditorSchemaIdentification |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/DrctDbtTx/MndtRltdInf/AmdmntInfDtls/OrgnlCdtrSchmeId/Id/PrvtId/Othr/Id" |
'Direct_debit_type' = 207801 ; 'Mandate_reference_(Original)' |
| 2.57 OriginalDebtorAccount Identification |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/DrctDbtTx/MndtRltdInf/AmdmntInfDtls/OrgnlDbtrAcct/Id/IBAN" |
'Bank_account_(Original)' |
| 2.70 DebtorAgent FinancialInstitutionIdentification |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/DbtrAgt/FinInstnId/BIC" |
DBQUERY ( RETURN-FIELD = bnkacc.swift-address, adm-nr = 'Administratie', bank-acc-nr = DBQUERY (RETURN-FIELD = debtor.bank-acc-nr, adm-nr = 'Administratie' , debtor = 'Debiteur' ) , curr-code = 'Valuta' ) |
| 2.72 Debtor Name |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/Dbtr/Nm" |
MID ( REMOVEDIACRITICS ( DBQUERY (RETURN-FIELD = debtor.name, adm-nr = 'Administratie' , debtor = 'Debiteur' ) ) , 1 , 70) |
| 2.73 DebtorAccount Identification |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/DbtrAcct/Id/IBAN" |
DBQUERY (RETURN-FIELD = debtor.bank-acc-nr, adm-nr = 'Company' , debtor = 'Debtor' ) |
| 2.88 RemittanceInformation Unstructured |
|
| Node "Document/CstmrDrctDbtInitn/PmtInf/DrctDbtTxInf/RmtInf/Ustrd" |
'Description' + "-" + 'BGC_description_1' + "-" + 'BGC_description_2' + "-" + 'BGC_description_3' |