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
   [Sell-to Customer No_]
   ,[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]
   ,[Format Region]
   ,[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]
   ,[VAT Reporting Date]
   ,[Rcvd-from Country_Region Code]
   ,[Rcvd_-from Count__Region Code]
   ,[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]
   ,[$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].[Bill-to Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales Cr.Memo Header].[Bill-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Sales Cr.Memo Header].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales Cr.Memo Header].[Ship-to City] = [Post Code].[City]
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_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Sales Cr.Memo Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Sales Cr.Memo Header].[Shortcut Dimension 2 Code] = [Dimension].[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_$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].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Sales Cr.Memo Header].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Sales Cr.Memo Header].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Sales Cr.Memo Header].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Cr.Memo Header].[Sell-to Customer Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales Cr.Memo Header].[Sell-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales Cr.Memo Header].[Bill-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales Cr.Memo Header].[Sell-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales Cr.Memo Header].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
      ON
         [Sales Cr.Memo Header].[Exit Point] = [Entry/Exit Point].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Sales Cr.Memo Header].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Sales Cr.Memo Header].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] 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$ext] AS [Shipping Agent]
      ON
         [Sales Cr.Memo Header].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Sales Cr.Memo Header].[Source Code] = [Source Code].[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_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Sales Cr.Memo Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Sales Cr.Memo Header].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Refund Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Header]
      ON
         [Sales Cr.Memo Header].[Shpfy Refund Id] = [Shpfy Refund Header].[Refund Id]
LEFT JOIN
   [User] AS [User]
      ON
         [Sales Cr.Memo Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Sales Cr.Memo Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Sales Cr.Memo Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
2Sell-to Customer No. SearchSell-to Customer No.NormalCode20Sell-to Customer No_nvarchar(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_]
3No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
4Bill-to Customer No. SearchBill-to Customer No.NormalCode20Bill-to Customer No_nvarchar(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 SearchNameNormalText100Bill-to Namenvarchar(200)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Bill-to Name]
       ,[Customer].[Name]
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 Name] = [Customer].[Name]
6Bill-to Name 2 SearchName 2NormalText50Bill-to Name 2nvarchar(100)
7Bill-to Address SearchAddressNormalText100Bill-to Addressnvarchar(200)
8Bill-to Address 2 SearchAddress 2NormalText50Bill-to Address 2nvarchar(100)
9Bill-to City SearchCityNormalText30Bill-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Bill-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Sales Cr.Memo Header].[Bill-to City] = [Post Code].[City]
10Bill-to Contact SearchContactNormalText100Bill-to Contactnvarchar(200)
11Your Reference SearchYour ReferenceNormalText35Your Referencenvarchar(70)
12Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Sales Cr.Memo Header].[Ship-to Code] = [Ship-to Address].[Code]
13Ship-to Name SearchShip-to NameNormalText100Ship-to Namenvarchar(200)
14Ship-to Name 2 SearchShip-to Name 2NormalText50Ship-to Name 2nvarchar(100)
15Ship-to Address SearchShip-to AddressNormalText100Ship-to Addressnvarchar(200)
16Ship-to Address 2 SearchShip-to Address 2NormalText50Ship-to Address 2nvarchar(100)
17Ship-to City SearchShip-to CityNormalText30Ship-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Ship-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Sales Cr.Memo Header].[Ship-to City] = [Post Code].[City]
18Ship-to Contact SearchShip-to ContactNormalText100Ship-to Contactnvarchar(200)
20Posting Date SearchPosting DateNormalDate4Posting Datedatetime
21Shipment Date SearchShipment DateNormalDate4Shipment Datedatetime
22Posting Description SearchPosting DescriptionNormalText100Posting Descriptionnvarchar(200)
23Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(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]
24Due Date SearchDue DateNormalDate4Due Datedatetime
25Payment Discount % SearchPayment Discount %NormalDecimal12Payment Discount _decimal(38,38)
26Pmt. Discount Date SearchPmt. Discount DateNormalDate4Pmt_ Discount Datedatetime
27Shipment Method Code SearchShipment Method CodeNormalCode10Shipment Method Codenvarchar(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]
28Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
29Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Sales Cr.Memo Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
30Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Sales Cr.Memo Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
31Customer Posting Group SearchCustomer Posting GroupNormalCode20Customer Posting Groupnvarchar(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]
32Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
33Currency Factor SearchCurrency FactorNormalDecimal12Currency Factordecimal(38,38)
34Customer Price Group SearchCustomer Price GroupNormalCode10Customer Price Groupnvarchar(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]
35Prices Including VAT SearchPrices Including TaxNormalBoolean4Prices Including VATtinyint
37Invoice Disc. Code SearchInvoice Disc. CodeNormalCode20Invoice Disc_ Codenvarchar(40)
40Customer Disc. Group SearchCustomer Disc. GroupNormalCode20Customer Disc_ Groupnvarchar(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].[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 Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Sales Cr.Memo Header].[Customer Disc_ Group] = [Customer Discount Group].[Code]
41Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(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]
42Format Region SearchFormat RegionNormalText80Format Regionnvarchar(160)
43Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Salesperson Code]
       ,[Salesperson/Purchaser].[Code]
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].[Code]
46Comment SearchCommentFlowFieldBoolean4
47No. Printed SearchNo. PrintedNormalInteger4No_ Printedint
51On Hold SearchOn HoldNormalCode3On Holdnvarchar(6)
52Applies-to Doc. Type SearchApplies-to Doc. TypeNormalOption4Applies-to Doc_ Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
53Applies-to Doc. No. SearchApplies-to Doc. No.NormalCode20Applies-to Doc_ No_nvarchar(40)
55Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
60Amount SearchAmountFlowFieldDecimal12
61Amount Including VAT SearchAmount Including TaxFlowFieldDecimal12
70VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
73Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Sales Cr.Memo Header].[Reason Code] = [Reason Code].[Code]
74Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Gen_ Bus_ Posting Group]
       ,[Gen. Business 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_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Sales Cr.Memo Header].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
