Stockkeeping 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
   [timestamp]
   ,[Location Code]
   ,[Item No_]
   ,[Variant 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]
   ,[Replenishment System]
   ,[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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Stockkeeping Unit].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Stockkeeping Unit].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Stockkeeping Unit].[Vendor No_] = [Vendor].[No_]
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_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Stockkeeping Unit].[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
         [Stockkeeping Unit].[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
         [Stockkeeping Unit].[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
         [Stockkeeping Unit].[Production BOM No_] = [Production BOM Line].[Production BOM No_]

Show/hide columns in Stockkeeping Unit table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Location Code Primary Key Searchnvarchar(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]
3Item No_ Primary Key Searchnvarchar(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$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Stockkeeping Unit].[Item No_] = [Item].[No_]
4Variant Code Primary Key Searchnvarchar(20)
5Shelf No_ Searchnvarchar(20)
6Unit Cost Searchdecimal(38,38)
7Standard Cost Searchdecimal(38,38)
8Last Direct Cost Searchdecimal(38,38)
9Vendor No_ Searchnvarchar(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_]
10Vendor Item No_ Searchnvarchar(100)
11Lead Time Calculation Searchvarchar(32)
12Reorder Point Searchdecimal(38,38)
13Maximum Inventory Searchdecimal(38,38)
14Reorder Quantity Searchdecimal(38,38)
15Last Date Modified Searchdatetime
16Assembly Policy Searchint
17Transfer-Level Code Searchint
18Lot Size Searchdecimal(38,38)
19Discrete Order Quantity Searchint
20Minimum Order Quantity Searchdecimal(38,38)
21Maximum Order Quantity Searchdecimal(38,38)
22Safety Stock Quantity Searchdecimal(38,38)
23Order Multiple Searchdecimal(38,38)
24Safety Lead Time Searchvarchar(32)
25Components at Location Searchnvarchar(20)
26Flushing Method Searchint
27Replenishment System Searchint
28Time Bucket Searchvarchar(32)
29Reordering Policy Searchint
30Include Inventory Searchtinyint
31Manufacturing Policy Searchint
32Rescheduling Period Searchvarchar(32)
33Lot Accumulation Period Searchvarchar(32)
34Dampener Period Searchvarchar(32)
35Dampener Quantity Searchdecimal(38,38)
36Overflow Level Searchdecimal(38,38)
37Transfer-from Code Searchnvarchar(20)
38Special Equipment Code Searchnvarchar(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]
39Put-away Template Code Searchnvarchar(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]
40Put-away Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Stockkeeping Unit].[Put-away Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Stockkeeping Unit$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Stockkeeping Unit]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Stockkeeping Unit].[Put-away Unit of Measure Code] = [Unit of Measure].[Code]
41Phys Invt Counting Period Code Searchnvarchar(20)
42Last Counting Period Update Searchdatetime
43Use Cross-Docking Searchtinyint
44Next Counting Start Date Searchdatetime
45Next Counting End Date Searchdatetime
46Routing No_ Searchnvarchar(40)
47Production BOM No_ Searchnvarchar(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_]
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_]
48$systemId Searchuniqueidentifier
49$systemCreatedAt Searchdatetime
50$systemCreatedBy Searchuniqueidentifier
51$systemModifiedAt Searchdatetime
52$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Stockkeeping Unit table

Leave a Reply

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