{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
Date the fee was added to the Subscription
7
LAST_CHARGE_DATE
DATE
7
Y
Last date the fee was charged (when was the last time an IDL was generated for the fee)
8
END_DATE_LAST_PERIOD
DATE
7
N
For recurring fees, the fee has been charged until this date (We need to know this date, so we can prorate appropriately when unsubscribing from the option linked to this fee).
9
NEXT_CHARGE_DATE
DATE
7
Y
The next date the fee should be charged (when should the Subscription Fee Biller Engine next handle this fee)
10
PERIOD_LENGTH
NUMBER
22
Y
11
DISCOUNT
NUMBER22
5,2
Y
Extended the precision of the discount column to handle the value 100. Modified with 10.3
12
FEE_END_DATE
DATE
7
Y
For recurring fees which should be charged until a particular end date, this is the end date
13
QTY
NUMBER
22
Y
14
LOCKED_BY_PROCESS
VARCHAR2
10
Y
15
LOCKED_BY_PROCESS_DATE
DATE
7
Y
Used by Subscription Fee Biller to avoid double-handling of fees
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
21
SOURCE_OBJECT_TABLE
VARCHAR2
120
Y
22
QTY_CHARGED
NUMBER
22
Y
The number of periods this fee has previously been charged for.