Service Header

Dynamics 365 BC Table ReferenceTablesCompany TablesSService 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

   [Document Type]
   ,[Customer No_]
   ,[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]
   ,[Format Region]
   ,[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]
   ,[VAT Reporting Date]
   ,[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_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Service Header].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Service Header].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Service Header].[Document Type] = [Sales Header].[Document Type]
      AND
         [Service Header].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Header].[Bill-to Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Header].[Bill-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Service Header].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Header].[Ship-to City] = [Post Code].[City]
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_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Header].[Shortcut Dimension 2 Code] = [Dimension].[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_$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].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Service Header].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Service Header].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Service Header].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Header].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Header].[Bill-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Header].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Header].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
      ON
         [Service Header].[Exit Point] = [Entry/Exit Point].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Service Header].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Service Header].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Service Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] 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_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Service Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Service Header].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Service Header].[Location Filter] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Order Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Order Type]
      ON
         [Service Header].[Service Order Type] = [Service Order Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Header].[Customer Filter] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
      ON
         [Service Header].[Resource Filter] = [Resource].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group]
      ON
         [Service Header].[Resource Group Filter] = [Resource Group].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
      ON
         [Service Header].[Service Zone Filter] = [Service Zone].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
      ON
         [Service Header].[Service Zone Code] = [Service Zone].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Service Header].[Assigned User ID] = [User Setup].[User ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type Primary Key SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
2Customer No. SearchCustomer No.NormalCode20Customer 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_]
3No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
4Bill-to Customer No. SearchBill-to Customer No.NormalCode20Bill-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_]
5Bill-to Name SearchBill-to NameNormalText100Bill-to Namenvarchar(200)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Service Header].[Bill-to Name]
       ,[Customer].[Name]
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 Name] = [Customer].[Name]
6Bill-to Name 2 SearchBill-to Name 2NormalText50Bill-to Name 2nvarchar(100)
7Bill-to Address SearchBill-to AddressNormalText100Bill-to Addressnvarchar(200)
8Bill-to Address 2 SearchBill-to Address 2NormalText50Bill-to Address 2nvarchar(100)
9Bill-to City SearchBill-to CityNormalText30Bill-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Service Header].[Bill-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Service Header].[Bill-to City] = [Post Code].[City]
10Bill-to Contact SearchContactNormalText100Bill-to Contactnvarchar(200)
11Your Reference SearchYour ReferenceNormalText35Your Referencenvarchar(70)
12Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Service Header].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Service Header].[Ship-to Code] = [Ship-to Address].[Code]
13Ship-to Name SearchShip-to NameNormalText100Ship-to Namenvarchar(200)
14Ship-to Name 2 SearchShip-to Name 2NormalText50Ship-to Name 2nvarchar(100)
15Ship-to Address SearchShip-to AddressNormalText100Ship-to Addressnvarchar(200)
16Ship-to Address 2 SearchShip-to Address 2NormalText50Ship-to Address 2nvarchar(100)
17Ship-to City SearchShip-to CityNormalText30Ship-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Service Header].[Ship-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Service Header].[Ship-to City] = [Post Code].[City]
18Ship-to Contact SearchShip-to ContactNormalText100Ship-to Contactnvarchar(200)
19Order Date SearchOrder DateNormalDate4Order Datedatetime
20Posting Date SearchPosting DateNormalDate4Posting Datedatetime
22Posting Description SearchPosting DescriptionNormalText100Posting Descriptionnvarchar(200)
23Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(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 SearchDue DateNormalDate4Due Datedatetime
25Payment Discount % SearchPayment Discount %NormalDecimal12Payment Discount _decimal(38,38)
26Pmt. Discount Date SearchPmt. Discount DateNormalDate4Pmt_ Discount Datedatetime
27Shipment Method Code SearchShipment Method CodeNormalCode10Shipment Method Codenvarchar(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 SearchLocation CodeNormalCode10Location Codenvarchar(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 SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Service Header].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Service Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
30Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Service Header].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Service Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
31Customer Posting Group SearchCustomer Posting GroupNormalCode20Customer Posting Groupnvarchar(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 SearchCurrency CodeNormalCode10Currency Codenvarchar(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 SearchCurrency FactorNormalDecimal12Currency Factordecimal(38,38)
34Customer Price Group SearchCustomer Price GroupNormalCode10Customer Price Groupnvarchar(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 SearchPrices Including TaxNormalBoolean4Prices Including VATtinyint
37Invoice Disc. Code SearchInvoice Disc. CodeNormalCode20Invoice Disc_ Codenvarchar(40)
40Customer Disc. Group SearchCustomer Disc. GroupNormalCode20Customer Disc_ Groupnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Service Header].[Customer Disc_ Group]
       ,[Customer Discount Group].[Code]
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].[Code]
41Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(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]
42Format Region SearchFormat RegionNormalText80Format Regionnvarchar(160)
43Salesperson Code SearchSalesperson CodeNormalCode20Salesperson Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Service Header].[Salesperson Code]
       ,[Salesperson/Purchaser].[Code]
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].[Code]
46Comment SearchCommentFlowFieldBoolean4
47No. Printed SearchNo. PrintedNormalInteger4No_ Printedint
52Applies-to Doc. Type SearchApplies-to Doc. TypeNormalOption4Applies-to Doc_ Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
53Applies-to Doc. No. SearchApplies-to Doc. No.NormalCode20Applies-to Doc_ No_nvarchar(40)
55Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
62Shipping No. SearchShipping No.NormalCode20Shipping No_nvarchar(40)
63Posting No. SearchPosting No.NormalCode20Posting No_nvarchar(40)
64Last Shipping No. SearchLast Shipping No.NormalCode20Last Shipping No_nvarchar(40)
Key to join to the Posted Whse. Shipment Header table.