75EU 3-Party Trade SearchEU 3-Party TradeNormalBoolean4EU 3-Party Tradetinyint
76Transaction Type SearchTransaction TypeNormalCode10Transaction Typenvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Transaction Type]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Sales Cr.Memo Header].[Transaction Type] = [Transaction Type].[Code]
77Transport Method SearchTransport MethodNormalCode10Transport Methodnvarchar(20)
Key to join to the Transport Method table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Transport Method]
       ,[Transport 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_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
              ON
                     [Sales Cr.Memo Header].[Transport Method] = [Transport Method].[Code]
78VAT Country/Region Code SearchTax Country/Region CodeNormalCode10VAT Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[VAT Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Sales Cr.Memo Header].[VAT Country_Region Code] = [Country/Region].[Code]
79Sell-to Customer Name SearchSell-to Customer NameNormalText100Sell-to Customer Namenvarchar(200)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Sell-to Customer Name]
       ,[Customer].[Name]
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 Name] = [Customer].[Name]
80Sell-to Customer Name 2 SearchSell-to Customer Name 2NormalText50Sell-to Customer Name 2nvarchar(100)
81Sell-to Address SearchSell-to AddressNormalText100Sell-to Addressnvarchar(200)
82Sell-to Address 2 SearchSell-to Address 2NormalText50Sell-to Address 2nvarchar(100)
83Sell-to City SearchSell-to CityNormalText30Sell-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Sell-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Sales Cr.Memo Header].[Sell-to City] = [Post Code].[City]
84Sell-to Contact SearchSell-to ContactNormalText100Sell-to Contactnvarchar(200)
85Bill-to Post Code SearchZIP CodeNormalCode20Bill-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Bill-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Sales Cr.Memo Header].[Bill-to Post Code] = [Post Code].[Code]
86Bill-to County SearchStateNormalText30Bill-to Countynvarchar(60)
87Bill-to Country/Region Code SearchCountry/Region CodeNormalCode10Bill-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Bill-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Sales Cr.Memo Header].[Bill-to Country_Region Code] = [Country/Region].[Code]
88Sell-to Post Code SearchSell-to ZIP CodeNormalCode20Sell-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Sell-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Sales Cr.Memo Header].[Sell-to Post Code] = [Post Code].[Code]
89Sell-to County SearchSell-to StateNormalText30Sell-to Countynvarchar(60)
90Sell-to Country/Region Code SearchSell-to Country/Region CodeNormalCode10Sell-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Sell-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Sales Cr.Memo Header].[Sell-to Country_Region Code] = [Country/Region].[Code]
91Ship-to Post Code SearchShip-to ZIP CodeNormalCode20Ship-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Ship-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Sales Cr.Memo Header].[Ship-to Post Code] = [Post Code].[Code]
92Ship-to County SearchShip-to StateNormalText30Ship-to Countynvarchar(60)
93Ship-to Country/Region Code SearchShip-to Country/Region CodeNormalCode10Ship-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Ship-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Sales Cr.Memo Header].[Ship-to Country_Region Code] = [Country/Region].[Code]
94Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Bank Account”
97Exit Point SearchExit PointNormalCode10Exit Pointnvarchar(20)
Key to join to the Entry/Exit Point table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Exit Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Sales Cr.Memo Header].[Exit Point] = [Entry/Exit Point].[Code]
98Correction SearchCorrectionNormalBoolean4Correctiontinyint
99Document Date SearchDocument DateNormalDate4Document Datedatetime
100External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
101Area SearchAreaNormalCode10Areanvarchar(20)
Key to join to the Area table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Area]
       ,[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_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
              ON
                     [Sales Cr.Memo Header].[Area] = [Area].[Code]
102Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Transaction Specification]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Sales Cr.Memo Header].[Transaction Specification] = [Transaction Specification].[Code]
104Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(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$ext] AS [Payment Method]
              ON
                     [Sales Cr.Memo Header].[Payment Method Code] = [Payment Method].[Code]
105Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(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$ext] AS [Shipping Agent]
              ON
                     [Sales Cr.Memo Header].[Shipping Agent Code] = [Shipping Agent].[Code]
106Package Tracking No. SearchPackage Tracking No.NormalText30Package Tracking No_nvarchar(60)
107Pre-Assigned No. Series SearchPre-Assigned No. SeriesNormalCode20Pre-Assigned No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Pre-Assigned No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales Cr.Memo Header].[Pre-Assigned No_ Series] = [No. Series].[Code]
108No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales Cr.Memo Header].[No_ Series] = [No. Series].[Code]
111Pre-Assigned No. SearchPre-Assigned No.NormalCode20Pre-Assigned No_nvarchar(40)
112User ID SearchUser IDNormalCode50User IDnvarchar(100)
113Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Sales Cr.Memo Header].[Source Code] = [Source Code].[Code]
114Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(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]
115Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
116VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[VAT Bus_ Posting Group]
       ,[VAT Business 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_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Sales Cr.Memo Header].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
119VAT Base Discount % SearchVAT Base Discount %NormalDecimal12VAT Base Discount _decimal(38,38)
134Prepmt. Cr. Memo No. Series SearchPrepmt. Cr. Memo No. SeriesNormalCode20Prepmt_ Cr_ Memo No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Prepmt_ Cr_ Memo No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales Cr.Memo Header].[Prepmt_ Cr_ Memo No_ Series] = [No. Series].[Code]
136Prepayment Credit Memo SearchPrepayment Credit MemoNormalBoolean4Prepayment Credit Memotinyint
137Prepayment Order No. SearchPrepayment Order No.NormalCode20Prepayment Order No_nvarchar(40)
163Company Bank Account Code SearchCompany Bank Account CodeNormalCode20Company Bank Account Codenvarchar(40)
171Sell-to Phone No. SearchSell-to Phone No.NormalText30Sell-to Phone No_nvarchar(60)
172Sell-to E-Mail SearchEmailNormalText80Sell-to E-Mailnvarchar(160)
179VAT Reporting Date SearchTax DateNormalDate4VAT Reporting Datedatetime
180Rcvd-from Country/Region Code SearchReceived-from Country/Region CodeNormalCode10Rcvd-from Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Rcvd-from Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Sales Cr.Memo Header].[Rcvd-from Country_Region Code] = [Country/Region].[Code]
181Rcvd.-from Count./Region Code SearchReceived-from Country/Region CodeNormalCode10Rcvd_-from Count__Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Rcvd_-from Count__Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Sales Cr.Memo Header].[Rcvd_-from Count__Region Code] = [Country/Region].[Code]
200Work Description SearchWork DescriptionNormalBLOB8Work Descriptionimage
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Sales Cr.Memo Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
710Document Exchange Identifier SearchDocument Exchange IdentifierNormalText50Document Exchange Identifiernvarchar(100)
711Document Exchange Status SearchDocument Exchange StatusNormalOption4Document Exchange Statusint
Available options are:
  • “Not Sent”
  • “Sent to Document Exchange Service”
  • “Delivered to Recipient”
  • “Delivery Failed”
  • “Pending Connection to Recipient”
712Doc. Exch. Original Identifier SearchDoc. Exch. Original IdentifierNormalText50Doc_ Exch_ Original Identifiernvarchar(100)
1302Paid SearchPaidFlowFieldBoolean4
1303Remaining Amount SearchRemaining AmountFlowFieldDecimal12
1304Cust. Ledger Entry No. SearchCust. Ledger Entry No.NormalInteger4Cust_ Ledger Entry No_int
Key to join to the Cust. Ledger Entry table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Cust_ Ledger Entry No_]
       ,[Cust. Ledger Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Cust_ Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Cust. Ledger Entry]
              ON
                     [Sales Cr.Memo Header].[Cust_ Ledger Entry No_] = [Cust. Ledger Entry].[Entry No_]
