Stockkeeping Unit

Dynamics 365 BC Table ReferenceTablesCompany TablesSStockkeeping Unit

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

Table Type: Company

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

Table Number: 5700

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Item No_]
   ,[Variant Code]
   ,[Location Code]
   ,[Shelf No_]
   ,[Unit Cost]
   ,[Standard Cost]
   ,[Last Direct Cost]
   ,[Vendor No_]
   ,[Vendor Item No_]
   ,[Lead Time Calculation]
   ,[Reorder Point]
   ,[Maximum Inventory]
   ,[Reorder Quantity]
   ,[Last Date Modified]
   ,[Assembly Policy]
   ,[Transfer-Level Code]
   ,[Lot Size]
   ,[Discrete Order Quantity]
   ,[Minimum Order Quantity]
   ,[Maximum Order Quantity]
   ,[Safety Stock Quantity]
   ,[Order Multiple]
   ,[Safety Lead Time]
   ,[Components at Location]
   ,[Flushing Method]
   ,[Time Bucket]
   ,[Reordering Policy]
   ,[Include Inventory]
   ,[Manufacturing Policy]
   ,[Rescheduling Period]
   ,[Lot Accumulation Period]
   ,[Dampener Period]
   ,[Dampener Quantity]
   ,[Overflow Level]
   ,[Transfer-from 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]
   ,[Routing No_]
   ,[Production BOM No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Stockkeeping Unit].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Stockkeeping Unit].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Stockkeeping Unit].[Components at Location] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Stockkeeping Unit].[Transfer-from Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
      ON
         [Stockkeeping Unit].[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
         [Stockkeeping Unit].[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
         [Stockkeeping Unit].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Stockkeeping Unit].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Stockkeeping Unit].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Stockkeeping Unit table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Item No. Primary Key SearchItem No.NormalCode20Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Stockkeeping Unit].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Stockkeeping Unit].[Item No_] = [Item].[No_]
2Variant Code Primary Key SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Stockkeeping Unit].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Stockkeeping Unit].[Variant Code] = [Item Variant].[Code]
3Location Code Primary Key SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Stockkeeping Unit].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Stockkeeping Unit].[Location Code] = [Location].[Code]
4Description SearchDescriptionFlowFieldText100
5Description 2 SearchDescription 2FlowFieldText50
6Assembly BOM SearchAssembly BOMFlowFieldBoolean4
12Shelf No. SearchShelf No.NormalCode10Shelf No_nvarchar(20)
22Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
24Standard Cost SearchStandard CostNormalDecimal12Standard Costdecimal(38,38)
25Last Direct Cost SearchLast Direct CostNormalDecimal12Last Direct Costdecimal(38,38)
31Vendor No. SearchVendor No.NormalCode20Vendor No_nvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Stockkeeping Unit].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Stockkeeping Unit].[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)
53Comment SearchCommentFlowFieldBoolean4
62Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
64Date Filter SearchDate FilterFlowFilterDate4
65Global Dimension 1 Filter SearchGlobal Dimension 1 FilterFlowFilterCode20
66Global Dimension 2 Filter SearchGlobal Dimension 2 FilterFlowFilterCode20
68Inventory SearchQuantity on HandFlowFieldDecimal12
84Qty. on Purch. Order SearchQty. on Purch. OrderFlowFieldDecimal12
85Qty. on Sales Order SearchQty. on Sales OrderFlowFieldDecimal12
89Drop Shipment Filter SearchDrop Shipment FilterFlowFilterBoolean4
910Assembly Policy SearchAssembly PolicyNormalOption4Assembly Policyint
Available options are:
  • “Assemble-to-Stock”
  • “Assemble-to-Order”
977Qty. on Assembly Order SearchQty. on Assembly OrderFlowFieldDecimal12
978Qty. on Asm. Component SearchQty. on Asm. ComponentFlowFieldDecimal12
1001Qty. on Job Order SearchQty. on Job OrderFlowFieldDecimal12
5400Transfer-Level Code SearchTransfer-Level CodeNormalInteger4Transfer-Level Codeint
5401Lot Size SearchLot SizeNormalDecimal12Lot Sizedecimal(38,38)
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)
5416Components at Location SearchComponents at LocationNormalCode10Components at Locationnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Stockkeeping Unit].[Components at Location]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Stockkeeping Unit].[Components at Location] = [Location].[Code]
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
5423Bin Filter SearchBin FilterFlowFilterCode20
5428Time Bucket SearchTime BucketNormalDateFormula32Time Bucketvarchar(32)
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)
5700Transfer-from Code SearchTransfer-from CodeNormalCode10Transfer-from Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Stockkeeping Unit].[Transfer-from Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Stockkeeping Unit].[Transfer-from Code] = [Location].[Code]
5701Qty. in Transit SearchQty. in TransitFlowFieldDecimal12
5702Trans. Ord. Receipt (Qty.) SearchTrans. Ord. Receipt (Qty.)FlowFieldDecimal12
5703Trans. Ord. Shipment (Qty.) SearchTrans. Ord. Shipment (Qty.)FlowFieldDecimal12
5901Qty. on Service Order SearchQty. on Service OrderFlowFieldDecimal12
7301Special Equipment Code SearchSpecial Equipment CodeNormalCode10Special Equipment Codenvarchar(20)
Key to join to the Special Equipment table.

Show/hide example query

SELECT
       [Stockkeeping Unit].[Special Equipment Code]
       ,[Special Equipment].[Code]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
              ON
                     [Stockkeeping Unit].[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
       [Stockkeeping Unit].[Put-away Template Code]
       ,[Put-away Template Header].[Code]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [CRONUS UK Ltd_$Put-away Template Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Put-away Template Header]
              ON
                     [Stockkeeping Unit].[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
       [Stockkeeping Unit].[Phys Invt Counting Period Code]
       ,[Phys. Invt. Counting Period].[Code]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
              ON
                     [Stockkeeping Unit].[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
99000750Routing No. SearchRouting No.NormalCode20Routing No_nvarchar(40)
Key to join to the Routing Header table.

Show/hide example query

SELECT
       [Stockkeeping Unit].[Routing No_]
       ,[Routing Header].[No_]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [CRONUS UK Ltd_$Routing Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Header]
              ON
                     [Stockkeeping Unit].[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
       [Stockkeeping Unit].[Production BOM No_]
       ,[Production BOM Header].[No_]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Header]
              ON
                     [Stockkeeping Unit].[Production BOM No_] = [Production BOM Header].[No_]
Part of multi-key to join to the Production BOM Line table.

Show/hide example query

SELECT
       [Stockkeeping Unit].[Production BOM No_]
       ,[Production BOM Line].[Production BOM No_]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
              ON
                     [Stockkeeping Unit].[Production BOM No_] = [Production BOM Line].[Production BOM No_]
              AND
                     [Stockkeeping Unit].[BOM Line No_] = [Production BOM Line].[Line No_]
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
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
99000777Qty. on Prod. Order SearchQty. on Prod. OrderFlowFieldDecimal12
99000778Qty. on Component Lines SearchQty. on Component LinesFlowFieldDecimal12
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
       [Stockkeeping Unit].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [User] AS [User]
              ON
                     [Stockkeeping Unit].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Stockkeeping Unit].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [User] AS [User]
              ON
                     [Stockkeeping Unit].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Stockkeeping Unit table

LocationPut-away Template HeaderSpecial EquipmentUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesSStockkeeping Unit

Leave a Reply

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