Inventory Profile

Dynamics 365 BC Table ReferenceTablesCompany TablesIInventory Profile

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

Table Type: Company

Table Name: Inventory Profile
Database Table Name: CRONUS UK Ltd_$Inventory Profile$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 99000853

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 Inventory Profile can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Inventory Profile$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Line No_]
   ,[Attribute Priority]
   ,[Order Priority]
   ,[Item No_]
   ,[Variant Code]
   ,[Location Code]
   ,[Bin Code]
   ,[IsSupply]
   ,[Order Relation]
   ,[Source Type]
   ,[Source Order Status]
   ,[Source ID]
   ,[Source Batch Name]
   ,[Source Ref_ No_]
   ,[Source Prod_ Order Line]
   ,[Primary Order Status]
   ,[Primary Order No_]
   ,[Primary Order Line]
   ,[Primary Order Type]
   ,[Original Quantity]
   ,[Remaining Quantity (Base)]
   ,[Untracked Quantity]
   ,[Original Due Date]
   ,[Due Date]
   ,[Planning Flexibility]
   ,[Fixed Date]
   ,[Action Message]
   ,[Binding]
   ,[Quantity (Base)]
   ,[Min_ Quantity]
   ,[Starting Date]
   ,[Planning Line No_]
   ,[Unit of Measure Code]
   ,[Qty_ per Unit of Measure]
   ,[Quantity]
   ,[Remaining Quantity]
   ,[Finished Quantity]
   ,[Planning Level Code]
   ,[Planning Line Phase]
   ,[Due Time]
   ,[Sell-to Customer No_]
   ,[Drop Shipment]
   ,[Special Order]
   ,[Ref_ Order No_]
   ,[Ref_ Line No_]
   ,[Derived from Blanket Order]
   ,[Ref_ Blanket Order No_]
   ,[Tracking Reference]
   ,[Lot No_]
   ,[Serial No_]
   ,[Max_ Quantity]
   ,[Safety Stock Quantity]
   ,[Is Exception Order]
   ,[Transfer Location Not Planned]
   ,[Expiration Date]
   ,[Ref_ Order Type]
   ,[Disallow Cancellation]
   ,[MPS Order]
   ,[Package No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Inventory Profile$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Inventory Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Profile]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Inventory Profile].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Inventory Profile].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Inventory Profile].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Inventory Profile].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Inventory Profile].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Inventory Profile table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
4Attribute Priority SearchAttribute PriorityNormalInteger4Attribute Priorityint
5Order Priority SearchOrder PriorityNormalInteger4Order Priorityint
11Item No. SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Inventory Profile].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Inventory Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Profile]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Inventory Profile].[Item No_] = [Item].[No_]
12Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Inventory Profile].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Profile]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Inventory Profile].[Variant Code] = [Item Variant].[Code]
13Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Inventory Profile].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Profile]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Inventory Profile].[Location Code] = [Location].[Code]
14Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Inventory Profile].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Profile]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Inventory Profile].[Bin Code] = [Bin].[Code]
15IsSupply SearchIsSupplyNormalBoolean4IsSupplytinyint
16Order Relation SearchOrder RelationNormalOption4Order Relationint
Available options are:
  • “Normal”
  • “Safety Stock”
  • “Reorder Point”
21Source Type SearchSource TypeNormalInteger4Source Typeint
22Source Order Status SearchSource Order StatusNormalInteger4Source Order Statusint
23Source ID SearchSource IDNormalCode20Source IDnvarchar(40)
24Source Batch Name SearchSource Batch NameNormalCode10Source Batch Namenvarchar(20)
25Source Ref. No. SearchSource Ref. No.NormalInteger4Source Ref_ No_int
26Source Prod. Order Line SearchSource Prod. Order LineNormalInteger4Source Prod_ Order Lineint
27Primary Order Status SearchPrimary Order StatusNormalInteger4Primary Order Statusint
28Primary Order No. SearchPrimary Order No.NormalCode20Primary Order No_nvarchar(40)
29Primary Order Line SearchPrimary Order LineNormalInteger4Primary Order Lineint
30Primary Order Type SearchPrimary Order TypeNormalInteger4Primary Order Typeint
31Original Quantity SearchOriginal QuantityNormalDecimal12Original Quantitydecimal(38,38)
32Remaining Quantity (Base) SearchRemaining Quantity (Base)NormalDecimal12Remaining Quantity (Base)decimal(38,38)
33Untracked Quantity SearchUntracked QuantityNormalDecimal12Untracked Quantitydecimal(38,38)
34Original Due Date SearchOriginal Due DateNormalDate4Original Due Datedatetime
35Due Date SearchDue DateNormalDate4Due Datedatetime
36Planning Flexibility SearchPlanning FlexibilityNormalOption4Planning Flexibilityint
Available options are:
  • “Unlimited”
  • “None”
  • “Reduce Only”
