Diagrams


Table

Sales & Receivables Setup

DynamicsDocs.comSales & Receivables Setup«Table 311»Sales & Receivables SetupPrimary Key [PK]Discount Posting; [No Discounts,Invoic...Credit Warnings; [Both Warnings,Credit...Stockout WarningShipment on InvoiceInvoice RoundingExt. Doc. No. MandatoryCustomer Nos.Quote Nos.Order Nos.Invoice Nos.Posted Invoice Nos.Credit Memo Nos.Posted Credit Memo Nos.Posted Shipment Nos.Reminder Nos.Issued Reminder Nos.Fin. Chrg. Memo Nos.Issued Fin. Chrg. M. Nos.Posted Prepmt. Inv. Nos.Posted Prepmt. Cr. Memo Nos.Blanket Order Nos.Calc. Inv. DiscountAppln. between Currencies; [None,EMU,A...Copy Comments Blanket to OrderCopy Comments Order to InvoiceCopy Comments Order to Shpt.Allow VAT DifferenceCalc. Inv. Disc. per VAT IDLogo Position on Documents; [No Logo,L...Check Prepmt. when Posting...«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 471»Job Queue CategoryCode [PK,NN]Description«Table 323»VAT Business Posting GroupCode [PK,NN]DescriptionLast Modified Date TimeId«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 348»DimensionCode [PK,NN]NameCode CaptionFilter CaptionDescriptionBlockedConsolidation CodeMap-to IC Dimension CodeIdLast Modified Date Time«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....<Customer Nos.><Quote Nos.><Order Nos.><Invoice Nos.><Posted Invoice Nos.><Credit Memo Nos.><Posted Credit Memo Nos.><Posted Shipment Nos.><Reminder Nos.><Issued Reminder Nos.><Fin. Chrg. Memo Nos.><Issued Fin. Chrg. M. Nos.><Posted Prepmt. Inv. Nos.><Posted Prepmt. Cr. Memo Nos.><Blanket Order Nos.><Direct Debit Mandate Nos.><Posted Return Receipt Nos.><Return Order Nos.><Job Queue Category Code><VAT Bus. Posting Gr. (Price)><Write-in Product No.><Write-in Product No.><Customer Group Dimension Code><Salesperson Dimension Code><Freight G/L Acc. No.><No. Series><No. Series><Serial Nos.><Lot Nos.><VAT Bus. Posting Group><VAT Bus. Posting Gr. (Price)><Alternative Item No.>

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

Fields

# Name Type
1 Primary Key Code10
2 Discount Posting Option
4 Credit Warnings Option
5 Stockout Warning Boolean
6 Shipment on Invoice Boolean
7 Invoice Rounding Boolean
8 Ext. Doc. No. Mandatory Boolean
9 Customer Nos. Code20
10 Quote Nos. Code20
11 Order Nos. Code20
12 Invoice Nos. Code20
13 Posted Invoice Nos. Code20
14 Credit Memo Nos. Code20
15 Posted Credit Memo Nos. Code20
16 Posted Shipment Nos. Code20
17 Reminder Nos. Code20
18 Issued Reminder Nos. Code20
19 Fin. Chrg. Memo Nos. Code20
20 Issued Fin. Chrg. M. Nos. Code20
21 Posted Prepmt. Inv. Nos. Code20
22 Posted Prepmt. Cr. Memo Nos. Code20
23 Blanket Order Nos. Code20
24 Calc. Inv. Discount Boolean
25 Appln. between Currencies Option
26 Copy Comments Blanket to Order Boolean
27 Copy Comments Order to Invoice Boolean
28 Copy Comments Order to Shpt. Boolean
29 Allow VAT Difference Boolean
30 Calc. Inv. Disc. per VAT ID Boolean
31 Logo Position on Documents Option
32 Check Prepmt. when Posting Boolean
35 Default Posting Date Option
36 Default Quantity to Ship Option
37 Archive Quotes and Orders Boolean
38 Post with Job Queue Boolean
39 Job Queue Category Code Code10
40 Job Queue Priority for Post Integer
41 Post & Print with Job Queue Boolean
42 Job Q. Prio. for Post & Print Integer
43 Notify On Success Boolean
44 VAT Bus. Posting Gr. (Price) Code20
45 Direct Debit Mandate Nos. Code20
46 Allow Document Deletion Before Date
50 Default Item Quantity Boolean
51 Create Item from Description Boolean
5329 Write-in Product Type Option
5330 Write-in Product No. Code20
5800 Posted Return Receipt Nos. Code20
5801 Copy Cmts Ret.Ord. to Ret.Rcpt Boolean
5802 Copy Cmts Ret.Ord. to Cr. Memo Boolean
6600 Return Order Nos. Code20
6601 Return Receipt on Credit Memo Boolean
6602 Exact Cost Reversing Mandatory Boolean
7101 Customer Group Dimension Code Code20
7102 Salesperson Dimension Code Code20
7103 Freight G/L Acc. No. Code20

Keys

# Fields
0 Primary Key Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Salesperson Dimension Code Dimension Code 1..n
Freight G/L Acc. No. G/L Account No. 1..n
Write-in Product No. Item No. 1..n
Job Queue Category Code Job Queue Category Code 1..n
Return Order Nos. No. Series Code 1..n
Write-in Product No. Resource No. 1..n
VAT Bus. Posting Gr. (Price) VAT Business Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field