Groups
SUBSCRIPTION_BUNDLE
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | KEY | VARCHAR2 | 200 | Y | ||
| 3 | SUBSCRIPTION_ID | NUMBER | 22 | Y | Reference to SUBSCRIPTION (redundant from SUBSCRIPTION_CAMPAIGN_ID) | |
| 4 | CAMPAIGN_ID | NUMBER | 22 | Y | Reference to CAMPAIGN (redundant from SUBSCRIPTION_CAMPAIGN_ID) | |
| 5 | BUNDLE_ID | NUMBER | 22 | Y | Reference to BUNDLE | |
| 6 | PERIOD | VARCHAR2 | 20 | Y | ||
| 7 | STATUS_ID | NUMBER | 22 | Y | ||
| 8 | VALUE1 | NUMBER | 22 | Y | ||
| 9 | VALUE2 | NUMBER | 22 | Y | ||
| 10 | VALUE3 | NUMBER | 22 | Y | ||
| 11 | VALUE4 | NUMBER | 22 | Y | ||
| 12 | SUBSCRIPTION_CAMPAIGN_ID | NUMBER | 22 | Y | Reference to SUBSCRIPTION_CAMPAIGN | |
| 13 | CHARGE_ITEM_ID | NUMBER | 22 | Y | Reference to CHARGE_ITEM | |
| 14 | CONCURRENCY_KEY | NUMBER | 22 | Y | ||
| 15 | ALERT_GROUP_ID | NUMBER | 22 | Y | Deprecated | |
| 16 | FROM_DATE | DATE | 7 | Y | ||
| 17 | TO_DATE | DATE | 7 | Y | ||
| 18 | CURRENCY_CODE | VARCHAR2 | 12 | Y |
Contains information on which bundles subscribe to which subscription at a given time