Sales Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SSales 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Document Type	int
3	No_	nvarchar(40)
4	Sell-to Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Sales Header].[Sell-to Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Sales Header].[Sell-to Customer No_] = [Customer].[No_]
5	Bill-to Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Sales Header].[Bill-to Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Sales Header].[Bill-to Customer No_] = [Customer].[No_]
6	Bill-to Name	nvarchar(200)
7	Bill-to Name 2	nvarchar(100)
8	Bill-to Address	nvarchar(200)
9	Bill-to Address 2	nvarchar(100)
10	Bill-to City	nvarchar(60)
11	Bill-to Contact	nvarchar(200)
12	Your Reference	nvarchar(70)
13	Ship-to Code	nvarchar(20)
14	Ship-to Name	nvarchar(200)
15	Ship-to Name 2	nvarchar(100)
16	Ship-to Address	nvarchar(200)
17	Ship-to Address 2	nvarchar(100)
18	Ship-to City	nvarchar(60)
19	Ship-to Contact	nvarchar(200)
20	Order Date	datetime
21	Posting Date	datetime
22	Shipment Date	datetime
23	Posting Description	nvarchar(200)
24	Payment Terms Code	nvarchar(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]
25	Due Date	datetime
26	Payment Discount _	decimal(38,38)
27	Pmt_ Discount Date	datetime
28	Shipment Method Code	nvarchar(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]
29	Location Code	nvarchar(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]
30	Shortcut Dimension 1 Code	nvarchar(40)
31	Shortcut Dimension 2 Code	nvarchar(40)
32	Customer Posting Group	nvarchar(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]
33	Currency Code	nvarchar(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]
34	Currency Factor	decimal(38,38)
35	Customer Price Group	nvarchar(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]
36	Prices Including VAT	tinyint
37	Invoice Disc_ Code	nvarchar(40)
38	Customer Disc_ Group	nvarchar(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_]
39	Language Code	nvarchar(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]
40	Salesperson Code	nvarchar(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_]
41	Order Class	nvarchar(20)
42	No_ Printed	int
43	On Hold	nvarchar(6)
44	Applies-to Doc_ Type	int
45	Applies-to Doc_ No_	nvarchar(40)
46	Bal_ Account No_	nvarchar(40)
47	Ship	tinyint
48	Invoice	tinyint
49	Print Posted Documents	tinyint
50	Shipping No_	nvarchar(40)
51	Posting No_	nvarchar(40)
52	Last Shipping No_	nvarchar(40)
53	Last Posting No_	nvarchar(40)
54	Prepayment No_	nvarchar(40)
55	Last Prepayment No_	nvarchar(40)
56	Prepmt_ Cr_ Memo No_	nvarchar(40)
57	Last Prepmt_ Cr_ Memo No_	nvarchar(40)
58	VAT Registration No_	nvarchar(40)
59	Combine Shipments	tinyint
60	Reason Code	nvarchar(20)
61	Gen_ Bus_ Posting Group	nvarchar(40)
62	EU 3-Party Trade	tinyint
63	Transaction Type	nvarchar(20)
64	Transport Method	nvarchar(20)
65	VAT Country_Region Code	nvarchar(20)
66	Sell-to Customer Name	nvarchar(200)
67	Sell-to Customer Name 2	nvarchar(100)
68	Sell-to Address	nvarchar(200)
69	Sell-to Address 2	nvarchar(100)
70	Sell-to City	nvarchar(60)
71	Sell-to Contact	nvarchar(200)
72	Bill-to Post Code	nvarchar(40)
73	Bill-to County	nvarchar(60)
74	Bill-to Country_Region Code	nvarchar(20)
75	Sell-to Post Code	nvarchar(40)
76	Sell-to County	nvarchar(60)
77	Sell-to Country_Region Code	nvarchar(20)
78	Ship-to Post Code	nvarchar(40)
79	Ship-to County	nvarchar(60)
80	Ship-to Country_Region Code	nvarchar(20)
81	Bal_ Account Type	int
82	Exit Point	nvarchar(20)
83	Correction	tinyint
84	Document Date	datetime
85	External Document No_	nvarchar(70)
86	Area	nvarchar(20)
87	Transaction Specification	nvarchar(20)
88	Payment Method Code	nvarchar(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]
89	Shipping Agent Code	nvarchar(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]
90	Package Tracking No_	nvarchar(60)
91	No_ Series	nvarchar(40)
92	Posting No_ Series	nvarchar(40)
93	Shipping No_ Series	nvarchar(40)
94	Tax Area Code	nvarchar(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]
95	Tax Liable	tinyint
96	VAT Bus_ Posting Group	nvarchar(40)
97	Reserve	int
98	Applies-to ID	nvarchar(100)
99	VAT Base Discount _	decimal(38,38)
100	Status	int
101	Invoice Discount Calculation	int
102	Invoice Discount Value	decimal(38,38)
103	Send IC Document	tinyint
104	IC Status	int
105	Sell-to IC Partner Code	nvarchar(40)
106	Bill-to IC Partner Code	nvarchar(40)
107	IC Direction	int
108	Prepayment _	decimal(38,38)
109	Prepayment No_ Series	nvarchar(40)
110	Compress Prepayment	tinyint
111	Prepayment Due Date	datetime
112	Prepmt_ Cr_ Memo No_ Series	nvarchar(40)
113	Prepmt_ Posting Description	nvarchar(200)
114	Prepmt_ Pmt_ Discount Date	datetime
115	Prepmt_ Payment Terms Code	nvarchar(20)
116	Prepmt_ Payment Discount _	decimal(38,38)
117	Quote No_	nvarchar(40)
118	Quote Valid Until Date	datetime
119	Quote Sent to Customer	datetime
120	Quote Accepted	tinyint
121	Quote Accepted Date	datetime
122	Job Queue Status	int
123	Job Queue Entry ID	uniqueidentifier
124	Company Bank Account Code	nvarchar(40)
125	Incoming Document Entry No_	int
126	IsTest	tinyint
127	Sell-to Phone No_	nvarchar(60)
128	Sell-to E-Mail	nvarchar(160)
129	Payment Instructions Id	int
130	Journal Templ_ Name	nvarchar(20)
131	Work Description	image
132	Dimension Set ID	int
133	Payment Service Set ID	int
134	Direct Debit Mandate ID	nvarchar(70)
135	Doc_ No_ Occurrence	int
136	Campaign No_	nvarchar(40)
137	Sell-to Customer Template Code	nvarchar(20)
138	Sell-to Contact No_	nvarchar(40)
139	Bill-to Contact No_	nvarchar(40)
140	Bill-to Customer Template Code	nvarchar(20)
141	Opportunity No_	nvarchar(40)
	Key to join to the Opportunity table. Show/hide example query SELECT [Sales Header].[Opportunity No_] ,[Opportunity].[No_] FROM [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header] LEFT JOIN [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity] ON [Sales Header].[Opportunity No_] = [Opportunity].[No_]
