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
NUMBER
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.