JobCosting
| Column | Type | Notes |
|---|---|---|
| AcceptedMargin | DECIMAL NUMBER | |
| AcceptedValue | DECIMAL NUMBER | |
| ActualCommencementDate | DATETIME | |
| BalanceToInvoice | DECIMAL NUMBER | |
| CompanyNumberJobNo | TEXT | Tugger created column combining: CompanyNumber, JobNo |
| CompanyNumber | WHOLE NUMBER | |
| CustomerNo | TEXT | |
| DirectCostsActual | DECIMAL NUMBER | |
| Invoice1ActualDate | DATETIME | |
| Invoice1PlanDate | DATETIME | |
| Invoice1Value | DECIMAL NUMBER | |
| Invoice2ActualDate | DATETIME | |
| Invoice2PlanDate | DATETIME | |
| Invoice2Value | DECIMAL NUMBER | |
| Invoice3ActualDate | DATETIME | |
| Invoice3PlanDate | DATETIME | |
| Invoice3Value | DECIMAL NUMBER | |
| Invoice4ActualDate | DATETIME | |
| Invoice4PlanDate | DATETIME | |
| Invoice4Value | DECIMAL NUMBER | |
| Invoice5ActualDate | DATETIME | |
| Invoice5PlanDate | DATETIME | |
| Invoice5Value | DECIMAL NUMBER | |
| InvoicedComments | TEXT | |
| InvoicedValue | DECIMAL NUMBER | |
| Invoices1To5TotalValue | DECIMAL NUMBER | |
| JobCreatedDate | DATETIME | |
| JobNumber | WHOLE NUMBER | |
| JobStatus | TEXT | |
| JobTitle | TEXT | |
| JobType | TEXT | |
| OnHold_YN | TEXT | |
| OriginalEstimatedCost | DECIMAL NUMBER | |
| OtherInvoicedValue | DECIMAL NUMBER | |
| PlannedCommencementDate | DATETIME | |
| PlannedCompExclCommisDate | DATETIME | |
| PlannedCompIncCommisDate | DATETIME | |
| ProductCostsActual | DECIMAL NUMBER | |
| ProjectManager | TEXT | |
| QuoteReference | TEXT | |
| RetentionAmount | DECIMAL NUMBER | |
| RevisedEstimatedCost | DECIMAL NUMBER | |
| RevisedMargin | DECIMAL NUMBER | |
| RevisedSalesValue | DECIMAL NUMBER | |
| SiteID | TEXT | |
| LastEditDate | DATETIME | |
| Deleted | BINARY |