Service Invoice Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables SService 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
2	Customer No.	Customer No.	Normal	Code	20	Customer 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_]
3	No.	No.	Normal	Code	20	No_	nvarchar(40)
4	Bill-to Customer No.	Bill-to Customer No.	Normal	Code	20	Bill-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_]
5	Bill-to Name	Bill-to Name	Normal	Text	100	Bill-to Name	nvarchar(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]
6	Bill-to Name 2	Bill-to Name 2	Normal	Text	50	Bill-to Name 2	nvarchar(100)
7	Bill-to Address	Bill-to Address	Normal	Text	100	Bill-to Address	nvarchar(200)
8	Bill-to Address 2	Bill-to Address 2	Normal	Text	50	Bill-to Address 2	nvarchar(100)
9	Bill-to City	Bill-to City	Normal	Text	30	Bill-to City	nvarchar(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]
10	Bill-to Contact	Contact	Normal	Text	100	Bill-to Contact	nvarchar(200)
11	Your Reference	Your Reference	Normal	Text	35	Your Reference	nvarchar(70)
12	Ship-to Code	Ship-to Code	Normal	Code	10	Ship-to Code	nvarchar(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]
13	Ship-to Name	Ship-to Name	Normal	Text	100	Ship-to Name	nvarchar(200)
14	Ship-to Name 2	Ship-to Name 2	Normal	Text	50	Ship-to Name 2	nvarchar(100)
15	Ship-to Address	Ship-to Address	Normal	Text	100	Ship-to Address	nvarchar(200)
16	Ship-to Address 2	Ship-to Address 2	Normal	Text	50	Ship-to Address 2	nvarchar(100)
17	Ship-to City	Ship-to City	Normal	Text	30	Ship-to City	nvarchar(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]
18	Ship-to Contact	Ship-to Contact	Normal	Text	100	Ship-to Contact	nvarchar(200)
19	Order Date	Order Date	Normal	Date	4	Order Date	datetime
20	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
22	Posting Description	Posting Description	Normal	Text	100	Posting Description	nvarchar(200)
23	Payment Terms Code	Payment Terms Code	Normal	Code	10	Payment Terms Code	nvarchar(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]
24	Due Date	Due Date	Normal	Date	4	Due Date	datetime
25	Payment Discount %	Payment Discount %	Normal	Decimal	12	Payment Discount _	decimal(38,38)
26	Pmt. Discount Date	Pmt. Discount Date	Normal	Date	4	Pmt_ Discount Date	datetime
27	Shipment Method Code	Shipment Method Code	Normal	Code	10	Shipment Method Code	nvarchar(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]
28	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(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]
29	Shortcut Dimension 1 Code	Shortcut Dimension 1 Code	Normal	Code	20	Shortcut Dimension 1 Code	nvarchar(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]
30	Shortcut Dimension 2 Code	Shortcut Dimension 2 Code	Normal	Code	20	Shortcut Dimension 2 Code	nvarchar(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]
31	Customer Posting Group	Customer Posting Group	Normal	Code	20	Customer Posting Group	nvarchar(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]
32	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(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]
33	Currency Factor	Currency Factor	Normal	Decimal	12	Currency Factor	decimal(38,38)
34	Customer Price Group	Customer Price Group	Normal	Code	10	Customer Price Group	nvarchar(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]
35	Prices Including VAT	Prices Including Tax	Normal	Boolean	4	Prices Including VAT	tinyint
37	Invoice Disc. Code	Invoice Disc. Code	Normal	Code	20	Invoice Disc_ Code	nvarchar(40)
40	Customer Disc. Group	Customer Disc. Group	Normal	Code	20	Customer Disc_ Group	nvarchar(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]
41	Language Code	Language Code	Normal	Code	10	Language Code	nvarchar(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]
42	Format Region	Format Region	Normal	Text	80	Format Region	nvarchar(160)
43	Salesperson Code	Salesperson Code	Normal	Code	20	Salesperson Code	nvarchar(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]
44	Order No.	Order No.	Normal	Code	20	Order No_	nvarchar(40)
46	Comment	Comment	FlowField	Boolean	4
47	No. Printed	No. Printed	Normal	Integer	4	No_ Printed	int
52	Applies-to Doc. Type	Applies-to Doc. Type	Normal	Option	4	Applies-to Doc_ Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
53	Applies-to Doc. No.	Applies-to Doc. No.	Normal	Code	20	Applies-to Doc_ No_	nvarchar(40)
55	Bal. Account No.	Bal. Account No.	Normal	Code	20	Bal_ Account No_	nvarchar(40)
60	Amount	Amount	FlowField	Decimal	12
61	Amount Including VAT	Amount Including Tax	FlowField	Decimal	12
62	Shipping No.	Shipping No.	Normal	Code	20	Shipping No_	nvarchar(40)
63	Posting No.	Posting No.	Normal	Code	20	Posting No_	nvarchar(40)
64	Last Shipping No.	Last Shipping No.	Normal	Code	20	Last 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_]
65	Last Posting No.	Last Posting No.	Normal	Code	20	Last Posting No_	nvarchar(40)
70	VAT Registration No.	Tax Registration No.	Normal	Text	20	VAT Registration No_	nvarchar(40)
73	Reason Code	Reason Code	Normal	Code	10	Reason Code	nvarchar(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]
74	Gen. Bus. Posting Group	Gen. Bus. Posting Group	Normal	Code	20	Gen_ Bus_ Posting Group	nvarchar(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]
75	EU 3-Party Trade	EU 3-Party Trade	Normal	Boolean	4	EU 3-Party Trade	tinyint
76	Transaction Type	Transaction Type	Normal	Code	10	Transaction Type	nvarchar(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]
77	Transport Method	Transport Method	Normal	Code	10	Transport Method	nvarchar(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]
78	VAT Country/Region Code	Tax Country/Region Code	Normal	Code	10	VAT Country_Region Code	nvarchar(20)
79	Name	Name	Normal	Text	100	Name	nvarchar(200)
80	Name 2	Name 2	Normal	Text	50	Name 2	nvarchar(100)
81	Address	Address	Normal	Text	100	Address	nvarchar(200)
82	Address 2	Address 2	Normal	Text	50	Address 2	nvarchar(100)
83	City	City	Normal	Text	30	City	nvarchar(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]
84	Contact Name	Contact Name	Normal	Text	100	Contact Name	nvarchar(200)
85	Bill-to Post Code	Bill-to ZIP Code	Normal	Code	20	Bill-to Post Code	nvarchar(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]
86	Bill-to County	Bill-to State	Normal	Text	30	Bill-to County	nvarchar(60)
87	Bill-to Country/Region Code	Bill-to Country/Region Code	Normal	Code	10	Bill-to Country_Region Code	nvarchar(20)
88	Post Code	ZIP Code	Normal	Code	20	Post Code	nvarchar(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]
89	County	State	Normal	Text	30	County	nvarchar(60)
90	Country/Region Code	Country/Region Code	Normal	Code	10	Country_Region Code	nvarchar(20)
91	Ship-to Post Code	Ship-to ZIP Code	Normal	Code	20	Ship-to Post Code	nvarchar(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]
92	Ship-to County	Ship-to State	Normal	Text	30	Ship-to County	nvarchar(60)
93	Ship-to Country/Region Code	Ship-to Country/Region Code	Normal	Code	10	Ship-to Country_Region Code	nvarchar(20)
94	Bal. Account Type	Bal. Account Type	Normal	Option	4	Bal_ Account Type	int
	Available options are: “G/L Account” “Bank Account”
