PRODUCT_OPTION

Owned by Daniel Hostrup Eriksen
Last updated: 27.06.2014 by Former user (Deleted)

Groups

PRODUCT_OPTION

Col #

Column NameData TypeField Length Not Null? Data Def.Comments
1

ID

NUMBER

22

N

 Primary key
2

NAME

VARCHAR2

256

Y

  
3

DESCRIPTION

VARCHAR2

256

Y

  
4

LABEL

VARCHAR2

256

Y

  
5

PARENT_ID

NUMBER

22

Y

 Reference to PRODUCT_OPTION (parent)
6

SUB_OPTIONS_EXCLUSIVE

CHAR

1

Y

  
7

CODE

VARCHAR2

20

Y

  
8

TAG

VARCHAR2

20

Y

  
9

HANDLER_TAG

VARCHAR2

20

Y

  
10

PROVISIONING_TAG

VARCHAR2

25

Y

  
11

PRICE_CODE

VARCHAR2

40

Y

  
12

OPTION_KEY

VARCHAR2

50

Y

  
13

WEB_DESCRIPTION

VARCHAR2

4000

Y

  
14

HAS_LICENSE_AGREEMENT

CHAR

1

Y

  
15

LICENSE_AGREEMENT

VARCHAR2

4000

Y

  
16

ON_SELECT_METHOD

VARCHAR2

100

Y

  
17

COMPLETE_IT_METHOD

VARCHAR2

100

Y

  
18

ON_UNSUBSCRIBE_METHOD

VARCHAR2

100

Y

  
19

DEFAULT_SUBSCRIBE_STATUS_ID

NUMBER

22

Y

  
20

DEFAULT_UNSUBSCRIBE_STATUS_ID

NUMBER

22

Y

  
21

TYPE_ID

NUMBER

22

Y

  
22

CATEGORY

VARCHAR2

30

Y

  
23

PRODUCT_OPTION_CATEGORY_ID

NUMBER

22

Y

 Reference to PRODUCT_OPTION_CATEGORY
24

SUB_LOCKIN_TYPE_ID

NUMBER

22

Y

 Reference to SUBSCRIPTION_LOCKIN_TYPE
25

CAMPAIGN_ID

NUMBER

22

Y

 Reference to CAMPAIGN
26

CAN_MODIFY_METHOD

VARCHAR2

100

Y

  
27

IS_EXCLUSIVE

CHAR

4

Y

  
28

GROUP_NAME

VARCHAR2

400

Y

  

Definition of all Products to which a Subscription/SIM can subscribe