{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width
33%
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
Column
width
33%
Contains information about terminated subscriptions