Groups
SIMCARD_FILE_FORMAT
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | NAME | VARCHAR2 | 100 | Y | ||
| 3 | DESCRIPTION | VARCHAR2 | 300 | Y | ||
| 4 | SEPARATOR | VARCHAR2 | 2 | Y | ||
| 5 | HEADER_RECORDS | NUMBER | 22 | Y | ||
| 6 | TRAILER_RECORDS | NUMBER | 22 | Y | ||
| 7 | SIMCARD_TYPE | VARCHAR2 | 100 | Y | ||
| 8 | NETWORK_ID | NUMBER | 22 | Y | ||
| 9 | A_NUMBER_GROUP_ID | NUMBER | 22 | Y | ||
| 10 | WRAPPER | VARCHAR2 | 1 | Y | ||
| 11 | SETUP_ACCOUNTS | VARCHAR2 | 1 | Y | ||
| 12 | PRODUCT_ID | NUMBER | 22 | Y | ||
| 13 | RATE_PLAN_ID | NUMBER | 22 | Y | ||
| 14 | ALERT_GROUP_ID | NUMBER | 22 | Y | ||
| 15 | BILLING_ALERT_GROUP_ID | NUMBER | 22 | Y | ||
| 16 | ICC_PREFIX | VARCHAR2 | 8 | Y | ||
| 17 | GSM_PREFIX | VARCHAR2 | 4 | Y | ||
| 18 | LOCATION | VARCHAR2 | 100 | Y | ||
| 19 | SIM_TYPE_ID | NUMBER | 22 | Y | ||
| 20 | BRAND_ID | NUMBER | 22 | Y | ||
| 21 | PRODUCT_CONFIG_ID | NUMBER | 22 | Y | ||
| 22 | BILLING_GROUP_CODE | VARCHAR2 | 100 | Y |