Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
|
| GLACCOUNT_ID | int | 4 | √ | null |
|
|
GL account ID. |
|
| TRANSACTION_SITE_ID | int | 4 | √ | null |
|
|
ID of the transaction site |
|
| REVENUE_SITE_ID | int | 4 | √ | null |
|
|
ID of the site where the revenue is recognized |
|
| TRANSACTION_DATE | datetime | 16,3 | √ | null |
|
|
Transaction date |
|
| RECEIPT_NUMBER | varchar | 255 | √ | null |
|
|
Number of the receipt for the transaction |
|
| ACTIVITY_ID | int | 4 | √ | null |
|
|
If this transaction relates to an activity, then this field displays the activity ID, otherwise this is hidden. |
|
| PACKAGE_ID | int | 4 | √ | null |
|
|
If this transaction relates to a membership package, then this field displays the package ID, otherwise this is hidden. |
|
| PROGRAM_ID | int | 4 | √ | null |
|
|
If this transaction relates to a FlexReg program, then this field displays the program ID, otherwise this is hidden. |
|
| RESOURCE_ID | int | 4 | √ | null |
|
|
If this transaction relates to a resource reservation, then this field displays the resource ID, otherwise this is hidden. |
|
| PERMIT_NUMBER | varchar | 255 | √ | null |
|
|
If this transaction relates to a resource reservation, then this field displays the permit number |
|
| CUSTOMER_ID | int | 4 | √ | null |
|
|
Customer ID |
|
| AMOUNT | decimal | 21,5 | √ | null |
|
|
Total charged amount for the transaction |
|
| CC_ECP_DC_AMOUNT | decimal | 21,5 | √ | null |
|
|
Amount paid by credit card/ ECP/ debit card |
|
| TRANSACTION_FEE | decimal | 21,5 | √ | null |
|
|
Transaction fee amount |
|
| CREDIT_CARD_FEE | decimal | 21,5 | √ | null |
|
|
Credit card fee amount |
|
| CONVENIENCE_FEE | decimal | 21,5 | √ | null |
|
|
Convenience fee amount |
|
| 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 |
|
| GL_LEDGER_ID | int | 4 | √ | null |
|
|
GL ledger ID |
|
| CHARGE_NAME | varchar | 150 | √ | null |
|
|
Shows the receipt charge name |
|
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user. Details will be in the table System_Users |
|
| STAFF_NOTES | varchar | 8000 | √ | null |
|
|
Staff notes added at the time of transaction |
|
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |
|
| CHARGE_ID | int | 4 | √ | null |
|
|
The ID of the related charge record |
|
| CUSTOMER_SCHOLARSHIP_ID | int | 4 | √ | null |
|
|
Customer scholarship ID |
|
| PERMIT_ID | int | 4 | √ | null |
|
|
Permit ID |
|
| COMPANY_ID | int | 4 | √ | null |
|
|
Company ID |
|
| POSPRODUCT_ID | int | 4 | √ | null |
|
|
If this transaction relates to a POS product sale, then this field displays the product ID, otherwise NULL. |
|
| SESSION_ID | int | 4 | √ | null |
|
|
If the transaction relates to any program sessions, then this field displays ID of the session, otherwise NULL. |
|
| WORKSTATION_ID | int | 4 | √ | null |
|
|
ID of the workstation where the transaction occurred |
|
| CAMPAIGN_ID | int | 4 | √ | null |
|
|
Campaign ID |
|
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
|
| VOIDED | bit | 1 | ((0)) |
|
|
Whether the GL posting has been voided (1 = voided / 0 = not voided) |
||
| VOIDED_BY | int | 4 | √ | null |
|
|
The ID of the system user who voided the GL posting |
|
| VOIDED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the GL posting was voided |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| FINANCIAL_GL_TRANSACTIONS_PK_v2 | Primary key | Asc | ACTIVE_HUB_KEY |
| FINANCIAL_GL_TRANSACTIONS_CAMPAIGN_ID_IX | Performance | Asc | CAMPAIGN_ID |
| FINANCIAL_GL_TRANSACTIONS_CHARGE_ID_IX | Performance | Asc | CHARGE_ID |
| FINANCIAL_GL_TRANSACTIONS_CUSTOMER_ID_PACKAGE_ID_IX | Performance | Asc/Asc | CUSTOMER_ID + PACKAGE_ID |
| FINANCIAL_GL_TRANSACTIONS_CUSTOMER_ID_TRANSACTION_DATE_PACKAGE_ID_IX | Performance | Asc/Asc/Asc | CUSTOMER_ID + TRANSACTION_DATE + PACKAGE_ID |
| FINANCIAL_GL_TRANSACTIONS_CUSTOMER_SCHOLARSHIP_ID_IX | Performance | Asc | CUSTOMER_SCHOLARSHIP_ID |
| FINANCIAL_GL_TRANSACTIONS_GL_LEDGER_ID_UQ | Must be unique | Asc | GL_LEDGER_ID |
| FINANCIAL_GL_TRANSACTIONS_GLACCOUNT_ID_IX | Performance | Asc | GLACCOUNT_ID |
| FINANCIAL_GL_TRANSACTIONS_nc_cs_ix | Performance | Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc | AMOUNT + CAMPAIGN_ID + CHARGE_ID + CUSTOMER_ID + CUSTOMER_SCHOLARSHIP_ID + GL_LEDGER_ID + GLACCOUNT_ID + PACKAGE_ID + PERMIT_NUMBER + RECEIPT_NUMBER + REVENUE_SITE_ID + TRANSACTION_DATE + VOIDED + VOIDED_BY + VOIDED_DATE_TIME |
| FINANCIAL_GL_TRANSACTIONS_PACKAGE_ID_IX | Performance | Asc | PACKAGE_ID |
| FINANCIAL_GL_TRANSACTIONS_PERMIT_NUMBER_IX | Performance | Asc | PERMIT_NUMBER |
| FINANCIAL_GL_TRANSACTIONS_receipt_number_IX | Performance | Asc | RECEIPT_NUMBER |
| FINANCIAL_GL_TRANSACTIONS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| FINANCIAL_GL_TRANSACTIONS_TRANSACTION_DATE_CUSTOMER_ID_PACKAGE_ID_IX | Performance | Asc/Asc/Asc | TRANSACTION_DATE + CUSTOMER_ID + PACKAGE_ID |
| FINANCIAL_GL_TRANSACTIONS_VOIDED_IX | Performance | Asc/Asc | VOIDED + VOIDED_DATE_TIME |