Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||
| FACILITY_USAGE_REVENUE_ID | int | 4 | √ | null |
|
|
Facility usage revenue ID |
||||
| PERMIT_ID | int | 4 | √ | null |
|
|
Permit ID that the revenue is for |
||||
| PERMIT_NUMBER | int | 4 | √ | null |
|
|
Permit number that the revenue is for |
||||
| PERMIT_EVENT_NAME | varchar | 200 | √ | null |
|
|
Permit event name |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
ID of the customer that the permit belongs to |
||||
| CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
Name of the customer that the permit belongs to |
||||
| COMPANY_ID | int | 4 | √ | null |
|
|
ID of the company that the permit belongs to |
||||
| COMPANY_NAME | varchar | 255 | √ | null |
|
|
Name of the company that the permit belongs to |
||||
| FACILITY_ID | int | 4 | √ | null |
|
|
Facility ID that the revenue is for |
||||
| FACILITY_NAME | varchar | 255 | √ | null |
|
|
Facility name that the revenue is for |
||||
| EVENT_TYPE_ID | int | 4 | √ | null |
|
|
Event type ID that the revenue is for |
||||
| EVENT_TYPE | varchar | 102 | √ | null |
|
|
Event type name that the revenue is for |
||||
| SCHEDULE_TYPE_ID | int | 4 | √ | null |
|
|
Schedule type ID that the revenue is for |
||||
| SCHEDULE_TYPE | varchar | 80 | √ | null |
|
|
Schedule type name that the revenue is for |
||||
| SCHEDULE_DATE | date | 20 | √ | null |
|
|
Date that the revenue is calculated for |
||||
| USAGE_REVENUE | money | 21,4 | √ | null |
|
|
The calculated amount of revenue for this permit and facility on this date |
||||
| 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 |