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

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Credit Acc. for Non-Item Lines (Credit Acc. for Non-Item Lines) G/L Account () 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

Table Relations From Other Tables

From Table From Field