Service Shipment Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SService Shipment Header

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

Table Type: Company

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

Table Number: 5990

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[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]
   ,[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 No_]
   ,[No_ Printed]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Bal_ Account 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]
   ,[No_ Series]
   ,[Order No_ Series]
   ,[User ID]
   ,[Source Code]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[VAT Base Discount _]
   ,[Company Bank Account Code]
   ,[Dimension Set ID]
   ,[Contact No_]
   ,[Bill-to Contact No_]
   ,[Responsibility Center]
   ,[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_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Service Shipment Header table

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

Show/hide tables related from Service Shipment Header table

Country_Region Currency Customer Customer Discount Group Customer Posting Group Customer Price Group Language Location Payment Method Payment Terms Salesperson_Purchaser Tax Area

Dynamics 365 BC Table Reference Tables Company Tables SService Shipment Header

Leave a Reply Cancel reply