Purchases & Payables Setup – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPurchases & Payables Setup

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/312

Table Type: Company

Table Name: Purchases & Payables Setup
Database Table Name: CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 312

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Purchases & Payables Setup can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT



FROM

   [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Job Queue Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Category]
      ON
         [Purchases & Payables Setup].[Job Queue Category Code] = [Job Queue Category].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Purchases & Payables Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Purchases & Payables Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Purchases & Payables Setup table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Primary Key	Primary Key	Normal	Code	10	Primary Key	nvarchar(20)
2	Discount Posting	Discount Posting	Normal	Option	4	Discount Posting	int
	Available options are: “No Discounts” “Invoice Discounts” “Line Discounts” “All Discounts”
6	Receipt on Invoice	Receipt on Invoice	Normal	Boolean	4	Receipt on Invoice	tinyint
7	Invoice Rounding	Invoice Rounding	Normal	Boolean	4	Invoice Rounding	tinyint
8	Ext. Doc. No. Mandatory	Ext. Doc. No. Mandatory	Normal	Boolean	4	Ext_ Doc_ No_ Mandatory	tinyint
9	Vendor Nos.	Vendor Nos.	Normal	Code	20	Vendor Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Vendor Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Vendor Nos_] = [No. Series].[Code]
10	Quote Nos.	Quote Nos.	Normal	Code	20	Quote Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Quote Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Quote Nos_] = [No. Series].[Code]
11	Order Nos.	Order Nos.	Normal	Code	20	Order Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Order Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Order Nos_] = [No. Series].[Code]
12	Invoice Nos.	Invoice Nos.	Normal	Code	20	Invoice Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Invoice Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Invoice Nos_] = [No. Series].[Code]
13	Posted Invoice Nos.	Posted Invoice Nos.	Normal	Code	20	Posted Invoice Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Posted Invoice Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Posted Invoice Nos_] = [No. Series].[Code]
14	Credit Memo Nos.	Credit Memo Nos.	Normal	Code	20	Credit Memo Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Credit Memo Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Credit Memo Nos_] = [No. Series].[Code]
15	Posted Credit Memo Nos.	Posted Credit Memo Nos.	Normal	Code	20	Posted Credit Memo Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Posted Credit Memo Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Posted Credit Memo Nos_] = [No. Series].[Code]
16	Posted Receipt Nos.	Posted Receipt Nos.	Normal	Code	20	Posted Receipt Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Posted Receipt Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Posted Receipt Nos_] = [No. Series].[Code]
19	Blanket Order Nos.	Blanket Order Nos.	Normal	Code	20	Blanket Order Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Blanket Order Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Blanket Order Nos_] = [No. Series].[Code]
20	Calc. Inv. Discount	Calc. Inv. Discount	Normal	Boolean	4	Calc_ Inv_ Discount	tinyint
21	Appln. between Currencies	Appln. between Currencies	Normal	Option	4	Appln_ between Currencies	int
	Available options are: “None” “EMU” “All”
22	Copy Comments Blanket to Order	Copy Comments Blanket to Order	Normal	Boolean	4	Copy Comments Blanket to Order	tinyint
23	Copy Comments Order to Invoice	Copy Comments Order to Invoice	Normal	Boolean	4	Copy Comments Order to Invoice	tinyint
24	Copy Comments Order to Receipt	Copy Comments Order to Receipt	Normal	Boolean	4	Copy Comments Order to Receipt	tinyint
25	Allow VAT Difference	Allow Tax Difference	Normal	Boolean	4	Allow VAT Difference	tinyint
26	Calc. Inv. Disc. per VAT ID	Calc. Inv. Disc. per Tax ID	Normal	Boolean	4	Calc_ Inv_ Disc_ per VAT ID	tinyint
27	Posted Prepmt. Inv. Nos.	Posted Prepmt. Inv. Nos.	Normal	Code	20	Posted Prepmt_ Inv_ Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Posted Prepmt_ Inv_ Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Posted Prepmt_ Inv_ Nos_] = [No. Series].[Code]
28	Posted Prepmt. Cr. Memo Nos.	Posted Prepmt. Cr. Memo Nos.	Normal	Code	20	Posted Prepmt_ Cr_ Memo Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Posted Prepmt_ Cr_ Memo Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Posted Prepmt_ Cr_ Memo Nos_] = [No. Series].[Code]
29	Check Prepmt. when Posting	Check Prepmt. when Posting	Normal	Boolean	4	Check Prepmt_ when Posting	tinyint
33	Prepmt. Auto Update Frequency	Prepmt. Auto Update Frequency	Normal	Option	4	Prepmt_ Auto Update Frequency	int
	Available options are: “Never” “Daily” “Weekly”
