Invt_ Receipt Line

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

Table Type: Company

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

Table Number: 5853

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[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]
   ,[Receipt No_]
   ,[Source Code]
   ,[Applies-to Entry]
   ,[Item Rcpt_ 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]
   ,[Applies-from Entry]
   ,[Amount (ACY)]
   ,[Applies-to Value Entry]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Invt_ Receipt 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_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Receipt Line]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Invt_ Receipt Line].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Invt_ Receipt Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Invt_ Receipt 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_ Receipt Line].[Item Category Code] = [Item Category].[Code]

Show/hide columns in Invt_ Receipt Line table

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

Show/hide example query

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

Show/hide example query

SELECT
       [Invt_ Receipt Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Invt_ Receipt Line].[Location Code] = [Location].[Code]
9Inventory Posting Group Searchnvarchar(40)
10Quantity Searchdecimal(38,38)
11Unit Amount Searchdecimal(38,38)
12Unit Cost Searchdecimal(38,38)
13Amount Searchdecimal(38,38)
14Salespers__Purch_ Code Searchnvarchar(40)
15Receipt No_ Searchnvarchar(40)
16Source Code Searchnvarchar(20)
17Applies-to Entry Searchint
18Item Rcpt_ 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_ Receipt Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Invt_ Receipt 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_ Receipt Line].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt_ Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Invt_ Receipt Line].[Item Category Code] = [Item Category].[Code]
41Purchasing Code Searchnvarchar(20)
42Applies-from Entry Searchint
43Amount (ACY) Searchdecimal(38,38)
44Applies-to Value Entry Searchint
45$systemId Searchuniqueidentifier
46$systemCreatedAt Searchdatetime
47$systemCreatedBy Searchuniqueidentifier
48$systemModifiedAt Searchdatetime
49$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Invt_ Receipt Line table

Leave a Reply

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