Sales Cr_Memo Header

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

Table Type: Company

Table Name: Sales Cr_Memo Header
Database Table Name: CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 114

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 Header can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Sell-to Customer No_]
   ,[Bill-to Customer No_]
   ,[Bill-to Name]
   ,[Bill-to Name 2]
   ,[Bill-to Address]
   ,[Bill-to Address 2]
   ,[Bill-to City]
   ,[Bill-to Contact]
   ,[Your Reference]
   ,[Ship-to Code]
   ,[Ship-to Name]
   ,[Ship-to Name 2]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Contact]
   ,[Posting Date]
   ,[Shipment Date]
   ,[Posting Description]
   ,[Payment Terms Code]
   ,[Due Date]
   ,[Payment Discount _]
   ,[Pmt_ Discount Date]
   ,[Shipment Method Code]
   ,[Location Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Customer Posting Group]
   ,[Currency Code]
   ,[Currency Factor]
   ,[Customer Price Group]
   ,[Prices Including VAT]
   ,[Invoice Disc_ Code]
   ,[Customer Disc_ Group]
   ,[Language Code]
   ,[Salesperson Code]
   ,[No_ Printed]
   ,[On Hold]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Bal_ Account No_]
   ,[VAT Registration No_]
   ,[Reason Code]
   ,[Gen_ Bus_ Posting Group]
   ,[EU 3-Party Trade]
   ,[Transaction Type]
   ,[Transport Method]
   ,[VAT Country_Region Code]
   ,[Sell-to Customer Name]
   ,[Sell-to Customer Name 2]
   ,[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]
   ,[Bal_ Account Type]
   ,[Exit Point]
   ,[Correction]
   ,[Document Date]
   ,[External Document No_]
   ,[Area]
   ,[Transaction Specification]
   ,[Payment Method Code]
   ,[Shipping Agent Code]
   ,[Package Tracking No_]
   ,[Pre-Assigned No_ Series]
   ,[No_ Series]
   ,[Pre-Assigned No_]
   ,[User ID]
   ,[Source Code]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[VAT Base Discount _]
   ,[Prepmt_ Cr_ Memo No_ Series]
   ,[Prepayment Credit Memo]
   ,[Prepayment Order No_]
   ,[Company Bank Account Code]
   ,[Sell-to Phone No_]
   ,[Sell-to E-Mail]
   ,[Work Description]
   ,[Dimension Set ID]
   ,[Document Exchange Identifier]
   ,[Document Exchange Status]
   ,[Doc_ Exch_ Original Identifier]
   ,[Cust_ Ledger Entry No_]
   ,[Campaign No_]
   ,[Sell-to Contact No_]
   ,[Bill-to Contact No_]
   ,[Opportunity No_]
   ,[Responsibility Center]
   ,[Shipping Agent Service Code]
   ,[Return Order No_]
   ,[Return Order No_ Series]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Get Return Receipt Used]
   ,[Id]
   ,[Draft Cr_ Memo SystemId]
   ,[Type of Supply Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Sales Cr_Memo Header$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 Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Cr_Memo Header].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Cr_Memo Header].[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 Header].[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 Header].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Sales Cr_Memo Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Sales Cr_Memo Header].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Sales Cr_Memo Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Sales Cr_Memo Header].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Sales Cr_Memo Header].[Customer Disc_ Group] = [Customer Discount Group].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Sales Cr_Memo Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Sales Cr_Memo Header].[Salesperson Code] = [Salesperson_Purchaser].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Sales Cr_Memo Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Sales Cr_Memo Header].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Sales Cr_Memo Header].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
      ON
         [Sales Cr_Memo Header].[Opportunity No_] = [Opportunity].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Sales Cr_Memo Header].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
      ON
         [Sales Cr_Memo Header].[Type of Supply Code] = [Type of Supply].[Code]

Show/hide columns in Sales Cr_Memo Header table

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

