Service 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 IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Customer No_ Searchnvarchar(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_]
4Bill-to Customer No_ Searchnvarchar(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_]
5Bill-to Name Searchnvarchar(200)
6Bill-to Name 2 Searchnvarchar(100)
7Bill-to Address Searchnvarchar(200)
8Bill-to Address 2 Searchnvarchar(100)
9Bill-to City Searchnvarchar(60)
10Bill-to Contact Searchnvarchar(200)
11Your Reference Searchnvarchar(70)
12Ship-to Code Searchnvarchar(20)
13Ship-to Name Searchnvarchar(200)
14Ship-to Name 2 Searchnvarchar(100)
15Ship-to Address Searchnvarchar(200)
16Ship-to Address 2 Searchnvarchar(100)
17Ship-to City Searchnvarchar(60)
18Ship-to Contact Searchnvarchar(200)
19Order Date Searchdatetime
20Posting Date Searchdatetime
21Posting Description Searchnvarchar(200)
22Payment Terms Code Searchnvarchar(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]
23Due Date Searchdatetime
24Payment Discount _ Searchdecimal(38,38)
25Pmt_ Discount Date Searchdatetime
26Location Code Searchnvarchar(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]
27Shortcut Dimension 1 Code Searchnvarchar(40)
28Shortcut Dimension 2 Code Searchnvarchar(40)
29Customer Posting Group Searchnvarchar(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]
30Currency Code Searchnvarchar(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]
31Currency Factor Searchdecimal(38,38)
32Customer Price Group Searchnvarchar(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]
33Prices Including VAT Searchtinyint
34Invoice Disc_ Code Searchnvarchar(40)
35Customer Disc_ Group Searchnvarchar(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_]
36Language Code Searchnvarchar(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]
37Salesperson Code Searchnvarchar(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_]
38Order No_ Searchnvarchar(40)
39No_ Printed Searchint
40Applies-to Doc_ Type Searchint
41Applies-to Doc_ No_ Searchnvarchar(40)
42Bal_ Account No_ Searchnvarchar(40)
43VAT Registration No_ Searchnvarchar(40)
44Reason Code Searchnvarchar(20)
45Gen_ Bus_ Posting Group Searchnvarchar(40)
46EU 3-Party Trade Searchtinyint
47Transaction Type Searchnvarchar(20)
48Transport Method Searchnvarchar(20)
49VAT Country_Region Code Searchnvarchar(20)
50Name Searchnvarchar(200)
51Name 2 Searchnvarchar(100)
52Address Searchnvarchar(200)
53Address 2 Searchnvarchar(100)
54City Searchnvarchar(60)
55Contact Name Searchnvarchar(200)
56Bill-to Post Code Searchnvarchar(40)
57Bill-to County Searchnvarchar(60)
58Bill-to Country_Region Code Searchnvarchar(20)
59Post Code Searchnvarchar(40)
60County Searchnvarchar(60)
61Country_Region Code Searchnvarchar(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]
62Ship-to Post Code Searchnvarchar(40)
63Ship-to County Searchnvarchar(60)
64Ship-to Country_Region Code Searchnvarchar(20)
65Bal_ Account Type Searchint
66Exit Point Searchnvarchar(20)
67Correction Searchtinyint
68Document Date Searchdatetime
69Area Searchnvarchar(20)
70Transaction Specification Searchnvarchar(20)
71Payment Method Code Searchnvarchar(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]
72No_ Series Searchnvarchar(40)
73Order No_ Series Searchnvarchar(40)
74User ID Searchnvarchar(100)
75Source Code Searchnvarchar(20)
76Tax Area Code Searchnvarchar(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]
77Tax Liable Searchtinyint
78VAT Bus_ Posting Group Searchnvarchar(40)
79VAT Base Discount _ Searchdecimal(38,38)
80Company Bank Account Code Searchnvarchar(40)
81Dimension Set ID Searchint
82Contact No_ Searchnvarchar(40)
83Bill-to Contact No_ Searchnvarchar(40)
84Responsibility Center Searchnvarchar(20)
85Description Searchnvarchar(200)
86Service Order Type Searchnvarchar(20)
87Link Service to Service Item Searchtinyint
88Priority Searchint
89Phone No_ Searchnvarchar(60)
90E-Mail Searchnvarchar(160)
91Phone No_ 2 Searchnvarchar(60)
92Fax No_ Searchnvarchar(60)
93Order Time Searchdatetime
94Default Response Time (Hours) Searchdecimal(38,38)
95Actual Response Time (Hours) Searchdecimal(38,38)
96Service Time (Hours) Searchdecimal(38,38)
97Response Date Searchdatetime
98Response Time Searchdatetime
99Starting Date Searchdatetime
100Starting Time Searchdatetime
101Finishing Date Searchdatetime
102Finishing Time Searchdatetime
103Notify Customer Searchint
104Max_ Labor Unit Price Searchdecimal(38,38)
105Warning Status Searchint
106Contract No_ Searchnvarchar(40)
107Ship-to Fax No_ Searchnvarchar(60)
108Ship-to E-Mail Searchnvarchar(160)
109Ship-to Phone Searchnvarchar(60)
110Ship-to Phone 2 Searchnvarchar(60)
111Service Zone Code Searchnvarchar(20)
112Expected Finishing Date Searchdatetime
113Price Calculation Method Searchint
114Allow Line Disc_ Searchtinyint
115$systemId Searchuniqueidentifier
116$systemCreatedAt Searchdatetime
117$systemCreatedBy Searchuniqueidentifier
118$systemModifiedAt Searchdatetime
119$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Shipment Header table

Leave a Reply

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