Groups
NUMBER_BOOKED_BY
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | ||
| 2 | NUMBER_ID | NUMBER | 22 | Y | ||
| 3 | NUMBER_TYPE | VARCHAR2 | 10 | Y | ||
| 4 | SERVICE_ID | NUMBER | 22 | Y | ||
| 5 | TAKEN_DATE | DATE | 7 | Y | ||
| 6 | BOOKED_FOR | VARCHAR2 | 10 | Y | ||
| 7 | END_DATE | DATE | 7 | Y | ||
| 8 | ACCOUNT_ID | NUMBER | 22 | Y | ||
| 9 | PHONE_NUMBER | VARCHAR2 | 80 | Y | ||
| 10 | ICC | VARCHAR2 | 400 | Y | ||
| 11 | IMSI | VARCHAR2 | 400 | Y | ||
| 12 | TYPE | VARCHAR2 | 80 | Y | ||
| 13 | DEVICE_IDENTIFIER | VARCHAR2 | 400 | Y | ||
| 14 | BRAND_ID | NUMBER | 22 | Y |
Contains information on which MSISDNs and SIM cards were allocated to which subscription at a given time.