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$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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. SearchNo.NormalCode20No_nvarchar(40)
2No. 2 Primary Key SearchNo. 2NormalCode20No_ 2nvarchar(40)
3Description SearchDescriptionNormalText100Descriptionnvarchar(200)
4Search Description SearchSearch DescriptionNormalCode100Search Descriptionnvarchar(200)
5Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
6Assembly BOM SearchAssembly BOMFlowFieldBoolean4
8Base Unit of Measure SearchBase Unit of MeasureNormalCode10Base Unit of Measurenvarchar(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]
9Price Unit Conversion SearchPrice Unit ConversionNormalInteger4Price Unit Conversionint
10Type SearchTypeNormalOption4Typeint
Available options are:
  • “Inventory”
  • “Service”
  • “Non-Inventory”
11Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(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]
12Shelf No. SearchShelf No.NormalCode10Shelf No_nvarchar(20)
14Item Disc. Group SearchItem Disc. GroupNormalCode20Item Disc_ Groupnvarchar(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]
15Allow Invoice Disc. SearchAllow Invoice Disc.NormalBoolean4Allow Invoice Disc_tinyint
16Statistics Group SearchStatistics GroupNormalInteger4Statistics Groupint
17Commission Group SearchCommission GroupNormalInteger4Commission Groupint
18Unit Price SearchUnit PriceNormalDecimal12Unit Pricedecimal(38,38)
19Price/Profit Calculation SearchPrice/Profit CalculationNormalOption4Price_Profit Calculationint
20Profit % SearchProfit %NormalDecimal12Profit _decimal(38,38)
21Costing Method SearchCosting MethodNormalOption4Costing Methodint
Available options are:
  • “FIFO”
  • “LIFO”
  • “Specific”
  • “Average”
  • “Standard”
22Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
24Standard Cost SearchStandard CostNormalDecimal12Standard Costdecimal(38,38)
25Last Direct Cost SearchLast Direct CostNormalDecimal12Last Direct Costdecimal(38,38)
28Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
29Cost is Adjusted SearchCost is AdjustedNormalBoolean4Cost is Adjustedtinyint
30Allow Online Adjustment SearchAllow Online AdjustmentNormalBoolean4Allow Online Adjustmenttinyint
31Vendor No. SearchVendor No.NormalCode20Vendor 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_]
32Vendor Item No. SearchVendor Item No.NormalText50Vendor Item No_nvarchar(100)
33Lead Time Calculation SearchLead Time CalculationNormalDateFormula32Lead Time Calculationvarchar(32)
34Reorder Point SearchReorder PointNormalDecimal12Reorder Pointdecimal(38,38)
35Maximum Inventory SearchMaximum InventoryNormalDecimal12Maximum Inventorydecimal(38,38)
36Reorder Quantity SearchReorder QuantityNormalDecimal12Reorder Quantitydecimal(38,38)
37Alternative Item No. SearchAlternative Item No.NormalCode20Alternative Item No_nvarchar(40)
38Unit List Price SearchUnit List PriceNormalDecimal12Unit List Pricedecimal(38,38)
39Duty Due % SearchDuty Due %NormalDecimal12Duty Due _decimal(38,38)
40Duty Code SearchDuty CodeNormalCode10Duty Codenvarchar(20)
41Gross Weight SearchGross WeightNormalDecimal12Gross Weightdecimal(38,38)
42Net Weight SearchNet WeightNormalDecimal12Net Weightdecimal(38,38)
43Units per Parcel SearchUnits per ParcelNormalDecimal12Units per Parceldecimal(38,38)
44Unit Volume SearchUnit VolumeNormalDecimal12Unit Volumedecimal(38,38)
45Durability SearchDurabilityNormalCode10Durabilitynvarchar(20)
46Freight Type SearchFreight TypeNormalCode10Freight Typenvarchar(20)
47Tariff No. SearchTariff No.NormalCode20Tariff 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_]
48Duty Unit Conversion SearchDuty Unit ConversionNormalDecimal12Duty Unit Conversiondecimal(38,38)
49Country/Region Purchased Code SearchCountry/Region Purchased CodeNormalCode10Country_Region Purchased Codenvarchar(20)
50Budget Quantity SearchBudget QuantityNormalDecimal12Budget Quantitydecimal(38,38)
51Budgeted Amount SearchBudgeted AmountNormalDecimal12Budgeted Amountdecimal(38,38)
52Budget Profit SearchBudget ProfitNormalDecimal12Budget Profitdecimal(38,38)
53Comment SearchCommentFlowFieldBoolean4
54Blocked SearchBlockedNormalBoolean4Blockedtinyint
55Cost is Posted to G/L SearchCost is Posted to G/LFlowFieldBoolean4
56Block Reason SearchBlock ReasonNormalText250Block Reasonnvarchar(500)
61Last DateTime Modified SearchLast DateTime ModifiedNormalDateTime8Last DateTime Modifieddatetime
62Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
63Last Time Modified SearchLast Time ModifiedNormalTime4Last Time Modifieddatetime
64Date Filter SearchDate FilterFlowFilterDate4
65Global Dimension 1 Filter SearchGlobal Dimension 1 FilterFlowFilterCode20
66Global Dimension 2 Filter SearchGlobal Dimension 2 FilterFlowFilterCode20
67Location Filter SearchLocation FilterFlowFilterCode10
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]
68Inventory SearchQuantity on HandFlowFieldDecimal12
69Net Invoiced Qty. SearchNet Invoiced Qty.FlowFieldDecimal12
70Net Change SearchNet ChangeFlowFieldDecimal12
71Purchases (Qty.) SearchPurchases (Qty.)FlowFieldDecimal12
72Sales (Qty.) SearchSales (Qty.)FlowFieldDecimal12
73Positive Adjmt. (Qty.) SearchPositive Adjmt. (Qty.)FlowFieldDecimal12
74Negative Adjmt. (Qty.) SearchNegative Adjmt. (Qty.)FlowFieldDecimal12
77Purchases (LCY) SearchPurchases ($)FlowFieldDecimal12
78Sales (LCY) SearchSales ($)FlowFieldDecimal12
79Positive Adjmt. (LCY) SearchPositive Adjmt. ($)FlowFieldDecimal12
80Negative Adjmt. (LCY) SearchNegative Adjmt. ($)FlowFieldDecimal12
83COGS (LCY) SearchCOGS ($)FlowFieldDecimal12
84Qty. on Purch. Order SearchQty. on Purch. OrderFlowFieldDecimal12
85Qty. on Sales Order SearchQty. on Sales OrderFlowFieldDecimal12
87Price Includes VAT SearchPrice Includes TaxNormalBoolean4Price Includes VATtinyint
89Drop Shipment Filter SearchDrop Shipment FilterFlowFilterBoolean4
90VAT Bus. Posting Gr. (Price) SearchTax Bus. Posting Gr. (Price)NormalCode20VAT 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]
91Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(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]
92Picture SearchPictureNormalMediaSet16Pictureuniqueidentifier
93Transferred (Qty.) SearchTransferred (Qty.)FlowFieldDecimal12
94Transferred (LCY) SearchTransferred ($)FlowFieldDecimal12
95Country/Region of Origin Code SearchCountry/Region of Origin CodeNormalCode10Country_Region of Origin Codenvarchar(20)
96Automatic Ext. Texts SearchAutomatic Ext. TextNormalBoolean4Automatic Ext_ Textstinyint
97No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(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]
98Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(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]
99VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(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]
100Reserve SearchReserveNormalOption4Reserveint
Available options are:
  • “Never”
  • “Optional”
  • “Always”
