A_NUMBER

ID

NUMBER

22

N

STATUS

NUMBER

22

Y

Status of the number, 0-active, 1-in use, 2-reserved, 3-rest period, 4-barred, 5-exported, 100-reserved for anumber sequence

ASSIGNED_TO_SERVICE_ID

NUMBER

22

Y

Service to which the number belongs

CREATE_DATE

DATE

7

Y

RESERV_TO_DATE

DATE

7

Y

A_NUMBER

VARCHAR2

100

Y

COMMENTS

VARCHAR2

1000

Y

Add. comments

GROUP_ID

NUMBER

22

Y

References ANUMBER_GROUP-table

USERCLIENT

VARCHAR2

100

Y

OPERATOR_ID

NUMBER

22

Y

Network operator creating the number

RS_EXCHANGE_ID

NUMBER

22

Y

BRAND_ID

NUMBER

22

Y

References BRAND-table