Bookshelf Home | Contents | Index | PDF     

Implementation Guide for Oracle Billing Insight > Load Input File Specifications and Data Mapping >

File Formats for Unbilled Detail-Level Information

Table 159 shows the file format for unbilled detail information.

Table 159. Unbilled Detail File Format
Record Type
Field
Pos
Max Len
Data Type
Req?
Staging Table (STG_CDR) Column Name
DB_TABLE_NAME
DB_COLUMN_NAME
Industry Application
4900
Rec Type
1
4
VARCHAR2
Yes
REC_TYPE
None
None
Telco
4900
Account Number
 
2
20
VARCHAR2
Yes
COL1
EDX_RPT_UNBILLED_DETAIL _FACT
ACCOUNT_KEY
Telco
4900
Service Number
 
3
20
VARCHAR2
Yes
COL2
EDX_RPT_UNBILLED_DETAIL _FACT
SERVICE_KEY
Telco
4900
Called Date
 
4
8
DATE
Yes
COL3
EDX_RPT_UNBILLED_DETAIL _FACT
DATE_KEY
Telco
4900
Duration
 
 
5
10
VARCHAR2
Yes
COL4
EDX_RPT_UNBILLED_DETAIL _FACT
TIME_KEY
Telco
4900
Called Number
6
20
VARCHAR2
Yes
COL5
EDX_RPT_UNBILLED_DETAIL _FACT
CALLED_NUM
 
 
Telco
4900
Usage Type Code
7
50
VARCHAR2
Yes
COL6
EDX_RPT_UNBILLED_DETAIL _FACT
USAGE_TYPE_KEY
Telco
4900
Tariff Code
 
8
50
VARCHAR2
Yes
COL7
EDX_RPT_UNBILLED_DETAIL _FACT
TARIFF_KEY
Telco
4900
Usage Unit Code
9
50
VARCHAR2
Yes
COL8
EDX_RPT_UNBILLED_DETAIL _FACT
UNIT_KEY
Telco
4900
Call Type Code
 
10
50
VARCHAR2
No
COL9
EDX_RPT_UNBILLED_DETAIL _FACT
CALL_TYPE_KEY
Telco
4900
Direction Code
 
11
20
VARCHAR2
Yes
COL10
EDX_RPT_UNBILLED_DETAIL _FACT
DIRECTION_KEY
Telco
4900
Calling City, State Code
12
100
VARCHAR2
Yes
COL11
EDX_RPT_UNBILLED_DETAIL _FACT
CALLING_AREA
_CD_KEY
 
 
Telco
4900
Calling Country Code
 
13
100
VARCHAR2
Yes
COL12
EDX_RPT_UNBILLED_DETAIL _FACT
CALLING_AREA
_CD_KEY
 
Telco
4900
Called City, State Code
 
14
100
VARCHAR2
Yes
COL13
EDX_RPT_UNBILLED_DETAIL _FACT
CALLED_AREA
_CD_KEY
 
Telco
4900
Called Country Code
15
100
VARCHAR2
Yes
COL14
EDX_RPT_UNBILLED_DETAIL _FACT
CALLED_AREA
_CD_KEY
 
Telco
4900
Total Usages
 
16
16,2
NUMBER
Yes
COL15
EDX_RPT_UNBILLED_DETAIL _FACT
TOTAL_USAGE
Telco
4900
Total Charge
 
17
16,2
NUMBER
Yes
COL16
EDX_RPT_UNBILLED_DETAIL _FACT
TOTAL_CHARGE_AMT
Telco
4900
Other Charge
 
16
16,2
NUMBER
No
COL17
EDX_RPT_UNBILLED_DETAIL _FACT
OTHER_CHARGE_AMT
Telco
4900
FlexField1
17
255
VARCHAR2
No
COL18
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD1
Telco
4900
FlexField2
18
255
VARCHAR2
No
COL19
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD2
Telco
4900
FlexField3
19
255
VARCHAR2
No
COL20
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD3
Telco
4900
FlexField4
20
255
VARCHAR2
No
COL21
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD4
Telco
4900
FlexField5
21
255
VARCHAR2
No
COL22
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD5
Telco
4900
FlexField6
22
16,2
NUMBER
No
COL23
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD6
Telco
4900
FlexField7
23
16,2
NUMBER
No
COL24
EDX_RPT_UNBILLED_DETAIL _FACT
FLEX_FIELD7
Telco

4900

FlexField8

24

16,2

NUMBER

No

COL25

EDX_RPT_UNBILLED_DETAIL _FACT

FLEX_FIELD8

Telco

4900

FlexField9

25

8

DATE

No

COL26

EDX_RPT_UNBILLED_DETAIL _FACT

FLEX_FIELD9

Telco

4900

FlexField10

26

8

DATE

No

COL27

EDX_RPT_UNBILLED_DETAIL _FACT

FLEX_FIELD10

Telco

4900

Allowance

27

20

VARCHAR2

 

No

COL28

EDX_RPT_UNBILLED_DETAIL _FACT

ALLOWANCE

Telco

4900

Gross Amount

28

16,2

NUMBER

No

COL29

EDX_RPT_UNBILLED_DETAIL _FACT

GROSS_AMT

Telco and Utility

4900

Discount Amount

29

16,2

NUMBER

No

COL30

EDX_RPT_UNBILLED_DETAIL _FACT

DISCOUNT_AMT

Telco and Utility

4900

Tax Amount

30

16,2

NUMBER

No

COL31

EDX_RPT_UNBILLED_DETAIL _FACT

TAX_AMT

Telco and Utility
    
Implementation Guide for Oracle Billing Insight Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.