glhistory_raw
Pipelined Data Sets
>
Symitar
>
glhistory_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 | |
| glhistoryuuid | This field stores a JH Platform unique identifier for a gl history | NULLABLE | STRING | |
| glaccountuuid | This field stores a JH Platform unique identifier for a gl account | NULLABLE | STRING | |
| glaccount | This field stores the gl account | NULLABLE | STRING | |
| glhistorykey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| glaccountkey | 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 | |
| voucheruniqueid | NULLABLE | STRING | ||
| vouchersortrank | NULLABLE | INTEGER | ||
| sequencenumber | The system assigns this number in sequence to each transaction posted on a specific system date | NULLABLE | INTEGER | |
| effectivedate | This field stores the effective date of the transaction | NULLABLE | DATE | |
| postdate | The system updates this field with the current system date when you OK the transaction | NULLABLE | DATE | |
| usernumber | The system updates this field with the user number of the person who posted the transaction | NULLABLE | INTEGER | |
| comment | This field stores the text a teller enters at the General Ledger comment prompt | NULLABLE | STRING | |
| glaccountnumber | This field stores the account number of the GL account affected by the transaction | NULLABLE | STRING | |
| debitcreditcode | The system updates this field with a code to identify the type of transaction | NULLABLE | INTEGER | |
| amount | The system updates this field with the amount of the transaction | NULLABLE | NUMERIC | |
| reference | This field stores any reference entered for the transaction | NULLABLE | STRING | |
| glcategory | The system updates this field with the GL category that was specified when the transaction was posted | NULLABLE | INTEGER | |
| processoruser | The SymConnect message creator can provide specific user information in this field. The system only saves the field. It performs no validation of the contents. A value of 0 indicates that this field was not used | NULLABLE | INTEGER |
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