Groups
RECHARGE_TICKET
Col # | Column Name | Data Type | Not Null? | Data Def. | Comments | |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | BILLING_GROUP_ID | NUMBER | 22 | Y | Reference to BILLING_GROUP | |
| 3 | 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_TABLE | |
| 20 | SOURCE_OBJECT_TABLE | VARCHAR2 | 400 | Y | Table name | |
| 21 | 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_TYPE | |
| 28 | 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 | |
| 31 | CA_AMOUNT_LIMIT | NUMBER | 22 | Y | ||
| 32 | CA_PERIOD | VARCHAR2 | 40 | Y | ||
| 33 | CA_NICKNAME | VARCHAR2 | 120 | Y |
Contains automatic top up information