Diagrams


Table

Bank Account Statement Line

Fields

# Name Type
1 Bank Account No. Code20
2 Statement No. Code20
3 Statement Line No. Integer
4 Document No. Code20
5 Transaction Date Date
6 Description Text50
7 Statement Amount Decimal
8 Difference Decimal
9 Applied Amount Decimal Editable: No
10 Type Option
11 Applied Entries Integer Editable: No
12 Value Date Date
14 Check No. Code20

Keys

# Fields
0 Bank Account No.,Statement No.,Statement Line No. Clustered: Yes
MaintainSIFTIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Bank Account No. Bank Account No. 1..n
Statement No. Bank Account Statement Statement No. 1..n

Table Relations From Other Tables

From Table From Field