Versions Compared

Old Version 1

changes.mady.by.user Søren Duusgaard

Saved on

compared with

New Version Current

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

Column
width33%

DIAMETER_CDR

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

ID

NUMBER

22

N

  
2

CREATE_DATE

DATE

7

Y

  
3

STATUS_ID

NUMBER

22

Y

 

0-New

1-Processed

3-Error

4

CODE

VARCHAR2

400

Y

  
5

RATING_CODE

VARCHAR2

224

Y

  
6

RATING_KEY

VARCHAR2

224

Y

  7

REQUEST_TYPE

NUMBER

22

Y

  8

REQUEST_NUMBER

NUMBER

22

Y

  9

SESSION_IDEN

VARCHAR2

4000

Y

  10

CHARGING_IDEN

VARCHAR2

200

Y

  
11

IMSI

VARCHAR2

400

Y

  
12

MSISDN

VARCHAR2

400

Y

  13

MCC

NUMBER

22

Y

  14

MNC

NUMBER

22

Y

  15

SAC

NUMBER

22

Y

  16

LAC

NUMBER

22

Y

  17

RATING_GROUP

NUMBER

22

Y

  18

TRAFFIC_IN

NUMBER

22

Y

  19

TRAFFIC_OUT

NUMBER

22

Y

  20

TRAFFIC_TOTAL

NUMBER

22

Y

  21

RATE_COUNTRY_ID

NUMBER

22

Y

  22

COMMENTS

VARCHAR2

4000

Y

  
23

GEO_LOC_TYPE

NUMBER

22

Y

  
24

CI

NUMBER

22

Y

  25

RAC

NUMBER

22

Y

  26

BILLING_RECORD_ID

NUMBER

22

Y

  27

EVENT_TIMESTAMP

DATE

7

Y

  28

REQUESTED_CC_TIME

NUMBER

22

Y

  29

USED_CC_TIME

NUMBER

22

Y

  30

CALLING_PARTY_ADDRESS

VARCHAR2

200

Y

  31

CALLED_PARTY_ADDRESS

VARCHAR2

200

Y

  32

REAL_CALLED_NUMBER

VARCHAR2

200

Y

  33

CONNECT_CALLED_NUMBER

VARCHAR2

200

Y

  34

CHARGE_FLOW_TYPE

NUMBER

22

Y

  35

CALLING_PARTYS_CATEGORY

NUMBER

22

Y

  36

CALLING_VLR_NUMBER

VARCHAR2

200

Y

  37

CALLING_CELL_ID_OR_SAI

VARCHAR2

200

Y

  38

CALLED_VLR_NUMBER

VARCHAR2

200

Y

  39

CALLED_CELL_ID_OR_SAI

VARCHAR2

200

Y

  40

BEARER_CAPABILITY

VARCHAR2

200

Y

  41

REDIRECTING_PARTY_ID

VARCHAR2

200

Y

  42

REDIRECTION_REASON

VARCHAR2

200

Y

  43

CALL_REFERENCE_NUMBER

VARCHAR2

200

Y

  44

MSC_ADDRESS

VARCHAR2

200

Y

  45

SSP_TIME

DATE

7

Y

  46

CALL_FORWARD_INDICATOR

NUMBER

22

Y

  
47

TIME_ZONE

NUMBER

22

Y

  
48

SMSC_ADDRESS

VARCHAR2

200

Y

  49

SM_ID

VARCHAR2

200

Y

  50

SM_LENGTH

NUMBER

22

Y

  51

MO_MSC_ADDRESS

VARCHAR2

200

Y

  52

MT_MSC_ADDRESS

VARCHAR2

200

Y

  53

SOURCE_ADDRESS

VARCHAR2

200

Y

  54

DESTINATION_ADDRESS

VARCHAR2

200

Y

  55

FEE_ADDRESS

VARCHAR2

200

Y

  56

FEE_FLAG

NUMBER

22

Y

  57

FEE_TYPE

NUMBER

22

Y

  58

STATUS_REPOST_REQUEST

NUMBER

22

Y

  59

SEND_RESULT

NUMBER

22

Y

  60

REQUESTED_CC_TOTAL_OCTETS

NUMBER

22

Y

  61

USED_CC_TOTAL_OCTETS

NUMBER

22

Y

  62

USED_CC_INPUT_OCTETS

NUMBER

22

Y

  63

USED_CC_OUTPUT_OCTETS

NUMBER

22

Y

  64

QOS

VARCHAR2

200

Y

  65

SGSN_ADDRESS

VARCHAR2

200

Y

  66

CALLED_STATION_ID

VARCHAR2

200

Y

  67

SP_ID

VARCHAR2

200

Y

  68

SERVICE_ID

VARCHAR2

200

Y

  69

SERVICE_TYPE

VARCHAR2

200

Y

  70

BEARER_TYPE

NUMBER

22

Y

  71

START_TIME

VARCHAR2

200

Y

  72

BEARER_PROTOCOL_TYPE

NUMBER

22

Y

  73

CHARGING_ID

VARCHAR2

200

Y

  74

TGPP_SGSN_MCC_MNC

VARCHAR2

200

Y

  75

TGPP_USER_LOCATION_INFO

VARCHAR2

200

Y

  76

RECIPIENT_ADDR_TYPE

NUMBER

22

Y

  77

RECIPIENT_ADDR_DATA

VARCHAR2

200

Y

  78

CC_CORRELATION_IDEN

VARCHAR2

200

Y

  79

SERVICE_IDENTIFIER

NUMBER

22

Y

  80

REQUESTED_ACTION

NUMBER

22

Y

  81

CONTENT_PROVIDER_IDEN

VARCHAR2

200

Y

  82

CONTENT_IDEN

VARCHAR2

200

Y

  83

MULTIPLE_SERV_INDICATOR

NUMBER

22

Y

  84

ORIGIN_ADDR_TYPE

NUMBER

22

Y

  85

ORIGIN_ADDR_DATA

VARCHAR2

200

Y

  85

REFUND_INFORMATION

VARCHAR2

200

Y

  86

MESSAGE_IDEN

VARCHAR2

200

Y

  87

ORIGIN_SCCP_ADDR

VARCHAR2

200

Y

  88

MULTIPLE_SERVICES_INDICATOR

NUMBER

22

Y

  89

ORIGINATOR_ADDRESS_TYPE

NUMBER

22

Y

  90

ORIGINATOR_ADDRESS_DATA

VARCHAR2

200

Y

  91

RECIPIENT_ADDRESS_TYPE

NUMBER

22

Y

  92

RECIPIENT_ADDRESS_DATA

VARCHAR2

200

Y

  93

MESSAGE_ID

VARCHAR2

200

Y

  94

CORRELATION_ID

VARCHAR2

200

Y

  

 

 

Column
width33%