Invt_ Document Line

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

Table Type: Company

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

Table Number: 5851

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document Type]
   ,[Document No_]
   ,[Line No_]
   ,[Item No_]
   ,[Posting Date]
   ,[Document Date]
   ,[Description]
   ,[Location Code]
   ,[Inventory Posting Group]
   ,[Quantity]
   ,[Unit Amount]
   ,[Unit Cost]
   ,[Amount]
   ,[Salespers__Purch_ Code]
   ,[Source Code]
   ,[Applies-to Entry]
   ,[Item Shpt_ Entry No_]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Indirect Cost _]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Reason Code]
   ,[Last Item Ledger Entry No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[Posting No_ Series]
   ,[Unit Cost (ACY)]
   ,[Dimension Set ID]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Item Category Code]
   ,[Purchasing Code]
   ,[Item Charge No_]
   ,[Applies-from Entry]
   ,[Applied Amount]
   ,[Update Standard Cost]
   ,[Amount (ACY)]
   ,[Applies-to Value Entry]
   ,[FA No_]
   ,[FA Entry No_]
   ,[Depreciation Book Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Invt_ Document 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_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Document Line]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Invt_ Document Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Invt_ Document Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Invt_ Document 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
         [Invt_ Document Line].[Item Category Code] = [Item Category].[Code]

Show/hide columns in Invt_ Document Line table

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

Show/hide example query

SELECT
       [Invt_ Document Line].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Document Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Invt_ Document Line].[Item No_] = [Item].[No_]
6Posting Date Searchdatetime
7Document Date Searchdatetime
8Description Searchnvarchar(200)
9Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Invt_ Document Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Document Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Invt_ Document Line].[Location Code] = [Location].[Code]
10Inventory Posting Group Searchnvarchar(40)
11Quantity Searchdecimal(38,38)
12Unit Amount Searchdecimal(38,38)
13Unit Cost Searchdecimal(38,38)
14Amount Searchdecimal(38,38)
15Salespers__Purch_ Code Searchnvarchar(40)
16Source Code Searchnvarchar(20)
17Applies-to Entry Searchint
18Item Shpt_ Entry No_ Searchint
19Shortcut Dimension 1 Code Searchnvarchar(40)
20Shortcut Dimension 2 Code Searchnvarchar(40)
21Indirect Cost _ Searchdecimal(38,38)
22Gross Weight Searchdecimal(38,38)
23Net Weight Searchdecimal(38,38)
24Units per Parcel Searchdecimal(38,38)
25Unit Volume Searchdecimal(38,38)
26Reason Code Searchnvarchar(20)
27Last Item Ledger Entry No_ Searchint
28Gen_ Bus_ Posting Group Searchnvarchar(40)
29Gen_ Prod_ Posting Group Searchnvarchar(40)
30Posting No_ Series Searchnvarchar(40)
31Unit Cost (ACY) Searchdecimal(38,38)
32Dimension Set ID Searchint
33Variant Code Searchnvarchar(20)
34Bin Code Searchnvarchar(40)
35Qty_ per Unit of Measure Searchdecimal(38,38)
36Qty_ Rounding Precision Searchdecimal(38,38)
37Qty_ Rounding Precision (Base) Searchdecimal(38,38)
38Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Invt_ Document Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Document Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Invt_ Document Line].[Unit of Measure Code] = [Unit of Measure].[Code]
39Quantity (Base) Searchdecimal(38,38)
40Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Invt_ Document Line].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Document Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Document Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Invt_ Document Line].[Item Category Code] = [Item Category].[Code]
41Purchasing Code Searchnvarchar(20)
42Item Charge No_ Searchnvarchar(40)
43Applies-from Entry Searchint
44Applied Amount Searchdecimal(38,38)
45Update Standard Cost Searchtinyint
46Amount (ACY) Searchdecimal(38,38)
47Applies-to Value Entry Searchint
48FA No_ Searchnvarchar(40)
49FA Entry No_ Searchint
50Depreciation Book Code Searchnvarchar(20)
51$systemId Searchuniqueidentifier
52$systemCreatedAt Searchdatetime
53$systemCreatedBy Searchuniqueidentifier
54$systemModifiedAt Searchdatetime
55$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Invt_ Document Line table

Leave a Reply

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