Sales Header

Dynamics 365 BC Table ReferenceTablesCompany TablesSSales Header

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

Table Type: Company

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

Table Number: 36

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Document Type]
   ,[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]
   ,[Order Date]
   ,[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]
   ,[Order Class]
   ,[No_ Printed]
   ,[On Hold]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Bal_ Account No_]
   ,[Ship]
   ,[Invoice]
   ,[Print Posted Documents]
   ,[Shipping No_]
   ,[Posting No_]
   ,[Last Shipping No_]
   ,[Last Posting No_]
   ,[Prepayment No_]
   ,[Last Prepayment No_]
   ,[Prepmt_ Cr_ Memo No_]
   ,[Last Prepmt_ Cr_ Memo No_]
   ,[VAT Registration No_]
   ,[Combine Shipments]
   ,[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_]
   ,[No_ Series]
   ,[Posting No_ Series]
   ,[Shipping No_ Series]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[Reserve]
   ,[Applies-to ID]
   ,[VAT Base Discount _]
   ,[Status]
   ,[Invoice Discount Calculation]
   ,[Invoice Discount Value]
   ,[Send IC Document]
   ,[IC Status]
   ,[Sell-to IC Partner Code]
   ,[Bill-to IC Partner Code]
   ,[IC Reference Document No_]
   ,[IC Direction]
   ,[Prepayment _]
   ,[Prepayment No_ Series]
   ,[Compress Prepayment]
   ,[Prepayment Due Date]
   ,[Prepmt_ Cr_ Memo No_ Series]
   ,[Prepmt_ Posting Description]
   ,[Prepmt_ Pmt_ Discount Date]
   ,[Prepmt_ Payment Terms Code]
   ,[Prepmt_ Payment Discount _]
   ,[Quote No_]
   ,[Quote Valid Until Date]
   ,[Quote Sent to Customer]
   ,[Quote Accepted]
   ,[Quote Accepted Date]
   ,[Job Queue Status]
   ,[Job Queue Entry ID]
   ,[Company Bank Account Code]
   ,[Incoming Document Entry No_]
   ,[IsTest]
   ,[Sell-to Phone No_]
   ,[Sell-to E-Mail]
   ,[Payment Instructions Id]
   ,[Journal Templ_ Name]
   ,[VAT Reporting Date]
   ,[Rcvd-from Country_Region Code]
   ,[Rcvd_-from Count__Region Code]
   ,[Work Description]
   ,[Dimension Set ID]
   ,[Payment Service Set ID]
   ,[Coupled to CRM]
   ,[Direct Debit Mandate ID]
   ,[Doc_ No_ Occurrence]
   ,[Campaign No_]
   ,[Sell-to Customer Template Code]
   ,[Sell-to Contact No_]
   ,[Bill-to Contact No_]
   ,[Bill-to Customer Template Code]
   ,[Opportunity No_]
   ,[Sell-to Customer Templ_ Code]
   ,[Bill-to Customer Templ_ Code]
   ,[Responsibility Center]
   ,[Shipping Advice]
   ,[Posting from Whse_ Ref_]
   ,[Requested Delivery Date]
   ,[Promised Delivery Date]
   ,[Shipping Time]
   ,[Outbound Whse_ Handling Time]
   ,[Shipping Agent Service Code]
   ,[Receive]
   ,[Return Receipt No_]
   ,[Return Receipt No_ Series]
   ,[Last Return Receipt No_]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Get Shipment Used]
   ,[Id]
   ,[Assigned User ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Sales 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 Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Sales Header].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Sales Header].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Sales Header].[Document Type] = [Sales Header].[Document Type]
      AND
         [Sales Header].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Header].[Bill-to Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales 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 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 Header].[Ship-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Sales Header].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Sales Header].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Sales Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Sales Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Sales 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 Header].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Sales Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Sales Header].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Sales Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Sales Header].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Sales Header].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Sales Header].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Sales Header].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Header].[Sell-to Customer Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales Header].[Sell-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Sales 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 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 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 Header].[Exit Point] = [Entry/Exit Point].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Sales Header].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Sales Header].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Sales 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 Header].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Sales Header].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Sales Header].[Sell-to IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Sales Header].[Bill-to IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$O365 Payment Instructions$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Payment Instructions]
      ON
         [Sales Header].[Payment Instructions Id] = [O365 Payment Instructions].[Id]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Sales 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 Header].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Sales Header].[Location Filter] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Sales Header].[Assigned User ID] = [User Setup].[User ID]
