Price Worksheet Line #7022

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

The Price Worksheet Line table (ID 7022) is part of the Pricing & Discounts area in Microsoft Dynamics 365 Business Central. It contains 46 fields, with a primary key of Price List Code, Line No., Existing Line. 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: Price List Code, Line No., Existing Line.

All fields (46)

Price Worksheet Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Price List Code PK	Code	Normal	→ Price List Header #7000
2	Line No. PK	Integer	Normal
3	Assign-to Type	Option	Normal
4	Assign-to No.	Code	Normal
5	Assign-to Parent No.	Code	Normal
6	Assign-to ID	GUID	Normal
7	Product Type	Option	Normal
8	Product No.	Code	Normal
9	Variant Code	Code	Normal
10	Currency Code	Code	Normal	→ Currency #4
11	Work Type Code	Code	Normal	→ Work Type #200
12	Starting Date	Date	Normal
13	Ending Date	Date	Normal
14	Minimum Quantity	Decimal	Normal
15	Unit of Measure Code	Code	Normal
16	Defines	Option	Normal
17	Unit Price	Decimal	Normal
18	Cost Factor	Decimal	Normal
19	Unit Cost	Decimal	Normal
20	Line Discount %	Decimal	Normal
21	Allow Line Disc.	Boolean	Normal
22	Allow Invoice Disc.	Boolean	Normal
23	Price Includes VAT	Boolean	Normal
24	VAT Bus. Posting Gr. (Price)	Code	Normal	→ VAT Business Posting Group #323
25	VAT Prod. Posting Group	Code	Normal	→ VAT Product Posting Group #324
26	Asset ID	GUID	Normal
27	Line Amount	Decimal	Normal
28	Price Type	Option	Normal
29	Description	Text	Normal
30	Status	Option	Normal
31	Direct Unit Cost	Decimal	Normal
32	Source Group	Option	Normal
33	Product No.	Code	Normal
34	Assign-to No.	Code	Normal
35	Assign-to Parent No.	Code	Normal
36	Variant Code	Code	Normal
37	Unit of Measure Code	Code	Normal
100	Existing Line PK	Boolean	Normal
101	Existing Unit Price	Decimal	Normal
102	Existing Direct Unit Cost	Decimal	Normal
103	Existing Unit Cost	Decimal	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 (6)

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

Price List Header

#7000 · Pricing & Discounts · via Price List Code

Currency

#4 · General Ledger · via Currency Code

Work Type

#200 · Other · via Work Type Code

VAT Business Posting Group

#323 · Other · via VAT Bus. Posting Gr. (Price)

VAT Product Posting Group

#324 · Other · via VAT Prod. Posting Group