SUBSCRIPTION_FEES_LOG

Groups

SUBSCRIPTION_FEES_LOG

Col #Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key
2

SUBSCRIPTION_FEES_ID

NUMBER

22

Y

  
3

SUBSCRIPTION_ID

NUMBER

22

Y

  
4

PLAN_ELEMENT_ID

NUMBER

22

Y

  
5

DESCRIPTION

VARCHAR2

1000

Y

  
6

ADDED_BY_OPERATOR

VARCHAR2

50

Y

  
7

DATE_ADDED

DATE

7

Y

  
8

LAST_CHARGE_DATE

DATE

7

Y

  
9

END_DATE_LAST_PERIOD

DATE

7

Y

  
10

NEXT_CHARGE_DATE

DATE

7

Y

  
11

PERIOD_LENGTH

NUMBER

22

Y

  
12

DISCOUNT

NUMBER

22

Y

  
13

FEE_END_DATE

DATE

7

Y

  
14

QTY

NUMBER

22

Y

  
15

LOCKED_BY_PROCESS

VARCHAR2

10

Y

  
16

LOCKED_BY_PROCESS_DATE

DATE

7

Y

  

 

Â