Table 7021 "Price Line Filters"

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

Properties

Property	Value
TableType	Temporary
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	Primary Key Δ BC26	Code[10]	—	DataClassification SystemMetadata
2	Asset Type Δ BC28	Enum “Price Asset Type”	Specifies the product type that defines the table being a source for the suggested price list lines.	enum Enum 7004 “Price Asset Type”; DataClassification SystemMetadata
3	Asset Filter	Text[2048]	Product Filter caption	DataClassification SystemMetadata
4	Table Id	Integer	—	DataClassification SystemMetadata
5	Minimum Quantity Δ BC28	Decimal	Specifies the default minimum quantity for the suggested lines. If you do not specify minimum qunatity, pricing will apply same price irrespective of quantity.	DataClassification SystemMetadata
6	Adjustment Factor Δ BC28	Decimal	Specifies an adjustment factor to multiply the amounts that you want to copy. By entering an adjustment factor, you can increase or decrease the amounts.	DataClassification SystemMetadata
7	Rounding Method Code Δ BC28	Code[10]	Specifies a rounding method code that you want applied to prices.	TableRelation Table 42 “Rounding Method” (Rounding Method); DataClassification SystemMetadata
8	From Price List Code Δ BC28	Code[20]	Specifies the price list code to copy lines from.	TableRelation Table 7000 “Price List Header” (Price List Header); DataClassification SystemMetadata
9	To Price List Code	Code[20]	—	TableRelation Table 7000 “Price List Header” (Price List Header); DataClassification SystemMetadata
10	Price Type	Enum “Price Type”	—	enum Enum 7009 “Price Type”; DataClassification SystemMetadata
11	Source Group	Enum “Price Source Group”	Assign-to Group caption	enum Enum 7002 “Price Source Group”; DataClassification SystemMetadata
12	Price Line Filter	Text[2048]	—	DataClassification SystemMetadata
13	From Currency Code	Code[10]	—	DataClassification SystemMetadata
14	To Currency Code	Code[10]	—	DataClassification SystemMetadata
15	Amount Rounding Precision Δ BC28	Decimal	—	DataClassification SystemMetadata
16	Exchange Rate Date Δ BC28	Date	Specifies a date for the currency exchange rate calculations.	DataClassification SystemMetadata
17	Different Currencies	Boolean	—	DataClassification SystemMetadata
18	Copy Lines	Boolean	Copy Price List caption	DataClassification SystemMetadata
19	Worksheet	Boolean	—	DataClassification SystemMetadata
20	Copy As New Lines Δ BC28	Boolean	Specifies if the suggested lines will become new lines in the target price list.	DataClassification SystemMetadata
21	Update Multiple Price Lists	Boolean	—	DataClassification SystemMetadata
22	Force Defaults Δ BC28	Boolean	Specifies whether to apply the values of the target price list header to the new lines instead of the values of the price list you are copying.	DataClassification SystemMetadata

Keys

PK: Primary Key

Events published

OnAfterSetFilterByFilterPageBuilder(TableCaptionValue: Text; var FilterValue: Text[2048]) (integration)
OnEditPriceLineFilterOnAfterSetFilterPageBuilder(TableCaptionValue: Text; PriceListLine: Record "Price List Line"; var FilterPageBuilder: FilterPageBuilder) (integration)

Procedures

Initialize(PriceListHeader: Record "Price List Header"; CopyLines: Boolean)
EditAssetFilter()
EditPriceLineFilter()

Plus 4 local procedures.

Relations

Rounding Method Code: TableRelation Table 42 “Rounding Method”
From Price List Code: TableRelation Table 7000 “Price List Header”
To Price List Code: TableRelation Table 7000 “Price List Header”

Pages and codeunits on this table

Page 7021 “Suggest Price Lines” (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: "Price Line Filters"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.