101Reserved Qty. on Inventory SearchReserved Qty. on InventoryFlowFieldDecimal12
102Reserved Qty. on Purch. Orders SearchReserved Qty. on Purch. OrdersFlowFieldDecimal12
103Reserved Qty. on Sales Orders SearchReserved Qty. on Sales OrdersFlowFieldDecimal12
105Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(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]
106Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(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]
107Res. Qty. on Outbound Transfer SearchRes. Qty. on Outbound TransferFlowFieldDecimal12
108Res. Qty. on Inbound Transfer SearchRes. Qty. on Inbound TransferFlowFieldDecimal12
109Res. Qty. on Sales Returns SearchRes. Qty. on Sales ReturnsFlowFieldDecimal12
110Res. Qty. on Purch. Returns SearchRes. Qty. on Purch. ReturnsFlowFieldDecimal12
120Stockout Warning SearchStockout WarningNormalOption4Stockout Warningint
Available options are:
  • “Default”
  • “No”
  • “Yes”
121Prevent Negative Inventory SearchPrevent Negative InventoryNormalOption4Prevent Negative Inventoryint
Available options are:
  • “Default”
  • “No”
  • “Yes”
122Variant Mandatory if Exists SearchVariant Mandatory if ExistsNormalOption4Variant Mandatory if Existsint
Available options are:
  • “Default”
  • “No”
  • “Yes”
200Cost of Open Production Orders SearchCost of Open Production OrdersFlowFieldDecimal12
521Application Wksh. User ID SearchApplication Wksh. User IDNormalCode128Application Wksh_ User IDnvarchar(256)
720Coupled to CRM SearchCoupled to Dynamics 365 SalesNormalBoolean4Coupled to CRMtinyint
721Coupled to Dataverse SearchCoupled to Dynamics 365 SalesFlowFieldBoolean4
910Assembly Policy SearchAssembly PolicyNormalOption4Assembly Policyint
Available options are:
  • “Assemble-to-Stock”
  • “Assemble-to-Order”
929Res. Qty. on Assembly Order SearchRes. Qty. on Assembly OrderFlowFieldDecimal12
930Res. Qty. on Asm. Comp. SearchRes. Qty. on Asm. Comp.FlowFieldDecimal12
977Qty. on Assembly Order SearchQty. on Assembly OrderFlowFieldDecimal12
978Qty. on Asm. Component SearchQty. on Asm. ComponentFlowFieldDecimal12
1001Qty. on Job Order SearchQty. on Job OrderFlowFieldDecimal12
1002Res. Qty. on Job Order SearchRes. Qty. on Job OrderFlowFieldDecimal12
1217GTIN SearchGTINNormalCode14GTINnvarchar(28)
1700Default Deferral Template Code SearchDefault Deferral Template CodeNormalCode10Default Deferral Template Codenvarchar(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]
5400Low-Level Code SearchLow-Level CodeNormalInteger4Low-Level Codeint
5401Lot Size SearchLot SizeNormalDecimal12Lot Sizedecimal(38,38)
5402Serial Nos. SearchSerial Nos.NormalCode20Serial 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]
5403Last Unit Cost Calc. Date SearchLast Unit Cost Calc. DateNormalDate4Last Unit Cost Calc_ Datedatetime
5404Rolled-up Material Cost SearchRolled-up Material CostNormalDecimal12Rolled-up Material Costdecimal(38,38)
5405Rolled-up Capacity Cost SearchRolled-up Capacity CostNormalDecimal12Rolled-up Capacity Costdecimal(38,38)
5407Scrap % SearchScrap %NormalDecimal12Scrap _decimal(38,38)
5409Inventory Value Zero SearchInventory Value ZeroNormalBoolean4Inventory Value Zerotinyint
5410Discrete Order Quantity SearchDiscrete Order QuantityNormalInteger4Discrete Order Quantityint
5411Minimum Order Quantity SearchMinimum Order QuantityNormalDecimal12Minimum Order Quantitydecimal(38,38)
5412Maximum Order Quantity SearchMaximum Order QuantityNormalDecimal12Maximum Order Quantitydecimal(38,38)
5413Safety Stock Quantity SearchSafety Stock QuantityNormalDecimal12Safety Stock Quantitydecimal(38,38)
5414Order Multiple SearchOrder MultipleNormalDecimal12Order Multipledecimal(38,38)
5415Safety Lead Time SearchSafety Lead TimeNormalDateFormula32Safety Lead Timevarchar(32)
5417Flushing Method SearchFlushing MethodNormalOption4Flushing Methodint
Available options are:
  • “Manual”
  • “Forward”
  • “Backward”
  • “Pick + Forward”
  • “Pick + Backward”
