Table 7338 "Bin Creation Worksheet Line"
Base Application · Microsoft.Warehouse.Structure
Across versions
- BC23present
- BC247 fields changed
- BC25-27unchanged
- BC2819 fields changed
- BC29-30unchanged
Neighbourhood 20 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 7371 “Bin Content Creation Worksheet” (2 Learn pages), Page 7372 “Bin Creation Worksheet” (1).
Properties
| Property | Value |
|---|---|
| Caption | Bin Creation Worksheet Line |
| 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 | Worksheet Template Name Δ BC24 | Code[10] | — | TableRelation Table 7336 “Bin Creation Wksh. Template” (“Bin Creation Wksh. Template”.Name where(Type = field(Type))) |
| 2 | Name Δ BC24 | Code[10] | — | TableRelation Table 7337 “Bin Creation Wksh. Name” (“Bin Creation Wksh. Name”.Name where(“Worksheet Template Name” = field(“Worksheet Template Name”))) |
| 3 | Line No. | Integer | — | |
| 4 | Type | Option | — | OptionCaption: Bin,Bin Content |
| 5 | Location Code Δ BC24 | Code[10] | — | TableRelation Table 14 “Location” (Location where(“Bin Mandatory” = const(true))); NotBlank |
| 6 | Zone Code Δ BC24 Δ BC28 | Code[10] | Specifies the code of the zone where the bin on the worksheet will be located. | TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”))) |
| 7 | Bin Code Δ BC24 Δ BC28 | Code[20] | Specifies the bin where the items are picked or put away. | TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”))); NotBlank |
| 8 | Item No. Δ BC28 | Code[20] | Specifies the item number for which bin content should be created. | TableRelation Table 27 “Item”; NotBlank |
| 9 | Description Δ BC28 | Text[100] | Specifies the description for the bin that should be created. | |
| 10 | Bin Type Code Δ BC28 | Code[10] | Specifies the bin type or bin content that should be created. | TableRelation Table 7303 “Bin Type” (Bin Type) |
| 11 | Warehouse Class Code Δ BC28 | Code[10] | Specifies the warehouse class of the bin or bin content that should be created. | TableRelation Table 7304 “Warehouse Class” (Warehouse Class) |
| 12 | Block Movement Δ BC28 | Option | Specifies how the movement of a particular item, or bin content, into or out of this bin, is blocked. | OptionCaption: ,Inbound,Outbound,All |
| 15 | Min. Qty. Δ BC28 | Decimal | Specifies the minimum quantity for the bin content that should be created. | |
| 16 | Max. Qty. Δ BC28 | Decimal | Specifies the maximum quantity for the bin content that should be created. | |
| 20 | Special Equipment Code Δ BC28 | Code[10] | Specifies the special equipment code of the bin or bin content that should be created. | TableRelation Table 7305 “Special Equipment” (Special Equipment) |
| 21 | Bin Ranking Δ BC28 | Integer | Specifies the ranking of the bin or bin content that should be created. | |
| 22 | Maximum Cubage Δ BC28 | Decimal | Specifies the maximum cubage of the bin that should be created. | |
| 23 | Maximum Weight Δ BC28 | Decimal | Specifies the maximum weight of the bin that should be created. | |
| 37 | Fixed Δ BC28 | Boolean | Specifies whether the bin content that is to be created will be fixed for the item. | |
| 38 | Default Δ BC28 | Boolean | Specifies if the bin is to be the default bin for the item on the bin worksheet line. | |
| 40 | Cross-Dock Bin Δ BC28 | Boolean | Specifies new cross-dock bins. | |
| 67 | User ID | Code[50] | — | TableRelation User.“User Name”; not editable; DataClassification EndUserIdentifiableInformation |
| 5402 | Variant Code Δ BC24 Δ BC28 | Code[10] | Specifies the variant of the item on the line. | TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”))) |
| 5404 | Qty. per Unit of Measure Δ BC28 | Decimal | — | not editable |
| 5407 | Unit of Measure Code Δ BC24 Δ BC28 | Code[10] | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. | TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))); NotBlank |
| 5408 | Dedicated | Boolean | — |
Keys
- Key1: Worksheet Template Name, Name, Location Code, Line No. (clustered)
- Key2: Location Code, Zone Code, Bin Code, Item No., Variant Code
Events published
OnAfterGetUnitOfMeasureDescr(UOMCode: Code[10]; var UOMDescription: Text[50])(integration)OnBeforeBinCreateWkshTemplateSetPageIDFilter(var BinCreateWkshTemplate: Record "Bin Creation Wksh. Template"; var IsHandled: Boolean)(integration)OnBeforeCheckMaxQtyBinContent(var BinCreationWorksheetLine: Record "Bin Creation Worksheet Line"; CheckWeight: Boolean; var IsHandled: Boolean)(integration)OnBeforeCheckName(var WkshName: Code[10]; var LocationCode: Code[10]; var IsHandled: Boolean)(integration)
Procedures
EmptyLine(): BooleanSetUpNewLine(CurrentWkshTemplateName: Code[10])TemplateSelection(PageID: Integer; PageTemplate: Option; var BinCreateWkshLine: Record "Bin Creation Worksheet Line"; var WkshSelected: Boolean)TemplateSelectionFromBatch(var BinCreateWkshName: Record "Bin Creation Wksh. Name")OpenWksh(var CurrentWkshName: Code[10]; var CurrentLocationCode: Code[10]; var BinCreateWkshLine: Record "Bin Creation Worksheet Line")OpenWkshBatch(var BinCreateWkshName: Record "Bin Creation Wksh. Name")CheckName(CurrentWkshName: Code[10]; CurrentLocationCode: Code[10]; var BinCreateWkshLine: Record "Bin Creation Worksheet Line")SetName(CurrentWkshName: Code[10]; CurrentLocationCode: Code[10]; var BinCreateWkshLine: Record "Bin Creation Worksheet Line")LookupBinCreationName(var CurrentWkshName: Code[10]; var CurrentLocationCode: Code[10]; var BinCreateWkshLine: Record "Bin Creation Worksheet Line")GetItemDescr(ItemNo: Code[20]; VariantCode: Code[10]; var ItemDescription: Text[100])GetUnitOfMeasureDescr(UOMCode: Code[10]; var UOMDescription: Text[50])
Plus 8 local procedures.
Triggers
OnInsert, OnModify
Relations
- lookup page Page 7372 “Bin Creation Worksheet”
- Location Code: TableRelation Table 14 “Location”
- Item No.: TableRelation Table 27 “Item”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
- Zone Code: TableRelation Table 7300 “Zone”
- Bin Type Code: TableRelation Table 7303 “Bin Type”
- Warehouse Class Code: TableRelation Table 7304 “Warehouse Class”
- Special Equipment Code: TableRelation Table 7305 “Special Equipment”
- Worksheet Template Name: TableRelation Table 7336 “Bin Creation Wksh. Template”
- Name: TableRelation Table 7337 “Bin Creation Wksh. Name”
- Bin Code: TableRelation Table 7354 “Bin”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 7337 “Bin Creation Wksh. Name”: No. of Lines
Pages and codeunits on this table
- Page 7371 “Bin Content Creation Worksheet” (source table)
- Page 7372 “Bin Creation Worksheet” (source table)
- Codeunit 7318 “Bin Create” (codeunit runs on it)
- Codeunit 7319 “Bin Content Create” (codeunit runs on it)
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” (3 calls:
CheckMaxQtyBinContent → CalcCubageAndWeight,CheckTemplateName → GetWMSLocation,OpenWksh → CheckUserIsWhseEmployee) - Page 7373 “Bin Creation Wksh. Name List” (1 call:
LookupBinCreationName → (object))
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 Creation Worksheet Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.