{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_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