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
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 Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
---|---|---|---|---|---|---|---|
1 | Location Code | Location Code | Normal | Code | 10 | Location Code | nvarchar(20) |
Key to join to the Location table.Show/hide example querySELECT
[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] | |||||||
2 | Zone Code | Zone Code | Normal | Code | 10 | Zone Code | nvarchar(20) |
3 | Bin Code | Bin Code | Normal | Code | 20 | Bin Code | nvarchar(40) |
Key to join to the Bin table.Show/hide example querySELECT
[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] | |||||||
4 | Item No. | Item No. | Normal | Code | 20 | Item No_ | nvarchar(40) |
Key to join to the Item table.Show/hide example querySELECT
[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_] | |||||||
10 | Bin Type Code | Bin Type Code | Normal | Code | 10 | Bin Type Code | nvarchar(20) |
Key to join to the Bin Type table.Show/hide example querySELECT
[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] | |||||||
11 | Warehouse Class Code | Warehouse Class Code | Normal | Code | 10 | Warehouse Class Code | nvarchar(20) |
Key to join to the Warehouse Class table.Show/hide example querySELECT
[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] | |||||||
12 | Block Movement | Block Movement | Normal | Option | 4 | Block Movement | int |
Available options are:
| |||||||
15 | Min. Qty. | Min. Qty. | Normal | Decimal | 12 | Min_ Qty_ | decimal(38,38) |
16 | Max. Qty. | Max. Qty. | Normal | Decimal | 12 | Max_ Qty_ | decimal(38,38) |
21 | Bin Ranking | Bin Ranking | Normal | Integer | 4 | Bin Ranking | int |
26 | Quantity | Quantity | FlowField | Decimal | 12 | ||
29 | Pick Qty. | Pick Qty. | FlowField | Decimal | 12 | ||
30 | Neg. Adjmt. Qty. | Neg. Adjmt. Qty. | FlowField | Decimal | 12 | ||
31 | Put-away Qty. | Put-away Qty. | FlowField | Decimal | 12 | ||
32 | Pos. Adjmt. Qty. | Pos. Adjmt. Qty. | FlowField | Decimal | 12 | ||
37 | Fixed | Fixed | Normal | Boolean | 4 | Fixed | tinyint |
40 | Cross-Dock Bin | Cross-Dock Bin | Normal | Boolean | 4 | Cross-Dock Bin | tinyint |
41 | Default | Default | Normal | Boolean | 4 | Default | tinyint |
50 | Quantity (Base) | Quantity (Base) | FlowField | Decimal | 12 | ||
51 | Pick Quantity (Base) | Pick Quantity (Base) | FlowField | Decimal | 12 | ||
52 | Negative Adjmt. Qty. (Base) | Negative Adjmt. Qty. (Base) | FlowField | Decimal | 12 | ||
53 | Put-away Quantity (Base) | Put-away Quantity (Base) | FlowField | Decimal | 12 | ||
54 | Positive Adjmt. Qty. (Base) | Positive Adjmt. Qty. (Base) | FlowField | Decimal | 12 | ||
55 | ATO Components Pick Qty. | ATO Components Pick Qty. | FlowField | Decimal | 12 | ||
56 | ATO Components Pick Qty (Base) | ATO Components Pick Qty (Base) | FlowField | Decimal | 12 | ||
5402 | Variant Code | Variant Code | Normal | Code | 10 | Variant Code | nvarchar(20) |
Key to join to the Item Variant table.Show/hide example querySELECT
[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] | |||||||
5404 | Qty. per Unit of Measure | Qty. per Unit of Measure | Normal | Decimal | 12 | Qty_ per Unit of Measure | decimal(38,38) |
5407 | Unit of Measure Code | Unit of Measure Code | Normal | Code | 10 | Unit of Measure Code | nvarchar(20) |
6500 | Lot No. Filter | Lot No. Filter | FlowFilter | Code | 50 | ||
6501 | Serial No. Filter | Serial No. Filter | FlowFilter | Code | 50 | ||
6502 | Dedicated | Dedicated | Normal | Boolean | 4 | Dedicated | tinyint |
6503 | Unit of Measure Filter | Unit of Measure Filter | FlowFilter | Code | 10 | ||
6515 | Package No. Filter | Package No. Filter | FlowFilter | Code | 50 | ||
2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[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] | |||||||
2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[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] |