Item – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IItem

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/27

Table Type: Company

Table Name: Item
Database Table Name: CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext

Table Number: 27

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 Item can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

Show/hide an example select of all columns by name

SELECT

   [No_]
   ,[No_ 2]
   ,[Description]
   ,[Search Description]
   ,[Description 2]
   ,[Base Unit of Measure]
   ,[Price Unit Conversion]
   ,[Type]
   ,[Inventory Posting Group]
   ,[Shelf No_]
   ,[Item Disc_ Group]
   ,[Allow Invoice Disc_]
   ,[Statistics Group]
   ,[Commission Group]
   ,[Unit Price]
   ,[Price_Profit Calculation]
   ,[Profit _]
   ,[Costing Method]
   ,[Unit Cost]
   ,[Standard Cost]
   ,[Last Direct Cost]
   ,[Indirect Cost _]
   ,[Cost is Adjusted]
   ,[Allow Online Adjustment]
   ,[Vendor No_]
   ,[Vendor Item No_]
   ,[Lead Time Calculation]
   ,[Reorder Point]
   ,[Maximum Inventory]
   ,[Reorder Quantity]
   ,[Alternative Item No_]
   ,[Unit List Price]
   ,[Duty Due _]
   ,[Duty Code]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Durability]
   ,[Freight Type]
   ,[Tariff No_]
   ,[Duty Unit Conversion]
   ,[Country_Region Purchased Code]
   ,[Budget Quantity]
   ,[Budgeted Amount]
   ,[Budget Profit]
   ,[Blocked]
   ,[Block Reason]
   ,[Last DateTime Modified]
   ,[Last Date Modified]
   ,[Last Time Modified]
   ,[Price Includes VAT]
   ,[VAT Bus_ Posting Gr_ (Price)]
   ,[Gen_ Prod_ Posting Group]
   ,[Picture]
   ,[Country_Region of Origin Code]
   ,[Automatic Ext_ Texts]
   ,[No_ Series]
   ,[Tax Group Code]
   ,[VAT Prod_ Posting Group]
   ,[Reserve]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Stockout Warning]
   ,[Prevent Negative Inventory]
   ,[Variant Mandatory if Exists]
   ,[Application Wksh_ User ID]
   ,[Coupled to CRM]
   ,[Assembly Policy]
   ,[GTIN]
   ,[Default Deferral Template Code]
   ,[Low-Level Code]
   ,[Lot Size]
   ,[Serial Nos_]
   ,[Last Unit Cost Calc_ Date]
   ,[Rolled-up Material Cost]
   ,[Rolled-up Capacity Cost]
   ,[Scrap _]
   ,[Inventory Value Zero]
   ,[Discrete Order Quantity]
   ,[Minimum Order Quantity]
   ,[Maximum Order Quantity]
   ,[Safety Stock Quantity]
   ,[Order Multiple]
   ,[Safety Lead Time]
   ,[Flushing Method]
   ,[Rounding Precision]
   ,[Sales Unit of Measure]
   ,[Purch_ Unit of Measure]
   ,[Time Bucket]
   ,[Reordering Policy]
   ,[Include Inventory]
   ,[Manufacturing Policy]
   ,[Rescheduling Period]
   ,[Lot Accumulation Period]
   ,[Dampener Period]
   ,[Dampener Quantity]
   ,[Overflow Level]
   ,[Manufacturer Code]
   ,[Item Category Code]
   ,[Created From Nonstock Item]
   ,[Product Group Code]
   ,[Purchasing Code]
   ,[Service Item Group]
   ,[Item Tracking Code]
   ,[Lot Nos_]
   ,[Expiration Calculation]
   ,[Warehouse Class Code]
   ,[Special Equipment Code]
   ,[Put-away Template Code]
   ,[Put-away Unit of Measure Code]
   ,[Phys Invt Counting Period Code]
   ,[Last Counting Period Update]
   ,[Use Cross-Docking]
   ,[Next Counting Start Date]
   ,[Next Counting End Date]
   ,[Id]
   ,[Unit of Measure Id]
   ,[Tax Group Id]
   ,[Sales Blocked]
   ,[Purchasing Blocked]
   ,[Item Category Id]
   ,[Inventory Posting Group Id]
   ,[Gen_ Prod_ Posting Group Id]
   ,[Over-Receipt Code]
   ,[Routing No_]
   ,[Production BOM No_]
   ,[Single-Level Material Cost]
   ,[Single-Level Capacity Cost]
   ,[Single-Level Subcontrd_ Cost]
   ,[Single-Level Cap_ Ovhd Cost]
   ,[Single-Level Mfg_ Ovhd Cost]
   ,[Overhead Rate]
   ,[Rolled-up Subcontracted Cost]
   ,[Rolled-up Mfg_ Ovhd Cost]
   ,[Rolled-up Cap_ Overhead Cost]
   ,[Order Tracking Policy]
   ,[Critical]
   ,[Common Item No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Item].[Base Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Item].[Inventory Posting Group] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Item].[Location Filter] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Item].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template]
      ON
         [Item].[Default Deferral Template Code] = [Deferral Template].[Deferral Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Item].[Variant Filter] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Item].[Unit of Measure Filter] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Manufacturer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturer]
      ON
         [Item].[Manufacturer Code] = [Manufacturer].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Item].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
      ON
         [Item].[Purchasing Code] = [Purchasing].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group]
      ON
         [Item].[Service Item Group] = [Service Item Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Tracking Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracking Code]
      ON
         [Item].[Item Tracking Code] = [Item Tracking Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Warehouse Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Class]
      ON
         [Item].[Warehouse Class Code] = [Warehouse Class].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
      ON
         [Item].[Special Equipment Code] = [Special Equipment].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Put-away Template Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Put-away Template Header]
      ON
         [Item].[Put-away Template Code] = [Put-away Template Header].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
      ON
         [Item].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Item].[Unit of Measure Id] = [Unit of Measure].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Item].[Tax Group Id] = [Tax Group].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Item].[Item Category Id] = [Item Category].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Item].[Inventory Posting Group Id] = [Inventory Posting Group].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Over-Receipt Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Over-Receipt Code]
      ON
         [Item].[Over-Receipt Code] = [Over-Receipt Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Name]
      ON
         [Item].[Production Forecast Name] = [Production Forecast Name].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [Item].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Item].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Item table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	No.	No.	Normal	Code	20	No_	nvarchar(40)
