Sales Cr_ Memo Entity Buffer

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

Table Type: Company

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

Table Number: 5507

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Posted]
   ,[Sell-to Customer No_]
   ,[Bill-to Customer No_]
   ,[Bill-to Name]
   ,[Bill-to Address]
   ,[Bill-to Address 2]
   ,[Bill-to City]
   ,[Bill-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]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Amount]
   ,[Amount Including VAT]
   ,[Reason Code]
   ,[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]
   ,[Document Date]
   ,[External Document No_]
   ,[Sell-to Phone No_]
   ,[Sell-to E-Mail]
   ,[Cust_ Ledger Entry No_]
   ,[Invoice Discount Amount]
   ,[Sell-to Contact No_]
   ,[Shipping Advice]
   ,[Completely Shipped]
   ,[Requested Delivery Date]
   ,[Id]
   ,[Total Tax Amount]
   ,[Status]
   ,[Discount Applied Before Tax]
   ,[Last Modified Date Time]
   ,[Customer Id]
   ,[Contact Graph Id]
   ,[Currency Id]
   ,[Payment Terms Id]
   ,[Shipment Method Id]
   ,[Bill-to Customer Id]
   ,[Reason Code Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Sales Cr_ Memo 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 Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_ Memo Entity Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Cr_ Memo Entity Buffer].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Cr_ Memo 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 Cr_ Memo 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 Cr_ Memo 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 Cr_ Memo Entity Buffer].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Sales Cr_ Memo Entity Buffer].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Sales Cr_ Memo Entity Buffer].[Salesperson Code] = [Salesperson_Purchaser].[No_]

Show/hide columns in Sales Cr_ Memo Entity Buffer table

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

Show/hide example query

SELECT
       [Sales Cr_ Memo Entity Buffer].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_ Memo Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Cr_ Memo 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 Cr_ Memo Entity Buffer].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_ Memo Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Cr_ Memo 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)
11Posting Date Searchdatetime
12Payment Terms Code Searchnvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Sales Cr_ Memo Entity Buffer].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_ Memo Entity Buffer]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [Sales Cr_ Memo Entity Buffer].[Salesperson Code] = [Salesperson_Purchaser].[No_]
21Applies-to Doc_ Type Searchint
22Applies-to Doc_ No_ Searchnvarchar(40)
23Amount Searchdecimal(38,38)
24Amount Including VAT Searchdecimal(38,38)
25Reason Code Searchnvarchar(20)
26Sell-to Customer Name Searchnvarchar(200)
27Sell-to Address Searchnvarchar(200)
28Sell-to Address 2 Searchnvarchar(100)
29Sell-to City Searchnvarchar(60)
30Sell-to Contact Searchnvarchar(200)
31Bill-to Post Code Searchnvarchar(40)
32Bill-to County Searchnvarchar(60)
33Bill-to Country_Region Code Searchnvarchar(20)
34Sell-to Post Code Searchnvarchar(40)
35Sell-to County Searchnvarchar(60)
36Sell-to Country_Region Code Searchnvarchar(20)
37Document Date Searchdatetime
38External Document No_ Searchnvarchar(70)
39Sell-to Phone No_ Searchnvarchar(60)
40Sell-to E-Mail Searchnvarchar(160)
41Cust_ Ledger Entry No_ Searchint
42Invoice Discount Amount Searchdecimal(38,38)
43Sell-to Contact No_ Searchnvarchar(40)
44Shipping Advice Searchint
45Completely Shipped Searchtinyint
46Requested Delivery Date Searchdatetime
47Id Searchuniqueidentifier
48Total Tax Amount Searchdecimal(38,38)
49Status Searchint
50Discount Applied Before Tax Searchtinyint
51Last Modified Date Time Searchdatetime
52Customer Id Searchuniqueidentifier
53Contact Graph Id Searchnvarchar(500)
54Currency Id Searchuniqueidentifier
55Payment Terms Id Searchuniqueidentifier
56Shipment Method Id Searchuniqueidentifier
57Bill-to Customer Id Searchuniqueidentifier
58Reason Code Id Searchuniqueidentifier
59$systemId Searchuniqueidentifier
60$systemCreatedAt Searchdatetime
61$systemCreatedBy Searchuniqueidentifier
62$systemModifiedAt Searchdatetime
63$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales Cr_ Memo Entity Buffer table

Leave a Reply

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