Table 6504 "Serial No. Information"

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

Properties

Property	Value
Caption	Serial 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 the number that is copied from the Tracking Specification table, when a serial 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	Serial No. Δ BC25 Δ BC28	Code[50]	Specifies this number from the Tracking Specification table when a serial number information record is created.	NotBlank
10	Description Δ BC25 Δ BC28	Text[100]	Specifies a description of the serial no. information record.
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 serial number.	FlowField: exist(“Item Tracking Comment” where(Type = const(“Serial No.”), “Item No.” = field(“Item No.”), “Variant Code” = field(“Variant Code”), “Serial/Lot No.” = field(“Serial No.”))); not editable
20	Inventory Δ BC28	Decimal	Specifies the inventory quantity of the specified serial number.	FlowField: sum(“Item Ledger Entry”.Quantity where(“Item No.” = field(“Item No.”), “Variant Code” = field(“Variant Code”), “Serial No.” = field(“Serial 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 serial 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”), “Serial No.” = field(“Serial 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, Serial No. (clustered)
Key2: Serial No.

Procedures

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

Triggers

OnDelete

Relations

drill-down page Page 6509 “Serial No. Information List”
lookup page Page 6509 “Serial 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

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

Table 5767 “Warehouse Activity Line”: Serial No. Blocked
Table 5884 “Pstd. Phys. Invt. Tracking”: Serial No.

Pages and codeunits on this table

Page 6504 “Serial No. Information Card” (source table)
Page 6509 “Serial 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: "Serial No. Information"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.