5419Replenishment System SearchReplenishment SystemNormalOption4
5420Scheduled Receipt (Qty.) SearchScheduled Receipt (Qty.)FlowFieldDecimal12
5421Scheduled Need (Qty.) SearchScheduled Need (Qty.)FlowFieldDecimal12
5422Rounding Precision SearchRounding PrecisionNormalDecimal12Rounding Precisiondecimal(38,38)
5423Bin Filter SearchBin FilterFlowFilterCode20
5424Variant Filter SearchVariant FilterFlowFilterCode10
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]
5425Sales Unit of Measure SearchSales Unit of MeasureNormalCode10Sales Unit of Measurenvarchar(20)
5426Purch. Unit of Measure SearchPurch. Unit of MeasureNormalCode10Purch_ Unit of Measurenvarchar(20)
5427Unit of Measure Filter SearchUnit of Measure FilterFlowFilterCode10
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]
5428Time Bucket SearchTime BucketNormalDateFormula32Time Bucketvarchar(32)
5429Reserved Qty. on Prod. Order SearchReserved Qty. on Prod. OrderFlowFieldDecimal12
5430Res. Qty. on Prod. Order Comp. SearchRes. Qty. on Prod. Order Comp.FlowFieldDecimal12
5431Res. Qty. on Req. Line SearchRes. Qty. on Req. LineFlowFieldDecimal12
5440Reordering Policy SearchReordering PolicyNormalOption4Reordering Policyint
Available options are:
  • ” “
  • “Fixed Reorder Qty.”
  • “Maximum Qty.”
  • “Order”
  • “Lot-for-Lot”
5441Include Inventory SearchInclude InventoryNormalBoolean4Include Inventorytinyint
5442Manufacturing Policy SearchManufacturing PolicyNormalOption4Manufacturing Policyint
Available options are:
  • “Make-to-Stock”
  • “Make-to-Order”