2	No. 2	No. 2	Normal	Code	20	No_ 2	nvarchar(40)
3	Description	Description	Normal	Text	100	Description	nvarchar(200)
4	Search Description	Search Description	Normal	Code	100	Search Description	nvarchar(200)
5	Description 2	Description 2	Normal	Text	50	Description 2	nvarchar(100)
6	Assembly BOM	Assembly BOM	FlowField	Boolean	4
8	Base Unit of Measure	Base Unit of Measure	Normal	Code	10	Base Unit of Measure	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Item].[Base Unit of Measure] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Item].[Base Unit of Measure] = [Unit of Measure].[Code]
9	Price Unit Conversion	Price Unit Conversion	Normal	Integer	4	Price Unit Conversion	int
10	Type	Type	Normal	Option	4	Type	int
	Available options are: “Inventory” “Service” “Non-Inventory”
11	Inventory Posting Group	Inventory Posting Group	Normal	Code	20	Inventory Posting Group	nvarchar(40)
	Key to join to the Inventory Posting Group table. Show/hide example query SELECT [Item].[Inventory Posting Group] ,[Inventory Posting Group].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group] ON [Item].[Inventory Posting Group] = [Inventory Posting Group].[Code]
12	Shelf No.	Shelf No.	Normal	Code	10	Shelf No_	nvarchar(20)
14	Item Disc. Group	Item Disc. Group	Normal	Code	20	Item Disc_ Group	nvarchar(40)
	Key to join to the Item Discount Group table. Show/hide example query SELECT [Item].[Item Disc_ Group] ,[Item Discount Group].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Item Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Discount Group] ON [Item].[Item Disc_ Group] = [Item Discount Group].[Code]
15	Allow Invoice Disc.	Allow Invoice Disc.	Normal	Boolean	4	Allow Invoice Disc_	tinyint
16	Statistics Group	Statistics Group	Normal	Integer	4	Statistics Group	int
17	Commission Group	Commission Group	Normal	Integer	4	Commission Group	int
18	Unit Price	Unit Price	Normal	Decimal	12	Unit Price	decimal(38,38)
19	Price/Profit Calculation	Price/Profit Calculation	Normal	Option	4	Price_Profit Calculation	int
20	Profit %	Profit %	Normal	Decimal	12	Profit _	decimal(38,38)
21	Costing Method	Costing Method	Normal	Option	4	Costing Method	int
	Available options are: “FIFO” “LIFO” “Specific” “Average” “Standard”
22	Unit Cost	Unit Cost	Normal	Decimal	12	Unit Cost	decimal(38,38)
24	Standard Cost	Standard Cost	Normal	Decimal	12	Standard Cost	decimal(38,38)
25	Last Direct Cost	Last Direct Cost	Normal	Decimal	12	Last Direct Cost	decimal(38,38)
28	Indirect Cost %	Indirect Cost %	Normal	Decimal	12	Indirect Cost _	decimal(38,38)
29	Cost is Adjusted	Cost is Adjusted	Normal	Boolean	4	Cost is Adjusted	tinyint
30	Allow Online Adjustment	Allow Online Adjustment	Normal	Boolean	4	Allow Online Adjustment	tinyint
31	Vendor No.	Vendor No.	Normal	Code	20	Vendor No_	nvarchar(40)
	Key to join to the Vendor table. Show/hide example query SELECT [Item].[Vendor No_] ,[Vendor].[No_] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Item].[Vendor No_] = [Vendor].[No_]
