SWS2 GetDataView Method – sws_new_rentals_v
This is the same view that is used in the “New Rental” report and provides a list of new rentals. This is available at the organization or site level.
Returned Columns
| Name | Data Type |
|---|---|
| UNIT_NUMBER | String |
| Description | The unit’s number as assigned by the organization. This is not the UnitID. This can be retrieved using any of the GetSiteUnitData methods. |
| UNIT_ID | Long |
| Description | The unit’s ID number. This is maintained through rentals. |
| WIDTH | Integer |
| Description | The width measurement of the unit dimensions. |
| DEPTH | Integer |
| Description | The depth measurement of the unit dimensions. |
| AVGLOS | Decimal |
| Description | The average length of stay, in months, of the tenants in this unit. |
| HEIGHT | Integer |
| Description | The height measurement of the unit dimensions. |
| DIM_ATTRIB | String |
| Description | The width and depth dimensions as well as the “Attribute01” as a string. |
| RENTAL_START_DATE | DateTime |
| Description | The date and time that the customer initiated the rental. |
| RENT_RATE | Decimal |
| Description | The rate at which the unit was rented. |
| ACCT_ID | Long |
| Description | The account’s ID number. |
| ACCOUNT_NAME | String |
| Description | The name on the account. This may differ from the primary contact’s name in some instances, such as a business account or a guardian account. |
| FIRST_NAME | String |
| Description | The first name of the primary contact. |
| LAST_NAME | String |
| Description | The last name of the primary contact. |
| String | |
| Description | The email of the primary contact. |
| ADDRESS | String |
| Description | A combination of all three address lines of the primary contact’s address |
| CITY | String |
| Description | The city of the primary contact’s address. |
| STATE | String |
| Description | The state/province of the primary contact’s address. |
| POSTAL_CODE | String |
| Description | The ZIP/postal code of the primary contact’s address. |
| PHONE | String |
| Description | The primary conact’s phone number. |
| MOVED_IN_BY | String |
| Description | The first and last name of the user that moved the customer into the unit. |
| SITE_ID | Long |
| Description | The site’s ID number |
| SITE_NAME | String |
| Description | The site’s name. |
| ORG_ID | Long |
| Description | The organization’s ID number. |
| START_DATE | DateTime |
| Description | The date the customer started the rental. |
| CLASS_DESC | String |
| Description | The textual description for the class type of the unit. |
| ORG_NUMBER_XREF | String |
| Description | The organization’s site number. This is not the site ID. |
| CURR_STATUS | String |
| Description | The current rental status of the specific unit. |
| END_DATE | DateTime |
| Description | If the rental has been terminated, this is the date the the rental was terminated. |
| UNIT_NUM_SORT | String |
| Description | A number used to allow us to sort the units in the application. |
Categories: API General, Reports, Search
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
Yardi Store Developer eXchange 