Diagrams


Table

Payment Matching Details

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 Statement Type (Statement Type) Option
5 Line No. (Line No.) Integer
6 Message (Message) Text250

Keys

# Fields
0 Statement Type,Bank Account No.,Statement No.,Statement Line No.,Line No. (Statement Type,Bank Account No.,Statement No.,Statement Line No.,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Statement No. (Statement No.) Bank Acc. Reconciliation Statement No. (Statement No.) 1..n
Bank Account No. (Bank Account No.) Bank Account No. (No.) 1..n

Table Relations From Other Tables

From Table From Field