32	Vendor Item No.	Vendor Item No.	Normal	Text	50	Vendor Item No_	nvarchar(100)
33	Lead Time Calculation	Lead Time Calculation	Normal	DateFormula	32	Lead Time Calculation	varchar(32)
34	Reorder Point	Reorder Point	Normal	Decimal	12	Reorder Point	decimal(38,38)
35	Maximum Inventory	Maximum Inventory	Normal	Decimal	12	Maximum Inventory	decimal(38,38)
36	Reorder Quantity	Reorder Quantity	Normal	Decimal	12	Reorder Quantity	decimal(38,38)
37	Alternative Item No.	Alternative Item No.	Normal	Code	20	Alternative Item No_	nvarchar(40)
38	Unit List Price	Unit List Price	Normal	Decimal	12	Unit List Price	decimal(38,38)
39	Duty Due %	Duty Due %	Normal	Decimal	12	Duty Due _	decimal(38,38)
40	Duty Code	Duty Code	Normal	Code	10	Duty Code	nvarchar(20)
41	Gross Weight	Gross Weight	Normal	Decimal	12	Gross Weight	decimal(38,38)
42	Net Weight	Net Weight	Normal	Decimal	12	Net Weight	decimal(38,38)
43	Units per Parcel	Units per Parcel	Normal	Decimal	12	Units per Parcel	decimal(38,38)
44	Unit Volume	Unit Volume	Normal	Decimal	12	Unit Volume	decimal(38,38)
45	Durability	Durability	Normal	Code	10	Durability	nvarchar(20)
46	Freight Type	Freight Type	Normal	Code	10	Freight Type	nvarchar(20)
47	Tariff No.	Tariff No.	Normal	Code	20	Tariff No_	nvarchar(40)
	Key to join to the Tariff Number table. Show/hide example query SELECT [Item].[Tariff No_] ,[Tariff Number].[No_] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Tariff Number$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tariff Number] ON [Item].[Tariff No_] = [Tariff Number].[No_]
48	Duty Unit Conversion	Duty Unit Conversion	Normal	Decimal	12	Duty Unit Conversion	decimal(38,38)
49	Country/Region Purchased Code	Country/Region Purchased Code	Normal	Code	10	Country_Region Purchased Code	nvarchar(20)
50	Budget Quantity	Budget Quantity	Normal	Decimal	12	Budget Quantity	decimal(38,38)
51	Budgeted Amount	Budgeted Amount	Normal	Decimal	12	Budgeted Amount	decimal(38,38)
52	Budget Profit	Budget Profit	Normal	Decimal	12	Budget Profit	decimal(38,38)
53	Comment	Comment	FlowField	Boolean	4
54	Blocked	Blocked	Normal	Boolean	4	Blocked	tinyint
55	Cost is Posted to G/L	Cost is Posted to G/L	FlowField	Boolean	4
56	Block Reason	Block Reason	Normal	Text	250	Block Reason	nvarchar(500)
61	Last DateTime Modified	Last DateTime Modified	Normal	DateTime	8	Last DateTime Modified	datetime
62	Last Date Modified	Last Date Modified	Normal	Date	4	Last Date Modified	datetime
63	Last Time Modified	Last Time Modified	Normal	Time	4	Last Time Modified	datetime
64	Date Filter	Date Filter	FlowFilter	Date	4
65	Global Dimension 1 Filter	Global Dimension 1 Filter	FlowFilter	Code	20
66	Global Dimension 2 Filter	Global Dimension 2 Filter	FlowFilter	Code	20
67	Location Filter	Location Filter	FlowFilter	Code	10
	Key to join to the Location table. Show/hide example query SELECT [Item].[] ,[Location].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Item].[] = [Location].[Code]
68	Inventory	Quantity on Hand	FlowField	Decimal	12
69	Net Invoiced Qty.	Net Invoiced Qty.	FlowField	Decimal	12
70	Net Change	Net Change	FlowField	Decimal	12
71	Purchases (Qty.)	Purchases (Qty.)	FlowField	Decimal	12
72	Sales (Qty.)	Sales (Qty.)	FlowField	Decimal	12
73	Positive Adjmt. (Qty.)	Positive Adjmt. (Qty.)	FlowField	Decimal	12
74	Negative Adjmt. (Qty.)	Negative Adjmt. (Qty.)	FlowField	Decimal	12
77	Purchases (LCY)	Purchases ($)	FlowField	Decimal	12
78	Sales (LCY)	Sales ($)	FlowField	Decimal	12
79	Positive Adjmt. (LCY)	Positive Adjmt. ($)	FlowField	Decimal	12
80	Negative Adjmt. (LCY)	Negative Adjmt. ($)	FlowField	Decimal	12
83	COGS (LCY)	COGS ($)	FlowField	Decimal	12
84	Qty. on Purch. Order	Qty. on Purch. Order	FlowField	Decimal	12
85	Qty. on Sales Order	Qty. on Sales Order	FlowField	Decimal	12
87	Price Includes VAT	Price Includes Tax	Normal	Boolean	4	Price Includes VAT	tinyint
89	Drop Shipment Filter	Drop Shipment Filter	FlowFilter	Boolean	4
90	VAT Bus. Posting Gr. (Price)	Tax Bus. Posting Gr. (Price)	Normal	Code	20	VAT Bus_ Posting Gr_ (Price)	nvarchar(40)
	Key to join to the VAT Business Posting Group table. Show/hide example query SELECT [Item].[VAT Bus_ Posting Gr_ (Price)] ,[VAT Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group] ON [Item].[VAT Bus_ Posting Gr_ (Price)] = [VAT Business Posting Group].[Code]
