Table 5773 "Registered Whse. Activity Line"

Base Application · Microsoft.Warehouse.Activity.History · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Registered Whse. Activity 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	Activity Type Δ BC28	Enum “Warehouse Activity Type”	Specifies the type of activity that the warehouse performed on the line, such as put-away, pick, or movement.	enum Enum 5767 “Warehouse Activity Type”
2	No. Δ BC28	Code[20]	Specifies the number of the involved entry or record, according to the specified number series.
3	Line No. Δ BC28	Integer	Specifies the number of the registered warehouse activity line.
4	Source Type Δ BC28	Integer	Specifies the type of transaction the source document is associated with, such as sales, purchase, and production.
5	Source Subtype Δ BC28	Option	Specifies the source subtype of the document related to the registered activity line.	OptionCaption: 0,1,2,3,4,5,6,7,8,9,10
6	Source No. Δ BC28	Code[20]	Specifies the number of the source document that the entry originates from.
7	Source Line No. Δ BC28	Integer	Specifies the line number of the source document that the entry originates from.
8	Source Subline No. Δ BC28	Integer	Specifies the number of the source document subline related to this activity line.
9	Source Document Δ BC28	Enum “Warehouse Activity Source Document”	Specifies the type of document that the line relates to.	enum Enum 5768 “Warehouse Activity Source Document”
11	Location Code Δ BC28	Code[10]	Specifies the code for the location at which the activity occurs.	TableRelation Table 14 “Location”
12	Shelf No. Δ BC28	Code[10]	Specifies the shelf number of the item on the line for information use.
13	Sorting Sequence No.	Integer	—
14	Item No. Δ BC28	Code[20]	Specifies the item number of the item to be handled, such as picked or put away.	TableRelation Table 27 “Item”
15	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.”)))
16	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.”)))
17	Qty. per Unit of Measure Δ BC28	Decimal	Specifies the quantity per unit of measure of the item on the line.
18	Description Δ BC28	Text[100]	Specifies a description of the item on the line.
19	Description 2 Δ BC28	Text[50]	Specifies a description of the item on the line.
20	Quantity Δ BC28	Decimal	Specifies the quantity of the item that was put-away, picked or moved.
21	Qty. (Base) Δ BC28	Decimal	Specifies the quantity of the item that was put-away, picked or moved. via Page 7364 “Registered Whse. Act.-Lines”
31	Shipping Advice Δ BC28	Enum “Sales Header Shipping Advice”	Specifies the shipping advice about whether a partial delivery was acceptable to the order recipient.	enum Enum 3657 “Sales Header Shipping Advice”
34	Due Date Δ BC28	Date	Specifies the date when the warehouse activity must be completed.
39	Destination Type	enum “Warehouse Destination Type”	—	enum Enum 7310 “Warehouse Destination Type”
40	Destination No. Δ BC26	Code[20]	—	TableRelation Table 14 “Location”, Table 18 “Customer”, Table 23 “Vendor” (if (“Destination Type” = const(Vendor)) Vendor else if (“Destination Type” = const(Customer)) Customer else if (“Destination Type” = const(Location)) Location else if (“Destination Type” = const(Item)) Item else if (“Destination Type” = const(“Sales Order”)) “Sales Header”.“No.” where(“Document Type…)
41	Whse. Activity No.	Code[20]	—
42	Shipping Agent Code	Code[10]	—	TableRelation Table 291 “Shipping Agent” (Shipping Agent)
43	Shipping Agent Service Code	Code[10]	—	TableRelation Table 5790 “Shipping Agent Services” (“Shipping Agent Services”.Code where(“Shipping Agent Code” = field(“Shipping Agent Code”)))
44	Shipment Method Code	Code[10]	—	TableRelation Table 10 “Shipment Method” (Shipment Method)
47	Starting Date	Date	—
6500	Serial No. Δ BC28	Code[50]	Specifies the serial number that was handled.
6501	Lot No. Δ BC28	Code[50]	Specifies the lot number that was handled.
6502	Warranty Date	Date	—
6503	Expiration Date Δ BC28	Date	Specifies the expiration date of the serial number that was handled.
6515	Package No.	Code[50]	—
7300	Bin Code Δ BC28	Code[20]	Specifies the bin where the items are picked or put away.	TableRelation Table 7354 “Bin” (if (“Action Type” = filter(<> Take)) Bin.Code where(“Location Code” = field(“Location Code”), “Zone Code” = field(“Zone Code”)) else if (“Action Type” = filter(<> Take), “Zone Code” = filter(‘’)) Bin.Code where(“Location Code” = field(“Location Code”)) else if (“Action Type” = const(Take)) “Bin Cont…)
7301	Zone Code Δ BC28	Code[10]	Specifies the code of the zone in which the bin on this line is located.	TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”)))
7305	Action Type Δ BC28	Enum “Warehouse Action Type”	Specifies the action you must perform for the items on the line.	enum Enum 5774 “Warehouse Action Type”; not editable
7306	Whse. Document Type Δ BC28	Enum “Warehouse Activity Document Type”	Specifies the type of document that the line originated from.	enum Enum 5769 “Warehouse Activity Document Type”; not editable
7307	Whse. Document No. Δ BC28	Code[20]	Specifies the number of the warehouse document that is the basis for the action on the line.	TableRelation Table 7318 “Posted Whse. Receipt Header”, Table 7320 “Warehouse Shipment Header” (if (“Whse. Document Type” = const(Receipt)) “Posted Whse. Receipt Header”.“No.” where(“No.” = field(“Whse. Document No.”)) else if (“Whse. Document Type” = const(Shipment)) “Warehouse Shipment Header”.“No.” where(“No.” = field(“Whse. Document No.”)) else if (“Whse. Document Type” = const(“Internal P…); not editable
7308	Whse. Document Line No. Δ BC28	Integer	Specifies the number of the line in the warehouse document that is the basis for the action on the line.	TableRelation Table 7319 “Posted Whse. Receipt Line”, Table 7321 “Warehouse Shipment Line” (if (“Whse. Document Type” = const(Receipt)) “Posted Whse. Receipt Line”.“Line No.” where(“No.” = field(“Whse. Document No.”), “Line No.” = field(“Whse. Document Line No.”)) else if (“Whse. Document Type” = const(Shipment)) “Warehouse Shipment Line”.“Line No.” where(“No.” = field(“Whse. Document No.”…); not editable
7310	Cubage Δ BC28	Decimal	Specifies the total cubage of items on the line, calculated based on the Quantity field.
7311	Weight Δ BC28	Decimal	Specifies the weight of one item unit when measured in the specified unit of measure.
7312	Special Equipment Code Δ BC28	Code[10]	Specifies the code of the equipment required when you perform the action on the line.	TableRelation Table 7305 “Special Equipment” (Special Equipment)

Keys

Key1: Activity Type, No., Line No. (clustered)
Key2: No., Line No., Activity Type
Key3: Activity Type, No., Sorting Sequence No.
Key4: Whse. Document Type, Whse. Document No., Whse. Document Line No.
Key5: Source Type, Source Subtype, Source No., Source Line No., Source Subline No., Whse. Document No., Serial No., Lot No., Action Type

Events published

OnAfterClearTrackingFilter(var RegisteredWhseActivityLine: Record "Registered Whse. Activity Line") (integration)
- subscribers: Codeunit 6516 “Package Management” RegisteredWhseActivityLineClearTrackingFilter
OnAfterSetTrackingFilterFromSpec(var RegisteredWhseActivityLine: Record "Registered Whse. Activity Line"; TrackingSpecification: Record "Tracking Specification") (integration)
- subscribers: Codeunit 6516 “Package Management” RegisteredWhseActivityLineSetTrackingFilterFromSpec
OnAfterSetTrackingFilterFromRelation(var RegisteredWhseActivityLine: Record "Registered Whse. Activity Line"; WhseItemEntryRelation: Record "Whse. Item Entry Relation") (integration)
- subscribers: Codeunit 6516 “Package Management” RegisteredWhseActivityLineSetTrackingFilterFromRelation
OnAfterSetTrackingFilterFromWhseActivityLine(var RegisteredWhseActivityLine: Record "Registered Whse. Activity Line"; WarehouseActivityLine: Record "Warehouse Activity Line") (integration)
- subscribers: Codeunit 6516 “Package Management” RegisteredWhseActivityLineSetTrackingFilterFromWhseActivityLine
OnAfterSetTrackingFilterFromWhseSpec(var RegisteredWhseActivityLine: Record "Registered Whse. Activity Line"; WhseItemTrackingLine: Record "Whse. Item Tracking Line") (integration)
- subscribers: Codeunit 6516 “Package Management” RegisteredWhseActivityLineSetTrackingFilterFromWhseSpec
OnBeforeShowWhseDoc(RegisteredWhseActivityLine: Record "Registered Whse. Activity Line"; var IsHandled: Boolean) (integration)
OnAfterSetSourceFilter(var RegisteredWhseActivityLine: Record "Registered Whse. Activity Line"; SourceType: Integer; SourceSubtype: Option; SourceNo: Code[20]; SourceLineNo: Integer; SourceSubLineNo: Integer; SetKey: Boolean) (integration)
OnShowWhseDoc(var RegisteredWhseActivityLine: Record "Registered Whse. Activity Line") + BC26 (integration)
- subscribers: Codeunit 5996 “Prod. Order Warehouse Mgt.” RegisteredWhseActivityLineOnShowWhseDoc

Procedures

ShowRegisteredActivityDoc()
ShowWhseDoc()
ShowWhseEntries(RegisterDate: Date)
SetSourceFilter(SourceType: Integer; SourceSubType: Option; SourceNo: Code[20]; SourceLineNo: Integer; SourceSubLineNo: Integer; SetKey: Boolean)
ClearSourceFilter()
ClearTrackingFilter()
SetTrackingFilterFromRelation(WhseItemEntryRelation: Record "Whse. Item Entry Relation")
SetTrackingFilterFromItemLedgerEntry(ItemLedgEntry: Record "Item Ledger Entry") + BC26
SetTrackingFilterFromSpec(TrackingSpecification: Record "Tracking Specification")
SetTrackingFilterFromWhseActivityLine(WarehouseActivityLine: Record "Warehouse Activity Line")
SetTrackingFilterFromWhseSpec(WhseItemTrackingLine: Record "Whse. Item Tracking Line")

Relations

drill-down page Page 7364 “Registered Whse. Act.-Lines”
lookup page Page 7364 “Registered Whse. Act.-Lines”
Shipment Method Code: TableRelation Table 10 “Shipment Method”
Destination No.: TableRelation Table 14 “Location” (conditional)
Location Code: TableRelation Table 14 “Location”
Destination No.: TableRelation Table 18 “Customer” (conditional)
Destination No.: TableRelation Table 23 “Vendor” (conditional)
Destination No.: TableRelation Table 27 “Item” (conditional)
Item No.: TableRelation Table 27 “Item”
Shipping Agent Code: TableRelation Table 291 “Shipping Agent”
Destination No.: TableRelation Table 36 “Sales Header” (conditional)
Variant Code: TableRelation Table 5401 “Item Variant”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
Shipping Agent Service Code: TableRelation Table 5790 “Shipping Agent Services”
Zone Code: TableRelation Table 7300 “Zone”
Special Equipment Code: TableRelation Table 7305 “Special Equipment”
Whse. Document No.: TableRelation Table 7318 “Posted Whse. Receipt Header” (conditional)
Whse. Document Line No.: TableRelation Table 7319 “Posted Whse. Receipt Line” (conditional)
Whse. Document No.: TableRelation Table 7320 “Warehouse Shipment Header” (conditional)
Whse. Document Line No.: TableRelation Table 7321 “Warehouse Shipment Line” (conditional)
Bin Code: TableRelation Table 7354 “Bin” (conditional)

Pages and codeunits on this table

Page 5796 “Registered Put-away Subform” (source table)
Page 5799 “Registered Pick Subform” (source table)
Page 7350 “Registered Movement Subform” (source table)
Page 7364 “Registered Whse. Act.-Lines” (source table)

Extended by

Table extension 99000762 “Mfg. Reg. Whse. Activity Line”

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.

Page 900 “Assembly Order” (1 call: ShowWhseDoc → (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: "Registered Whse. Activity Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.