The Bank Reconciliation Headers table contains the header information from complete and incomplete bank reconciliations that have been performed using the Bank Reconciliation Wizard.
The details are stored in the Bank Reconciliation Details table.
Key Field: brhIdxCode1
Field Name |
Description |
Type |
Length |
brhIdxRecSub |
|
String |
2 |
brhSpare |
not used |
String |
1 |
brhIdxCode1 |
|
String |
30 |
brhSpare1 |
not used |
String |
1 |
brhIdxCode2 |
|
String |
45 |
brhSpare2 |
not used |
String |
1 |
brhIdxCode3 |
|
String |
31 |
brhStatementDateLB |
not used |
String |
1 |
brhStatementDate |
Statement Date (if statement has been linked) |
Date |
8 |
brhStatementRefLB |
not used |
String |
1 |
brhStatementRef |
Statement Reference (if statement has been linked) |
String |
20 |
brhBankAccountLB |
not used |
String |
1 |
brhBankAccount |
|
String |
15 |
brhCurrency |
Currency |
Integer |
1 |
brhUserIDLB |
not used |
String |
1 |
brhUserID |
|
String |
10 |
brhDateCreatedLB |
not used |
String |
1 |
brhDateCreated |
|
Date |
8 |
brhTimeCreatedLB |
not used |
String |
1 |
brhTimeCreated |
|
String |
6 |
brhStatementBalance |
Statement Balance |
Float |
8 |
brhOpeningBalance |
Opening Balance |
Float |
8 |
brhClosingBalance |
Closing Balance |
Float |
8 |
brhStatus |
|
Integer |
1 |
brhFolio |
|
Integer |
4 |
brhGLCode |
General Ledger Code |
Integer |
4 |
brhStatementFolio |
Statement Folio (if statement has been linked) |
Integer |
4 |
brhDateLB |
not used |
String |
1 |
brhDate |
Date of starting |
Date |
8 |
brhReferenceLB |
not used |
String |
1 |
brhReference |
Reference entered by user when starting reconciliation |
String |
20 |
brhInitialSequence |
|
Integer |
1 |