ssdb_gl_account_cdc
Pipelined Data Sets
>
Symitar
>
ssdb_gl_account_cdc
| Column name | Description | Mode | Type | Length |
|---|---|---|---|---|
| institutionid | This field stores the JH Platform institution identifier | REQUIRED | STRING | |
| sourceeventtime | The timestamp of the change event from the source system (e.g., Debezium's ts_ms field). | NULLABLE | INTEGER | |
| sourceeventdate | The UTC date of the change event, derived from sourceeventtime. | NULLABLE | DATE | |
| operation | The type of operation that caused the change event (e.g., 'c' for create/insert, 'u' for update, 'd' for delete, 'r' for read). This corresponds to Debezium's 'op' field. | NULLABLE | STRING | |
| glaccountkey | Internal use only; SSDB field | NULLABLE | INTEGER | |
| deleteid | This field stores a soft delete flag where 0=not deleted, 1=deleted | NULLABLE | INTEGER | |
| number | This field stores the six-character account number you assign to this GL account when you create the account | NULLABLE | STRING | |
| suffix | This field stores the four-character account number suffix, if any, you assign to this GL account when you create the account | NULLABLE | STRING | |
| branch | This field stores the four-character branch number, if any, you assign to this GL account when you create the account | NULLABLE | STRING | |
| lookup | This field stores a name by which you can look up the account | NULLABLE | STRING | |
| name | This field stores a name for the account | NULLABLE | STRING | |
| type | This field stores a code that indicates the function of the GL account on financial statements | NULLABLE | INTEGER | |
| lastfmdate | Symitar Quest stores the date in this field of the last file maintenance of the GL Account record | NULLABLE | DATE | |
| lasttrandate | Symitar Quest stores the date of the last monetary transaction that affected this GL Account record in this field | NULLABLE | DATE | |
| opencode | This field stores a code that indicates the status of this GL Account record | NULLABLE | INTEGER | |
| distributioncode | This field stores a code that determines whether this GL account is an overhead GL account | NULLABLE | INTEGER | |
| subtype | This field stores an optional credit union-defined code to further categorize your GL accounts | NULLABLE | INTEGER | |
| restrictionlevel | This field stores a code that lets you restrict transaction access to this GL Account record | NULLABLE | INTEGER | |
| usagetype | This field stores a code that specifies how Symitar Quest should use this GL account on the Income Statement or Balance Sheet | NULLABLE | INTEGER | |
| formattype | You can access this field only if the value in the Usage Type field is (1) Printout Formatting Account. This field stores a code that specifies how Symitar Quest should use this GL account on the financial reports | NULLABLE | INTEGER | |
| dcrestrictionlevel | This field stores a code that restricts the type of transactions (debits and credits) that credit union employees can post to GL Accounts | NULLABLE | INTEGER | |
| totallevel | This field stores a code that specifies which GL accounts total together on financial statements | NULLABLE | INTEGER | |
| balancesheetcolumn | This field stores a code that indicates where Symitar Quest should place the balance of the GL account if it prints on the Balance Sheet | NULLABLE | INTEGER | |
| printingcode | This field stores a code that specifies the level at which GL accounts are printed on financial statements | NULLABLE | INTEGER | |
| indentationcode | This field stores the number of spaces to indent the account name on financial statements | NULLABLE | INTEGER | |
| underscorecode | This field stores a code that indicates the type of underscore Symitar Quest prints under the dollar balance of this account on financial statements | NULLABLE | INTEGER | |
| blanklinecode | This field stores the number of lines to skip after printing this GL account and before printing the next GL account on financial statements | NULLABLE | INTEGER | |
| balance | Symitar Quest stores the balance of the GL account for the current accounting month in this field | NULLABLE | INTEGER | |
| balanceytd | This field stores the balance of the GL account for the current calendar year | NULLABLE | INTEGER | |
| balancelastyear | This field stores the balance of the GL account at the end of the previous calendar year | NULLABLE | INTEGER | |
| balancenextperiod | Symitar Quest stores the transaction activity total or change in the balance of the GL account for the next accounting period in this field | NULLABLE | INTEGER | |
| budget_1 | These fields store the 12 amounts budgeted for this GL account for January through December of the current calendar year | NULLABLE | INTEGER | |
| budget_2 | These fields store the 12 amounts budgeted for this GL account for January through December of the current calendar year | NULLABLE | INTEGER | |
| budget_3 | These fields store the 12 amounts budgeted for this GL account for January through December of the current calendar year | NULLABLE | INTEGER | |
| budget_4 | These fields store the 12 amounts budgeted for this GL account for January through December of the current calendar year | NULLABLE | INTEGER | |
| budget_5 | These fields store the 12 amounts budgeted for this GL account for January through December of the current calendar year | NULLABLE | INTEGER | |
| budget_6 | These fields store the 12 amounts budgeted for this GL account for January through December of the current calendar year | NULLABLE | INTEGER | |
| budget_7 | These fields store the 12 amounts budgeted for this GL account for January through December of the current calendar year | NULLABLE | INTEGER | |
| budget_8 | These fields store the 12 amounts budgeted for this GL account for January through December of the current calendar year | NULLABLE | INTEGER | |
| budget_9 | These fields store the 12 amounts budgeted for this GL account for January through December of the current calendar year | NULLABLE | INTEGER | |
| budget_10 | These fields store the 12 amounts budgeted for this GL account for January through December of the current calendar year | NULLABLE | INTEGER | |
| budget_11 | These fields store the 12 amounts budgeted for this GL account for January through December of the current calendar year | NULLABLE | INTEGER | |
| budget_12 | These fields store the 12 amounts budgeted for this GL account for January through December of the current calendar year | NULLABLE | INTEGER | |
| historicalbalance_1 | For Asset, Liability and Equity GL accounts these fields store balances from one to 12 months ago. For Income and Expense GL accounts, these fields store the activity from one to 12 months ago | NULLABLE | INTEGER | |
| historicalbalance_2 | For Asset, Liability and Equity GL accounts these fields store balances from one to 12 months ago. For Income and Expense GL accounts, these fields store the activity from one to 12 months ago | NULLABLE | INTEGER | |
| historicalbalance_3 | For Asset, Liability and Equity GL accounts these fields store balances from one to 12 months ago. For Income and Expense GL accounts, these fields store the activity from one to 12 months ago | NULLABLE | INTEGER | |
| historicalbalance_4 | For Asset, Liability and Equity GL accounts these fields store balances from one to 12 months ago. For Income and Expense GL accounts, these fields store the activity from one to 12 months ago | NULLABLE | INTEGER | |
| historicalbalance_5 | For Asset, Liability and Equity GL accounts these fields store balances from one to 12 months ago. For Income and Expense GL accounts, these fields store the activity from one to 12 months ago | NULLABLE | INTEGER | |
| historicalbalance_6 | For Asset, Liability and Equity GL accounts these fields store balances from one to 12 months ago. For Income and Expense GL accounts, these fields store the activity from one to 12 months ago | NULLABLE | INTEGER | |
| historicalbalance_7 | For Asset, Liability and Equity GL accounts these fields store balances from one to 12 months ago. For Income and Expense GL accounts, these fields store the activity from one to 12 months ago | NULLABLE | INTEGER | |
| historicalbalance_8 | For Asset, Liability and Equity GL accounts these fields store balances from one to 12 months ago. For Income and Expense GL accounts, these fields store the activity from one to 12 months ago | NULLABLE | INTEGER | |
| historicalbalance_9 | For Asset, Liability and Equity GL accounts these fields store balances from one to 12 months ago. For Income and Expense GL accounts, these fields store the activity from one to 12 months ago | NULLABLE | INTEGER | |
| historicalbalance_10 | For Asset, Liability and Equity GL accounts these fields store balances from one to 12 months ago. For Income and Expense GL accounts, these fields store the activity from one to 12 months ago | NULLABLE | INTEGER | |
| historicalbalance_11 | For Asset, Liability and Equity GL accounts these fields store balances from one to 12 months ago. For Income and Expense GL accounts, these fields store the activity from one to 12 months ago | NULLABLE | INTEGER | |
| historicalbalance_12 | For Asset, Liability and Equity GL accounts these fields store balances from one to 12 months ago. For Income and Expense GL accounts, these fields store the activity from one to 12 months ago | NULLABLE | INTEGER | |
| lastpurgedate | Symitar Quest stores the last transaction date for purge for this GL account | NULLABLE | DATE | |
| commentcode | This field stores the predefined comment code for General Ledger (GL) transactions to post to this GL account | NULLABLE | INTEGER | |
| fmlevel | This field stores a code that lets you restrict file maintenance access to this GL Account record | NULLABLE | INTEGER | |
| iqlevel | This field stores a code that lets you restrict inquiry access to this GL Account record | NULLABLE | INTEGER | |
| fmlastpurgedate | Symitar Quest stores the date in this field through which you last purged file maintenance history for the General Ledger records with the Purge Transaction Processing batch program | NULLABLE | DATE | |
| recordchangedate | Symitar Quest stores the system date when you create, change, or save the GL Account record in this field. Sometimes Symitar Quest 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