This solution has all of the Word Merge fields that are available to inset in to your Word Merge Templates *Note: There may be more Word Merge fields available in your .txt file, depending on what version of Chintaro you are running. The latest version has the most up to date list of Word Merge Fields.
Arrears
Field Name | PostalAddress |
Days | PostalCity |
Arrears | PostalState |
RentBalance | PostalPostCode |
NonRentBalance | Rent_Paid_To |
StartDate | JointTitle |
Title | JointSurname |
Surname | JointGivenName |
GivenNames | JointKnownAsName |
Address | LastRentChargeFrom |
City | LastRentChargeTo |
Postcode | NextOfKinName |
State | NextOfKinAddress |
ContactPhone1 | NextOfKin1CityName |
TenancyManager | NextOfKin1State |
tcyMrgPh1 Tenancy Manager Phone | NextOfKin1Postcode |
tcyMgr1Email Tenancy Manager Email | NextOfKinName2 |
Today | NextOfKinAddress2 |
TodayPlus7 | NextOfKin2CityName |
TodayPlus14 | NextOfKin2State |
TodayPlus17 | NextOfKin2PostCode |
SiteName Site = Organisation | AmenitiesBalance |
SitePhone | DamageBalance |
SiteAddress | GardeningBalance |
SiteACN ABN | UtilitiesBalance |
SiteFax | WaterBalance |
SiteRep | OtherBalance |
Pcode | FurnitureBalance |
RentCalculatedTo | LoanBalance |
PaymentBookID | KeyBalance |
LastPayment Date | ParkingBalance |
LastAmount | CID |
CurrentWeeklyRent | EndDate |
PropertyName | Bond_Owing |
RoomNumber | |
HSA Housing South Australia | |
Community Not Generally Used |
Client
Today | DepGender4 |
ID | DepFirstName5 |
PrimaryTenant | DepSurname5 |
Title | DepRel5 |
Surname | DepDOB5 |
GivenNames | DepGender5 |
KnownAsName | DepFirstName6 |
Gender | DepSurname6 |
DateOfBirth | DepRel6 |
Email | DepDOB6 |
Address | DepGender6 |
City | DepFirstName7 |
Region | DepSurname7 |
DepRel7 | |
Postcode | DepDOB7 |
State | DepGender7 |
HSA | DepFirstName8 |
DepSurname8 | |
PostalAddress | DepRel8 |
PostalCity | DepDOB8 |
PostalPostCode | DepGender8 |
PostalState | DepFirstName9 |
RegistrationDate | DepSurname9 |
CRN | DepRel9 |
Country | DepDOB9 |
Language | DepGender9 |
SpokenEnglish | DepFirstName10 |
WrittenEnglish | DepSurname10 |
ReferralType | DepRel10 |
ArrearsActionFlag Internal Chintaro ID 1 or 0 | DepDOB10 |
ArrearsSince Date | DepGender10 |
RelationshipToPrimar | SortID |
AustralianResident | Include |
NextOfKinName | Active |
NextOfKinAddress | HousedStatus |
Expr1 - Next of Kin City | Band |
Expr2 - Next of Kin Postcode | CurrentUser |
Expr3 - Next of Kin State | ParentID |
Relationship | |
NextOfKinPhone | |
NextOfKinName2 | |
NextOfKinAddress2 | |
Expr4 - Next of Kin 2 City | |
Expr5 - Next of Kin 2 Postcode | |
Expr6 - Next of Kin 2 State | |
Expr7 - Next of Kin 2 Relationship | |
NextOfKinPhone2 | |
ContactPhone1 | |
ContactPhone2 | |
CarOwner | |
Centrelink | |
NDCAconsent | |
SiteName | |
SiteAddress | |
SitePhone | |
Site ACN | |
Site Fax | |
Income1 | |
IncomeAmount1 | |
Income2 | |
IncomeAmount2 | |
Income3 | |
IncomeAmount3 | |
Income4 | |
IncomeAmount4 | |
Income5 | |
IncomeAmount5 | |
Income6 | |
IncomeAmount6 | |
Income7 | |
IncomeAmount7 | |
Income8 | |
IncomeAmount8 | |
Income9 | |
IncomeAmount9 | |
Income10 | |
IncomeAmount10 | |
DepFirstName1 -Dep is Household dependent | |
DepSurname1 | |
DepRel1 | |
DepDOB1 | |
DepGender1 | |
DepFirstName2 | |
DepSurname2 | |
DepRel2 | |
DepDOB2 | |
DepGender2 | |
DepFirstName3 | |
DepSurname3 | |
DepRel3 | |
DepDOB3 | |
DepGender3 | |
DepFirstName4 | |
DepSurname4 | |
DepRel4 | |
DepDOB4 |
Maintenance
Today | TradeCity |
ReportedDate | TradePostCode |
MaintenanceType | ActualAmount |
Sitename | ActualGST |
SitePhone | EstimatedAmount |
SiteAddress | EstimatedGST |
SiteACN | TenantName |
SiteFax | TenantPhone |
SiteRep | TenantDamag |
Alerts | AccessInstructions |
ID | Availability Tenant’s Availability |
Urgent | CC Email CC |
ItemName | CC2 Email 2 CC |
Equipment Item Type | CreatedBy |
EquipmentType Item Group | Owner Property Owner |
WorksType | Owner_Address |
ScheduledDate | Owner_City |
ScheduledCompletionD Date | Owner_Postcode |
Comments Instructions | Owner_State |
Active Internal Chintaro ID | ABN Tradesperson ABN |
Program From Property Record | BSB Tradesperson BSB |
PropertyName | BankAccount |
RoomNumber | PaymentMethod |
Address | BPayCode |
City | PublicLiabilityDate |
ContactPhone1 From Client Record | PublicLiabilityNumbe |
ISIP | BuildersLicence |
Email From Client Record | BuildersLicenceExpir |
Fax | WorkersComp |
HotWater | WorkersCompExpiry |
Stove | Compliance |
Heating | ComplianceExpiry |
HousingWorker Tenancy Manager | Contact1Email |
PostCode | GLCode |
State | KeyTag |
TenantsPerm From Tenant’s Permission box | KeyCode |
Details | KeyComment |
UrgentText | CompletedDate |
Location | TimeSpent |
OrderNumber | DateEntered |
SCOrderNumber | TradeType |
TradingName | Today_1 |
TradeContact Name | Today_7 |
TradePhone | Today_30 |
TradeFax | |
FirstOfSurname Tenant Surname | |
FirstOfGivenNames Tenant Name | |
FirstOfKnownAsName Tenant Known As Name | |
FirstOfContactPhone1 | |
FirstOfContactPhone2 | |
TradeAddress |
Property
ID | tCity_1_State |
PropertyName | Landlord Property Manager |
tProperty_Address | tLandlord_Address Property Manager Address |
ContactPhone1 | tCity_2_City |
tCity_City | tCity_2_PostCode |
tCity_PostCode | tCity_2_State |
tCity_State | Contact1Phone1 |
Program | Contact1Phone1 |
UserName | ProgramID |
SiteName | Include |
SiteAddress | LandlordID |
SitePhone | Owner |
SiteACN | Owner_Address |
SiteFax | Owner_City |
LeaseStartDate | Owner_Postcode |
LeaseTerm | Owner_State |
tCity_1_City | |
tCity_1_PostCode |
Tenancy
Today | SplitType1 |
Title | SplitType2 |
Surname | SplitType3 |
GivenNames | SplitType4 |
KnownAsName | BSB |
JointTitle In Joint Tenancy – Related Tenant | DEAccountNumber |
JointSurname | DEAmount |
JointGivenName | ExpectedExitDate |
JointKnownAsName | LatestLeaseFrom |
Address | LatestLeaseTo |
City | m_75PercentMarketRen |
PostCode | ScheduledInspection Schedule Inspections screen |
State | InspectionTime Schedule Inspection screen |
PostalAddress | AdHocInspection |
PostalCity | InspectionTimeAdHoc |
PostalPostCode | LastRentChargeFrom |
PostalState | LastRentChargeTo |
DateOfBirth | NextOfKinName |
CRN | NextOfKinAddress |
Email | NextOfKinCity |
ContactPhone1 | NextOfKinPostCode |
ContactPhone2 | NextOfKinState |
PaymentArrangement | NextOfKinRel |
PropertyName | NextOfKinName2 |
RoomNumber | NextOfKinAddress2 |
TenancyStartDate | NextOfKinCity2 |
TenancyStatus | NextOfKinPostCode2 |
Balance | NextOfKinState2 |
RentCalcTo | NextOfKinRel2 |
PaymentBookId | FortnightlyRent |
PropAddress | FortnightlyNonRent |
Arrears | FortnightlyMgmtFee |
Days | FortnightlyServiceFe |
PropertyID Internal Chintaro ID | PropertyType |
Program | CheckTenantFile |
CurrentRent | |
UserName | |
SiteName | |
SiteAddress | |
SitePhone | |
SiteACN | |
SiteFax | |
SiteEmail | |
CurrentWeeklyRent | |
CurrentWeeklyNonRent | |
CurrentWeeklyMarketR | |
CurrentWeeklyManagem | |
CurrentWeeklyService | |
CurrentWeeklyUtiliti | |
NewRent | |
NewNonRent | |
NewServiceFee | |
NewUtilitiesFee | |
NewMarketRent | |
NewWeeklyStartDate | |
NewRentFortnightly | |
LastReviewDate | |
RentReviewDate | |
BondReference | |
BondAmount | |
TransferLodged | |
RefundLodged | |
BondLoan | |
BondTransferred | |
RefundRequired | |
RefundReason | |
Income | |
IncomeAmount | |
IncomeRate | |
TenancyManager | |
JobTitle | |
tcyMgr1Ph1 | |
tcyMgr1Ph2 | |
LastInspection | |
NextInspection | |
Band | |
BaseRent | |
ASL1 | |
ASL2 | |
ASL3 | |
TotalCRA | |
CappingAmount | |
RentAllowance | |
RentPayable | |
Comments | |
ActualRentPayableByT | |
AssessedRent | |
Marketrent | |
FortnightlyMarketren | |
MarketRentLessEquity | |
BaseRentLessEquity | |
SplitAmount | |
SplitAmount1 | |
SplitAmount2 | |
SplitAmount3 | |
SplitAmount4 | |
SplitType |
Transactions
SiteID | Title |
ID | Surname |
TenancyID | GivenNames |
TxnTypeID | PostalAddress |
TxnAmount | PostalCity |
GSTAmount | PostalPostCode |
TxnDate | PostalState |
Comment | Address |
BankAccountID | City |
RentFromDate | State |
RentToDate | Postcode |
DateEntered | PropertyAddress |
DateLastChanged | PropertyCity |
LastUpdatedBy | PropertyPostCode |
Batch | PropertyState |
BatchRent | PaymentBookId |
Include | GST |
BatchGL | TenancyManager |
GLCode | TcyMgr1Ph1 |
TodayPlus14 | TcyMgr1Ph2 |
TxnType | TcyMgr1Contact |
Amount | TcyMgr2Ph1 |
calcGSTAmt | TcyMgr2Ph2 |
calcExGSTAmt | TcyMgr2Contact |
calcGSTAmtNZ | |
CRNFormat |
Tradespeople
TradingName | Contact2Phone1 |
Address | Contact2Phone2 |
City | Contact2Fax |
PostCode | Comments |
State | Expr1016 |
TradeType | Expr1017 |
Contact1Name | PropertyRegion |
Contact1Phone1 | KpmMaintType |
Contact1Phone2 | PublicLiabilityNumbe |
Contact1Fax | PublicLiabilityDate |
Contact1Email | ID |
Contact2Name |
Waiting List
ID Internal Chintaro ID | Application_Date |
ClientNum | LastContactDate |
Title | CurrentRent |
Surname | Comments |
GivenNames | UserName |
KnownAsName | SiteName |
Address | SiteAddress |
City | SitePhone |
PostCode | SiteACN ABN |
State | SiteFax |
PostalAddress | Preference1 |
PostalCity | Preference2 |
PostalPostCode | Preference3 |
PostalState | Outcome |
Gender | |
ContactPhone1 | |
ContactPhone2 | |
DateOfBirth | |
CRN | |
Income | |
IncomeAmount | |
IncomeRate | |
WaitingListType1 | |
WaitingListType2 | |
WaitingListType3 | |
WaitingListType4 | |
HouseholdType | |
HousingType | |
Program | |
Transfer_ |
Water Charge
TxnType | PaymentBookId |
Amount | MeterReadingFromDate |
SiteID | MeterReadingFrom |
ID | MeterReadingToDate |
TenancyID | MeterReadingTo |
TxnTypeID | TotalConsumption |
TxnAmount | WaterUseDescription |
GSTAmount | WaterUseAmount1 |
TxnDate | WaterUseDescription2 |
Comment | WaterUseAmount2 |
BankAccountID | WaterUseDescription3 |
RentFromDate | WaterUseAmount3 |
RentToDate | SpecialMeterReading |
DateEntered | Concession |
DateLastChanged | BalanceBefore |
LastUpdatedBy | Days |
Batch | TotalCharge |
BatchRent | PeriodCharge |
Include | WaterCharge |
BatchGL | |
GLCode | |
Title | |
Surname | |
GivenNames | |
Address | |
City | |
PostCode | |
State | |
PostalAddress | |
PostalCity | |
PostalPostCode | |
PostalState |