Sales Header Archive – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SSales Header Archive

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

Table Type: Company

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

Table Number: 5107

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Sales Header Archive$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]
   ,[Price Group Code]
   ,[Prices Including VAT]
   ,[Invoice Disc_ Code]
   ,[Cust__Item Disc_ Gr_]
   ,[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]
   ,[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 _]
   ,[Sales Quote No_]
   ,[Quote Valid Until Date]
   ,[Quote Sent to Customer]
   ,[Quote Accepted]
   ,[Quote Accepted Date]
   ,[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]
   ,[Credit Card No_]
   ,[Interaction Exist]
   ,[Time Archived]
   ,[Date Archived]
   ,[Archived By]
   ,[Version No_]
   ,[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]
   ,[Assigned User ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Sales Header Archive table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: “Quote” “Order” “Invoice” “Credit Memo” “Blanket Order” “Return Order”
2	Sell-to Customer No.	Sell-to Customer No.	Normal	Code	20	Sell-to Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Sales Header Archive].[Sell-to Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Sales Header Archive].[Sell-to Customer No_] = [Customer].[No_]
3	No.	No.	Normal	Code	20	No_	nvarchar(40)
4	Bill-to Customer No.	Bill-to Customer No.	Normal	Code	20	Bill-to Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Sales Header Archive].[Bill-to Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Sales Header Archive].[Bill-to Customer No_] = [Customer].[No_]
5	Bill-to Name	Name	Normal	Text	100	Bill-to Name	nvarchar(200)
	Key to join to the Customer table. Show/hide example query SELECT [Sales Header Archive].[Bill-to Name] ,[Customer].[Name] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Sales Header Archive].[Bill-to Name] = [Customer].[Name]
6	Bill-to Name 2	Name 2	Normal	Text	50	Bill-to Name 2	nvarchar(100)
7	Bill-to Address	Address	Normal	Text	100	Bill-to Address	nvarchar(200)
8	Bill-to Address 2	Address 2	Normal	Text	50	Bill-to Address 2	nvarchar(100)
9	Bill-to City	City	Normal	Text	30	Bill-to City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Sales Header Archive].[Bill-to City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Sales Header Archive].[Bill-to City] = [Post Code].[City]
10	Bill-to Contact	Contact	Normal	Text	100	Bill-to Contact	nvarchar(200)
11	Your Reference	Your Reference	Normal	Text	35	Your Reference	nvarchar(70)
12	Ship-to Code	Ship-to Code	Normal	Code	10	Ship-to Code	nvarchar(20)
	Key to join to the Ship-to Address table. Show/hide example query SELECT [Sales Header Archive].[Ship-to Code] ,[Ship-to Address].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address] ON [Sales Header Archive].[Ship-to Code] = [Ship-to Address].[Code]
13	Ship-to Name	Ship-to Name	Normal	Text	100	Ship-to Name	nvarchar(200)
14	Ship-to Name 2	Ship-to Name 2	Normal	Text	50	Ship-to Name 2	nvarchar(100)
15	Ship-to Address	Ship-to Address	Normal	Text	100	Ship-to Address	nvarchar(200)
16	Ship-to Address 2	Ship-to Address 2	Normal	Text	50	Ship-to Address 2	nvarchar(100)
17	Ship-to City	Ship-to City	Normal	Text	30	Ship-to City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Sales Header Archive].[Ship-to City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Sales Header Archive].[Ship-to City] = [Post Code].[City]
18	Ship-to Contact	Ship-to Contact	Normal	Text	100	Ship-to Contact	nvarchar(200)
19	Order Date	Order Date	Normal	Date	4	Order Date	datetime
20	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
21	Shipment Date	Shipment Date	Normal	Date	4	Shipment Date	datetime
22	Posting Description	Posting Description	Normal	Text	100	Posting Description	nvarchar(200)
23	Payment Terms Code	Payment Terms Code	Normal	Code	10	Payment Terms Code	nvarchar(20)
	Key to join to the Payment Terms table. Show/hide example query SELECT [Sales Header Archive].[Payment Terms Code] ,[Payment Terms].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms] ON [Sales Header Archive].[Payment Terms Code] = [Payment Terms].[Code]
