Column Name	Data Type	Field Length	Not Null?	Comments
ID	NUMBER	22	N	Primary key
STATUS	NUMBER	22	Y	Status, i.e. 0-pre paid, 1-post paid, 2-pre paid card
ASSIGNED_TO_SERVICE_ID	NUMBER	22	Y	Foreign key referencing SERVICE-table
CREATE_DATE	DATE	7	Y	Date of creation
RESERV_TO_DATE	DATE	7	Y	Date to which SIM card is reserved
IMSI	VARCHAR2	100	Y	International Mobile Subscriber Indentity
ICC	VARCHAR2	100	Y	Integrated Circuit Card
PIN1	VARCHAR2	100	Y	PIN code
PIN2	VARCHAR2	100	Y	Second PIN code
PUK1	VARCHAR2	100	Y	Personal unblocking code
PUK2	VARCHAR2	100	Y	Second personal unblocking code
TYPE	VARCHAR2	100	Y	Status name
COMMENTS	VARCHAR2	1000	Y	Comments
USERCLIENT	VARCHAR2	100	Y	Operator name
LOCATION	VARCHAR2	100	Y	Location
BLOCKED_FROM_DATE	DATE	7	Y	Date on which SIM card is to be blocked
MARS_SYNC_DATE	DATE	7	Y
ASSIGNED_ANUMBER_ID	NUMBER	22	Y	Foreign key referencing A_NUMBER.ID
NETWORK_ID	NUMBER	22	Y	Foreign key referencing NETWORK_OPERATOR.ID
KI	VARCHAR2	32	Y
CHANGE_PENDING	VARCHAR2	1	Y
SIM_TYPE_ID	NUMBER	22	Y	SIM card type
NETWORK_STATUS	NUMBER	22	Y
BRAND_ID	NUMBER	22	Y	Foreign key referencing BRAND.ID
INITIAL_AMOUNT	NUMBER	22	Y	For a situation when the SIM card is loaded with some initial amount
SIMCARD_GROUP_ID	NUMBER			Added with 10.3.1

Contains all SIM cards

Browser not supported