97	Exit Point	Exit Point	Normal	Code	10	Exit Point	nvarchar(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]
98	Correction	Correction	Normal	Boolean	4	Correction	tinyint
99	Document Date	Document Date	Normal	Date	4	Document Date	datetime
101	Area	Area	Normal	Code	10	Area	nvarchar(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]
102	Transaction Specification	Transaction Specification	Normal	Code	10	Transaction Specification	nvarchar(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]
104	Payment Method Code	Payment Method Code	Normal	Code	10	Payment Method Code	nvarchar(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]
105	Shipping Agent Code	Shipping Agent Code	Normal	Code	10	Shipping Agent Code	nvarchar(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]
107	Pre-Assigned No. Series	Pre-Assigned No. Series	Normal	Code	20	Pre-Assigned No_ Series	nvarchar(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]
108	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(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]
109	Shipping No. Series	Shipping No. Series	Normal	Code	20	Shipping No_ Series	nvarchar(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]
110	Order No. Series	Order No. Series	Normal	Code	20	Order No_ Series	nvarchar(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]
111	Pre-Assigned No.	Pre-Assigned No.	Normal	Code	20	Pre-Assigned No_	nvarchar(40)
112	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
113	Source Code	Source Code	Normal	Code	10	Source Code	nvarchar(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]
114	Tax Area Code	Tax Area Code	Normal	Code	20	Tax Area Code	nvarchar(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]
115	Tax Liable	Tax Liable	Normal	Boolean	4	Tax Liable	tinyint
116	VAT Bus. Posting Group	VAT Bus. Posting Group	Normal	Code	20	VAT Bus_ Posting Group	nvarchar(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]
119	VAT Base Discount %	VAT Base Discount %	Normal	Decimal	12	VAT Base Discount _	decimal(38,38)
129	Company Bank Account Code	Company Bank Account Code	Normal	Code	20	Company Bank Account Code	nvarchar(40)
131	VAT Reporting Date	Tax Date	Normal	Date	4	VAT Reporting Date	datetime
180	Payment Reference	Payment Reference	Normal	Code	50	Payment Reference	nvarchar(100)
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	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]
710	Document Exchange Identifier	Document Exchange Identifier	Normal	Text	50	Document Exchange Identifier	nvarchar(100)
711	Document Exchange Status	Document Exchange Status	Normal	Option	4	Document Exchange Status	int
	Available options are: “Not Sent” “Sent to Document Exchange Service” “Delivered to Recipient” “Delivery Failed” “Pending Connection to Recipient”
