Item Substitution #5715

Other table in Microsoft Dynamics 365 Business Central. 24 fields, 3 records in Cronus demo.

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: No., Variant Code, Substitute No., Substitute Variant Code, Type, Substitute Type.

All fields (24)

Item Substitution — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	No. PK	Code	Normal
2	Variant Code PK	Code	Normal	→ Item Variant #5401
3	Substitute No. PK	Code	Normal
4	Substitute Variant Code PK	Code	Normal
5	Description	Text	Normal
6	Inventory	Decimal	Normal
7	Interchangeable	Boolean	Normal
8	Condition ⚡ FLOW	Boolean	FlowField
9	Location Filter	Code	FlowFilter	→ Location #14
100	Type PK	Option	Normal
101	Substitute Type PK	Option	Normal
102	Sub. Item No. ⚡ FLOW	Code	FlowField
103	Relations Level	Integer	Normal
104	Quantity Avail. on Shpt. Date	Decimal	Normal
105	Shipment Date	Date	Normal
7330	Confidence	Option	Normal
7331	Score	Decimal	Normal
7332	Primary Search Terms	BLOB	Normal
7333	Secondary Search Terms	BLOB	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 (3)

Tables referenced by fields on the Item Substitution table through TableRelation properties.

Item Variant

#5401 · Other · via Variant Code

Location

#14 · General Ledger · via Location Filter