Purchases & Payables Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesPPurchases & 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Discount Posting SearchDiscount PostingNormalOption4Discount Postingint
Available options are:
  • “No Discounts”
  • “Invoice Discounts”
  • “Line Discounts”
  • “All Discounts”
6Receipt on Invoice SearchReceipt on InvoiceNormalBoolean4Receipt on Invoicetinyint
7Invoice Rounding SearchInvoice RoundingNormalBoolean4Invoice Roundingtinyint
8Ext. Doc. No. Mandatory SearchExt. Doc. No. MandatoryNormalBoolean4Ext_ Doc_ No_ Mandatorytinyint
9Vendor Nos. SearchVendor Nos.NormalCode20Vendor 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]
10Quote Nos. SearchQuote Nos.NormalCode20Quote 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]
11Order Nos. SearchOrder Nos.NormalCode20Order 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]
12Invoice Nos. SearchInvoice Nos.NormalCode20Invoice 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]
13Posted Invoice Nos. SearchPosted Invoice Nos.NormalCode20Posted 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]
14Credit Memo Nos. SearchCredit Memo Nos.NormalCode20Credit 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]
15Posted Credit Memo Nos. SearchPosted Credit Memo Nos.NormalCode20Posted 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]
16Posted Receipt Nos. SearchPosted Receipt Nos.NormalCode20Posted 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]
19Blanket Order Nos. SearchBlanket Order Nos.NormalCode20Blanket 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]
20Calc. Inv. Discount SearchCalc. Inv. DiscountNormalBoolean4Calc_ Inv_ Discounttinyint
21Appln. between Currencies SearchAppln. between CurrenciesNormalOption4Appln_ between Currenciesint
Available options are:
  • “None”
  • “EMU”
  • “All”
22Copy Comments Blanket to Order SearchCopy Comments Blanket to OrderNormalBoolean4Copy Comments Blanket to Ordertinyint
23Copy Comments Order to Invoice SearchCopy Comments Order to InvoiceNormalBoolean4Copy Comments Order to Invoicetinyint
24Copy Comments Order to Receipt SearchCopy Comments Order to ReceiptNormalBoolean4Copy Comments Order to Receipttinyint
25Allow VAT Difference SearchAllow Tax DifferenceNormalBoolean4Allow VAT Differencetinyint
26Calc. Inv. Disc. per VAT ID SearchCalc. Inv. Disc. per Tax IDNormalBoolean4Calc_ Inv_ Disc_ per VAT IDtinyint
27Posted Prepmt. Inv. Nos. SearchPosted Prepmt. Inv. Nos.NormalCode20Posted 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]
28Posted Prepmt. Cr. Memo Nos. SearchPosted Prepmt. Cr. Memo Nos.NormalCode20Posted 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]
29Check Prepmt. when Posting SearchCheck Prepmt. when PostingNormalBoolean4Check Prepmt_ when Postingtinyint
33Prepmt. Auto Update Frequency SearchPrepmt. Auto Update FrequencyNormalOption4Prepmt_ Auto Update Frequencyint
Available options are:
  • “Never”
  • “Daily”
  • “Weekly”
35Default Posting Date SearchDefault Posting DateNormalOption4Default Posting Dateint
Available options are:
  • “Work Date”
  • “No Date”
36Default Qty. to Receive SearchDefault Qty. to ReceiveNormalOption4Default Qty_ to Receiveint
Available options are:
  • “Remainder”
  • “Blank”
37Archive Quotes and Orders SearchArchive Quotes and OrdersNormalBoolean4Archive Quotes and Orderstinyint
38Post with Job Queue SearchPost with Job QueueNormalBoolean4Post with Job Queuetinyint
39Job Queue Category Code SearchJob Queue Category CodeNormalCode10Job Queue Category Codenvarchar(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]
40Job Queue Priority for Post SearchJob Queue Priority for PostNormalInteger4Job Queue Priority for Postint
41Post & Print with Job Queue SearchPost & Print with Job QueueNormalBoolean4Post & Print with Job Queuetinyint
42Job Q. Prio. for Post & Print SearchJob Q. Prio. for Post & PrintNormalInteger4Job Q_ Prio_ for Post & Printint
43Notify On Success SearchNotify On SuccessNormalBoolean4Notify On Successtinyint
46Allow Document Deletion Before SearchAllow Document Deletion BeforeNormalDate4Allow Document Deletion Beforedatetime
47Report Output Type SearchReport Output TypeNormalOption4Report Output Typeint
Available options are:
  • “PDF”
  • “Print”
49Document Default Line Type SearchDocument Default Line TypeNormalOption4Document Default Line Typeint
Available options are:
  • ” “
  • “G/L Account”
  • “Item”
  • “Resource”
  • “Fixed Asset”
  • “Charge (Item)”
  • “Allocation Account”
52Archive Quotes SearchArchive QuotesNormalOption4Archive Quotesint
Available options are:
  • “Never”
  • “Question”
  • “Always”
53Archive Orders SearchArchive OrdersNormalBoolean4Archive Orderstinyint
54Archive Blanket Orders SearchArchive Blanket OrdersNormalBoolean4Archive Blanket Orderstinyint
55Archive Return Orders SearchArchive Return OrdersNormalBoolean4Archive Return Orderstinyint
56Ignore Updated Addresses SearchIgnore Updated AddressesNormalBoolean4Ignore Updated Addressestinyint
57Create Item from Item No. SearchCreate Item from Item No.NormalBoolean4Create Item from Item No_tinyint
58Copy Vendor Name to Entries SearchCopy Vendor Name to EntriesNormalBoolean4Copy Vendor Name to Entriestinyint
59Copy Inv. No. To Pmt. Ref. SearchCopy Invoice No. To Payment ReferenceNormalBoolean4Copy Inv_ No_ To Pmt_ Ref_tinyint
160Disable Search by Name SearchDisable Search by NameNormalBoolean4Disable Search by Nametinyint
170Insert Std. Purch. Lines Mode SearchInsert Std. Purch. Lines ModeNormalOption4Insert Std_ Purch_ Lines Modeint
Available options are:
  • “Manual”
  • “Automatic”
  • “Always Ask”
