Navigation:  Exchequer Data Information > Exchequer Tables >

 

EDL Product Supporthome

Bank Reconciliation Headers

Previous pageReturn to chapter overviewNext page

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