Table 5768 "Whse. Cross-Dock Opportunity"
Base Application · Microsoft.Warehouse.CrossDock
Across versions
- BC23present
- BC24declaration changed
- BC25unchanged
- BC261 events added
- BC27unchanged
- BC2822 fields changed
- BC29-30unchanged
Neighbourhood 9 connected objects and pages
Base Application · Microsoft.Warehouse.CrossDock · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Whse. Cross-Dock Opportunity |
| 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 | Source Template Name | Code[10] | — | not editable |
| 2 | Source Name/No. | Code[20] | — | not editable |
| 3 | Source Line No. | Integer | — | not editable |
| 4 | Line No. | Integer | — | not editable |
| 5 | From Source Type | Integer | — | not editable |
| 6 | From Source Subtype | Option | — | OptionCaption: 0,1,2,3,4,5,6,7,8,9,10; not editable |
| 7 | From Source No. | Code[20] | — | not editable |
| 8 | From Source Line No. | Integer | — | not editable |
| 9 | From Source Subline No. | Integer | — | not editable |
| 10 | From Source Document | Option | — | OptionCaption: ,Sales Order,Sales Return Order,Purchase Order,Purchase Return Order,Inbound Transfer,Outbound Transfer,Prod. Consumption,Prod. Output,Item Ledger Entry,,,,,,,,,,,Assembly Consumption,Assembly Order; not editable |
| 11 | To Source Type | Integer | — | not editable |
| 12 | To Source Subtype | Option | — | OptionCaption: 0,1,2,3,4,5,6,7,8,9,10; not editable |
| 13 | To Source No. Δ BC28 | Code[20] | Specifies the number of the source document for which items can be cross-docked. | not editable |
| 14 | To Source Line No. | Integer | — | not editable |
| 15 | To Source Subline No. | Integer | — | not editable |
| 16 | To Source Document Δ BC28 | Option | Specifies the type of source document for which the cross-dock opportunity can be used, such as sales order. | OptionCaption: ,Sales Order,,,,,,,Purchase Return Order,,Outbound Transfer,Prod. Order Comp.,,,,,,,Service Order,,Assembly Consumption,Assembly Order |
| 17 | Item No. Δ BC28 | Code[20] | Specifies the item number of the items that can be cross-docked. | TableRelation Table 27 “Item”; not editable |
| 18 | Variant Code Δ 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.”))); not editable |
| 19 | Unit of Measure Code Δ 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.”))); not editable |
| 20 | Qty. per Unit of Measure Δ BC28 | Decimal | Specifies the number of base units of measure in which the item has been received. | not editable |
| 21 | Location Code Δ BC28 | Code[10] | Specifies the code of the location on the warehouse receipt line related to this cross-dock opportunity. | TableRelation Table 14 “Location”; not editable |
| 24 | Qty. Needed Δ BC28 | Decimal | Specifies the quantity that is still needed on the document for which the items can be cross-docked. | not editable |
| 25 | Qty. Needed (Base) Δ BC28 | Decimal | Specifies the quantity that is needed to complete the outbound source document line, in the base unit of measure. via Page 5783 “Cross-Dock Opportunities” | not editable |
| 26 | Qty. to Cross-Dock Δ BC28 | Decimal | Specifies the quantity that is ready to cross-dock. | |
| 27 | Qty. to Cross-Dock (Base) Δ BC28 | Decimal | Specifies the quantity, in the base units of measure, that is ready to cross-dock. via Page 5783 “Cross-Dock Opportunities” | |
| 28 | Qty. Cross-Docked (Base) Δ BC28 | Decimal | Specifies the quantity, in the base units of measure, that have been cross-docked. via Page 5783 “Cross-Dock Opportunities” | FlowField: sum(“Whse. Cross-Dock Opportunity”.“Qty. to Cross-Dock (Base)” where(“Source Template Name” = field(“Source Template Name”), “Source Name/No.” = field(“Source Name/No.”), “Source Line No.” = field(“Source Line No.”), “Location Code” = field(“Location Code”))); not editable |
| 29 | Total Qty. Needed (Base) Δ BC28 | Decimal | — | FlowField: sum(“Whse. Cross-Dock Opportunity”.“Qty. Needed (Base)” where(“Source Template Name” = field(“Source Template Name”), “Source Name/No.” = field(“Source Name/No.”), “Source Line No.” = field(“Source Line No.”), “Location Code” = field(“Location Code”))) |
| 36 | Reserved Quantity Δ BC28 | Decimal | Specifies the number of units of the item on the line reserved for the source document line. | FlowField: - sum(“Reservation Entry”.Quantity where(“Source ID” = field(“To Source No.”), “Source Ref. No.” = field(“To Source Line No.”), “Source Type” = field(“To Source Type”), “Source Subtype” = field(“To Source Subtype”), “Source Prod. Order Line” = field(“To Source Subline No.”), “Reservation Status” = c…; not editable |
| 37 | Reserved Qty. (Base) Δ BC28 | Decimal | Specifies the number of units of the item on the line reserved for the related source document line. via Page 5783 “Cross-Dock Opportunities” | FlowField: - sum(“Reservation Entry”.Quantity where(“Source ID” = field(“To Source No.”), “Source Ref. No.” = field(“To Source Line No.”), “Source Type” = field(“To Source Type”), “Source Subtype” = field(“To Source Subtype”), “Source Prod. Order Line” = field(“To Source Subline No.”), “Reservation Status” = c…; not editable |
| 39 | To-Src. Unit of Measure Code Δ BC28 | Code[10] | Specifies the unit of measure code on the source document line that needs the cross-dock opportunity item. | TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))); not editable |
| 40 | To-Src. Qty. per Unit of Meas. Δ BC28 | Decimal | Specifies the quantity of base units of measure, on the source document line, that needs the cross-dock opportunity items. | not editable |
| 41 | Due Date Δ BC28 | Date | Specifies the date when the outbound warehouse activity should be started. | not editable |
| 42 | Pick Qty. Δ BC28 | Decimal | Specifies the quantity of the item that is on pick instructions for the outbound source document, but that has not yet been registered as picked. | not editable |
| 43 | Pick Qty. (Base) Δ BC28 | Decimal | Specifies the quantity of the item that is on pick instructions for the outbound source document, but that has not yet been registered as picked. via Page 5783 “Cross-Dock Opportunities” | not editable |
| 44 | Picked Qty. Δ BC28 | Decimal | — | not editable |
| 45 | Picked Qty. (Base) Δ BC28 | Decimal | — | not editable |
Keys
- Key1: Source Template Name, Source Name/No., Source Line No., Line No. (clustered)
- Key2: Item No., Location Code
- Key3: From Source Type, From Source Subtype, From Source No., From Source Line No., From Source Subline No.
- Key4: To Source Type, To Source Subtype, To Source No., To Source Line No., To Source Subline No.
- Key5: Due Date
Events published
OnBeforeCalcQtyToHandleBase(TemplateName: Code[10]; NameNo: Code[20]; LineNo: Integer; var QtyToHandleBase: Decimal; var IsHandled: Boolean)(integration)OnBeforeShowCrossDockQtyExceedsCrossDockQtyError(var WhseCrossDockOpportunity: Record "Whse. Cross-Dock Opportunity"; var ErrorMessage: Text)(integration)OnShowReservation(var WhseCrossDockOpportunity: Record "Whse. Cross-Dock Opportunity")+ BC26 (integration)- subscribers: Codeunit 5996 “Prod. Order Warehouse Mgt.” OnShowReservation, Codeunit 5997 “Assembly Warehouse Mgt.” OnShowReservation
Procedures
AutoFillQtyToCrossDock(var Rec: Record "Whse. Cross-Dock Opportunity")ShowReservation()
Plus 4 local procedures.
Relations
- drill-down page Page 5783 “Cross-Dock Opportunities”
- lookup page Page 5783 “Cross-Dock Opportunities”
- Location Code: TableRelation Table 14 “Location”
- Item No.: TableRelation Table 27 “Item”
- Reserved Qty. (Base): CalcFormula Table 337 “Reservation Entry”
- Reserved Quantity: CalcFormula Table 337 “Reservation Entry”
- Variant Code: TableRelation Table 5401 “Item Variant”
- To-Src. Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
- Qty. Cross-Docked (Base): CalcFormula Table 5768 “Whse. Cross-Dock Opportunity”
- Total Qty. Needed (Base): CalcFormula Table 5768 “Whse. Cross-Dock Opportunity”
Referenced by
2 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 5768 “Whse. Cross-Dock Opportunity”: Qty. Cross-Docked (Base), Total Qty. Needed (Base)
Pages and codeunits on this table
- Page 5783 “Cross-Dock Opportunities” (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 5402 “Unit of Measure Management” (2 calls:
CalcBaseQty → QtyRndPrecision,CalcQty → QtyRndPrecision)
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: "Whse. Cross-Dock Opportunity"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.