Service 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
   [timestamp]
   ,[No_]
   ,[Customer No_]
   ,[Bill-to Customer No_]
   ,[Bill-to Name]
   ,[Bill-to Name 2]
   ,[Bill-to Address]
   ,[Bill-to Address 2]
   ,[Bill-to City]
   ,[Bill-to Contact]
   ,[Your Reference]
   ,[Ship-to Code]
   ,[Ship-to Name]
   ,[Ship-to Name 2]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Contact]
   ,[Order Date]
   ,[Posting Date]
   ,[Posting Description]
   ,[Payment Terms Code]
   ,[Due Date]
   ,[Payment Discount _]
   ,[Pmt_ Discount Date]
   ,[Location Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Customer Posting Group]
   ,[Currency Code]
   ,[Currency Factor]
   ,[Customer Price Group]
   ,[Prices Including VAT]
   ,[Invoice Disc_ Code]
   ,[Customer Disc_ Group]
   ,[Language Code]
   ,[Salesperson Code]
   ,[Order No_]
   ,[No_ Printed]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Bal_ Account No_]
   ,[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]
   ,[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]
   ,[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]
   ,[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].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Invoice Header].[Bill-to Customer No_] = [Customer].[No_]
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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Service Invoice Header].[Location Code] = [Location].[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_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Service Invoice Header].[Customer Disc_ Group] = [Customer Discount Group].[No_]
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].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Service Invoice Header].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Service Invoice Header].[Payment Method Code] = [Payment Method].[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]

Show/hide columns in Service Invoice Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Service 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_]
4Bill-to Customer No_ Searchnvarchar(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 Searchnvarchar(200)
6Bill-to Name 2 Searchnvarchar(100)
7Bill-to Address Searchnvarchar(200)
8Bill-to Address 2 Searchnvarchar(100)
9Bill-to City Searchnvarchar(60)
10Bill-to Contact Searchnvarchar(200)
11Your Reference Searchnvarchar(70)
12Ship-to Code Searchnvarchar(20)
13Ship-to Name Searchnvarchar(200)
14Ship-to Name 2 Searchnvarchar(100)
15Ship-to Address Searchnvarchar(200)
16Ship-to Address 2 Searchnvarchar(100)
17Ship-to City Searchnvarchar(60)
18Ship-to Contact Searchnvarchar(200)
19Order Date Searchdatetime
20Posting Date Searchdatetime
21Posting Description Searchnvarchar(200)
22Payment Terms Code Searchnvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Service 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]
23Due Date Searchdatetime
24Payment Discount _ Searchdecimal(38,38)
25Pmt_ Discount Date Searchdatetime
26Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Service 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]
27Shortcut Dimension 1 Code Searchnvarchar(40)
28Shortcut Dimension 2 Code Searchnvarchar(40)
29Customer Posting Group Searchnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Service 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]
30Currency Code Searchnvarchar(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]
31Currency Factor Searchdecimal(38,38)
32Customer Price Group Searchnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
       [Service 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]