24	Due Date	Due Date	Normal	Date	4	Due Date	datetime
25	Payment Discount %	Payment Discount %	Normal	Decimal	12	Payment Discount _	decimal(38,38)
26	Pmt. Discount Date	Pmt. Discount Date	Normal	Date	4	Pmt_ Discount Date	datetime
27	Shipment Method Code	Shipment Method Code	Normal	Code	10	Shipment Method Code	nvarchar(20)
	Key to join to the Shipment Method table. Show/hide example query SELECT [Sales Header Archive].[Shipment Method Code] ,[Shipment Method].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method] ON [Sales Header Archive].[Shipment Method Code] = [Shipment Method].[Code]
28	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Sales Header Archive].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Sales Header Archive].[Location Code] = [Location].[Code]
29	Shortcut Dimension 1 Code	Shortcut Dimension 1 Code	Normal	Code	20	Shortcut Dimension 1 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Sales Header Archive].[Shortcut Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Sales Header Archive].[Shortcut Dimension 1 Code] = [Dimension].[Code]
30	Shortcut Dimension 2 Code	Shortcut Dimension 2 Code	Normal	Code	20	Shortcut Dimension 2 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Sales Header Archive].[Shortcut Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Sales Header Archive].[Shortcut Dimension 2 Code] = [Dimension].[Code]
31	Customer Posting Group	Customer Posting Group	Normal	Code	20	Customer Posting Group	nvarchar(40)
	Key to join to the Customer Posting Group table. Show/hide example query SELECT [Sales Header Archive].[Customer Posting Group] ,[Customer Posting Group].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group] ON [Sales Header Archive].[Customer Posting Group] = [Customer Posting Group].[Code]
32	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Sales Header Archive].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Sales Header Archive].[Currency Code] = [Currency].[Code]
33	Currency Factor	Currency Factor	Normal	Decimal	12	Currency Factor	decimal(38,38)
34	Price Group Code	Price Group Code	Normal	Code	10	Price Group Code	nvarchar(20)
	Key to join to the Customer Price Group table. Show/hide example query SELECT [Sales Header Archive].[Price Group Code] ,[Customer Price Group].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group] ON [Sales Header Archive].[Price Group Code] = [Customer Price Group].[Code]
35	Prices Including VAT	Prices Including Tax	Normal	Boolean	4	Prices Including VAT	tinyint
37	Invoice Disc. Code	Invoice Disc. Code	Normal	Code	20	Invoice Disc_ Code	nvarchar(40)
40	Cust./Item Disc. Gr.	Cust./Item Disc. Gr.	Normal	Code	20	Cust__Item Disc_ Gr_	nvarchar(40)
41	Language Code	Language Code	Normal	Code	10	Language Code	nvarchar(20)
	Key to join to the Language table. Show/hide example query SELECT [Sales Header Archive].[Language Code] ,[Language].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language] ON [Sales Header Archive].[Language Code] = [Language].[Code]
42	Format Region	Format Region	Normal	Text	80	Format Region	nvarchar(160)
43	Salesperson Code	Salesperson Code	Normal	Code	20	Salesperson Code	nvarchar(40)
	Key to join to the Salesperson/Purchaser table. Show/hide example query SELECT [Sales Header Archive].[Salesperson Code] ,[Salesperson/Purchaser].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser] ON [Sales Header Archive].[Salesperson Code] = [Salesperson/Purchaser].[Code]
45	Order Class	Order Class	Normal	Code	10	Order Class	nvarchar(20)
46	Comment	Comment	FlowField	Boolean	4
47	No. Printed	No. Printed	Normal	Integer	4	No_ Printed	int
51	On Hold	On Hold	Normal	Code	3	On Hold	nvarchar(6)
52	Applies-to Doc. Type	Applies-to Doc. Type	Normal	Option	4	Applies-to Doc_ Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
53	Applies-to Doc. No.	Applies-to Doc. No.	Normal	Code	20	Applies-to Doc_ No_	nvarchar(40)
55	Bal. Account No.	Bal. Account No.	Normal	Code	20	Bal_ Account No_	nvarchar(40)
57	Ship	Ship	Normal	Boolean	4	Ship	tinyint
58	Invoice	Invoice	Normal	Boolean	4	Invoice	tinyint
60	Amount	Amount	FlowField	Decimal	12
61	Amount Including VAT	Amount Including Tax	FlowField	Decimal	12
62	Shipping No.	Shipping No.	Normal	Code	20	Shipping No_	nvarchar(40)
63	Posting No.	Posting No.	Normal	Code	20	Posting No_	nvarchar(40)
64	Last Shipping No.	Last Shipping No.	Normal	Code	20	Last Shipping No_	nvarchar(40)
	Key to join to the Posted Whse. Shipment Header table. Show/hide example query SELECT [Sales Header Archive].[Last Shipping No_] ,[Posted Whse. Shipment Header].[No_] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Posted Whse_ Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse. Shipment Header] ON [Sales Header Archive].[Last Shipping No_] = [Posted Whse. Shipment Header].[No_]