142	Sell-to Customer Templ_ Code	nvarchar(40)
143	Bill-to Customer Templ_ Code	nvarchar(40)
144	Responsibility Center	nvarchar(20)
145	Shipping Advice	int
146	Posting from Whse_ Ref_	int
147	Requested Delivery Date	datetime
148	Promised Delivery Date	datetime
149	Shipping Time	varchar(32)
150	Outbound Whse_ Handling Time	varchar(32)
151	Shipping Agent Service Code	nvarchar(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]
152	Receive	tinyint
153	Return Receipt No_	nvarchar(40)
154	Return Receipt No_ Series	nvarchar(40)
155	Last Return Receipt No_	nvarchar(40)
156	Price Calculation Method	int
157	Allow Line Disc_	tinyint
158	Get Shipment Used	tinyint
159	Id	uniqueidentifier
160	Assigned User ID	nvarchar(100)
161	Type of Supply Code	nvarchar(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	uniqueidentifier
163	$systemCreatedAt	datetime
164	$systemCreatedBy	uniqueidentifier
165	$systemModifiedAt	datetime
166	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Sales Header table

Currency Customer Customer Discount Group Customer Posting Group Customer Price Group Language Location Opportunity Payment Method Payment Terms Salesperson_Purchaser Shipment Method Shipping Agent Shipping Agent Services Tax Area Type of Supply

Dynamics 365 BC Table Reference Tables Company Tables SSales Header

Leave a Reply Cancel reply