LEFT JOIN
   [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
      ON
         [Sales Header].[Vehicle Code] = [Fixed Asset].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Shpfy Refund Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Header]
      ON
         [Sales Header].[Shpfy Refund Id] = [Shpfy Refund Header].[Refund Id]
LEFT JOIN
   [User] AS [User]
      ON
         [Sales Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Sales Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Sales Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
  • “Blanket Order”
  • “Return Order”
2Sell-to Customer No. Primary Key SearchSell-to Customer No.NormalCode20Sell-to Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

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

Show/hide example query

SELECT
	       [Sales Header].[Bill-to Customer No_]
	       ,[Customer].[No_]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Sales 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 Header].[Bill-to Name]
	       ,[Customer].[Name]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Sales 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 Header].[Bill-to City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Sales 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 Header].[Ship-to Code]
	       ,[Ship-to Address].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
	              ON
	                     [Sales 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 Header].[Ship-to City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Sales Header].[Ship-to City] = [Post Code].[City]
18Ship-to Contact SearchShip-to ContactNormalText100Ship-to Contactnvarchar(200)
19Order Date SearchOrder DateNormalDate4Order Datedatetime
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 Header].[Payment Terms Code]
	       ,[Payment Terms].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
	              ON
	                     [Sales 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 Header].[Shipment Method Code]
	       ,[Shipment Method].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
	              ON
	                     [Sales 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 Header].[Location Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Sales 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 Header].[Shortcut Dimension 1 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Sales 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 Header].[Shortcut Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Sales 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 Header].[Customer Posting Group]
	       ,[Customer Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
	              ON
	                     [Sales 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 Header].[Currency Code]
	       ,[Currency].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Sales 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 Header].[Customer Price Group]
	       ,[Customer Price Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
	              ON
	                     [Sales 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 Header].[Customer Disc_ Group]
	       ,[Customer Discount Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
	              ON
	                     [Sales 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 Header].[Language Code]
	       ,[Language].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
	              ON
	                     [Sales 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 Header].[Salesperson Code]
	       ,[Salesperson/Purchaser].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
	              ON
	                     [Sales Header].[Salesperson Code] = [Salesperson/Purchaser].[Code]
45Order Class SearchOrder ClassNormalCode10Order Classnvarchar(20)
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)
56Recalculate Invoice Disc. SearchRecalculate Invoice Disc.FlowFieldBoolean4
57Ship SearchShipNormalBoolean4Shiptinyint
58Invoice SearchInvoiceNormalBoolean4Invoicetinyint
59Print Posted Documents SearchPrint Posted DocumentsNormalBoolean4Print Posted Documentstinyint
60Amount SearchAmountFlowFieldDecimal12
61Amount Including VAT SearchAmount Including TaxFlowFieldDecimal12
62Shipping No. SearchShipping No.NormalCode20Shipping No_nvarchar(40)
63Posting No. SearchPosting No.NormalCode20Posting No_nvarchar(40)
64Last Shipping No. SearchLast Shipping No.NormalCode20Last Shipping No_nvarchar(40)
Key to join to the Posted Whse. Shipment Header table.

Show/hide example query

SELECT
	       [Sales Header].[Last Shipping No_]
	       ,[Posted Whse. Shipment Header].[No_]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Posted Whse_ Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse. Shipment Header]
	              ON
	                     [Sales Header].[Last Shipping No_] = [Posted Whse. Shipment Header].[No_]
