Service Invoice Header

Dynamics 365 BC Table ReferenceTablesCompany TablesSService Invoice Header

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

Table Type: Company

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

Table Number: 5992

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [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]
   ,[Order No_]
   ,[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]
   ,[Pre-Assigned No_ Series]
   ,[No_ Series]
   ,[Shipping No_ Series]
   ,[Order No_ Series]
   ,[Pre-Assigned No_]
   ,[User ID]
   ,[Source Code]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[VAT Base Discount _]
   ,[Company Bank Account Code]
   ,[VAT Reporting Date]
   ,[Payment Reference]
   ,[Dimension Set ID]
   ,[Document Exchange Identifier]
   ,[Document Exchange Status]
   ,[Doc_ Exch_ Original Identifier]
   ,[Direct Debit Mandate ID]
   ,[Contact No_]
   ,[Bill-to Contact No_]
   ,[Responsibility Center]
   ,[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_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Service Invoice 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 Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Invoice Header].[Bill-to Name] = [Customer].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Invoice 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 Invoice 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 Invoice Header].[Ship-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Service Invoice Header].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Service Invoice Header].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Service Invoice Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Invoice Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Service Invoice 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 Invoice Header].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Service Invoice Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Service Invoice Header].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Service Invoice Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Service Invoice Header].[Salesperson Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Service Invoice Header].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Service Invoice Header].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Service Invoice Header].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Invoice Header].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Invoice 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 Invoice Header].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Service Invoice 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 Invoice Header].[Exit Point] = [Entry/Exit Point].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Service Invoice Header].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Service Invoice Header].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Service Invoice 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 Invoice Header].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Service Invoice Header].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Service Invoice 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 Invoice 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 Invoice Header].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Order Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Order Type]
      ON
         [Service Invoice Header].[Service Order Type] = [Service Order Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Invoice Header].[Customer Filter] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
      ON
         [Service Invoice Header].[Resource Filter] = [Resource].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group]
      ON
         [Service Invoice Header].[Resource Group Filter] = [Resource Group].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
      ON
         [Service Invoice Header].[Service Zone Filter] = [Service Zone].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
      ON
         [Service Invoice Header].[Service Zone Code] = [Service Zone].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Invoice Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Service Invoice Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Service Invoice Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
2Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

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

Show/hide example query

SELECT
	       [Service Invoice Header].[Bill-to Customer No_]
	       ,[Customer].[No_]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Service Invoice 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 Invoice Header].[Bill-to Name]
	       ,[Customer].[Name]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Service Invoice 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 Invoice Header].[Bill-to City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Service Invoice 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 Invoice Header].[Ship-to Code]
	       ,[Ship-to Address].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
	              ON
	                     [Service Invoice 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 Invoice Header].[Ship-to City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Service Invoice 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 Invoice Header].[Payment Terms Code]
	       ,[Payment Terms].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
	              ON
	                     [Service Invoice 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 Invoice Header].[Shipment Method Code]
	       ,[Shipment Method].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
	              ON
	                     [Service Invoice 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 Invoice Header].[Location Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Service Invoice 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 Invoice Header].[Shortcut Dimension 1 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Service Invoice 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 Invoice Header].[Shortcut Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Service Invoice 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 Invoice Header].[Customer Posting Group]
	       ,[Customer Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
	              ON
	                     [Service Invoice 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 Invoice Header].[Currency Code]
	       ,[Currency].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Service Invoice 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 Invoice Header].[Customer Price Group]
	       ,[Customer Price Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
	              ON
	                     [Service Invoice 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 Invoice Header].[Customer Disc_ Group]
	       ,[Customer Discount Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
	              ON
	                     [Service Invoice 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 Invoice Header].[Language Code]
	       ,[Language].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
	              ON
	                     [Service Invoice 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 Invoice Header].[Salesperson Code]
	       ,[Salesperson/Purchaser].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
	              ON
	                     [Service Invoice Header].[Salesperson Code] = [Salesperson/Purchaser].[Code]
44Order No. SearchOrder No.NormalCode20Order No_nvarchar(40)
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)
60Amount SearchAmountFlowFieldDecimal12
61Amount Including VAT SearchAmount Including TaxFlowFieldDecimal12
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 Invoice Header].[Last Shipping No_]
	       ,[Posted Whse. Shipment Header].[No_]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Posted Whse_ Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse. Shipment Header]
	              ON
	                     [Service Invoice 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 Invoice Header].[Reason Code]
	       ,[Reason Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
	              ON
	                     [Service Invoice 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 Invoice Header].[Gen_ Bus_ Posting Group]
	       ,[Gen. Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
	              ON
	                     [Service Invoice 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 Invoice Header].[Transaction Type]
	       ,[Transaction Type].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
	              ON
	                     [Service Invoice 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 Invoice Header].[Transport Method]
	       ,[Transport Method].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
	              ON
	                     [Service Invoice Header].[Transport Method] = [Transport Method].[Code]
78VAT Country/Region Code SearchTax Country/Region CodeNormalCode10VAT Country_Region Codenvarchar(20)
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 Invoice Header].[City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Service Invoice 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 Invoice Header].[Bill-to Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Service Invoice 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)
88Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Service Invoice Header].[Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Service Invoice Header].[Post Code] = [Post Code].[Code]
89County SearchStateNormalText30Countynvarchar(60)
90Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
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 Invoice Header].[Ship-to Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Service Invoice 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)
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 Invoice Header].[Exit Point]
	       ,[Entry/Exit Point].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
	              ON
	                     [Service Invoice 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 Invoice Header].[Area]
	       ,[Area].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
	              ON
	                     [Service Invoice Header].[Area] = [Area].[Code]
102Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
	       [Service Invoice Header].[Transaction Specification]
	       ,[Transaction Specification].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
	              ON
	                     [Service Invoice 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 Invoice Header].[Payment Method Code]
	       ,[Payment Method].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
	              ON
	                     [Service Invoice 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 Invoice Header].[Shipping Agent Code]
	       ,[Shipping Agent].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Shipping Agent]
	              ON
	                     [Service Invoice Header].[Shipping Agent Code] = [Shipping Agent].[Code]
107Pre-Assigned No. Series SearchPre-Assigned No. SeriesNormalCode20Pre-Assigned No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

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

Show/hide example query

SELECT
	       [Service Invoice Header].[No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Service Invoice Header].[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 Invoice Header].[Shipping No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Service Invoice Header].[Shipping No_ Series] = [No. Series].[Code]
110Order No. Series SearchOrder No. SeriesNormalCode20Order No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [Service Invoice Header].[Order No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Service Invoice Header].[Order No_ Series] = [No. Series].[Code]
111Pre-Assigned No. SearchPre-Assigned No.NormalCode20Pre-Assigned No_nvarchar(40)
112User ID SearchUser IDNormalCode50User IDnvarchar(100)
113Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
	       [Service Invoice Header].[Source Code]
	       ,[Source Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
	              ON
	                     [Service Invoice Header].[Source Code] = [Source Code].[Code]
114Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
	       [Service Invoice Header].[Tax Area Code]
	       ,[Tax Area].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
	              ON
	                     [Service Invoice 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 Invoice Header].[VAT Bus_ Posting Group]
	       ,[VAT Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
	              ON
	                     [Service Invoice Header].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
119VAT Base Discount % SearchVAT Base Discount %NormalDecimal12VAT Base Discount _decimal(38,38)
129Company Bank Account Code SearchCompany Bank Account CodeNormalCode20Company Bank Account Codenvarchar(40)
131VAT Reporting Date SearchTax DateNormalDate4VAT Reporting Datedatetime
180Payment Reference SearchPayment ReferenceNormalCode50Payment Referencenvarchar(100)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
	       [Service Invoice Header].[Dimension Set ID]
	       ,[Dimension Set Entry].[Dimension Set ID]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
	              ON
	                     [Service Invoice Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
710Document Exchange Identifier SearchDocument Exchange IdentifierNormalText50Document Exchange Identifiernvarchar(100)
711Document Exchange Status SearchDocument Exchange StatusNormalOption4Document Exchange Statusint
Available options are:
  • “Not Sent”
  • “Sent to Document Exchange Service”
  • “Delivered to Recipient”
  • “Delivery Failed”
  • “Pending Connection to Recipient”
712Doc. Exch. Original Identifier SearchDoc. Exch. Original IdentifierNormalText50Doc_ Exch_ Original Identifiernvarchar(100)
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 Invoice Header].[Contact No_]
	       ,[Contact].[No_]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
	              ON
	                     [Service Invoice 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 Invoice Header].[Bill-to Contact No_]
	       ,[Contact].[No_]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
	              ON
	                     [Service Invoice 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 Invoice Header].[Responsibility Center]
	       ,[Responsibility Center].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
	              ON
	                     [Service Invoice Header].[Responsibility Center] = [Responsibility Center].[Code]
5794Shipping Agent Service Code SearchShipping Agent Service CodeNormalCode10Shipping Agent Service Codenvarchar(20)
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 Invoice Header].[Service Order Type]
	       ,[Service Order Type].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Service Order Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Order Type]
	              ON
	                     [Service Invoice 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
Key to join to the Customer table.

Show/hide example query

SELECT
	       [Service Invoice Header].[]
	       ,[Customer].[No_]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
	              ON
	                     [Service Invoice Header].[] = [Customer].[No_]
5953Resource Filter SearchResource FilterFlowFilterCode20
Key to join to the Resource table.

Show/hide example query

SELECT
	       [Service Invoice Header].[]
	       ,[Resource].[No_]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Resource$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource]
	              ON
	                     [Service Invoice Header].[] = [Resource].[No_]
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
Key to join to the Resource Group table.

