Groups
SUBSCRIPTION_FEES_LOG
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | SUBSCRIPTION_FEES_ID | NUMBER | 22 | Y | ||
| 3 | SUBSCRIPTION_ID | NUMBER | 22 | Y | ||
| 4 | PLAN_ELEMENT_ID | NUMBER | 22 | Y | ||
| 5 | DESCRIPTION | VARCHAR2 | 1000 | Y | ||
| 6 | ADDED_BY_OPERATOR | VARCHAR2 | 50 | Y | ||
| 7 | DATE_ADDED | DATE | 7 | Y | ||
| 8 | LAST_CHARGE_DATE | DATE | 7 | Y | ||
| 9 | END_DATE_LAST_PERIOD | DATE | 7 | Y | ||
| 10 | NEXT_CHARGE_DATE | DATE | 7 | Y | ||
| 11 | PERIOD_LENGTH | NUMBER | 22 | Y | ||
| 12 | DISCOUNT | NUMBER | 22 | Y | ||
| 13 | FEE_END_DATE | DATE | 7 | Y | ||
| 14 | QTY | NUMBER | 22 | Y | ||
| 15 | LOCKED_BY_PROCESS | VARCHAR2 | 10 | Y | ||
| 16 | LOCKED_BY_PROCESS_DATE | DATE | 7 | Y |