Inventory Profile – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IInventory 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	Line No_	int
3	Attribute Priority	int
4	Order Priority	int
5	Item 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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item] ON [Inventory Profile].[Item No_] = [Item].[No_]
6	Variant Code	nvarchar(20)
7	Location Code	nvarchar(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]
8	Bin Code	nvarchar(40)
9	IsSupply	tinyint
10	Order Relation	int
11	Source Type	int
12	Source Order Status	int
13	Source ID	nvarchar(40)
14	Source Batch Name	nvarchar(20)
15	Source Ref_ No_	int
16	Source Prod_ Order Line	int
17	Primary Order Status	int
18	Primary Order No_	nvarchar(40)
19	Primary Order Line	int
20	Primary Order Type	int
21	Original Quantity	decimal(38,38)
22	Remaining Quantity (Base)	decimal(38,38)
23	Untracked Quantity	decimal(38,38)
24	Original Due Date	datetime
25	Due Date	datetime
26	Planning Flexibility	int
27	Fixed Date	datetime
28	Action Message	int
29	Binding	int
30	Quantity (Base)	decimal(38,38)
31	Min_ Quantity	decimal(38,38)
32	Starting Date	datetime
33	Planning Line No_	int
34	Unit of Measure Code	nvarchar(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]
35	Qty_ per Unit of Measure	decimal(38,38)
36	Quantity	decimal(38,38)
37	Remaining Quantity	decimal(38,38)
38	Finished Quantity	decimal(38,38)
39	Planning Level Code	int
40	Planning Line Phase	int
41	Due Time	datetime
42	Sell-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_]
43	Drop Shipment	tinyint
44	Special Order	tinyint
45	Ref_ Order No_	nvarchar(40)
46	Ref_ Line No_	int
47	Derived from Blanket Order	tinyint
48	Ref_ Blanket Order No_	nvarchar(40)
49	Tracking Reference	int
50	Lot No_	nvarchar(100)
51	Serial No_	nvarchar(100)
52	Max_ Quantity	decimal(38,38)
53	Safety Stock Quantity	decimal(38,38)
54	Is Exception Order	tinyint
55	Transfer Location Not Planned	tinyint
56	Expiration Date	datetime
57	Ref_ Order Type	int
58	Disallow Cancellation	tinyint
59	MPS Order	tinyint
60	Package No_	nvarchar(100)
61	$systemId	uniqueidentifier
62	$systemCreatedAt	datetime
63	$systemCreatedBy	uniqueidentifier
64	$systemModifiedAt	datetime
65	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Inventory Profile table

Customer Item Location Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables IInventory Profile

Leave a Reply Cancel reply