CalcDetailItems
less than a minute
This table stores all calculated costs.
| Name | Type | Size | Description |
|---|---|---|---|
| AddOn | Double | 8 | |
| CalcDetailItemID | Long Integer | 4 | PRIMARY KEY |
| Commission | Double | 8 | |
| ElevationId | Long Integer | 4 | FOREIGN KEY refers to Elevations.ElevationID |
| Gross | Double | 8 | |
| GrossInclMult | Double | 8 | |
| Interest | Double | 8 | |
| LK_DetailId | Long Integer | 4 | LOOKUP KEY refers to CalcDetailNames.CalcDetailNameID |
| LK_ItemId | Long Integer | 4 | LOOKUP KEY refers to CalcItemNames.CalcDetailItemNameID |
| Net | Double | 8 | |
| Overheads | Double | 8 | |
| PlanningOffice | Double | 8 | |
| Profit | Double | 8 | |
| ProfitByDiscountGroup | Double | 8 | |
| SalesAndManagement | Double | 8 | |
| SurchargeCashDiscount | Double | 8 | |
| Total | Double | 8 | |
| Transport | Double | 8 |