712	Doc. Exch. Original Identifier	Doc. Exch. Original Identifier	Normal	Text	50	Doc_ Exch_ Original Identifier	nvarchar(100)
1200	Direct Debit Mandate ID	Direct Debit Mandate ID	Normal	Code	35	Direct Debit Mandate ID	nvarchar(70)
5052	Contact No.	Contact No.	Normal	Code	20	Contact 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_]
5053	Bill-to Contact No.	Bill-to Contact No.	Normal	Code	20	Bill-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_]
5700	Responsibility Center	Responsibility Center	Normal	Code	10	Responsibility Center	nvarchar(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]
5794	Shipping Agent Service Code	Shipping Agent Service Code	Normal	Code	10	Shipping Agent Service Code	nvarchar(20)
5902	Description	Description	Normal	Text	100	Description	nvarchar(200)
5904	Service Order Type	Service Order Type	Normal	Code	10	Service Order Type	nvarchar(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]
5905	Link Service to Service Item	Link Service to Service Item	Normal	Boolean	4	Link Service to Service Item	tinyint
5907	Priority	Priority	Normal	Option	4	Priority	int
	Available options are: “Low” “Medium” “High”
5911	Allocated Hours	Allocated Hours	FlowField	Decimal	12
5915	Phone No.	Phone No.	Normal	Text	30	Phone No_	nvarchar(60)
5916	E-Mail	Email	Normal	Text	80	E-Mail	nvarchar(160)
5917	Phone No. 2	Phone No. 2	Normal	Text	30	Phone No_ 2	nvarchar(60)
5918	Fax No.	Fax No.	Normal	Text	30	Fax No_	nvarchar(60)
5921	No. of Unallocated Items	No. of Unallocated Items	FlowField	Integer	4
5923	Order Time	Order Time	Normal	Time	4	Order Time	datetime
5924	Default Response Time (Hours)	Default Response Time (Hours)	Normal	Decimal	12	Default Response Time (Hours)	decimal(38,38)
5925	Actual Response Time (Hours)	Actual Response Time (Hours)	Normal	Decimal	12	Actual Response Time (Hours)	decimal(38,38)
5926	Service Time (Hours)	Service Time (Hours)	Normal	Decimal	12	Service Time (Hours)	decimal(38,38)
5927	Response Date	Response Date	Normal	Date	4	Response Date	datetime
5928	Response Time	Response Time	Normal	Time	4	Response Time	datetime
5929	Starting Date	Starting Date	Normal	Date	4	Starting Date	datetime
5930	Starting Time	Starting Time	Normal	Time	4	Starting Time	datetime
5931	Finishing Date	Finishing Date	Normal	Date	4	Finishing Date	datetime
5932	Finishing Time	Finishing Time	Normal	Time	4	Finishing Time	datetime
5933	Contract Serv. Hours Exist	Contract Serv. Hours Exist	FlowField	Boolean	4
5934	Reallocation Needed	Reallocation Needed	FlowField	Boolean	4
5936	Notify Customer	Notify Customer	Normal	Option	4	Notify Customer	int
	Available options are: “No” “By Phone 1” “By Phone 2” “By Fax” “By Email”
