Price Worksheet Line #7022

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

Fields

Records

Primary key

FlowFields

Relations

Primary key

The primary key uniquely identifies each record in this table. It consists of: Price List Code, Line No., Existing Line.

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

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