65	Last Posting No.	Last Posting No.	Normal	Code	20	Last Posting No_	nvarchar(40)
66	Prepayment No.	Prepayment No.	Normal	Code	20	Prepayment No_	nvarchar(40)
67	Last Prepayment No.	Last Prepayment No.	Normal	Code	20	Last Prepayment No_	nvarchar(40)
68	Prepmt. Cr. Memo No.	Prepmt. Cr. Memo No.	Normal	Code	20	Prepmt_ Cr_ Memo No_	nvarchar(40)
69	Last Prepmt. Cr. Memo No.	Last Prepmt. Cr. Memo No.	Normal	Code	20	Last Prepmt_ Cr_ Memo No_	nvarchar(40)
70	VAT Registration No.	Tax Registration No.	Normal	Text	20	VAT Registration No_	nvarchar(40)
71	Combine Shipments	Combine Shipments	Normal	Boolean	4	Combine Shipments	tinyint
73	Reason Code	Reason Code	Normal	Code	10	Reason Code	nvarchar(20)
	Key to join to the Reason Code table. Show/hide example query SELECT [Sales Header Archive].[Reason Code] ,[Reason Code].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code] ON [Sales Header Archive].[Reason Code] = [Reason Code].[Code]
74	Gen. Bus. Posting Group	Gen. Bus. Posting Group	Normal	Code	20	Gen_ Bus_ Posting Group	nvarchar(40)
	Key to join to the Gen. Business Posting Group table. Show/hide example query SELECT [Sales Header Archive].[Gen_ Bus_ Posting Group] ,[Gen. Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group] ON [Sales Header Archive].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
75	EU 3-Party Trade	EU 3-Party Trade	Normal	Boolean	4	EU 3-Party Trade	tinyint
76	Transaction Type	Transaction Type	Normal	Code	10	Transaction Type	nvarchar(20)
	Key to join to the Transaction Type table. Show/hide example query SELECT [Sales Header Archive].[Transaction Type] ,[Transaction Type].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type] ON [Sales Header Archive].[Transaction Type] = [Transaction Type].[Code]
77	Transport Method	Transport Method	Normal	Code	10	Transport Method	nvarchar(20)
	Key to join to the Transport Method table. Show/hide example query SELECT [Sales Header Archive].[Transport Method] ,[Transport Method].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method] ON [Sales Header Archive].[Transport Method] = [Transport Method].[Code]
78	VAT Country/Region Code	Tax Country/Region Code	Normal	Code	10	VAT Country_Region Code	nvarchar(20)
79	Sell-to Customer Name	Sell-to Customer Name	Normal	Text	100	Sell-to Customer Name	nvarchar(200)
	Key to join to the Customer table. Show/hide example query SELECT [Sales Header Archive].[Sell-to Customer Name] ,[Customer].[Name] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Sales Header Archive].[Sell-to Customer Name] = [Customer].[Name]
