Table 6505 "Lot No. Information"

Base Application · Microsoft.Inventory.Tracking · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Lot No. Information
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	Item No. Δ BC25 Δ BC28	Code[20]	Specifies this number from the Tracking Specification table when a lot number information record is created.	TableRelation Table 27 “Item”; NotBlank
2	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.”)))
3	Lot No. Δ BC25 Δ BC28	Code[50]	Specifies this number from the Tracking Specification table when a lot number information record is created.	NotBlank
10	Description Δ BC25 Δ BC28	Text[100]	Specifies a description of the lot no. information record.
11	Test Quality Δ BC28	Option	Specifies the quality of a given lot if you have inspected the items.	OptionCaption: ,Good,Average,Bad
12	Certificate Number Δ BC28	Code[20]	Specifies the number provided by the supplier to indicate that the batch or lot meets the specified requirements.
13	Blocked Δ BC28	Boolean	Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine.
14	Comment Δ BC28	Boolean	Specifies that a comment has been recorded for the lot number.	FlowField: exist(“Item Tracking Comment” where(Type = const(“Lot No.”), “Item No.” = field(“Item No.”), “Variant Code” = field(“Variant Code”), “Serial/Lot No.” = field(“Lot No.”))); not editable
20	Inventory Δ BC28	Decimal	Specifies the inventory quantity of the specified lot number.	FlowField: sum(“Item Ledger Entry”.Quantity where(“Item No.” = field(“Item No.”), “Variant Code” = field(“Variant Code”), “Lot No.” = field(“Lot No.”), “Location Code” = field(“Location Filter”))); not editable
21	Date Filter	Date	—	FlowFilter
22	Location Filter	Code[10]	—	TableRelation Table 14 “Location”; FlowFilter
23	Bin Filter	Code[20]	—	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Filter”))); FlowFilter
24	Expired Inventory Δ BC28	Decimal	Specifies the inventory of the lot number with an expiration date before the posting date on the associated document.	FlowField: sum(“Item Ledger Entry”.“Remaining Quantity” where(“Item No.” = field(“Item No.”), “Variant Code” = field(“Variant Code”), “Lot No.” = field(“Lot No.”), “Location Code” = field(“Location Filter”), “Expiration Date” = field(“Date Filter”), Open = const(true), Positive = const(true))); not editable

Keys

Key1: Item No., Variant Code, Lot No. (clustered)
Key2: Lot No.

Events published

OnShowCardOnAfterLotNoInfoNewSetFilters(var LotNoInformation: Record "Lot No. Information"; TrackingSpecification: Record "Tracking Specification"; LotNo: Code[50]; var LotNoInformationCard: Page "Lot No. Information Card") + BC27 − BC27 (integration)
OnShowCardOnAfterLotNoInfoNewSetFilters2(var LotNoInformation: Record "Lot No. Information"; WhseItemTrackingLine: Record "Whse. Item Tracking Line"; LotNo: Code[50]; var LotNoInformationCard: Page "Lot No. Information Card") + BC27 (integration)

Procedures

ShowCard(LotNo: Code[50]; TrackingSpecification: Record "Tracking Specification")
ShowCard(LotNo: Code[50]; WhseItemTrackingLine: Record "Whse. Item Tracking Line")

Triggers

OnDelete

Relations

drill-down page Page 6508 “Lot No. Information List”
lookup page Page 6508 “Lot No. Information List”
Location Filter: TableRelation Table 14 “Location”
Item No.: TableRelation Table 27 “Item”
Expired Inventory: CalcFormula Table 32 “Item Ledger Entry”
Inventory: CalcFormula Table 32 “Item Ledger Entry”
Variant Code: TableRelation Table 5401 “Item Variant”
Comment: CalcFormula Table 6506 “Item Tracking Comment”
Bin Filter: TableRelation Table 7354 “Bin”

Referenced by

5 fields in 3 objects relate to this table (TableRelation or CalcFormula).

Table 520 “Availability Info. Buffer”: Blocked, Certificate Number, Quality
Table 5767 “Warehouse Activity Line”: Lot No. Blocked
Table 5884 “Pstd. Phys. Invt. Tracking”: Lot No.

Pages and codeunits on this table

Page 6505 “Lot No. Information Card” (source table)
Page 6508 “Lot No. Information List” (source table)

Extended by

Ask your agent

Procedure bodies are not stored here (D10). 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: "Lot No. Information"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.