dealer_comment_raw
Pipelined Data Sets
>
Symitar
>
dealer_comment_raw
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| institutionid | This field stores the JH Platform institution identifier | REQUIRED | STRING | |
| eventtime | Internal use only | NULLABLE | INTEGER | |
| sourcetype | Internal use only; SSDB field | NULLABLE | STRING | |
| operation | Internal use only; SSDB field | NULLABLE | STRING | |
| extractdate | Internal use only | NULLABLE | DATE | |
| processdatetime | Internal use only; SSDB field | NULLABLE | TIMESTAMP | |
| dealercommentuuid | This field stores a JH Platform unique identifier for a dealer comment | NULLABLE | STRING | |
| dealeruuid | This field stores a JH Platform unique identifier for a dealer | NULLABLE | STRING | |
| dealernumber | This field stores the dealer number | NULLABLE | STRING | |
| dealercommentkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| dealerkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sortrank | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| symdate | Internal use only; SSDB field | NULLABLE | INTEGER | |
| systemcreatedatetime | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odscreatedatetime | Internal use only; SSDB field | NULLABLE | INTEGER | |
| sym | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odsdeleteflag | Internal use only; SSDB field | NULLABLE | INTEGER | |
| odskey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| type | This field stores an optional code to categorize your Dealer Reserve Accounting Manager comments | NULLABLE | INTEGER | |
| effectivedate | This field stores the date the comment should begin to display | NULLABLE | DATE | |
| expirationdate | This field stores the date after which the comment should no longer display | NULLABLE | DATE | |
| comment | This field stores the comment text | NULLABLE | STRING | |
| locator | This field stores a unique number within each Dealer Comment record set that can be used as a unique identification of this record | NULLABLE | INTEGER | |
| recordchangedate | This field stores the system date in this field when you create, change, or save the Dealer Comment record. Sometimes the system updates this field because the record was saved, even though there may not be any actual changes in the record | NULLABLE | DATE |
Have a Question?
- Have a how-to question? Seeing a weird error? Get help on our collaborative Discourse page.
- Register for the Developer Office Hours where we answer technical Q&A, in real time, from the audience.
Did this page help you?
Last updated Tue Sep 15 2026