Sales & Receivables Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesSSales & Receivables Setup

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

Table Type: Company

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

Table Number: 311

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 Sales & Receivables Setup can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

Show/hide an example select of all columns by name

SELECT



FROM

   [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

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

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

Show/hide columns in Sales & Receivables 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”
4Credit Warnings SearchCredit WarningsNormalOption4Credit Warningsint
Available options are:
  • “Both Warnings”
  • “Credit Limit”
  • “Overdue Balance”
  • “No Warning”
5Stockout Warning SearchStockout WarningNormalBoolean4Stockout Warningtinyint
6Shipment on Invoice SearchShipment on InvoiceNormalBoolean4Shipment on Invoicetinyint
7Invoice Rounding SearchInvoice RoundingNormalBoolean4Invoice Roundingtinyint
8Ext. Doc. No. Mandatory SearchExt. Doc. No. MandatoryNormalBoolean4Ext_ Doc_ No_ Mandatorytinyint
9Customer Nos. SearchCustomer Nos.NormalCode20Customer Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Customer Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Customer 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
       [Sales & Receivables Setup].[Quote Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables 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
       [Sales & Receivables Setup].[Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables 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
       [Sales & Receivables Setup].[Invoice Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables 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
       [Sales & Receivables Setup].[Posted Invoice Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables 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
       [Sales & Receivables Setup].[Credit Memo Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables 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
       [Sales & Receivables Setup].[Posted Credit Memo Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Posted Credit Memo Nos_] = [No. Series].[Code]
16Posted Shipment Nos. SearchPosted Shipment Nos.NormalCode20Posted Shipment Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Posted Shipment Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Posted Shipment Nos_] = [No. Series].[Code]
17Reminder Nos. SearchReminder Nos.NormalCode20Reminder Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Reminder Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Reminder Nos_] = [No. Series].[Code]
18Issued Reminder Nos. SearchIssued Reminder Nos.NormalCode20Issued Reminder Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Issued Reminder Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Issued Reminder Nos_] = [No. Series].[Code]
19Fin. Chrg. Memo Nos. SearchFin. Chrg. Memo Nos.NormalCode20Fin_ Chrg_ Memo Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Fin_ Chrg_ Memo Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Fin_ Chrg_ Memo Nos_] = [No. Series].[Code]
20Issued Fin. Chrg. M. Nos. SearchIssued Fin. Chrg. M. Nos.NormalCode20Issued Fin_ Chrg_ M_ Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Issued Fin_ Chrg_ M_ Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Issued Fin_ Chrg_ M_ Nos_] = [No. Series].[Code]
21Posted 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
       [Sales & Receivables Setup].[Posted Prepmt_ Inv_ Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Posted Prepmt_ Inv_ Nos_] = [No. Series].[Code]
22Posted 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
       [Sales & Receivables Setup].[Posted Prepmt_ Cr_ Memo Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Posted Prepmt_ Cr_ Memo Nos_] = [No. Series].[Code]
23Blanket Order Nos. SearchBlanket Order Nos.NormalCode20Blanket Order Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Blanket Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Blanket Order Nos_] = [No. Series].[Code]
24Calc. Inv. Discount SearchCalc. Inv. DiscountNormalBoolean4Calc_ Inv_ Discounttinyint
25Appln. between Currencies SearchAppln. between CurrenciesNormalOption4Appln_ between Currenciesint
Available options are:
  • “None”
  • “EMU”
  • “All”
26Copy Comments Blanket to Order SearchCopy Comments Blanket to OrderNormalBoolean4Copy Comments Blanket to Ordertinyint
27Copy Comments Order to Invoice SearchCopy Comments Order to InvoiceNormalBoolean4Copy Comments Order to Invoicetinyint
28Copy Comments Order to Shpt. SearchCopy Comments Order to Shpt.NormalBoolean4Copy Comments Order to Shpt_tinyint
29Allow VAT Difference SearchAllow Tax DifferenceNormalBoolean4Allow VAT Differencetinyint
30Calc. Inv. Disc. per VAT ID SearchCalc. Inv. Disc. per Tax IDNormalBoolean4Calc_ Inv_ Disc_ per VAT IDtinyint
31Logo Position on Documents SearchLogo Position on DocumentsNormalOption4Logo Position on Documentsint
Available options are:
  • “No Logo”
  • “Left”
  • “Center”
  • “Right”
