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

Table Number: 0

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]

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[No_]
   ,[Has Sales Forecast]
   ,[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]
   ,[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]
   ,[Replenishment System]
   ,[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]
   ,[Reverse Charge Applies]
   ,[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]

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_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Item].[Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Item].[Country_Region Purchased Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Item].[Country_Region of Origin Code] = [Country_Region].[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_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Item].[Sales Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Item].[Purch_ Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Manufacturer] AS [Manufactuer]
      ON
         [Item].[Manufacturer Code] = [Manufactuer].[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_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Item].[Product Group Code] = [Product Group].[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_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Item].[Put-away Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
      ON
         [Item].[BOM Line No_] = [Production BOM Line].[Line No_]
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_]
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_]

Show/hide columns in Item table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	No_	nvarchar(40)
3	Has Sales Forecast	tinyint
3	No_ 2	nvarchar(40)
4	Description	nvarchar(200)
5	Search Description	nvarchar(200)
6	Description 2	nvarchar(100)
7	Base Unit of Measure	nvarchar(20)
8	Price Unit Conversion	int
9	Type	int
10	Inventory Posting Group	nvarchar(40)
11	Shelf No_	nvarchar(20)
12	Item Disc_ Group	nvarchar(40)
13	Allow Invoice Disc_	tinyint
14	Statistics Group	int
15	Commission Group	int
16	Unit Price	decimal(38,38)
17	Price_Profit Calculation	int
18	Profit _	decimal(38,38)
19	Costing Method	int
20	Unit Cost	decimal(38,38)
21	Standard Cost	decimal(38,38)
22	Last Direct Cost	decimal(38,38)
23	Indirect Cost _	decimal(38,38)
24	Cost is Adjusted	tinyint
25	Allow Online Adjustment	tinyint
26	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] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Item].[Vendor No_] = [Vendor].[No_]
27	Vendor Item No_	nvarchar(100)
28	Lead Time Calculation	varchar(32)
29	Reorder Point	decimal(38,38)
30	Maximum Inventory	decimal(38,38)
31	Reorder Quantity	decimal(38,38)
32	Alternative Item No_	nvarchar(40)
33	Unit List Price	decimal(38,38)
34	Duty Due _	decimal(38,38)
35	Duty Code	nvarchar(20)
36	Gross Weight	decimal(38,38)
37	Net Weight	decimal(38,38)
38	Units per Parcel	decimal(38,38)
39	Unit Volume	decimal(38,38)
40	Durability	nvarchar(20)
41	Freight Type	nvarchar(20)
42	Tariff No_	nvarchar(40)
43	Duty Unit Conversion	decimal(38,38)
44	Country_Region Purchased Code	nvarchar(20)
	Key to join to the Country_Region table. Show/hide example query SELECT [Item].[Country_Region Purchased Code] ,[Country_Region].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region] ON [Item].[Country_Region Purchased Code] = [Country_Region].[Code]
45	Budget Quantity	decimal(38,38)
46	Budgeted Amount	decimal(38,38)
47	Budget Profit	decimal(38,38)
48	Blocked	tinyint
49	Block Reason	nvarchar(500)
50	Last DateTime Modified	datetime
51	Last Date Modified	datetime
52	Last Time Modified	datetime
53	Price Includes VAT	tinyint
54	VAT Bus_ Posting Gr_ (Price)	nvarchar(40)
55	Gen_ Prod_ Posting Group	nvarchar(40)
56	Picture	uniqueidentifier
57	Country_Region of Origin Code	nvarchar(20)
	Key to join to the Country_Region table. Show/hide example query SELECT [Item].[Country_Region of Origin Code] ,[Country_Region].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region] ON [Item].[Country_Region of Origin Code] = [Country_Region].[Code]
