Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SYSTEM_GL_ACCOUNT_PACKAGE_ID | int | 4 | null |
|
|
The system GL account package ID |
|||||||||||||||||||||||||||||||||||
| SYSTEM_GL_ACCOUNT_PACKAGE_NAME | varchar | 50 | √ | null |
|
|
The system GL account package name |
||||||||||||||||||||||||||||||||||
| FUND_ID | int | 4 | √ | null |
|
|
The ID of the fund that this system GL account package is related to |
||||||||||||||||||||||||||||||||||
| FUND_NAME | varchar | 50 | √ | null |
|
|
The name of the fund that this system GL account package is related to |
||||||||||||||||||||||||||||||||||
| PAYMENT_CASH_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for cash payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CASH_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name for cash payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CASH_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number for cash payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CHECK_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for check payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CHECK_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name for check payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CHECK_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number for check payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CREDIT_CARD_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for credit card payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CREDIT_CARD_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name for credit card payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CREDIT_CARD_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number for credit card payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_DEBIT_CARD_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for debit card payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_DEBIT_CARD_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name for debit card payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_DEBIT_CARD_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number for debit card payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CREDIT_MEMO_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for credit memo payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CREDIT_MEMO_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name for credit memo payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CREDIT_MEMO_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number for credit memo payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_ECP_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for electronic check processing (ECP) payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_ECP_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name for electronic check processing (ECP) payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_ECP_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number for electronic check processing (ECP) payments |
||||||||||||||||||||||||||||||||||
| DEFERRED_REVENUE_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for deferred revenue |
||||||||||||||||||||||||||||||||||
| DEFERRED_REVENUE_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name for deferred revenue |
||||||||||||||||||||||||||||||||||
| DEFERRED_REVENUE_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number for deferred revenue |
||||||||||||||||||||||||||||||||||
| ACCOUNTS_RECEIVABLE_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for accounts receivable |
||||||||||||||||||||||||||||||||||
| ACCOUNTS_RECEIVABLE_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name for accounts receivable |
||||||||||||||||||||||||||||||||||
| ACCOUNTS_RECEIVABLE_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number for accounts receivable |
||||||||||||||||||||||||||||||||||
| FUTURE_RECEIVABLES_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for future accounts receivable |
||||||||||||||||||||||||||||||||||
| FUTURE_RECEIVABLES_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name for future accounts receivable |
||||||||||||||||||||||||||||||||||
| FUTURE_RECEIVABLES_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number for future accounts receivable |
||||||||||||||||||||||||||||||||||
| DEFERRED_RECEIVABLES_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for deferred accounts receivable |
||||||||||||||||||||||||||||||||||
| DEFERRED_RECEIVABLES_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name for deferred accounts receivable |
||||||||||||||||||||||||||||||||||
| DEFERRED_RECEIVABLES_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number for deferred accounts receivable |
||||||||||||||||||||||||||||||||||
| REFUND_CLEARING_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for refund clearing |
||||||||||||||||||||||||||||||||||
| REFUND_CLEARING_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name for refund clearing |
||||||||||||||||||||||||||||||||||
| REFUND_CLEARING_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number for refund clearing |
||||||||||||||||||||||||||||||||||
| IS_RETIRED | varchar | 5 | √ | null |
|
|
Whether this system GL account package has been retired from further use (Yes/No) |
||||||||||||||||||||||||||||||||||
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
Date and time Hub record was last modified |
|||||||||||||||||||||||||||||||||||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The Hub sync process ID |
||||||||||||||||||||||||||||||||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |