Bookshelf Home | Contents | Index | PDF     

Implementation Guide for Oracle Self-Service E-Billing > Input File Specifications and Data Mapping >

Account Level File Format

This topic shows the account level file formats.

Table 108 shows the file format for account fact charge information.

Table 108. Account Fact Charges (charge Summary for Account)
RECORD TYPE
FIELD
POSITION
MAX LENGTH
DATA TYPE
REQ?
STAGING TABLE (STG_CDR) COLUMN NAME
DB_TABLE_NAME
DB_COLUMN_NAME
2000
Rec Type
1
4
VARCHAR2
Yes
REC_TYPE
 
 
2000
Statement Number
2
20
VARCHAR2
Yes
COL1
EDX_RPT_ACCOUNT_FACT
STATEMENT_KEY
2000
Account Number
3
20
VARCHAR2
Yes
COL2
EDX_RPT_ACCOUNT_DIM
ACCOUNT_NUM
2000
Account Owner Name
4
255
VARCHAR2
Yes
COL3
EDX_RPT_ACCOUNT_DIM
CONTACT_NAME
2000
Address1
5
200
VARCHAR2
No
COL4
EDX_RPT_ACCOUNT_DIM,
EDX_RPT_ADDRESS_DIM
ADDRESS1,
ADDRESS1
2000
Address2
6
200
VARCHAR2
No
COL5
EDX_RPT_ACCOUNT_DIM,
EDX_RPT_ADDRESS_DIM
ADDRESS2,
ADDRESS2
2000
City
7
100
VARCHAR2
No
COL6
EDX_RPT_ACCOUNT_DIM,
EDX_RPT_ADDRESS_DIM
CITY,
CITY
2000
State
8
100
VARCHAR2
No
COL7
EDX_RPT_ACCOUNT_DIM,
EDX_RPT_ADDRESS_DIM
STATE,
STATE
2000
Country
9
100
VARCHAR2
No
COL8
EDX_RPT_ACCOUNT_DIM,
EDX_RPT_ADDRESS_DIM
COUNTRY,
COUNTRY
2000
Zip
10
20
VARCHAR2
No
COL9
EDX_RPT_ACCOUNT_DIM,
EDX_RPT_ADDRESS_DIM
ZIP,
ZIP
2000
Monthly Service Charges
11
16,2
NUMBER
Yes
COL 10
EDX_RPT_ACCOUNT_FACT
MONTHLY_CHARGE_AMT
2000
Usage Charges
12
16,2
NUMBER
Yes
COL 11
EDX_RPT_ACCOUNT_FACT
USAGE_CHARGE_AMT
2000
Credits
13
16,2
NUMBER
Yes
COL 12
EDX_RPT_ACCOUNT_FACT
CREDIT_ADJUST_AMT
2000
Other Charges
14
16,2
NUMBER
Yes
COL 13
EDX_RPT_ACCOUNT_FACT
OTHER_CHARGE_AMT
2000
Taxes and Fees
15
16,2
NUMBER
Yes
COL 14
EDX_RPT_ACCOUNT_FACT
TAXES_SURCHARGES_FEE
2000
Total Charge Amount
16
16,2
NUMBER
Yes
COL15
EDX_RPT_ACCOUNT_FACT
TOTAL_CHARGE_AMT
2000
Charge Flag
17
1
VARCHAR2
Yes
COL16
EDX_RPT_ACCOUNT_FACT
CHARGE_FLAG
2000
Account Type
18
20
VARCHAR2
No
COL17
EDX_RPT_ACCOUNT_FACT
ACCOUNT_TYPE_KEY
2000
Flex Field_1
19
16,2
NUMBER
No
COL18
EDX_RPT_ACCOUNT_FACT
FLEX_FIELD1
2000
Flex Field_2
20
16,2
NUMBER
No
COL19
EDX_RPT_ACCOUNT_FACT
FLEX_FIELD2
2000
Flex Field_3
21
16,2
NUMBER
No
COL20
EDX_RPT_ACCOUNT_FACT
FLEX_FIELD3
2000
Flex Field_4
22
16,2
NUMBER
No
COL21
EDX_RPT_ACCOUNT_FACT
FLEX_FIELD4
2000
Flex Field_5
23
16,2
NUMBER
No
COL22
EDX_RPT_ACCOUNT_FACT
FLEX_FIELD5
Format

Table 109 shows the file format for information about account level charges at the charge type level.

Table 109. Account Level Charges at Charge Type Level
RECORD TYPE
FIELD
POSITION
MAX LENGTH
DATA TYPE
REQ?
STAGING TABLE (STG_CDR) COLUMN NAME
DB_TABLE_NAME
DB_COLUMN_NAME
2100
Rec Type
1
3
VARCHAR2
Yes
REC_TYPE
 
 
2100
Statement Number
2
20
VARCHAR2
Yes
COL1
EDX_RPT_ACCOUNT_CHARGE_FACT
STATEMENT_KEY
2100
Account Number
3
20
VARCHAR2
Yes
COL2
EDX_RPT_ACCOUNT_CHARGE_FACT
ACCOUNT_KEY
2100
Charge Type Code
4
50
VARCHAR2
Yes
COL3
EDX_RPT_ACCOUNT_CHARGE_FACT
CHARGE_TYPE_KEY
2100
Monthly Service Charges
5
16,2
NUMBER
Yes
COL4
EDX_RPT_ACCOUNT_CHARGE_FACT
MONTHLY_CHARGE_AMT
2100
Usage Charges
6
16,2
NUMBER
Yes
COL5
EDX_RPT_ACCOUNT_CHARGE_FACT
USAGE_CHARGE_AMT
2100
Credits
7
16,2
NUMBER
Yes
COL6
EDX_RPT_ACCOUNT_CHARGE_FACT
CREDIT_ADJUST_AMT
2100
Other Charges
8
16,2
NUMBER
Yes
COL7
EDX_RPT_ACCOUNT_CHARGE_FACT
OTHER_CHARGE_AMT
2100
Taxes and Fees
9
16,2
NUMBER
Yes
COL8
EDX_RPT_ACCOUNT_CHARGE_FACT
TAXES_SURCHARGES_FEE
2100
Total Charge Amount
10
16,2
NUMBER
Yes
COL9
EDX_RPT_ACCOUNT_CHARGE_FACT
TOTAL_CHARGE_AMT
2100
Charge Note
11
255
VARCHAR2
No
COL10
EDX_RPT_ACCOUNT_CHARGE_FACT
CHARGE_NOTE
Format
    
Implementation Guide for Oracle Self-Service E-Billing Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.