Difference between revisions of "MetaData - SEPA"

From All n One's bxp software Wixi

Jump to: navigation, search
(Example Rule)
(Example Rule)
Line 271: Line 271:
 
[[-SEP-]]
 
[[-SEP-]]
 
[[-SEP-]]
 
[[-SEP-]]
 
 
</syntaxhighlight>
 
</syntaxhighlight>
  
 
== SEPA Pain 002 Import==
 
== SEPA Pain 002 Import==

Revision as of 12:22, 30 September 2016

1 MetaData - SEPA Rule

bxp has the ability through MetaData, both manual and scheduled to generate a SEPA PAIN 008 file and import to a form a SEPA PAIN 002 Rejection file.



2 SEPA Pain 008 Export

In order to generate a SEPA Pain 008 file bxp needs two forms, one to store all of the Header information for the file and one that stores the individual transaction data. Both the header form and the transaction form must contain the fields mentioned below.


Once the MetaData Process Rule has been set up correctly, bxp will cycle through the header and transaction forms taking all of the required data. The MetaData sequence needs to be set up on the transaction form as this controls the transactions to include in the file.


After a success full process bxp will store the SEPA Pain 008 file in the specified MetaData directory and also perform the following options:


1) Store a CCL of the SEPA file generation in all of the transaction records included

2) Store a CCL of the SEPA file generation in the header form record

3) Store a copy of the SEPA file generated in the header form record, once here this copy cannot be modified/deleted (optional action)


2.1 Header Form Required Fields

# BOI XML Reference Information Manual or Automatic Data Entry
1 1.1 Message Information Manual
2 2.2 Creation Date Time Automatic
3 1.6 Number of transactions Automatic
4 1.7 Control Sum Automatic
5 1.8 Identification Manual
6 2.1 Payment Information Identification Manual
7 2 Payment Method Manual
8 2.4 Number of transactions Automatic
9 2.5 Control Sum Automatic
10 2.9 Code Manual
11 2.12 Code Manual
12 2.14 Sequence Type Manual
13 2.17 Proprietary Manual
14 2.18 Requested Collection Date Manual
15 2.19 Name Manual
16 2.20 IBAN Manual
17 2.21 BIC Manual


2.2 Transaction Form Required Fields

# BOI XML Reference Information Manual or Automatic Data Entry
1 2.30 Payment Identification/Instruction Identification Manual
2 2.31 Payment Identification/End to End Identification Manual
3 2.44 Instructed Amount Manual
4 2.48 Mandate Identification Manual
5 2.49 Date of Signature Manual
6 2.66 Identification Manual
7 2.66 Proprietary Manual
8 2.70 Financial Institution Identification Manual
9 2.72 Name Manual
10 2.73 IBAN Manual


2.3 Rule Parameter Explanation

# Example Type Mandatory Description
0 SEPAFileGeneration Text True This tells bxp what rule to execute and must be as specified
1 Header Form Id Number True This tells bxp what form contains the header information
2 Header Record Id Number True This tells bxp what record contains the header information
3 Header form fields Text True This tells bxp the fields that the header information are stored
4 Transaction form Id Number True This tells bxp what form contains the transaction information
5 Transaction form fields Text True This tells bxp the fields that the transaction information are stored
6 Record Status update True/False True This tells bxp to apply a custom status to the records updated
7 Custom Status to apply Text True This is the custom status that will be applied to the records
8 Store in CCL of Record True/False True This tells bxp to store a copy of the XML file in the CCL of the header record
9 Sub folder Location Text True This tells bxp to look in sub folders if specified

2.4 Example Rule

SEPAFileGeneration
[[-SEP-]]1
[[-SEP-]]1
[[-SEP-]]strCDA_1_field_0_1,strCDA_1_field_0_2,..............,strCDA_1_field_0_16,strCDA_1_field_0_17
[[-SEP-]]2
[[-SEP-]]strCDA_2_field_0_1,strCDA_2_field_0_2,..............,strCDA_2_field_0_9,strCDA_2_field_0_10
[[-SEP-]]True
[[-SEP-]]SEPA FILE GENERATION
[[-SEP-]]True
[[-SEP-]]SubFolder1\SubFolder2\SubFolder3
[[-SEP-]]
[[-SEP-]]
[[-SEP-]]
[[-SEP-]]
[[-SEP-]]
[[-SEP-]]
[[-SEP-]]
[[-SEP-]]

3 SEPA Pain 002 Import