Diagrams


Table

Native - Payment

Fields

# Name Type
1 Ledger Entry No. (Ledger Entry No.) Integer
2 Payment No. (Payment No.) Integer
3 Customer Id (Customer Id) GUID
4 Customer No. (Customer No.) Code20
5 Payment Date (Payment Date) Date
6 Amount (Amount) Decimal
7 Applies-to Invoice Id (Applies-to Invoice Id) GUID
8 Applies-to Invoice No. (Applies-to Invoice No.) Code20
9 Payment Method Id (Payment Method Id) GUID
10 Payment Method Code (Payment Method Code) Code10

Keys

# Fields
0 Applies-to Invoice Id,Payment No. (Applies-to Invoice Id,Payment No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field