| 2.1 PaymentInformationIdentification
| |
| Node "Document/CstmrCdtTrfInitn/PmtInf/PmtInfId" |
TEXT ( 'Sequence_number:_Payment_format' ) |
| 2.2 PaymentMethod
| |
| Node "Document/CstmrCdtTrfInitn/PmtInf/PmtMtd" |
"TRF" |
| 2.9 ServiceLevel Code |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/PmtTpInf/SvcLvl/Cd" |
"SEPA" |
| 2.17 RequestedExecutionDate |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/ReqdExctnDt" |
IF ( 'Posting_date' > CURRENT (DATE) , 'Posting_date' , CURRENT (DATE) ) |
| 2.19 Debtor Name |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/Dbtr/Nm" |
REMOVEDIACRITICS ( DBQUERY (RETURN-FIELD = admdat.adm-name, adm-nr = 'Company' ) ) |
| 2.20 DebtorAccount Identification |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/DbtrAcct/Id/IBAN" |
'Bank_account_(Journal)' |
| 2.21 DebtorAgent FinancialInstitutionIdentification |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/DbtrAgt/FinInstnld/BIC" |
DBQUERY ( RETURN-FIELD = bnkacc.swift-address, adm-nr = 'Company', bank-acc-nr = 'Bank_account_(Journal)' , curr-code = 'Currency_(Journal)' ) |
| 2.24 ChargeBearer |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/ChrgBr" |
"SLEV" |
| 2.28 PaymentIdentification InstructionIdentification |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/PmtId/InstrId" |
TEXT ( 'Company' ) + "-" + TEXT ('Payment:_Run_number' ) + "-" + TEXT ( 'Order_number:_Payment' ) + "-" + TEXT ( 'Debtor_/_Creditor' ) |
| 2.28 PaymentIdentification EndToEndIdentification |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/PmtId/EndToEndId" |
TEXT ( 'Company' ) + "-" + TEXT ('Payment:_Run_number' ) + "-" + TEXT ( 'Order_number:_Payment' ) + "-" + TEXT ( 'Debtor_/_Creditor' ) |
| 2.42 Amount InstructedAmount |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/Amt/InstdAmt/" |
'Amount_FC_(Total)' |
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/Amt/InstdAmt/Ccy" |
'Currency' |
| 2.77 CreditorAgent FinancialInstitutionIdentification |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/CdtrAgt/FinInstnId/BIC" |
DBQUERY ( RETURN-FIELD = bnkacc.swift-address, adm-nr = 'Company', bank-acc-nr = 'Bank_account' , curr-code = 'Currency_(Bank)' ) |
| 2.79 Creditor Name |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/Cdtr/Nm" |
REMOVEDIACRITICS ( 'Name' ) |
| 2.80 CreditorAccount Identification |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/CdtrAcct/Id/IBAN" |
'Bank_account' |
| 2.98 RemittanceInformation Unstructured |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/RmtInf/Ustrd" |
LEFT ( REMOVEDIACRITICS ( 'Description' ) , 140 ) |
| 2.28 PaymentIdentification InstructionIdentification |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/PmtId/InstrId" |
TEXT ( 'Order_number:_Payment' ) + "-" + TEXT ( 'Debtor_/_Creditor' ) + "-B" |
| 2.28 PaymentIdentification EndToEndIdentification |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/PmtId/EndToEndId" |
TEXT ( 'Order_number:_Payment' ) + "-" + TEXT ( 'Debtor_/_Creditor' ) + "-B" |
| 2.42 Amount InstructedAmount |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/Amt/InstdAmt/" |
'Amount_blocked_bank_account_FC_(Total)' |
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/Amt/InstdAmt/Ccy" |
'Currency' |
| 2.77 CreditorAgent FinancialInstitutionIdentification |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/CdtrAgt/FinInstnId/BIC" |
DBQUERY ( RETURN-FIELD = bnkacc.swift-address, adm-nr = 'Company', bank-acc-nr = 'Bank_account_(Blocked)' , curr-code = 'Currency_(Blocked)' ) |
| 2.79 Creditor Name |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/Cdtr/Nm" |
REMOVEDIACRITICS ( 'Name' ) |
| 2.80 CreditorAccount Identification |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/CdtrAcct/Id/IBAN" |
'Bank_account_(Blocked)' |
| 2.98 RemittanceInformation Unstructured |
|
| Node "Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/RmtInf/Ustrd" |
LEFT ( REMOVEDIACRITICS ( 'Description' ) , 140 ) |