The way we send data between Rex and ADL Forms is via a 'merge file', created and populated in the Rex ADL Connector.
- This data is queried through the Rex API running under the users account
- The following tables describe in detail the actual mappings between the Rex API and the ADL Forms merge file interface
- Mapped attributes refer to a direct mapping between Rex and the ADL Forms merge fields
- Calculated attributes are those which require extra processing to translate to the requirements of the forms which may include addresses, prices, etc
Mapped Property Attributes
| Rex attribute | ADLForms merge tag | Description |
| property.attr_bathrooms | Property for Sale\Rooms\Bathroom\Qty | The number of bathrooms to display on forms. |
| property.attr_bedrooms | Property for Sale\Rooms\Bedroom\Qty | The number of bedrooms to display on forms. |
| property.attr_living_areas | Property for Sale\Rooms\Lounge\Qty | The number of lounge rooms to display on forms. |
| property.attr_ensuites | Property for Sale\Rooms\Ensuite\Qty | The number of ensuites to display on forms. |
| property.attr_exterior.text | Property for Sale\Feature Descriptions\Exterior | Describes features about the exterior of the property. |
| property.attr_land_frontage | Property for Sale\Land\Frontage | The frontage of the property. |
| property.attr_landarea_m2 | Property for Sale\Land\Size\M2 | Size of the property in meters squared. |
| property.adr_state_or_region | Property for Sale\State | Property address state. |
| property.adr_postcode | Property for Sale\Post Code | Property address post code. |
| property.attr_roof.text | Property for Sale\Feature Descriptions\Roof | Describes the roof of the property. |
| property.property_category.text | Property for Sale\Use\Detail | The category: Commercial, Business, Residential, etc. |
Calculated Property Attributes
We find the Property owner in "property._related.contact_reln_property" : A list of PROPERTY relations (Relations 1..n).
The owner is described as the Relation with "relation.reln_type.id" set to "owner".
We can then API query the owner's contact from "relation.contact.id".
| Rex attribute | ADL Forms merge tag | Description |
| contact.address | Seller\Address Line\No. 1 | Seller's address. |
| contact.email_address | Seller\Email | Seller's email. |
| contact.name | Seller\Name | Seller's name. |
| contact.phone_number | Seller\Phone | Seller's phone number. |
| property.system_search_key | Property for Sale\Address Line\No. 1 | The Rex attribute is split on occurences of (,). |
| property.adr_suburb_or_town | Property for Sale\Address Line\No. 3 | The suburb/town inserted onto line three. |
| property.attr_build_year | Property for Sale\Age | The Rex attribute subtracted from the current year returns the actual age. |
| property.attr_garages, property.attr_carports, property.attr_open_spaces | Property for Sale\Feature Descriptions\Car Parking | The three Rex attributes are formatted if available and provided in the form of "X garage(s), Y car port(s), Z open space(s)". |
| listing.related.property_features | Property for Sale\Feature Descriptions\Special Features | Each special feature listed in the Rex attribute is comma separated and provided to ADL Forms. |
Mapped Listing Attributes
| Rex Attribute | ADL Forms merge tag | Description |
| listing.inspection_notes |
Property for Sale\Inspection Instructions |
Property inspection conditions or instructions. |
| listing.legal_prop_titleref |
Property for Sale\Title Reference |
Title reference of the property. |
| listing.price_advertise_as |
Property for Sale\Appointment\Price |
Listing price. |
Calculated Listing Attributes
We find the Listing owner in "listing._related.contact_reln_listing" : A list of LISTING relations (Relations 1..n).
The owner is described as the relation with "relation.reln_type.id" set to "owner".
We can then API query the owner's contact from "relation.contact.id".
| Rex attribute | ADL Forms merge tag | Description |
| contact.address | Seller\Address Line\No. 1 | Seller's address. |
| contact.email_address | Seller\Email | Seller's email. |
| contact.name | Seller\Name | Seller's name. |
| contact.phone_number | Seller\Phone | Seller's phone number. |
Mapped Contract Attributes
| Rex attribute | ADL Forms merge tag | Description |
| agent.name | Agent\Name | Name of the seller's agent. |
| agent.phone_direct | Agent\Phone | Agent's direct phone number. |
| agent.phone_mobile | Agent\Mobile | Agent's mobile number. |
| agent.email_address | Agent\Email | Agent's email address. |
| contract.purchtenant_legal_name | Buyer\Name | Name of the buyer. |
| contract.purchtenant_solicitor.name | Buyer\Solicitor\Name | Name of the buyer's solicitor. |
| contract.purchtenant_solicitor.email_address | Buyer\Solicitor\Email | Buyer's solicitor's email. |
| contract.purchtenant_solicitor.fax_number | Buyer\Solicitor\Fax | Fax contact of the buyer's solicitor. |
| contract.detail_deposit_init_or_bond | Sales\Sales Contracts\Deposit | Initial deposit or bond of the contract. |
| contract.date_expec_deposit | Sales\Sales Contracts\Deposit\Balance\Payable\By | Date to expect the deposit. |
| contract.detail_finance_amount | Sales\Sales Contracts\Finance\Amount | Amount financed on the contract. |
| contract.date_expec_finance | Sales\Sales Contracts\Finance\Date | Date of finance availability. |
| contract.detail_finance_lender | Sales\Sales Contracts\Finance\Lender | Finance lender. |
| contract.date_expec_settlement | Sales\Sales Contracts\Settlement\Date | Date to expect contract settlement. |
| contract.chattels | Property for Sale\Inclusions | Chattels included with the property. |
| contract.detail_sale_price_or_lease_pa | Sales\Sales Contracts\Deposit\Balance\Amount | The purchase price of the property. |
| listing.legal_vendor_name | Seller\Name | When the application context is set to "Contract", we use this value instead of Seller\Name mentioned in other mapping contexts. |
| listing.legal_vendor_residence | Seller\Address Line\No. 1 | The legal residence of the vendor for display in contracts. We use the first owner contact available to determine this value, but if the legal details are provided, we prefer them. If nothing is provided then ADL will default to the Property Address. |
| listing.legal_solicitor._name | Seller\Solicitor\Name |
The name of the vendor's legal practitioner. |
| listing.legal_solicitor._phone_number | Seller\Solicitor\Phone | The phone number of the vendor's legal practitioner. |
| listing.legal_solicitor._fax_number | Seller\Solicitor\Fax | The fax number of the vendor's legal practitioner. |
| listing.legal_solicitor._email_address | Seller\Solicitor\Email | The email address of the vendor's legal practitioner. |
| listing.legal_prop_address | Property for Sale\Address Line\No. 1 | This Rex attribute is used when provided, else the application defaults to the property address ('property.system_search_key'). |
Calculated Contract Attributes
| Rex attribute | ADL Forms merge tag | Description |
| contract.detail_sale_price_or_lease_pa, contract.detail_deposit_full_or_prepayment | Sales\Sales Contracts\Deposit\Balance\Amount | The deposit amount subtracted from the sale price. |
| contract.conditions | Sales\Sales Contracts\Special Conditions | Each condition is parsed into the form of 'condition.condition_type - condition.condition_notes - Due d/M/y'. |
| contract.detail_deposit_init_or_bond | Sales\Sales Contracts\Deposit\Initial | The initial deposit paid. |
| contract.detail_deposit_full_or_prepayment | Sales\Sales Contracts\Deposit\Initial Payable | The full deposit amount. |
The following details are specific to accounts with their region set to VIC.
| Rex attribute | ADL Forms merge tag | Description |
| contract.detail_deposit_full_or_prepayment | Sales\Sales Contracts\Deposit\Initial | This value is switched with initial payable as ADL expects them in the wrong order for the AUVICREPS006v1.4 form. |
| contract.detail_deposit_init_or_bond | Sales\Sales Contracts\Deposit\Initial Payable | This value is switched with intial as ADL expects them in the wrong order for the AUVICREPS006v1.4 form. |
Mapped Appraisal Attributes
| ¸Rex attribute | ADL Forms merge tag | Description |
| appraisal.price_min | Property for Sale\Appraisal\From | Appraisal minimum price. |
| appraisal.price_max | Property for Sale\Appraisal\To | Appraisal maximum price. |