91	Gen. Prod. Posting Group	Gen. Prod. Posting Group	Normal	Code	20	Gen_ Prod_ Posting Group	nvarchar(40)
	Key to join to the Gen. Product Posting Group table. Show/hide example query SELECT [Item].[Gen_ Prod_ Posting Group] ,[Gen. Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group] ON [Item].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
92	Picture	Picture	Normal	MediaSet	16	Picture	uniqueidentifier
93	Transferred (Qty.)	Transferred (Qty.)	FlowField	Decimal	12
94	Transferred (LCY)	Transferred ($)	FlowField	Decimal	12
95	Country/Region of Origin Code	Country/Region of Origin Code	Normal	Code	10	Country_Region of Origin Code	nvarchar(20)
96	Automatic Ext. Texts	Automatic Ext. Text	Normal	Boolean	4	Automatic Ext_ Texts	tinyint
97	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Item].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Item].[No_ Series] = [No. Series].[Code]
98	Tax Group Code	Tax Group Code	Normal	Code	20	Tax Group Code	nvarchar(40)
	Key to join to the Tax Group table. Show/hide example query SELECT [Item].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Item].[Tax Group Code] = [Tax Group].[Code]
99	VAT Prod. Posting Group	VAT Prod. Posting Group	Normal	Code	20	VAT Prod_ Posting Group	nvarchar(40)
	Key to join to the VAT Product Posting Group table. Show/hide example query SELECT [Item].[VAT Prod_ Posting Group] ,[VAT Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group] ON [Item].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
100	Reserve	Reserve	Normal	Option	4	Reserve	int
	Available options are: “Never” “Optional” “Always”
101	Reserved Qty. on Inventory	Reserved Qty. on Inventory	FlowField	Decimal	12
102	Reserved Qty. on Purch. Orders	Reserved Qty. on Purch. Orders	FlowField	Decimal	12
103	Reserved Qty. on Sales Orders	Reserved Qty. on Sales Orders	FlowField	Decimal	12
105	Global Dimension 1 Code	Global Dimension 1 Code	Normal	Code	20	Global Dimension 1 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Item].[Global Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Item].[Global Dimension 1 Code] = [Dimension].[Code]
106	Global Dimension 2 Code	Global Dimension 2 Code	Normal	Code	20	Global Dimension 2 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Item].[Global Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Item].[Global Dimension 2 Code] = [Dimension].[Code]
107	Res. Qty. on Outbound Transfer	Res. Qty. on Outbound Transfer	FlowField	Decimal	12
108	Res. Qty. on Inbound Transfer	Res. Qty. on Inbound Transfer	FlowField	Decimal	12
109	Res. Qty. on Sales Returns	Res. Qty. on Sales Returns	FlowField	Decimal	12
110	Res. Qty. on Purch. Returns	Res. Qty. on Purch. Returns	FlowField	Decimal	12
120	Stockout Warning	Stockout Warning	Normal	Option	4	Stockout Warning	int
	Available options are: “Default” “No” “Yes”
121	Prevent Negative Inventory	Prevent Negative Inventory	Normal	Option	4	Prevent Negative Inventory	int
	Available options are: “Default” “No” “Yes”
122	Variant Mandatory if Exists	Variant Mandatory if Exists	Normal	Option	4	Variant Mandatory if Exists	int
	Available options are: “Default” “No” “Yes”
200	Cost of Open Production Orders	Cost of Open Production Orders	FlowField	Decimal	12
521	Application Wksh. User ID	Application Wksh. User ID	Normal	Code	128	Application Wksh_ User ID	nvarchar(256)
720	Coupled to CRM	Coupled to Dynamics 365 Sales	Normal	Boolean	4	Coupled to CRM	tinyint
721	Coupled to Dataverse	Coupled to Dynamics 365 Sales	FlowField	Boolean	4
910	Assembly Policy	Assembly Policy	Normal	Option	4	Assembly Policy	int
	Available options are: “Assemble-to-Stock” “Assemble-to-Order”