37Fixed Date SearchFixed DateNormalDate4Fixed Datedatetime
38Action Message SearchAction MessageNormalOption4Action Messageint
Available options are:
  • ” “
  • “New”
  • “Change Qty.”
  • “Reschedule”
  • “Resched. & Chg. Qty.”
  • “Cancel”
39Binding SearchBindingNormalOption4Bindingint
Available options are:
  • ” “
  • “Order-to-Order”
40Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
41Min. Quantity SearchMin. QuantityNormalDecimal12Min_ Quantitydecimal(38,38)
42Starting Date SearchStarting DateNormalDate4Starting Datedatetime
43Planning Line No. SearchPlanning Line No.NormalInteger4Planning Line No_int
Key to join to the Job Planning Line table.

Show/hide example query

SELECT
       [Inventory Profile].[Planning Line No_]
       ,[Job Planning Line].[Line No_]
FROM
       [CRONUS UK Ltd_$Inventory Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Profile]
LEFT JOIN
       [CRONUS UK Ltd_$Job Planning Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Planning Line]
              ON
                     [Inventory Profile].[Planning Line No_] = [Job Planning Line].[Line No_]
44Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
45Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
46Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
47Remaining Quantity SearchRemaining QuantityNormalDecimal12Remaining Quantitydecimal(38,38)
48Finished Quantity SearchFinished QuantityNormalDecimal12Finished Quantitydecimal(38,38)
50Planning Level Code SearchPlanning Level CodeNormalInteger4Planning Level Codeint
51Planning Line Phase SearchPlanning Line PhaseNormalOption4Planning Line Phaseint
Available options are:
  • ” “
  • “Line Created”
  • “Routing Created”
  • “Exploded”
52Due Time SearchDue TimeNormalTime4Due Timedatetime
53Sell-to Customer No. SearchSell-to Customer No.NormalCode20Sell-to Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Inventory Profile].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Inventory Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Profile]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Inventory Profile].[Sell-to Customer No_] = [Customer].[No_]
54Drop Shipment SearchDrop ShipmentNormalBoolean4Drop Shipmenttinyint
55Special Order SearchSpecial OrderNormalBoolean4Special Ordertinyint
56Ref. Order No. SearchRef. Order No.NormalCode20Ref_ Order No_nvarchar(40)
57Ref. Line No. SearchRef. Line No.NormalInteger4Ref_ Line No_int
58Derived from Blanket Order SearchDerived from Blanket OrderNormalBoolean4Derived from Blanket Ordertinyint
59Ref. Blanket Order No. SearchRef. Blanket Order No.NormalCode20Ref_ Blanket Order No_nvarchar(40)
60Tracking Reference SearchTracking ReferenceNormalInteger4Tracking Referenceint
61Lot No. SearchLot No.NormalCode50Lot No_nvarchar(100)
62Serial No. SearchSerial No.NormalCode50Serial No_nvarchar(100)
63Max. Quantity SearchMax. QuantityNormalDecimal12Max_ Quantitydecimal(38,38)
64Safety Stock Quantity SearchSafety Stock QuantityNormalDecimal12Safety Stock Quantitydecimal(38,38)
65Is Exception Order SearchIs Exception OrderNormalBoolean4Is Exception Ordertinyint
66Transfer Location Not Planned SearchTransfer Location Not PlannedNormalBoolean4Transfer Location Not Plannedtinyint
67Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
68Ref. Order Type SearchRef. Order TypeNormalOption4Ref_ Order Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Prod. Order”
  • “Transfer”
  • “Assembly”
69Disallow Cancellation SearchDisallow CancelationNormalBoolean4Disallow Cancellationtinyint
70MPS Order SearchMPS OrderNormalBoolean4MPS Ordertinyint
6515Package No. SearchPackage No.NormalCode50Package No_nvarchar(100)
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
       [Inventory Profile].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Inventory Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Profile]
LEFT JOIN
       [User] AS [User]
              ON
                     [Inventory Profile].[$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
       [Inventory Profile].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Inventory Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Profile]
LEFT JOIN
       [User] AS [User]
              ON
                     [Inventory Profile].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Inventory Profile table

LocationUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesIInventory Profile

Leave a Reply

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