Versions Compared

Old Version 5

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Column
width33%

RECHARGE_TICKET

Col #

Column NameData Type Not Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key
2

BILLING_GROUP_ID

NUMBER

22

Y

 Reference to BILLING_GROUP3

TICKET_VALUE

VARCHAR2

50

Y

  
4

DATE_CREATED

DATE

7

Y

  5

RECHARGE_AMOUNT

NUMBER

22

Y

  6

NEXT_RECHARGE_DATE

DATE

7

Y

  7

DAY_OF_MONTH

NUMBER

22

Y

  
8

RECHARGE_TO_AMOUNT

NUMBER

22

Y

  9

RECHARGE_LIMIT

NUMBER

22

Y

  10

CODE

VARCHAR2

50

Y

  11

LAST_RECHARGE_DATE

DATE

7

Y

  12

LAST_CHANGED_DATE

DATE

7

Y

  13

LAST_RECHARGE_AMOUNT

NUMBER

22

Y

  14

ROAMING_END_DATE

DATE

7

Y

  15

REFERENCE

VARCHAR2

160

Y

  
16

FROM_DATE

DATE

7

Y

  17

TO_DATE

DATE

7

Y

  18

TRIES

NUMBER

22

Y

  19

SOURCE_OBJECT_ID

NUMBER

22

Y

 Reference to record in table named in column SOURCE_OBJECT_TABLE20

SOURCE_OBJECT_TABLE

VARCHAR2

400

Y

 Table name21

CREDIT_CARD_EXPIRE_DATE

DATE

7

Y

  22

CARD_TYPE

VARCHAR2

200

Y

  23

LAST_DIGITS

VARCHAR2

40

Y

  24

EXP_MONTH

VARCHAR2

8

Y

  25

EXP_YEAR

VARCHAR2

16

Y

  26

STATUS_ID

NUMBER

22

Y

  27

ACCOUNT_PAYMENT_TYPE_ID

NUMBER

22

Y

 Reference to ACCOUNT_PAYMENT_TYPE28

RECHARGE_STRATEGY_CODE

VARCHAR2

200

Y

  29

CURRENCY_CODE

VARCHAR2

12

Y

  30

RECHARGE_TICKET_TYPE_ID

NUMBER

22

Y

 Reference to RECHARGE_TICKET_TYPE 
META_DATAVARCHAR24000Y With v. 9.8
Column
width33%

Contains automatic top up information