929	Res. Qty. on Assembly Order	Res. Qty. on Assembly Order	FlowField	Decimal	12
930	Res. Qty. on Asm. Comp.	Res. Qty. on Asm. Comp.	FlowField	Decimal	12
977	Qty. on Assembly Order	Qty. on Assembly Order	FlowField	Decimal	12
978	Qty. on Asm. Component	Qty. on Asm. Component	FlowField	Decimal	12
1001	Qty. on Job Order	Qty. on Job Order	FlowField	Decimal	12
1002	Res. Qty. on Job Order	Res. Qty. on Job Order	FlowField	Decimal	12
1217	GTIN	GTIN	Normal	Code	14	GTIN	nvarchar(28)
1700	Default Deferral Template Code	Default Deferral Template Code	Normal	Code	10	Default Deferral Template Code	nvarchar(20)
	Key to join to the Deferral Template table. Show/hide example query SELECT [Item].[Default Deferral Template Code] ,[Deferral Template].[Deferral Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template] ON [Item].[Default Deferral Template Code] = [Deferral Template].[Deferral Code]
5400	Low-Level Code	Low-Level Code	Normal	Integer	4	Low-Level Code	int
5401	Lot Size	Lot Size	Normal	Decimal	12	Lot Size	decimal(38,38)
5402	Serial Nos.	Serial Nos.	Normal	Code	20	Serial Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Item].[Serial Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Item].[Serial Nos_] = [No. Series].[Code]
5403	Last Unit Cost Calc. Date	Last Unit Cost Calc. Date	Normal	Date	4	Last Unit Cost Calc_ Date	datetime
5404	Rolled-up Material Cost	Rolled-up Material Cost	Normal	Decimal	12	Rolled-up Material Cost	decimal(38,38)
5405	Rolled-up Capacity Cost	Rolled-up Capacity Cost	Normal	Decimal	12	Rolled-up Capacity Cost	decimal(38,38)
5407	Scrap %	Scrap %	Normal	Decimal	12	Scrap _	decimal(38,38)
5409	Inventory Value Zero	Inventory Value Zero	Normal	Boolean	4	Inventory Value Zero	tinyint
5410	Discrete Order Quantity	Discrete Order Quantity	Normal	Integer	4	Discrete Order Quantity	int
5411	Minimum Order Quantity	Minimum Order Quantity	Normal	Decimal	12	Minimum Order Quantity	decimal(38,38)
5412	Maximum Order Quantity	Maximum Order Quantity	Normal	Decimal	12	Maximum Order Quantity	decimal(38,38)
5413	Safety Stock Quantity	Safety Stock Quantity	Normal	Decimal	12	Safety Stock Quantity	decimal(38,38)
5414	Order Multiple	Order Multiple	Normal	Decimal	12	Order Multiple	decimal(38,38)
5415	Safety Lead Time	Safety Lead Time	Normal	DateFormula	32	Safety Lead Time	varchar(32)
5417	Flushing Method	Flushing Method	Normal	Option	4	Flushing Method	int
	Available options are: “Manual” “Forward” “Backward” “Pick + Forward” “Pick + Backward”
5419	Replenishment System	Replenishment System	Normal	Option	4
5420	Scheduled Receipt (Qty.)	Scheduled Receipt (Qty.)	FlowField	Decimal	12
5421	Scheduled Need (Qty.)	Scheduled Need (Qty.)	FlowField	Decimal	12
5422	Rounding Precision	Rounding Precision	Normal	Decimal	12	Rounding Precision	decimal(38,38)
5423	Bin Filter	Bin Filter	FlowFilter	Code	20
5424	Variant Filter	Variant Filter	FlowFilter	Code	10
	Key to join to the Item Variant table. Show/hide example query SELECT [Item].[] ,[Item Variant].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant] ON [Item].[] = [Item Variant].[Code]
5425	Sales Unit of Measure	Sales Unit of Measure	Normal	Code	10	Sales Unit of Measure	nvarchar(20)
5426	Purch. Unit of Measure	Purch. Unit of Measure	Normal	Code	10	Purch_ Unit of Measure	nvarchar(20)
5427	Unit of Measure Filter	Unit of Measure Filter	FlowFilter	Code	10
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Item].[] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Item].[] = [Unit of Measure].[Code]
5428	Time Bucket	Time Bucket	Normal	DateFormula	32	Time Bucket	varchar(32)
5429	Reserved Qty. on Prod. Order	Reserved Qty. on Prod. Order	FlowField	Decimal	12
5430	Res. Qty. on Prod. Order Comp.	Res. Qty. on Prod. Order Comp.	FlowField	Decimal	12
5431	Res. Qty. on Req. Line	Res. Qty. on Req. Line	FlowField	Decimal	12
5440	Reordering Policy	Reordering Policy	Normal	Option	4	Reordering Policy	int
	Available options are: ” “ “Fixed Reorder Qty.” “Maximum Qty.” “Order” “Lot-for-Lot”
5441	Include Inventory	Include Inventory	Normal	Boolean	4	Include Inventory	tinyint
5442	Manufacturing Policy	Manufacturing Policy	Normal	Option	4	Manufacturing Policy	int
	Available options are: “Make-to-Stock” “Make-to-Order”
