| Name | Description | Type | Additional information |
|---|---|---|---|
| JobID | integer |
None. |
|
| TemplateName | string |
None. |
|
| JobNo | string |
None. |
|
| ActiveJob | integer |
None. |
|
| Suburb | string |
None. |
|
| Estate | string |
None. |
|
| JobCreatedDate | date |
None. |
|
| CreatedBy | string |
None. |
|
| BA | string |
None. |
|
| PP | string |
None. |
|
| RPSP | string |
None. |
|
| SpekHome | boolean |
None. |
|
| BasixNo | string |
None. |
|
| StreetNo | string |
None. |
|
| Postcode | string |
None. |
|
| JobState | string |
None. |
|
| Start | date |
None. |
|
| IsLand | boolean |
None. |
|
| IsTownhouse | boolean |
None. |
|
| Source | string |
None. |
|
| JobOnHoldDuration | integer |
None. |
|
| IsHandoverCountdown | boolean |
None. |
|
| ConstructionNotificationNo | string |
None. |
|
| Status | string |
None. |
|
| JobOnHold | string |
None. |
|
| JobHoldUpCount | integer |
None. |
|
| HouseDesign | string |
None. |
|
| IsPriceCheck | boolean |
None. |
|
| IsSalesSpecCheck | boolean |
None. |
|
| IsPlanCheck | boolean |
None. |
|
| IsSiteSpecCheck | boolean |
None. |
|
| IsSummaryCheck | boolean |
None. |
|
| SpekHomeWithChild | boolean |
None. |
|
| SpekHomeWithParent | boolean |
None. |
|
| IsConfirmCommission | boolean |
None. |
|
| ColourExternal | string |
None. |
|
| DoNotRent | boolean |
None. |
|
| Latitude | decimal number |
None. |
|
| Longitude | decimal number |
None. |
|
| IsLandSourceByReferrer | boolean |
None. |
|
| ColourInternal | string |
None. |
|
| NoHOW | integer |
None. |
|
| CurrentProfitReal | decimal number |
None. |
|
| IsPO6Sent | boolean |
None. |
|
| IsHouseRentedCompleted | boolean |
None. |
|
| IsPO6Received | boolean |
None. |
|
| RegoCost | decimal number |
None. |
|
| LandExpiryDate | date |
None. |
|
| IsSalesStatusConfirm | boolean |
None. |
|
| PreliminaryAgreement | decimal number |
None. |
|
| IsDARequired | string |
None. |
|
| KPI_WD | integer |
None. |
|
| KPI_BA | integer |
None. |
|
| KPI_Lock | integer |
None. |
|
| Diff_Slab | integer |
None. |
|
| Diff_FG | integer |
None. |
|
| Diff_Plaster | integer |
None. |
|
| Diff_PT | integer |
None. |
|
| Diff_Landscaping | integer |
None. |
|
| Diff_FT | integer |
None. |
|
| Diff_H1 | integer |
None. |
|
| Diff_H2 | integer |
None. |
|
| Diff_Footing | integer |
None. |
|
| Diff_Tiling | integer |
None. |
|
| Diff_PC | integer |
None. |
|
| Diff_Footing_ST | integer |
None. |
|
| Diff_Slab_ST | integer |
None. |
|
| Diff_FG_ST | integer |
None. |
|
| Diff_Plaster_ST | integer |
None. |
|
| Diff_Tiling_ST | integer |
None. |
|
| Diff_PT_ST | integer |
None. |
|
| Diff_Landscaping_ST | integer |
None. |
|
| Diff_FT_ST | integer |
None. |
|
| Diff_PC_ST | integer |
None. |
|
| Diff_H1_ST | integer |
None. |
|
| Diff_H2_ST | integer |
None. |
|
| IsBushfireZone | boolean |
None. |
|
| IsFloodZone | boolean |
None. |
|
| IsCertificationCheck | boolean |
None. |
|
| HardHoldDays | integer |
None. |
|
| LicenceNoORACNNoInDoBSAInsuranceDoc | string |
None. |
|
| TStartCertificationBANewBuildingWD | integer |
None. |
|
| TStartCertificationBANewBuilding | integer |
None. |
|
| ContractPriceNote | decimal number |
None. |
|
| IsOwnerOccupier | boolean |
None. |
|
| WorkDays | integer |
None. |
|
| LandFounder | string |
None. |
|
| ParentJobID | integer |
None. |
|
| NotifyClientColourSelection | boolean |
None. |
|
| IsHSTP | boolean |
None. |
|
| DCCompleteDate | date |
None. |
|
| DepositHolderName | string |
None. |
|
| BuilderAllocated | string |
None. |
|
| TownhouseUnit | integer |
None. |
|
| IsMainSibling | boolean |
None. |
|
| Finance | string |
None. |
|
| FinanceEmail | string |
None. |
|
| Grouping | string |
None. |
|
| Broker | string |
None. |
|
| FinBrokerContact | string |
None. |
|
| FinBrokerMobile | string |
None. |
|
| FinBrokerEmail | string |
None. |
|
| Conveyancer | string |
None. |
|
| Client1Info | string |
None. |
|
| Client1Client2 | string |
None. |
|
| Client1Name | string |
None. |
|
| Client1Mobile | string |
None. |
|
| Client2Name | string |
None. |
|
| ClientPhone | string |
None. |
|
| ClientEmail | string |
None. |
|
| ClientAddress | string |
None. |
|
| RentalRentRange | string |
None. |
|
| RentalLeaseStart | date |
None. |
|
| RentalLeaseEnd | date |
None. |
|
| RentalRentRate | decimal number |
None. |
|
| RentalTenancyAgreement | boolean |
None. |
|
| IsPMLocked | boolean |
None. |
|
| MaxSizeOfHouse | decimal number |
None. |
|
| CostCovenant | decimal number |
None. |
|
| SalePrice | decimal number |
None. |
|
| LandPrice | decimal number |
None. |
|
| Commission | decimal number |
None. |
|
| AdditionalCommission | decimal number |
None. |
|
| ContractPrice | decimal number |
None. |
|
| CostPerM2 | decimal number |
None. |
|
| BuildPrice | decimal number |
None. |
|
| LandSize | decimal number |
None. |
|
| NetLandPrice | decimal number |
None. |
|
| LandFrontage | decimal number |
None. |
|
| Bed | integer |
None. |
|
| Bath | decimal number |
None. |
|
| Garage | integer |
None. |
|
| HousePrice | decimal number |
None. |
|
| SiteCost | decimal number |
None. |
|
| MarketerCost | decimal number |
None. |
|
| LandProfitHouseDesignTab | decimal number |
None. |
|
| LandProfitHouseDesignTabIncGST | decimal number |
None. |
|
| IsHouseOnly | boolean |
None. |
|
| ContractPriceHouseDesign | decimal number |
None. |
|
| PCCompany | string |
None. |
|
| SalesSpecCost | decimal number |
None. |
|
| ReduceContract | decimal number |
None. |
|
| Discount | decimal number |
None. |
|
| Land_Rebate | decimal number |
None. |
|
| LandProfitOffset | decimal number |
None. |
|
| RentalGuarantee | decimal number |
None. |
|
| ExternalCommission | decimal number |
None. |
|
| InternalCommission | decimal number |
None. |
|
| AdjustAfterScan | decimal number |
None. |
|
| CommissionCheck | integer |
None. |
|
| ContractPriceDiff | integer |
None. |
|
| DiscountAfterContract | decimal number |
None. |
|
| EstateFolder | string |
None. |
|
| SiteAccessEarlyDate | date |
None. |
|
| IsAsConstructedData | boolean |
None. |
|
| IsSubdivisionApproval | boolean |
None. |
|
| IsBushfireReport | boolean |
None. |
|
| IsAcousticReport | boolean |
None. |
|
| IsPlanOfDevelopment | boolean |
None. |
|
| CovenantContact | string |
None. |
|
| Region | string |
None. |
|
| JobArea | string |
None. |
|
| DivisionName | string |
None. |
|
| BuilderACNNo | string |
None. |
|
| BuilderLicenceNo | string |
None. |
|
| Council | string |
None. |
|
| BankPayout | decimal number |
None. |
|
| BankPayoutHL | decimal number |
None. |
|
| JoiiLoan | decimal number |
None. |
|
| LandRebate | decimal number |
None. |
|
| ImpactFunds | decimal number |
None. |
|
| GST | decimal number |
None. |
|
| ImpactContribution | decimal number |
None. |
|
| BreakEvenSalePrice | decimal number |
None. |
|
| MarginScheme | decimal number |
None. |
|
| IsFinanceConfirm | boolean |
None. |
|
| MinNetPrice | decimal number |
None. |
|
| BreakEvenSalePriceAuto | decimal number |
None. |
|
| ImpactFundHL | decimal number |
None. |
|
| SpekEquity | decimal number |
None. |
|
| OriginalProfit | decimal number |
None. |
|
| LastCompletedTask | string |
None. |
|
| NextTask | string |
None. |
|
| CurrentTask | string |
None. |
|
| ActualIncome | decimal number |
None. |
|
| ActualIncomeIncGST | decimal number |
None. |
|
| ActualExpense | decimal number |
None. |
|
| ActualExpenseIncGST | decimal number |
None. |
|
| CashFlowWIPLastMonth | decimal number |
None. |
|
| ProfitClaimToday_LastMonth | decimal number |
None. |
|
| ProfitClaimToday_Current | decimal number |
None. |
|
| ActualIncomePaid | decimal number |
None. |
|
| ActualExpensePaid | decimal number |
None. |
|
| ClaimNotLive | decimal number |
None. |
|
| ContractPriceClaim | decimal number |
None. |
|
| ClaimNotPaid | decimal number |
None. |
|
| OrderNotInvoiced | decimal number |
None. |
|
| OrderNotPaid | decimal number |
None. |
|
| PlasterboardSupplier | string |
None. |
|
| CeilingInsulationSupplier | string |
None. |
|
| WaterTankSupplier | string |
None. |
|
| AirConFitOffSupplier | string |
None. |
|
| EnergyEfficientRatingSupplier | string |
None. |
|
| FasciaGutterSupplier | string |
None. |
|
| FasciaGutterColourbondSupplier | string |
None. |
|
| RoofTrussesSupplier | string |
None. |
|
| GarageDoorSupplier | string |
None. |
|
| LowerRoofSupplier | string |
None. |
|
| LightFittingSupplier | string |
None. |
|
| TimberGroundFloorSupplier | string |
None. |
|
| ReqPlumberFitOffSupplier | string |
None. |
|
| ReqPainterInternalSupplier | string |
None. |
|
| BANewBuildingApplicationSupplier | string |
None. |
|
| DoSurveyPlanOfBlockSupplier | string |
None. |
|
| DoFinishingTouchesSupplier | string |
None. |
|
| DoEngSlabDesignSupplier | string |
None. |
|
| ReqDrivewayConcretorSupplier | string |
None. |
|
| ReqDrivewayPrepSupplier | string |
None. |
|
| ReqPrenailFrameAndTrussesSupplier | string |
None. |
|
| CovenantApprovalDuration | integer |
None. |
|
| DoWaterConnectionDuration | integer |
None. |
|
| PaidConsultationFee | decimal number |
None. |
|
| Claim0Live | boolean |
None. |
|
| Claim1Live | boolean |
None. |
|
| Claim2Live | boolean |
None. |
|
| Claim3Live | boolean |
None. |
|
| Claim4Live | boolean |
None. |
|
| Claim5Live | boolean |
None. |
|
| Claim0ClaimDate | date |
None. |
|
| Claim1ClaimDate | date |
None. |
|
| Claim2ClaimDate | date |
None. |
|
| Claim3ClaimDate | date |
None. |
|
| Claim4ClaimDate | date |
None. |
|
| Claim5ClaimDate | date |
None. |
|
| Claim0DueDate | date |
None. |
|
| Claim1DueDate | date |
None. |
|
| Claim2DueDate | date |
None. |
|
| Claim3DueDate | date |
None. |
|
| Claim4DueDate | date |
None. |
|
| Claim5DueDate | date |
None. |
|
| Claim0OverDue | integer |
None. |
|
| Claim1OverDue | integer |
None. |
|
| Claim2OverDue | integer |
None. |
|
| Claim3OverDue | integer |
None. |
|
| Claim4OverDue | integer |
None. |
|
| ClaimConsultationFeeAmount | decimal number |
None. |
|
| LandProfit | decimal number |
None. |
|
| LandProfitIncGST | decimal number |
None. |
|
| ClaimVariation | decimal number |
None. |
|
| ActualIncomeWeeklyPaid | decimal number |
None. |
|
| Claim0Outstanding | decimal number |
None. |
|
| Claim1Outstanding | decimal number |
None. |
|
| Claim2Outstanding | decimal number |
None. |
|
| Claim3Outstanding | decimal number |
None. |
|
| Claim4Outstanding | decimal number |
None. |
|
| Claim5Outstanding | decimal number |
None. |
|
| CashFlowWIP | decimal number |
None. |
|
| CashFlowWIPPaid | decimal number |
None. |
|
| TotalProfit | decimal number |
None. |
|
| TotalProfitAfterMarketer | decimal number |
None. |
|
| DifferentOriginalProfitToCurrentProfit | decimal number |
None. |
|
| WIPExcludeJobAtPC | decimal number |
None. |
|
| PayLicenseFeePaid | decimal number |
None. |
|
| PayOverheadsFeeOrder | decimal number |
None. |
|
| NetProfitAfterMarketer | decimal number |
None. |
|
| DepositNetTaxAmount | decimal number |
None. |
|
| DepositBoostMargin | decimal number |
None. |
|
| SupervisorID | integer |
None. |
|
| QualityControlID | integer |
None. |
|
| CommsToBePaid | decimal number |
None. |
|
| NetImpactFunds | decimal number |
None. |
|
| EquivalentContract | integer |
None. |
|
| SalesAdditionalType | string |
None. |
|
| JobType | string |
None. |
|
| ConstructionType | string |
None. |
|
| TitleOptions | string |
None. |
|
| AccountManager | string |
None. |
|
| PreAccountManager | string |
None. |
|
| TeamManager | string |
None. |
|
| Supervisor | string |
None. |
|
| QualityControl | string |
None. |
|
| SalesBrand | string |
None. |
|
| HouseWeight | decimal number |
None. |
|
| DepositBoostRequired | decimal number |
None. |
|
| PutCallSunsetDate | date |
None. |
|
| DemolitionRequired | string |
None. |
|
| Erosion | decimal number |
None. |
|
| ErosionPercentage | decimal number |
None. |
|
| ErosionFromRollover | decimal number |
None. |
|
| ProfitLastLocked | decimal number |
None. |
|
| TabName | string |
None. |
|
| SalesCategory | string |
None. |
|
| SalesCategoryID | integer |
None. |
|
| HoldingDepositGeneralMore | decimal number |
None. |
|
| TotalMarketingPaid | decimal number |
None. |
|
| LandDepth | decimal number |
None. |
|
| LandIsCornerLot | boolean |
None. |
|
| IsTenanted | boolean |
None. |
|
| ErosionDifferentFromLastMonth | decimal number |
None. |
|
| HomeLength | decimal number |
None. |
|
| HomeWidth | decimal number |
None. |
|
| DropOffWIP | boolean |
None. |
|
| MarketReduction | decimal number |
None. |
|
| IsResellContracts | boolean |
None. |
|
| IsResellUnconditional | boolean |
None. |
|
| DCCompleteBy | string |
None. |
|
| BuilderBoostStartDate | date |
None. |
|
| IsPreSale | boolean |
None. |
|
| CertificationCoordinator | string |
None. |
|
| IsFastract | boolean |
None. |
|
| CopyOrderQtyFrom | string |
None. |
|
| DoHomeWarrantyInsuranceExpiry | date |
None. |
|
| IsReadyForClientCheck | boolean |
None. |
|
| CouncilWorkflow | string |
None. |
|
| HouseCategory | string |
None. |
|
| HouseDesignGroup | string |
None. |
|
| DesignType | string |
None. |
|
| CurrentExpenses | decimal number |
None. |
|
| UnconProjection | boolean |
None. |
|
| ContractProjection | boolean |
None. |
|
| CurrentExpensesIncGST | decimal number |
None. |
|
| RiskFee | decimal number |
None. |
|
| IsUnrealFileExist | boolean |
None. |
|
| PayInternalSalesCommPaid | decimal number |
None. |
|
| PayMarketingCostAddPaid | decimal number |
None. |
|
| PaySalesCommissionPaid | decimal number |
None. |
|
| PayMarketingCostExtPaid | decimal number |
None. |
|
| IsNotInkFile | boolean |
None. |
|
| ProfitDifference | decimal number |
None. |
|
| PriviumConveyancer | string |
None. |
|
| GrossProfitOriginal | decimal number |
None. |
|
| GrossProfitPercentOriginal | decimal number |
None. |
|
| GrossProfitLive | decimal number |
None. |
|
| GrossProfitPercentLive | decimal number |
None. |
|
| FutureQC | string |
None. |
|
| ActiveLockExpenseExGst | decimal number |
None. |
|
| CertificationSpecCost | decimal number |
None. |
|
| RockAllowanceCost | decimal number |
None. |
|
| ClaimsInJob | decimal number |
None. |
|
| ClaimLive | decimal number |
None. |
|
| OrdersInJob | decimal number |
None. |
|
| OrderInvoiced | decimal number |
None. |
|
| AccrualClaim | decimal number |
None. |
|
| AccrualInvoice | decimal number |
None. |
|
| AccrualPosition | decimal number |
None. |
|
| CashFlowClaim | decimal number |
None. |
|
| CashFlowInvoice | decimal number |
None. |
|
| CashFlowPosition | decimal number |
None. |
|
| ReqKitchenSupplier | string |
None. |
|
| ClaimLiveNotPaid | decimal number |
None. |
|
| ToPaidCashFlowInvoice | decimal number |
None. |
|
| ToPaidCashFlowPosition | decimal number |
None. |
|
| GrossProfitLiveOGasDirectCost | decimal number |
None. |
|
| OpenGoldOrders | decimal number |
None. |
|
| DAReason | string |
None. |
|
| GrossProfitForecast | decimal number |
None. |
|
| GrossProfitForecastFigure | decimal number |
None. |
|
| InvoiceBalanceOwing | decimal number |
None. |
|
| InvoiceFirst7Day | decimal number |
None. |
|
| InvoiceSecond7Day | decimal number |
None. |
|
| InvoiceFirst14Day | decimal number |
None. |
|
| InvoiceSecond14Day | decimal number |
None. |
|
| InvoiceFirst30Day | decimal number |
None. |
|
| InvoiceSecond30Day | decimal number |
None. |
|
| InvoiceOtherDay | decimal number |
None. |
|
| PriceCheckBy | string |
None. |
|
| NovationCompany | string |
None. |
|
| PriceCheckDate | date |
None. |
|
| CSNCActualDate | date |
None. |
|
| Complete | date |
None. |
|
| CalendarDay | integer |
None. |
|
| Estimator | string |
None. |
|
| CalendarDaysFromStart | integer |
None. |