Diagrams


Table

DO Payment Trans. Log Entry

DynamicsDocs.comDO Payment Trans. Log Entry«Table 829»DO Payment Trans. Log EntryEntry No. [PK]Document Type; [,Order,Invoice,Payment...Document No.Customer No.Credit Card No.Transaction Type; [Authorization,Void,...Transaction Result; [Success,Failed]Transaction DescriptionAmountTransaction Date-TimeTransaction Status; [,Voided,Expired,C...Cust. Ledger Entry No.Currency CodeTransaction GUIDTransaction IDUser IDParent Entry No.Reference GUID«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 827»DO Payment Credit CardNo. [PK]Type [NN]Credit Card NumberExpiry Date [NN]Card Holder Name [NN]Customer No. [NN]Contact No. [NN]Cvc No.No. Series«Table 21»Cust. Ledger EntryEntry No. [PK]Customer No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Sales [LCY]Profit [LCY]Inv. Discount [LCY]Sell-to Customer No.Customer Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeSalesperson CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Given [LCY]Positive...«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<Customer No.><Credit Card No.><Cust. Ledger Entry No.><Currency Code><User ID><Currency Code><Currency Filter><Customer Filter><Bill-to Customer No.><Customer No.><Sell-to Customer No.><Bal. Account No.><Customer No.><Currency Code><Closed by Currency Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.>

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

Fields

# Name Type
1 Entry No. Integer AutoIncrement: Yes
2 Document Type Option
3 Document No. Code20
4 Customer No. Code20
5 Credit Card No. Code20
6 Transaction Type Option
7 Transaction Result Option
8 Transaction Description Text250
9 Amount Decimal
10 Transaction Date-Time DateTime
11 Transaction Status Option
12 Cust. Ledger Entry No. Integer
13 Currency Code Code10
14 Transaction GUID GUID
15 Transaction ID Text50
16 User ID Code50
17 Parent Entry No. Integer
18 Reference GUID GUID

Keys

# Fields
0 Entry No. Clustered: Yes
1 Document Type,Document No.,Transaction Type,Transaction Result,Transaction Status
2 Cust. Ledger Entry No.
3 Parent Entry No.,Transaction Type,Transaction Result
4 Credit Card No.
5 Document No.,Customer No.,Transaction Status

Table Relations To Other Tables

Field Related Table Related Field
Currency Code Currency Code 1..n
Cust. Ledger Entry No. Cust. Ledger Entry Entry No. 1..n
Customer No. Customer No. 1..n
Credit Card No. DO Payment Credit Card No. 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field