80	Sell-to Customer Name 2	Sell-to Customer Name 2	Normal	Text	50	Sell-to Customer Name 2	nvarchar(100)
81	Sell-to Address	Sell-to Address	Normal	Text	100	Sell-to Address	nvarchar(200)
82	Sell-to Address 2	Sell-to Address 2	Normal	Text	50	Sell-to Address 2	nvarchar(100)
83	Sell-to City	Sell-to City	Normal	Text	30	Sell-to City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Sales Header Archive].[Sell-to City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Sales Header Archive].[Sell-to City] = [Post Code].[City]
84	Sell-to Contact	Sell-to Contact	Normal	Text	100	Sell-to Contact	nvarchar(200)
85	Bill-to Post Code	ZIP Code	Normal	Code	20	Bill-to Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Sales Header Archive].[Bill-to Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Sales Header Archive].[Bill-to Post Code] = [Post Code].[Code]
86	Bill-to County	State	Normal	Text	30	Bill-to County	nvarchar(60)
87	Bill-to Country/Region Code	Country/Region Code	Normal	Code	10	Bill-to Country_Region Code	nvarchar(20)
88	Sell-to Post Code	Sell-to ZIP Code	Normal	Code	20	Sell-to Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Sales Header Archive].[Sell-to Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Sales Header Archive].[Sell-to Post Code] = [Post Code].[Code]
89	Sell-to County	Sell-to State	Normal	Text	30	Sell-to County	nvarchar(60)
90	Sell-to Country/Region Code	Sell-to Country/Region Code	Normal	Code	10	Sell-to Country_Region Code	nvarchar(20)
91	Ship-to Post Code	Ship-to ZIP Code	Normal	Code	20	Ship-to Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Sales Header Archive].[Ship-to Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Sales Header Archive].[Ship-to Post Code] = [Post Code].[Code]
92	Ship-to County	Ship-to State	Normal	Text	30	Ship-to County	nvarchar(60)
93	Ship-to Country/Region Code	Ship-to Country/Region Code	Normal	Code	10	Ship-to Country_Region Code	nvarchar(20)
94	Bal. Account Type	Bal. Account Type	Normal	Option	4	Bal_ Account Type	int
	Available options are: “G/L Account” “Bank Account”
97	Exit Point	Exit Point	Normal	Code	10	Exit Point	nvarchar(20)
	Key to join to the Entry/Exit Point table. Show/hide example query SELECT [Sales Header Archive].[Exit Point] ,[Entry/Exit Point].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point] ON [Sales Header Archive].[Exit Point] = [Entry/Exit Point].[Code]
98	Correction	Correction	Normal	Boolean	4	Correction	tinyint
99	Document Date	Document Date	Normal	Date	4	Document Date	datetime
100	External Document No.	External Document No.	Normal	Code	35	External Document No_	nvarchar(70)
101	Area	Area	Normal	Code	10	Area	nvarchar(20)
	Key to join to the Area table. Show/hide example query SELECT [Sales Header Archive].[Area] ,[Area].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area] ON [Sales Header Archive].[Area] = [Area].[Code]
102	Transaction Specification	Transaction Specification	Normal	Code	10	Transaction Specification	nvarchar(20)
	Key to join to the Transaction Specification table. Show/hide example query SELECT [Sales Header Archive].[Transaction Specification] ,[Transaction Specification].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification] ON [Sales Header Archive].[Transaction Specification] = [Transaction Specification].[Code]
104	Payment Method Code	Payment Method Code	Normal	Code	10	Payment Method Code	nvarchar(20)
	Key to join to the Payment Method table. Show/hide example query SELECT [Sales Header Archive].[Payment Method Code] ,[Payment Method].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method] ON [Sales Header Archive].[Payment Method Code] = [Payment Method].[Code]
105	Shipping Agent Code	Shipping Agent Code	Normal	Code	10	Shipping Agent Code	nvarchar(20)
	Key to join to the Shipping Agent table. Show/hide example query SELECT [Sales Header Archive].[Shipping Agent Code] ,[Shipping Agent].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent] ON [Sales Header Archive].[Shipping Agent Code] = [Shipping Agent].[Code]
106	Package Tracking No.	Package Tracking No.	Normal	Text	30	Package Tracking No_	nvarchar(60)
107	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Sales Header Archive].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Sales Header Archive].[No_ Series] = [No. Series].[Code]
108	Posting No. Series	Posting No. Series	Normal	Code	20	Posting No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Sales Header Archive].[Posting No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Sales Header Archive].[Posting No_ Series] = [No. Series].[Code]
109	Shipping No. Series	Shipping No. Series	Normal	Code	20	Shipping No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Sales Header Archive].[Shipping No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Sales Header Archive].[Shipping No_ Series] = [No. Series].[Code]
114	Tax Area Code	Tax Area Code	Normal	Code	20	Tax Area Code	nvarchar(40)
	Key to join to the Tax Area table. Show/hide example query SELECT [Sales Header Archive].[Tax Area Code] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Sales Header Archive].[Tax Area Code] = [Tax Area].[Code]
115	Tax Liable	Tax Liable	Normal	Boolean	4	Tax Liable	tinyint
116	VAT Bus. Posting Group	VAT Bus. Posting Group	Normal	Code	20	VAT Bus_ Posting Group	nvarchar(40)
	Key to join to the VAT Business Posting Group table. Show/hide example query SELECT [Sales Header Archive].[VAT Bus_ Posting Group] ,[VAT Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group] ON [Sales Header Archive].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
