399
edits
Changes
From All n One's bxp software Wixi
→SEPA Import Form Required Fields
3) Store a copy of the SEPA file generated in the header form record, once here this copy cannot be modified/deleted (optional action)
Reference Document -- [[Media:SEPA_008_LayoutDocument.pdf]]
=== Example Rule ===
<syntaxhighlight lang="java">
SEPAFileGeneration
== SEPA Pain 002 Import==
In order to import a SEPA Pain 002 file bxp needs one forms, one to store all of the transaction information as wee as the group header information. The form must contain the fields mentioned below. Once the '''MetaData Input''' Rule has been set up correctly, bxp will go through .xml files in the specified location and take all group header information and refused transaction information and store them in the form. Please note that there will be one record in the form for every refused transaction. After a success full process bxp will perform the following options: 1) Store a CCL of the refusal record creation for each record created 2) Update the Refusal Reason to include the English Reason i.e. convert the refusal code 3) Store a CCL of the SEPA file that was processed for each record created (optional action - but highly recommended) 4) Delete the original file from the specified location (optional action - but highly recommended) Reference Document -- [[Media:SEPA_002_LayoutDocument.pdf]] === Transaction SEPA Import Form Required Fields ===
{| class="wikitable"
|-
! BOI XML Reference
! Information
! XML Data Path
|-
| 1
| 1.1| Message Identification
| GrpHdr > MsgId
|-
| 2
| 1.2| Creation Date Time
| GrpHdr > CreDtTm
|-
| 3
| 1.6| BIC
| GrpHdr > CdtrAgt > FinInstnId > BIC
|-
| 4
| 2.1| Original Message Identification
| OrgnlGrpInfAndSts > OrgnlMsgId
|-
| 5
| 2.2| Original Message Name Identification
| OrgnlGrpInfAndSts > OrgnlMsgNmId
|-
| 6
| 2.4| Original Number of Transactions
| OrgnlGrpInfAndSts > OrgnlNbOfTxs
|-
| 7
| 2.5| Original Control Sum
| OrgnlGrpInfAndSts > OrgnlCtrlSum
|-
| 8
| 3.1| Original Payment Information Identification
| OrgnlPmtInfAndSts > OrgnlPmtInfId
|-
| 9
| 3.2| Original Number Of Transactions
| OrgnlPmtInfAndSts > OrgnlNbOfTxs
|-
| 10
| 3.3| Original Control Sum
| OrgnlPmtInfAndSts > OrgnlCtrlSum
|-
| 11
| 3.16| Status Identification
| TxInfAndSts > StsId
|-
| 12
| 3.17| Original Instruction Identification
| TxInfAndSts > OrgnlInstrId
|-
| 13
| 3.18| Original End To End Identification
| TxInfAndSts > OrgnlEndToEndId
|-
| 14
| 3.19| Transaction Status
| TxInfAndSts > TxSts
|-
| 15
| 3.21| BIC Or BEI
| TxInfAndSts > StsRsnInf > Orgtr > Id > OrgId > BICOrBEI
|-
| 16
| 3.23| Code
| TxInfAndSts > StsRsnInf > Rsn > Cd
|-
| 17
| 3.35| Instructed Amount
| TxInfAndSts > OrgnlTxRef > Amt > InstdAmt
|-
| 18
| 3.40| Requested Collection Date
| TxInfAndSts > OrgnlTxRef > ReqdColltnDt
|-
| 19
| 3.42| Identification
| TxInfAndSts > OrgnlTxRef > CdtrSchmeId > Id > PrvtId > Othr > Id
|-
| 20
| 3.42| Proprietary
| TxInfAndSts > OrgnlTxRef > CdtrSchmeId > Id > PrvtId > Othr > SchmeNm > Prtry
|-
| 21
| 3.59| Code
| TxInfAndSts > OrgnlTxRef > PmtTpInf > SvcLvl > Cd
|-
| 22
| 3.62| Code
| TxInfAndSts > OrgnlTxRef > PmtTpInf > LclInstrm > Cd
|-
| 23
| 3.64| SequenceType
| TxInfAndSts > OrgnlTxRef > PmtTpInf > SeqTp
|-
| 24
| 3.67| Proprietary
| TxInfAndSts > OrgnlTxRef > PmtTpInf > CtgyPurp > Prtry
|-
| 25
| 3.70| Mandate Identification
| TxInfAndSts > OrgnlTxRef > MndtRltdInf > MndtId
|-
| 26
| 3.71| Date of Signature
| TxInfAndSts > OrgnlTxRef > MndtRltdInf > DtOfSgntr
|-
| 27
| 3.72| Amendment Indicator
| TxInfAndSts > OrgnlTxRef > MndtRltdInf > AmdmntInd
|-
| 28
| 3.121| Name
| TxInfAndSts > OrgnlTxRef > Dbtr > Nm
|-
| 29
| 3.122| IBAN
| TxInfAndSts > OrgnlTxRef > DbtrAcct > Id > IBAN
|-
| 30
| 3.123| BIC
| TxInfAndSts > OrgnlTxRef > DbtrAgt > FinInstnId > BIC
|-
| 31
| 3.125| BIC
| TxInfAndSts > OrgnlTxRef > CdtrAgt > FinInstnId > BIC
|-
| 32
| 3.127| Name
| TxInfAndSts > OrgnlTxRef > Cdtr > Nm
|-
| 33
| 3.128| IBAN
| TxInfAndSts > OrgnlTxRef > CdtrAcct > Id > IBAN
|-
SEPA002FileRead
[[-SEP-]]1
[[-SEP-]]strCDA_1_field_0_1,strCDA_1_field_0_2,..............,strCDA_1_field_0_32,strCDA_1_field_0_33,strCDA_1_field_0_34
[[-SEP-]]SubFolder1\SubFolder2\SubFolder3
[[-SEP-]]True
