SUBSCRIPTION_FEES

Groups

SUBSCRIPTION_FEES

Col #	Column Name	Data Type	Field Length	Not Null?	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	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.
23	FINALIZED	VARCHAR2	4	Y
24	PRICE_CODE	VARCHAR2	200	Y
25	SERVICE_CODE	VARCHAR2	200	Y
26	NEXT_CHARGE_DATE_STRATEGY	VARCHAR2	300	Y
27	PRICE_RETRIEVAL_STRATEGY	VARCHAR2	512	Y
28	FEE_PROFILE_TYPE_ID	NUMBER	22	Y	Reference to FEE_PROFILE_TYPE
29	STATUS_ID	NUMBER	22	Y
30	META_DATA	VARCHAR2	4000	Y

Contains all recurring and one time fees