The Bank Statement Headers table contains the information from the headers of bank statements that have been imported using the eBanking feature.
Details of the individual lines are stored in the Bank Statement Lines table.
Key Field: bsIdxCode1
Field Name |
Description |
Type |
Length |
bsIdxRecSub |
|
String |
2 |
bsSpare |
Future Use |
String |
1 |
bsIdxCode1 |
|
String |
30 |
bsIdxCode2 |
|
String |
45 |
bsIdxCode3 |
|
String |
31 |
bsGLCode |
General Ledger Code |
Integer |
4 |
bsReferenceLB |
not used |
String |
1 |
bsReference |
Reference |
String |
20 |
bsStatus |
0 = Open; 1 = In progress; 2 = complete |
Integer |
2 |
bsSourceFileLB |
not used |
String |
1 |
bsSourceFile |
|
String |
100 |
bsFolio |
|
Integer |
4 |
bsDateLB |
not used |
String |
1 |
bsDate |
Date |
Date |
8 |