65Last Posting No. SearchLast Posting No.NormalCode20Last Posting No_nvarchar(40)
66Prepayment No. SearchPrepayment No.NormalCode20Prepayment No_nvarchar(40)
67Last Prepayment No. SearchLast Prepayment No.NormalCode20Last Prepayment No_nvarchar(40)
68Prepmt. Cr. Memo No. SearchPrepmt. Cr. Memo No.NormalCode20Prepmt_ Cr_ Memo No_nvarchar(40)
69Last Prepmt. Cr. Memo No. SearchLast Prepmt. Cr. Memo No.NormalCode20Last Prepmt_ Cr_ Memo No_nvarchar(40)
70VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
71Combine Shipments SearchCombine ShipmentsNormalBoolean4Combine Shipmentstinyint
73Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
	       [Sales Header].[Reason Code]
	       ,[Reason Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
	              ON
	                     [Sales 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 Header].[Gen_ Bus_ Posting Group]
	       ,[Gen. Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
	              ON
	                     [Sales 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 Header].[Transaction Type]
	       ,[Transaction Type].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
	              ON
	                     [Sales 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 Header].[Transport Method]
	       ,[Transport Method].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
	              ON
	                     [Sales Header].[Transport Method] = [Transport Method].[Code]
78VAT Country/Region Code SearchTax Country/Region CodeNormalCode10VAT Country_Region Codenvarchar(20)
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 Header].[Sell-to Customer Name]
	       ,[Customer].[Name]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Sales 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 Header].[Sell-to City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Sales 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 Header].[Bill-to Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Sales 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)
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 Header].[Sell-to Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Sales 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)
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 Header].[Ship-to Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Sales 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)
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 Header].[Exit Point]
	       ,[Entry/Exit Point].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
	              ON
	                     [Sales 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 Header].[Area]
	       ,[Area].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
	              ON
	                     [Sales Header].[Area] = [Area].[Code]
102Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
	       [Sales Header].[Transaction Specification]
	       ,[Transaction Specification].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
	              ON
	                     [Sales 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 Header].[Payment Method Code]
	       ,[Payment Method].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
	              ON
	                     [Sales 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 Header].[Shipping Agent Code]
	       ,[Shipping Agent].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
	              ON
	                     [Sales Header].[Shipping Agent Code] = [Shipping Agent].[Code]
106Package Tracking No. SearchPackage Tracking No.NormalText30Package Tracking No_nvarchar(60)
107No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

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

Show/hide example query

SELECT
	       [Sales Header].[Posting No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Sales Header].[Posting No_ Series] = [No. Series].[Code]
