{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_FEE_LINE (Backend)
Col#
Column Name
Data Type
Not Null?
Data Def.
Comments
1
ID
NUMBER
22
N
Primary key
2
SUBSCRIPTION_FEE_ID
NUMBER
22
Y
Reference to SUBSCRIPTION_FEES
3
STATUS_ID
NUMBER
22
Y
4
FROM_DATE
DATE
7
Y
5
TO_DATE
DATE
7
Y
6
CHARGE_ITEM_ID
NUMBER
22
Y
Reference to CHARGE_ITEM
7
PLAN_ELEMENT_ID
NUMBER
22
Y
Reference to PLAN_ELEMENTS
8
DISCOUNT_ID
NUMBER
22
Y
Reference to DISCOUNTS
9
BUNDLE_ID
NUMBER
22
Y
Reference to BUNDLE
10
VALUE_EX_VAT
NUMBER
22
Y
11
VALUE_VAT
NUMBER
22
Y
12
INVOICE_DETAIL_LINE_ID
NUMBER
22
Y
Reference to INVOICE_DETAIL_LINE
13
BALANCE_LINE_ID
NUMBER
22
Y
Reference to SUBSCRIPTION_FEE_LINE
14
BILLING_GROUP_ID
NUMBER
22
Y
Reference to BILLING_GROUP
15
PERIOD_NUMBER
NUMBER
22
Y
16
CREATING_PROCESS_ID
NUMBER
22
Y
Column
width
33%
Contains information of fees added to subscriptions