Price Line Filters #7021

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

27
Fields
0
Records
1
Primary key
0
FlowFields
5
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.FIELDTYPECLASSRELATION
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