109Shipping No. Series SearchShipping No. SeriesNormalCode20Shipping No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Sales Header].[Shipping No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Sales Header].[Shipping No_ Series] = [No. Series].[Code]
114Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
	       [Sales Header].[Tax Area Code]
	       ,[Tax Area].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
	              ON
	                     [Sales 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 Header].[VAT Bus_ Posting Group]
	       ,[VAT Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
	              ON
	                     [Sales Header].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
117Reserve SearchReserveNormalOption4Reserveint
Available options are:
  • “Never”
  • “Optional”
  • “Always”
118Applies-to ID SearchApplies-to IDNormalCode50Applies-to IDnvarchar(100)
119VAT Base Discount % SearchVAT Base Discount %NormalDecimal12VAT Base Discount _decimal(38,38)
120Status SearchStatusNormalOption4Statusint
Available options are:
  • “Open”
  • “Released”
  • “Pending Approval”
  • “Pending Prepayment”
121Invoice Discount Calculation SearchInvoice Discount CalculationNormalOption4Invoice Discount Calculationint
Available options are:
  • “None”
  • “%”
  • “Amount”
122Invoice Discount Value SearchInvoice Discount ValueNormalDecimal12Invoice Discount Valuedecimal(38,38)
123Send IC Document SearchSend IC DocumentNormalBoolean4Send IC Documenttinyint
124IC Status SearchIC StatusNormalOption4IC Statusint
Available options are:
  • “New”
  • “Pending”
  • “Sent”
125Sell-to IC Partner Code SearchSell-to IC Partner CodeNormalCode20Sell-to IC Partner Codenvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
	       [Sales Header].[Sell-to IC Partner Code]
	       ,[IC Partner].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
	              ON
	                     [Sales Header].[Sell-to IC Partner Code] = [IC Partner].[Code]
126Bill-to IC Partner Code SearchIC Partner CodeNormalCode20Bill-to IC Partner Codenvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
	       [Sales Header].[Bill-to IC Partner Code]
	       ,[IC Partner].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
	              ON
	                     [Sales Header].[Bill-to IC Partner Code] = [IC Partner].[Code]
127IC Reference Document No. SearchIC Reference Document No.NormalCode20IC Reference Document No_nvarchar(40)
129IC Direction SearchIC DirectionNormalOption4IC Directionint
Available options are:
  • “Outgoing”
  • “Incoming”
130Prepayment % SearchPrepayment %NormalDecimal12Prepayment _decimal(38,38)
131Prepayment No. Series SearchPrepayment No. SeriesNormalCode20Prepayment No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Sales Header].[Prepayment No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Sales Header].[Prepayment No_ Series] = [No. Series].[Code]
132Compress Prepayment SearchCompress PrepaymentNormalBoolean4Compress Prepaymenttinyint
133Prepayment Due Date SearchPrepayment Due DateNormalDate4Prepayment Due Datedatetime
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 Header].[Prepmt_ Cr_ Memo No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Sales Header].[Prepmt_ Cr_ Memo No_ Series] = [No. Series].[Code]
135Prepmt. Posting Description SearchPrepmt. Posting DescriptionNormalText100Prepmt_ Posting Descriptionnvarchar(200)
138Prepmt. Pmt. Discount Date SearchPrepmt. Pmt. Discount DateNormalDate4Prepmt_ Pmt_ Discount Datedatetime
139Prepmt. Payment Terms Code SearchPrepmt. Payment Terms CodeNormalCode10Prepmt_ Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
	       [Sales Header].[Prepmt_ Payment Terms Code]
	       ,[Payment Terms].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
	              ON
	                     [Sales Header].[Prepmt_ Payment Terms Code] = [Payment Terms].[Code]
140Prepmt. Payment Discount % SearchPrepmt. Payment Discount %NormalDecimal12Prepmt_ Payment Discount _decimal(38,38)
151Quote No. SearchQuote No.NormalCode20Quote No_nvarchar(40)
152Quote Valid Until Date SearchQuote Valid To DateNormalDate4Quote Valid Until Datedatetime
153Quote Sent to Customer SearchQuote Sent to CustomerNormalDateTime8Quote Sent to Customerdatetime
154Quote Accepted SearchQuote AcceptedNormalBoolean4Quote Acceptedtinyint
155Quote Accepted Date SearchQuote Accepted DateNormalDate4Quote Accepted Datedatetime
160Job Queue Status SearchJob Queue StatusNormalOption4Job Queue Statusint
Available options are:
  • ” “
  • “Scheduled for Posting”
  • “Error”
  • “Posting”
161Job Queue Entry ID SearchJob Queue Entry IDNormalGUID16Job Queue Entry IDuniqueidentifier
163Company Bank Account Code SearchCompany Bank Account CodeNormalCode20Company Bank Account Codenvarchar(40)
165Incoming Document Entry No. SearchIncoming Document Entry No.NormalInteger4Incoming Document Entry No_int
Key to join to the Incoming Document table.

Show/hide example query

