Sales 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
   [timestamp]
   ,[Document Type]
   ,[No_]
   ,[Doc_ No_ Occurrence]
   ,[Version No_]
   ,[Sell-to Customer No_]
   ,[Bill-to Customer No_]
   ,[Bill-to Name]
   ,[Bill-to Name 2]
   ,[Bill-to Address]
   ,[Bill-to Address 2]
   ,[Bill-to City]
   ,[Bill-to Contact]
   ,[Your Reference]
   ,[Ship-to Code]
   ,[Ship-to Name]
   ,[Ship-to Name 2]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Contact]
   ,[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]
   ,[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 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]
   ,[Work Description]
   ,[Dimension Set ID]
   ,[Credit Card No_]
   ,[Interaction Exist]
   ,[Time Archived]
   ,[Date Archived]
   ,[Archived By]
   ,[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]
   ,[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]
   ,[Type of Supply Code]
   ,[$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_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Header Archive].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Header Archive].[Bill-to Customer No_] = [Customer].[No_]
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_$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_$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].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] 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] 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_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
      ON
         [Sales Header Archive].[Opportunity No_] = [Opportunity].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Sales Header Archive].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
      ON
         [Sales Header Archive].[Type of Supply Code] = [Type of Supply].[Code]

Show/hide columns in Sales Header Archive table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document Type Primary Key Searchint
3No_ Primary Key Searchnvarchar(40)
4Doc_ No_ Occurrence Primary Key Searchint
5Version No_ Primary Key Searchint
6Sell-to Customer No_ Searchnvarchar(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_]
7Bill-to Customer No_ Searchnvarchar(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_]
8Bill-to Name Searchnvarchar(200)
9Bill-to Name 2 Searchnvarchar(100)
10Bill-to Address Searchnvarchar(200)
11Bill-to Address 2 Searchnvarchar(100)
12Bill-to City Searchnvarchar(60)
13Bill-to Contact Searchnvarchar(200)
14Your Reference Searchnvarchar(70)
15Ship-to Code Searchnvarchar(20)
16Ship-to Name Searchnvarchar(200)
17Ship-to Name 2 Searchnvarchar(100)
18Ship-to Address Searchnvarchar(200)
19Ship-to Address 2 Searchnvarchar(100)
20Ship-to City Searchnvarchar(60)
21Ship-to Contact Searchnvarchar(200)
22Order Date Searchdatetime
23Posting Date Searchdatetime
24Shipment Date Searchdatetime
25Posting Description Searchnvarchar(200)
26Payment Terms Code Searchnvarchar(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]
27Due Date Searchdatetime
28Payment Discount _ Searchdecimal(38,38)
29Pmt_ Discount Date Searchdatetime
30Shipment Method Code Searchnvarchar(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]
31Location Code Searchnvarchar(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]
32Shortcut Dimension 1 Code Searchnvarchar(40)
33Shortcut Dimension 2 Code Searchnvarchar(40)
34Customer Posting Group Searchnvarchar(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]
35Currency Code Searchnvarchar(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]
36Currency Factor Searchdecimal(38,38)
37Price Group Code Searchnvarchar(20)
38Prices Including VAT Searchtinyint
39Invoice Disc_ Code Searchnvarchar(40)
40Cust__Item Disc_ Gr_ Searchnvarchar(40)
41Language Code Searchnvarchar(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]
42Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Sales Header Archive].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
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].[No_]
43Order Class Searchnvarchar(20)
44No_ Printed Searchint
45On Hold Searchnvarchar(6)
46Applies-to Doc_ Type Searchint
47Applies-to Doc_ No_ Searchnvarchar(40)
48Bal_ Account No_ Searchnvarchar(40)
49Ship Searchtinyint
50Invoice Searchtinyint
51Shipping No_ Searchnvarchar(40)
52Posting No_ Searchnvarchar(40)
53Last Shipping No_ Searchnvarchar(40)
54Last Posting No_ Searchnvarchar(40)
55Prepayment No_ Searchnvarchar(40)
56Last Prepayment No_ Searchnvarchar(40)
57Prepmt_ Cr_ Memo No_ Searchnvarchar(40)
58Last Prepmt_ Cr_ Memo No_ Searchnvarchar(40)
59VAT Registration No_ Searchnvarchar(40)
60Combine Shipments Searchtinyint
61Reason Code Searchnvarchar(20)
62Gen_ Bus_ Posting Group Searchnvarchar(40)
63EU 3-Party Trade Searchtinyint
64Transaction Type Searchnvarchar(20)
65Transport Method Searchnvarchar(20)
66VAT Country_Region Code Searchnvarchar(20)
67Sell-to Customer Name Searchnvarchar(200)
68Sell-to Customer Name 2 Searchnvarchar(100)
69Sell-to Address Searchnvarchar(200)
70Sell-to Address 2 Searchnvarchar(100)
71Sell-to City Searchnvarchar(60)
72Sell-to Contact Searchnvarchar(200)
73Bill-to Post Code Searchnvarchar(40)
74Bill-to County Searchnvarchar(60)
75Bill-to Country_Region Code Searchnvarchar(20)
76Sell-to Post Code Searchnvarchar(40)
77Sell-to County Searchnvarchar(60)
78Sell-to Country_Region Code Searchnvarchar(20)
79Ship-to Post Code Searchnvarchar(40)
80Ship-to County Searchnvarchar(60)
81Ship-to Country_Region Code Searchnvarchar(20)
82Bal_ Account Type Searchint
83Exit Point Searchnvarchar(20)
84Correction Searchtinyint
85Document Date Searchdatetime
86External Document No_ Searchnvarchar(70)
87Area Searchnvarchar(20)
88Transaction Specification Searchnvarchar(20)
89Payment Method Code Searchnvarchar(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] AS [Payment Method]
              ON
                     [Sales Header Archive].[Payment Method Code] = [Payment Method].[Code]
