JobCostingDirectCosts - Direct costs for a specific job.
Child table of JobCostings table.
| Column | Type | Notes |
|---|---|---|
| CompanyNumberJobNumberDirectCostCode | TEXT | Tugger created column combining: CompanyNumber, JobNumber, DirectCostCod |
| CompanyNumber | WHOLE NUMBER | |
| CostPrice | DECIMAL NUMBER | |
| DirectCostCode | TEXT | |
| DirectCostDescription | TEXT | |
| EstimatedQuantity | DECIMAL NUMBER | |
| JobNumber | WHOLE NUMBER | |
| LastEditTime | TEXT | |
| RevisedEstimatedQty | DECIMAL NUMBER | |
| SalePrice | DECIMAL NUMBER | |
| UsedQuantity | DECIMAL NUMBER | |
| LastEditDate | DATETIME | |
| Deleted | BINARY |