SELECT
	       [Sales Header].[Incoming Document Entry No_]
	       ,[Incoming Document].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Incoming Document]
	              ON
	                     [Sales Header].[Incoming Document Entry No_] = [Incoming Document].[Entry No_]
166Last Email Sent Time SearchLast Email Sent TimeFlowFieldDateTime8
167Last Email Sent Status SearchLast Email Sent StatusFlowFieldOption4
168Sent as Email SearchSent as EmailFlowFieldBoolean4
169Last Email Notif Cleared SearchLast Email Notif ClearedFlowFieldBoolean4
170IsTest SearchIsTestNormalBoolean4IsTesttinyint
171Sell-to Phone No. SearchSell-to Phone No.NormalText30Sell-to Phone No_nvarchar(60)
172Sell-to E-Mail SearchEmailNormalText80Sell-to E-Mailnvarchar(160)
175Payment Instructions Id SearchPayment Instructions IdNormalInteger4Payment Instructions Idint
Key to join to the O365 Payment Instructions table.

Show/hide example query

SELECT
	       [Sales Header].[Payment Instructions Id]
	       ,[O365 Payment Instructions].[Id]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$O365 Payment Instructions$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Payment Instructions]
	              ON
	                     [Sales Header].[Payment Instructions Id] = [O365 Payment Instructions].[Id]
178Journal Templ. Name SearchJournal Template NameNormalCode10Journal Templ_ Namenvarchar(20)
179VAT Reporting Date SearchTax DateNormalDate4VAT Reporting Datedatetime
180Rcvd-from Country/Region Code SearchReceived-from Country/Region CodeNormalCode10Rcvd-from Country_Region Codenvarchar(20)
181Rcvd.-from Count./Region Code SearchReceived-from Country/Region CodeNormalCode10Rcvd_-from Count__Region Codenvarchar(20)
200Work Description SearchWork DescriptionNormalBLOB8Work Descriptionimage
300Amt. Ship. Not Inv. (LCY) SearchAmount Shipped Not Invoiced ($) Incl. TaxFlowFieldDecimal12
301Amt. Ship. Not Inv. (LCY) Base SearchAmount Shipped Not Invoiced ($)FlowFieldDecimal12
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
	       [Sales Header].[Dimension Set ID]
	       ,[Dimension Set Entry].[Dimension Set ID]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
	              ON
	                     [Sales Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
600Payment Service Set ID SearchPayment Service Set IDNormalInteger4Payment Service Set IDint
720Coupled to CRM SearchCoupled to Dynamics 365 SalesNormalBoolean4Coupled to CRMtinyint
721Coupled to Dataverse SearchCoupled to Dynamics 365 SalesFlowFieldBoolean4
1200Direct Debit Mandate ID SearchDirect Debit Mandate IDNormalCode35Direct Debit Mandate IDnvarchar(70)
1305Invoice Discount Amount SearchInvoice Discount AmountFlowFieldDecimal12
5043No. of Archived Versions SearchNo. of Archived VersionsFlowFieldInteger4
5048Doc. No. Occurrence SearchDoc. No. OccurrenceNormalInteger4Doc_ No_ Occurrenceint
5050Campaign No. SearchCampaign No.NormalCode20Campaign No_nvarchar(40)
Key to join to the Campaign table.

Show/hide example query

SELECT
	       [Sales Header].[Campaign No_]
	       ,[Campaign].[No_]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
	              ON
	                     [Sales Header].[Campaign No_] = [Campaign].[No_]
5051Sell-to Customer Template Code SearchSell-to Customer Template CodeNormalCode10Sell-to Customer Template Codenvarchar(20)
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 Header].[Sell-to Contact No_]
	       ,[Contact].[No_]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
	              ON
	                     [Sales 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 Header].[Bill-to Contact No_]
	       ,[Contact].[No_]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
	              ON
	                     [Sales Header].[Bill-to Contact No_] = [Contact].[No_]
