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


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


# Fields
0 Primary Key (Primary Key) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field