117	Reserve	Reserve	Normal	Option	4	Reserve	int
	Available options are: “Never” “Optional” “Always”
118	Applies-to ID	Applies-to ID	Normal	Code	50	Applies-to ID	nvarchar(100)
119	VAT Base Discount %	VAT Base Discount %	Normal	Decimal	12	VAT Base Discount _	decimal(38,38)
120	Status	Status	Normal	Option	4	Status	int
	Available options are: “Open” “Released” “Pending Approval” “Pending Prepayment”
121	Invoice Discount Calculation	Invoice Discount Calculation	Normal	Option	4	Invoice Discount Calculation	int
	Available options are: “None” “%” “Amount”
122	Invoice Discount Value	Invoice Discount Value	Normal	Decimal	12	Invoice Discount Value	decimal(38,38)
123	Send IC Document	Send IC Document	Normal	Boolean	4	Send IC Document	tinyint
124	IC Status	IC Status	Normal	Option	4	IC Status	int
	Available options are: “New” “Pending” “Sent”
125	Sell-to IC Partner Code	Sell-to IC Partner Code	Normal	Code	20	Sell-to IC Partner Code	nvarchar(40)
	Key to join to the IC Partner table. Show/hide example query SELECT [Sales Header Archive].[Sell-to IC Partner Code] ,[IC Partner].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner] ON [Sales Header Archive].[Sell-to IC Partner Code] = [IC Partner].[Code]
126	Bill-to IC Partner Code	IC Partner Code	Normal	Code	20	Bill-to IC Partner Code	nvarchar(40)
	Key to join to the IC Partner table. Show/hide example query SELECT [Sales Header Archive].[Bill-to IC Partner Code] ,[IC Partner].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner] ON [Sales Header Archive].[Bill-to IC Partner Code] = [IC Partner].[Code]
127	IC Reference Document No.	IC Reference Document No.	Normal	Code	20	IC Reference Document No_	nvarchar(40)
129	IC Direction	IC Direction	Normal	Option	4	IC Direction	int
	Available options are: “Outgoing” “Incoming”
130	Prepayment %	Prepayment %	Normal	Decimal	12	Prepayment _	decimal(38,38)
131	Prepayment No. Series	Prepayment No. Series	Normal	Code	20	Prepayment No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Sales Header Archive].[Prepayment No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Sales Header Archive].[Prepayment No_ Series] = [No. Series].[Code]
132	Compress Prepayment	Compress Prepayment	Normal	Boolean	4	Compress Prepayment	tinyint
133	Prepayment Due Date	Prepayment Due Date	Normal	Date	4	Prepayment Due Date	datetime
134	Prepmt. Cr. Memo No. Series	Prepmt. Cr. Memo No. Series	Normal	Code	20	Prepmt_ Cr_ Memo No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Sales Header Archive].[Prepmt_ Cr_ Memo No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Sales Header Archive].[Prepmt_ Cr_ Memo No_ Series] = [No. Series].[Code]
135	Prepmt. Posting Description	Prepmt. Posting Description	Normal	Text	100	Prepmt_ Posting Description	nvarchar(200)
138	Prepmt. Pmt. Discount Date	Prepmt. Pmt. Discount Date	Normal	Date	4	Prepmt_ Pmt_ Discount Date	datetime
139	Prepmt. Payment Terms Code	Prepmt. Payment Terms Code	Normal	Code	10	Prepmt_ Payment Terms Code	nvarchar(20)
	Key to join to the Payment Terms table. Show/hide example query SELECT [Sales Header Archive].[Prepmt_ Payment Terms Code] ,[Payment Terms].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms] ON [Sales Header Archive].[Prepmt_ Payment Terms Code] = [Payment Terms].[Code]
