Sales Quote Entity Buffer

DynamicsDocs.comSales Quote Entity Buffer«Table 5505»Sales Quote Entity BufferDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No. [NN]No. [PK]Your ReferencePosting DatePayment Terms CodeDue DateShipment Method CodeCustomer Posting GroupCurrency CodePrices Including VATSalesperson CodeRecalculate Invoice Disc.AmountAmount Including VATVAT Registration No.Sell-to Customer NameSell-to AddressSell-to Address 2Sell-to CitySell-to ContactSell-to Post CodeSell-to CountySell-to Country/Region CodeDocument DateExternal Document No.Tax Area CodeTax LiableVAT Bus. Posting GroupInvoice Discount Calculation; [None,%,...Invoice Discount Value...«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 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. MemosLast Modified Date TimeId«Table 10»Shipment MethodCode [PK,NN]DescriptionLast Modified Date TimeId«Table 92»Customer Posting GroupCode [PK,NN]Receivables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountAdditional Fee AccountInterest AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.Add. Fee per Line AccountDescriptionUsed in CustomersUsed in Ledger Entries«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 13»Salesperson/PurchaserCode [PK,NN]NameCommission %ImageGlobal Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next Task DateNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Job TitleAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterAvg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Contact FilterContact Company FilterCampaign FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTask Status Filter; [Not Started,In Pr......«Table 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT SchemeLast Modified Date TimeId«Table 323»VAT Business Posting GroupCode [PK,NN]DescriptionLast Modified Date TimeId«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 5050»ContactNo. [PK]NameSearch NameName 2AddressAddress 2CityPhone No.Telex No.Territory CodeCurrency CodeLanguage CodeSalesperson CodeCountry/Region CodeCommentLast Date ModifiedFax No.Telex Answer BackVAT Registration No.PicturePost CodeCountyE-MailHome PageNo. SeriesImageType; [Company,Person]Company No.Company NameLookup Contact No.First Name...<Sell-to Customer No.><Customer Id><Payment Terms Code><Payment Terms Id><Shipment Method Code><Shipment Method Id><Customer Posting Group><Currency Code><Currency Id><Salesperson Code><Sell-to Country/Region Code><VAT Bus. Posting Group><Cust. Ledger Entry No.><Sell-to Contact No.><Customer Posting Group><Currency Code><Currency Filter><Currency Id><Customer Filter><Payment Terms Code><Cash Flow Payment Terms Code><Payment Terms Id><Salesperson Code><Shipment Method Code><Shipment Method Id><Country/Region Code><Bill-to Customer No.><VAT Bus. Posting Group><Primary Contact No.><Customer No.><Sell-to Customer No.><Bal. Account No.><Customer Posting Group><Currency Code><Closed by Currency Code><Currency Code><Contact Filter><Contact Company Filter><Salesperson Code><Salesperson Filter><Salesperson Code><Country/Region Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Company No.><Lookup Contact No.>

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


# Name Type
1 Document Type Option
2 Sell-to Customer No. Code20 NotBlank: Yes
3 No. Code20
11 Your Reference Text35
20 Posting Date Date
23 Payment Terms Code Code10
24 Due Date Date
27 Shipment Method Code Code10
31 Customer Posting Group Code20
32 Currency Code Code10
35 Prices Including VAT Boolean
43 Salesperson Code Code20
56 Recalculate Invoice Disc. Boolean Editable: No
60 Amount Decimal
61 Amount Including VAT Decimal
70 VAT Registration No. Text20
79 Sell-to Customer Name Text50
81 Sell-to Address Text50
82 Sell-to Address 2 Text50
83 Sell-to City Text30
84 Sell-to Contact Text50
88 Sell-to Post Code Code20
89 Sell-to County Text30
90 Sell-to Country/Region Code Code10
99 Document Date Date
100 External Document No. Code35
114 Tax Area Code Code20
115 Tax Liable Boolean
116 VAT Bus. Posting Group Code20
121 Invoice Discount Calculation Option
122 Invoice Discount Value Decimal
152 Quote Valid Until Date Date
153 Quote Sent to Customer DateTime Editable: No
154 Quote Accepted Boolean
155 Quote Accepted Date Date Editable: No
167 Last Email Sent Status Option
1304 Cust. Ledger Entry No. Integer
1305 Invoice Discount Amount Decimal
5052 Sell-to Contact No. Code20
8000 Id GUID
9600 Total Tax Amount Decimal
9601 Status Option
9602 Posted Boolean
9603 Subtotal Amount Decimal Editable: No
9624 Discount Applied Before Tax Boolean
9630 Last Modified Date Time DateTime
9631 Customer Id GUID
9633 Contact Graph Id Text250
9634 Currency Id GUID
9635 Payment Terms Id GUID
9636 Shipment Method Id GUID
9637 Tax Area ID GUID


# Fields
0 No. Clustered: Yes
1 Id

Table Relations To Other Tables

Field Related Table Related Field
Sell-to Contact No. Contact No. 1..n
Sell-to Country/Region Code Country/Region Code 1..n
Currency Id Currency Id 1..n
Cust. Ledger Entry No. Cust. Ledger Entry Entry No. 1..n
Customer Id Customer Id 1..n
Customer Posting Group Customer Posting Group Code 1..n
Payment Terms Id Payment Terms Id 1..n
Salesperson Code Salesperson/Purchaser Code 1..n
Shipment Method Id Shipment Method Id 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field