Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| AS_OF_DATE | date | 20 | √ | null |
|
|
The effective date that the revenue recognition has been calculated as of |
||||
| 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 |
||||
| DEFERRED_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
The deferred revenue GL account name |
||||
| DEFERRED_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
The deferred revenue GL account number |
||||
| REVENUE_GLACCOUNT_ID | int | 4 | √ | null |
|
|
The revenue GL account ID that will be posted to when the revenue is recognized |
||||
| REVENUE_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
The revenue GL account name that will be posted to when the revenue is recognized |
||||
| REVENUE_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
The revenue GL account number 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) |
||||
| FISCAL_PERIOD_TYPE_NAME | varchar | 38 | null |
|
|
The fiscal period type name (When Payment Received / Daily / Weekly / Monthly / Quarterly / Yearly / At Item Start Date / At Item Start Date and Fiscal Year End) |
|||||
| 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 |
||||
| TRANSACTION_SITE_NAME | varchar | 255 | √ | null |
|
|
The site name where the transaction took place |
||||
| REVENUE_SITE_ID | int | 4 | √ | null |
|
|
The site ID that the revenue applies to |
||||
| REVENUE_SITE_NAME | varchar | 255 | √ | null |
|
|
The site name that the revenue applies to |
||||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
The activity ID that the revenue applies to |
||||
| ACTIVITY_NAME | varchar | 100 | √ | null |
|
|
The activity name that the revenue applies to |
||||
| ACTIVITY_NUMBER | varchar | 20 | √ | null |
|
|
The activity number that the revenue applies to |
||||
| PROGRAM_ID | int | 4 | √ | null |
|
|
The program ID that the revenue applies to |
||||
| PROGRAM_NAME | varchar | 255 | √ | null |
|
|
The program name that the revenue applies to |
||||
| PACKAGE_ID | int | 4 | √ | null |
|
|
The package ID that the revenue applies to |
||||
| PACKAGE_NAME | varchar | 255 | √ | null |
|
|
The package name that the revenue applies to |
||||
| FACILITY_ID | int | 4 | √ | null |
|
|
The facility ID that the revenue applies to |
||||
| FACILITY_NAME | varchar | 255 | √ | null |
|
|
The facility name that the revenue applies to |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The customer ID that the revenue applies to |
||||
| CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
The customer’s name that the revenue applies to |
||||
| CUSTOMER_NAME_LAST_FIRST | varchar | 512 | √ | null |
|
|
The customer’s name that the revenue applies to (last name, first name) |
||||
| COMPANY_ID | int | 4 | √ | null |
|
|
The company ID that the revenue applies to |
||||
| COMPANY_NAME | varchar | 255 | √ | null |
|
|
The company name that the revenue applies to |
||||
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||
| 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 |