Diagrams


Table

O365 Sales Document

DynamicsDocs.comO365 Sales Document«Table 2103»O365 Sales DocumentDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Due DateCurrency CodeSell-to Customer NameSell-to ContactDocument DateLast Email Sent TimeLast Email Sent Status; [,In Process,F...Sent as EmailLast Email Notif ClearedPosted [PK]CanceledCurrency SymbolDocument Status; [Quote,Draft Invoice,...Sales AmountOutstanding AmountTotal Invoiced AmountOutstanding StatusDocument IconPayment MethodDisplay No.Quote Valid Until DateQuote AcceptedQuote Sent to CustomerQuote Accepted Date«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 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 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. TypeUse for InvoicingLast Modified Date TimeId<Sell-to Customer No.><Currency Code><Payment Method><Currency Code><Currency Filter><Currency Id><Customer Filter><Bill-to Customer No.><Payment Method Code><Payment Method Id>

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

Fields

# Name Type
1 Document Type Option
2 Sell-to Customer No. Code20
3 No. Code20
24 Due Date Date
32 Currency Code Code10
79 Sell-to Customer Name Text50
84 Sell-to Contact Text50
99 Document Date Date
166 Last Email Sent Time DateTime FlowField
167 Last Email Sent Status Option FlowField
168 Sent as Email Boolean FlowField
169 Last Email Notif Cleared Boolean FlowField
2100 Posted Boolean
2101 Canceled Boolean FlowField
2102 Currency Symbol Text10
2103 Document Status Option
2104 Sales Amount Decimal
2105 Outstanding Amount Decimal
2106 Total Invoiced Amount Text250
2107 Outstanding Status Text250
2108 Document Icon MediaSet
2109 Payment Method Code10
2110 Display No. Text20
2111 Quote Valid Until Date Date FlowField
2112 Quote Accepted Boolean FlowField
2113 Quote Sent to Customer DateTime FlowField
2114 Quote Accepted Date Date FlowField

Keys

# Fields
0 Document Type,No.,Posted Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Currency Code Currency Code 1..n
Sell-to Customer No. Customer No. 1..n
Payment Method Payment Method 1..n

Table Relations From Other Tables

From Table From Field