Pricing & Discounts table in Microsoft Dynamics 365 Business Central. 16 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Code, Sales Code, Currency Code, Starting Date, Sales Type, Minimum Quantity, Type, Unit of Measure Code, Variant Code.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Code PK | Code | Normal | |
| 2 | Sales Code PK | Code | Normal | |
| 3 | Currency Code PK | Code | Normal | → Currency #4 |
| 4 | Starting Date PK | Date | Normal | |
| 5 | Line Discount % | Decimal | Normal | |
| 13 | Sales Type PK | Option | Normal | |
| 14 | Minimum Quantity PK | Decimal | Normal | |
| 15 | Ending Date | Date | Normal | |
| 21 | Type PK | Option | Normal | |
| 5400 | Unit of Measure Code PK | Code | Normal | |
| 5700 | Variant Code PK | Code | 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 Sales Line Discount table through TableRelation properties.