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
   [Location Code]
   ,[Zone Code]
   ,[Bin Code]
   ,[Item No_]
   ,[Bin Type Code]
   ,[Warehouse Class Code]
   ,[Block Movement]
   ,[Min_ Qty_]
   ,[Max_ Qty_]
   ,[Bin Ranking]
   ,[Fixed]
   ,[Cross-Dock Bin]
   ,[Default]
   ,[Variant Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[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_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Bin Content].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Type]
      ON
         [Bin Content].[Bin Type Code] = [Bin Type].[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]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Bin Content].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Bin Content].[Unit of Measure Filter] = [Unit of Measure].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Bin Content].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Bin Content].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Bin Content table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Location Code Primary Key SearchLocation CodeNormalCode10Location Codenvarchar(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]
2Zone Code SearchZone CodeNormalCode10Zone Codenvarchar(20)
3Bin Code Primary Key SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Bin Content].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Bin Content$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Content]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Bin Content].[Bin Code] = [Bin].[Code]
4Item No. Primary Key SearchItem No.NormalCode20Item No_nvarchar(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$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Bin Content].[Item No_] = [Item].[No_]
10Bin Type Code SearchBin Type CodeNormalCode10Bin Type Codenvarchar(20)
Key to join to the Bin Type table.

Show/hide example query

SELECT
       [Bin Content].[Bin Type Code]
       ,[Bin Type].[Code]
FROM
       [CRONUS UK Ltd_$Bin Content$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Content]
LEFT JOIN
       [CRONUS UK Ltd_$Bin Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Type]
              ON
                     [Bin Content].[Bin Type Code] = [Bin Type].[Code]
11Warehouse Class Code SearchWarehouse Class CodeNormalCode10Warehouse Class Codenvarchar(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]
12Block Movement SearchBlock MovementNormalOption4Block Movementint
Available options are:
  • ” “
  • “Inbound”
  • “Outbound”
  • “All”
15Min. Qty. SearchMin. Qty.NormalDecimal12Min_ Qty_decimal(38,38)
16Max. Qty. SearchMax. Qty.NormalDecimal12Max_ Qty_decimal(38,38)
21Bin Ranking SearchBin RankingNormalInteger4Bin Rankingint
26Quantity SearchQuantityFlowFieldDecimal12
29Pick Qty. SearchPick Qty.FlowFieldDecimal12
30Neg. Adjmt. Qty. SearchNeg. Adjmt. Qty.FlowFieldDecimal12
31Put-away Qty. SearchPut-away Qty.FlowFieldDecimal12
32Pos. Adjmt. Qty. SearchPos. Adjmt. Qty.FlowFieldDecimal12
37Fixed SearchFixedNormalBoolean4Fixedtinyint
40Cross-Dock Bin SearchCross-Dock BinNormalBoolean4Cross-Dock Bintinyint
41Default SearchDefaultNormalBoolean4Defaulttinyint
50Quantity (Base) SearchQuantity (Base)FlowFieldDecimal12
51Pick Quantity (Base) SearchPick Quantity (Base)FlowFieldDecimal12
52Negative Adjmt. Qty. (Base) SearchNegative Adjmt. Qty. (Base)FlowFieldDecimal12
53Put-away Quantity (Base) SearchPut-away Quantity (Base)FlowFieldDecimal12
54Positive Adjmt. Qty. (Base) SearchPositive Adjmt. Qty. (Base)FlowFieldDecimal12
55ATO Components Pick Qty. SearchATO Components Pick Qty.FlowFieldDecimal12
56ATO Components Pick Qty (Base) SearchATO Components Pick Qty (Base)FlowFieldDecimal12
5402Variant Code Primary Key SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Bin Content].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Bin Content$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Content]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Bin Content].[Variant Code] = [Item Variant].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5407Unit of Measure Code Primary Key SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
6500Lot No. Filter SearchLot No. FilterFlowFilterCode50
6501Serial No. Filter SearchSerial No. FilterFlowFilterCode50
6502Dedicated SearchDedicatedNormalBoolean4Dedicatedtinyint
6503Unit of Measure Filter SearchUnit of Measure FilterFlowFilterCode10
6515Package No. Filter SearchPackage No. FilterFlowFilterCode50
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
       [Bin Content].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Bin Content$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Content]
LEFT JOIN
       [User] AS [User]
              ON
                     [Bin Content].[$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
       [Bin Content].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Bin Content$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin Content]
LEFT JOIN
       [User] AS [User]
              ON
                     [Bin Content].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Bin Content table

Leave a Reply

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