Groups
SUBSCRIPTION_FEES
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | SUBSCRIPTION_ID | NUMBER | 22 | Y | Reference to SUBSCRIPTION | |
| 3 | PLAN_ELEMENT_ID | NUMBER | 22 | Y | Reference to PLAN_ELEMENTS | |
| 4 | DESCRIPTION | VARCHAR2 | 1000 | Y | ||
| 5 | ADDED_BY_OPERATOR | VARCHAR2 | 50 | Y | ||
| 6 | DATE_ADDED | DATE | 7 | Y | ||
| 7 | LAST_CHARGE_DATE | DATE | 7 | Y | ||
| 8 | END_DATE_LAST_PERIOD | DATE | 7 | N | ||
| 9 | NEXT_CHARGE_DATE | DATE | 7 | Y | ||
| 10 | PERIOD_LENGTH | NUMBER | 22 | Y | ||
| 11 | DISCOUNT | NUMBER | 22 | Y | ||
| 12 | FEE_END_DATE | DATE | 7 | Y | ||
| 13 | QTY | NUMBER | 22 | Y | ||
| 14 | LOCKED_BY_PROCESS | VARCHAR2 | 10 | Y | ||
| 15 | LOCKED_BY_PROCESS_DATE | DATE | 7 | Y | ||
| 16 | CODE | VARCHAR2 | 120 | Y | ||
| 17 | OBJECT_ID | NUMBER | 22 | Y | ||
| 18 | OBJECT_TYPE | VARCHAR2 | 120 | Y | ||
| 19 | CONCURRENCY_KEY | NUMBER | 22 | Y | ||
| 20 | SOURCE_OBJECT_ID | NUMBER | 22 | Y | Reference to table identified by content of column SOURCE_OBJECT_TABLE | |
| 21 | SOURCE_OBJECT_TABLE | VARCHAR2 | 120 | Y | ||
| 22 | QTY_CHARGED | NUMBER | 22 | Y | ||
| 23 | FINALIZED | VARCHAR2 | 4 | Y | ||
| 24 | PRICE_CODE | VARCHAR2 | 200 | Y | ||
| 25 | SERVICE_CODE | VARCHAR2 | 200 | Y | ||
| 26 | NEXT_CHARGE_DATE_STRATEGY | VARCHAR2 | 300 | Y | ||
| 27 | PRICE_RETRIEVAL_STRATEGY | VARCHAR2 | 512 | Y | ||
| 28 | FEE_PROFILE_TYPE_ID | NUMBER | 22 | Y | Reference to FEE_PROFILE_TYPE | |
| 29 | STATUS_ID | NUMBER | 22 | Y | ||
| 30 | META_DATA | VARCHAR2 | 4000 | Y |
Contains all recurring and one time fees