Versions Compared

Old Version 4

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

compared with

New Version 5

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Column
width33%

SUBSCRIPTION_FEES

Col #Column NameData TypeField LengthNot Null?Data Def.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

  
7

LAST_CHARGE_DATE

DATE

7

Y

  
8

END_DATE_LAST_PERIOD

DATE

7

N

  
9

NEXT_CHARGE_DATE

DATE

7

Y

  
10

PERIOD_LENGTH

NUMBER

22

Y

  
11

DISCOUNT

NUMBER22

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

  
13

QTY

NUMBER

22

Y

  
14

LOCKED_BY_PROCESS

VARCHAR2

10

Y

  
15

LOCKED_BY_PROCESS_DATE

DATE

7

Y

  
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

  
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

  
30META_DATAVARCHAR24000Y  
Column
width33%

Contains all recurring and one time fees