5443	Rescheduling Period	Rescheduling Period	Normal	DateFormula	32	Rescheduling Period	varchar(32)
5444	Lot Accumulation Period	Lot Accumulation Period	Normal	DateFormula	32	Lot Accumulation Period	varchar(32)
5445	Dampener Period	Dampener Period	Normal	DateFormula	32	Dampener Period	varchar(32)
5446	Dampener Quantity	Dampener Quantity	Normal	Decimal	12	Dampener Quantity	decimal(38,38)
5447	Overflow Level	Overflow Level	Normal	Decimal	12	Overflow Level	decimal(38,38)
5449	Planning Transfer Ship. (Qty).	Planning Transfer Ship. (Qty).	FlowField	Decimal	12
5450	Planning Worksheet (Qty.)	Planning Worksheet (Qty.)	FlowField	Decimal	12
5700	Stockkeeping Unit Exists	Stockkeeping Unit Exists	FlowField	Boolean	4
5701	Manufacturer Code	Manufacturer Code	Normal	Code	10	Manufacturer Code	nvarchar(20)
	Key to join to the Manufacturer table. Show/hide example query SELECT [Item].[Manufacturer Code] ,[Manufacturer].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Manufacturer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturer] ON [Item].[Manufacturer Code] = [Manufacturer].[Code]
5702	Item Category Code	Item Category Code	Normal	Code	20	Item Category Code	nvarchar(40)
	Key to join to the Item Category table. Show/hide example query SELECT [Item].[Item Category Code] ,[Item Category].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category] ON [Item].[Item Category Code] = [Item Category].[Code]
5703	Created From Nonstock Item	Created From Catalog Item	Normal	Boolean	4	Created From Nonstock Item	tinyint
5704	Product Group Code	Product Group Code	Normal	Code	10	Product Group Code	nvarchar(20)
5706	Substitutes Exist	Substitutes Exist	FlowField	Boolean	4
5707	Qty. in Transit	Qty. in Transit	FlowField	Decimal	12
5708	Trans. Ord. Receipt (Qty.)	Trans. Ord. Receipt (Qty.)	FlowField	Decimal	12
5709	Trans. Ord. Shipment (Qty.)	Trans. Ord. Shipment (Qty.)	FlowField	Decimal	12
5711	Purchasing Code	Purchasing Code	Normal	Code	10	Purchasing Code	nvarchar(20)
	Key to join to the Purchasing table. Show/hide example query SELECT [Item].[Purchasing Code] ,[Purchasing].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing] ON [Item].[Purchasing Code] = [Purchasing].[Code]
5776	Qty. Assigned to ship	Qty. Assigned to ship	FlowField	Decimal	12
5777	Qty. Picked	Qty. Picked	FlowField	Decimal	12
5900	Service Item Group	Service Item Group	Normal	Code	10	Service Item Group	nvarchar(20)
	Key to join to the Service Item Group table. Show/hide example query SELECT [Item].[Service Item Group] ,[Service Item Group].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group] ON [Item].[Service Item Group] = [Service Item Group].[Code]
5901	Qty. on Service Order	Qty. on Service Order	FlowField	Decimal	12
5902	Res. Qty. on Service Orders	Res. Qty. on Service Orders	FlowField	Decimal	12
6500	Item Tracking Code	Item Tracking Code	Normal	Code	10	Item Tracking Code	nvarchar(20)
	Key to join to the Item Tracking Code table. Show/hide example query SELECT [Item].[Item Tracking Code] ,[Item Tracking Code].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Item Tracking Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracking Code] ON [Item].[Item Tracking Code] = [Item Tracking Code].[Code]
6501	Lot Nos.	Lot Nos.	Normal	Code	20	Lot Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Item].[Lot Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Item].[Lot Nos_] = [No. Series].[Code]
6502	Expiration Calculation	Expiration Calculation	Normal	DateFormula	32	Expiration Calculation	varchar(32)
6503	Lot No. Filter	Lot No. Filter	FlowFilter	Code	50
6504	Serial No. Filter	Serial No. Filter	FlowFilter	Code	50
6515	Package No. Filter	Package No. Filter	FlowFilter	Code	50
6650	Qty. on Purch. Return	Qty. on Purch. Return	FlowField	Decimal	12
6660	Qty. on Sales Return	Qty. on Sales Return	FlowField	Decimal	12
7171	No. of Substitutes	No. of Substitutes	FlowField	Integer	4
7300	Warehouse Class Code	Warehouse Class Code	Normal	Code	10	Warehouse Class Code	nvarchar(20)
	Key to join to the Warehouse Class table. Show/hide example query SELECT [Item].[Warehouse Class Code] ,[Warehouse Class].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Warehouse Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Class] ON [Item].[Warehouse Class Code] = [Warehouse Class].[Code]
7301	Special Equipment Code	Special Equipment Code	Normal	Code	10	Special Equipment Code	nvarchar(20)
	Key to join to the Special Equipment table. Show/hide example query SELECT [Item].[Special Equipment Code] ,[Special Equipment].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment] ON [Item].[Special Equipment Code] = [Special Equipment].[Code]
7302	Put-away Template Code	Put-away Template Code	Normal	Code	10	Put-away Template Code	nvarchar(20)
	Key to join to the Put-away Template Header table. Show/hide example query SELECT [Item].[Put-away Template Code] ,[Put-away Template Header].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Put-away Template Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Put-away Template Header] ON [Item].[Put-away Template Code] = [Put-away Template Header].[Code]
