| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comment |
|---|
| 1 | ID | NUMBER | 22 | N | | Primary key |
| 2 | SUBSCRIPTION_ID | NUMBER | 22 | Y | | Foreign key referencing SUBSCRIPTION-table |
| 3 | CODE | VARCHAR2 | 10 | Y | | Refers to type of service, references SERVICE_CLASS.CODE 4 |
STATUS_ID | NUMBER | 22 | Y | | Status of the service, references STATUS.ID |
| 5 | IMSI | VARCHAR2 | 50 | Y | | International Mobile Subscriber Identity |
| 6 | PHONE_NUMBER | VARCHAR2 | 20 | Y | | Phone number 7 |
MAILBOX_NUMBER | VARCHAR2 | 50 | Y | | Mailbox number 8 |
DATA_FAX_NUMBER | VARCHAR2 | 50 | Y | | Data fax number 9 |
PHONEBOOK_ENTRY | NUMBER | 22 | Y | | 10 |
FOREIGN_CALLS | NUMBER | 22 | Y | | 11 |
SIM_DELIVERED | NUMBER | 22 | Y | | Indicates whether SIM card is delivered 12 |
FAX_NUMBER | VARCHAR2 | 50 | Y | | Fax number 13 |
DUAL_IMSI | VARCHAR2 | 50 | Y | | Second IMSI number if one exists |
| 14 | DUAL_PHONE_NUMBER | VARCHAR2 | 50 | Y | | Second phone number if one exists |
| 15 | NETWORK_ICC | VARCHAR2 | 100 | Y | | Network Integrated Circuit Card 16 |
NETWORK_PHONENUMBER | VARCHAR2 | 100 | Y | | Network phone number 17 |
ESN | VARCHAR2 | 50 | Y | | Electronic Serial Number |
| 18 | NETWORK_ESN | VARCHAR2 | 50 | Y | | Network ESN 19 |
SERVICE_CLASS_ID | NUMBER | 22 | Y | | Foreign key referencing SERVICE_CLASS.ID 20 |
CDMAPHONE_GROUP_ID | NUMBER | 22 | Y | | Foreign key referencing CDMA_PHONE_GROUP.ID 21 |
SHOP_PRODUCT_ID | NUMBER | 22 | Y | | Foreign key referencing SHOP_PRODUCT.ID
22 |
DIRECTORY_KEY | VARCHAR2 | 15 | Y | | 23 |
BRAND_ID | NUMBER | 22 | Y | | Foreign key referencing BRAND_ID
|
| 24 | IS_SUSPEND | NUMBER | 22 | N | | Indicates whether service is suspended25 |
NETWORK_SUB_ID | VARCHAR2 | 400 | Y | | |
| 26 | BLOCKED_FROM_DATE | DATE | 7 | Y | | Date of blocking |
| 27 | EXTERNAL_ACCOUNT_REFERENCE | VARCHAR2 | 32 | Y | | |
| 28 | DISCONNECT_DATE | DATE | 7 | Y | | Date of disconnecting29 |
LAST_SPEED_CHANGE_DATE | DATE | 7 | Y | | Date of latest speed change |
| 30 | INSTALLATION_ID | NUMBER | 22 | Y | | |
| 31 | USER_NO | VARCHAR2 | 200 | Y | | User number32 |
IP_NUMBER | VARCHAR2 | 50 | Y | | IP-number33 |
MAC_ADDRESS_NUMBER | VARCHAR2 | 50 | Y | | Mac address number34 |
NETWORK_USER_ID | NUMBER | 22 | Y | | 35 |
SERVICE_TAG | VARCHAR2 | 100 | Y | | |
| 36 | LAST_PROVISIONING_SYNC_DATE | DATE | 7 | Y | | Date of latest provisioning synchronization |
| 37 | CUSTOM_VALUE1 | VARCHAR2 | 4000 | Y | | Custom value38 |
CUSTOM_VALUE2 | VARCHAR2 | 4000 | Y | | Custom value39 |
CUSTOM_VALUE3 | VARCHAR2 | 4000 | Y | | Custom value40 |
CSA_ZIP | VARCHAR2 | 200 | Y | | 41 |
CSA | VARCHAR2 | 400 | Y | | 42 |
HEX_MEID | VARCHAR2 | 200 | Y | | MEID in hex-format43 |
MEID | VARCHAR2 | 50 | Y | | Mobile Equipment ID44 |
NETWORK_MEID | VARCHAR2 | 50 | Y | | Network MEID45 |
MIN | VARCHAR2 | 200 | Y | | Mobile Identification Number 46 |
CSA_NUMBER | VARCHAR2 | 400 | Y | | 47 |
NETWORK_MIN | VARCHAR2 | 200 | Y | | Network MIN48 |
FIRST_CDR_RATED_DATE | DATE | 7 | Y | | Date of first rating |