|
Bank Details Extension Setup (BDES) |
|
|
|
|
Sun Documentation -
Accounts Payable
|
|
You can transfer payments or debits from SunSystems into bank transfer files, ready for export into a payment clearing system. To aid in the preparation of the transfer file, a bank details extension record may be defined in order to derive data for inclusion on the bank file record.
To do this, select Bank Details Extension Setup (BDES).
You will be presented with a form containing bank details formats for different European countries:
Click here to see the screenshot
Select a form for France: "BDE_FB" and click Ok.
Click here to see the screenshot
Bank Details Code
A code that uniquely identifies all of the bank details for a customer or supplier.
Bank Subcode
This code identifies an individual bank account for the debtor, creditor or client account, if more than one bank account is required. You can define any number of banks from which you can draw funds, or into which you can deposit funds, when the settlement is by bank transfer.
Note: This combination must match a bank details record.
Format Code
This is used for a country/bank format combination which enables you to define more than one bank format per country. When using the following format codes, predefined validation rules are applied, in addition to the normal validation, to ensure details adhere to an internationally recognised format:
BB - Belgium
EB - Spain
ED - Austria (EDIFACT)
FB - France
GB - Germany
IB - Ireland
IT - Italy
NB - Netherlands
When using a format code of FB (France) within Bank Details Extension Setup (BDES) the following validation rules are applied, in additional to normal validation for Bank Details Setup (BDS) and Bank Details Extension Setup (BDES), to ensure details adhere to an internationally recognised format.
Bank Details Setup
Bank Name
Mandatory
Bank Branch
Optional
Bank Address Code
Mandatory
Bank Account_Name
Mandatory
Bank Account Number
Mandatory
Maximum 11 uppercase alpha or numeric characters
Transaction Limit
Optional, can set limit of single transaction
Transaction Reference
Optional
Direct Debit Transaction Type
First, Normal, Re-present, or Last
Comment
Optional
Bank Details Extension Setup
Format Identifier (Format Code)
FB
Swift Code
Optional for Foreign
Record Type (Sun_User)
'U' for Own (Sun)
' ' blank for regular Debtor / Creditor
Domestic / Foreign (Code 1)
Mandatory
'D' or 'F'
If Record Type = 'U', then must be 'D'
Country Code (Code 2)
Not Required for Domestic
Optional for Foreign
Pay by Account / Ref. (Code 3)
Mandatory for Record Type ' ' blank , 'A' or 'R'
Currency Code (Code 4)
Not Required for Domestic
Optional for Foreign
Bank RIB Code (Integer 1)
Mandatory
5 digits
Branch Code (Integer 2)
Mandatory
5 digits
RIB Check Code (Integer 3)
Mandatory
2 digits
Calculated using the following formula:
x = concatenation of RIB Code, Branch Code, and Account Number, with any alpha characters in the Account Number replaced with numeric values as follows
1 for A or J
2 for B, K or S
3 for C, L or T
4 for D, M or U
5 for E, N or V
6 for F, O or W
7 for G, P or X
8 for H, Q or Y
9 for I, R or Z
x / 97 = whole number (E) + remainder (Er)
RIB Check Code = 97 - remainder (Er)
Issuer Number - Pay (Integer 4)
Mandatory for Record Type 'U'
Issuer Number - DD (Integer 5)
Mandatory for Record Type 'U'
Siren Number (Integer 6)
Optional
Only required for Foreign
Economic Code (Integer 7)
Optional
Only required for Foreign
|
Sun Documentation 