5054Bill-to Customer Template Code SearchBill-to Customer Template CodeNormalCode10Bill-to Customer Template Codenvarchar(20)
5055Opportunity No. SearchOpportunity No.NormalCode20Opportunity No_nvarchar(40)
Key to join to the Opportunity table.

Show/hide example query

SELECT
	       [Sales Header].[Opportunity No_]
	       ,[Opportunity].[No_]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
	              ON
	                     [Sales Header].[Opportunity No_] = [Opportunity].[No_]
5056Sell-to Customer Templ. Code SearchSell-to Customer Template CodeNormalCode20Sell-to Customer Templ_ Codenvarchar(40)
Key to join to the Customer Templ. table.

Show/hide example query

SELECT
	       [Sales Header].[Sell-to Customer Templ_ Code]
	       ,[Customer Templ.].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.]
	              ON
	                     [Sales Header].[Sell-to Customer Templ_ Code] = [Customer Templ.].[Code]
5057Bill-to Customer Templ. Code SearchBill-to Customer Template CodeNormalCode20Bill-to Customer Templ_ Codenvarchar(40)
Key to join to the Customer Templ. table.

Show/hide example query

SELECT
	       [Sales Header].[Bill-to Customer Templ_ Code]
	       ,[Customer Templ.].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.]
	              ON
	                     [Sales Header].[Bill-to Customer Templ_ Code] = [Customer Templ.].[Code]
5700Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
	       [Sales Header].[Responsibility Center]
	       ,[Responsibility Center].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
	              ON
	                     [Sales Header].[Responsibility Center] = [Responsibility Center].[Code]
5750Shipping Advice SearchShipping AdviceNormalOption4Shipping Adviceint
Available options are:
  • “Partial”
  • “Complete”
5751Shipped Not Invoiced SearchShipped Not InvoicedFlowFieldBoolean4
5752Completely Shipped SearchCompletely ShippedFlowFieldBoolean4
5753Posting from Whse. Ref. SearchPosting from Whse. Ref.NormalInteger4Posting from Whse_ Ref_int
5754Location Filter SearchLocation FilterFlowFilterCode10
Key to join to the Location table.

Show/hide example query

SELECT
	       [Sales Header].[]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Sales Header].[] = [Location].[Code]
5755Shipped SearchShippedFlowFieldBoolean4
5756Last Shipment Date SearchLast Shipment DateFlowFieldDate4
5790Requested Delivery Date SearchRequested Delivery DateNormalDate4Requested Delivery Datedatetime
5791Promised Delivery Date SearchPromised Delivery DateNormalDate4Promised Delivery Datedatetime
5792Shipping Time SearchShipping TimeNormalDateFormula32Shipping Timevarchar(32)
5793Outbound Whse. Handling Time SearchOutbound Whse. Handling TimeNormalDateFormula32Outbound Whse_ Handling Timevarchar(32)
5794Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
5795Late Order Shipping SearchLate Order ShippingFlowFieldBoolean4
5796Date Filter SearchDate FilterFlowFilterDate4
5800Receive SearchReceiveNormalBoolean4Receivetinyint
5801Return Receipt No. SearchReturn Receipt No.NormalCode20Return Receipt No_nvarchar(40)
5802Return Receipt No. Series SearchReturn Receipt No. SeriesNormalCode20Return Receipt No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Sales Header].[Return Receipt No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Sales Header].[Return Receipt No_ Series] = [No. Series].[Code]
5803Last Return Receipt No. SearchLast Return Receipt No.NormalCode20Last Return Receipt No_nvarchar(40)
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7001Allow Line Disc. SearchAllow Line Disc.NormalBoolean4Allow Line Disc_tinyint
7200Get Shipment Used SearchGet Shipment UsedNormalBoolean4Get Shipment Usedtinyint
8000Id SearchIdNormalGUID16Iduniqueidentifier
9000Assigned User ID SearchAssigned User IDNormalCode50Assigned User IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
	       [Sales Header].[Assigned User ID]
	       ,[User Setup].[User ID]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
	              ON
	                     [Sales Header].[Assigned User ID] = [User Setup].[User ID]
