Service Invoice Line

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

Table Type: Company

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

Table Number: 5993

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Service Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document No_]
   ,[Line No_]
   ,[Customer No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Quantity]
   ,[Unit Price]
   ,[Unit Cost (LCY)]
   ,[VAT _]
   ,[Line Discount _]
   ,[Line Discount Amount]
   ,[Amount]
   ,[Amount Including VAT]
   ,[Allow Invoice Disc_]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Appl_-to Item Entry]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Customer Price Group]
   ,[Work Type Code]
   ,[Shipment No_]
   ,[Shipment Line No_]
   ,[Bill-to Customer No_]
   ,[Inv_ Discount Amount]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Attached to Line No_]
   ,[Exit Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[VAT Clause Code]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[VAT Base Amount]
   ,[System-Created Entry]
   ,[Line Amount]
   ,[VAT Difference]
   ,[VAT Identifier]
   ,[Pmt_ Discount Amount]
   ,[Dimension Set ID]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Responsibility Center]
   ,[Substitution Available]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Product Group Code]
   ,[Service Item No_]
   ,[Appl_-to Service Entry]
   ,[Service Item Line No_]
   ,[Service Item Serial No_]
   ,[Service Item Line Description]
   ,[Serv_ Price Adjmt_ Gr_ Code]
   ,[Posting Date]
   ,[Needed by Date]
   ,[Ship-to Code]
   ,[Quantity Consumed]
   ,[Qty_ Consumed (Base)]
   ,[Service Price Group Code]
   ,[Fault Area Code]
   ,[Symptom Code]
   ,[Fault Code]
   ,[Resolution Code]
   ,[Exclude Warranty]
   ,[Warranty]
   ,[Contract No_]
   ,[Contract Disc_ _]
   ,[Warranty Disc_ _]
   ,[Component Line No_]
   ,[Spare Part Action]
   ,[Fault Reason Code]
   ,[Replaced Item No_]
   ,[Exclude Contract Discount]
   ,[Replaced Item Type]
   ,[Price Adjmt_ Status]
   ,[Line Discount Type]
   ,[Copy Components From]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Customer Disc_ Group]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Invoice Line$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 Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Line]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Invoice Line].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Service Invoice Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Service Invoice Line].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Invoice Line].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Service Invoice Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Service Invoice Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Service Invoice Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Service Invoice Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Service Invoice Line].[Product Group Code] = [Product Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Service Invoice Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]

Show/hide columns in Service Invoice Line table

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

Show/hide example query

SELECT
       [Service Invoice Line].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Invoice Line].[Customer No_] = [Customer].[No_]
5Type Searchint
6No_ Searchnvarchar(40)
7Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Service Invoice Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Service Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Service Invoice Line].[Location Code] = [Location].[Code]
8Posting Group Searchnvarchar(40)
9Description Searchnvarchar(200)
10Description 2 Searchnvarchar(100)
11Unit of Measure Searchnvarchar(100)
12Quantity Searchdecimal(38,38)
13Unit Price Searchdecimal(38,38)
14Unit Cost (LCY) Searchdecimal(38,38)
15VAT _ Searchdecimal(38,38)
16Line Discount _ Searchdecimal(38,38)
17Line Discount Amount Searchdecimal(38,38)
18Amount Searchdecimal(38,38)
19Amount Including VAT Searchdecimal(38,38)
20Allow Invoice Disc_ Searchtinyint
21Gross Weight Searchdecimal(38,38)
22Net Weight Searchdecimal(38,38)
23Units per Parcel Searchdecimal(38,38)
24Unit Volume Searchdecimal(38,38)
25Appl_-to Item Entry Searchint
26Shortcut Dimension 1 Code Searchnvarchar(40)
27Shortcut Dimension 2 Code Searchnvarchar(40)
28Customer Price Group Searchnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
       [Service Invoice Line].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Service Invoice Line].[Customer Price Group] = [Customer Price Group].[Code]
