Sales Quote Entity Buffer

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

Table Type: Company

Table Name: Sales Quote Entity Buffer
Database Table Name: CRONUS UK Ltd_$Sales Quote Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 Quote Entity Buffer can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Sales Quote Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Document Type]
   ,[Sell-to Customer No_]
   ,[Bill-to Customer No_]
   ,[Bill-to Name]
   ,[Bill-to Address]
   ,[Bill-to Address 2]
   ,[Bill-to City]
   ,[Bill-to Contact]
   ,[Your Reference]
   ,[Ship-to Code]
   ,[Ship-to Name]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Contact]
   ,[Posting Date]
   ,[Payment Terms Code]
   ,[Due Date]
   ,[Shipment Method Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Customer Posting Group]
   ,[Currency Code]
   ,[Prices Including VAT]
   ,[Salesperson Code]
   ,[Amount]
   ,[Amount Including VAT]
   ,[VAT Registration No_]
   ,[Sell-to Customer Name]
   ,[Sell-to Address]
   ,[Sell-to Address 2]
   ,[Sell-to City]
   ,[Sell-to Contact]
   ,[Bill-to Post Code]
   ,[Bill-to County]
   ,[Bill-to Country_Region Code]
   ,[Sell-to Post Code]
   ,[Sell-to County]
   ,[Sell-to Country_Region Code]
   ,[Ship-to Post Code]
   ,[Ship-to County]
   ,[Ship-to Country_Region Code]
   ,[Document Date]
   ,[External Document No_]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[Invoice Discount Calculation]
   ,[Invoice Discount Value]
   ,[Quote Valid Until Date]
   ,[Quote Sent to Customer]
   ,[Quote Accepted]
   ,[Quote Accepted Date]
   ,[Last Email Sent Status]
   ,[Sell-to Phone No_]
   ,[Sell-to E-Mail]
   ,[Cust_ Ledger Entry No_]
   ,[Invoice Discount Amount]
   ,[Sell-to Contact No_]
   ,[Id]
   ,[Total Tax Amount]
   ,[Status]
   ,[Posted]
   ,[Subtotal Amount]
   ,[Discount Applied Before Tax]
   ,[Last Modified Date Time]
   ,[Customer Id]
   ,[Contact Graph Id]
   ,[Currency Id]
   ,[Payment Terms Id]
   ,[Shipment Method Id]
   ,[Tax Area ID]
   ,[Bill-to Customer Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Sales Quote Entity Buffer$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 Quote Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Quote Entity Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Quote Entity Buffer].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Quote Entity Buffer].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Sales Quote Entity Buffer].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Sales Quote Entity Buffer].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Sales Quote Entity Buffer].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Sales Quote Entity Buffer].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Sales Quote Entity Buffer].[Salesperson Code] = [Salesperson_Purchaser].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Sales Quote Entity Buffer].[Tax Area Code] = [Tax Area].[Code]

