Sales Invoice Line

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document No_]
   ,[Line No_]
   ,[Sell-to Customer No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Shipment Date]
   ,[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]
   ,[Job No_]
   ,[Work Type Code]
   ,[Shipment No_]
   ,[Shipment Line No_]
   ,[Order No_]
   ,[Order Line No_]
   ,[Bill-to Customer No_]
   ,[Inv_ Discount Amount]
   ,[Drop Shipment]
   ,[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 Category]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[VAT Clause Code]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Blanket Order No_]
   ,[Blanket Order Line No_]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[System-Created Entry]
   ,[Line Amount]
   ,[VAT Difference]
   ,[VAT Identifier]
   ,[IC Partner Ref_ Type]
   ,[IC Partner Reference]
   ,[Prepayment Line]
   ,[IC Partner Code]
   ,[Posting Date]
   ,[IC Item Reference No_]
   ,[Pmt_ Discount Amount]
   ,[Line Discount Calculation]
   ,[Dimension Set ID]
   ,[Job Task No_]
   ,[Job Contract Entry No_]
   ,[Deferral Code]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[FA Posting Date]
   ,[Depreciation Book Code]
   ,[Depr_ until FA Posting Date]
   ,[Duplicate in Depreciation Book]
   ,[Use Duplication List]
   ,[Responsibility Center]
   ,[Cross-Reference No_]
   ,[Unit of Measure (Cross Ref_)]
   ,[Cross-Reference Type]
   ,[Cross-Reference Type No_]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Purchasing Code]
   ,[Product Group Code]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Appl_-from Item Entry]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[Customer Disc_ Group]
   ,[Price description]
   ,[Reverse Charge Item]
   ,[Reverse Charge]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Sales 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_$Sales Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Line]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Invoice Line].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Sales Invoice Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Sales Invoice Line].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Sales Invoice Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Invoice Line].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Sales Invoice Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Sales Invoice Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Sales Invoice Line].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Sales Invoice Line].[Job Task No_] = [Job Task].[Job Task No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Sales 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
         [Sales Invoice Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Sales 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
         [Sales Invoice Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]

Show/hide columns in Sales Invoice Line table

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

Show/hide example query

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

Show/hide example query

SELECT
       [Sales Invoice Line].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Sales Invoice Line].[Customer Price Group] = [Customer Price Group].[Code]
30Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Sales Invoice Line].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Sales Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Sales Invoice Line].[Job No_] = [Job].[Job No_]
31Work Type Code Searchnvarchar(20)
32Shipment No_ Searchnvarchar(40)
33Shipment Line No_ Searchint
34Order No_ Searchnvarchar(40)
35Order Line No_ Searchint
36Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Sales Invoice Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Sales Invoice Line].[Tax Group Code] = [Tax Group].[Code]
52VAT Clause Code Searchnvarchar(40)
53VAT Bus_ Posting Group Searchnvarchar(40)
54VAT Prod_ Posting Group Searchnvarchar(40)
55Blanket Order No_ Searchnvarchar(40)
56Blanket Order Line No_ Searchint
57VAT Base Amount Searchdecimal(38,38)
58Unit Cost Searchdecimal(38,38)
59System-Created Entry Searchtinyint
60Line Amount Searchdecimal(38,38)
61VAT Difference Searchdecimal(38,38)
62VAT Identifier Searchnvarchar(40)
63IC Partner Ref_ Type Searchint
64IC Partner Reference Searchnvarchar(40)
65Prepayment Line Searchtinyint
66IC Partner Code Searchnvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Sales Invoice Line].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Sales Invoice Line].[IC Partner Code] = [IC Partner].[Code]
67Posting Date Searchdatetime
68IC Item Reference No_ Searchnvarchar(100)
69Pmt_ Discount Amount Searchdecimal(38,38)
70Line Discount Calculation Searchint
71Dimension Set ID Searchint
72Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Sales Invoice Line].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Sales Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Sales Invoice Line].[Job Task No_] = [Job Task].[Job Task No_]
73Job Contract Entry No_ Searchint
74Deferral Code Searchnvarchar(20)
75Variant Code Searchnvarchar(20)
76Bin Code Searchnvarchar(40)
77Qty_ per Unit of Measure Searchdecimal(38,38)
78Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Sales Invoice Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Sales Invoice Line].[Unit of Measure Code] = [Unit of Measure].[Code]
79Quantity (Base) Searchdecimal(38,38)
80FA Posting Date Searchdatetime
81Depreciation Book Code Searchnvarchar(20)
82Depr_ until FA Posting Date Searchtinyint
83Duplicate in Depreciation Book Searchnvarchar(20)
84Use Duplication List Searchtinyint
85Responsibility Center Searchnvarchar(20)
86Cross-Reference No_ Searchnvarchar(40)
87Unit of Measure (Cross Ref_) Searchnvarchar(20)
88Cross-Reference Type Searchint
89Cross-Reference Type No_ Searchnvarchar(60)
90Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

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

Show/hide example query

SELECT
       [Sales Invoice Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Sales Invoice Line].[Product Group Code] = [Product Group].[Code]
94Item Reference No_ Searchnvarchar(100)
95Item Reference Unit of Measure Searchnvarchar(20)
96Item Reference Type Searchint
97Item Reference Type No_ Searchnvarchar(60)
98Appl_-from Item Entry Searchint
99Return Reason Code Searchnvarchar(20)
100Price Calculation Method Searchint
101Allow Line Disc_ Searchtinyint
102Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Sales Invoice Line].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Sales Invoice Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Invoice Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Sales Invoice Line].[Customer Disc_ Group] = [Customer Discount Group].[No_]
103Price description Searchnvarchar(160)
104Reverse Charge Item Searchtinyint
105Reverse Charge Searchdecimal(38,38)
106$systemId Searchuniqueidentifier
107$systemCreatedAt Searchdatetime
108$systemCreatedBy Searchuniqueidentifier
109$systemModifiedAt Searchdatetime
110$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales Invoice Line table

Leave a Reply

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