33Prices Including VAT Searchtinyint
34Invoice Disc_ Code Searchnvarchar(40)
35Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Service Invoice Header].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
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].[No_]
36Language Code Searchnvarchar(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]
37Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Service Invoice Header].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
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].[No_]
38Order No_ Searchnvarchar(40)
39No_ Printed Searchint
40Applies-to Doc_ Type Searchint
41Applies-to Doc_ No_ Searchnvarchar(40)
42Bal_ Account No_ Searchnvarchar(40)
43Shipping No_ Searchnvarchar(40)
44Posting No_ Searchnvarchar(40)
45Last Shipping No_ Searchnvarchar(40)
46Last Posting No_ Searchnvarchar(40)
47VAT Registration No_ Searchnvarchar(40)
48Reason Code Searchnvarchar(20)
49Gen_ Bus_ Posting Group Searchnvarchar(40)
50EU 3-Party Trade Searchtinyint
51Transaction Type Searchnvarchar(20)
52Transport Method Searchnvarchar(20)
53VAT Country_Region Code Searchnvarchar(20)
54Name Searchnvarchar(200)
55Name 2 Searchnvarchar(100)
56Address Searchnvarchar(200)
57Address 2 Searchnvarchar(100)
58City Searchnvarchar(60)
59Contact Name Searchnvarchar(200)
60Bill-to Post Code Searchnvarchar(40)
61Bill-to County Searchnvarchar(60)
62Bill-to Country_Region Code Searchnvarchar(20)
63Post Code Searchnvarchar(40)
64County Searchnvarchar(60)
65Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Service Invoice Header].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Service Invoice Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Service Invoice Header].[Country_Region Code] = [Country_Region].[Code]
66Ship-to Post Code Searchnvarchar(40)
67Ship-to County Searchnvarchar(60)
68Ship-to Country_Region Code Searchnvarchar(20)
69Bal_ Account Type Searchint
70Exit Point Searchnvarchar(20)
71Correction Searchtinyint
72Document Date Searchdatetime
73Area Searchnvarchar(20)
74Transaction Specification Searchnvarchar(20)
75Payment Method Code Searchnvarchar(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] AS [Payment Method]
              ON
                     [Service Invoice Header].[Payment Method Code] = [Payment Method].[Code]
76Pre-Assigned No_ Series Searchnvarchar(40)
77No_ Series Searchnvarchar(40)
78Shipping No_ Series Searchnvarchar(40)
79Order No_ Series Searchnvarchar(40)
80Pre-Assigned No_ Searchnvarchar(40)
81User ID Searchnvarchar(100)
82Source Code Searchnvarchar(20)
83Tax Area Code Searchnvarchar(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]
84Tax Liable Searchtinyint
85VAT Bus_ Posting Group Searchnvarchar(40)
86VAT Base Discount _ Searchdecimal(38,38)
87Company Bank Account Code Searchnvarchar(40)
88Payment Reference Searchnvarchar(100)
89Dimension Set ID Searchint
90Document Exchange Identifier Searchnvarchar(100)
91Document Exchange Status Searchint
92Doc_ Exch_ Original Identifier Searchnvarchar(100)
93Direct Debit Mandate ID Searchnvarchar(70)
94Contact No_ Searchnvarchar(40)
95Bill-to Contact No_ Searchnvarchar(40)
96Responsibility Center Searchnvarchar(20)
97Description Searchnvarchar(200)
98Service Order Type Searchnvarchar(20)
99Link Service to Service Item Searchtinyint
100Priority Searchint
101Phone No_ Searchnvarchar(60)
102E-Mail Searchnvarchar(160)
103Phone No_ 2 Searchnvarchar(60)
104Fax No_ Searchnvarchar(60)
105Order Time Searchdatetime
106Default Response Time (Hours) Searchdecimal(38,38)
107Actual Response Time (Hours) Searchdecimal(38,38)
108Service Time (Hours) Searchdecimal(38,38)
109Response Date Searchdatetime
110Response Time Searchdatetime
111Starting Date Searchdatetime
112Starting Time Searchdatetime
113Finishing Date Searchdatetime
114Finishing Time Searchdatetime
115Notify Customer Searchint
116Max_ Labor Unit Price Searchdecimal(38,38)
117Warning Status Searchint
118Contract No_ Searchnvarchar(40)
119Ship-to Fax No_ Searchnvarchar(60)
120Ship-to E-Mail Searchnvarchar(160)
121Ship-to Phone Searchnvarchar(60)
122Ship-to Phone 2 Searchnvarchar(60)
123Service Zone Code Searchnvarchar(20)
124Expected Finishing Date Searchdatetime
125Price Calculation Method Searchint
126Allow Line Disc_ Searchtinyint
127$systemId Searchuniqueidentifier
128$systemCreatedAt Searchdatetime
129$systemCreatedBy Searchuniqueidentifier
130$systemModifiedAt Searchdatetime
131$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Invoice Header table

Leave a Reply

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