Show/hide example query

SELECT
       [Service Header].[Last Shipping No_]
       ,[Posted Whse. Shipment Header].[No_]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Posted Whse_ Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse. Shipment Header]
              ON
                     [Service Header].[Last Shipping No_] = [Posted Whse. Shipment Header].[No_]
65Last Posting No. SearchLast Posting No.NormalCode20Last Posting No_nvarchar(40)
70VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
73Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Service Header].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Service Header].[Reason Code] = [Reason Code].[Code]
74Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Service Header].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Service Header].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
75EU 3-Party Trade SearchEU 3-Party TradeNormalBoolean4EU 3-Party Tradetinyint
76Transaction Type SearchTransaction TypeNormalCode10Transaction Typenvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

SELECT
       [Service Header].[Transaction Type]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Service Header].[Transaction Type] = [Transaction Type].[Code]
77Transport Method SearchTransport MethodNormalCode10Transport Methodnvarchar(20)
Key to join to the Transport Method table.

Show/hide example query

SELECT
       [Service Header].[Transport Method]
       ,[Transport Method].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
              ON
                     [Service Header].[Transport Method] = [Transport Method].[Code]
78VAT Country/Region Code SearchTax Country/Region CodeNormalCode10VAT Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Service Header].[VAT 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].[VAT Country_Region Code] = [Country/Region].[Code]
79Name SearchNameNormalText100Namenvarchar(200)
80Name 2 SearchName 2NormalText50Name 2nvarchar(100)
81Address SearchAddressNormalText100Addressnvarchar(200)
82Address 2 SearchAddress 2NormalText50Address 2nvarchar(100)
83City SearchCityNormalText30Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Service Header].[City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Service Header].[City] = [Post Code].[City]
84Contact Name SearchContact NameNormalText100Contact Namenvarchar(200)
85Bill-to Post Code SearchBill-to ZIP CodeNormalCode20Bill-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Service Header].[Bill-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Service Header].[Bill-to Post Code] = [Post Code].[Code]
86Bill-to County SearchBill-to StateNormalText30Bill-to Countynvarchar(60)
87Bill-to Country/Region Code SearchBill-to Country/Region CodeNormalCode10Bill-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Service Header].[Bill-to 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].[Bill-to Country_Region Code] = [Country/Region].[Code]
88Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Service Header].[Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Service Header].[Post Code] = [Post Code].[Code]
89County SearchStateNormalText30Countynvarchar(60)
90Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(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]
91Ship-to Post Code SearchShip-to ZIP CodeNormalCode20Ship-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Service Header].[Ship-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Service Header].[Ship-to Post Code] = [Post Code].[Code]
92Ship-to County SearchShip-to StateNormalText30Ship-to Countynvarchar(60)
93Ship-to Country/Region Code SearchShip-to Country/Region CodeNormalCode10Ship-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Service Header].[Ship-to 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].[Ship-to Country_Region Code] = [Country/Region].[Code]
94Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Bank Account”
97Exit Point SearchExit PointNormalCode10Exit Pointnvarchar(20)
Key to join to the Entry/Exit Point table.

Show/hide example query

SELECT
       [Service Header].[Exit Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Service Header].[Exit Point] = [Entry/Exit Point].[Code]
