The Bank Accounts table contains details of the Bank Accounts set up within Exchequer.
Key Field: baIdxCode1
Field Name  | 
Description  | 
Type  | 
Length  | 
baIdxRecSub  | 
  | 
String  | 
2  | 
baSpare  | 
not used  | 
String  | 
1  | 
baIdxCode1  | 
  | 
String  | 
30  | 
baSpare1  | 
not used  | 
String  | 
1  | 
baIdxCode2  | 
  | 
String  | 
45  | 
baSpare2  | 
not used  | 
String  | 
1  | 
baIdxCode3  | 
  | 
String  | 
31  | 
baGLCode  | 
General Ledger Code  | 
Integer  | 
4  | 
baProduct  | 
Two digit code identifying Bank Product  | 
Integer  | 
2  | 
baOutputPathLB  | 
not used  | 
String  | 
1  | 
baOutputPath  | 
Output path  | 
String  | 
60  | 
baPayFilenameLB  | 
not used  | 
String  | 
1  | 
baPayFilename  | 
Payments File Name  | 
String  | 
60  | 
baRecFilenameLB  | 
not used  | 
String  | 
1  | 
baRecFilename  | 
Receipts file name  | 
String  | 
60  | 
baStatementPathLB  | 
not used  | 
String  | 
1  | 
baStatementPath  | 
Statement Path  | 
String  | 
60  | 
baSwiftRef1LB  | 
not used  | 
String  | 
1  | 
baSwiftRef1  | 
  | 
String  | 
60  | 
baSwiftRef2LB  | 
not used  | 
String  | 
1  | 
baSwiftRef2  | 
  | 
String  | 
60  | 
baSwiftRef3LB  | 
not used  | 
String  | 
1  | 
baSwiftRef3  | 
  | 
String  | 
60  | 
baSwiftBICLB  | 
not used  | 
String  | 
1  | 
baSwiftBIC  | 
  | 
String  | 
11  | 
baRouteCodeLB  | 
not used  | 
String  | 
1  | 
baRouteCode  | 
  | 
String  | 
35  | 
baChargeInstLB  | 
not used  | 
String  | 
1  | 
baChargeInst  | 
  | 
String  | 
5  | 
baRouteMethod  | 
  | 
String  | 
1  | 
baLastDateLB  | 
  | 
String  | 
1  | 
baLastDate  | 
not used  | 
String  | 
8  | 
baSortCodeLB  | 
not used  | 
String  | 
1  | 
baSortCode  | 
Sort Code  | 
String  | 
6  | 
baAccountNoLB  | 
not used  | 
String  | 
1  | 
baAccountNo  | 
Account Number  | 
String  | 
12  | 
baReferenceLB  | 
not used  | 
String  | 
1  | 
baReference  | 
Reference  | 
String  | 
18  | 
baUserIDLB  | 
not used  | 
String  | 
1  | 
baUserID  | 
User ID  | 
String  | 
10  |