Last active
February 20, 2017 22:48
-
-
Save mplatts/c55dac5ee50936e603b0a33084780e82 to your computer and use it in GitHub Desktop.
Rest properties fields
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
: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 => "[email protected]", # 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 => "[email protected]", # 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 => "[email protected]", # 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" # ??? | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
: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 => "[email protected]", # 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 => "[email protected]", # 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 => "[email protected]", # 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" # ??? | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment