Service Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SService Header

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

Table Type: Company

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

Table Number: 5900

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Document Type]
   ,[No_]
   ,[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]
   ,[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]
   ,[No_ Printed]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Bal_ Account No_]
   ,[Shipping No_]
   ,[Posting No_]
   ,[Last Shipping No_]
   ,[Last Posting No_]
   ,[VAT Registration No_]
   ,[Reason Code]
   ,[Gen_ Bus_ Posting Group]
   ,[EU 3-Party Trade]
   ,[Transaction Type]
   ,[Transport Method]
   ,[VAT Country_Region Code]
   ,[Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Contact Name]
   ,[Bill-to Post Code]
   ,[Bill-to County]
   ,[Bill-to Country_Region Code]
   ,[Post Code]
   ,[County]
   ,[Country_Region Code]
   ,[Ship-to Post Code]
   ,[Ship-to County]
   ,[Ship-to Country_Region Code]
   ,[Bal_ Account Type]
   ,[Exit Point]
   ,[Correction]
   ,[Document Date]
   ,[Area]
   ,[Transaction Specification]
   ,[Payment Method Code]
   ,[Shipping Agent Code]
   ,[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]
   ,[Company Bank Account Code]
   ,[Release Status]
   ,[Journal Templ_ Name]
   ,[Dimension Set ID]
   ,[Direct Debit Mandate ID]
   ,[Contact No_]
   ,[Bill-to Contact No_]
   ,[Responsibility Center]
   ,[Shipping Advice]
   ,[Shipping Time]
   ,[Shipping Agent Service Code]
   ,[Description]
   ,[Service Order Type]
   ,[Link Service to Service Item]
   ,[Priority]
   ,[Phone No_]
   ,[E-Mail]
   ,[Phone No_ 2]
   ,[Fax No_]
   ,[Order Time]
   ,[Default Response Time (Hours)]
   ,[Actual Response Time (Hours)]
   ,[Service Time (Hours)]
   ,[Response Date]
   ,[Response Time]
   ,[Starting Date]
   ,[Starting Time]
   ,[Finishing Date]
   ,[Finishing Time]
   ,[Notify Customer]
   ,[Max_ Labor Unit Price]
   ,[Warning Status]
   ,[Contract No_]
   ,[Ship-to Fax No_]
   ,[Ship-to E-Mail]
   ,[Ship-to Phone]
   ,[Ship-to Phone 2]
   ,[Service Zone Code]
   ,[Expected Finishing Date]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Assigned User ID]
   ,[Quote No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Service 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_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Header].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Header].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Service Header].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Service Header].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Service Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Service Header].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Service Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Service 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
         [Service Header].[Customer Disc_ Group] = [Customer Discount Group].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Service Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Service Header].[Salesperson Code] = [Salesperson_Purchaser].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Service Header].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Service Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Service Header].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Service Header].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Service Header].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]

Show/hide columns in Service Header table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Document Type	int
3	No_	nvarchar(40)
4	Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Service Header].[Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Service Header].[Customer No_] = [Customer].[No_]
5	Bill-to Customer No_	nvarchar(40)
	Key to join to the Customer table. Show/hide example query SELECT [Service Header].[Bill-to Customer No_] ,[Customer].[No_] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [Service 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	Posting Description	nvarchar(200)
23	Payment Terms Code	nvarchar(20)
	Key to join to the Payment Terms table. Show/hide example query SELECT [Service Header].[Payment Terms Code] ,[Payment Terms].[Code] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms] ON [Service Header].[Payment Terms Code] = [Payment Terms].[Code]
24	Due Date	datetime
25	Payment Discount _	decimal(38,38)
26	Pmt_ Discount Date	datetime
27	Shipment Method Code	nvarchar(20)
	Key to join to the Shipment Method table. Show/hide example query SELECT [Service Header].[Shipment Method Code] ,[Shipment Method].[Code] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method] ON [Service Header].[Shipment Method Code] = [Shipment Method].[Code]
28	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Service Header].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Service Header].[Location Code] = [Location].[Code]
29	Shortcut Dimension 1 Code	nvarchar(40)
30	Shortcut Dimension 2 Code	nvarchar(40)
31	Customer Posting Group	nvarchar(40)
	Key to join to the Customer Posting Group table. Show/hide example query SELECT [Service Header].[Customer Posting Group] ,[Customer Posting Group].[Code] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group] ON [Service Header].[Customer Posting Group] = [Customer Posting Group].[Code]
32	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [Service Header].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [Service Header].[Currency Code] = [Currency].[Code]
33	Currency Factor	decimal(38,38)
34	Customer Price Group	nvarchar(20)
	Key to join to the Customer Price Group table. Show/hide example query SELECT [Service Header].[Customer Price Group] ,[Customer Price Group].[Code] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group] ON [Service Header].[Customer Price Group] = [Customer Price Group].[Code]
35	Prices Including VAT	tinyint
36	Invoice Disc_ Code	nvarchar(40)
37	Customer Disc_ Group	nvarchar(40)
	Key to join to the Customer Discount Group table. Show/hide example query SELECT [Service Header].[Customer Disc_ Group] ,[Customer Discount Group].[No_] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group] ON [Service Header].[Customer Disc_ Group] = [Customer Discount Group].[No_]
38	Language Code	nvarchar(20)
	Key to join to the Language table. Show/hide example query SELECT [Service Header].[Language Code] ,[Language].[Code] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language] ON [Service Header].[Language Code] = [Language].[Code]
39	Salesperson Code	nvarchar(40)
	Key to join to the Salesperson_Purchaser table. Show/hide example query SELECT [Service Header].[Salesperson Code] ,[Salesperson_Purchaser].[No_] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser] ON [Service Header].[Salesperson Code] = [Salesperson_Purchaser].[No_]
