Table 5365 CRM Discount in 21
- App
- Base Application
Versions171819202122232425262728latest
Source29
Fields, 27
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | DiscountId | Guid | - |
| 2 | DiscountTypeId | Guid | - |
| 3 | LowQuantity | Decimal | - |
| 4 | HighQuantity | Decimal | - |
| 5 | Percentage | Decimal | - |
| 6 | Amount | Decimal | - |
| 7 | StatusCode | Option | - |
| 8 | CreatedOn | DateTime | - |
| 9 | CreatedBy | Guid | - |
| 10 | ModifiedBy | Guid | - |
| 11 | ModifiedOn | DateTime | - |
| 12 | DiscountTypeIdName | Text[100] | - |
| 13 | IsAmountType | Boolean | - |
| 14 | CreatedByName | Text[200] | - |
| 15 | ModifiedByName | Text[200] | - |
| 16 | VersionNumber | BigInteger | - |
| 17 | OrganizationId | Guid | - |
| 18 | OverriddenCreatedOn | Date | - |
| 19 | TransactionCurrencyId | Guid | - |
| 20 | ExchangeRate | Decimal | - |
| 21 | ImportSequenceNumber | Integer | - |
| 22 | Amount_Base | Decimal | - |
| 23 | TransactionCurrencyIdName | Text[100] | - |
| 24 | CreatedOnBehalfBy | Guid | - |
| 25 | CreatedOnBehalfByName | Text[200] | - |
| 26 | ModifiedOnBehalfBy | Guid | - |
| 27 | ModifiedOnBehalfByName | Text[200] | - |
Keys, 1
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | DiscountId | - |