35	Default Posting Date	Default Posting Date	Normal	Option	4	Default Posting Date	int
	Available options are: “Work Date” “No Date”
36	Default Qty. to Receive	Default Qty. to Receive	Normal	Option	4	Default Qty_ to Receive	int
	Available options are: “Remainder” “Blank”
37	Archive Quotes and Orders	Archive Quotes and Orders	Normal	Boolean	4	Archive Quotes and Orders	tinyint
38	Post with Job Queue	Post with Job Queue	Normal	Boolean	4	Post with Job Queue	tinyint
39	Job Queue Category Code	Job Queue Category Code	Normal	Code	10	Job Queue Category Code	nvarchar(20)
	Key to join to the Job Queue Category table. Show/hide example query SELECT [Purchases & Payables Setup].[Job Queue Category Code] ,[Job Queue Category].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$Job Queue Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Category] ON [Purchases & Payables Setup].[Job Queue Category Code] = [Job Queue Category].[Code]
40	Job Queue Priority for Post	Job Queue Priority for Post	Normal	Integer	4	Job Queue Priority for Post	int
41	Post & Print with Job Queue	Post & Print with Job Queue	Normal	Boolean	4	Post & Print with Job Queue	tinyint
42	Job Q. Prio. for Post & Print	Job Q. Prio. for Post & Print	Normal	Integer	4	Job Q_ Prio_ for Post & Print	int
43	Notify On Success	Notify On Success	Normal	Boolean	4	Notify On Success	tinyint
46	Allow Document Deletion Before	Allow Document Deletion Before	Normal	Date	4	Allow Document Deletion Before	datetime
47	Report Output Type	Report Output Type	Normal	Option	4	Report Output Type	int
	Available options are: “PDF” “Print”
49	Document Default Line Type	Document Default Line Type	Normal	Option	4	Document Default Line Type	int
	Available options are: ” “ “G/L Account” “Item” “Resource” “Fixed Asset” “Charge (Item)” “Allocation Account”
52	Archive Quotes	Archive Quotes	Normal	Option	4	Archive Quotes	int
	Available options are: “Never” “Question” “Always”
53	Archive Orders	Archive Orders	Normal	Boolean	4	Archive Orders	tinyint
54	Archive Blanket Orders	Archive Blanket Orders	Normal	Boolean	4	Archive Blanket Orders	tinyint
55	Archive Return Orders	Archive Return Orders	Normal	Boolean	4	Archive Return Orders	tinyint
56	Ignore Updated Addresses	Ignore Updated Addresses	Normal	Boolean	4	Ignore Updated Addresses	tinyint
57	Create Item from Item No.	Create Item from Item No.	Normal	Boolean	4	Create Item from Item No_	tinyint
58	Copy Vendor Name to Entries	Copy Vendor Name to Entries	Normal	Boolean	4	Copy Vendor Name to Entries	tinyint
59	Copy Inv. No. To Pmt. Ref.	Copy Invoice No. To Payment Reference	Normal	Boolean	4	Copy Inv_ No_ To Pmt_ Ref_	tinyint
160	Disable Search by Name	Disable Search by Name	Normal	Boolean	4	Disable Search by Name	tinyint
170	Insert Std. Purch. Lines Mode	Insert Std. Purch. Lines Mode	Normal	Option	4	Insert Std_ Purch_ Lines Mode	int
	Available options are: “Manual” “Automatic” “Always Ask”
171	Insert Std. Lines on Quotes	Insert Std. Lines on Quotes	Normal	Boolean	4	Insert Std_ Lines on Quotes	tinyint
172	Insert Std. Lines on Orders	Insert Std. Lines on Orders	Normal	Boolean	4	Insert Std_ Lines on Orders	tinyint
173	Insert Std. Lines on Invoices	Insert Std. Lines on Invoices	Normal	Boolean	4	Insert Std_ Lines on Invoices	tinyint
174	Insert Std. Lines on Cr. Memos	Insert Std. Lines on Cr. Memos	Normal	Boolean	4	Insert Std_ Lines on Cr_ Memos	tinyint
175	Allow Multiple Posting Groups	Allow Multiple Posting Groups	Normal	Boolean	4	Allow Multiple Posting Groups	tinyint
176	Check Multiple Posting Groups	Check Multiple Posting Groups	Normal	Option	4	Check Multiple Posting Groups	int
	Available options are: “Alternative Groups”
