Sales & 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

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]

Show/hide an example select of all columns by name

SELECT

FROM
   [CRONUS UK Ltd_$Sales & Receivables 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_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales & Receivables Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales & Receivables Setup].[Customer Nos_] = [Customer].[No_]

Show/hide columns in Sales & Receivables Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Bank Deposit Nos_ Searchnvarchar(40)
3Discount Posting Searchint
4Credit Warnings Searchint
4Post Bank Deposits as Lump Sum Searchtinyint
5Stockout Warning Searchtinyint
6Shipment on Invoice Searchtinyint
7Invoice Rounding Searchtinyint
8Ext_ Doc_ No_ Mandatory Searchtinyint
9Customer Nos_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales & Receivables Setup].[Customer Nos_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Sales & Receivables Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales & Receivables Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales & Receivables Setup].[Customer Nos_] = [Customer].[No_]
10Quote Nos_ Searchnvarchar(40)
11Order Nos_ Searchnvarchar(40)
12Invoice Nos_ Searchnvarchar(40)
13Posted Invoice Nos_ Searchnvarchar(40)
14Credit Memo Nos_ Searchnvarchar(40)
15Posted Credit Memo Nos_ Searchnvarchar(40)
16Posted Shipment Nos_ Searchnvarchar(40)
17Reminder Nos_ Searchnvarchar(40)
18Issued Reminder Nos_ Searchnvarchar(40)
19Fin_ Chrg_ Memo Nos_ Searchnvarchar(40)
20Issued Fin_ Chrg_ M_ Nos_ Searchnvarchar(40)
21Posted Prepmt_ Inv_ Nos_ Searchnvarchar(40)
22Posted Prepmt_ Cr_ Memo Nos_ Searchnvarchar(40)
23Blanket Order Nos_ Searchnvarchar(40)
24Calc_ Inv_ Discount Searchtinyint
25Appln_ between Currencies Searchint
26Copy Comments Blanket to Order Searchtinyint
27Copy Comments Order to Invoice Searchtinyint
28Copy Comments Order to Shpt_ Searchtinyint
29Allow VAT Difference Searchtinyint
30Calc_ Inv_ Disc_ per VAT ID Searchtinyint
31Logo Position on Documents Searchint
32Check Prepmt_ when Posting Searchtinyint
33Prepmt_ Auto Update Frequency Searchint
34Default Posting Date Searchint
35Default Quantity to Ship Searchint
36Archive Quotes and Orders Searchtinyint
37Post with Job Queue Searchtinyint
38Job Queue Category Code Searchnvarchar(20)
39Job Queue Priority for Post Searchint
40Post & Print with Job Queue Searchtinyint
41Job Q_ Prio_ for Post & Print Searchint
42Notify On Success Searchtinyint
43VAT Bus_ Posting Gr_ (Price) Searchnvarchar(40)
44Direct Debit Mandate Nos_ Searchnvarchar(40)
45Allow Document Deletion Before Searchdatetime
46Report Output Type Searchint
47Document Default Line Type Searchint
48Default Item Quantity Searchtinyint
49Create Item from Description Searchtinyint
50Archive Quotes Searchint
51Archive Orders Searchtinyint
52Archive Blanket Orders Searchtinyint
53Archive Return Orders Searchtinyint
54Create Item from Item No_ Searchtinyint
55Copy Customer Name to Entries Searchtinyint
56Batch Archiving Quotes Searchtinyint
57Ignore Updated Addresses Searchtinyint
58Skip Manual Reservation Searchtinyint
59Disable Search by Name Searchtinyint
60Insert Std_ Sales Lines Mode Searchint
61Insert Std_ Lines on Quotes Searchtinyint
62Insert Std_ Lines on Orders Searchtinyint
63Insert Std_ Lines on Invoices Searchtinyint
64Insert Std_ Lines on Cr_ Memos Searchtinyint
65Allow Multiple Posting Groups Searchtinyint
66Quote Validity Calculation Searchvarchar(32)
67S_ Invoice Template Name Searchnvarchar(20)
68S_ Cr_ Memo Template Name Searchnvarchar(20)
69S_ Prep_ Inv_ Template Name Searchnvarchar(20)
70S_ Prep_ Cr_Memo Template Name Searchnvarchar(20)
71IC Sales Invoice Template Name Searchnvarchar(20)
72IC Sales Cr_ Memo Templ_ Name Searchnvarchar(20)
73Fin_ Charge Jnl_ Template Name Searchnvarchar(20)
74Reminder Journal Template Name Searchnvarchar(20)
75Reminder Journal Batch Name Searchnvarchar(20)
76Copy Line Descr_ to G_L Entry Searchtinyint
77Fin_ Charge Jnl_ Batch Name Searchnvarchar(20)
78Canceled Issued Reminder Nos_ Searchnvarchar(40)
79Canc_ Iss_ Fin_ Ch_ Mem_ Nos_ Searchnvarchar(40)
80Invoice Posting Setup Searchint
81Write-in Product Type Searchint
82Write-in Product No_ Searchnvarchar(40)
83Posted Return Receipt Nos_ Searchnvarchar(40)
84Copy Cmts Ret_Ord_ to Ret_Rcpt Searchtinyint
85Copy Cmts Ret_Ord_ to Cr_ Memo Searchtinyint
86Return Order Nos_ Searchnvarchar(40)
87Return Receipt on Credit Memo Searchtinyint
88Exact Cost Reversing Mandatory Searchtinyint
89Price Calculation Method Searchint
90Price List Nos_ Searchnvarchar(40)
91Allow Editing Active Price Searchtinyint
92Default Price List Code Searchnvarchar(40)
93Customer Group Dimension Code Searchnvarchar(40)
94Salesperson Dimension Code Searchnvarchar(40)
95Freight G_L Acc_ No_ Searchnvarchar(40)
96Posting Date Check on Posting Searchtinyint
97Reverse Charge VAT Posting Gr_ Searchnvarchar(40)
98Domestic Customers Searchnvarchar(40)
99Invoice Wording Searchnvarchar(60)
100$systemId Searchuniqueidentifier
101$systemCreatedAt Searchdatetime
102$systemCreatedBy Searchuniqueidentifier
103$systemModifiedAt Searchdatetime
104$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales & Receivables Setup table

Leave a Reply

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