Diagrams


Table

Bank Account Statement Line

Fields

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

Keys

# Fields
0 Bank Account No.,Statement No.,Statement Line No. (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.) Bank Account No. (No.) 1..n
Statement No. (Statement No.) Bank Account Statement Statement No. (Statement No.) 1..n

Table Relations From Other Tables

From Table From Field