32Check 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 Quantity to Ship SearchDefault Quantity to ShipNormalOption4Default Quantity to Shipint
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
       [Sales & Receivables Setup].[Job Queue Category Code]
       ,[Job Queue Category].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Job Queue Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Queue Category]
              ON
                     [Sales & Receivables 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
44VAT Bus. Posting Gr. (Price) SearchTax Bus. Posting Gr. (Price)NormalCode20VAT Bus_ Posting Gr_ (Price)nvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[VAT Bus_ Posting Gr_ (Price)]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Sales & Receivables Setup].[VAT Bus_ Posting Gr_ (Price)] = [VAT Business Posting Group].[Code]
45Direct Debit Mandate Nos. SearchDirect Debit Mandate Nos.NormalCode20Direct Debit Mandate Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Direct Debit Mandate Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Direct Debit Mandate Nos_] = [No. Series].[Code]
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”
50Default Item Quantity SearchDefault Item QuantityNormalBoolean4Default Item Quantitytinyint
51Create Item from Description SearchCreate Item from DescriptionNormalBoolean4Create Item from Descriptiontinyint
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
57Create Item from Item No. SearchCreate Item from Item No.NormalBoolean4Create Item from Item No_tinyint
58Copy Customer Name to Entries SearchCopy Customer Name to EntriesNormalBoolean4Copy Customer Name to Entriestinyint
60Batch Archiving Quotes SearchBatch Archiving QuotesNormalBoolean4Batch Archiving Quotestinyint
61Ignore Updated Addresses SearchIgnore Updated AddressesNormalBoolean4Ignore Updated Addressestinyint
65Skip Manual Reservation SearchSkip Manual ReservationNormalBoolean4Skip Manual Reservationtinyint
160Disable Search by Name SearchDisable Search by NameNormalBoolean4Disable Search by Nametinyint
170Insert Std. Sales Lines Mode SearchInsert Std. Sales Lines ModeNormalOption4Insert Std_ Sales 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”
200Quote Validity Calculation SearchQuote Validity CalculationNormalDateFormula32Quote Validity Calculationvarchar(32)
201S. Invoice Template Name SearchSales Invoice Journal TemplateNormalCode10S_ Invoice Template Namenvarchar(20)
202S. Cr. Memo Template Name SearchSales Cr. Memo Journal TemplateNormalCode10S_ Cr_ Memo Template Namenvarchar(20)
203S. Prep. Inv. Template Name SearchSales Prep. Invoice Template NameNormalCode10S_ Prep_ Inv_ Template Namenvarchar(20)
204S. Prep. Cr.Memo Template Name SearchSales Prep. Cr. Memo Template NameNormalCode10S_ Prep_ Cr_Memo Template Namenvarchar(20)
205IC Sales Invoice Template Name SearchIC Sales Invoice Template NameNormalCode10IC Sales Invoice Template Namenvarchar(20)
206IC Sales Cr. Memo Templ. Name SearchIC Sales Cr. Memo Template NameNormalCode10IC Sales Cr_ Memo Templ_ Namenvarchar(20)
207Fin. Charge Jnl. Template Name SearchFinance Charge Journal Template NameNormalCode10Fin_ Charge Jnl_ Template Namenvarchar(20)
208Reminder Journal Template Name SearchReminder Journal Template NameNormalCode10Reminder Journal Template Namenvarchar(20)
209Reminder Journal Batch Name SearchReminder Journal Batch NameNormalCode10Reminder Journal Batch Namenvarchar(20)
210Copy Line Descr. to G/L Entry SearchCopy Line Descr. to G/L EntryNormalBoolean4Copy Line Descr_ to G_L Entrytinyint
211Fin. Charge Jnl. Batch Name SearchFinance Charge Journal Batch NameNormalCode10Fin_ Charge Jnl_ Batch Namenvarchar(20)
393Canceled Issued Reminder Nos. SearchCanceled Issued Reminder Nos.NormalCode20Canceled Issued Reminder Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Canceled Issued Reminder Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Canceled Issued Reminder Nos_] = [No. Series].[Code]
395Canc. Iss. Fin. Ch. Mem. Nos. SearchCanceled Issued Fin. Charge Memo Nos.NormalCode20Canc_ Iss_ Fin_ Ch_ Mem_ Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Canc_ Iss_ Fin_ Ch_ Mem_ Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Canc_ Iss_ Fin_ Ch_ Mem_ Nos_] = [No. Series].[Code]
810Invoice Posting Setup SearchInvoice Posting SetupNormalOption4Invoice Posting Setupint
Available options are:
  • “Invoice Posting (Default)”
  • “Invoice Posting (v.19)”
1690Bank Deposit Nos. SearchBank Deposit Nos.NormalCode20
1691Post Bank Deposits as Lump Sum SearchPost Bank Deposits as Lump SumNormalBoolean4
5329Write-in Product Type SearchWrite-in Product TypeNormalOption4Write-in Product Typeint
Available options are:
  • “Item”
  • “Resource”
5330Write-in Product No. SearchWrite-in Product No.NormalCode20Write-in Product No_nvarchar(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 Receipt Nos. SearchPosted Return Receipt Nos.NormalCode20Posted Return Receipt Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Posted Return Receipt Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Posted Return Receipt Nos_] = [No. Series].[Code]
5801Copy Cmts Ret.Ord. to Ret.Rcpt SearchCopy Cmts Ret.Ord. to Ret.RcptNormalBoolean4Copy Cmts Ret_Ord_ to Ret_Rcpttinyint
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
       [Sales & Receivables Setup].[Return Order Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables Setup].[Return Order Nos_] = [No. Series].[Code]
6601Return Receipt on Credit Memo SearchReturn Receipt on Credit MemoNormalBoolean4Return Receipt 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
       [Sales & Receivables Setup].[Price List Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales & Receivables 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)
7005Use Customized Lookup SearchUse Your Custom LookupNormalBoolean4Use Customized Lookuptinyint
7101Customer Group Dimension Code SearchCustomer Group Dimension CodeNormalCode20Customer Group Dimension Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Customer Group Dimension Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Sales & Receivables Setup].[Customer Group Dimension Code] = [Dimension].[Code]
7102Salesperson Dimension Code SearchSalesperson Dimension CodeNormalCode20Salesperson Dimension Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Salesperson Dimension Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Sales & Receivables Setup].[Salesperson Dimension Code] = [Dimension].[Code]
7103Freight G/L Acc. No. SearchFreight G/L Account No.NormalCode20Freight G_L Acc_ No_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Freight G_L Acc_ No_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Sales & Receivables Setup].[Freight G_L Acc_ No_] = [G/L Account].[No_]
7104Link Doc. Date To Posting Date SearchLink Doc. Date to Posting DateNormalBoolean4Link Doc_ Date To Posting Datetinyint
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
       [Sales & Receivables Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Sales & Receivables 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
       [Sales & Receivables Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Sales & Receivables Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [Sales & Receivables Setup].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesSSales & Receivables Setup

Leave a Reply

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