| Name | Description | Type | Additional information |
|---|---|---|---|
| CompanyId | integer |
None. |
|
| ProjectName | string |
None. |
|
| ProjectIsTemplate | boolean |
None. |
|
| JobsInProject | integer |
None. |
|
| ArchiveFolderId | integer |
None. |
|
| FolderName | string |
None. |
|
| JobKey | globally unique identifier |
None. |
|
| JobName | string |
None. |
|
| DirectoryNote | string |
None. |
|
| JobNote | string |
None. |
|
| QuoteNumber | string |
None. |
|
| JobNumber | string |
None. |
|
| JobDate | date |
None. |
|
| JobStatus | string |
None. |
|
| SaveMaterials | boolean |
None. |
|
| CreatedDate | date |
None. |
|
| CreatedBy | string |
None. |
|
| AlertsCurrent | boolean |
None. |
|
| ExportHistory | string |
None. |
|
| LockedDate | date |
None. |
|
| LockedBy | string |
None. |
|
| tbl_SP_UserName | string |
None. |
|
| JobColor | string |
None. |
|
| FlagColor | integer |
None. |
|
| tbl_FU_UserName | string |
None. |
|
| FlagDate | date |
None. |
|
| FlagNotes | string |
None. |
|
| PurchaseOrder | string |
None. |
|
| SplitQuote | boolean |
None. |
|
| ScenarioName | string |
None. |
|
| LastModifiedDate | date |
None. |
|
| Status | integer |
None. |
|
| ClientName | string |
None. |
|
| tblClients_ContactName | string |
None. |
|
| Salutation | string |
None. |
|
| tblClients_Street | string |
None. |
|
| tblClients_Suburb | string |
None. |
|
| tblClients_City | string |
None. |
|
| tblClients_State | string |
None. |
|
| tblClients_Zip | string |
None. |
|
| ReferredBy | string |
None. |
|
| tblClients_Phone | string |
None. |
|
| Fax | string |
None. |
|
| tblClients_Mobile | string |
None. |
|
| string |
None. |
||
| CompanyNumber | string |
None. |
|
| ClientNote | string |
None. |
|
| IsOwner | boolean |
None. |
|
| Pay1Percent | integer |
None. |
|
| Pay2Percent | integer |
None. |
|
| Pay2Days | integer |
None. |
|
| Terms2 | integer |
None. |
|
| Pay3Days | integer |
None. |
|
| Terms3 | integer |
None. |
|
| tblClients_Discount | decimal number |
None. |
|
| Tag | string |
None. |
|
| CustId | string |
None. |
|
| tblClientContacts_ContactName | string |
None. |
|
| tblClientContacts_Salutation | string |
None. |
|
| Role | string |
None. |
|
| tblClientContacts_Phone | string |
None. |
|
| tblClientContacts_Fax | string |
None. |
|
| tblClientContacts_Mobile | string |
None. |
|
| tblClientContacts_Tag | string |
None. |
|
| tblClientContacts_Email | string |
None. |
|
| tblClientContacts_UserField | string |
None. |
|
| MeasureDate | date |
None. |
|
| SiteContact | string |
None. |
|
| tblSites_Street | string |
None. |
|
| tblSites_Suburb | string |
None. |
|
| tblSites_City | string |
None. |
|
| tblSites_State | string |
None. |
|
| tblSites_Zip | string |
None. |
|
| MapRef | string |
None. |
|
| CrossStreet | string |
None. |
|
| tblSites_Phone | string |
None. |
|
| IsNewHome | boolean |
None. |
|
| MeasureNote | string |
None. |
|
| tblSites_Mobile | string |
None. |
|
| SiteNote | string |
None. |
|
| DisposeDate | date |
None. |
|
| DisposeMode | integer |
None. |
|
| ScheduleDate | date |
None. |
|
| ScheduleDate2 | date |
None. |
|
| TravelHours | integer |
None. |
|
| TravelDollars | decimal number |
None. |
|
| TravelHoursB | integer |
None. |
|
| TravelDollarsB | decimal number |
None. |
|
| UpperFloor | integer |
None. |
|
| LowerFloor | integer |
None. |
|
| Stain | boolean |
None. |
|
| WePaint | boolean |
None. |
|
| Cupboard | integer |
None. |
|
| WeCutFloor | boolean |
None. |
|
| WeCutWall | boolean |
None. |
|
| BrickUpper | boolean |
None. |
|
| BrickLower | boolean |
None. |
|
| PowerOn | boolean |
None. |
|
| ReMeasure | boolean |
None. |
|
| Briefing | boolean |
None. |
|
| FromPlan | boolean |
None. |
|
| DetailsNote | string |
None. |
|
| RequiresCnc | boolean |
None. |
|
| CncScheduleDate | date |
None. |
|
| TreadProtect | boolean |
None. |
|
| CncDone | boolean |
None. |
|
| MatNet | decimal number |
None. |
|
| LabNet | decimal number |
None. |
|
| LabLoad | integer |
None. |
|
| LabPrepMins | integer |
None. |
|
| LabTurnMins | integer |
None. |
|
| LabDelvMins | integer |
None. |
|
| LabConsMins | integer |
None. |
|
| LabInstMins | integer |
None. |
|
| LabCNCMins | integer |
None. |
|
| LabPrepMins_LabTurnMins_LabDelvMins_LabConsMins_LabInstMins_LabCNCMins | integer |
None. |
|
| LabPrepMins_LabTurnMins_LabConsMins_LabCNCMins | integer |
None. |
|
| MatTotal | decimal number |
None. |
|
| LabTotal | decimal number |
None. |
|
| TruckTotal | decimal number |
None. |
|
| OHeadTotal | decimal number |
None. |
|
| NetPlusProfit | decimal number |
None. |
|
| TaxPercent1 | decimal number |
None. |
|
| TaxPercent2 | decimal number |
None. |
|
| LabMatPW | decimal number |
None. |
|
| OHeadPW | decimal number |
None. |
|
| ProfitPercent | decimal number |
None. |
|
| tblQuotations_Discount | decimal number |
None. |
|
| GrandTotal | decimal number |
None. |
|
| Freeze | boolean |
None. |
|
| DueAmt1 | decimal number |
None. |
|
| DueAmt2 | decimal number |
None. |
|
| DueAmt3 | decimal number |
None. |
|
| DeliverNet | decimal number |
None. |
|
| InstallNet | decimal number |
None. |
|
| BalanceDue | decimal number |
None. |
|
| PaidAmt1 | decimal number |
None. |
|
| PaidAmt2 | decimal number |
None. |
|
| PaidAmt3 | decimal number |
None. |
|
| PaidDate1 | date |
None. |
|
| PaidDate2 | date |
None. |
|
| PaidDate3 | date |
None. |
|
| PayType1 | string |
None. |
|
| PayType2 | string |
None. |
|
| PayType3 | string |
None. |
|
| PayDetail1 | string |
None. |
|
| PayDetail2 | string |
None. |
|
| PayDetail3 | string |
None. |