SUBSCRIPTION_TERMINATION

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

Groups

SUBSCRIPTION_TERMINATION

Col #Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key
2

SUBSCRIPTION_ID

NUMBER

22

Y

 Reference to SUBSCRIPTION
3

STATE_ID

NUMBER

22

Y

  
4

WORKFLOW_ID

NUMBER

22

Y

 Reference to WF_WORKFLOW
5

EXPECTED_TERMINATION_DATE

DATE

7

Y

  
6

REQUESTED_ON_DATE

DATE

7

Y

  
7

REQUESTED_BY_OPERATOR

VARCHAR2

50

Y

  
8

IS_ACTIVE

CHAR

1

Y

  
9

REASON

VARCHAR2

100

Y

  
10

COMMENTS

VARCHAR2

1000

Y

  
11

REASON_ID

NUMBER

22

Y

  
12

COMMENTS2

VARCHAR2

4000

Y

  
13

CAN_CONTACT_CUSTOMER

NUMBER

22

Y

  
14

ORDER_DATE

DATE

7

Y

  
15

PROVIDER_ID

NUMBER

22

Y

  
16

ADD_TERMINATE_FEE

VARCHAR2

4

Y

  
17

FINALIZED

VARCHAR2

4

Y

  
18

CHARGE_UNTIL_DATE

DATE

7

Y

  

Contains information about terminated subscriptions