140	Prepmt. Payment Discount %	Prepmt. Payment Discount %	Normal	Decimal	12	Prepmt_ Payment Discount _	decimal(38,38)
145	No. of Archived Versions	No. of Archived Versions	FlowField	Integer	4
151	Sales Quote No.	Sales Quote No.	Normal	Code	20	Sales Quote No_	nvarchar(40)
152	Quote Valid Until Date	Quote Valid To Date	Normal	Date	4	Quote Valid Until Date	datetime
153	Quote Sent to Customer	Quote Sent to Customer	Normal	DateTime	8	Quote Sent to Customer	datetime
154	Quote Accepted	Quote Accepted	Normal	Boolean	4	Quote Accepted	tinyint
155	Quote Accepted Date	Quote Accepted Date	Normal	Date	4	Quote Accepted Date	datetime
163	Company Bank Account Code	Company Bank Account Code	Normal	Code	20	Company Bank Account Code	nvarchar(40)
171	Sell-to Phone No.	Sell-to Phone No.	Normal	Text	30	Sell-to Phone No_	nvarchar(60)
172	Sell-to E-Mail	Sell-to E-Mail	Normal	Text	80	Sell-to E-Mail	nvarchar(160)
179	VAT Reporting Date	Tax Date	Normal	Date	4	VAT Reporting Date	datetime
180	Rcvd-from Country/Region Code	Received-from Country/Region Code	Normal	Code	10	Rcvd-from Country_Region Code	nvarchar(20)
181	Rcvd.-from Count./Region Code	Received-from Country/Region Code	Normal	Code	10	Rcvd_-from Count__Region Code	nvarchar(20)
200	Work Description	Work Description	Normal	BLOB	8	Work Description	image
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	Key to join to the Dimension Set Entry table. Show/hide example query SELECT [Sales Header Archive].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [Sales Header Archive].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
827	Credit Card No.	Credit Card No.	Normal	Code	20	Credit Card No_	nvarchar(40)
3998	Source Doc. Exists	Source Doc. Exists	FlowField	Boolean	4
3999	Last Archived Date	Last Archived Date	FlowField	DateTime	8
5043	Interaction Exist	Interaction Exist	Normal	Boolean	4	Interaction Exist	tinyint
5044	Time Archived	Time Archived	Normal	Time	4	Time Archived	datetime
5045	Date Archived	Date Archived	Normal	Date	4	Date Archived	datetime
5046	Archived By	Archived By	Normal	Code	50	Archived By	nvarchar(100)
	Key to join to the User table. Show/hide example query SELECT [Sales Header Archive].[Archived By] ,[User].[User Name] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [User] AS [User] ON [Sales Header Archive].[Archived By] = [User].[User Name]
5047	Version No.	Version No.	Normal	Integer	4	Version No_	int
5048	Doc. No. Occurrence	Doc. No. Occurrence	Normal	Integer	4	Doc_ No_ Occurrence	int
5050	Campaign No.	Campaign No.	Normal	Code	20	Campaign No_	nvarchar(40)
	Key to join to the Campaign table. Show/hide example query SELECT [Sales Header Archive].[Campaign No_] ,[Campaign].[No_] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign] ON [Sales Header Archive].[Campaign No_] = [Campaign].[No_]
5051	Sell-to Customer Template Code	Sell-to Customer Template Code	Normal	Code	10	Sell-to Customer Template Code	nvarchar(20)
5052	Sell-to Contact No.	Sell-to Contact No.	Normal	Code	20	Sell-to Contact No_	nvarchar(40)
	Key to join to the Contact table. Show/hide example query SELECT [Sales Header Archive].[Sell-to Contact No_] ,[Contact].[No_] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact] ON [Sales Header Archive].[Sell-to Contact No_] = [Contact].[No_]
5053	Bill-to Contact No.	Bill-to Contact No.	Normal	Code	20	Bill-to Contact No_	nvarchar(40)
	Key to join to the Contact table. Show/hide example query SELECT [Sales Header Archive].[Bill-to Contact No_] ,[Contact].[No_] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact] ON [Sales Header Archive].[Bill-to Contact No_] = [Contact].[No_]
5054	Bill-to Customer Template Code	Bill-to Customer Template Code (obsoleted)	Normal	Code	10	Bill-to Customer Template Code	nvarchar(20)
5055	Opportunity No.	Opportunity No.	Normal	Code	20	Opportunity No_	nvarchar(40)
	Key to join to the Opportunity table. Show/hide example query SELECT [Sales Header Archive].[Opportunity No_] ,[Opportunity].[No_] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity] ON [Sales Header Archive].[Opportunity No_] = [Opportunity].[No_]
5056	Sell-to Customer Templ. Code	Sell-to Customer Template Code	Normal	Code	20	Sell-to Customer Templ_ Code	nvarchar(40)
	Key to join to the Customer Templ. table. Show/hide example query SELECT [Sales Header Archive].[Sell-to Customer Templ_ Code] ,[Customer Templ.].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] ON [Sales Header Archive].[Sell-to Customer Templ_ Code] = [Customer Templ.].[Code]
