Bank Account Validation
Three key features of this utility include the ability to:
- Format an account into bb-BBBB-aaaaaaaa-sss format (where bb = bank, BBBB = branch number, aaaaaaaa = account number and sss = suffix). The separator character is definable at formatting time.
- De-format an account into bbBBBBaaaaaaaasss format.
- Validate the account number depending on various different check digit algorithms.
The formatting utility is used for presentation requirements on screens, reports or file outputs. It will ensure a consistent format each time an account is referenced.
The de-format utility is used when outputting the account into a flat file for direct credit or direct debit processing into a third party banking package.
The validation utility is used in preventing invalid data being entered into JDEdwards. It makes use of a couple custom UDC tables that hold bank and branch information. These UDC tables are initially set up from a conversion of a spreadsheet of all bank branches obtainable from your bank. The validation process uses the different bank’s check digit algorithms to ensure the branch and account is valid.
A modification to the Bank Account by Address (P0030A) ensures that the validation occurs at data entry time.
A modification to the Create AP Bank Tape ensures the data being written to any flat file output is in the format required by the bank being used.