Show/hide example query

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

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Cr_Memo Header].[Bill-to Customer No_] = [Customer].[No_]
5Bill-to Name Searchnvarchar(200)
6Bill-to Name 2 Searchnvarchar(100)
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 Name 2 Searchnvarchar(100)
15Ship-to Address Searchnvarchar(200)
16Ship-to Address 2 Searchnvarchar(100)
17Ship-to City Searchnvarchar(60)
18Ship-to Contact Searchnvarchar(200)
19Posting Date Searchdatetime
20Shipment Date Searchdatetime
21Posting Description Searchnvarchar(200)
22Payment Terms Code Searchnvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Sales Cr_Memo Header].[Payment Terms Code] = [Payment Terms].[Code]
23Due Date Searchdatetime
24Payment Discount _ Searchdecimal(38,38)
25Pmt_ Discount Date Searchdatetime
26Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Sales Cr_Memo Header].[Shipment Method Code] = [Shipment Method].[Code]
27Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Sales Cr_Memo Header].[Location Code] = [Location].[Code]
28Shortcut Dimension 1 Code Searchnvarchar(40)
29Shortcut Dimension 2 Code Searchnvarchar(40)
30Customer Posting Group Searchnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

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

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Sales Cr_Memo Header].[Currency Code] = [Currency].[Code]
32Currency Factor Searchdecimal(38,38)
33Customer Price Group Searchnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Sales Cr_Memo Header].[Customer Price Group] = [Customer Price Group].[Code]
34Prices Including VAT Searchtinyint
35Invoice Disc_ Code Searchnvarchar(40)
36Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Sales Cr_Memo Header].[Customer Disc_ Group] = [Customer Discount Group].[No_]
37Language Code Searchnvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Sales Cr_Memo Header].[Language Code] = [Language].[Code]
38Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [Sales Cr_Memo Header].[Salesperson Code] = [Salesperson_Purchaser].[No_]
39No_ Printed Searchint
40On Hold Searchnvarchar(6)
41Applies-to Doc_ Type Searchint
42Applies-to Doc_ No_ Searchnvarchar(40)
43Bal_ Account No_ Searchnvarchar(40)
44VAT Registration No_ Searchnvarchar(40)
45Reason Code Searchnvarchar(20)
46Gen_ Bus_ Posting Group Searchnvarchar(40)
47EU 3-Party Trade Searchtinyint
48Transaction Type Searchnvarchar(20)
49Transport Method Searchnvarchar(20)
50VAT Country_Region Code Searchnvarchar(20)
51Sell-to Customer Name Searchnvarchar(200)
52Sell-to Customer Name 2 Searchnvarchar(100)
53Sell-to Address Searchnvarchar(200)
54Sell-to Address 2 Searchnvarchar(100)
55Sell-to City Searchnvarchar(60)
56Sell-to Contact Searchnvarchar(200)
57Bill-to Post Code Searchnvarchar(40)
58Bill-to County Searchnvarchar(60)
59Bill-to Country_Region Code Searchnvarchar(20)
60Sell-to Post Code Searchnvarchar(40)
61Sell-to County Searchnvarchar(60)
62Sell-to Country_Region Code Searchnvarchar(20)
63Ship-to Post Code Searchnvarchar(40)
64Ship-to County Searchnvarchar(60)
65Ship-to Country_Region Code Searchnvarchar(20)
66Bal_ Account Type Searchint
67Exit Point Searchnvarchar(20)
68Correction Searchtinyint
69Document Date Searchdatetime
70External Document No_ Searchnvarchar(70)
71Area Searchnvarchar(20)
72Transaction Specification Searchnvarchar(20)
73Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Sales Cr_Memo Header].[Payment Method Code] = [Payment Method].[Code]
74Shipping Agent Code Searchnvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
              ON
                     [Sales Cr_Memo Header].[Shipping Agent Code] = [Shipping Agent].[Code]
75Package Tracking No_ Searchnvarchar(60)
76Pre-Assigned No_ Series Searchnvarchar(40)
77No_ Series Searchnvarchar(40)
78Pre-Assigned No_ Searchnvarchar(40)
79User ID Searchnvarchar(100)
80Source Code Searchnvarchar(20)
81Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Sales Cr_Memo Header].[Tax Area Code] = [Tax Area].[Code]
82Tax Liable Searchtinyint
83VAT Bus_ Posting Group Searchnvarchar(40)
84VAT Base Discount _ Searchdecimal(38,38)
85Prepmt_ Cr_ Memo No_ Series Searchnvarchar(40)
86Prepayment Credit Memo Searchtinyint
87Prepayment Order No_ Searchnvarchar(40)
88Company Bank Account Code Searchnvarchar(40)
89Sell-to Phone No_ Searchnvarchar(60)
90Sell-to E-Mail Searchnvarchar(160)
91Work Description Searchimage
92Dimension Set ID Searchint
93Document Exchange Identifier Searchnvarchar(100)
94Document Exchange Status Searchint
95Doc_ Exch_ Original Identifier Searchnvarchar(100)
96Cust_ Ledger Entry No_ Searchint
97Campaign No_ Searchnvarchar(40)
98Sell-to Contact No_ Searchnvarchar(40)
99Bill-to Contact No_ Searchnvarchar(40)
100Opportunity No_ Searchnvarchar(40)
Key to join to the Opportunity table.

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Opportunity No_]
       ,[Opportunity].[No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
              ON
                     [Sales Cr_Memo Header].[Opportunity No_] = [Opportunity].[No_]
101Responsibility Center Searchnvarchar(20)
102Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Sales Cr_Memo Header].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
103Return Order No_ Searchnvarchar(40)
104Return Order No_ Series Searchnvarchar(40)
105Price Calculation Method Searchint
106Allow Line Disc_ Searchtinyint
107Get Return Receipt Used Searchtinyint
108Id Searchuniqueidentifier
109Draft Cr_ Memo SystemId Searchuniqueidentifier
110Type of Supply Code Searchnvarchar(20)
Key to join to the Type of Supply table.

Show/hide example query

SELECT
       [Sales Cr_Memo Header].[Type of Supply Code]
       ,[Type of Supply].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
              ON
                     [Sales Cr_Memo Header].[Type of Supply Code] = [Type of Supply].[Code]
111$systemId Searchuniqueidentifier
112$systemCreatedAt Searchdatetime
113$systemCreatedBy Searchuniqueidentifier
114$systemModifiedAt Searchdatetime
115$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales Cr_Memo Header table

Leave a Reply

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