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
   [Line No_]
   ,[Item No_]
   ,[Posting Date]
   ,[Document Date]
   ,[Document No_]
   ,[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]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Invt. Receipt Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Invt. Receipt Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Invt. Receipt Line].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Invt. Receipt Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Invt. Receipt Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Invt. Receipt Line].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Invt. Receipt Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Invt. Receipt Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Invt. Receipt Line].[Bin Code] = [Bin].[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]
LEFT JOIN
   [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
      ON
         [Invt. Receipt Line].[Purchasing Code] = [Purchasing].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Invt. Receipt Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Invt. Receipt Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Invt. Receipt Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
2Line No. Primary Key SearchLine No.NormalInteger4Line No_int
3Item No. SearchItem No.NormalCode20Item No_nvarchar(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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Invt. Receipt Line].[Item No_] = [Item].[No_]
4Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5Document Date SearchDocument DateNormalDate4Document Datedatetime
7Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
8Description SearchDescriptionNormalText100Descriptionnvarchar(200)
9Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
10Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(40)
Key to join to the Inventory Posting Group table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Inventory Posting Group]
       ,[Inventory Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
              ON
                     [Invt. Receipt Line].[Inventory Posting Group] = [Inventory Posting Group].[Code]
13Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
16Unit Amount SearchUnit AmountNormalDecimal12Unit Amountdecimal(38,38)
17Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
18Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
23Salespers./Purch. Code SearchSalespers./Purch. CodeNormalCode20Salespers__Purch_ Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Salespers__Purch_ Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Invt. Receipt Line].[Salespers__Purch_ Code] = [Salesperson/Purchaser].[Code]
24Receipt No. SearchReceipt No.NormalCode20Receipt No_nvarchar(40)
26Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Invt. Receipt Line].[Source Code] = [Source Code].[Code]
29Applies-to Entry SearchApplies-to EntryNormalInteger4Applies-to Entryint
31Item Rcpt. Entry No. SearchItem Rcpt. Entry No.NormalInteger4Item Rcpt_ Entry No_int
34Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Invt. Receipt Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
35Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Invt. Receipt Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
37Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
38Gross Weight SearchGross WeightNormalDecimal12Gross Weightdecimal(38,38)
39Net Weight SearchNet WeightNormalDecimal12Net Weightdecimal(38,38)
40Units per Parcel SearchUnits per ParcelNormalDecimal12Units per Parceldecimal(38,38)
41Unit Volume SearchUnit VolumeNormalDecimal12Unit Volumedecimal(38,38)
42Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Invt. Receipt Line].[Reason Code] = [Reason Code].[Code]
55Last Item Ledger Entry No. SearchLast Item Ledger Entry No.NormalInteger4Last Item Ledger Entry No_int
Key to join to the Item Ledger Entry table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Last Item Ledger Entry No_]
       ,[Item Ledger Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
              ON
                     [Invt. Receipt Line].[Last Item Ledger Entry No_] = [Item Ledger Entry].[Entry No_]
57Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Invt. Receipt Line].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
58Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Invt. Receipt Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
65Posting No. Series SearchPosting No. SeriesNormalCode20Posting No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Posting No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Invt. Receipt Line].[Posting No_ Series] = [No. Series].[Code]
72Unit Cost (ACY) SearchUnit Cost (ACY)NormalDecimal12Unit Cost (ACY)decimal(38,38)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Invt. Receipt Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Invt. Receipt Line].[Variant Code] = [Item Variant].[Code]
5403Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Invt. Receipt Line].[Bin Code] = [Bin].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5405Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
5406Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
5407Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
5413Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
5704Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(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]
5706Purchasing Code SearchPurchasing CodeNormalCode10Purchasing Codenvarchar(20)
Key to join to the Purchasing table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[Purchasing Code]
       ,[Purchasing].[Code]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
              ON
                     [Invt. Receipt Line].[Purchasing Code] = [Purchasing].[Code]
5725Item Reference No. SearchItem Reference No.NormalCode50Item Reference No_nvarchar(100)
5726Item Reference Unit of Measure SearchItem Reference Unit of MeasureNormalCode10Item Reference Unit of Measurenvarchar(20)
5727Item Reference Type SearchItem Reference TypeNormalOption4Item Reference Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bar Code”
5728Item Reference Type No. SearchItem Reference Type No.NormalCode30Item Reference Type No_nvarchar(60)
5807Applies-from Entry SearchApplies-from EntryNormalInteger4Applies-from Entryint
5813Amount (ACY) SearchAmount (ACY)NormalDecimal12Amount (ACY)decimal(38,38)
5819Applies-to Value Entry SearchApplies-to Value EntryNormalInteger4Applies-to Value Entryint
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Invt. Receipt Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Invt. Receipt Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Invt_ Receipt Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Receipt Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Invt. Receipt Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Invt. Receipt Line table

Leave a Reply

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