98Correction SearchCorrectionNormalBoolean4Correctiontinyint
99Document Date SearchDocument DateNormalDate4Document Datedatetime
101Area SearchAreaNormalCode10Areanvarchar(20)
Key to join to the Area table.

Show/hide example query

SELECT
       [Service Header].[Area]
       ,[Area].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
              ON
                     [Service Header].[Area] = [Area].[Code]
102Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
       [Service Header].[Transaction Specification]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Service Header].[Transaction Specification] = [Transaction Specification].[Code]
104Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(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$ext] AS [Payment Method]
              ON
                     [Service Header].[Payment Method Code] = [Payment Method].[Code]
105Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(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$ext] AS [Shipping Agent]
              ON
                     [Service Header].[Shipping Agent Code] = [Shipping Agent].[Code]
107No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Header].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Header].[No_ Series] = [No. Series].[Code]
108Posting No. Series SearchPosting No. SeriesNormalCode20Posting No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Header].[Posting No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Header].[Posting No_ Series] = [No. Series].[Code]
109Shipping No. Series SearchShipping No. SeriesNormalCode20Shipping No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Service Header].[Shipping No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Service Header].[Shipping No_ Series] = [No. Series].[Code]
114Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(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]
115Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
116VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Service Header].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Service Header].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
117Reserve SearchReserveNormalOption4Reserveint
Available options are:
  • “Never”
  • “Optional”
  • “Always”
118Applies-to ID SearchApplies-to IDNormalCode50Applies-to IDnvarchar(100)
119VAT Base Discount % SearchVAT Base Discount %NormalDecimal12VAT Base Discount _decimal(38,38)
120Status SearchStatusNormalOption4Statusint
Available options are:
  • “Pending”
  • “In Process”
  • “Finished”
  • “On Hold”
121Invoice Discount Calculation SearchInvoice Discount CalculationNormalOption4Invoice Discount Calculationint
Available options are:
  • “None”
  • “%”
  • “Amount”
122Invoice Discount Value SearchInvoice Discount ValueNormalDecimal12Invoice Discount Valuedecimal(38,38)
129Company Bank Account Code SearchBank Account CodeNormalCode20Company Bank Account Codenvarchar(40)
130Release Status SearchRelease StatusNormalOption4Release Statusint
Available options are:
  • “Open”
  • “Released to Ship”
131VAT Reporting Date SearchTax DateNormalDate4VAT Reporting Datedatetime
178Journal Templ. Name SearchJournal Template NameNormalCode10Journal Templ_ Namenvarchar(20)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Service Header].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Service Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
1200Direct Debit Mandate ID SearchDirect Debit Mandate IDNormalCode35Direct Debit Mandate IDnvarchar(70)
5052Contact No. SearchContact No.NormalCode20Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Service Header].[Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Service Header].[Contact No_] = [Contact].[No_]
5053Bill-to Contact No. SearchBill-to Contact No.NormalCode20Bill-to Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Service Header].[Bill-to Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Service Header].[Bill-to Contact No_] = [Contact].[No_]
5700Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Service Header].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Service Header].[Responsibility Center] = [Responsibility Center].[Code]
5750Shipping Advice SearchShipping AdviceNormalOption4Shipping Adviceint
Available options are:
  • “Partial”
  • “Complete”
5752Completely Shipped SearchCompletely ShippedFlowFieldBoolean4
5754Location Filter SearchLocation FilterFlowFilterCode10
5792Shipping Time SearchShipping TimeNormalDateFormula32Shipping Timevarchar(32)
5794Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
5796Date Filter SearchDate FilterFlowFilterDate4
5902Description SearchDescriptionNormalText100Descriptionnvarchar(200)
5904Service Order Type SearchService Order TypeNormalCode10Service Order Typenvarchar(20)
Key to join to the Service Order Type table.

Show/hide example query

SELECT
       [Service Header].[Service Order Type]
       ,[Service Order Type].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Service Order Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Order Type]
              ON
                     [Service Header].[Service Order Type] = [Service Order Type].[Code]
5905Link Service to Service Item SearchLink Service to Service ItemNormalBoolean4Link Service to Service Itemtinyint
5907Priority SearchPriorityNormalOption4Priorityint
Available options are:
  • “Low”
  • “Medium”
  • “High”
