Diagrams

Table

Positive Pay Entry

DynamicsDocs.comPositive Pay Entry«Table 1231»Positive Pay EntryBank Account No. [PK]Upload Date-Time [PK]Last Upload DateLast Upload TimeNumber of UploadsNumber of ChecksNumber of VoidsCheck AmountVoid AmountConfirmation NumberExported File«Table 1232»Positive Pay Entry DetailBank Account No. [PK]Upload Date-Time [PK]No. [PK]Check No.Currency CodeDocument Type; [CHECK,VOID]Document DateAmountPayeeUser IDUpdate Date«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...<Bank Account No.><Upload Date-Time><Bank Account No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

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