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 EmailExchange IdentifierApplication ID<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. Code20
2 Upload Date-Time DateTime
3 No. Integer
5 Check No. Code20
6 Currency Code Code10
7 Document Type Option
8 Document Date Date
9 Amount Decimal
10 Payee Text50
11 User ID Code50
12 Update Date Date

Keys

# Fields
0 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. 1..n
Currency Code Currency Code 1..n
Upload Date-Time Positive Pay Entry Upload Date-Time 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field