5911Allocated Hours SearchAllocated HoursFlowFieldDecimal12
5915Phone No. SearchPhone No.NormalText30Phone No_nvarchar(60)
5916E-Mail SearchEmailNormalText80E-Mailnvarchar(160)
5917Phone No. 2 SearchPhone No. 2NormalText30Phone No_ 2nvarchar(60)
5918Fax No. SearchFax No.NormalText30Fax No_nvarchar(60)
5921No. of Unallocated Items SearchNo. of Unallocated ItemsFlowFieldInteger4
5923Order Time SearchOrder TimeNormalTime4Order Timedatetime
5924Default Response Time (Hours) SearchDefault Response Time (Hours)NormalDecimal12Default Response Time (Hours)decimal(38,38)
5925Actual Response Time (Hours) SearchActual Response Time (Hours)NormalDecimal12Actual Response Time (Hours)decimal(38,38)
5926Service Time (Hours) SearchService Time (Hours)NormalDecimal12Service Time (Hours)decimal(38,38)
5927Response Date SearchResponse DateNormalDate4Response Datedatetime
5928Response Time SearchResponse TimeNormalTime4Response Timedatetime
5929Starting Date SearchStarting DateNormalDate4Starting Datedatetime
5930Starting Time SearchStarting TimeNormalTime4Starting Timedatetime
5931Finishing Date SearchFinishing DateNormalDate4Finishing Datedatetime
5932Finishing Time SearchFinishing TimeNormalTime4Finishing Timedatetime
5933Contract Serv. Hours Exist SearchContract Serv. Hours ExistFlowFieldBoolean4
5934Reallocation Needed SearchReallocation NeededFlowFieldBoolean4
5936Notify Customer SearchNotify CustomerNormalOption4Notify Customerint
Available options are:
  • “No”
  • “By Phone 1”
  • “By Phone 2”
  • “By Fax”
  • “By Email”
5937Max. Labor Unit Price SearchMax. Labor Unit PriceNormalDecimal12Max_ Labor Unit Pricedecimal(38,38)
5938Warning Status SearchWarning StatusNormalOption4Warning Statusint
Available options are:
  • ” “
  • “First Warning”
  • “Second Warning”
  • “Third Warning”
5939No. of Allocations SearchNo. of AllocationsFlowFieldInteger4
5940Contract No. SearchContract No.NormalCode20Contract No_nvarchar(40)
5951Type Filter SearchType FilterFlowFilterOption4
5952Customer Filter SearchCustomer FilterFlowFilterCode20
5953Resource Filter SearchResource FilterFlowFilterCode20
5954Contract Filter SearchContract FilterFlowFilterCode20
5955Ship-to Fax No. SearchShip-to Fax No.NormalText30Ship-to Fax No_nvarchar(60)
5956Ship-to E-Mail SearchShip-to EmailNormalText80Ship-to E-Mailnvarchar(160)
5957Resource Group Filter SearchResource Group FilterFlowFilterCode20
5958Ship-to Phone SearchShip-to PhoneNormalText30Ship-to Phonenvarchar(60)
5959Ship-to Phone 2 SearchShip-to Phone 2NormalText30Ship-to Phone 2nvarchar(60)
5966Service Zone Filter SearchService Zone FilterFlowFilterCode10
5968Service Zone Code SearchService Zone CodeNormalCode10Service Zone Codenvarchar(20)
Key to join to the Service Zone table.

Show/hide example query

SELECT
       [Service Header].[Service Zone Code]
       ,[Service Zone].[Code]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
              ON
                     [Service Header].[Service Zone Code] = [Service Zone].[Code]
5981Expected Finishing Date SearchExpected Finishing DateNormalDate4Expected Finishing Datedatetime
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7001Allow Line Disc. SearchAllow Line Disc.NormalBoolean4Allow Line Disc_tinyint
9000Assigned User ID SearchAssigned User IDNormalCode50Assigned User IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
       [Service Header].[Assigned User ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Service Header].[Assigned User ID] = [User Setup].[User ID]
9001Quote No. SearchQuote No.NormalCode20Quote No_nvarchar(40)
10015Tax Exemption No. SearchTax Exemption No.NormalText30
10018STE Transaction ID SearchSTE Transaction IDNormalText20
27000CFDI Purpose SearchCFDI PurposeNormalCode10
27001CFDI Relation SearchCFDI RelationNormalCode10
27004CFDI Export Code SearchCFDI Export CodeNormalCode10
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Service Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Service Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Service Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Service Header].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Service Header table

CurrencyCustomer Posting GroupCustomer Price GroupLanguageLocationPayment MethodPayment TermsPost CodeResponsibility CenterSales HeaderSales Header ArchiveSalesperson/PurchaserSalesperson/PurchaserService ZoneShip-to AddressShipment MethodShipping AgentShipping Agent ServicesTax Area
Dynamics 365 BC Table ReferenceTablesCompany TablesSService Header

Leave a Reply

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