The upload of bulk electronic bank statements generated from Nedbank’s NedAcad system.
Create a Batch Parameter with a Transaction Code of NEDACAD and Description of the directory where the Great Plains Interface file must be placed.
For the translation of the Codes on the NedAcad file to the Payment Type on IN.sight, translation values must be set up as per the details below:
Translation Purpose
Add NEDACAD to the UDPV object Translation Type.
Source / Target System ID’s and Attributes
The following Source System and Target System ID’s and Attributes must be set up:
|
Source System ID |
Source System Attribute |
Target System ID |
Target System Attribute |
|
NEDACAD |
TRANSACTION CODE |
IN.PENSIONS |
PAYMENT METHOD |
Translation Values
The following Translation Values for the System ID’s / Attributes above must be set up:
|
Source System |
Target System |
|
101 |
DEPOSIT* |
|
110 |
DEPOSIT |
|
111 |
DEPOSIT |
|
119 |
DEPOSIT |
|
124 |
DEPOSIT |
|
125 |
DEPOSIT |
|
152 |
DEPOSIT |
|
161 |
DEPOSIT |
|
195 |
DEPOSIT |
|
219 |
EFT |
|
237 |
EFT |
|
268 |
EFT |
|
280 |
EFT |
A batch job must be created that will run several times a day to extract the Bank Account details. When this batch job runs, the system will check if there is a file in the directory defined in the Batch Parameter (the details of the file name and the directory will be confirmed later). If there is a file, the system will extract the details as per the table below and update the field on the BANK STATEMENT table as per the IN.sight Field column:
Once the file has been processed, it will be moved to a folder with the name COMPLETED.
File Header Record
|
DATA ELEMENT |
LENGTH |
TYPE |
DESCRIPTION |
IN.SIGHT FIELD |
|
Record Identifier |
2 |
N |
00 – header record identifier |
|
|
Group Number |
10 |
N |
Nominated account number that all accounts are linked to and to which the NedAcad charges will be debited |
|
|
Filler |
70 |
N |
Zeroes |
|
|
Date |
8 |
N |
File creation date in format DDMMCCYY |
|
Account Header Record
|
DATA ELEMENT |
LENGTH |
TYPE |
DESCRIPTION |
IN.SIGHT FIELD |
|
Record Type |
2 |
N |
01 |
|
|
Group Number |
10 |
N |
Nominated account number that all accounts are linked to and to which the NedAcad charges will be debited |
|
|
Account Number |
10 |
N |
Account number being reported on this record |
BANK ACCOUNT NUMBER |
|
Filler |
7 |
N |
Not applicable |
|
|
Postal Code |
4 |
N |
Postal code |
|
|
Sign for Opening Balance |
1 |
A |
{ = Positive Balance } = Negative Balance |
|
|
Opening Balance |
14 |
N |
Opening balance of the account at the beginning of the processing period. Last two digits represents the cents value. |
|
|
Out Type |
1 |
N |
Not applicable |
|
|
Filler |
2 |
N |
Not applicable |
|
|
Sign for Closing Balance |
1 |
A |
{ = Positive Balance } = Negative Balance |
|
|
Closing Balance |
14 |
N |
Closing balance of the account at the end of the processing period. Last two digits represents the cents value. |
ACCOUNT BALANCE Read the value for Sign for Closing Balance field and if it is {update the Account Balance field with no sign. If it is} update the Account Balance field with a negative sign. Create the Bank Statement record with the Actual Transaction Date and Business Effective Date equal to the value for Date in the File Header record. |
|
Filler |
24 |
N |
Not applicable |
|
Account Name Record Type
|
DATA ELEMENT |
LENGTH |
TYPE |
DESCRIPTION |
IN.SIGHT FIELD |
|
Record Type |
2 |
N |
02 |
|
|
Group Number |
10 |
N |
Nominated account number that all accounts are linked to and to which the NedAcad charges will be debited |
|
|
Account Number |
10 |
N |
Account number being reported on this record |
|
|
Name |
30 |
A/N |
Name of the account |
|
|
Filler |
38 |
Space |
Not applicable |
|
Account Address Record Type
|
DATA ELEMENT |
LENGTH |
TYPE |
DESCRIPTION |
IN.SIGHT FIELD |
|
Record Type |
2 |
N |
03, 04 or 05 |
|
|
Group Number |
10 |
N |
Nominated account number that all accounts are linked to and to which the NedAcad charges will be debited |
|
|
Account Number |
10 |
N |
Account number being reported on this record |
|
|
Address |
30 |
A/N |
First line of address if the record type is 03 Second line of address if the record type is 04 Third lie of address if the record type is 05 |
|
|
Filler |
38 |
Space |
Not applicable |
|
Transaction Detail Record
|
DATA ELEMENT |
LENGTH |
TYPE |
DESCRIPTION |
IN.SIGHT FIELD |
|
Record Type |
2 |
N |
06 |
|
|
Group Number |
10 |
N |
Nominated account number that all accounts are linked to and to which the NedAcad charges will be debited |
|
|
Account Number |
10 |
N |
Account number being reported on this record |
BANK ACCOUNT NUMBER |
|
Transaction Date |
8 |
N |
Transaction date in format DDMMCCYY |
ACTUAL TRANSACTION DATE BUSINESS EFFECTIVE DATE |
|
Statement |
6 |
N |
Last six digits of the statement number |
STATEMENT NO |
|
Code |
1 |
A/N |
C = Cheque transaction B = Deposit transaction Space = Indicates that the code identifier contains a transaction code |
PAYMENT TYPE If the value is C update the Payment Type with CHEQUE If it is B update the Payment Type with DEPOSIT If it is a space find the Translation Value with a Purpose of NEDACAD and Source System Attribute of TRANSACTION CODE and find the translation value for the Code Number value (see next field). If no Translation Value is found leave blank. |
|
Code Number |
8 |
N |
If the Code is C this will contain a cheque number If the Code is B this will contain the deposit number If the Code is a space this will contain a Transaction Code |
If the value for Code is C or B update the DOCUMENT NUMBER field with this value. |
|
Amount |
14 |
N |
The amount of the transaction in cents |
MONETARY AMOUNT If the value for Code is C update the MONETARY AMOUNT with a negative sign. If the value for Code is B update the MONETARY AMOUNT with no sign. If the value for Code is spaces read the first character of the value for Code Number. If it is 1 update the MONETARY AMOUNT with no sign. If it is 2 update the MONETARY AMOUNT with a negative sign. |
|
Description |
30 |
A/N |
Transaction description/narrative |
If the value for Code is spaces update the DOCUMENT NUMBER field with this value. |
|
Punched or Tran |
1 |
N |
Branch number that initiated the transaction |
|
File Trailer Record Type
|
DATA ELEMENT |
LENGTH |
TYPE |
DESCRIPTION |
IN.SIGHT FIELD |
|
Record Type |
2 |
N |
99 |
|
|
Filler |
80 |
N |
Will contain all 9’s |
|
|
Entry count |
8 |
N |
The total number of records in the file excluding the file header and file trailer records |
|