Diagrams


Table

Positive Pay Entry

Fields

# Name Type
1 Bank Account No. Code20 NotBlank: No
2 Upload Date-Time DateTime Editable: No
5 Last Upload Date Date
6 Last Upload Time Time
7 Number of Uploads Integer
8 Number of Checks Integer
9 Number of Voids Integer
10 Check Amount Decimal
11 Void Amount Decimal
12 Confirmation Number Text20
13 Exported File BLOB

Keys

# Fields
0 Bank Account No.,Upload Date-Time Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field
Positive Pay Entry Detail Upload Date-Time 1..n