HistoryTransactional
GET
/trestle/odata/HistoryTransactional
GET
/trestle/rets/search?SearchType=HistoryTransactional&Class=HistoryTransactional
HistoryTransactionalKey is the primary key and uniquely identifies records in the HistoryTransactional resource.
The following fields are considered InKeyIndex fields and may be queried in batches up to 300,000 at a time:
ChangedByMemberID, ChangedByMemberKey, FieldKey, HistoryTransactionalKey, ListAgentKey, ListOfficeKey, ModificationTimestamp, OriginatingSystemHistoryKey, ResourceRecordID, ResourceRecordKey, SourceSystemHistoryKey, SourceSystemID.
Fields
| Field | Type | Size | Description |
|---|---|---|---|
| ChangedByMemberID InKey | String | 25 | ChangedByMemberID |
| ChangedByMemberKey InKey | String | 255 | ChangedByMemberKey |
| ChangeType | ChangeType Enum | ChangeType | |
| ClassName | String | 255 | ClassName |
| FieldKey InKey | String | 20 | FieldKey |
| FieldName | String | 100 | FieldName |
| HistoryTransactionalKey Key InKey | String | 255 | HistoryTransactionalKey |
| InternetEntireListingDisplayYN | Boolean | InternetEntireListingDisplayYN | |
| ListAgentKey InKey | Int64 | 20 | ListAgentKey |
| ListAOR | AOR Enum | ListAOR | |
| ListingPermission | String | 8000 | ListingPermission |
| ListOfficeKey InKey | String | 20 | ListOfficeKey |
| ModificationTimestamp InKey | DateTimeOffset | ModificationTimestamp | |
| NewValue | String | 8000 | NewValue |
| OffMarketDate | DateTime | OffMarketDate | |
| OriginatingSystem | String | 255 | OriginatingSystem |
| OriginatingSystemHistoryKey InKey | String | 255 | OriginatingSystemHistoryKey |
| OriginatingSystemName | String | 255 | OriginatingSystemName |
| OriginatingSystemSubName | String | 255 | OriginatingSystemSubName |
| PreviousValue | String | 8000 | PreviousValue |
| PropertySubType | PropertySubType Enum | PropertySubType | |
| PropertySubTypeAdditional | PropertySubTypeAdditional | 250 | PropertySubTypeAdditional |
| PropertyType | PropertyType Enum | PropertyType | |
| ResourceName | String | 100 | ResourceName |
| ResourceRecordID InKey | String | 255 | ResourceRecordID |
| ResourceRecordKey InKey | String | 20 | ResourceRecordKey |
| SourceSystem | String | 255 | SourceSystem |
| SourceSystemHistoryKey InKey | String | 255 | SourceSystemHistoryKey |
| SourceSystemID InKey | String | 25 | SourceSystemID |
| SourceSystemName | String | 255 | SourceSystemName |
| StandardStatus | StandardStatus Enum | StandardStatus | |
| SyndicateTo | SyndicateTo | 5125 | SyndicateTo |