NP_MESSAGE

Owned by Søren Duusgaard (Deactivated)
Last updated: 03.12.2015Version comment

Groups

NP_MESSAGE

Column NameData TypeField LengthNot Null?Data Def.Comments

ID

NUMBER

22

N

 Primary key

CODE

VARCHAR2

20

Y

  

TIME_STAMP

DATE

7

Y

  

READ_DATE

DATE

7

Y

  

STATUS_ID

NUMBER

22

Y

  

PHONE_NUMBER

VARCHAR2

20

Y

  

PORTIER_ID

VARCHAR2

30

Y

  

PORT_DATE

DATE

7

Y

  

SUGGESTED_PORT_DATE

DATE

7

Y

  

FIRST_NAME

VARCHAR2

100

Y

  

LAST_NAME

VARCHAR2

100

Y

  

BIRTH_DATE

DATE

7

Y

  

COMPANY_NAME

VARCHAR2

100

Y

  

STREET

VARCHAR2

100

Y

  

ZIP

VARCHAR2

10

Y

  

CITY

VARCHAR2

100

Y

  

CUSTOMER_NUMBER

VARCHAR2

30

Y

  

MESSAGE

VARCHAR2

4000

Y

  

FREE_TEXT

VARCHAR2

1000

Y

  

VERSION

VARCHAR2

10

Y

  

STATUS

VARCHAR2

4

Y

  

RSP

VARCHAR2

10

Y

  

DSP

VARCHAR2

10

Y

  

RNO

VARCHAR2

10

Y

  

DNO

VARCHAR2

10

Y

  

FILENAME

VARCHAR2

200

Y

  

MNP_REFERENCE_ID

NUMBER

22

Y

  

WORKFLOW_ID

NUMBER

22

Y

  

NP_FLOW_ID

NUMBER

22

Y

  

TYPE

VARCHAR2

10

Y

  

ICC

VARCHAR2

100

Y

  

TRANSACTION_ID

VARCHAR2

10

Y

  

REJECT_CODE

NUMBER

22

Y

  

PORTING_ORDER_REFERENCE

VARCHAR2

50

Y

  
TRIESNUMBER   Vs. 10

Holds messages retrieved from a porting authority or sent by Rator with text. Not used in the NRDB process.

 

Â