Bin

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

Table Type: Company

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

Table Number: 7354

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Location Code]
   ,[Code]
   ,[Description]
   ,[Zone Code]
   ,[Bin Type Code]
   ,[Warehouse Class Code]
   ,[Block Movement]
   ,[Special Equipment Code]
   ,[Bin Ranking]
   ,[Maximum Cubage]
   ,[Maximum Weight]
   ,[Empty]
   ,[Cross-Dock Bin]
   ,[Dedicated]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Bin$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$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Bin].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Warehouse Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Class]
      ON
         [Bin].[Warehouse Class Code] = [Warehouse Class].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
      ON
         [Bin].[Special Equipment Code] = [Special Equipment].[Code]

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

Show/hide example query

SELECT
       [Bin].[Warehouse Class Code]
       ,[Warehouse Class].[Code]
FROM
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
LEFT JOIN
       [CRONUS UK Ltd_$Warehouse Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Class]
              ON
                     [Bin].[Warehouse Class Code] = [Warehouse Class].[Code]
8Block Movement Searchint
9Special Equipment Code Searchnvarchar(20)
Key to join to the Special Equipment table.

Show/hide example query

SELECT
       [Bin].[Special Equipment Code]
       ,[Special Equipment].[Code]
FROM
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
LEFT JOIN
       [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
              ON
                     [Bin].[Special Equipment Code] = [Special Equipment].[Code]
10Bin Ranking Searchint
11Maximum Cubage Searchdecimal(38,38)
12Maximum Weight Searchdecimal(38,38)
13Empty Searchtinyint
14Cross-Dock Bin Searchtinyint
15Dedicated Searchtinyint
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Bin table

Leave a Reply

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