SERVICE_OPTION

Owned by Daniel Hostrup Eriksen
Last updated: 20.09.2017 by Søren Duusgaard (Deactivated)

Groups

SERVICE_OPTION

Column NameData TypeField LengthNot Null?Data Def.Comments

ID

NUMBER

22

N

 Primary key

SERVICE_ID

NUMBER

22

Y

 Reference to SERVICE (main relation)

START_DATE

DATE

7

Y

  

END_DATE

DATE

7

Y

  

STATUS_ID

NUMBER

22

Y

  

PRODUCT_OPTION_ID

NUMBER

22

Y

 Reference to PRODUCT_OPTION

LAST_CHANGED_BY

VARCHAR2

40

Y

  

RECURRENT_FEE_ID

NUMBER

22

Y

 Reference to SUBSCRIPTION_FEES

NETWORK_STATUS_ID

VARCHAR2

50

Y

  

SUBSCRIPTION_CAMPAIGN_ID

NUMBER

22

Y

 Reference to SUBSCRIPTION_CAMPAIGN

PROVISIONING_TASK_ID

NUMBER

22

Y

 Reference to PROVISIONING_TASK

OBJECT_ID

NUMBER

22

Y

 Not used in application

CODE

VARCHAR2

50

Y

  

SOURCE_OBJECT_ID

NUMBER

22

Y

 Reference to SERVICE (for now - available for extension to other tables)