Groups
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 |
Contains information of fees added to subscriptions