Show/hide columns in Sales Quote Entity Buffer table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Document Type Searchint
4Sell-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Quote Entity Buffer].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Sales Quote Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Quote Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Quote Entity Buffer].[Sell-to Customer No_] = [Customer].[No_]
5Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Quote Entity Buffer].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Sales Quote Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Quote Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Quote Entity Buffer].[Bill-to Customer No_] = [Customer].[No_]
6Bill-to Name Searchnvarchar(200)
7Bill-to Address Searchnvarchar(200)
8Bill-to Address 2 Searchnvarchar(100)
9Bill-to City Searchnvarchar(60)
10Bill-to Contact Searchnvarchar(200)
11Your Reference Searchnvarchar(70)
12Ship-to Code Searchnvarchar(20)
13Ship-to Name Searchnvarchar(200)
14Ship-to Address Searchnvarchar(200)
15Ship-to Address 2 Searchnvarchar(100)
16Ship-to City Searchnvarchar(60)
17Ship-to Contact Searchnvarchar(200)
18Posting Date Searchdatetime
19Payment Terms Code Searchnvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Sales Quote Entity Buffer].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Sales Quote Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Quote Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Sales Quote Entity Buffer].[Payment Terms Code] = [Payment Terms].[Code]
20Due Date Searchdatetime
21Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Sales Quote Entity Buffer].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Sales Quote Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Quote Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Sales Quote Entity Buffer].[Shipment Method Code] = [Shipment Method].[Code]
22Shortcut Dimension 1 Code Searchnvarchar(40)
23Shortcut Dimension 2 Code Searchnvarchar(40)
24Customer Posting Group Searchnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Sales Quote Entity Buffer].[Customer Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Quote Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Quote Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Sales Quote Entity Buffer].[Customer Posting Group] = [Customer Posting Group].[Code]
25Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Sales Quote Entity Buffer].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Sales Quote Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Quote Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Sales Quote Entity Buffer].[Currency Code] = [Currency].[Code]
26Prices Including VAT Searchtinyint
27Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Sales Quote Entity Buffer].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$Sales Quote Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Quote Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [Sales Quote Entity Buffer].[Salesperson Code] = [Salesperson_Purchaser].[No_]
28Amount Searchdecimal(38,38)
29Amount Including VAT Searchdecimal(38,38)
30VAT Registration No_ Searchnvarchar(40)
31Sell-to Customer Name Searchnvarchar(200)
32Sell-to Address Searchnvarchar(200)
33Sell-to Address 2 Searchnvarchar(100)
34Sell-to City Searchnvarchar(60)
35Sell-to Contact Searchnvarchar(200)
36Bill-to Post Code Searchnvarchar(40)
37Bill-to County Searchnvarchar(60)
38Bill-to Country_Region Code Searchnvarchar(20)
39Sell-to Post Code Searchnvarchar(40)
40Sell-to County Searchnvarchar(60)
41Sell-to Country_Region Code Searchnvarchar(20)
42Ship-to Post Code Searchnvarchar(40)
43Ship-to County Searchnvarchar(60)
44Ship-to Country_Region Code Searchnvarchar(20)
45Document Date Searchdatetime
46External Document No_ Searchnvarchar(70)
47Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Sales Quote Entity Buffer].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Sales Quote Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Quote Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Sales Quote Entity Buffer].[Tax Area Code] = [Tax Area].[Code]
48Tax Liable Searchtinyint
49VAT Bus_ Posting Group Searchnvarchar(40)
50Invoice Discount Calculation Searchint
51Invoice Discount Value Searchdecimal(38,38)
52Quote Valid Until Date Searchdatetime
53Quote Sent to Customer Searchdatetime
54Quote Accepted Searchtinyint
55Quote Accepted Date Searchdatetime
56Last Email Sent Status Searchint
57Sell-to Phone No_ Searchnvarchar(60)
58Sell-to E-Mail Searchnvarchar(160)
59Cust_ Ledger Entry No_ Searchint
60Invoice Discount Amount Searchdecimal(38,38)
61Sell-to Contact No_ Searchnvarchar(40)
62Id Searchuniqueidentifier
63Total Tax Amount Searchdecimal(38,38)
64Status Searchint
65Posted Searchtinyint
66Subtotal Amount Searchdecimal(38,38)
67Discount Applied Before Tax Searchtinyint
68Last Modified Date Time Searchdatetime
69Customer Id Searchuniqueidentifier
70Contact Graph Id Searchnvarchar(500)
71Currency Id Searchuniqueidentifier
72Payment Terms Id Searchuniqueidentifier
73Shipment Method Id Searchuniqueidentifier
74Tax Area ID Searchuniqueidentifier
75Bill-to Customer Id Searchuniqueidentifier
76$systemId Searchuniqueidentifier
77$systemCreatedAt Searchdatetime
78$systemCreatedBy Searchuniqueidentifier
79$systemModifiedAt Searchdatetime
80$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales Quote Entity Buffer table

Leave a Reply

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