NP_FLOW

Groups

Unknown macro: {float}

NP_FLOW

Col #	Column Name	Data Type	Field Length	Not Null?	Comments
1	ID	NUMBER	22	N	Primary key
2	SUBSCRIPTION_ID	NUMBER	22	Y	ID of subscription attached to number
3	WORKFLOW_ID	NUMBER	22	Y	Workflow handling the NP process
4	SIGNUP_DATE	DATE	7	Y	Date of number signup
5	PHONE_NUMBER	VARCHAR2	20	Y	Mobile number
6	PORT_DATE	DATE	7	Y	Date of importing/exporting number
7	ACTIVATION_DATE	DATE	7	Y	Date of activating number
8	SIMCARD_SENT_DATE	DATE	7	Y	Date of sending SIM card
9	DSP_ID	NUMBER	22	Y	DSP (Donor Service Provider) offering the number
10	STATUS_ID	NUMBER	22	Y	NP status: 0-pending, 1-completed, 2-waiting for donor, 6-cancelled, 7-waiting for activation, 8-waiting for cancel/confirm, 9-check reject, 10-waiting for npc ok
11	CASE_NUMBER	NUMBER	22	Y	NP case number
12	REJECT_CODE	VARCHAR2	10	Y	Reject code
13	TERMINATION_DATE	DATE	7	Y	Date of terminating number
14	CODE	VARCHAR2	20	Y	NP code, refers to implementation class
15	NEW_SIMCARD_ID	NUMBER	22	Y	New SIM card ID, references SIMCARD-table
16	PORT_TYPE_ID	NUMBER	22	Y	NP type: 0-import, 2-export
17	NEW_PRODUCT_ID	NUMBER	22	Y	New product ID, references PRODUCT-table
18	CASE_STATUS_ID	NUMBER	22	Y	NP case status, 1-case active, 2-case unactive
19	OLD_SIMCARD_ID	NUMBER	22	Y	Old SIM card id, references SIMCARD-table
20	REJECT_COMMENT	VARCHAR2	4000	Y	Comment in case of NP rejection
21	SIGNUP_IP	VARCHAR2	80	Y	Signup IP address
22	PORTING_ID	VARCHAR2	30	Y	Porting ID
23	ACCOUNT_PAY_TYPE	VARCHAR2	10	Y	Account payment type
24	PHONE_NUMBER_FLAG	NUMBER	22	Y
25	ACCOUNT_NUMBER	VARCHAR2	120	Y	Account number
26	ACCOUNT_IDENTIFIER	VARCHAR2	120	Y	Account name
27	CORPORATE_REG_NUMBER	VARCHAR2	120	Y	Corporation registration number
28	CORPORATE_CONTACT_PERSON	VARCHAR2	120	Y	Corporate contact person
29	CORPORATE_CONTACT_PHONE	VARCHAR2	120	Y	Corporate contact phone

Contains all MNP Flows