7307	Put-away Unit of Measure Code	Put-away Unit of Measure Code	Normal	Code	10	Put-away Unit of Measure Code	nvarchar(20)
7380	Phys Invt Counting Period Code	Phys Invt Counting Period Code	Normal	Code	10	Phys Invt Counting Period Code	nvarchar(20)
	Key to join to the Phys. Invt. Counting Period table. Show/hide example query SELECT [Item].[Phys Invt Counting Period Code] ,[Phys. Invt. Counting Period].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period] ON [Item].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
7381	Last Counting Period Update	Last Counting Period Update	Normal	Date	4	Last Counting Period Update	datetime
7383	Last Phys. Invt. Date	Last Phys. Invt. Date	FlowField	Date	4
7384	Use Cross-Docking	Use Cross-Docking	Normal	Boolean	4	Use Cross-Docking	tinyint
7385	Next Counting Start Date	Next Counting Start Date	Normal	Date	4	Next Counting Start Date	datetime
7386	Next Counting End Date	Next Counting End Date	Normal	Date	4	Next Counting End Date	datetime
7387	Unit Group Exists	Unit Group Exists	FlowField	Boolean	4
7700	Identifier Code	Identifier Code	FlowField	Code	20
8000	Id	Id	Normal	GUID	16	Id	uniqueidentifier
8001	Unit of Measure Id	Unit of Measure Id	Normal	GUID	16	Unit of Measure Id	uniqueidentifier
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Item].[Unit of Measure Id] ,[Unit of Measure].[$systemId] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Item].[Unit of Measure Id] = [Unit of Measure].[$systemId]
8002	Tax Group Id	Tax Group Id	Normal	GUID	16	Tax Group Id	uniqueidentifier
	Key to join to the Tax Group table. Show/hide example query SELECT [Item].[Tax Group Id] ,[Tax Group].[$systemId] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Item].[Tax Group Id] = [Tax Group].[$systemId]
8003	Sales Blocked	Sales Blocked	Normal	Boolean	4	Sales Blocked	tinyint
8004	Purchasing Blocked	Purchasing Blocked	Normal	Boolean	4	Purchasing Blocked	tinyint
8005	Item Category Id	Item Category Id	Normal	GUID	16	Item Category Id	uniqueidentifier
	Key to join to the Item Category table. Show/hide example query SELECT [Item].[Item Category Id] ,[Item Category].[$systemId] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category] ON [Item].[Item Category Id] = [Item Category].[$systemId]
8006	Inventory Posting Group Id	Inventory Posting Group Id	Normal	GUID	16	Inventory Posting Group Id	uniqueidentifier
	Key to join to the Inventory Posting Group table. Show/hide example query SELECT [Item].[Inventory Posting Group Id] ,[Inventory Posting Group].[$systemId] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group] ON [Item].[Inventory Posting Group Id] = [Inventory Posting Group].[$systemId]
8007	Gen. Prod. Posting Group Id	Gen. Prod. Posting Group Id	Normal	GUID	16	Gen_ Prod_ Posting Group Id	uniqueidentifier
	Key to join to the Gen. Product Posting Group table. Show/hide example query SELECT [Item].[Gen_ Prod_ Posting Group Id] ,[Gen. Product Posting Group].[$systemId] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group] ON [Item].[Gen_ Prod_ Posting Group Id] = [Gen. Product Posting Group].[$systemId]
8510	Over-Receipt Code	Over-Receipt Code	Normal	Code	20	Over-Receipt Code	nvarchar(40)
	Key to join to the Over-Receipt Code table. Show/hide example query SELECT [Item].[Over-Receipt Code] ,[Over-Receipt Code].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Over-Receipt Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Over-Receipt Code] ON [Item].[Over-Receipt Code] = [Over-Receipt Code].[Code]
10004	Duty Class	Duty Class	Normal	Code	10
10011	Consumptions (Qty.)	Consumptions (Qty.)	FlowField	Decimal	12
10012	Outputs (Qty.)	Outputs (Qty.)	FlowField	Decimal	12
10013	Rel. Scheduled Receipt (Qty.)	Rel. Scheduled Receipt (Qty.)	FlowField	Decimal	12
10014	Rel. Scheduled Need (Qty.)	Rel. Scheduled Need (Qty.)	FlowField	Decimal	12
21850	Has Sales Forecast	Has Sales Forecast	Normal	Boolean	4
27000	SAT Item Classification	SAT Item Classification	Normal	Code	10
27024	SAT Hazardous Material	SAT Hazardous Material	Normal	Code	10
27025	SAT Packaging Type	SAT Packaging Type	Normal	Code	10
99000750	Routing No.	Routing No.	Normal	Code	20	Routing No_	nvarchar(40)
	Key to join to the Routing Header table. Show/hide example query SELECT [Item].[Routing No_] ,[Routing Header].[No_] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Routing Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Header] ON [Item].[Routing No_] = [Routing Header].[No_]
