Table 1304 "Sales Price and Line Disc Buff"

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

Properties

Property	Value
Caption	Sales Price and Line Disc Buff
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	Code Δ BC28	Code[20]	Specifies a code for the sales line price or discount.	TableRelation Table 27 “Item”, Table 341 “Item Discount Group” (if (Type = const(Item)) Item else if (Type = const(“Item Disc. Group”)) “Item Discount Group”); NotBlank; DataClassification SystemMetadata
2	Sales Code Δ BC28	Code[20]	Specifies the sales code of the price or discount. The sales code depends on the value in the Sales Type field. The code can represent an individual customer, a customer discount group, or for all customers.	TableRelation Table 18 “Customer”, Table 340 “Customer Discount Group”, Table 6 “Customer Price Group” (if (“Sales Type” = const(“Customer Price/Disc. Group”), “Line Type” = const(“Sales Line Discount”)) “Customer Discount Group” else if (“Sales Type” = const(“Customer Price/Disc. Group”), “Line Type” = const(“Sales Price”)) “Customer Price Group” else if (“Sales Type” = const(Customer)) Customer); DataClassification SystemMetadata
3	Currency Code Δ BC28	Code[10]	Specifies the currency that must be used on the sales document line to warrant the sales price or discount.	TableRelation Table 4 “Currency”; DataClassification SystemMetadata
4	Starting Date Δ BC28	Date	Specifies the date from which the sales line discount is valid.	DataClassification SystemMetadata
5	Line Discount % Δ BC28	Decimal	Specifies the discount percentage that is granted for the item on the line.	DataClassification SystemMetadata
6	Unit Price Δ BC28	Decimal	Specifies the price of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card.	DataClassification SystemMetadata
7	Price Includes VAT Δ BC28	Boolean	Specifies if the price that is granted includes VAT.	DataClassification SystemMetadata
10	Allow Invoice Disc. Δ BC28	Boolean	Specifies if an invoice discount will be calculated when the sales price is offered.	DataClassification SystemMetadata
11	VAT Bus. Posting Gr. (Price)	Code[20]	Specifies the VAT business posting group for customers who you want to apply the sales price to. This price includes VAT. via Page 1345 “Sales Price and Line Discounts”	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group); DataClassification SystemMetadata
13	Sales Type Δ BC28	Option	Specifies the sales type of the price or discount. The sales type defines whether the sales price or discount is for an individual customer, a customer discount group, or for all customers.	OptionCaption: Customer,Customer Price/Disc. Group,All Customers,Campaign; DataClassification SystemMetadata
14	Minimum Quantity Δ BC28	Decimal	Specifies the quantity that must be entered on the sales document to warrant the sales price or discount.	DataClassification SystemMetadata
15	Ending Date Δ BC28	Date	Specifies the date to which the sales line discount is valid.	DataClassification SystemMetadata
21	Type Δ BC28	Enum “Sales Line Discount Type”	Specifies if the discount is valid for an item or for an item discount group.	enum Enum 7021 “Sales Line Discount Type”; DataClassification SystemMetadata
1300	Line Type Δ BC28	Option	Specifies if the line is for a sales price or a sales line discount.	OptionCaption: ,Sales Line Discount,Sales Price; DataClassification SystemMetadata
1301	Loaded Item No.	Code[20]	—	not editable; DataClassification SystemMetadata
1302	Loaded Disc. Group	Code[20]	—	not editable; DataClassification SystemMetadata
1303	Loaded Customer No.	Code[20]	—	not editable; DataClassification SystemMetadata
1304	Loaded Price Group	Code[20]	—	not editable; DataClassification SystemMetadata
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” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(Code))); DataClassification SystemMetadata
5700	Variant Code Δ BC28	Code[10]	Specifies the variant that must be used on the sales document line to warrant the sales price or discount.	TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(Code))); DataClassification SystemMetadata
7001	Allow Line Disc. Δ BC28	Boolean	Specifies if line discounts are allowed.	DataClassification SystemMetadata

Keys

Key1: Line Type, Type, Code, Sales Type, Sales Code, Starting Date, Currency Code, Variant Code, Unit of Measure Code, Minimum Quantity, Loaded Item No., Loaded Disc. Group, Loaded Customer No., Loaded Price Group (clustered)

Events published

