Inventory 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
   [timestamp]
   ,[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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Inventory Profile].[Item No_] = [Item].[No_]
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_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Inventory Profile].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Inventory Profile].[Sell-to Customer No_] = [Customer].[No_]

Show/hide columns in Inventory Profile table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Line No_ Primary Key Searchint
3Attribute Priority Searchint
4Order Priority Searchint
5Item No_ Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Inventory Profile].[Item No_] = [Item].[No_]
6Variant Code Searchnvarchar(20)
7Location Code Searchnvarchar(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]
8Bin Code Searchnvarchar(40)
9IsSupply Searchtinyint
10Order Relation Searchint
11Source Type Searchint
12Source Order Status Searchint
13Source ID Searchnvarchar(40)
14Source Batch Name Searchnvarchar(20)
15Source Ref_ No_ Searchint
16Source Prod_ Order Line Searchint
17Primary Order Status Searchint
18Primary Order No_ Searchnvarchar(40)
19Primary Order Line Searchint
20Primary Order Type Searchint
21Original Quantity Searchdecimal(38,38)
22Remaining Quantity (Base) Searchdecimal(38,38)
23Untracked Quantity Searchdecimal(38,38)
24Original Due Date Searchdatetime
25Due Date Searchdatetime
26Planning Flexibility Searchint
27Fixed Date Searchdatetime
28Action Message Searchint
29Binding Searchint
30Quantity (Base) Searchdecimal(38,38)
31Min_ Quantity Searchdecimal(38,38)
32Starting Date Searchdatetime
33Planning Line No_ Searchint
34Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Inventory Profile].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Inventory Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Profile]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Inventory Profile].[Unit of Measure Code] = [Unit of Measure].[Code]
35Qty_ per Unit of Measure Searchdecimal(38,38)
36Quantity Searchdecimal(38,38)
37Remaining Quantity Searchdecimal(38,38)
38Finished Quantity Searchdecimal(38,38)
39Planning Level Code Searchint
40Planning Line Phase Searchint
41Due Time Searchdatetime
42Sell-to Customer No_ Searchnvarchar(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_]
43Drop Shipment Searchtinyint
44Special Order Searchtinyint
45Ref_ Order No_ Searchnvarchar(40)
46Ref_ Line No_ Searchint
47Derived from Blanket Order Searchtinyint
48Ref_ Blanket Order No_ Searchnvarchar(40)
49Tracking Reference Searchint
50Lot No_ Searchnvarchar(100)
51Serial No_ Searchnvarchar(100)
52Max_ Quantity Searchdecimal(38,38)
53Safety Stock Quantity Searchdecimal(38,38)
54Is Exception Order Searchtinyint
55Transfer Location Not Planned Searchtinyint
56Expiration Date Searchdatetime
57Ref_ Order Type Searchint
58Disallow Cancellation Searchtinyint
59MPS Order Searchtinyint
60Package No_ Searchnvarchar(100)
61$systemId Searchuniqueidentifier
62$systemCreatedAt Searchdatetime
63$systemCreatedBy Searchuniqueidentifier
64$systemModifiedAt Searchdatetime
65$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Inventory Profile table

Leave a Reply

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