Table 7354 "Bin"
Base Application · Microsoft.Warehouse.Structure
Across versions
- BC23present
- BC244 fields changed
- BC25-27unchanged
- BC2815 fields changed
- BC29-30unchanged
Neighbourhood 103 connected objects and pages
Base Application · Microsoft.Warehouse.Structure · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 7302 “Bins” (2 Learn pages), Page 7303 “Bin List” (1).
Properties
| Property | Value |
|---|---|
| Caption | Bin |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Location Code Δ BC28 | Code[10] | Specifies the location from which you opened the Bins window. | TableRelation Table 14 “Location”; not editable; NotBlank |
| 2 | Code Δ BC28 | Code[20] | Specifies a code that uniquely describes the bin. | NotBlank |
| 3 | Description Δ BC28 | Text[100] | Specifies a description of the bin. | |
| 4 | Zone Code Δ BC24 Δ BC28 | Code[10] | Specifies the code of the zone in which the bin is located. | TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”))); not editable |
| 5 | Adjustment Bin Δ BC24 | Boolean | — | FlowField: exist(Location where(Code = field(“Location Code”), “Adjustment Bin Code” = field(Code))); not editable |
| 10 | Bin Type Code Δ BC28 | Code[10] | Specifies the code of the bin type that applies to the bin. | TableRelation Table 7303 “Bin Type” (Bin Type) |
| 11 | Warehouse Class Code Δ BC28 | Code[10] | Specifies the code of the warehouse class that applies to the bin. | TableRelation Table 7304 “Warehouse Class” (Warehouse Class) |
| 12 | Block Movement Δ BC28 | Option | Specifies how the movement of an item, or bin content, into or out of this bin, is blocked. | OptionCaption: ,Inbound,Outbound,All |
| 20 | Special Equipment Code Δ BC28 | Code[10] | Specifies the code of the equipment needed when working in the bin. | TableRelation Table 7305 “Special Equipment” (Special Equipment) |
| 21 | Bin Ranking Δ BC28 | Integer | Specifies the ranking of the bin. Items in the highest-ranking bins (with the highest number in the field) will be picked first. | |
| 22 | Maximum Cubage Δ BC28 | Decimal | Specifies the maximum cubage (volume) that the bin can hold. | |
| 23 | Maximum Weight Δ BC28 | Decimal | Specifies the maximum weight that this bin can hold. | |
| 30 | Empty Δ BC28 | Boolean | Specifies that the bin Specifies no items. | not editable |
| 32 | Item Filter | Code[20] | — | TableRelation Table 27 “Item”; FlowFilter |
| 33 | Variant Filter Δ BC24 | Code[10] | — | TableRelation Table 5700 “Stockkeeping Unit” (“Stockkeeping Unit”.“Variant Code” where(“Location Code” = field(“Location Code”), “Item No.” = field(“Item Filter”))); FlowFilter |
| 34 | Default Δ BC24 Δ BC28 | Boolean | Specifies if the bin is the default bin for an item. | FlowField: exist(“Bin Content” where(“Location Code” = field(“Location Code”), “Bin Code” = field(Code), “Item No.” = field(“Item Filter”), “Variant Code” = field(“Variant Filter”), Default = const(true))); not editable |
| 40 | Cross-Dock Bin Δ BC28 | Boolean | Specifies if the bin is considered a cross-dock bin. | |
| 41 | Dedicated Δ BC28 | Boolean | Specifies that quantities in the bin are protected from being picked for other demands. |
Keys
- Key1: Location Code, Code (clustered)
- Key2: Bin Type Code
- Key3: Location Code, Warehouse Class Code, Bin Ranking
- Key4: Location Code, Zone Code, Code
- Key5: Code
- Key6: Bin Ranking
Events published
OnAfterCheckEmptyBin(var Bin: Record Bin)(integration)OnAfterCalcCubageAndWeight(Bin: Record Bin; CalledByPosting: Boolean; var Cubage: Decimal; var Weight: Decimal)(integration)OnAfterSetUpNewLine(var Bin: Record Bin)(integration)OnBeforeCheckMaxQtyBinContent(var Bin: Record Bin; CheckWeight: Boolean; var IsHandled: Boolean)(integration)OnBeforeCheckWhseClass(Bin: Record Bin; ItemNo: Code[20]; var ResultValue: Boolean; var IsHandled: Boolean; IgnoreError: Boolean)(integration)OnBeforeOnInsert(var Bin: Record Bin; var IsHandled: Boolean)(integration)OnBeforeOnModify(var Bin: Record Bin; var xBin: Record Bin; var IsHandled: Boolean)(integration)OnBeforeCheckEmptyBin(var Bin: Record Bin; ErrorText: Text[250]; var IsHandled: Boolean)(integration)
Procedures
SetUpNewLine()CalcCubageAndWeight(var Cubage: Decimal; var Weight: Decimal; CalledbyPosting: Boolean)CheckWhseClass(ItemNo: Code[20]; IgnoreError: Boolean): BooleanCheckIncreaseBin(BinCode: Code[20]; ItemNo: Code[20]; Qty: Decimal; DeductCubage: Decimal; DeductWeight: Decimal; PutawayCubage: Decimal; PutawayWeight: Decimal; CalledbyPosting: Boolean; IgnoreError: Boolean): Boolean
Plus 12 local procedures.
Triggers
OnDelete, OnInsert, OnModify
Relations
- lookup page Page 7303 “Bin List”
- Adjustment Bin: CalcFormula Table 14 “Location”
- Location Code: TableRelation Table 14 “Location”
- Item Filter: TableRelation Table 27 “Item”
- Variant Filter: TableRelation Table 5700 “Stockkeeping Unit”
- Zone Code: TableRelation Table 7300 “Zone”
- Default: CalcFormula Table 7302 “Bin Content”
- Bin Type Code: TableRelation Table 7303 “Bin Type”
- Warehouse Class Code: TableRelation Table 7304 “Warehouse Class”
- Special Equipment Code: TableRelation Table 7305 “Special Equipment”
Referenced by
110 fields in 89 objects relate to this table (TableRelation or CalcFormula).
- Table 14 “Location”: Adjustment Bin Code, Asm.-to-Order Shpt. Bin Code, Cross-Dock Bin Code, Default Bin Code, From-Assembly Bin Code, Open Shop Floor Bin Code, Receipt Bin Code, Shipment Bin Code, To-Assembly Bin Code, To-Job Bin Code
- Table 99000754 “Work Center”: From-Production Bin Code, Open Shop Floor Bin Code, To-Production Bin Code
- Table 99000758 “Machine Center”: From-Production Bin Code, Open Shop Floor Bin Code, To-Production Bin Code
- Table 5857 “Direct Trans. Line”: Transfer-from Bin Code, Transfer-To Bin Code
- Table 7311 “Warehouse Journal Line”: Bin Code, To Bin Code
- Table 7316 “Warehouse Receipt Header”: Bin Code, Cross-Dock Bin Code
- Table 7317 “Warehouse Receipt Line”: Bin Code, Cross-Dock Bin Code
- Table 7319 “Posted Whse. Receipt Line”: Bin Code, Cross-Dock Bin Code
- Table 7347 “Internal Movement Line”: From Bin Code, To Bin Code
- Table 83 “Item Journal Line”: Bin Code, New Bin Code
- Table extension 99000761 “Mfg. Location”: From-Production Bin Code, To-Production Bin Code
- Table 1001 “Job Task”: Bin Code
- Table 1003 “Job Planning Line”: Bin Code
- Table 111 “Sales Shipment Line”: Bin Code
- Table 113 “Sales Invoice Line”: Bin Code
- Table 115 “Sales Cr.Memo Line”: Bin Code
- Table 121 “Purch. Rcpt. Line”: Bin Code
- Table 123 “Purch. Inv. Line”: Bin Code
- Table 125 “Purch. Cr. Memo Line”: Bin Code
- Table 167 “Job”: Bin Code
- Table 169 “Job Ledger Entry”: Bin Code
- Table 246 “Requisition Line”: Bin Code
- Table 27 “Item”: Bin Filter
- Table 307 “Inventory Buffer”: Bin Code
- Table 336 “Tracking Specification”: Bin Code
- Table 5108 “Sales Line Archive”: Bin Code
- Table 5110 “Purchase Line Archive”: Bin Code
- Table 5135 “Job Archive”: Bin Code
- Table 5136 “Job Task Archive”: Bin Code
- Table 5137 “Job Planning Line Archive”: Bin Code
- Table 5405 “Production Order”: Bin Code
- Table 5406 “Prod. Order Line”: Bin Code
- Table 5407 “Prod. Order Component”: Bin Code
- Table 5520 “Unplanned Demand”: Bin Code
- Table 5700 “Stockkeeping Unit”: Bin Filter
- Table 5741 “Transfer Line”: Transfer-To Bin Code
- Table 5745 “Transfer Shipment Line”: Transfer-from Bin Code
- Table 5747 “Transfer Receipt Line”: Transfer-To Bin Code
- Table 5767 “Warehouse Activity Line”: Bin Code
- Table 5773 “Registered Whse. Activity Line”: Bin Code
- Table 5850 “Invt. Document Header”: Whse. Adj. Bin Code
- Table 5853 “Invt. Receipt Line”: Bin Code
- Table 5855 “Invt. Shipment Line”: Bin Code
- Table 5875 “Phys. Invt. Order Header”: Bin Code
- Table 5876 “Phys. Invt. Order Line”: Bin Code
- Table 5877 “Phys. Invt. Record Header”: Bin Code
- Table 5878 “Phys. Invt. Record Line”: Bin Code
- Table 5879 “Pstd. Phys. Invt. Order Hdr”: Bin Code
- Table 5880 “Pstd. Phys. Invt. Order Line”: Bin Code
- Table 5881 “Pstd. Phys. Invt. Record Hdr”: Bin Code
- and 39 more objects (39 fields): data/code/relations/29.json
Pages and codeunits on this table
- Page 7302 “Bins” (source table)
- Page 7303 “Bin List” (source table)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 7302 “WMS Management” (2 calls:
CheckIncreaseBin → CheckPutAwayAvailability,CheckMaxQtyBinContent → CalcCubageAndWeight) - Codeunit 8703 “Feature Telemetry” (1 call:
CheckIncreaseBin → LogUsage)
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Bin"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.