Purchases & Payables Setup #312

Setup table in Microsoft Dynamics 365 Business Central. 82 fields, 1 records in Cronus demo.

The Purchases & Payables Setup table (ID 312) is part of the Setup area in Microsoft Dynamics 365 Business Central. It contains 82 fields, with a primary key of Primary Key. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Primary Key.

All fields (82)

Purchases & Payables Setup — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Primary Key PK	Code	Normal
2	Discount Posting	Option	Normal
6	Receipt on Invoice	Boolean	Normal
7	Invoice Rounding	Boolean	Normal
8	Ext. Doc. No. Mandatory	Boolean	Normal
9	Vendor Nos.	Code	Normal	→ No. Series #308
10	Quote Nos.	Code	Normal	→ No. Series #308
11	Order Nos.	Code	Normal	→ No. Series #308
12	Invoice Nos.	Code	Normal	→ No. Series #308
13	Posted Invoice Nos.	Code	Normal	→ No. Series #308
14	Credit Memo Nos.	Code	Normal	→ No. Series #308
15	Posted Credit Memo Nos.	Code	Normal	→ No. Series #308
16	Posted Receipt Nos.	Code	Normal	→ No. Series #308
19	Blanket Order Nos.	Code	Normal	→ No. Series #308
20	Calc. Inv. Discount	Boolean	Normal
21	Appln. between Currencies	Option	Normal
22	Copy Comments Blanket to Order	Boolean	Normal
23	Copy Comments Order to Invoice	Boolean	Normal
24	Copy Comments Order to Receipt	Boolean	Normal
25	Allow VAT Difference	Boolean	Normal
26	Calc. Inv. Disc. per VAT ID	Boolean	Normal
27	Posted Prepmt. Inv. Nos.	Code	Normal	→ No. Series #308
28	Posted Prepmt. Cr. Memo Nos.	Code	Normal	→ No. Series #308
29	Check Prepmt. when Posting	Boolean	Normal
33	Prepmt. Auto Update Frequency	Option	Normal
35	Default Posting Date	Option	Normal
36	Default Qty. to Receive	Option	Normal
38	Post with Job Queue	Boolean	Normal
39	Job Queue Category Code	Code	Normal	→ Job Queue Category #471
40	Job Queue Priority for Post	Integer	Normal
41	Post & Print with Job Queue	Boolean	Normal
42	Job Q. Prio. for Post & Print	Integer	Normal
43	Notify On Success	Boolean	Normal
46	Allow Document Deletion Before	Date	Normal
47	Report Output Type	Option	Normal
49	Document Default Line Type	Option	Normal
51	Default G/L Account Quantity	Boolean	Normal
52	Archive Quotes	Option	Normal
53	Archive Orders	Boolean	Normal
54	Archive Blanket Orders	Boolean	Normal
55	Archive Return Orders	Boolean	Normal
56	Ignore Updated Addresses	Boolean	Normal
57	Create Item from Item No.	Boolean	Normal
58	Copy Vendor Name to Entries	Boolean	Normal
59	Copy Invoice No. To Payment Reference	Boolean	Normal
160	Disable Search by Name	Boolean	Normal
175	Allow Multiple Posting Groups	Boolean	Normal
176	Check Multiple Posting Groups	Option	Normal
200	Purch. Invoice Template Name	Code	Normal	→ Gen. Journal Template #80
201	Purch. Cr. Memo Template Name	Code	Normal	→ Gen. Journal Template #80
202	P. Prep. Invoice Template Name	Code	Normal	→ Gen. Journal Template #80
203	Purch. Prep. Cr. Memo Template Name	Code	Normal	→ Gen. Journal Template #80
204	IC Jnl. Templ. Purch. Invoice	Code	Normal	→ Gen. Journal Template #80
205	IC Jnl. Templ. Purch. Cr. Memo	Code	Normal	→ Gen. Journal Template #80
210	Copy Line Descr. to G/L Entry	Boolean	Normal
1217	Debit Acc. for Non-Item Lines	Code	Normal	→ G/L Account #15
1218	Credit Acc. for Non-Item Lines	Code	Normal	→ G/L Account #15
5775	Auto Post Non-Invt. via Whse.	Option	Normal
5800	Posted Return Shpt. Nos.	Code	Normal	→ No. Series #308
5801	Copy Cmts Ret.Ord. to Ret.Shpt	Boolean	Normal
5802	Copy Cmts Ret.Ord. to Cr. Memo	Boolean	Normal
6100	E-Document Matching Difference %	Decimal	Normal
6101	E-Document Learn Copilot Matchings	Boolean	Normal
6600	Return Order Nos.	Code	Normal	→ No. Series #308
6601	Return Shipment on Credit Memo	Boolean	Normal
6602	Exact Cost Reversing Mandatory	Boolean	Normal
7000	Price Calculation Method	Option	Normal
7001	Price List Nos.	Code	Normal	→ No. Series #308
7002	Allow Editing Active Price	Boolean	Normal
7003	Default Price List Code	Code	Normal	→ Price List Header #7000
7004	Link Doc. Date to Posting Date	Boolean	Normal
10500	Posting Date Check on Posting	Boolean	Normal
10501	Reverse Charge VAT Posting Gr.	Code	Normal	→ VAT Business Posting Group #323
10502	Domestic Vendors	Code	Normal	→ VAT Business Posting Group #323
10507	Reverse Charge VAT Posting Gr.	Code	Normal	→ VAT Business Posting Group #323
10508	Domestic Vendors	Code	Normal	→ VAT Business Posting Group #323
11320	Check Doc. Total Amounts	Boolean	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (7)

Tables referenced by fields on the Purchases & Payables Setup table through TableRelation properties.

No. Series

#308 · Other · via 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., Price List Nos.

Job Queue Category

#471 · Other · via Job Queue Category Code

Gen. Journal Template

#80 · Other · via Purch. Invoice Template Name, Purch. Cr. Memo Template Name, P. Prep. Invoice Template Name, Purch. Prep. Cr. Memo Template Name, IC Jnl. Templ. Purch. Invoice, IC Jnl. Templ. Purch. Cr. Memo

G/L Account

#15 · General Ledger · via Debit Acc. for Non-Item Lines, Credit Acc. for Non-Item Lines

Price List Header

#7000 · Pricing & Discounts · via Default Price List Code

VAT Business Posting Group

#323 · Other · via Reverse Charge VAT Posting Gr., Domestic Vendors, Reverse Charge VAT Posting Gr., Domestic Vendors