BUNDLE
Groups
BUNDLE
Col # | Column Name | Data Type | Field Length | Not 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 |
Definition of all Bundles