Difference between revisions of "MetaData - SEPA"

Revision as of 15:11, 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)

Reference Document -- Media:SEPA_008_LayoutDocument.pdf

2.1 Header Form Required Fields

2.2 Transaction Form Required Fields

2.3 Rule Parameter Explanation

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

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) Store a CCL of the SEPA file that was processed for each record created (optional action - but highly recommended)

3) Delete the original file from the specified location (optional action - but highly recommended)

Reference Document -- Media:SEPA_002_LayoutDocument.pdf

3.1 SEPA Import Form Required Fields

3.2 Example Rule

SEPA002FileRead
[[-SEP-]]1
[[-SEP-]]strCDA_1_field_0_1,strCDA_1_field_0_2,..............,strCDA_1_field_0_32,strCDA_1_field_0_33
[[-SEP-]]SubFolder1\SubFolder2\SubFolder3
[[-SEP-]]True
[[-SEP-]]SEPA Rejection
[[-SEP-]]False
[[-SEP-]]
[[-SEP-]]
[[-SEP-]]
[[-SEP-]]
[[-SEP-]]
[[-SEP-]]