SpecialPrices
less than a minute
The table SpecialPrices stores the special prices of a project.
| Name | Type | Size | Property |
|---|---|---|---|
| ArticleCode | String | 255 | ArticleCode |
| Color | String | 255 | Color of the Article |
| LK_ProjectId | Long Integer | 4 | LOOKUP KEY refers to Projects.ProjectId |
| Price | Double | 8 | The special price. (only valid if SpecialPriceType is 0) |
| SpecialPriceId | Long Integer | 4 | PRIMARY KEY |
| PriceCurrency | String | 255 | Currency of the special price |
| PriceClass | String | 255 | PriceClass of the article (only valid if SpecialPriceType is 2) |
| DIscount | Double | 8 | Discount of the article (only valid if SpecialPriceType is 1 or 2) |
| SpecialPriceType | Integer | 4 | Type of the Special Price - see SpecialPriceType |