SWS2 GetDataView Method – quote_reconciliation_3_v
The new view is quote_reconciliation_3_v which is a duplicate of quote_reconciliation_2_v and includes postal_code, updated_by and updated_user.
Returned Parameters
| Name | Data Type |
|---|---|
| QUOTE_ID | Long |
| Description | The quote’s ID number. |
| ORG_ID | Long |
| Description | The organization’s ID number. |
| CREATED_BY | Long |
| Description | The user’s ID that created the quote/reservation. |
| USER_NAME | String |
| Description | The user’s username that created the quote/reservation. |
| QUOTE_TYPE | Integer |
| Description | The numeric value of the quote type for the quote/reservation. |
| QUOTE_TYPE_VAL | String |
| Description | The textual value of the quote type for the quote/reservation. |
| STATUS | Integer |
| Description | The numeric value of quote’s status. |
| QUOTE_STATUS_VAL | String |
| Description | The textual value of the quote’s status. |
| QUOTE_SOURCE | String |
| Description | The application source that created the quote/reservation. |
| QUOTE_START_DATE | DateTime |
| Description | The date the quote/reservation was originally created. |
| EXPIRATION | DateTime |
| Description | The date the quote/reservation is no longer available. |
| ACCT_ID | Long |
| Description | The account’s ID number. This is returned when you use the CreateNewAccount method or can be retrieved with the SearchBy method. |
| CONTACT_ID | Long |
| Description | The rental contact’s ID number. This is returned when using the CreateNewAccount or AddNewContact methods or you can search for it using the SearchBy method. |
| ADDR_ID | Long |
| Description | The primary contact’s address ID number. |
| PHONE_ID | Long |
| Description | The primary contact’s phone ID number |
| SITE_ID | Long |
| Description | The site’s ID number. This can be found using the GetSiteList method. |
| SITE_NAME | String |
| Description | The site’s name as it appears in the Store application. |
| ACCT_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 guardianship account. |
| FIRST_NAME | String |
| Description | The primary contact’s first name. |
| LAST_NAME | String |
| Description | The primary contact’s last name. |
| CONTACT_ADDRESS | String |
| Description | The primary contact’s complete address. This includes all applicable address lines, city, state/province and ZIP/postal code. |
| PHONE | String |
| Description | The primary contact’s phone number. |
| String | |
| Description | The primary contact’s email address. This acts as the username if eStore/eCommerce are supported. |
| UNIT_NUMBER | String |
| Description | The unit’s number as assigned by the organization. This is not the UnitID. |
| UNIT_STATUS_VAL | String |
| Description | The rental status of the unit. |
| UNIT_DIMENSIONS | String |
| Description | The width and depth measurements together as a string. |
| ATTRIBUTE01 | Integer |
| Description | The numeric value for the “Attribute01” custom look up as defined by the site. See eUnitAttr01 for the available values. |
| ATTRIBUTE01_VAL | String |
| Description | The textual value for the “Attribute01” custom look up as defined by the site. See eUnitAttr01 for the available values. |
| QUOTED_RATE | Decimal |
| Description | The amount quoted for the monthly rental rate. |
| DISCOUNT_AMOUNT_OFFERED | Decimal |
| Description | The dollar amount of any discount applicable to the quote/reservation. |
| MARKET_CODE_VAL | Integer |
| Description | The numeric indicator as to where the customer heard about the site. This is available to only specific sites. |
| MARKET_SOURCE_VAL | String |
| Description | The textual indicator as to where the customer heard about the site. This is available to only specific sites. |
| INQUIRY_SOURCE_VAL | String |
| Description | Indicates how the customer heard about the site. |
| CREATED | DateTime |
| Description | The date the quote/reservation was initially created. |
| UPDATED | DateTime |
| Description | The date that quote/reservation was most recently updated. |
| POSTAL_CODE | String |
| Description | The ZIP/postal code of the primary contact’s address. |
| UPDATED_BY | Long |
| Description | The user’s ID that last updated the quote/reservation. |
| UPDATED_USER | String |
| Description | The username of the person that last updated the quote/reservation. |
Categories: API General, Search
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
Yardi Store Developer eXchange 