Groups
SUBSCRIPTION_TERMINATION
| 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 | STATE_ID | NUMBER | 22 | Y | ||
| 4 | WORKFLOW_ID | NUMBER | 22 | Y | Reference to WF_WORKFLOW | |
| 5 | EXPECTED_TERMINATION_DATE | DATE | 7 | Y | ||
| 6 | REQUESTED_ON_DATE | DATE | 7 | Y | ||
| 7 | REQUESTED_BY_OPERATOR | VARCHAR2 | 50 | Y | ||
| 8 | IS_ACTIVE | CHAR | 1 | Y | ||
| 9 | REASON | VARCHAR2 | 100 | Y | ||
| 10 | COMMENTS | VARCHAR2 | 1000 | Y | ||
| 11 | REASON_ID | NUMBER | 22 | Y | ||
| 12 | COMMENTS2 | VARCHAR2 | 4000 | Y | ||
| 13 | CAN_CONTACT_CUSTOMER | NUMBER | 22 | Y | ||
| 14 | ORDER_DATE | DATE | 7 | Y | ||
| 15 | PROVIDER_ID | NUMBER | 22 | Y | ||
| 16 | ADD_TERMINATE_FEE | VARCHAR2 | 4 | Y | ||
| 17 | FINALIZED | VARCHAR2 | 4 | Y | ||
| 18 | CHARGE_UNTIL_DATE | DATE | 7 | Y |
Contains information about terminated subscriptions