Table 6550 "Whse. Item Tracking Line"
Base Application · Microsoft.Warehouse.Tracking
Across versions
- BC23present
- BC241 fields changed
- BC25unchanged
- BC261 procedures added
- BC27unchanged
- BC2823 fields changed, 1 procedures added
- BC29-30unchanged
Neighbourhood 11 connected objects and pages
Base Application · Microsoft.Warehouse.Tracking · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Whse. Item Tracking 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 | Entry No. | Integer | — | |
| 2 | Item No. Δ BC28 | Code[20] | Specifies the same as the field in the Item Tracking Lines window. | TableRelation Table 27 “Item” |
| 3 | Location Code Δ BC28 | Code[10] | Specifies the same as the field in the Item Tracking Lines window. | TableRelation Table 14 “Location” |
| 4 | Quantity (Base) Δ BC28 | Decimal | Specifies the same as the field in the Item Tracking Lines window. via Page 6550 “Whse. Item Tracking Lines” | |
| 7 | Description Δ BC28 | Text[100] | Specifies the same as the field with the same name in the Item Tracking Lines window. | |
| 10 | Source Type | Integer | — | |
| 11 | Source Subtype | Option | — | OptionCaption: 0,1,2,3,4,5,6,7,8,9,10 |
| 12 | Source ID | Code[20] | — | |
| 13 | Source Batch Name | Code[10] | — | |
| 14 | Source Prod. Order Line | Integer | — | |
| 15 | Source Ref. No. | Integer | — | |
| 24 | Serial No. Δ BC28 | Code[50] | Specifies the same as the field in the Item Tracking Lines window. | |
| 29 | Qty. per Unit of Measure Δ BC28 | Decimal | — | not editable |
| 40 | Warranty Date Δ BC28 | Date | Specifies the same as the field in the Item Tracking Lines window. | |
| 41 | Expiration Date Δ BC28 | Date | Specifies the same as the field in the Item Tracking Lines window. | |
| 50 | Qty. to Handle (Base) Δ BC28 | Decimal | Specifies the same as the field in the Item Tracking Lines window. via Page 6550 “Whse. Item Tracking Lines” | |
| 51 | Qty. to Invoice (Base) Δ BC28 | Decimal | — | |
| 52 | Quantity Handled (Base) Δ BC28 | Decimal | Specifies the same as the field in the Item Tracking Lines window. via Page 6550 “Whse. Item Tracking Lines” | not editable |
| 53 | Quantity Invoiced (Base) Δ BC28 | Decimal | — | not editable |
| 60 | Qty. to Handle Δ BC28 | Decimal | — | |
| 70 | Buffer Status | Option | — | OptionCaption: ,MODIFY; not editable |
| 71 | Buffer Status2 | Option | — | OptionCaption: ,ExpDate blocked; not editable |
| 80 | New Serial No. Δ BC28 | Code[50] | Specifies a new serial number that replaces the number in the Serial No. field, when you post the warehouse item reclassification journal. | |
| 81 | New Lot No. Δ BC28 | Code[50] | Specifies a new lot number that replaces the number in the Lot No. field, when you post the warehouse item reclassification journal. | |
| 90 | Source Type Filter Δ BC24 | Option | — | FlowFilter; OptionCaption: ,Receipt,Shipment,Internal Put-away,Internal Pick,Production,Movement Worksheet,Assembly,Project |
| 91 | Qty. Registered (Base) Δ BC28 | Decimal | — | |
| 92 | Put-away Qty. (Base) Δ BC28 | Decimal | — | FlowField: sum(“Warehouse Activity Line”.“Qty. Outstanding (Base)” where(“Activity Type” = filter(“Put-away”), #pragma warning disable AL0603 “Whse. Document Type” = field(“Source Type Filter”), #pragma warning restore AL0603 “Whse. Document No.” = field(“Source ID”), “Whse. Document Line No.” = field(“Source … |
| 93 | Pick Qty. (Base) Δ BC28 | Decimal | — | FlowField: sum(“Warehouse Activity Line”.“Qty. Outstanding (Base)” where(“Activity Type” = filter(Pick | Movement), #pragma warning disable AL0603 “Whse. Document Type” = field(“Source Type Filter”), #pragma warning restore AL0603 “Whse. Document No.” = field(“Source ID”), “Whse. Document Line No.” = field(“So… |
| 94 | Created by Whse. Activity Line | Boolean | — | |
| 5400 | Lot No. Δ BC28 | Code[50] | Specifies the same as the field in the Item Tracking Lines window. | |
| 5401 | 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.”))) |
| 6505 | New Expiration Date Δ BC28 | Date | Specifies the same as the field in the Item Tracking Lines window. | |
| 6515 | Package No. Δ BC28 | Code[50] | Specifies a new package number that replaces the package number, when you post the warehouse item reclassification journal. | |
| 6516 | New Package No. Δ BC28 | Code[50] | Specifies a new package number that replaces the number in the Package No. field, when you post the warehouse item reclassification journal. |
Keys
- Key1: Entry No. (clustered)
- Key2: Source ID, Source Type, Source Subtype, Source Batch Name, Source Prod. Order Line, Source Ref. No., Location Code
- Key3: Serial No., Lot No., Package No.
- Key4: Item No., Variant Code, Location Code
Events published
OnAfterCheckTrackingIfRequired(WhseItemTrackingLine: Record "Whse. Item Tracking Line"; WhseItemTrackingSetup: Record "Item Tracking Setup")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineInitFromTrackingSpec
OnAfterClearTrackingFilter(var WhseItemTrackingLine: Record "Whse. Item Tracking Line")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineClearTrackingFilter
OnAfterCopyTrackingFromEntrySummary(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; EntrySummary: Record "Entry Summary")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineCopyTrackingFromEntrySummary
OnAfterCopyTrackingFromItemLedgEntry(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; ItemLedgerEntry: Record "Item Ledger Entry")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineCopyTrackingFromItemLedgEntry
OnAfterCopyTrackingFromPostedWhseReceiptine(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; PostedWhseReceiptLine: Record "Posted Whse. Receipt Line")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineCopyTrackingFromPostedWhseReceiptLine
OnAfterCopyTrackingFromRelation(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; WhseItemEntryRelation: Record "Whse. Item Entry Relation")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineCopyTrackingFromRelation
OnAfterCopyTrackingFromReservEntry(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; ReservationEntry: Record "Reservation Entry")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineCopyTrackingFromReservEntry
OnAfterCopyTrackingFromPostedWhseRcptLine(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; PostedWhseRcptLine: Record "Posted Whse. Receipt Line")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineCopyTrackingFromPostedWhseRcptLine
OnAfterCopyTrackingFromWhseActivityLine(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; WhseActivityLine: Record "Warehouse Activity Line")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineCopyTrackingFromWhseActivityLine
OnAfterCopyTrackingFromWhseEntry(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; WhseEntry: Record "Warehouse Entry")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineCopyTrackingFromWhseEntry
OnAfterCopyTrackingFromWhseItemTrackingLine(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; FromWhseItemTrackingLine: Record "Whse. Item Tracking Line")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineCopyTrackingFromWhseItemTrackingLine
OnAfterHasSameTracking(WhseItemTrackingLine: Record "Whse. Item Tracking Line"; WhseItemTrackingLine2: Record "Whse. Item Tracking Line"; var IsSameTracking: Boolean)(integration)OnAfterHasSameNewTracking(WhseItemTrackingLine: Record "Whse. Item Tracking Line"; var IsSameTracking: Boolean)(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineHasSameNewTracking
OnAfterHasSameTrackingWithItemEntryRelation(WhseItemTrackingLine: Record "Whse. Item Tracking Line"; WhseItemEntryRelation: Record "Whse. Item Entry Relation"; var IsSameTracking: Boolean)(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineHasSameTrackingWithItemEntryRelation
OnAfterInitQtyToHandle(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; xWhseItemTrackingLine: Record "Whse. Item Tracking Line"; CallingFieldNo: Integer)(integration)OnAfterLookUpTrackingSummary(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; TrackingType: Enum "Item Tracking Type"; var TempTrackingSpecification: Record "Tracking Specification" temporary)(integration)OnAfterSetTrackingFilterFromBinContent(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; var BinContent: Record "Bin Content")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineSetTrackingFilterFromBinContent
OnAfterSetTrackingFilterFromItemLedgerEntry(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; var ItemLedgerEntry: Record "Item Ledger Entry")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineSetTrackingFilterFromItemLedgerEntry
OnAfterSetTrackingFilterFromItemTrackingSetupIfNotBlank(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; ItemTrackingSetup: Record "Item Tracking Setup")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineOnAfterSetTrackingFilterFromItemTrackingSetupIfNotBlank
OnAfterSetTrackingFilterFromPostedWhseReceiptLine(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; PostedWhseReceiptLine: Record "Posted Whse. Receipt Line")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineSetTrackingFilterFromPostedWhseReceiptLine
OnAfterSetTrackingFilterFromRelation(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; WhseItemEntryRelation: Record "Whse. Item Entry Relation")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineSetTrackingFilterFromRelation
OnAfterSetTrackingFilterFromReservEntry(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; ReservationEntry: Record "Reservation Entry")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineSetTrackingFilterFromReservEntry
OnAfterSetTrackingFilterFromSpec(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; FromWhseItemTrackingLine: Record "Whse. Item Tracking Line")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineSetTrackingFilterFromSpec
OnAfterSetTrackingFilterFromWhseActivityLine(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; WhseActivityLine: Record "Warehouse Activity Line")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineSetTrackingFilterFromWhseActivityLine
OnAfterSetTrackingFilterFromWhseItemTrackingLine(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; FromWhseItemTrackingLine: Record "Whse. Item Tracking Line")(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineSetTrackingFilterFromWhseItemTrackingLine
OnAfterTrackingExists(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; var IsTrackingExist: Boolean)(integration)- subscribers: Codeunit 6516 “Package Management” WhseItemTrackingLineTrackingExists
OnBeforeCheckSerialNoQty(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; var IsHandled: Boolean)(integration)OnBeforeLookUpTrackingSummary(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; TrackingType: Enum "Item Tracking Type"; MaxQuantity: Decimal; SignFactor: Integer; SearchForSupply: Boolean; var IsHandled: Boolean)(integration)OnBeforeInitExpirationDate(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; xWhseItemTrackingLine: Record "Whse. Item Tracking Line"; var IsHandled: Boolean)(integration)OnBeforeSetTrackingKey(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; var IsHandled: Boolean)(integration)OnAfterSetSourceFilter(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; SourceType: Integer; SourceSubtype: Integer; SourceID: Code[20]; SourceRefNo: Integer; SourceKey: Boolean)(integration)
Trigger event subscribers
- OnAfterLookupTrackingSummary: Codeunit 6516 “Package Management” WhseItemTrackingLineLookupTrackingSummary
Procedures
GetNextEntryNo(): Integer+ BC28: Gets the next entry number for the Whse. Item Tracking Line table using sequence number management.GetLastEntryNo(): IntegerInitQtyToHandle()InitExpirationDate()IsReclass(SourceType: Integer; SourceBatchName: Code[10]): BooleanLookUpTrackingSummary(var WhseItemTrackingLine: Record "Whse. Item Tracking Line"; TrackingType: Enum "Item Tracking Type"; MaxQuantity: Decimal; SignFactor: Integer; SearchForSupply: Boolean)CheckTrackingIfRequired(WhseItemTrackingSetup: Record "Item Tracking Setup")SetTrackingFilterFromItemTrackingSetupIfNotBlank(ItemTrackingSetup: Record "Item Tracking Setup")ClearTrackingFilter()CopyTrackingFromEntrySummary(EntrySummary: Record "Entry Summary")CopyTrackingFromItemLedgEntry(ItemLedgerEntry: Record "Item Ledger Entry")CopyTrackingFromPostedWhseReceiptLine(PostedWhseReceiptLine: Record "Posted Whse. Receipt Line")CopyTrackingFromReservEntry(ReservationEntry: Record "Reservation Entry")CopyTrackingFromPostedWhseRcptLine(PostedWhseReceiptLine: Record "Posted Whse. Receipt Line")CopyTrackingFromWhseActivityLine(WarehouseActivityLine: Record "Warehouse Activity Line")CopyTrackingFromWhseEntry(WarehouseEntry: Record "Warehouse Entry")CopyTrackingFromWhseItemTrackingLine(WhseItemTrackingLine: Record "Whse. Item Tracking Line")CopyTrackingFromRelation(WhseItemEntryRelation: Record "Whse. Item Entry Relation")SetSource(SourceType: Integer; SourceSubtype: Integer; SourceID: Code[20]; SourceRefNo: Integer; SourceBatchName: Code[10]; SourceProdOrderLine: Integer)SetSourceFilter(SourceType: Integer; SourceSubtype: Integer; SourceID: Code[20]; SourceRefNo: Integer; SourceKey: Boolean)SetSourceFilter(SourceBatchName: Code[10]; SourceProdOrderLine: Integer)SetTrackingFilterFromBinContent(var BinContent: Record "Bin Content")SetTrackingFilterFromItemLedgerEntry(var ItemLedgerEntry: Record "Item Ledger Entry")SetTrackingFilterFromPostedWhseReceiptLine(PostedWhseReceiptLine: Record "Posted Whse. Receipt Line")SetTrackingFilterFromRelation(WhseItemEntryRelation: Record "Whse. Item Entry Relation")SetTrackingFilterFromReservEntry(ReservationEntry: Record "Reservation Entry")SetTrackingFilterFromSpec(WhseItemTrackingLine: Record "Whse. Item Tracking Line")SetTrackingFilterFromWhseActivityLine(WarehouseActivityLine: Record "Warehouse Activity Line")SetTrackingFilterFromWhseItemTrackingLine(WhseItemTrackingLine: Record "Whse. Item Tracking Line")SetTrackingKey()HasSameTracking(WhseItemTrackingLine: Record "Whse. Item Tracking Line"): BooleanHasSameNewTracking(): BooleanHasSameTrackingWithItemEntryRelation(WhseItemEntryRelation: Record "Whse. Item Entry Relation"): BooleanHasSameTrackingWithItemLedgerEntry(ItemLedgerEntry: Record "Item Ledger Entry"): Boolean+ BC26TrackingExists(): Boolean
Plus 2 local procedures.
Triggers
OnDelete
Relations
- Location Code: TableRelation Table 14 “Location”
- Item No.: TableRelation Table 27 “Item”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Pick Qty. (Base): CalcFormula Table 5767 “Warehouse Activity Line”
- Put-away Qty. (Base): CalcFormula Table 5767 “Warehouse Activity Line”
Pages and codeunits on this table
- Page 6550 “Whse. Item Tracking Lines” (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 6500 “Item Tracking Management” (2 calls:
InitExpirationDate → GetWhseExpirationDate,InitExpirationDate → GetWhseWarrantyDate) - Codeunit 5402 “Unit of Measure Management” (1 call:
CalcQty → QtyRndPrecision) - Codeunit 6501 “Item Tracking Data Collection” (1 call:
LookUpTrackingSummary → AssistEditTrackingNo) - Codeunit 703 “Find Record Management” (1 call:
GetLastEntryNo → GetLastEntryIntFieldValue) - Codeunit 9500 “Sequence No. Mgt.” (1 call:
GetNextEntryNo → GetNextSeqNo)
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. Item Tracking Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.