90Shipping Agent Code Searchnvarchar(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] AS [Shipping Agent]
              ON
                     [Sales Header Archive].[Shipping Agent Code] = [Shipping Agent].[Code]
91Package Tracking No_ Searchnvarchar(60)
92No_ Series Searchnvarchar(40)
93Posting No_ Series Searchnvarchar(40)
94Shipping No_ Series Searchnvarchar(40)
95Tax Area Code Searchnvarchar(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]
96Tax Liable Searchtinyint
97VAT Bus_ Posting Group Searchnvarchar(40)
98Reserve Searchint
99Applies-to ID Searchnvarchar(100)
100VAT Base Discount _ Searchdecimal(38,38)
101Status Searchint
102Invoice Discount Calculation Searchint
103Invoice Discount Value Searchdecimal(38,38)
104Send IC Document Searchtinyint
105IC Status Searchint
106Sell-to IC Partner Code Searchnvarchar(40)
107Bill-to IC Partner Code Searchnvarchar(40)
108IC Direction Searchint
109Prepayment _ Searchdecimal(38,38)
110Prepayment No_ Series Searchnvarchar(40)
111Compress Prepayment Searchtinyint
112Prepayment Due Date Searchdatetime
113Prepmt_ Cr_ Memo No_ Series Searchnvarchar(40)
114Prepmt_ Posting Description Searchnvarchar(200)
115Prepmt_ Pmt_ Discount Date Searchdatetime
116Prepmt_ Payment Terms Code Searchnvarchar(20)
117Prepmt_ Payment Discount _ Searchdecimal(38,38)
118Sales Quote No_ Searchnvarchar(40)
119Quote Valid Until Date Searchdatetime
120Quote Sent to Customer Searchdatetime
121Quote Accepted Searchtinyint
122Quote Accepted Date Searchdatetime
123Company Bank Account Code Searchnvarchar(40)
124Sell-to Phone No_ Searchnvarchar(60)
125Sell-to E-Mail Searchnvarchar(160)
126Work Description Searchimage
127Dimension Set ID Searchint
128Credit Card No_ Searchnvarchar(40)
129Interaction Exist Searchtinyint
130Time Archived Searchdatetime
131Date Archived Searchdatetime
132Archived By Searchnvarchar(100)
133Campaign No_ Searchnvarchar(40)
134Sell-to Customer Template Code Searchnvarchar(20)
135Sell-to Contact No_ Searchnvarchar(40)
136Bill-to Contact No_ Searchnvarchar(40)
137Bill-to Customer Template Code Searchnvarchar(20)
138Opportunity No_ Searchnvarchar(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_]
139Sell-to Customer Templ_ Code Searchnvarchar(40)
140Responsibility Center Searchnvarchar(20)
141Shipping Advice Searchint
142Posting from Whse_ Ref_ Searchint
143Requested Delivery Date Searchdatetime
144Promised Delivery Date Searchdatetime
145Shipping Time Searchvarchar(32)
146Outbound Whse_ Handling Time Searchvarchar(32)
147Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Sales Header Archive].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Sales Header Archive].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
148Receive Searchtinyint
149Return Receipt No_ Searchnvarchar(40)
150Return Receipt No_ Series Searchnvarchar(40)
151Last Return Receipt No_ Searchnvarchar(40)
152Price Calculation Method Searchint
153Allow Line Disc_ Searchtinyint
154Get Shipment Used Searchtinyint
155Assigned User ID Searchnvarchar(100)
156Type of Supply Code Searchnvarchar(20)
Key to join to the Type of Supply table.

Show/hide example query

SELECT
       [Sales Header Archive].[Type of Supply Code]
       ,[Type of Supply].[Code]
FROM
       [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
              ON
                     [Sales Header Archive].[Type of Supply Code] = [Type of Supply].[Code]
157$systemId Searchuniqueidentifier
158$systemCreatedAt Searchdatetime
159$systemCreatedBy Searchuniqueidentifier
160$systemModifiedAt Searchdatetime
161$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales Header Archive table

Leave a Reply

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