Diagrams


Table

Sales Cr. Memo Entity Buffer

DynamicsDocs.comSales Cr. Memo Entity Buffer«Table 5507»Sales Cr. Memo Entity BufferSell-to Customer No. [NN]No. [PK]Payment Terms CodeDue DateCustomer Posting GroupCurrency CodePrices Including VATSalesperson CodeApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.Recalculate Invoice Disc.AmountAmount Including VATSell-to Customer NameSell-to AddressSell-to Address 2Sell-to CitySell-to ContactSell-to Post CodeSell-to CountySell-to Country/Region CodeDocument DateExternal Document No.Cust. Ledger Entry No.Invoice Discount AmountSell-to Contact No.Shipping Advice; [Partial,Complete]Completely ShippedRequested Delivery DateIdTotal Tax Amount...«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 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 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><Customer Posting Group><Currency Code><Currency Id><Salesperson Code><Sell-to Country/Region Code><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><Country/Region Code><Bill-to Customer No.><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

Fields

# Name Type
2 Sell-to Customer No. Code20 NotBlank: Yes
3 No. Code20
23 Payment Terms Code Code10
24 Due Date Date
31 Customer Posting Group Code20
32 Currency Code Code10
35 Prices Including VAT Boolean
43 Salesperson Code Code20
52 Applies-to Doc. Type Option
53 Applies-to Doc. No. Code20
56 Recalculate Invoice Disc. Boolean Editable: No
FlowField
60 Amount Decimal
61 Amount Including VAT Decimal
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
1304 Cust. Ledger Entry No. Integer
1305 Invoice Discount Amount Decimal
5052 Sell-to Contact No. Code20
5750 Shipping Advice Option
5752 Completely Shipped Boolean
5790 Requested Delivery Date Date
8000 Id GUID
9600 Total Tax Amount Decimal
9601 Status Option
9602 Posted Boolean
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

Keys

# Fields
0 No.,Posted
1 Id Clustered: Yes
2 Cust. Ledger Entry No.

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

Table Relations From Other Tables

From Table From Field