99000751	Production BOM No.	Production BOM No.	Normal	Code	20	Production BOM No_	nvarchar(40)
	Key to join to the Production BOM Header table. Show/hide example query SELECT [Item].[Production BOM No_] ,[Production BOM Header].[No_] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Header] ON [Item].[Production BOM No_] = [Production BOM Header].[No_] Part of multi-key to join to the Production BOM Line table. Show/hide example query SELECT [Item].[Production BOM No_] ,[Production BOM Line].[Line No_] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line] ON [Item].[Production BOM No_] = [Production BOM Line].[Line No_] Part of multi-key to join to the Production BOM Line table. Show/hide example query SELECT [Item].[Production BOM No_] ,[Production BOM Line].[Production BOM No_] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line] ON [Item].[Production BOM No_] = [Production BOM Line].[Production BOM No_]
99000752	Single-Level Material Cost	Single-Level Material Cost	Normal	Decimal	12	Single-Level Material Cost	decimal(38,38)
99000753	Single-Level Capacity Cost	Single-Level Capacity Cost	Normal	Decimal	12	Single-Level Capacity Cost	decimal(38,38)
99000754	Single-Level Subcontrd. Cost	Single-Level Subcontrd. Cost	Normal	Decimal	12	Single-Level Subcontrd_ Cost	decimal(38,38)
99000755	Single-Level Cap. Ovhd Cost	Single-Level Cap. Ovhd Cost	Normal	Decimal	12	Single-Level Cap_ Ovhd Cost	decimal(38,38)
99000756	Single-Level Mfg. Ovhd Cost	Single-Level Mfg. Ovhd Cost	Normal	Decimal	12	Single-Level Mfg_ Ovhd Cost	decimal(38,38)
99000757	Overhead Rate	Overhead Rate	Normal	Decimal	12	Overhead Rate	decimal(38,38)
99000758	Rolled-up Subcontracted Cost	Rolled-up Subcontracted Cost	Normal	Decimal	12	Rolled-up Subcontracted Cost	decimal(38,38)
99000759	Rolled-up Mfg. Ovhd Cost	Rolled-up Mfg. Ovhd Cost	Normal	Decimal	12	Rolled-up Mfg_ Ovhd Cost	decimal(38,38)
99000760	Rolled-up Cap. Overhead Cost	Rolled-up Cap. Overhead Cost	Normal	Decimal	12	Rolled-up Cap_ Overhead Cost	decimal(38,38)
99000761	Planning Issues (Qty.)	Planning Issues (Qty.)	FlowField	Decimal	12
99000762	Planning Receipt (Qty.)	Planning Receipt (Qty.)	FlowField	Decimal	12
99000765	Planned Order Receipt (Qty.)	Planned Order Receipt (Qty.)	FlowField	Decimal	12
99000766	FP Order Receipt (Qty.)	FP Order Receipt (Qty.)	FlowField	Decimal	12
99000767	Rel. Order Receipt (Qty.)	Rel. Order Receipt (Qty.)	FlowField	Decimal	12
99000768	Planning Release (Qty.)	Planning Release (Qty.)	FlowField	Decimal	12
99000769	Planned Order Release (Qty.)	Planned Order Release (Qty.)	FlowField	Decimal	12
99000770	Purch. Req. Receipt (Qty.)	Purch. Req. Receipt (Qty.)	FlowField	Decimal	12
99000771	Purch. Req. Release (Qty.)	Purch. Req. Release (Qty.)	FlowField	Decimal	12
99000773	Order Tracking Policy	Order Tracking Policy	Normal	Option	4	Order Tracking Policy	int
	Available options are: “None” “Tracking Only” “Tracking & Action Msg.”
99000774	Prod. Forecast Quantity (Base)	Prod. Forecast Quantity (Base)	FlowField	Decimal	12
99000775	Production Forecast Name	Production Forecast Name	FlowFilter	Code	10
	Key to join to the Production Forecast Name table. Show/hide example query SELECT [Item].[] ,[Production Forecast Name].[Name] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Production Forecast Name$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production Forecast Name] ON [Item].[] = [Production Forecast Name].[Name]
99000776	Component Forecast	Component Forecast	FlowFilter	Boolean	4
99000777	Qty. on Prod. Order	Qty. on Prod. Order	FlowField	Decimal	12
99000778	Qty. on Component Lines	Qty. on Component Lines	FlowField	Decimal	12
99000875	Critical	Critical	Normal	Boolean	4	Critical	tinyint
99008500	Common Item No.	Common Item No.	Normal	Code	20	Common Item No_	nvarchar(40)
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 [Item].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] LEFT JOIN [User] AS [User] ON [Item].[$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 Item table

Item Category Item Tracking Code Product Group Put-away Template Header Service Item Group Special Equipment Tax Group Unit of Measure Warehouse Class

Dynamics 365 BC Table Reference Tables Company Tables IItem

Leave a Reply Cancel reply