Item

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

Show/hide tables related from Item table

Show/hide tables related to Item table

Action Message EntryAssembly HeaderATO Sales BufferAvailability Calc_ OverviewAverage Cost Calc_ OverviewAvg_ Cost Adjmt_ Entry PointBin ContentBin Creation Worksheet LineBooking Service MappingCapacity Ledger EntryCost Share BufferDirect Trans_ LineFamily LineFiled Contract LineInternal Movement LineIntrastat Jnl_ LineInventory Adjmt_ Entry (Order)Inventory Adjustment BufferInventory BufferInventory Event BufferInventory Page DataInventory ProfileInvt_ Document LineInvt_ Receipt LineInvt_ Shipment LineItem AmountItem Analysis View Budg_ EntryItem Analysis View EntryItem Availability BufferItem Availability by DateItem Budget BufferItem Budget EntryItem Charge Assignment (Purch)Item Charge Assignment (Sales)Item Cross ReferenceItem IdentifierItem Journal BufferItem Journal LineItem Ledger EntryItem Picture BufferItem ReferenceItem Tracing BufferItem Tracking CommentItem TranslationItem Unit of MeasureItem VariantItem VendorJob Item PriceLoanerLot Bin BufferLot No_ InformationLot Numbers by Bin BufferMS – Sales ForecastMS – Sales Forecast ParameterMy ItemNonstock ItemO365 Item Basket EntryOffice Suggested Line ItemOrder Promising LineOrder Tracking EntryPackage No_ InformationPhys_ Inventory Ledger EntryPhys_ Invt_ Item SelectionPhys_ Invt_ Order LinePhys_ Invt_ Record LinePlanning AssignmentPlanning BufferPlanning ComponentPlanning Error LogPost Value Entry to G_LPosted Assembly HeaderPosted Invt_ Pick LinePosted Invt_ Put-away LinePosted Whse_ Receipt LinePosted Whse_ Shipment LineProduction Forecast EntryProduction Matrix BOM EntryProduction Matrix BOM LineProd_ Order ComponentProd_ Order LinePstd_ Phys_ Invt_ Order LinePstd_ Phys_ Invt_ Record LinePstd_ Phys_ Invt_ TrackingPurchase Line DiscountPurchase Prepayment _Purchase PricePurch_ Price Line Disc_ Buff_Record BufferRegistered Invt_ Movement LineRegistered Whse_ Activity LineReservation EntrySales Planning LineSales Prepayment _Sales PriceSales Price WorksheetSerial No_ InformationService Contract LineService ItemService Item LineService Shipment Item LineStandard Item Journal LineStockkeeping UnitStockkeeping Unit Comment LineTracking SpecificationTransfer LineTransfer Receipt LineTransfer Shipment LineUnplanned DemandUntracked Planning ElementValue EntryWarehouse Activity LineWarehouse EntryWarehouse Journal LineWarehouse Receipt LineWarehouse Shipment LineWhere-Used LineWhse_ Cross-Dock OpportunityWhse_ Internal Pick LineWhse_ Internal Put-away LineWhse_ Item Tracking LineWhse_ Worksheet Line

Leave a Reply

Your email address will not be published. Required fields are marked *