5057	Bill-to Customer Templ. Code	Bill-to Customer Template Code	Normal	Code	20	Bill-to Customer Templ_ Code	nvarchar(40)
	Key to join to the Customer Templ. table. Show/hide example query SELECT [Sales Header Archive].[Bill-to Customer Templ_ Code] ,[Customer Templ.].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Customer Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Templ.] ON [Sales Header Archive].[Bill-to Customer Templ_ Code] = [Customer Templ.].[Code]
5700	Responsibility Center	Responsibility Center	Normal	Code	10	Responsibility Center	nvarchar(20)
	Key to join to the Responsibility Center table. Show/hide example query SELECT [Sales Header Archive].[Responsibility Center] ,[Responsibility Center].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center] ON [Sales Header Archive].[Responsibility Center] = [Responsibility Center].[Code]
5750	Shipping Advice	Shipping Advice	Normal	Option	4	Shipping Advice	int
	Available options are: “Partial” “Complete”
5752	Completely Shipped	Completely Shipped	FlowField	Boolean	4
5753	Posting from Whse. Ref.	Posting from Whse. Ref.	Normal	Integer	4	Posting from Whse_ Ref_	int
5754	Location Filter	Location Filter	FlowFilter	Code	10
	Key to join to the Location table. Show/hide example query SELECT [Sales Header Archive].[] ,[Location].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Sales Header Archive].[] = [Location].[Code]
5790	Requested Delivery Date	Requested Delivery Date	Normal	Date	4	Requested Delivery Date	datetime
5791	Promised Delivery Date	Promised Delivery Date	Normal	Date	4	Promised Delivery Date	datetime
5792	Shipping Time	Shipping Time	Normal	DateFormula	32	Shipping Time	varchar(32)
5793	Outbound Whse. Handling Time	Outbound Whse. Handling Time	Normal	DateFormula	32	Outbound Whse_ Handling Time	varchar(32)
5794	Shipping Agent Service Code	Shipping Agent Service Code	Normal	Code	10	Shipping Agent Service Code	nvarchar(20)
5795	Late Order Shipping	Late Order Shipping	FlowField	Boolean	4
5796	Date Filter	Date Filter	FlowFilter	Date	4
5800	Receive	Receive	Normal	Boolean	4	Receive	tinyint
5801	Return Receipt No.	Return Receipt No.	Normal	Code	20	Return Receipt No_	nvarchar(40)
5802	Return Receipt No. Series	Return Receipt No. Series	Normal	Code	20	Return Receipt No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Sales Header Archive].[Return Receipt No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Sales Header Archive].[Return Receipt No_ Series] = [No. Series].[Code]
5803	Last Return Receipt No.	Last Return Receipt No.	Normal	Code	20	Last Return Receipt No_	nvarchar(40)
7000	Price Calculation Method	Price Calculation Method	Normal	Option	4	Price Calculation Method	int
	Available options are: ” “ “Lowest Price”
7001	Allow Line Disc.	Allow Line Disc.	Normal	Boolean	4	Allow Line Disc_	tinyint
7200	Get Shipment Used	Get Shipment Used	Normal	Boolean	4	Get Shipment Used	tinyint
9000	Assigned User ID	Assigned User ID	Normal	Code	50	Assigned User ID	nvarchar(100)
	Key to join to the User Setup table. Show/hide example query SELECT [Sales Header Archive].[Assigned User ID] ,[User Setup].[User ID] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup] ON [Sales Header Archive].[Assigned User ID] = [User Setup].[User ID]
10005	Ship-to UPS Zone	Ship-to UPS Zone	Normal	Code	2
10009	Outstanding Amount ($)	Outstanding Amount ($)	FlowField	Decimal	12
10015	Tax Exemption No.	Tax Exemption No.	Normal	Text	30
10018	STE Transaction ID	STE Transaction ID	Normal	Text	20
12600	Prepmt. Include Tax	Prepmt. Include Tax	Normal	Boolean	4
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Sales Header Archive].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive] LEFT JOIN [User] AS [User] ON [Sales Header Archive].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Sales Header Archive table

Dynamics 365 BC Table Reference Tables Company Tables SSales Header Archive

Leave a Reply Cancel reply