58	Automatic Ext_ Texts	tinyint
59	No_ Series	nvarchar(40)
60	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] 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]
61	VAT Prod_ Posting Group	nvarchar(40)
62	Reserve	int
63	Global Dimension 1 Code	nvarchar(40)
64	Global Dimension 2 Code	nvarchar(40)
65	Stockout Warning	int
66	Prevent Negative Inventory	int
67	Application Wksh_ User ID	nvarchar(256)
68	Coupled to CRM	tinyint
69	Assembly Policy	int
70	GTIN	nvarchar(28)
71	Default Deferral Template Code	nvarchar(20)
72	Low-Level Code	int
73	Lot Size	decimal(38,38)
74	Serial Nos_	nvarchar(40)
75	Last Unit Cost Calc_ Date	datetime
76	Rolled-up Material Cost	decimal(38,38)
77	Rolled-up Capacity Cost	decimal(38,38)
78	Scrap _	decimal(38,38)
79	Inventory Value Zero	tinyint
80	Discrete Order Quantity	int
81	Minimum Order Quantity	decimal(38,38)
82	Maximum Order Quantity	decimal(38,38)
83	Safety Stock Quantity	decimal(38,38)
84	Order Multiple	decimal(38,38)
85	Safety Lead Time	varchar(32)
86	Flushing Method	int
87	Replenishment System	int
88	Rounding Precision	decimal(38,38)
89	Sales Unit of Measure	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Item].[Sales Unit of Measure] ,[Unit of Measure].[Code] 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].[Sales Unit of Measure] = [Unit of Measure].[Code]
90	Purch_ Unit of Measure	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Item].[Purch_ Unit of Measure] ,[Unit of Measure].[Code] 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].[Purch_ Unit of Measure] = [Unit of Measure].[Code]
91	Time Bucket	varchar(32)
92	Reordering Policy	int
93	Include Inventory	tinyint
94	Manufacturing Policy	int
95	Rescheduling Period	varchar(32)
96	Lot Accumulation Period	varchar(32)
97	Dampener Period	varchar(32)
98	Dampener Quantity	decimal(38,38)
99	Overflow Level	decimal(38,38)
100	Manufacturer Code	nvarchar(20)
	Key to join to the Manufactuer table. Show/hide example query SELECT [Item].[Manufacturer Code] ,[Manufactuer].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Manufacturer] AS [Manufactuer] ON [Item].[Manufacturer Code] = [Manufactuer].[Code]
101	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] 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]
102	Created From Nonstock Item	tinyint
103	Product Group Code	nvarchar(20)
	Key to join to the Product Group table. Show/hide example query SELECT [Item].[Product Group Code] ,[Product Group].[Code] FROM [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item] LEFT JOIN [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group] ON [Item].[Product Group Code] = [Product Group].[Code]
104	Purchasing Code	nvarchar(20)
105	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] 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]
106	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] 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]
107	Lot Nos_	nvarchar(40)
108	Expiration Calculation	varchar(32)
109	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] 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]
110	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] 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]
111	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] 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]
112	Put-away Unit of Measure Code	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Item].[Put-away Unit of Measure Code] ,[Unit of Measure].[Code] 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].[Put-away Unit of Measure Code] = [Unit of Measure].[Code]
113	Phys Invt Counting Period Code	nvarchar(20)
114	Last Counting Period Update	datetime
115	Use Cross-Docking	tinyint
116	Next Counting Start Date	datetime
117	Next Counting End Date	datetime
118	Id	uniqueidentifier
119	Unit of Measure Id	uniqueidentifier
120	Tax Group Id	uniqueidentifier
121	Sales Blocked	tinyint
122	Purchasing Blocked	tinyint
123	Item Category Id	uniqueidentifier
124	Inventory Posting Group Id	uniqueidentifier
125	Gen_ Prod_ Posting Group Id	uniqueidentifier
126	Over-Receipt Code	nvarchar(40)
127	Reverse Charge Applies	tinyint
128	Routing No_	nvarchar(40)
129	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] 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_] 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] 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_] AND [Item].[BOM Line No_] = [Production BOM Line].[Line No_]
130	Single-Level Material Cost	decimal(38,38)
131	Single-Level Capacity Cost	decimal(38,38)
132	Single-Level Subcontrd_ Cost	decimal(38,38)
133	Single-Level Cap_ Ovhd Cost	decimal(38,38)
134	Single-Level Mfg_ Ovhd Cost	decimal(38,38)
135	Overhead Rate	decimal(38,38)
136	Rolled-up Subcontracted Cost	decimal(38,38)
137	Rolled-up Mfg_ Ovhd Cost	decimal(38,38)
138	Rolled-up Cap_ Overhead Cost	decimal(38,38)
139	Order Tracking Policy	int
140	Critical	tinyint
141	Common Item No_	nvarchar(40)
142	$systemId	uniqueidentifier
143	$systemCreatedAt	datetime
144	$systemCreatedBy	uniqueidentifier
145	$systemModifiedAt	datetime
146	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Item table

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

