SUBSCRIPTION_FEE_LINE

Owned by Søren Duusgaard (Deactivated)
Last updated: 27.06.2014 by Former user (Deleted)

Groups

SUBSCRIPTION_FEE_LINE (Backend)

Col #

Column NameData 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