Inventory Setup #313

Setup table in Microsoft Dynamics 365 Business Central. 59 fields, 1 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: Primary Key.

All fields (59)

Inventory Setup — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Primary Key PK	Code	Normal
2	Automatic Cost Posting	Boolean	Normal
3	Location Mandatory	Boolean	Normal
4	Item Nos.	Code	Normal	→ No. Series #308
30	Automatic Cost Adjustment	Option	Normal
31	Cost Adjustment Logging	Option	Normal
35	Current Demand Forecast	Code	Normal	→ Production Forecast Name #99000851
36	Use forecast on variants	Boolean	Normal
37	Use forecast on locations	Boolean	Normal
38	Combined MPS/MRP Calculation	Boolean	Normal
40	Prevent Negative Inventory	Boolean	Normal
41	Default Dampener %	Decimal	Normal
42	Default Safety Lead Time	DateFormula	Normal
43	Blank Overflow Level	Option	Normal
44	Default Dampener Period	DateFormula	Normal
45	Variant Mandatory if Exists	Boolean	Normal
50	Skip Prompt to Create Item	Boolean	Normal
51	Copy Item Descr. to Entries	Boolean	Normal
60	Allow Inventory Adjustment	Boolean	Normal
180	Invt. Cost Jnl. Template Name	Code	Normal	→ Gen. Journal Template #80
181	Jnl. Batch Name Cost Posting	Code	Normal
5700	Transfer Order Nos.	Code	Normal	→ No. Series #308
5701	Posted Transfer Shpt. Nos.	Code	Normal	→ No. Series #308
5702	Posted Transfer Rcpt. Nos.	Code	Normal	→ No. Series #308
5703	Copy Comments Order to Shpt.	Boolean	Normal
5704	Copy Comments Order to Rcpt.	Boolean	Normal
5718	Catalog Item Nos.	Code	Normal	→ No. Series #308
5790	Outbound Whse. Handling Time	DateFormula	Normal
5791	Inbound Whse. Handling Time	DateFormula	Normal
5800	Expected Cost Posting to G/L	Boolean	Normal
5801	Default Costing Method	Option	Normal
5804	Average Cost Calc. Type	Option	Normal
5805	Average Cost Period	Option	Normal
5840	Disable cost adjustment signals logging	Boolean	Normal
5849	Allow Invt. Doc. Reservation	Boolean	Normal
5850	Invt. Receipt Nos.	Code	Normal	→ No. Series #308
5851	Posted Invt. Receipt Nos.	Code	Normal	→ No. Series #308
5852	Invt. Shipment Nos.	Code	Normal	→ No. Series #308
5853	Posted Invt. Shipment Nos.	Code	Normal	→ No. Series #308
5854	Copy Comments to Invt. Doc.	Boolean	Normal
5855	Direct Transfer Posting	Option	Normal
5856	Posted Direct Trans. Nos.	Code	Normal	→ No. Series #308
5860	Package Nos.	Code	Normal	→ No. Series #308
5875	Phys. Invt. Order Nos.	Code	Normal	→ No. Series #308
5876	Posted Phys. Invt. Order Nos.	Code	Normal	→ No. Series #308
6500	Package Caption	Text	Normal
7101	Item Group Dimension Code	Code	Normal	→ Dimension #348
7300	Inventory Put-away Nos.	Code	Normal	→ No. Series #308
7301	Inventory Pick Nos.	Code	Normal	→ No. Series #308
7302	Posted Invt. Put-away Nos.	Code	Normal	→ No. Series #308
7303	Posted Invt. Pick Nos.	Code	Normal	→ No. Series #308
7304	Inventory Movement Nos.	Code	Normal	→ No. Series #308
7305	Registered Invt. Movement Nos.	Code	Normal	→ No. Series #308
7306	Internal Movement Nos.	Code	Normal	→ No. Series #308
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 (5)

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

No. Series

#308 · Other · via Item Nos., Transfer Order Nos., Posted Transfer Shpt. Nos., Posted Transfer Rcpt. Nos., Catalog Item Nos., Invt. Receipt Nos., Posted Invt. Receipt Nos., Invt. Shipment Nos., Posted Invt. Shipment Nos., Posted Direct Trans. Nos., Package Nos., Phys. Invt. Order Nos., Posted Phys. Invt. Order Nos., Inventory Put-away Nos., Inventory Pick Nos., Posted Invt. Put-away Nos., Posted Invt. Pick Nos., Inventory Movement Nos., Registered Invt. Movement Nos., Internal Movement Nos.

Production Forecast Name

#99000851 · Other · via Current Demand Forecast

Gen. Journal Template

#80 · Other · via Invt. Cost Jnl. Template Name

Dimension

#348 · Dimensions · via Item Group Dimension Code