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

   [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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
3	Line No.	Line No.	Normal	Integer	4	Line No_	int
4	Attribute Priority	Attribute Priority	Normal	Integer	4	Attribute Priority	int
5	Order Priority	Order Priority	Normal	Integer	4	Order Priority	int
11	Item No.	Item No.	Normal	Code	20	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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Inventory Profile].[Item No_] = [Item].[No_]
12	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(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]
13	Location Code	Location Code	Normal	Code	10	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]
14	Bin Code	Bin Code	Normal	Code	20	Bin Code	nvarchar(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]
15	IsSupply	IsSupply	Normal	Boolean	4	IsSupply	tinyint
16	Order Relation	Order Relation	Normal	Option	4	Order Relation	int
	Available options are: “Normal” “Safety Stock” “Reorder Point”
21	Source Type	Source Type	Normal	Integer	4	Source Type	int
22	Source Order Status	Source Order Status	Normal	Integer	4	Source Order Status	int
23	Source ID	Source ID	Normal	Code	20	Source ID	nvarchar(40)
24	Source Batch Name	Source Batch Name	Normal	Code	10	Source Batch Name	nvarchar(20)
25	Source Ref. No.	Source Ref. No.	Normal	Integer	4	Source Ref_ No_	int
26	Source Prod. Order Line	Source Prod. Order Line	Normal	Integer	4	Source Prod_ Order Line	int
27	Primary Order Status	Primary Order Status	Normal	Integer	4	Primary Order Status	int
28	Primary Order No.	Primary Order No.	Normal	Code	20	Primary Order No_	nvarchar(40)
29	Primary Order Line	Primary Order Line	Normal	Integer	4	Primary Order Line	int
30	Primary Order Type	Primary Order Type	Normal	Integer	4	Primary Order Type	int
31	Original Quantity	Original Quantity	Normal	Decimal	12	Original Quantity	decimal(38,38)
32	Remaining Quantity (Base)	Remaining Quantity (Base)	Normal	Decimal	12	Remaining Quantity (Base)	decimal(38,38)
33	Untracked Quantity	Untracked Quantity	Normal	Decimal	12	Untracked Quantity	decimal(38,38)
34	Original Due Date	Original Due Date	Normal	Date	4	Original Due Date	datetime
35	Due Date	Due Date	Normal	Date	4	Due Date	datetime
36	Planning Flexibility	Planning Flexibility	Normal	Option	4	Planning Flexibility	int
	Available options are: “Unlimited” “None” “Reduce Only”
37	Fixed Date	Fixed Date	Normal	Date	4	Fixed Date	datetime
38	Action Message	Action Message	Normal	Option	4	Action Message	int
	Available options are: ” “ “New” “Change Qty.” “Reschedule” “Resched. & Chg. Qty.” “Cancel”
39	Binding	Binding	Normal	Option	4	Binding	int
	Available options are: ” “ “Order-to-Order”
40	Quantity (Base)	Quantity (Base)	Normal	Decimal	12	Quantity (Base)	decimal(38,38)
41	Min. Quantity	Min. Quantity	Normal	Decimal	12	Min_ Quantity	decimal(38,38)
42	Starting Date	Starting Date	Normal	Date	4	Starting Date	datetime
43	Planning Line No.	Planning Line No.	Normal	Integer	4	Planning 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_]
44	Unit of Measure Code	Unit of Measure Code	Normal	Code	10	Unit of Measure Code	nvarchar(20)
45	Qty. per Unit of Measure	Qty. per Unit of Measure	Normal	Decimal	12	Qty_ per Unit of Measure	decimal(38,38)
46	Quantity	Quantity	Normal	Decimal	12	Quantity	decimal(38,38)
47	Remaining Quantity	Remaining Quantity	Normal	Decimal	12	Remaining Quantity	decimal(38,38)
48	Finished Quantity	Finished Quantity	Normal	Decimal	12	Finished Quantity	decimal(38,38)
50	Planning Level Code	Planning Level Code	Normal	Integer	4	Planning Level Code	int
51	Planning Line Phase	Planning Line Phase	Normal	Option	4	Planning Line Phase	int
	Available options are: ” “ “Line Created” “Routing Created” “Exploded”
52	Due Time	Due Time	Normal	Time	4	Due Time	datetime
53	Sell-to Customer No.	Sell-to Customer No.	Normal	Code	20	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_]
54	Drop Shipment	Drop Shipment	Normal	Boolean	4	Drop Shipment	tinyint
55	Special Order	Special Order	Normal	Boolean	4	Special Order	tinyint
56	Ref. Order No.	Ref. Order No.	Normal	Code	20	Ref_ Order No_	nvarchar(40)
57	Ref. Line No.	Ref. Line No.	Normal	Integer	4	Ref_ Line No_	int
58	Derived from Blanket Order	Derived from Blanket Order	Normal	Boolean	4	Derived from Blanket Order	tinyint
59	Ref. Blanket Order No.	Ref. Blanket Order No.	Normal	Code	20	Ref_ Blanket Order No_	nvarchar(40)
60	Tracking Reference	Tracking Reference	Normal	Integer	4	Tracking Reference	int
61	Lot No.	Lot No.	Normal	Code	50	Lot No_	nvarchar(100)
62	Serial No.	Serial No.	Normal	Code	50	Serial No_	nvarchar(100)
63	Max. Quantity	Max. Quantity	Normal	Decimal	12	Max_ Quantity	decimal(38,38)
64	Safety Stock Quantity	Safety Stock Quantity	Normal	Decimal	12	Safety Stock Quantity	decimal(38,38)
65	Is Exception Order	Is Exception Order	Normal	Boolean	4	Is Exception Order	tinyint
66	Transfer Location Not Planned	Transfer Location Not Planned	Normal	Boolean	4	Transfer Location Not Planned	tinyint
67	Expiration Date	Expiration Date	Normal	Date	4	Expiration Date	datetime
68	Ref. Order Type	Ref. Order Type	Normal	Option	4	Ref_ Order Type	int
	Available options are: ” “ “Purchase” “Prod. Order” “Transfer” “Assembly”
69	Disallow Cancellation	Disallow Cancelation	Normal	Boolean	4	Disallow Cancellation	tinyint
70	MPS Order	MPS Order	Normal	Boolean	4	MPS Order	tinyint
6515	Package No.	Package No.	Normal	Code	50	Package No_	nvarchar(100)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Inventory Profile table

Location Unit of Measure

Dynamics 365 BC Table Reference Tables Company Tables IInventory Profile

Leave a Reply Cancel reply