OnAfterVATPostingSetupGet(var VATPostingSetup: Record "VAT Posting Setup") (integration)
OnBeforeDeleteOldRecordVersion(var SalesPriceAndLineDiscBuff: Record "Sales Price and Line Disc Buff"; xSalesPriceAndLineDiscBuff: Record "Sales Price and Line Disc Buff"; var IsHandled: Boolean) (integration)
OnBeforeDeleteOldRecordVersionFromPrices(xSalesPriceAndLineDiscBuff: Record "Sales Price and Line Disc Buff"; var IsHandled: Boolean) (integration)
OnInsertNewDiscountLineOnBeforeInsert(var SalesLineDiscount: Record "Sales Line Discount"; SalesPriceAndLineDiscBuff: Record "Sales Price and Line Disc Buff") (integration)
OnInsertNewPriceLineOnBeforeInsert(var SalesPrice: Record "Sales Price"; SalesPriceAndLineDiscBuff: Record "Sales Price and Line Disc Buff") (integration)
OnLoadSalesLineDiscountOnBeforeInsert(var SalesPriceAndLineDiscBuff: Record "Sales Price and Line Disc Buff"; SalesLineDiscount: Record "Sales Line Discount") (integration)
OnLoadSalesPriceOnBeforeInsert(var SalesPriceAndLineDiscBuff: Record "Sales Price and Line Disc Buff"; SalesPrice: Record "Sales Price") (integration)
OnLoadDataForCustomerOnAfterSetLoadedCustomerFields(var Customer: Record Customer; MaxNoOfLines: Integer; var SalesPriceAndLineDiscBuff: Record "Sales Price and Line Disc Buff") + BC28 (integration)
OnLoadDataForCustomerOnAfterCalcLoadedLines(var LoadedLines: Integer; var RemainingLinesToLoad: Integer; var SalesPriceAndLineDiscBuff: Record "Sales Price and Line Disc Buff"; var Customer: Record Customer; MaxNoOfLines: Integer) + BC28 (integration)
OnLookupCodeCaseElse() (integration)
OnValidateTypeCaseElse() (integration)
OnAfterSetFiltersOnSalesPrice(var SalesPriceandLineDiscBuff: Record "Sales Price and Line Disc Buff"; var SalesPrice: Record "Sales Price") (integration)
OnAfterSetFiltersOnSalesLineDiscountItem(var SalesPriceandLineDiscBuff: Record "Sales Price and Line Disc Buff"; var SalesLineDiscount: Record "Sales Line Discount") (integration)
OnAfterSetFiltersOnSalesLineDiscountItemGroup(var SalesPriceandLineDiscBuff: Record "Sales Price and Line Disc Buff"; var SalesLineDiscount: Record "Sales Line Discount") (integration)
OnAfterFilterToActualRecords(var SalesPriceandLineDiscBuff: Record "Sales Price and Line Disc Buff") (integration)

Procedures

LoadDataForItem(Item: Record Item): Loads sales prices and line discounts for the specified item into the buffer.
LoadDataForCustomer(Customer: Record Customer): Loads sales prices and line discounts for the specified customer into the buffer.
LoadDataForCustomer(var Customer: Record Customer; MaxNoOfLines: Integer): Integer: Loads sales prices and line discounts for the specified customer into the buffer with a maximum number of lines.
FilterToActualRecords(): Filters the buffer to show only active records that have not expired.
CustHasLines(Cust: Record Customer): Boolean: Checks whether any sales prices or line discounts exist for the specified customer.
ItemHasLines(Item: Record Item): Boolean: Checks whether any sales prices or line discounts exist for the specified item.
UpdatePriceIncludesVatAndPrices(Item: Record Item; IncludesVat: Boolean): Updates the Price Includes VAT flag and recalculates unit prices for the item.

Plus 28 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

Sales Code: TableRelation Table 18 “Customer” (conditional)
Code: TableRelation Table 27 “Item” (conditional)
VAT Bus. Posting Gr. (Price): TableRelation Table 323 “VAT Business Posting Group”
Sales Code: TableRelation Table 340 “Customer Discount Group” (conditional)
Code: TableRelation Table 341 “Item Discount Group” (conditional)
Currency Code: TableRelation Table 4 “Currency”
Variant Code: TableRelation Table 5401 “Item Variant”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
Sales Code: TableRelation Table 6 “Customer Price Group” (conditional)

Pages and codeunits on this table

Page 1345 “Sales Price and Line Discounts” (source table)
Page 1347 “Sales Pr. & Line Disc. Part” (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: "Sales Price and Line Disc Buff"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.