5937	Max. Labor Unit Price	Max. Labor Unit Price	Normal	Decimal	12	Max_ Labor Unit Price	decimal(38,38)
5938	Warning Status	Warning Status	Normal	Option	4	Warning Status	int
	Available options are: ” “ “First Warning” “Second Warning” “Third Warning”
5939	No. of Allocations	No. of Allocations	FlowField	Integer	4
5940	Contract No.	Contract No.	Normal	Code	20	Contract No_	nvarchar(40)
5951	Type Filter	Type Filter	FlowFilter	Option	4
5952	Customer Filter	Customer Filter	FlowFilter	Code	20
	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_]
5953	Resource Filter	Resource Filter	FlowFilter	Code	20
	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_]
5954	Contract Filter	Contract Filter	FlowFilter	Code	20
5955	Ship-to Fax No.	Ship-to Fax No.	Normal	Text	30	Ship-to Fax No_	nvarchar(60)
5956	Ship-to E-Mail	Ship-to Email	Normal	Text	80	Ship-to E-Mail	nvarchar(160)
5957	Resource Group Filter	Resource Group Filter	FlowFilter	Code	20
	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_]
5958	Ship-to Phone	Ship-to Phone	Normal	Text	30	Ship-to Phone	nvarchar(60)
5959	Ship-to Phone 2	Ship-to Phone 2	Normal	Text	30	Ship-to Phone 2	nvarchar(60)
5966	Service Zone Filter	Service Zone Filter	FlowFilter	Code	10
	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]
5968	Service Zone Code	Service Zone Code	Normal	Code	10	Service Zone Code	nvarchar(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]
5981	Expected Finishing Date	Expected Finishing Date	Normal	Date	4	Expected Finishing Date	datetime
7000	Price Calculation Method	Price Calculation Method	Normal	Option	4	Price Calculation Method	int
	Available options are: ” “ “Lowest Price”
7001	Allow Line Disc.	Allow Line Disc.	Normal	Boolean	4	Allow Line Disc_	tinyint
10018	STE Transaction ID	STE Transaction ID	Normal	Text	20
10019	Electronic Document Sent	Electronic Document Sent	Normal	Boolean	4
10020	Original Document XML	Original Document XML	Normal	BLOB	8
10021	No. of E-Documents Sent	No. of E-Documents Sent	Normal	Integer	4
10022	Original String	Original String	Normal	BLOB	8
10023	Digital Stamp SAT	Digital Stamp SAT	Normal	BLOB	8
10024	Certificate Serial No.	Certificate Serial No.	Normal	Text	250
10025	Signed Document XML	Signed Document XML	Normal	BLOB	8
10026	Digital Stamp PAC	Digital Stamp PAC	Normal	BLOB	8
10030	Electronic Document Status	Electronic Document Status	Normal	Option	4
10031	Date/Time Stamped	Date/Time Stamped	Normal	Text	50
10032	Date/Time Sent	Date/Time Sent	Normal	Text	50
10033	Date/Time Canceled	Date/Time Canceled	Normal	Text	50
10035	Error Code	Error Code	Normal	Code	10
10036	Error Description	Error Description	Normal	Text	250
10037	Date/Time Stamp Received	Date/Time Stamp Received	Normal	DateTime	8
10038	Date/Time Cancel Sent	Date/Time Cancel Sent	Normal	DateTime	8
10040	PAC Web Service Name	PAC Web Service Name	Normal	Text	50
10041	QR Code	QR Code	Normal	BLOB	8
10042	Fiscal Invoice Number PAC	Fiscal Invoice Number PAC	Normal	Text	50
10043	Date/Time First Req. Sent	Date/Time First Req. Sent	Normal	Text	50
27000	CFDI Purpose	CFDI Purpose	Normal	Code	10
27001	CFDI Relation	CFDI Relation	Normal	Code	10
27002	CFDI Cancellation Reason Code	CFDI Cancelation Reason	Normal	Code	10
27003	Substitution Document No.	Substitution Document No.	Normal	Code	20
27004	CFDI Export Code	CFDI Export Code	Normal	Code	10
27007	CFDI Cancellation ID	CFDI Cancelation ID	Normal	Text	50
27008	Marked as Canceled	Marked as Canceled	Normal	Boolean	4
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Service Invoice Header table

Dynamics 365 BC Table Reference Tables Company Tables SService Invoice Header

Leave a Reply Cancel reply