200	P. Invoice Template Name	Purch. Invoice Template Name	Normal	Code	10	P_ Invoice Template Name	nvarchar(20)
201	P. Cr. Memo Template Name	Purch. Cr. Memo Template Name	Normal	Code	10	P_ Cr_ Memo Template Name	nvarchar(20)
202	P. Prep. Inv. Template Name	P. Prep. Invoice Template Name	Normal	Code	10	P_ Prep_ Inv_ Template Name	nvarchar(20)
203	P. Prep. Cr.Memo Template Name	Purch. Prep. Cr. Memo Template Name	Normal	Code	10	P_ Prep_ Cr_Memo Template Name	nvarchar(20)
204	IC Purch. Invoice Templ. Name	IC Jnl. Templ. Purch. Invoice	Normal	Code	10	IC Purch_ Invoice Templ_ Name	nvarchar(20)
205	IC Purch. Cr. Memo Templ. Name	IC Jnl. Templ. Purch. Cr. Memo	Normal	Code	10	IC Purch_ Cr_ Memo Templ_ Name	nvarchar(20)
210	Copy Line Descr. to G/L Entry	Copy Line Descr. to G/L Entry	Normal	Boolean	4	Copy Line Descr_ to G_L Entry	tinyint
810	Invoice Posting Setup	Invoice Posting Setup	Normal	Option	4	Invoice Posting Setup	int
	Available options are: “Invoice Posting (Default)” “Invoice Posting (v.19)”
1217	Debit Acc. for Non-Item Lines	Debit Acc. for Non-Item Lines	Normal	Code	20	Debit Acc_ for Non-Item Lines	nvarchar(40)
1218	Credit Acc. for Non-Item Lines	Credit Acc. for Non-Item Lines	Normal	Code	20	Credit Acc_ for Non-Item Lines	nvarchar(40)
5775	Auto Post Non-Invt. via Whse.	Auto Post Non-Invt. via Whse.	Normal	Option	4	Auto Post Non-Invt_ via Whse_	int
	Available options are: “None” “Attached/Assigned” “All”
5800	Posted Return Shpt. Nos.	Posted Return Shpt. Nos.	Normal	Code	20	Posted Return Shpt_ Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Posted Return Shpt_ Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Posted Return Shpt_ Nos_] = [No. Series].[Code]
5801	Copy Cmts Ret.Ord. to Ret.Shpt	Copy Cmts Ret.Ord. to Ret.Shpt	Normal	Boolean	4	Copy Cmts Ret_Ord_ to Ret_Shpt	tinyint
5802	Copy Cmts Ret.Ord. to Cr. Memo	Copy Cmts Ret.Ord. to Cr. Memo	Normal	Boolean	4	Copy Cmts Ret_Ord_ to Cr_ Memo	tinyint
6600	Return Order Nos.	Return Order Nos.	Normal	Code	20	Return Order Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Return Order Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Return Order Nos_] = [No. Series].[Code]
6601	Return Shipment on Credit Memo	Return Shipment on Credit Memo	Normal	Boolean	4	Return Shipment on Credit Memo	tinyint
6602	Exact Cost Reversing Mandatory	Exact Cost Reversing Mandatory	Normal	Boolean	4	Exact Cost Reversing Mandatory	tinyint
7000	Price Calculation Method	Price Calculation Method	Normal	Option	4	Price Calculation Method	int
	Available options are: ” “ “Lowest Price”
7001	Price List Nos.	Price List Nos.	Normal	Code	20	Price List Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[Price List Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[Price List Nos_] = [No. Series].[Code]
7002	Allow Editing Active Price	Allow Editing Active Price	Normal	Boolean	4	Allow Editing Active Price	tinyint
7003	Default Price List Code	Default Price List Code	Normal	Code	20	Default Price List Code	nvarchar(40)
7004	Link Doc. Date To Posting Date	Link Doc. Date to Posting Date	Normal	Boolean	4	Link Doc_ Date To Posting Date	tinyint
10000	Combine Special Orders Default	Combine Special Orders Default	Normal	Option	4
10001	Use Vendor’s Tax Area Code	Use Vendor’s Tax Area Code	Normal	Boolean	4
10017	IRS 1096 Form No. Series	IRS 1096 Form No. Series	Normal	Code	20
	Key to join to the No. Series table. Show/hide example query SELECT [Purchases & Payables Setup].[] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Purchases & Payables Setup].[] = [No. Series].[Code]
27030	Default Vendor DIOT Type	Default Vendor DIOT Type	Normal	Option	4
27040	DIOT Default Vendor Type	Default Vendor DIOT Type	Normal	Option	4
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Purchases & Payables Setup].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Purchases & Payables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchases & Payables Setup] LEFT JOIN [User] AS [User] ON [Purchases & Payables Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Dynamics 365 BC Table Reference Tables Company Tables PPurchases & Payables Setup

Leave a Reply Cancel reply