Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section


Column
width33%

Groups

Wiki Markup
{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
width33%

BUNDLE

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

ID

NUMBER

22

N

 
Primary key
2

CAMPAIGN_ID

NUMBER

22

Y


Reference to CAMPAIGN
3

CODE

VARCHAR2

80

Y

 

4

NAME

VARCHAR2

80

Y

  
 Short name of the bundle, used to distinguish this bundle from the other on the same campaign.
5

DESCRIPTION

VARCHAR2

2000

Y

 
 Longer description of bundle; it explains what the bundle does and what the parameters are used for.
6

RECURRENCE_ID

NUMBER

22

Y

  
 0=no recurrence, 1=hourly, 30=monthly, 7=daily
7

VALUE1

NUMBER

22

Y

 



8

VALUE2

NUMBER

22

Y

 

9

VALUE3

NUMBER

22

Y

 



10

VALUE4

NUMBER

22

Y

 



11

CHARGE_ITEM_ID

NUMBER

22

Y


Reference to CHARGE_ITEM (deprecated)
12

PERIOD_HANDLER_ID

NUMBER

22

Y


Deprecated
13

RATE_PRIORITY

NUMBER

22

Y

 
 The priority for this bundle in the rating process. Bundles with a lower priority are rated first. Must be unique for all bundles related to the same campaign.
14

ALERT_GROUP_ID

NUMBER

22

Y

 
Deprecated
15

IS_RATING_EXCLUSIVE

NUMBER

22

Y

 



16

PARAMETERS

VARCHAR2

4000

Y

 
 

Configuration of the bundle behaviour

17

USE_DATE_FIELDS

NUMBER

22

N

 



18

CURRENCY_CODE

VARCHAR2

12

Y

 



19

BUNDLE_KEY

VARCHAR2

50

Y

 



20

META_DATA

VARCHAR2

4000

Y

  
 






Column
width33%

Definition of all Bundles


...