SERVICE

ID

NUMBER

22

N

SUBSCRIPTION_ID

NUMBER

22

Y

Foreign key referencing SUBSCRIPTION-table

CODE

VARCHAR2

10

Y

Refers to type of service, references SERVICE_CLASS.CODE

STATUS_ID

NUMBER

22

Y

Status of the service, references STATUS.ID

IMSI

VARCHAR2

50

Y

International Mobile Subscriber Identity

PHONE_NUMBER

VARCHAR2

20

Y

Phone number

MAILBOX_NUMBER

VARCHAR2

50

Y

Mailbox number

DATA_FAX_NUMBER

VARCHAR2

50

Y

Data fax number

PHONEBOOK_ENTRY

NUMBER

22

Y

FOREIGN_CALLS

NUMBER

22

Y

SIM_DELIVERED

NUMBER

22

Y

Indicates whether SIM card is delivered

FAX_NUMBER

VARCHAR2

50

Y

Fax number

DUAL_IMSI

VARCHAR2

50

Y

Second IMSI number if one exists

DUAL_PHONE_NUMBER

VARCHAR2

50

Y

Second phone number if one exists

NETWORK_ICC

VARCHAR2

100

Y

Network Integrated Circuit Card

NETWORK_PHONENUMBER

VARCHAR2

100

Y

Network phone number

ESN

VARCHAR2

50

Y

Electronic Serial Number

NETWORK_ESN

VARCHAR2

50

Y

Network ESN

SERVICE_CLASS_ID

NUMBER

22

Y

Foreign key referencing SERVICE_CLASS.ID

CDMAPHONE_GROUP_ID

NUMBER

22

Y

Foreign key referencing CDMA_PHONE_GROUP.ID

SHOP_PRODUCT_ID

NUMBER

22

Y

DIRECTORY_KEY

VARCHAR2

15

Y

BRAND_ID

NUMBER

22

Y

IS_SUSPEND

NUMBER

22

N

NETWORK_SUB_ID

VARCHAR2

400

Y

BLOCKED_FROM_DATE

DATE

7

Y

EXTERNAL_ACCOUNT_REFERENCE

VARCHAR2

32

Y

DISCONNECT_DATE

DATE

7

Y

LAST_SPEED_CHANGE_DATE

DATE

7

Y

INSTALLATION_ID

NUMBER

22

Y

USER_NO

VARCHAR2

200

Y

IP_NUMBER

VARCHAR2

50

Y

MAC_ADDRESS_NUMBER

VARCHAR2

50

Y

NETWORK_USER_ID

NUMBER

22

Y

SERVICE_TAG

VARCHAR2

100

Y

LAST_PROVISIONING_SYNC_DATE

DATE

7

Y

CUSTOM_VALUE1

VARCHAR2

4000

Y

CUSTOM_VALUE2

VARCHAR2

4000

Y

CUSTOM_VALUE3

VARCHAR2

4000

Y

CSA_ZIP

VARCHAR2

200

Y

CSA

VARCHAR2

400

Y

HEX_MEID

VARCHAR2

200

Y

MEID

VARCHAR2

50

Y

NETWORK_MEID

VARCHAR2

50

Y

MIN

VARCHAR2

200

Y

Mobile Identification Number

CSA_NUMBER

VARCHAR2

400

Y

NETWORK_MIN

VARCHAR2

200

Y

FIRST_CDR_RATED_DATE

DATE

7

Y