Diagrams


Table

Purchases & Payables Setup

DynamicsDocs.comPurchases & Payables Setup«Table 312»Purchases & Payables SetupPrimary Key [PK]Discount Posting; [No Discounts,Invoic...Receipt on InvoiceInvoice RoundingExt. Doc. No. MandatoryVendor Nos.Quote Nos.Order Nos.Invoice Nos.Posted Invoice Nos.Credit Memo Nos.Posted Credit Memo Nos.Posted Receipt Nos.Blanket Order Nos.Calc. Inv. DiscountAppln. between Currencies; [None,EMU,A...Copy Comments Blanket to OrderCopy Comments Order to InvoiceCopy Comments Order to ReceiptAllow VAT DifferenceCalc. Inv. Disc. per VAT IDPosted Prepmt. Inv. Nos.Posted Prepmt. Cr. Memo Nos.Check Prepmt. when PostingDefault Posting Date; [Work Date,No Da...Default Qty. to Receive; [Remainder,Bl...Archive Quotes and OrdersPost with Job QueueJob Queue Category CodeJob Queue Priority for PostPost & Print with Job Queue...«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 471»Job Queue CategoryCode [PK,NN]Description«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/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.Business Unit Filter...<Vendor Nos.><Quote Nos.><Order Nos.><Invoice Nos.><Posted Invoice Nos.><Credit Memo Nos.><Posted Credit Memo Nos.><Posted Receipt Nos.><Blanket Order Nos.><Posted Prepmt. Inv. Nos.><Posted Prepmt. Cr. Memo Nos.><Posted Return Shpt. Nos.><Return Order Nos.><Job Queue Category Code><Debit Acc. for Non-Item Lines><Credit Acc. for Non-Item Lines>

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
6 Receipt on Invoice Boolean
7 Invoice Rounding Boolean
8 Ext. Doc. No. Mandatory Boolean
9 Vendor 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 Receipt Nos. Code10
19 Blanket Order Nos. Code10
20 Calc. Inv. Discount Boolean
21 Appln. between Currencies Option
22 Copy Comments Blanket to Order Boolean
23 Copy Comments Order to Invoice Boolean
24 Copy Comments Order to Receipt Boolean
25 Allow VAT Difference Boolean
26 Calc. Inv. Disc. per VAT ID Boolean
27 Posted Prepmt. Inv. Nos. Code10
28 Posted Prepmt. Cr. Memo Nos. Code10
29 Check Prepmt. when Posting Boolean
35 Default Posting Date Option
36 Default Qty. to Receive 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
1217 Debit Acc. for Non-Item Lines Code20
1218 Credit Acc. for Non-Item Lines Code20
5800 Posted Return Shpt. Nos. Code10
5801 Copy Cmts Ret.Ord. to Ret.Shpt Boolean
5802 Copy Cmts Ret.Ord. to Cr. Memo Boolean
6600 Return Order Nos. Code10
6601 Return Shipment on Credit Memo Boolean
6602 Exact Cost Reversing Mandatory Boolean

Keys

# Fields
0 Primary Key Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Credit Acc. for Non-Item Lines G/L Account 1..n
Job Queue Category Code Job Queue Category Code 1..n
Return Order Nos. No. Series Code 1..n

Table Relations From Other Tables

From Table From Field