Versions Compared

Old Version 2

changes.mady.by.user Søren Duusgaard

Saved on

compared with

New Version 3

changes.mady.by.user Søren Duusgaard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width33%

NP_MESSAGE

Col #Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key
2

CODE

VARCHAR2

20

Y

  
3

TIME_STAMP

DATE

7

Y

  
4

READ_DATE

DATE

7

Y

  
5

STATUS_ID

NUMBER

22

Y

  
6

PHONE_NUMBER

VARCHAR2

20

Y

  
7

PORTIER_ID

VARCHAR2

30

Y

  
8

PORT_DATE

DATE

7

Y

  
9

SUGGESTED_PORT_DATE

DATE

7

Y

  
10

FIRST_NAME

VARCHAR2

100

Y

  
11

LAST_NAME

VARCHAR2

100

Y

  
12

BIRTH_DATE

DATE

7

Y

  
13

COMPANY_NAME

VARCHAR2

100

Y

  
14

STREET

VARCHAR2

100

Y

  
15

ZIP

VARCHAR2

10

Y

  
16

CITY

VARCHAR2

100

Y

  
17

CUSTOMER_NUMBER

VARCHAR2

30

Y

  
18

MESSAGE

VARCHAR2

4000

Y

  
19

FREE_TEXT

VARCHAR2

1000

Y

  
20

VERSION

VARCHAR2

10

Y

  
21

STATUS

VARCHAR2

4

Y

  
22

RSP

VARCHAR2

10

Y

  
23

DSP

VARCHAR2

10

Y

  
24

RNO

VARCHAR2

10

Y

  
25

DNO

VARCHAR2

10

Y

  
26

FILENAME

VARCHAR2

200

Y

  
27

MNP_REFERENCE_ID

NUMBER

22

Y

  
28

WORKFLOW_ID

NUMBER

22

Y

  
29

NP_FLOW_ID

NUMBER

22

Y

  
30

TYPE

VARCHAR2

10

Y

  
31

ICC

VARCHAR2

100

Y

  
32

TRANSACTION_ID

VARCHAR2

10

Y

  
33

REJECT_CODE

NUMBER

22

Y

  
34

PORTING_ORDER_REFERENCE

VARCHAR2

50

Y

  
35

ERROR_CODE

VARCHAR2

10

Y

  
36

ERROR_DESC

VARCHAR2

300

Y

  
37

REJECTED_MESSAGE_ID

VARCHAR2

10

Y

  
38

MSISDN

VARCHAR2

20

Y

  
39

MSISDN_FLAG

VARCHAR2

10

Y

  
40

MSISDN_REJECT_CODE

VARCHAR2

100

Y

  
41

REASON_CODE

VARCHAR2

200

Y

  
42

ACCOUNT_PAY_TYPE

VARCHAR2

15

Y

  
Column
width33%