Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
||||
| AS_OF_DATE | date | 20 | √ | null |
|
|
The effective date that the revenue recognition has been calculated as of |
||||
| DEFERRED_REVENUE_PROJECTION_ID | int | 4 | √ | null |
|
|
The record counter within the as of date |
||||
| ORIGINAL_TRANSACTION_ID | int | 4 | √ | null |
|
|
The original transaction ID that the revenue is related to |
||||
| ORIGINAL_RECEIPT_DETAIL_ID | int | 4 | √ | null |
|
|
The original receipt detail ID that the revenue is related to |
||||
| GL_LEDGER_ID | int | 4 | √ | null |
|
|
The GL ledger ID for the deferred revenue posting |
||||
| DEFERRED_GLACCOUNT_ID | int | 4 | √ | null |
|
|
The deferred revenue GL account ID |
||||
| REVENUE_GLACCOUNT_ID | int | 4 | √ | null |
|
|
The revenue GL account ID that will be posted to when the revenue is recognized |
||||
| RECOGNIZE_DATE | date | 20 | √ | null |
|
|
The date that the revenue is scheduled to be recognized |
||||
| RECOGNIZE_AMOUNT | money | 21,4 | √ | null |
|
|
The amount of revenue that is scheduled to be recognized |
||||
| FISCAL_PERIOD_TYPE_ID | int | 4 | √ | null |
|
|
The fiscal period type ID (0=When Payment Received, 1=Daily, 2=Weekly, 3=Monthly, 4=Quarterly, 5=Yearly, 6=At Item Start Date, 7=At Item Start Date and Fiscal Year End) |
||||
| RECOGNITION_SOURCE | int | 4 | √ | null |
|
|
The process stage that the projection was calculated (for internal use) |
||||
| MODULE_NAME | varchar | 20 | √ | null |
|
|
The name of the module that the revenue applies to (Activities / Programs / Facilities / Memberships / Other) |
||||
| TRANSACTION_SITE_ID | int | 4 | √ | null |
|
|
The site ID where the transaction took place |
||||
| REVENUE_SITE_ID | int | 4 | √ | null |
|
|
The site ID that the revenue applies to |
||||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
The activity ID that the revenue applies to |
||||
| PROGRAM_ID | int | 4 | √ | null |
|
|
The program ID that the revenue applies to |
||||
| FACILITY_ID | int | 4 | √ | null |
|
|
The facility ID that the revenue applies to |
||||
| PACKAGE_ID | int | 4 | √ | null |
|
|
The package ID that the revenue applies to |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The customer ID that the revenue applies to |
||||
| COMPANY_ID | int | 4 | √ | null |
|
|
The company ID that the revenue applies to |
||||
| 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) |
|---|---|---|---|
| DEFERRED_REVENUE_PROJECTIONS_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| DEFERRED_REVENUE_PROJECTIONS_ACTIVITY_ID_IX | Performance | Asc | ACTIVITY_ID |
| DEFERRED_REVENUE_PROJECTIONS_AS_OF_DATE_IX | Performance | Asc | AS_OF_DATE |
| DEFERRED_REVENUE_PROJECTIONS_COMPANY_ID_IX | Performance | Asc | COMPANY_ID |
| DEFERRED_REVENUE_PROJECTIONS_CUSTOMER_ID_IX | Performance | Asc | CUSTOMER_ID |
| DEFERRED_REVENUE_PROJECTIONS_DEFERRED_GLACCOUNT_ID_IX | Performance | Asc | DEFERRED_GLACCOUNT_ID |
| DEFERRED_REVENUE_PROJECTIONS_FACILITY_ID_IX | Performance | Asc | FACILITY_ID |
| DEFERRED_REVENUE_PROJECTIONS_GL_LEDGER_ID_IX | Performance | Asc | GL_LEDGER_ID |
| DEFERRED_REVENUE_PROJECTIONS_ORG_ID_IX | Performance | Asc | ORG_ID |
| DEFERRED_REVENUE_PROJECTIONS_ORIGINAL_RECEIPT_DETAIL_ID_IX | Performance | Asc | ORIGINAL_RECEIPT_DETAIL_ID |
| DEFERRED_REVENUE_PROJECTIONS_ORIGINAL_TRANSACTION_ID_IX | Performance | Asc | ORIGINAL_TRANSACTION_ID |
| DEFERRED_REVENUE_PROJECTIONS_PACKAGE_ID_IX | Performance | Asc | PACKAGE_ID |
| DEFERRED_REVENUE_PROJECTIONS_PROGRAM_ID_IX | Performance | Asc | PROGRAM_ID |
| DEFERRED_REVENUE_PROJECTIONS_RECOGNIZE_DATE_IX | Performance | Asc | RECOGNIZE_DATE |
| DEFERRED_REVENUE_PROJECTIONS_REVENUE_GLACCOUNT_ID_IX | Performance | Asc | REVENUE_GLACCOUNT_ID |
| DEFERRED_REVENUE_PROJECTIONS_REVENUE_SITE_ID_IX | Performance | Asc | REVENUE_SITE_ID |
| DEFERRED_REVENUE_PROJECTIONS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| DEFERRED_REVENUE_PROJECTIONS_TRANSACTION_SITE_ID_IX | Performance | Asc | TRANSACTION_SITE_ID |