Navigation:  Exchequer Data Information > Exchequer Tables >

 

EDL Product Supporthome

Bank Statement Headers

Previous pageReturn to chapter overviewNext page

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