Purchase Line Discount #7014

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

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: Item No., Vendor No., Currency Code, Starting Date, Minimum Quantity, Unit of Measure Code, Variant Code.

All fields (14)

Purchase Line Discount — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Item No. PK	Code	Normal	→ Item #27
2	Vendor No. PK	Code	Normal	→ Vendor #23
3	Currency Code PK	Code	Normal	→ Currency #4
4	Starting Date PK	Date	Normal
5	Line Discount %	Decimal	Normal
11	Minimum Quantity PK	Decimal	Normal
15	Ending Date	Date	Normal
5400	Unit of Measure Code PK	Code	Normal	→ Item Unit of Measure #5404
5700	Variant Code PK	Code	Normal	→ Item Variant #5401
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 Purchase Line Discount table through TableRelation properties.

Item

#27 · Inventory · via Item No.

Vendor

#23 · Purchasing · via Vendor No.

Currency

#4 · General Ledger · via Currency Code

Item Unit of Measure

#5404 · Other · via Unit of Measure Code

Item Variant

#5401 · Other · via Variant Code