JobCostingProducts
| Column | Type | Notes |
|---|---|---|
| CompanyNumberJobNumberProductCodeLineNo | TEXT | Tugger created column combining: CompanyNumber, JobNumber, ProductCode, LineNo |
| CompanyNumber | WHOLE NUMBER | |
| CostPrice | DECIMAL NUMBER | |
| EstimatedQuantity | DECIMAL NUMBER | |
| IssuedFromReserveQty | DECIMAL NUMBER | |
| IssuedQuantity | DECIMAL NUMBER | |
| JobNumber | WHOLE NUMBER | |
| LastEditTime | TEXT | |
| LineNo | WHOLE NUMBER | |
| PreferredSupplierCode | TEXT | |
| ProductCode | TEXT | |
| ProductDescription | TEXT | |
| ReservedQuantity | DECIMAL NUMBER | |
| RevisedEstimatedQty | DECIMAL NUMBER | |
| SalePrice | DECIMAL NUMBER | |
| SundryOrMiscOrProduct | TEXT | |
| LastEditDate | DATETIME | |
| Deleted | BINARY |