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]Description«Table 348»DimensionCode [PK,NN]NameCode CaptionFilter CaptionDescriptionBlockedConsolidation CodeMap-to IC Dimension Code«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 Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit 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)><Customer Group Dimension Code><Salesperson Dimension Code><Freight G/L Acc. No.><VAT Bus. Posting Group>

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. Code10
10 Quote Nos. Code10
11 Order Nos. Code10
12 Invoice Nos. Code10
13 Posted Invoice Nos. Code10
14 Credit Memo Nos. Code10
15 Posted Credit Memo Nos. Code10
16 Posted Shipment Nos. Code10
17 Reminder Nos. Code10
18 Issued Reminder Nos. Code10
19 Fin. Chrg. Memo Nos. Code10
20 Issued Fin. Chrg. M. Nos. Code10
21 Posted Prepmt. Inv. Nos. Code10
22 Posted Prepmt. Cr. Memo Nos. Code10
23 Blanket Order Nos. Code10
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) Code10
45 Direct Debit Mandate Nos. Code10
46 Allow Document Deletion Before Date
50 Default Item Quantity Boolean
51 Create Item from Description Boolean
5800 Posted Return Receipt Nos. Code10
5801 Copy Cmts Ret.Ord. to Ret.Rcpt Boolean
5802 Copy Cmts Ret.Ord. to Cr. Memo Boolean
6600 Return Order Nos. Code10
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
Job Queue Category Code Job Queue Category Code 1..n
Return Order Nos. No. Series Code 1..n
VAT Bus. Posting Gr. (Price) VAT Business Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field