29Work Type Code Searchnvarchar(20)
30Shipment No_ Searchnvarchar(40)
31Shipment Line No_ Searchint
32Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Service Invoice Line].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Invoice Line].[Bill-to Customer No_] = [Customer].[No_]
33Inv_ Discount Amount Searchdecimal(38,38)
34Gen_ Bus_ Posting Group Searchnvarchar(40)
35Gen_ Prod_ Posting Group Searchnvarchar(40)
36VAT Calculation Type Searchint
37Transaction Type Searchnvarchar(20)
38Transport Method Searchnvarchar(20)
39Attached to Line No_ Searchint
40Exit Point Searchnvarchar(20)
41Area Searchnvarchar(20)
42Transaction Specification Searchnvarchar(20)
43Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Service Invoice Line].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Service Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Service Invoice Line].[Tax Area Code] = [Tax Area].[Code]
44Tax Liable Searchtinyint
45Tax Group Code Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Service Invoice Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Service Invoice Line].[Tax Group Code] = [Tax Group].[Code]
46VAT Clause Code Searchnvarchar(40)
47VAT Bus_ Posting Group Searchnvarchar(40)
48VAT Prod_ Posting Group Searchnvarchar(40)
49VAT Base Amount Searchdecimal(38,38)
50System-Created Entry Searchtinyint
51Line Amount Searchdecimal(38,38)
52VAT Difference Searchdecimal(38,38)
53VAT Identifier Searchnvarchar(40)
54Pmt_ Discount Amount Searchdecimal(38,38)
55Dimension Set ID Searchint
56Variant Code Searchnvarchar(20)
57Bin Code Searchnvarchar(40)
58Qty_ per Unit of Measure Searchdecimal(38,38)
59Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Service Invoice Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Service Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Service Invoice Line].[Unit of Measure Code] = [Unit of Measure].[Code]
60Quantity (Base) Searchdecimal(38,38)
61Responsibility Center Searchnvarchar(20)
62Substitution Available Searchtinyint
63Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Service Invoice Line].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Service Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Service Invoice Line].[Item Category Code] = [Item Category].[Code]
64Nonstock Searchtinyint
65Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Service Invoice Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Service Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Service Invoice Line].[Product Group Code] = [Product Group].[Code]
66Service Item No_ Searchnvarchar(40)
67Appl_-to Service Entry Searchint
68Service Item Line No_ Searchint
69Service Item Serial No_ Searchnvarchar(100)
70Service Item Line Description Searchnvarchar(200)
71Serv_ Price Adjmt_ Gr_ Code Searchnvarchar(20)
72Posting Date Searchdatetime
73Needed by Date Searchdatetime
74Ship-to Code Searchnvarchar(20)
75Quantity Consumed Searchdecimal(38,38)
76Qty_ Consumed (Base) Searchdecimal(38,38)
77Service Price Group Code Searchnvarchar(20)
78Fault Area Code Searchnvarchar(20)
79Symptom Code Searchnvarchar(20)
80Fault Code Searchnvarchar(20)
81Resolution Code Searchnvarchar(20)
82Exclude Warranty Searchtinyint
83Warranty Searchtinyint
84Contract No_ Searchnvarchar(40)
85Contract Disc_ _ Searchdecimal(38,38)
86Warranty Disc_ _ Searchdecimal(38,38)
87Component Line No_ Searchint
88Spare Part Action Searchint
89Fault Reason Code Searchnvarchar(20)
90Replaced Item No_ Searchnvarchar(40)
91Exclude Contract Discount Searchtinyint
92Replaced Item Type Searchint
93Price Adjmt_ Status Searchint
94Line Discount Type Searchint
95Copy Components From Searchint
96Return Reason Code Searchnvarchar(20)
97Price Calculation Method Searchint
98Allow Line Disc_ Searchtinyint
99Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Service Invoice Line].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Service Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Service Invoice Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]
100$systemId Searchuniqueidentifier
101$systemCreatedAt Searchdatetime
102$systemCreatedBy Searchuniqueidentifier
103$systemModifiedAt Searchdatetime
104$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Invoice Line table

Leave a Reply

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