40	No_ Printed	int
41	Applies-to Doc_ Type	int
42	Applies-to Doc_ No_	nvarchar(40)
43	Bal_ Account No_	nvarchar(40)
44	Shipping No_	nvarchar(40)
45	Posting No_	nvarchar(40)
46	Last Shipping No_	nvarchar(40)
47	Last Posting No_	nvarchar(40)
48	VAT Registration No_	nvarchar(40)
49	Reason Code	nvarchar(20)
50	Gen_ Bus_ Posting Group	nvarchar(40)
51	EU 3-Party Trade	tinyint
52	Transaction Type	nvarchar(20)
53	Transport Method	nvarchar(20)
54	VAT Country_Region Code	nvarchar(20)
55	Name	nvarchar(200)
56	Name 2	nvarchar(100)
57	Address	nvarchar(200)
58	Address 2	nvarchar(100)
59	City	nvarchar(60)
60	Contact Name	nvarchar(200)
61	Bill-to Post Code	nvarchar(40)
62	Bill-to County	nvarchar(60)
63	Bill-to Country_Region Code	nvarchar(20)
64	Post Code	nvarchar(40)
65	County	nvarchar(60)
66	Country_Region Code	nvarchar(20)
	Key to join to the Country_Region table. Show/hide example query SELECT [Service Header].[Country_Region Code] ,[Country_Region].[Code] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region] ON [Service Header].[Country_Region Code] = [Country_Region].[Code]
67	Ship-to Post Code	nvarchar(40)
68	Ship-to County	nvarchar(60)
69	Ship-to Country_Region Code	nvarchar(20)
70	Bal_ Account Type	int
71	Exit Point	nvarchar(20)
72	Correction	tinyint
73	Document Date	datetime
74	Area	nvarchar(20)
75	Transaction Specification	nvarchar(20)
76	Payment Method Code	nvarchar(20)
	Key to join to the Payment Method table. Show/hide example query SELECT [Service Header].[Payment Method Code] ,[Payment Method].[Code] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method] ON [Service Header].[Payment Method Code] = [Payment Method].[Code]
77	Shipping Agent Code	nvarchar(20)
	Key to join to the Shipping Agent table. Show/hide example query SELECT [Service Header].[Shipping Agent Code] ,[Shipping Agent].[Code] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent] ON [Service Header].[Shipping Agent Code] = [Shipping Agent].[Code]
78	No_ Series	nvarchar(40)
79	Posting No_ Series	nvarchar(40)
80	Shipping No_ Series	nvarchar(40)
81	Tax Area Code	nvarchar(40)
	Key to join to the Tax Area table. Show/hide example query SELECT [Service Header].[Tax Area Code] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Service Header].[Tax Area Code] = [Tax Area].[Code]
82	Tax Liable	tinyint
83	VAT Bus_ Posting Group	nvarchar(40)
84	Reserve	int
85	Applies-to ID	nvarchar(100)
86	VAT Base Discount _	decimal(38,38)
87	Status	int
88	Invoice Discount Calculation	int
89	Invoice Discount Value	decimal(38,38)
90	Company Bank Account Code	nvarchar(40)
91	Release Status	int
92	Journal Templ_ Name	nvarchar(20)
93	Dimension Set ID	int
94	Direct Debit Mandate ID	nvarchar(70)
95	Contact No_	nvarchar(40)
96	Bill-to Contact No_	nvarchar(40)
97	Responsibility Center	nvarchar(20)
98	Shipping Advice	int
99	Shipping Time	varchar(32)
100	Shipping Agent Service Code	nvarchar(20)
	Key to join to the Shipping Agent Services table. Show/hide example query SELECT [Service Header].[Shipping Agent Service Code] ,[Shipping Agent Services].[Code] FROM [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header] LEFT JOIN [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services] ON [Service Header].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
101	Description	nvarchar(200)
102	Service Order Type	nvarchar(20)
103	Link Service to Service Item	tinyint
104	Priority	int
105	Phone No_	nvarchar(60)
106	E-Mail	nvarchar(160)
107	Phone No_ 2	nvarchar(60)
108	Fax No_	nvarchar(60)
109	Order Time	datetime
110	Default Response Time (Hours)	decimal(38,38)
111	Actual Response Time (Hours)	decimal(38,38)
112	Service Time (Hours)	decimal(38,38)
113	Response Date	datetime
114	Response Time	datetime
115	Starting Date	datetime
116	Starting Time	datetime
117	Finishing Date	datetime
118	Finishing Time	datetime
119	Notify Customer	int
120	Max_ Labor Unit Price	decimal(38,38)
121	Warning Status	int
122	Contract No_	nvarchar(40)
123	Ship-to Fax No_	nvarchar(60)
124	Ship-to E-Mail	nvarchar(160)
125	Ship-to Phone	nvarchar(60)
126	Ship-to Phone 2	nvarchar(60)
127	Service Zone Code	nvarchar(20)
128	Expected Finishing Date	datetime
129	Price Calculation Method	int
130	Allow Line Disc_	tinyint
131	Assigned User ID	nvarchar(100)
132	Quote No_	nvarchar(40)
133	$systemId	uniqueidentifier
134	$systemCreatedAt	datetime
135	$systemCreatedBy	uniqueidentifier
136	$systemModifiedAt	datetime
137	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Service Header table

Country_Region Currency Customer Customer Discount Group Customer Posting Group Customer Price Group Language Location Payment Method Payment Terms Salesperson_Purchaser Shipment Method Shipping Agent Shipping Agent Services Tax Area

Dynamics 365 BC Table Reference Tables Company Tables SService Header

Leave a Reply Cancel reply