Pricing & Discounts table in Microsoft Dynamics 365 Business Central. 16 fields, 0 records in Cronus demo.
The Sales Line Discount table (ID 7004) is part of the Pricing & Discounts area in Microsoft Dynamics 365 Business Central. It contains 16 fields, with a primary key of Code, Sales Code, Currency Code, Starting Date, Sales Type, Minimum Quantity, Type, 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: 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.