1305Invoice Discount Amount SearchInvoice Discount AmountFlowFieldDecimal12
1310Cancelled SearchCanceledFlowFieldBoolean4
1311Corrective SearchCorrectiveFlowFieldBoolean4
5050Campaign No. SearchCampaign No.NormalCode20Campaign No_nvarchar(40)
Key to join to the Campaign table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Campaign No_]
       ,[Campaign].[No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
              ON
                     [Sales Cr.Memo Header].[Campaign No_] = [Campaign].[No_]
5052Sell-to Contact No. SearchSell-to Contact No.NormalCode20Sell-to Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Sell-to Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Sales Cr.Memo Header].[Sell-to Contact No_] = [Contact].[No_]
5053Bill-to Contact No. SearchBill-to Contact No.NormalCode20Bill-to Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Bill-to Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Sales Cr.Memo Header].[Bill-to Contact No_] = [Contact].[No_]
5055Opportunity No. SearchOpportunity No.NormalCode20Opportunity No_nvarchar(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_]
5700Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Sales Cr.Memo Header].[Responsibility Center] = [Responsibility Center].[Code]
5794Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
6601Return Order No. SearchReturn Order No.NormalCode20Return Order No_nvarchar(40)
6602Return Order No. Series SearchReturn Order No. SeriesNormalCode20Return Order No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Sales Cr.Memo Header].[Return Order No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Sales Cr.Memo Header].[Return Order No_ Series] = [No. Series].[Code]
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7001Allow Line Disc. SearchAllow Line Disc.NormalBoolean4Allow Line Disc_tinyint
7200Get Return Receipt Used SearchGet Return Receipt UsedNormalBoolean4Get Return Receipt Usedtinyint
8000Id SearchIdNormalGUID16Iduniqueidentifier
8001Draft Cr. Memo SystemId SearchDraft Cr. Memo System IdNormalGUID16
10005Ship-to UPS Zone SearchShip-to UPS ZoneNormalCode2
10015Tax Exemption No. SearchTax Exemption No.NormalText30
10018STE Transaction ID SearchSTE Transaction IDNormalText20
10019Electronic Document Sent SearchElectronic Document SentNormalBoolean4
10020Original Document XML SearchOriginal Document XMLNormalBLOB8
10021No. of E-Documents Sent SearchNo. of E-Documents SentNormalInteger4
10022Original String SearchOriginal StringNormalBLOB8
10023Digital Stamp SAT SearchDigital Stamp SATNormalBLOB8
10024Certificate Serial No. SearchCertificate Serial No.NormalText250
10025Signed Document XML SearchSigned Document XMLNormalBLOB8
10026Digital Stamp PAC SearchDigital Stamp PACNormalBLOB8
10030Electronic Document Status SearchElectronic Document StatusNormalOption4
10031Date/Time Stamped SearchDate/Time StampedNormalText50
10032Date/Time Sent SearchDate/Time SentNormalText50
10033Date/Time Canceled SearchDate/Time CanceledNormalText50
10035Error Code SearchError CodeNormalCode10
10036Error Description SearchError DescriptionNormalText250
10037Date/Time Stamp Received SearchDate/Time Stamp ReceivedNormalDateTime8
10038Date/Time Cancel Sent SearchDate/Time Cancel SentNormalDateTime8
10040PAC Web Service Name SearchPAC Web Service NameNormalText50
10041QR Code SearchQR CodeNormalBLOB8
10042Fiscal Invoice Number PAC SearchFiscal Invoice Number PACNormalText50
10043Date/Time First Req. Sent SearchDate/Time First Req. SentNormalText50
10050Foreign Trade SearchForeign TradeNormalBoolean4
10055Transit-to Location SearchTransit-to LocationNormalCode10
10059SAT International Trade Term SearchSAT International Trade TermNormalCode10
10060Exchange Rate USD SearchExchange Rate USDNormalDecimal12
27000CFDI Purpose SearchCFDI PurposeNormalCode10
27001CFDI Relation SearchCFDI RelationNormalCode10
27002CFDI Cancellation Reason Code SearchCFDI Cancelation ReasonNormalCode10
27003Substitution Document No. SearchSubstitution Document No.NormalCode20
27004CFDI Export Code SearchCFDI Export CodeNormalCode10
27007CFDI Cancellation ID SearchCFDI Cancelation IDNormalText50
27008Marked as Canceled SearchMarked as CanceledNormalBoolean4
27009SAT Address ID SearchSAT Address IDNormalInteger4
30103Shpfy Refund Id SearchShpfy Refund IdNormalBigInteger8
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 Cr.Memo Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Sales Cr.Memo Header].[$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 Cr.Memo Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Sales Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Cr.Memo Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Sales Cr.Memo Header].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Sales Cr.Memo Header table

Leave a Reply

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