Show/hide example query

SELECT
	       [Service Invoice Header].[]
	       ,[Resource Group].[No_]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Resource Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Resource Group]
	              ON
	                     [Service Invoice Header].[] = [Resource Group].[No_]
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
Key to join to the Service Zone table.

Show/hide example query

SELECT
	       [Service Invoice Header].[]
	       ,[Service Zone].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
	              ON
	                     [Service Invoice Header].[] = [Service Zone].[Code]
5968Service Zone Code SearchService Zone CodeNormalCode10Service Zone Codenvarchar(20)
Key to join to the Service Zone table.

Show/hide example query

SELECT
	       [Service Invoice Header].[Service Zone Code]
	       ,[Service Zone].[Code]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [CRONUS UK Ltd_$Service Zone$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Zone]
	              ON
	                     [Service Invoice 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
10018STE Transaction ID SearchSTE Transaction IDNormalText20
10019Electronic Document Sent SearchElectronic Document SentNormalBoolean4
10020Original Document XML SearchOriginal Document XMLNormalBLOB8
10021No. of E-Documents Sent SearchNo. of E-Documents SentNormalInteger4
10022Original String SearchOriginal StringNormalBLOB8
10023Digital Stamp SAT SearchDigital Stamp SATNormalBLOB8
10024Certificate Serial No. SearchCertificate Serial No.NormalText250
10025Signed Document XML SearchSigned Document XMLNormalBLOB8
10026Digital Stamp PAC SearchDigital Stamp PACNormalBLOB8
10030Electronic Document Status SearchElectronic Document StatusNormalOption4
10031Date/Time Stamped SearchDate/Time StampedNormalText50
10032Date/Time Sent SearchDate/Time SentNormalText50
10033Date/Time Canceled SearchDate/Time CanceledNormalText50
10035Error Code SearchError CodeNormalCode10
10036Error Description SearchError DescriptionNormalText250
10037Date/Time Stamp Received SearchDate/Time Stamp ReceivedNormalDateTime8
10038Date/Time Cancel Sent SearchDate/Time Cancel SentNormalDateTime8
10040PAC Web Service Name SearchPAC Web Service NameNormalText50
10041QR Code SearchQR CodeNormalBLOB8
10042Fiscal Invoice Number PAC SearchFiscal Invoice Number PACNormalText50
10043Date/Time First Req. Sent SearchDate/Time First Req. SentNormalText50
27000CFDI Purpose SearchCFDI PurposeNormalCode10
27001CFDI Relation SearchCFDI RelationNormalCode10
27002CFDI Cancellation Reason Code SearchCFDI Cancelation ReasonNormalCode10
27003Substitution Document No. SearchSubstitution Document No.NormalCode20
27004CFDI Export Code SearchCFDI Export CodeNormalCode10
27007CFDI Cancellation ID SearchCFDI Cancelation IDNormalText50
27008Marked as Canceled SearchMarked as CanceledNormalBoolean4
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 Invoice Header].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Service Invoice Header].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Service Invoice Header table

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

Leave a Reply

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