Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |
||
| ACTIVITY_SCHEDULED_FEE_RATE_ID | int | 4 | null |
|
|
The ID value from the Active Net system |
||
| SCHEDULED_FEE | money | 21,4 | √ | null |
|
|
Amount of fee |
|
| SCHEDULED_DATE | datetime | 16,3 | √ | null |
|
|
Date of change based on Activity Start Date |
|
| ACTIVITY_FEE_ID | int | 4 | √ | null |
|
|
Populated from SCHEDULEDFEES_ID |
|
| ACTIVITY_ID | int | 4 | √ | null |
|
|
Refers to ACTIVITY_FEES.ACTIVITY_ID |
|
| ACTIVITYNAME | nvarchar | 240 | √ | null |
|
|
Refers to ACTIVITIES.ACTIVITY_NAME |
|
| ACTIVITYNUMBER | varchar | 20 | √ | null |
|
|
Refers to ACTIVITIES.ACTIVITY_NUMBER |