Inventory Profile #99000853

Other table in Microsoft Dynamics 365 Business Central. 64 fields, 0 records in Cronus demo.

The Inventory Profile table (ID 99000853) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 64 fields, with a primary key of Line No.. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Line No..

All fields (64)

Inventory Profile — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
3	Line No. PK	Integer	Normal
4	Attribute Priority	Integer	Normal
5	Order Priority	Integer	Normal
11	Item No.	Code	Normal	→ Item #27
12	Variant Code	Code	Normal	→ Item Variant #5401
13	Location Code	Code	Normal	→ Location #14
14	Bin Code	Code	Normal	→ Bin #7354
15	IsSupply	Boolean	Normal
16	Order Relation	Option	Normal
21	Source Type	Integer	Normal
22	Source Order Status	Integer	Normal
23	Source ID	Code	Normal
24	Source Batch Name	Code	Normal
25	Source Ref. No.	Integer	Normal
26	Source Prod. Order Line	Integer	Normal
27	Primary Order Status	Integer	Normal
28	Primary Order No.	Code	Normal
29	Primary Order Line	Integer	Normal
30	Primary Order Type	Integer	Normal
31	Original Quantity	Decimal	Normal
32	Remaining Quantity (Base)	Decimal	Normal
33	Untracked Quantity	Decimal	Normal
34	Original Due Date	Date	Normal
35	Due Date	Date	Normal
36	Planning Flexibility	Option	Normal
37	Fixed Date	Date	Normal
38	Action Message	Option	Normal
39	Binding	Option	Normal
40	Quantity (Base)	Decimal	Normal
41	Min. Quantity	Decimal	Normal
42	Starting Date	Date	Normal
43	Planning Line No.	Integer	Normal
44	Unit of Measure Code	Code	Normal
45	Qty. per Unit of Measure	Decimal	Normal
46	Quantity	Decimal	Normal
47	Remaining Quantity	Decimal	Normal
48	Finished Quantity	Decimal	Normal
50	Planning Level Code	Integer	Normal
51	Planning Line Phase	Option	Normal
52	Due Time	Time	Normal
53	Sell-to Customer No.	Code	Normal	→ Customer #18
54	Drop Shipment	Boolean	Normal
55	Special Order	Boolean	Normal
56	Ref. Order No.	Code	Normal
57	Ref. Line No.	Integer	Normal
58	Derived from Blanket Order	Boolean	Normal
59	Ref. Blanket Order No.	Code	Normal
60	Tracking Reference	Integer	Normal
61	Lot No.	Code	Normal
62	Serial No.	Code	Normal
63	Max. Quantity	Decimal	Normal
64	Safety Stock Quantity	Decimal	Normal
65	Is Exception Order	Boolean	Normal
66	Transfer Location Not Planned	Boolean	Normal
67	Expiration Date	Date	Normal
68	Ref. Order Type	Option	Normal
69	Disallow Cancellation	Boolean	Normal
70	MPS Order	Boolean	Normal
6515	Package No.	Code	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (6)

Tables referenced by fields on the Inventory Profile table through TableRelation properties.

Item

#27 · Inventory · via Item No.

Item Variant

#5401 · Other · via Variant Code

Location

#14 · General Ledger · via Location Code

Bin

#7354 · Warehouse · via Bin Code

Customer

#18 · Sales · via Sell-to Customer No.