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 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 => "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" # ??? | |
} |
This file contains 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 => "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" # ??? | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment