SUBSCRIPTION_BUNDLE

Owned by Søren Duusgaard (Deactivated)
Last updated: 27.06.2014 by Former user (Deleted)

Groups

SUBSCRIPTION_BUNDLE

Col #

Column NameData TypeField LengthNot 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