Show/hide tables related to Item table

Action Message Entry Assembly Header ATO Sales Buffer Availability Calc_ Overview Average Cost Calc_ Overview Avg_ Cost Adjmt_ Entry Point Bin Content Bin Creation Worksheet Line Booking Service Mapping Capacity Ledger Entry Cost Share Buffer Direct Trans_ Line Family Line Filed Contract Line Internal Movement Line Intrastat Jnl_ Line Inventory Adjmt_ Entry (Order)Inventory Adjustment Buffer Inventory Buffer Inventory Event Buffer Inventory Page Data Inventory Profile Invt_ Document Line Invt_ Receipt Line Invt_ Shipment Line Item Amount Item Analysis View Budg_ Entry Item Analysis View Entry Item Availability Buffer Item Availability by Date Item Budget Buffer Item Budget Entry Item Charge Assignment (Purch)Item Charge Assignment (Sales)Item Cross Reference Item Identifier Item Journal Buffer Item Journal Line Item Ledger Entry Item Picture Buffer Item Reference Item Tracing Buffer Item Tracking Comment Item Translation Item Unit of Measure Item Variant Item Vendor Job Item Price Loaner Lot Bin Buffer Lot No_ Information Lot Numbers by Bin Buffer MS – Sales Forecast MS – Sales Forecast Parameter My Item Nonstock Item O365 Item Basket Entry Office Suggested Line Item Order Promising Line Order Tracking Entry Package No_ Information Phys_ Inventory Ledger Entry Phys_ Invt_ Item Selection Phys_ Invt_ Order Line Phys_ Invt_ Record Line Planning Assignment Planning Buffer Planning Component Planning Error Log Post Value Entry to G_L Posted Assembly Header Posted Invt_ Pick Line Posted Invt_ Put-away Line Posted Whse_ Receipt Line Posted Whse_ Shipment Line Production Forecast Entry Production Matrix BOM Entry Production Matrix BOM Line Prod_ Order Component Prod_ Order Line Pstd_ Phys_ Invt_ Order Line Pstd_ Phys_ Invt_ Record Line Pstd_ Phys_ Invt_ Tracking Purchase Line Discount Purchase Prepayment _Purchase Price Purch_ Price Line Disc_ Buff_Record Buffer Registered Invt_ Movement Line Registered Whse_ Activity Line Reservation Entry Sales Planning Line Sales Prepayment _Sales Price Sales Price Worksheet Serial No_ Information Service Contract Line Service Item Service Item Line Service Shipment Item Line Standard Item Journal Line Stockkeeping Unit Stockkeeping Unit Comment Line Tracking Specification Transfer Line Transfer Receipt Line Transfer Shipment Line Unplanned Demand Untracked Planning Element Value Entry Warehouse Activity Line Warehouse Entry Warehouse Journal Line Warehouse Receipt Line Warehouse Shipment Line Where-Used Line Whse_ Cross-Dock Opportunity Whse_ Internal Pick Line Whse_ Internal Put-away Line Whse_ Item Tracking Line Whse_ Worksheet Line

Dynamics 365 BC Table Reference Tables Company Tables IItem

Leave a Reply Cancel reply