NUMBER_BOOKED_BY
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.