Sales 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: 0

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
   [timestamp]
   ,[Document Type]
   ,[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]
   ,[Customer Price Group]
   ,[Prices Including VAT]
   ,[Invoice Disc_ Code]
   ,[Customer Disc_ Group]
   ,[Language Code]
   ,[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 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]
   ,[Work Description]
   ,[Dimension Set ID]
   ,[Payment Service Set ID]
   ,[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]
   ,[Type of Supply Code]
   ,[$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_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Header].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Header].[Bill-to Customer No_] = [Customer].[No_]
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_$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_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Sales Header].[Customer Disc_ Group] = [Customer Discount Group].[No_]
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].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Sales Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] 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_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
      ON
         [Sales Header].[Opportunity No_] = [Opportunity].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Sales Header].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
      ON
         [Sales Header].[Type of Supply Code] = [Type of Supply].[Code]

Show/hide columns in Sales Header table

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

Show/hide example query

SELECT
       [Sales Header].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
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].[No_]
39Language Code Searchnvarchar(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]
40Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Sales Header].[Type of Supply Code]
       ,[Type of Supply].[Code]
FROM
       [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
LEFT JOIN
       [CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
              ON
                     [Sales Header].[Type of Supply Code] = [Type of Supply].[Code]
162$systemId Searchuniqueidentifier
163$systemCreatedAt Searchdatetime
164$systemCreatedBy Searchuniqueidentifier
165$systemModifiedAt Searchdatetime
166$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales Header table

Leave a Reply

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