171Insert Std. Lines on Quotes SearchInsert Std. Lines on QuotesNormalBoolean4Insert Std_ Lines on Quotestinyint
172Insert Std. Lines on Orders SearchInsert Std. Lines on OrdersNormalBoolean4Insert Std_ Lines on Orderstinyint
173Insert Std. Lines on Invoices SearchInsert Std. Lines on InvoicesNormalBoolean4Insert Std_ Lines on Invoicestinyint
174Insert Std. Lines on Cr. Memos SearchInsert Std. Lines on Cr. MemosNormalBoolean4Insert Std_ Lines on Cr_ Memostinyint
175Allow Multiple Posting Groups SearchAllow Multiple Posting GroupsNormalBoolean4Allow Multiple Posting Groupstinyint
176Check Multiple Posting Groups SearchCheck Multiple Posting GroupsNormalOption4Check Multiple Posting Groupsint
Available options are:
  • “Alternative Groups”
200P. Invoice Template Name SearchPurch. Invoice Template NameNormalCode10P_ Invoice Template Namenvarchar(20)
201P. Cr. Memo Template Name SearchPurch. Cr. Memo Template NameNormalCode10P_ Cr_ Memo Template Namenvarchar(20)
202P. Prep. Inv. Template Name SearchP. Prep. Invoice Template NameNormalCode10P_ Prep_ Inv_ Template Namenvarchar(20)
203P. Prep. Cr.Memo Template Name SearchPurch. Prep. Cr. Memo Template NameNormalCode10P_ Prep_ Cr_Memo Template Namenvarchar(20)
204IC Purch. Invoice Templ. Name SearchIC Jnl. Templ. Purch. InvoiceNormalCode10IC Purch_ Invoice Templ_ Namenvarchar(20)
205IC Purch. Cr. Memo Templ. Name SearchIC Jnl. Templ. Purch. Cr. MemoNormalCode10IC Purch_ Cr_ Memo Templ_ Namenvarchar(20)
210Copy Line Descr. to G/L Entry SearchCopy Line Descr. to G/L EntryNormalBoolean4Copy Line Descr_ to G_L Entrytinyint
810Invoice Posting Setup SearchInvoice Posting SetupNormalOption4Invoice Posting Setupint
Available options are:
  • “Invoice Posting (Default)”
  • “Invoice Posting (v.19)”
1217Debit Acc. for Non-Item Lines SearchDebit Acc. for Non-Item LinesNormalCode20Debit Acc_ for Non-Item Linesnvarchar(40)
1218Credit Acc. for Non-Item Lines SearchCredit Acc. for Non-Item LinesNormalCode20Credit Acc_ for Non-Item Linesnvarchar(40)
5775Auto Post Non-Invt. via Whse. SearchAuto Post Non-Invt. via Whse.NormalOption4Auto Post Non-Invt_ via Whse_int
Available options are:
  • “None”
  • “Attached/Assigned”
  • “All”
5800Posted Return Shpt. Nos. SearchPosted Return Shpt. Nos.NormalCode20Posted 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]
5801Copy Cmts Ret.Ord. to Ret.Shpt SearchCopy Cmts Ret.Ord. to Ret.ShptNormalBoolean4Copy Cmts Ret_Ord_ to Ret_Shpttinyint
5802Copy Cmts Ret.Ord. to Cr. Memo SearchCopy Cmts Ret.Ord. to Cr. MemoNormalBoolean4Copy Cmts Ret_Ord_ to Cr_ Memotinyint
6600Return Order Nos. SearchReturn Order Nos.NormalCode20Return 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]
6601Return Shipment on Credit Memo SearchReturn Shipment on Credit MemoNormalBoolean4Return Shipment on Credit Memotinyint
6602Exact Cost Reversing Mandatory SearchExact Cost Reversing MandatoryNormalBoolean4Exact Cost Reversing Mandatorytinyint
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7001Price List Nos. SearchPrice List Nos.NormalCode20Price 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]
7002Allow Editing Active Price SearchAllow Editing Active PriceNormalBoolean4Allow Editing Active Pricetinyint
7003Default Price List Code SearchDefault Price List CodeNormalCode20Default Price List Codenvarchar(40)
7004Link Doc. Date To Posting Date SearchLink Doc. Date to Posting DateNormalBoolean4Link Doc_ Date To Posting Datetinyint
10000Combine Special Orders Default SearchCombine Special Orders DefaultNormalOption4
10001Use Vendor’s Tax Area Code SearchUse Vendor’s Tax Area CodeNormalBoolean4
10017IRS 1096 Form No. Series SearchIRS 1096 Form No. SeriesNormalCode20
27030Default Vendor DIOT Type SearchDefault Vendor DIOT TypeNormalOption4
27040DIOT Default Vendor Type SearchDefault Vendor DIOT TypeNormalOption4
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Purchases & Payables Setup].[$systemModifiedBy]
       ,[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].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesPPurchases & Payables Setup

Leave a Reply

Your email address will not be published. Required fields are marked *