Table 99 "Item Vendor"

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

Properties

Property	Value
Caption	Item Vendor
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. Δ BC28	Code[20]	Specifies the number of the item that the alternate direct unit cost is valid for.	TableRelation Table 27 “Item”; NotBlank
2	Vendor No. Δ BC28	Code[20]	Specifies the number of the vendor who offers the alternate direct unit cost.	TableRelation Table 23 “Vendor”; NotBlank
6	Lead Time Calculation Δ BC28	DateFormula	Specifies a date formula for the amount of time it takes to replenish the item.
7	Vendor Item No. Δ BC28	Text[50]	Specifies the number that the vendor uses for this item.
5700	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.”)))

Keys

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

Events published

OnBeforeDeleteItemReference(var ItemVendor: Record "Item Vendor"; xItemVendor: Record "Item Vendor"; var IsHandled: Boolean) (integration)
OnBeforeInsertItemReference(var ItemVendor: Record "Item Vendor"; xItemVendor: Record "Item Vendor"; var IsHandled: Boolean) (integration)
OnBeforeFindLeadTimeCalculation(var ItemVendor: Record "Item Vendor"; Item: Record Item; LocationCode: Code[10]; var IsHandled: Boolean) (integration)
OnBeforeUpdateItemReference(var ItemVendor: Record "Item Vendor"; var IsHandled: Boolean; var xItemVendor: Record "Item Vendor") (integration)

Trigger event subscribers

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

Procedures

InsertItemReference()
ShowPriceListLines(PriceAmountType: Enum "Price Amount Type")
FindLeadTimeCalculation(Item: Record Item; var SKU: Record "Stockkeeping Unit"; LocationCode: Code[10])

Plus 4 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

lookup page Page 114 “Item Vendor Catalog”
Vendor No.: TableRelation Table 23 “Vendor”
Item No.: TableRelation Table 27 “Item”
Variant Code: TableRelation Table 5401 “Item Variant”

Referenced by

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

Table extension 8052 “Item”: Usage Data Suppl. Ref. Exists

Pages and codeunits on this table

Page 114 “Item Vendor Catalog” (source table)
Page 297 “Vendor Item Catalog” (source table)
Page 298 “Vendor Item List” (source table)

Extended by

Table extension 8009 “Usage Based Item Vendor”

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 5720 “Item Reference Management” (3 calls: DeleteItemReference → DeleteItemReference, InsertItemReference → InsertItemReference, UpdateItemReference → UpdateItemReference)
Codeunit 7018 “Price UX Management” (1 call: ShowPriceListLines → ShowPriceListLines)
Codeunit 99000855 “Planning-Get Parameters” (1 call: FindLeadTimeCalculation → AtSKU)

Countries that replace it

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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

Across versions

Neighbourhood 12 connected objects and pages