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 |
||||||||||||||||||||||||||||||||||
| PAYMENT_CASH_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for cash payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CHECK_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for check payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CREDIT_CARD_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for credit card payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_DEBIT_CARD_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for debit card payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_CREDIT_MEMO_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for credit memo payments |
||||||||||||||||||||||||||||||||||
| PAYMENT_ECP_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for electronic check processing (ECP) payments |
||||||||||||||||||||||||||||||||||
| DEFERRED_REVENUE_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for deferred revenue |
||||||||||||||||||||||||||||||||||
| ACCOUNTS_RECEIVABLE_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for accounts receivable |
||||||||||||||||||||||||||||||||||
| FUTURE_RECEIVABLES_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for future accounts receivable |
||||||||||||||||||||||||||||||||||
| DEFERRED_RECEIVABLES_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for deferred accounts receivable |
||||||||||||||||||||||||||||||||||
| REFUND_CLEARING_GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID for refund clearing |
||||||||||||||||||||||||||||||||||
| IS_RETIRED | varchar | 5 | √ | null |
|
|
Whether this system GL account package has been retired from further use (Yes/No) |
||||||||||||||||||||||||||||||||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
||||||||||||||||||||||||||||||||||
| LAST_SYNC_TIME | datetime | 16,3 | (getdate()) |
|
|
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 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| SYSTEM_GL_ACCOUNT_PACKAGES_SYSTEM_GL_ACCOUNT_PACKAGE_ID_ORG_ID_PK | Primary key | Asc/Asc | SYSTEM_GL_ACCOUNT_PACKAGE_ID + ORG_ID |
| SYSTEM_GL_ACCOUNT_PACKAGES_ACCOUNTS_RECEIVABLE_GLACCOUNT_ID_IX | Performance | Asc | ACCOUNTS_RECEIVABLE_GLACCOUNT_ID |
| SYSTEM_GL_ACCOUNT_PACKAGES_DEFERRED_RECEIVABLES_GLACCOUNT_ID_IX | Performance | Asc | DEFERRED_RECEIVABLES_GLACCOUNT_ID |
| SYSTEM_GL_ACCOUNT_PACKAGES_DEFERRED_REVENUE_GLACCOUNT_ID_IX | Performance | Asc | DEFERRED_REVENUE_GLACCOUNT_ID |
| SYSTEM_GL_ACCOUNT_PACKAGES_FUTURE_RECEIVABLES_GLACCOUNT_ID_IX | Performance | Asc | FUTURE_RECEIVABLES_GLACCOUNT_ID |
| SYSTEM_GL_ACCOUNT_PACKAGES_PAYMENT_CASH_GLACCOUNT_ID_IX | Performance | Asc | PAYMENT_CASH_GLACCOUNT_ID |
| SYSTEM_GL_ACCOUNT_PACKAGES_PAYMENT_CHECK_GLACCOUNT_ID_IX | Performance | Asc | PAYMENT_CHECK_GLACCOUNT_ID |
| SYSTEM_GL_ACCOUNT_PACKAGES_PAYMENT_CREDIT_CARD_GLACCOUNT_ID_IX | Performance | Asc | PAYMENT_CREDIT_CARD_GLACCOUNT_ID |
| SYSTEM_GL_ACCOUNT_PACKAGES_PAYMENT_CREDIT_MEMO_GLACCOUNT_ID_IX | Performance | Asc | PAYMENT_CREDIT_MEMO_GLACCOUNT_ID |
| SYSTEM_GL_ACCOUNT_PACKAGES_PAYMENT_DEBIT_CARD_GLACCOUNT_ID_IX | Performance | Asc | PAYMENT_DEBIT_CARD_GLACCOUNT_ID |
| SYSTEM_GL_ACCOUNT_PACKAGES_PAYMENT_ECP_GLACCOUNT_ID_IX | Performance | Asc | PAYMENT_ECP_GLACCOUNT_ID |
| SYSTEM_GL_ACCOUNT_PACKAGES_REFUND_CLEARING_GLACCOUNT_ID_IX | Performance | Asc | REFUND_CLEARING_GLACCOUNT_ID |
| SYSTEM_GL_ACCOUNT_PACKAGES_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |