Bin Content

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

Table Type: Company

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

Table Number: 7302

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 Bin Content can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Bin Content$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Location Code]
   ,[Bin Code]
   ,[Item No_]
   ,[Variant Code]
   ,[Unit of Measure Code]
   ,[Zone Code]
   ,[Bin Type Code]
   ,[Warehouse Class Code]
   ,[Block Movement]
   ,[Min_ Qty_]
   ,[Max_ Qty_]
   ,[Bin Ranking]
   ,[Fixed]
   ,[Cross-Dock Bin]
   ,[Default]
   ,[Qty_ per Unit of Measure]
   ,[Dedicated]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Bin Content$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Bin Content$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Content]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Bin Content].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
      ON
         [Bin Content].[Item No_] = [Item].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Bin Content].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Warehouse Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Class]
      ON
         [Bin Content].[Warehouse Class Code] = [Warehouse Class].[Code]

Show/hide columns in Bin Content 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
       [Bin Content].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Bin Content$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Content]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Bin Content].[Location Code] = [Location].[Code]
3Bin Code Primary Key Searchnvarchar(40)
4Item No_ Primary Key Searchnvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Bin Content].[Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Bin Content$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Content]
LEFT JOIN
       [CRONUS UK Ltd_$Item$c526b3e9-b8ca-4683-81ba-fcd5f6b1472a] AS [Item]
              ON
                     [Bin Content].[Item No_] = [Item].[No_]
5Variant Code Primary Key Searchnvarchar(20)
6Unit of Measure Code Primary Key Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Bin Content].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Bin Content$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Content]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Bin Content].[Unit of Measure Code] = [Unit of Measure].[Code]
7Zone Code Searchnvarchar(20)
8Bin Type Code Searchnvarchar(20)
9Warehouse Class Code Searchnvarchar(20)
Key to join to the Warehouse Class table.

Show/hide example query

SELECT
       [Bin Content].[Warehouse Class Code]
       ,[Warehouse Class].[Code]
FROM
       [CRONUS UK Ltd_$Bin Content$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Content]
LEFT JOIN
       [CRONUS UK Ltd_$Warehouse Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Class]
              ON
                     [Bin Content].[Warehouse Class Code] = [Warehouse Class].[Code]
10Block Movement Searchint
11Min_ Qty_ Searchdecimal(38,38)
12Max_ Qty_ Searchdecimal(38,38)
13Bin Ranking Searchint
14Fixed Searchtinyint
15Cross-Dock Bin Searchtinyint
16Default Searchtinyint
17Qty_ per Unit of Measure Searchdecimal(38,38)
18Dedicated Searchtinyint
19$systemId Searchuniqueidentifier
20$systemCreatedAt Searchdatetime
21$systemCreatedBy Searchuniqueidentifier
22$systemModifiedAt Searchdatetime
23$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Bin Content table

Leave a Reply

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