mplatts
2/20/2017 - 10:08 PM
Rest properties fields
Rest properties fields
{
:propadd1 => "16 Waters Road", # property.address_line_one
:propadd3 => "Bonogin QLD 4213", # property.address_line_two
:propsuburb => "Bonogin", # property.suburb
:propstate => "QLD", # property.state
:proppcode => 4213, # property.postcode
:propalpha => "WATE16", # property.rest_alpha
:propmanager => "Jodie Cleary", # PropertyManager.find_or_create
:propmanageremail => "jodie.cleary@mrwrightproperty.com.au", # PropertyManager.find_or_create
:propmanagerwrkphone => "1300 325 997", # PropertyManager.find_or_create
:propmanfirstname => "Jodie", # PropertyManager.find_or_create
:propmanlastname => "Cleary", # PropertyManager.find_or_create
:propclass => "Residential", # property.classification ???
:proptypecode => "A", # ???
:propkeyno => 26, # ???
:proplastinp => "22-Dec-16", # ??? create new property.property_tenancy.property_tenancy_inspections
:propmfee => 7, # property.property_tenancy.management_fee_percentage
:propexplimit => 0, # ???
:propdwelling_type => "House", # property.dwelling_type?
:propbedrooms => 4, # property.bedrooms
:propparking => "Garage", # property.parking_type?
:propinclusions => "Non-Furnished", # ???
:propauthdate => "9-May-13", # ???
:proplettingfee => 715, # property.property_tenancy.weeks_in_advance
:proplettingfeecalcmethod => "Number of Weeks", # property.property_tenancy.weeks_in_advance
:proplettingfeerate => 1, # property.property_tenancy.weeks_in_advance
:proprent => 650, # property.property_tenancy.payment_price
:proprentperiod => "W1", # property.property_tenancy.payment_interval
:propsupervisionfeeaspercentyn => "N", # ???
:propsupervisionfee => 0, # ???
:propdisbursementfee => 0, # ???
:propinspectionfee => 0, # ???
:propgststartdate => "1-Jul-05", # ???
:createddate => "7-Jun-13", # property.created_at
:active_status => "Active", # not needed? worked out by tenancy start/end
:lostreason => "No reason specified", # ???
:gainedreason => "No reason specified", # ???
:referredby => "Not referred", # ???
:losttocompetitor => "Not lost to competitor", # ???
:advertbedrooms => 0, # ???
:floorareasqm => 0, # ???
:pricepersqm => 0, # ???
:floorareasqf => 0, # ???
:pricepersqf => 0, # ???
:ownername => "Daniel Paul Springer & Lee-Anne Springer", # property.owner
:owneradd1 => "7A Bateman Court", # property.owner.address_line_one
:owneradd2 => "Millars Well 6714 WA", # property.owner.address_line_two
:owneralpha => "SPRI", # property.owner.rest_alpha
:ownersalut => "Danny & Lee-Anne", # property.owner.salutation
:ownerhmephne => "0407 588 214 Lee-Ann", # ???
:ownermobile => 439908900, # property.owner.primary_phone
:owneremail => "info@mrwrightproperty.com.au", # property.owner.email
:ownerpostageandsundries => 4.55, # property.property_tenancy.postage_fee
:ownerincandexpfee => 0, # ???
:ownerrecoverbankchargesyn => "N", # ???
:ownergststartdate => "1-Jul-05", # ???
:tenantname => "David & Kelley McNiff", # property.tenant.name
:tenantalpha => "MCNI", # property.tenant.rest_alpha
:tenantsalutation => "Kelley McNiff", # property.tenant.salutation
:tenanthomephne => "0450998930 Leah", # property.tenant.secondary_phone
:tenantmobile => 426393421, # property.tenant.primary_phone
:tenantemail => "leighamcniff@gmail.com", # property.tenant.email
:tenantleasestdate => "8-Apr-16", # property.property_tenancy.start_date
:tenantleaseexpdate => "6-Apr-17", # property.property_tenancy.end_date
:tenantprevinsdate => "22-Dec-16", # ???
:tenantnxtinsdate => "22-Mar-17", # ???
:tenantbondpaid => 2600, # ???
:tenantbondno => "5692477-1", # ???
:tenantbondrequired => 2600, # # property.property_tenancy.bond
:birthdaysinuse => "N", # ???
:unusedinuse => "N", # ???
:stratacontactismanagingagentyn => "Y" # ???
}{
:alpha => "WILL L", # user.rest_alpha ?
:name => "Lynne Williams", # user.first_name, user.last_name
:leasename => "Lynne Williams", # ???
:leaseshortname => "Lynne Williams", # ???
:postalline1 => "27B Fisher Avenue", # user.address_line_one
:postalline3 => "Southport Qld 4215", # user.address_line_two
:tenantsuburb => "Southport", # user.suburb
:tenantstate => "Qld", # user.state
:tenantpcode => 4215, # user.postcode
:salutation => "Lynne Williams", # user.salutation
:mobile => 402538234, # user.primary_phone
:email => "lynnewilliams211@gmail.com", # user.email
:bond => 1040, # tenancy.bond (via calculations)
:invoice_credit_held => 0, # ???
:propadd1 => "27B Fisher Avenue", # Already in property
:propadd3 => "Southport Qld 4215", # Already in property
:propsuburb => "Southport", # Already in property
:propstate => "Qld", # Already in property
:proppcode => 4215, # Already in property
:propalpha => "FISHB", # Already in property
:propmanager => "Jodie Cleary", # Already in property
:propmanageremail => "jodie.cleary@mrwrightproperty.com.au", # Already in property
:propmanagerwrkphone => "1300 325 997", # Already in property
:propmanfirstname => "Jodie", # Already in property
:propmanlastname => "Cleary", # Already in property
:proptypecode => "A", # Already in property
:ownername => "Tim & Dianne Burgess", # Already in property
:ownradd1 => "PO Box 300", # Already in property
:ownradd2 => "Southport QLD 4215", # Already in property
:ownralpha => "BURG", # Already in property
:ownrsalut => "Tim & Dianne", # Already in property
:ownrhmephne => "0413870990 Tim", # Already in property
:ownrmobile => 403347217, # Already in property
:ownremail => "info@mrwrightproperty.com.au", # Already in property
:leasestdate => "8-Dec-16", # Already in property
:leaseexpdate => "6-Dec-17", # Already in property
:previnsdate => "24-Aug-16", # Already in property
:nxtinsdate => "8-Mar-17", # Already in property
:nxtinsdayofweek => "Wednesday", # Already in property
:rentdesc1 => "Rent", # Already in property
:rentamt1 => 260, # Already in property
:rentper1 => "W1", # Already in property
:rentarrs1 => 0, # Already in property
:rentarrstotoday1 => 0, # Already in property
:rentduedate1 => "1-Mar-17", # income? though should work out dynamically from start/end dates
:tenantvacatearrears1 => 0, # ???
:arrearsdays1 => 0, # ???
:arrearscalcdays1 => 0, # ???
:effectivepaidtodate1 => "1-Mar-17", # ??? can work out paid incomes?
:rentpdfrom1 => "16-Feb-17", # ???
:rentpdto1 => "1-Mar-17", # ???
:newrentamt1 => 0, # ???
:rentamt2 => 0, # ???
:rentarrs2 => 0, # ???
:rentarrstotoday2 => 0, # ???
:tenantvacatearrears2 => 0, # ???
:arrearsdays2 => 0, # ???
:arrearscalcdays2 => 0, # ???
:effectivepaidtodate2 => "7-Dec-16", # ???
:rentpdfrm2 => "7-Dec-16", # ???
:rentpdto2 => "7-Dec-16", # ???
:newrentamt2 => 0, # ???
:rentamt3 => 0, # ???
:rentarrs3 => 0, # ???
:rentarrstotoday3 => 0, # ???
:tenantvacatearrears3 => 0, # ???
:arrearsdays3 => 0, # ???
:arrearscalcdays3 => 0, # ???
:effectivepaidtodate3 => "7-Dec-16", # ???
:rentpdfrm3 => "7-Dec-16", # ???
:rentpdto3 => "7-Dec-16", # ???
:newrentamt3 => 0, # ???
:"90+_daysbal" => 0, # ???
:"60_daysbal" => 0, # ???
:"30_daysbal" => 0, # ???
:currntbal => 0, # ???
:totinvbal => 0, # ???
:totrentarrears => 0, # ???
:totarrears => 0, # ???
:totvacatearrears => 0, # ???
:totcurrentrentarrears => 0, # ???
:bankcode => 10000070, # user.account_number
:bankcodeinccheckdigit => 100000702, # ???
:tenantcommission1 => 7.5, # ???
:tenantcommission2 => 0, # ???
:tenantcommission3 => 0, # ???
:propertycommission => 7.5, # ???
:property_authority_date => "13-May-15", # ???
:credit1 => 0, # ???
:credit2 => 0, # ???
:credit3 => 0, # ???
:active_status => "Active", # ???
:primary_contact => "Y", # make primary tenant
:lease_contact => "Y", # ???
:accounts_contact => "Y", # ???
:repairs_contact => "Y", # ???
:stratacontactismanagingagentyn => "Y" # ???
}