Diagrams


Table

Positive Pay Entry Detail

DynamicsDocs.comPositive Pay Entry Detail«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...«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 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email<Bank Account No.><Upload Date-Time><Currency Code><User ID><Currency Code><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
2 Upload Date-Time (Upload Date-Time) DateTime
3 No. (No.) Integer
5 Check No. (Check No.) Code20
6 Currency Code (Currency Code) Code10
7 Document Type (Document Type) Option
8 Document Date (Document Date) Date
9 Amount (Amount) Decimal
10 Payee (Payee) Text50
11 User ID (User ID) Code50
12 Update Date (Update Date) Date

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Bank Account No. (Bank Account No.) Bank Account No. (No.) 1..n
Currency Code (Currency Code) Currency Code (Code) 1..n
Upload Date-Time (Upload Date-Time) Positive Pay Entry Upload Date-Time (Upload Date-Time) 1..n
User ID (User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field