Pricing & Discounts table in Microsoft Dynamics 365 Business Central. 27 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Primary Key.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Primary Key PK | Code | Normal | |
| 2 | Product Type | Option | Normal | |
| 3 | Product Filter | Text | Normal | |
| 4 | Table Id | Integer | Normal | |
| 5 | Minimum Quantity | Decimal | Normal | |
| 6 | Adjustment Factor | Decimal | Normal | |
| 7 | Rounding Method Code | Code | Normal | → Rounding Method #42 |
| 8 | From Price List Code | Code | Normal | → Price List Header #7000 |
| 9 | To Price List Code | Code | Normal | → Price List Header #7000 |
| 10 | Price Type | Option | Normal | |
| 11 | Assign-to Group | Option | Normal | |
| 12 | Price Line Filter | Text | Normal | |
| 13 | From Currency Code | Code | Normal | |
| 14 | To Currency Code | Code | Normal | |
| 15 | Amount Rounding Precision | Decimal | Normal | |
| 16 | Exchange Rate Date | Date | Normal | |
| 17 | Different Currencies | Boolean | Normal | |
| 18 | Copy Price List | Boolean | Normal | |
| 19 | Worksheet | Boolean | Normal | |
| 20 | Copy as new lines | Boolean | Normal | |
| 21 | Update Multiple Price Lists | Boolean | Normal | |
| 22 | Use defaults from target | Boolean | 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 Line Filters table through TableRelation properties.