10000Sales Tax Amount Rounding SearchSales Tax Amount RoundingNormalDecimal12
10001Prepmt. Sales Tax Rounding Amt SearchPrepayment Sales Tax Rounding AmountNormalDecimal12
10005Ship-to UPS Zone SearchShip-to UPS ZoneNormalCode2
10009Outstanding Amount ($) SearchOutstanding Amount ($)FlowFieldDecimal12
10015Tax Exemption No. SearchTax Exemption No.NormalText30
10018STE Transaction ID SearchSTE Transaction IDNormalText20
10044Transport Operators SearchTransport OperatorsFlowFieldInteger4
10045Transit-from Date/Time SearchTransit-from Date/TimeNormalDateTime8
10046Transit Hours SearchTransit HoursNormalInteger4
10047Transit Distance SearchTransit DistanceNormalDecimal12
10048Insurer Name SearchInsurer NameNormalText50
10049Insurer Policy Number SearchInsurer Policy NumberNormalText30
10050Foreign Trade SearchForeign TradeNormalBoolean4
10051Vehicle Code SearchVehicle CodeNormalCode20
Key to join to the Fixed Asset table.

Show/hide example query

SELECT
	       [Sales Header].[]
	       ,[Fixed Asset].[No_]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
	              ON
	                     [Sales Header].[] = [Fixed Asset].[No_]
10052Trailer 1 SearchTrailer 1NormalCode20
10053Trailer 2 SearchTrailer 2NormalCode20
10055Transit-to Location SearchTransit-to LocationNormalCode10
10056Medical Insurer Name SearchMedical Insurer NameNormalText50
10057Medical Ins. Policy Number SearchMedical Ins. Policy NumberNormalText30
10058SAT Weight Unit Of Measure SearchSAT Weight Unit Of MeasureNormalCode10
10059SAT International Trade Term SearchSAT International Trade TermNormalCode10
10060Exchange Rate USD SearchExchange Rate USDNormalDecimal12
12600Prepmt. Include Tax SearchPrepmt. Include TaxNormalBoolean4
27000CFDI Purpose SearchCFDI PurposeNormalCode10
27001CFDI Relation SearchCFDI RelationNormalCode10
27004CFDI Export Code SearchCFDI Export CodeNormalCode10
27005CFDI Period SearchCFDI PeriodNormalOption4
27009SAT Address ID SearchSAT Address IDNormalInteger4
30100Shpfy Order Id SearchShopify Order IdNormalBigInteger8
30101Shpfy Order No. SearchShopify Order No.NormalCode50
30102Shpfy Risk Level SearchRisk LevelFlowFieldOption4
30103Shpfy Refund Id SearchShopify Refund IdNormalBigInteger8
Key to join to the Shpfy Refund Header table.

Show/hide example query

SELECT
	       [Sales Header].[]
	       ,[Shpfy Refund Header].[Refund Id]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shpfy Refund Header$ec255f57-31d0-4ca2-b751-f2fa7c745abb] AS [Shpfy Refund Header]
	              ON
	                     [Sales Header].[] = [Shpfy Refund Header].[Refund Id]
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 Header].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Sales Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Sales Header table

CurrencyCustomer Posting GroupCustomer Price GroupLanguageLocationPayment MethodPayment TermsResponsibility CenterSales HeaderSales Header ArchiveSalesperson/PurchaserSalesperson/PurchaserShip-to AddressShipment MethodShipping AgentShipping Agent ServicesTax Area
Dynamics 365 BC Table ReferenceTablesCompany TablesSSales Header

Leave a Reply

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