SUBSCRIPTION_FEES_LOG
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 | Â | Â |
Â
Â