Table 7012 "Purchase Price"

Base Application · Microsoft.Purchases.Pricing · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 7012 “Purchase Prices” (1 Learn page), Page 7190 “Get Purchase Price” (1).

Properties

Property	Value
Caption	Purchase Price
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 purchase price applies to.	TableRelation Table 27 “Item”; NotBlank
2	Vendor No. Δ BC28	Code[20]	Specifies the number of the vendor who offers the line discount on the item.	TableRelation Table 23 “Vendor”; NotBlank
3	Currency Code Δ BC28	Code[10]	Specifies the currency code of the purchase price.	TableRelation Table 4 “Currency”
4	Starting Date Δ BC28	Date	Specifies the date from which the purchase price is valid.
5	Direct Unit Cost Δ BC28	Decimal	Specifies the cost of one unit of the selected item or resource.
14	Minimum Quantity Δ BC28	Decimal	Specifies the minimum quantity of the item that you must buy from the vendor in order to get the purchase price.
15	Ending Date Δ BC28	Date	Specifies the date to which the purchase price is valid.
5400	Unit of Measure Code Δ BC28	Code[10]	Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.	TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”)))
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: Item No., Vendor No., Starting Date, Currency Code, Variant Code, Unit of Measure Code, Minimum Quantity (clustered)
Key2: Vendor No., Item No., Starting Date, Currency Code, Variant Code, Unit of Measure Code, Minimum Quantity

Events published

OnBeforeNewPurchasePriceInsert(var NewPurchasePrice: Record "Purchase Price"; PurchasePrice: Record "Purchase Price") + BC28 (integration)

Procedures

CopyPurchPriceToVendorsPurchPrice(var PurchPrice: Record "Purchase Price"; VendNo: Code[20]) + BC28

Triggers

OnInsert, OnRename

Relations

Vendor No.: TableRelation Table 23 “Vendor”
Item No.: TableRelation Table 27 “Item”
Currency Code: TableRelation Table 4 “Currency”
Variant Code: TableRelation Table 5401 “Item Variant”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”

Pages and codeunits on this table

Page 7012 “Purchase Prices” (source table)
Page 7190 “Get Purchase Price” (source table)

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