Invt. Shipment Line

Dynamics 365 BC Table ReferenceTablesCompany TablesIInvt. Shipment Line

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

Table Type: Company

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

Table Number: 5855

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Invt_ Shipment 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]
   ,[Shipment No_]
   ,[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 Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Applies-from Entry]
   ,[Amount (ACY)]
   ,[Applies-to Value Entry]
   ,[FA No_]
   ,[FA Entry No_]
   ,[Depreciation Book Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Invt_ Shipment 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_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Invt. Shipment Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Invt. Shipment 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. Shipment Line].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Invt. Shipment Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Invt. Shipment Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Invt. Shipment 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. Shipment 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. Shipment Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Invt. Shipment Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Invt. Shipment Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
      ON
         [Invt. Shipment Line].[Purchasing Code] = [Purchasing].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [Invt. Shipment Line].[Depreciation Book Code] = [Depreciation Book].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Invt. Shipment Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Invt. Shipment Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Invt. Shipment Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
2Line No. SearchLine No.NormalInteger4Line No_int
3Item No. Primary Key SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
	       [Invt. Shipment Line].[Item No_]
	       ,[Item].[No_]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
	              ON
	                     [Invt. Shipment Line].[Item No_] = [Item].[No_]
4Posting Date SearchPosting DateNormalDate4Posting Datedatetime
5Document Date SearchDocument DateNormalDate4Document Datedatetime
7Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
8Description Primary Key SearchDescriptionNormalText100Descriptionnvarchar(200)
9Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
	       [Invt. Shipment Line].[Location Code]
	       ,[Location].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
	              ON
	                     [Invt. Shipment 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. Shipment Line].[Inventory Posting Group]
	       ,[Inventory Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
	              ON
	                     [Invt. Shipment 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)
24Shipment No. SearchShipment No.NormalCode20Shipment No_nvarchar(40)
26Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
	       [Invt. Shipment Line].[Source Code]
	       ,[Source Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
	              ON
	                     [Invt. Shipment Line].[Source Code] = [Source Code].[Code]
29Applies-to Entry SearchApplies-to EntryNormalInteger4Applies-to Entryint
32Item Shpt. Entry No. SearchItem Shpt. Entry No.NormalInteger4Item Shpt_ 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. Shipment Line].[Shortcut Dimension 1 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Invt. Shipment 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. Shipment Line].[Shortcut Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Invt. Shipment 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. Shipment Line].[Reason Code]
	       ,[Reason Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
	              ON
	                     [Invt. Shipment 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. Shipment Line].[Last Item Ledger Entry No_]
	       ,[Item Ledger Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Ledger Entry]
	              ON
	                     [Invt. Shipment 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. Shipment Line].[Gen_ Bus_ Posting Group]
	       ,[Gen. Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
	              ON
	                     [Invt. Shipment 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. Shipment Line].[Gen_ Prod_ Posting Group]
	       ,[Gen. Product Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
	              ON
	                     [Invt. Shipment 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. Shipment Line].[Posting No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [Invt. Shipment 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. Shipment Line].[Dimension Set ID]
	       ,[Dimension Set Entry].[Dimension Set ID]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
	              ON
	                     [Invt. Shipment 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. Shipment Line].[Variant Code]
	       ,[Item Variant].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
	              ON
	                     [Invt. Shipment 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. Shipment Line].[Bin Code]
	       ,[Bin].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
	              ON
	                     [Invt. Shipment 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. Shipment Line].[Item Category Code]
	       ,[Item Category].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
	              ON
	                     [Invt. Shipment 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. Shipment Line].[Purchasing Code]
	       ,[Purchasing].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
	              ON
	                     [Invt. Shipment 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
12450FA No. SearchFA No.NormalCode20FA No_nvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

SELECT
	       [Invt. Shipment Line].[FA No_]
	       ,[Fixed Asset].[No_]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
	              ON
	                     [Invt. Shipment Line].[FA No_] = [Fixed Asset].[No_]
12451FA Entry No. SearchFA Entry No.NormalInteger4FA Entry No_int
12452Depreciation Book Code SearchDepreciation Book CodeNormalCode10Depreciation Book Codenvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
	       [Invt. Shipment Line].[Depreciation Book Code]
	       ,[Depreciation Book].[Code]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
	              ON
	                     [Invt. Shipment Line].[Depreciation Book Code] = [Depreciation Book].[Code]
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. Shipment Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Invt_ Shipment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Invt. Shipment Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Invt. Shipment Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Invt. Shipment Line table

Item CategoryLocationUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesIInvt. Shipment Line

Leave a Reply

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