Table 7014 "Purchase Line Discount"

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

Learn documents this table through its pages: Page 7014 “Purchase Line Discounts” (1 Learn page), Page 7189 “Get Purchase Line Disc.” (1).

Properties

Property	Value
Caption	Purchase Line Discount
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 line discount 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 line discount price.	TableRelation Table 4 “Currency”
4	Starting Date Δ BC28	Date	Specifies the date from which the purchase line discount is valid.
5	Line Discount % Δ BC28	Decimal	Specifies the discount percentage that is granted for the item on the line.
11	Minimum Quantity Δ BC28	Decimal	Specifies the minimum quantity of the item that you must buy from the vendor in order to receive the purchase line discount.
15	Ending Date Δ BC28	Date	Specifies the date to which the purchase line discount 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

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 7014 “Purchase Line Discounts” (source table)
Page 7189 “Get Purchase Line Disc.” (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 Line Discount"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.