Table 5777 "Item Reference"

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

Properties

Property	Value
Caption	Item Reference
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 on the item card from which you opened the Item Reference Entries window.	TableRelation Table 27 “Item”
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	Unit of Measure Δ BC28	Code[10]	Specifies the name of the item or resource’s unit of measure, such as piece or hour.	TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”)))
4	Reference Type Δ BC28	Enum “Item Reference Type”	Specifies the type of the reference entry.	enum Enum 5726 “Item Reference Type”
5	Reference Type No. Δ BC26 Δ BC28	Code[20]	Specifies a customer number, a vendor number, or a bar code, depending on what you have selected in the Type field.	TableRelation if (“Reference Type” = const(Customer)) Customer.“No.” else if (“Reference Type” = const(Vendor)) Vendor.“No.”
6	Reference No. Δ BC26 Δ BC28	Code[50]	Specifies the referenced item number. If you enter a reference between yours and your vendor’s or customer’s item number, then this number will override the standard item number when you enter the reference number on a sales or purchase document.	NotBlank
7	Description Δ BC25 Δ BC28	Text[100]	Specifies a description of the item that is linked to this reference.
9	Description 2 Δ BC25 Δ BC28	Text[50]	Specifies an additional description of the item that is linked to this reference.
10	Starting Date Δ BC28	Date	Specifies the first day from when the item reference is valid.
11	Ending Date Δ BC28	Date	Specifies the last day from when the item reference is valid.

Keys

Key1: Item No., Variant Code, Unit of Measure, Reference Type, Reference Type No., Reference No. (clustered)
Key2: Reference No.
Key3: Reference No., Reference Type, Reference Type No.
Key4: Reference Type, Reference No.
Key5: Item No., Variant Code, Unit of Measure, Reference Type, Reference No.
Key6: Reference Type, Reference Type No.

Events published

OnAfterCreateItemVendor(var ItemReference: Record "Item Reference"; ItemVendor: Record "Item Vendor") (integration)
OnBeforeCreateItemVendor(var ItemReference: Record "Item Reference"; var ItemVendor: Record "Item Vendor") (integration)
- subscribers: Codeunit 8028 “Usage Based Contr. Subscribers” SynchronizeItemVendorUsageDataSupplierReferenceEntryNoOnBeforeCreateItemVendor
OnBeforeCreateItemVendorProcedure(var ItemReference: Record "Item Reference"; var ItemVendor: Record "Item Vendor"; var IsHandled: Boolean) (integration)
OnBeforeFindItemDescription(var ItemDescription: Text[100]; var ItemDescription2: Text[50]; ItemNo: Code[20]; VariantCode: Code[10]; UnitOfMeasureCode: Code[10]; ReferenceType: Enum "Item Reference Type"; ReferenceTypeNo: Code[20]; var Result: Boolean; var IsHandled: Boolean; var ItemReference: Record "Item Reference"; ToDate: Date) (integration)
OnBeforeItemVendorDelete(ItemVendor: Record "Item Vendor"; ItemReference: Record "Item Reference") (integration)
OnBeforeUpdateItemVendorNo(var ItemReference: Record "Item Reference"; var IsHandled: Boolean) (integration)
OnBeforeMultipleItemReferencesExist(var ItemReference: Record "Item Reference"; var Result: Boolean; var IsHandled: Boolean) (integration)
OnInsertTriggerOnBeforeCreateItemVendor(var Rec: Record "Item Reference"; xRec: Record "Item Reference"; Item: Record "Item") (integration)
OnBeforeDeleteItemVendor(var ItemReference: Record "Item Reference"; var IsHandled: Boolean) (integration)
OnRenameOnBeforeUpdateItemVendor(var ItemReference: Record "Item Reference"; xItemReference: Record "Item Reference"; var IsHandled: Boolean) + BC25 (integration)
OnBeforeValidateReferenceType(var ItemReference: Record "Item Reference"; xItemReference: Record "Item Reference"; var IsHandled: Boolean) + BC25 (integration)
OnInsertTriggerOnBeforeValidateUoM(var ItemReference: Record "Item Reference"; xItemReference: Record "Item Reference"; Item: Record "Item"; var IsHandled: Boolean) + BC26 (integration)

Trigger event subscribers

OnAfterValidateEvent(Supplier Ref. Entry No.): Codeunit 8028 “Usage Based Contr. Subscribers” SynchronizeItemVendorUsageDataSupplierReferenceEntryNoOnAfterValidateEvent

Procedures

CreateItemVendor()
FindItemDescription(var ItemDescription: Text[100]; var ItemDescription2: Text[50]; ItemNo: Code[20]; VariantCode: Code[10]; UnitOfMeasureCode: Code[10]; ToDate: Date; ReferenceType: Enum "Item Reference Type"; ReferenceTypeNo: Code[20]): Boolean − BC29
HasValidUnitOfMeasure(): Boolean

Plus 5 local procedures.

Triggers

OnDelete, OnInsert, OnRename

Relations

lookup page Page 5735 “Item Reference List”
Item No.: TableRelation Table 27 “Item”
Variant Code: TableRelation Table 5401 “Item Variant”
Unit of Measure: TableRelation Table 5404 “Item Unit of Measure”

Referenced by

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

Table 6101 “E-Document Purchase Line”: [BC] Item Reference No.
Table 6105 “E-Document Line Mapping”: Item Reference No.
Table 6154 “E-Document Sales Line”: [BC] Item Reference No.

Pages and codeunits on this table

Page 5735 “Item Reference List” (source table)
Page 5736 “Item References” (source table)
Page 5737 “Item Reference Entries” (source table)

Extended by

Table extension 8008 “Usage Based Item Reference”

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: "Item Reference"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.