Price Line Filters #7021

Pricing & Discounts table in Microsoft Dynamics 365 Business Central. 27 fields, 0 records in Cronus demo.

The Price Line Filters table (ID 7021) is part of the Pricing & Discounts area in Microsoft Dynamics 365 Business Central. It contains 27 fields, with a primary key of Primary Key. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Primary Key.

All fields (27)

Price Line Filters — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Primary Key PK	Code	Normal
2	Product Type	Option	Normal
3	Product Filter	Text	Normal
4	Table Id	Integer	Normal
5	Minimum Quantity	Decimal	Normal
6	Adjustment Factor	Decimal	Normal
7	Rounding Method Code	Code	Normal	→ Rounding Method #42
8	From Price List Code	Code	Normal	→ Price List Header #7000
9	To Price List Code	Code	Normal	→ Price List Header #7000
10	Price Type	Option	Normal
11	Assign-to Group	Option	Normal
12	Price Line Filter	Text	Normal
13	From Currency Code	Code	Normal
14	To Currency Code	Code	Normal
15	Amount Rounding Precision	Decimal	Normal
16	Exchange Rate Date	Date	Normal
17	Different Currencies	Boolean	Normal
18	Copy Price List	Boolean	Normal
19	Worksheet	Boolean	Normal
20	Copy as new lines	Boolean	Normal
21	Update Multiple Price Lists	Boolean	Normal
22	Use defaults from target	Boolean	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (3)

Tables referenced by fields on the Price Line Filters table through TableRelation properties.

Rounding Method

#42 · Sales Documents · via Rounding Method Code

Price List Header

#7000 · Pricing & Discounts · via From Price List Code, To Price List Code