/
RECHARGE_TICKET

RECHARGE_TICKET

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

Groups

RECHARGE_TICKET

Column NameData Type Not Null?Data Def.Comments

ID

NUMBER

22

N

 Primary key

BILLING_GROUP_ID

NUMBER

22

Y

 Reference to BILLING_GROUP

TICKET_VALUE

VARCHAR2

50

Y

  

DATE_CREATED

DATE

7

Y

  

RECHARGE_AMOUNT

NUMBER

22

Y

  

NEXT_RECHARGE_DATE

DATE

7

Y

  

DAY_OF_MONTH

NUMBER

22

Y

  

RECHARGE_TO_AMOUNT

NUMBER

22

Y

  

RECHARGE_LIMIT

NUMBER

22

Y

  

CODE

VARCHAR2

50

Y

  

LAST_RECHARGE_DATE

DATE

7

Y

  

LAST_CHANGED_DATE

DATE

7

Y

  

LAST_RECHARGE_AMOUNT

NUMBER

22

Y

  

ROAMING_END_DATE

DATE

7

Y

  

REFERENCE

VARCHAR2

160

Y

  

FROM_DATE

DATE

7

Y

  

TO_DATE

DATE

7

Y

  

TRIES

NUMBER

22

Y

  

SOURCE_OBJECT_ID

NUMBER

22

Y

 Reference to record in table named in column SOURCE_OBJECT_TABLE

SOURCE_OBJECT_TABLE

VARCHAR2

400

Y

 Table name

CREDIT_CARD_EXPIRE_DATE

DATE

7

Y

  

CARD_TYPE

VARCHAR2

200

Y

  

LAST_DIGITS

VARCHAR2

40

Y

  

EXP_MONTH

VARCHAR2

8

Y

  

EXP_YEAR

VARCHAR2

16

Y

  

STATUS_ID

NUMBER

22

Y

  

ACCOUNT_PAYMENT_TYPE_ID

NUMBER

22

Y

 Reference to ACCOUNT_PAYMENT_TYPE

RECHARGE_STRATEGY_CODE

VARCHAR2

200

Y

  

CURRENCY_CODE

VARCHAR2

12

Y

  

RECHARGE_TICKET_TYPE_ID

NUMBER

22

Y

 Reference to RECHARGE_TICKET_TYPE
META_DATAVARCHAR24000Y With v. 9.8

Contains automatic top up information