5443Rescheduling Period SearchRescheduling PeriodNormalDateFormula32Rescheduling Periodvarchar(32)
5444Lot Accumulation Period SearchLot Accumulation PeriodNormalDateFormula32Lot Accumulation Periodvarchar(32)
5445Dampener Period SearchDampener PeriodNormalDateFormula32Dampener Periodvarchar(32)
5446Dampener Quantity SearchDampener QuantityNormalDecimal12Dampener Quantitydecimal(38,38)
5447Overflow Level SearchOverflow LevelNormalDecimal12Overflow Leveldecimal(38,38)
5449Planning Transfer Ship. (Qty). SearchPlanning Transfer Ship. (Qty).FlowFieldDecimal12
5450Planning Worksheet (Qty.) SearchPlanning Worksheet (Qty.)FlowFieldDecimal12
5700Stockkeeping Unit Exists SearchStockkeeping Unit ExistsFlowFieldBoolean4
5701Manufacturer Code SearchManufacturer CodeNormalCode10Manufacturer Codenvarchar(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]
5702Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(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]
5703Created From Nonstock Item SearchCreated From Catalog ItemNormalBoolean4Created From Nonstock Itemtinyint
5704Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
5706Substitutes Exist SearchSubstitutes ExistFlowFieldBoolean4
5707Qty. in Transit SearchQty. in TransitFlowFieldDecimal12
5708Trans. Ord. Receipt (Qty.) SearchTrans. Ord. Receipt (Qty.)FlowFieldDecimal12
5709Trans. Ord. Shipment (Qty.) SearchTrans. Ord. Shipment (Qty.)FlowFieldDecimal12
5711Purchasing Code SearchPurchasing CodeNormalCode10Purchasing Codenvarchar(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]
5776Qty. Assigned to ship SearchQty. Assigned to shipFlowFieldDecimal12
5777Qty. Picked SearchQty. PickedFlowFieldDecimal12
5900Service Item Group SearchService Item GroupNormalCode10Service Item Groupnvarchar(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]
5901Qty. on Service Order SearchQty. on Service OrderFlowFieldDecimal12
5902Res. Qty. on Service Orders SearchRes. Qty. on Service OrdersFlowFieldDecimal12
6500Item Tracking Code SearchItem Tracking CodeNormalCode10Item Tracking Codenvarchar(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]
6501Lot Nos. SearchLot Nos.NormalCode20Lot 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]
6502Expiration Calculation SearchExpiration CalculationNormalDateFormula32Expiration Calculationvarchar(32)
6503Lot No. Filter SearchLot No. FilterFlowFilterCode50
6504Serial No. Filter SearchSerial No. FilterFlowFilterCode50
6515Package No. Filter SearchPackage No. FilterFlowFilterCode50
6650Qty. on Purch. Return SearchQty. on Purch. ReturnFlowFieldDecimal12
6660Qty. on Sales Return SearchQty. on Sales ReturnFlowFieldDecimal12
7171No. of Substitutes SearchNo. of SubstitutesFlowFieldInteger4
7300Warehouse Class Code SearchWarehouse Class CodeNormalCode10Warehouse Class Codenvarchar(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]
7301Special Equipment Code SearchSpecial Equipment CodeNormalCode10Special Equipment Codenvarchar(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]
7302Put-away Template Code SearchPut-away Template CodeNormalCode10Put-away Template Codenvarchar(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]
7307Put-away Unit of Measure Code SearchPut-away Unit of Measure CodeNormalCode10Put-away Unit of Measure Codenvarchar(20)
7380Phys Invt Counting Period Code SearchPhys Invt Counting Period CodeNormalCode10Phys Invt Counting Period Codenvarchar(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]
7381Last Counting Period Update SearchLast Counting Period UpdateNormalDate4Last Counting Period Updatedatetime
7383Last Phys. Invt. Date SearchLast Phys. Invt. DateFlowFieldDate4
7384Use Cross-Docking SearchUse Cross-DockingNormalBoolean4Use Cross-Dockingtinyint
7385Next Counting Start Date SearchNext Counting Start DateNormalDate4Next Counting Start Datedatetime
7386Next Counting End Date SearchNext Counting End DateNormalDate4Next Counting End Datedatetime
7387Unit Group Exists SearchUnit Group ExistsFlowFieldBoolean4
7700Identifier Code SearchIdentifier CodeFlowFieldCode20
8000Id SearchIdNormalGUID16Iduniqueidentifier
8001Unit of Measure Id SearchUnit of Measure IdNormalGUID16Unit of Measure Iduniqueidentifier
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]
8002Tax Group Id SearchTax Group IdNormalGUID16Tax Group Iduniqueidentifier
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]
8003Sales Blocked SearchSales BlockedNormalBoolean4Sales Blockedtinyint
8004Purchasing Blocked SearchPurchasing BlockedNormalBoolean4Purchasing Blockedtinyint
8005Item Category Id SearchItem Category IdNormalGUID16Item Category Iduniqueidentifier
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]
8006Inventory Posting Group Id SearchInventory Posting Group IdNormalGUID16Inventory Posting Group Iduniqueidentifier
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]
8007Gen. Prod. Posting Group Id SearchGen. Prod. Posting Group IdNormalGUID16Gen_ Prod_ Posting Group Iduniqueidentifier
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]
8510Over-Receipt Code SearchOver-Receipt CodeNormalCode20Over-Receipt Codenvarchar(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]
10004Duty Class SearchDuty ClassNormalCode10
10011Consumptions (Qty.) SearchConsumptions (Qty.)FlowFieldDecimal12
10012Outputs (Qty.) SearchOutputs (Qty.)FlowFieldDecimal12
10013Rel. Scheduled Receipt (Qty.) SearchRel. Scheduled Receipt (Qty.)FlowFieldDecimal12
10014Rel. Scheduled Need (Qty.) SearchRel. Scheduled Need (Qty.)FlowFieldDecimal12
21850Has Sales Forecast SearchHas Sales ForecastNormalBoolean4
27000SAT Item Classification SearchSAT Item ClassificationNormalCode10
27024SAT Hazardous Material SearchSAT Hazardous MaterialNormalCode10
27025SAT Packaging Type SearchSAT Packaging TypeNormalCode10
99000750Routing No. SearchRouting No.NormalCode20Routing 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_]
99000751Production BOM No. SearchProduction BOM No.NormalCode20Production 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_]
99000752Single-Level Material Cost SearchSingle-Level Material CostNormalDecimal12Single-Level Material Costdecimal(38,38)
99000753Single-Level Capacity Cost SearchSingle-Level Capacity CostNormalDecimal12Single-Level Capacity Costdecimal(38,38)
99000754Single-Level Subcontrd. Cost SearchSingle-Level Subcontrd. CostNormalDecimal12Single-Level Subcontrd_ Costdecimal(38,38)
99000755Single-Level Cap. Ovhd Cost SearchSingle-Level Cap. Ovhd CostNormalDecimal12Single-Level Cap_ Ovhd Costdecimal(38,38)
99000756Single-Level Mfg. Ovhd Cost SearchSingle-Level Mfg. Ovhd CostNormalDecimal12Single-Level Mfg_ Ovhd Costdecimal(38,38)
99000757Overhead Rate SearchOverhead RateNormalDecimal12Overhead Ratedecimal(38,38)
99000758Rolled-up Subcontracted Cost SearchRolled-up Subcontracted CostNormalDecimal12Rolled-up Subcontracted Costdecimal(38,38)
99000759Rolled-up Mfg. Ovhd Cost SearchRolled-up Mfg. Ovhd CostNormalDecimal12Rolled-up Mfg_ Ovhd Costdecimal(38,38)
99000760Rolled-up Cap. Overhead Cost SearchRolled-up Cap. Overhead CostNormalDecimal12Rolled-up Cap_ Overhead Costdecimal(38,38)
99000761Planning Issues (Qty.) SearchPlanning Issues (Qty.)FlowFieldDecimal12
99000762Planning Receipt (Qty.) SearchPlanning Receipt (Qty.)FlowFieldDecimal12
99000765Planned Order Receipt (Qty.) SearchPlanned Order Receipt (Qty.)FlowFieldDecimal12
99000766FP Order Receipt (Qty.) SearchFP Order Receipt (Qty.)FlowFieldDecimal12
99000767Rel. Order Receipt (Qty.) SearchRel. Order Receipt (Qty.)FlowFieldDecimal12
99000768Planning Release (Qty.) SearchPlanning Release (Qty.)FlowFieldDecimal12
99000769Planned Order Release (Qty.) SearchPlanned Order Release (Qty.)FlowFieldDecimal12
99000770Purch. Req. Receipt (Qty.) SearchPurch. Req. Receipt (Qty.)FlowFieldDecimal12
99000771Purch. Req. Release (Qty.) SearchPurch. Req. Release (Qty.)FlowFieldDecimal12
99000773Order Tracking Policy SearchOrder Tracking PolicyNormalOption4Order Tracking Policyint
Available options are:
  • “None”
  • “Tracking Only”
  • “Tracking & Action Msg.”
99000774Prod. Forecast Quantity (Base) SearchProd. Forecast Quantity (Base)FlowFieldDecimal12
99000775Production Forecast Name SearchProduction Forecast NameFlowFilterCode10
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]
99000776Component Forecast SearchComponent ForecastFlowFilterBoolean4
99000777Qty. on Prod. Order SearchQty. on Prod. OrderFlowFieldDecimal12
99000778Qty. on Component Lines SearchQty. on Component LinesFlowFieldDecimal12
99000875Critical SearchCriticalNormalBoolean4Criticaltinyint
99008500Common Item No. SearchCommon Item No.NormalCode20Common Item No_nvarchar(40)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Item table

Leave a Reply

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