Pricing & Discounts table in Microsoft Dynamics 365 Business Central. 14 fields, 0 records in Cronus demo.
The Purchase Line Discount table (ID 7014) is part of the Pricing & Discounts area in Microsoft Dynamics 365 Business Central. It contains 14 fields, with a primary key of Item No., Vendor No., Currency Code, Starting Date, Minimum Quantity, Unit of Measure Code, Variant Code. Use the reference below to explore every field, data type, and table relation.
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.
| 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 |
Tables referenced by fields on the Purchase Line Discount table through TableRelation properties.