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

Show/hide tables related from Service Header table

Leave a Reply

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