Oracle Self-Service E-Billing v6.2: File Formats for Account-Level Information

Table 159 shows the file format for account fact charge (charge summary for account) information.

Table 159. Account Fact Charges (Charge Summary for Account) 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
2000	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco and Utility
2000	Statement Number	2	20	VARCHAR2	Yes	COL1	EDX_RPT_ACCOUNT _FACT	STATEMENT_KEY	Telco and Utility
2000	Account Number	3	20	VARCHAR2	Yes	COL2	EDX_RPT_ACCOUNT _DIM	ACCOUNT_NUM	Telco and Utility
2000	Account Owner Name	4	255	VARCHAR2	Yes	COL3	EDX_RPT_ACCOUNT _DIM	CONTACT_NAME	Telco and Utility
2000	Address1	5	200	VARCHAR2	No	COL4	EDX_RPT_ACCOUNT _DIM, EDX_RPT_ADDRESS _DIM	ADDRESS1, ADDRESS1	Telco and Utility
2000	Address2	6	200	VARCHAR2	No	COL5	EDX_RPT_ACCOUNT _DIM, EDX_RPT_ADDRESS _DIM	ADDRESS2, ADDRESS2	Telco and Utility
2000	City	7	100	VARCHAR2	No	COL6	EDX_RPT_ACCOUNT _DIM, EDX_RPT_ADDRESS _DIM	CITY, CITY	Telco and Utility
2000	State	8	100	VARCHAR2	No	COL7	EDX_RPT_ACCOUNT _DIM, EDX_RPT_ADDRESS_DIM	STATE, STATE	Telco and Utility
2000	Country	9	100	VARCHAR2	No	COL8	EDX_RPT_ACCOUNT _DIM, EDX_RPT_ADDRESS _DIM	COUNTRY, COUNTRY	Telco and Utility
2000	Zip	10	20	VARCHAR2	No	COL9	EDX_RPT_ACCOUNT _DIM, EDX_RPT_ADDRESS _DIM	ZIP, ZIP	Telco and Utility
2000	Monthly Service Charges	11	16,2	NUMBER	Yes	COL 10	EDX_RPT_ACCOUNT _FACT	MONTHLY_CHARGE _AMT	Telco and Utility
2000	Usage Charges	12	16,2	NUMBER	Yes	COL 11	EDX_RPT_ACCOUNT _FACT	USAGE_CHARGE _AMT	Telco and Utility
2000	Credits	13	16,2	NUMBER	Yes	COL 12	EDX_RPT_ACCOUNT _FACT	CREDIT_ADJUST _AMT	Telco and Utility
2000	Other Charges	14	16,2	NUMBER	Yes	COL 13	EDX_RPT_ACCOUNT _FACT	OTHER_CHARGE _AMT	Telco and Utility
2000	Taxes and Fees	15	16,2	NUMBER	Yes	COL 14	EDX_RPT_ACCOUNT _FACT	TAXES_SURCHARGES_FEE	Telco and Utility
2000	Total Charge Amount	16	16,2	NUMBER	Yes	COL15	EDX_RPT_ACCOUNT _FACT	TOTAL_CHARGE_AMT	Telco and Utility
2000	Charge Flag	17	1	VARCHAR2	Yes	COL16	EDX_RPT_ACCOUNT _FACT	CHARGE_FLAG	Telco and Utility
2000	Account Type	18	20	VARCHAR2	No	COL17	EDX_RPT_ACCOUNT _DIM	ACCOUNT_TYPE_KEY	Telco and Utility
2000	Flex Field_1	19	16,2	NUMBER	No	COL18	EDX_RPT_ACCOUNT _FACT	FLEX_FIELD1	Telco and Utility
2000	Flex Field_2	20	16,2	NUMBER	No	COL19	EDX_RPT_ACCOUNT _FACT	FLEX_FIELD2	Telco and Utility
2000	Flex Field_3	21	16,2	NUMBER	No	COL20	EDX_RPT_ACCOUNT _FACT	FLEX_FIELD3	Telco and Utility
2000	Flex Field_4	22	16,2	NUMBER	No	COL21	EDX_RPT_ACCOUNT _FACT	FLEX_FIELD4	Telco and Utility
2000	Flex Field_5	23	16,2	NUMBER	No	COL22	EDX_RPT_ACCOUNT _FACT	FLEX_FIELD5	Telco and Utility
2000	Address3	24	200	VARCHAR2	No	COL23	EDX_RPT_ACCOUNT _DIM, EDX_RPT_ADDRESS _DIM	ADDRESS3, ADDRESS3	Telco and Utility
2000	Auto Debit Payment Date	25	8	DATE	No	COL24	EDX_RPT_ACCOUNT _FACT	AUTO_PAYMENT _DR_DT	Utility
2000	Cycle End Day	26	2	NUMBER	No	COL25	EDX_RPT_ACCOUNT_DIM	BILL_CYCLE_ENDDAY	Telco

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

Table 160. Account Level Charges at Charge Type Level 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
2100	Rec Type	1	3	VARCHAR2	No	REC_TYPE	None	None	Telco and Utility
2100	Statement Number	2	20	VARCHAR2	Yes	COL1	EDX_RPT_ACCOUNT_CHARGE_FACT	STATEMENT_KEY	Telco and Utility
2100	Account Number	3	20	VARCHAR2	Yes	COL2	EDX_RPT_ACCOUNT_CHARGE_FACT	ACCOUNT_KEY	Telco and Utility
2100	Charge Type Code	4	50	VARCHAR2	Yes	COL3	EDX_RPT_ACCOUNT_CHARGE_FACT	CHARGE_TYPE_KEY	Telco and Utility
2100	Monthly Service Charges	5	16,2	NUMBER	Yes	COL4	EDX_RPT_ACCOUNT_CHARGE_FACT	MONTHLY_CHARGE _AMT	Telco and Utility
2100	Usage Charges	6	16,2	NUMBER	Yes	COL5	EDX_RPT_ACCOUNT_CHARGE_FACT	USAGE_CHARGE _AMT	Telco and Utility
2100	Credits	7	16,2	NUMBER	Yes	COL6	EDX_RPT_ACCOUNT_CHARGE_FACT	CREDIT_ADJUST _AMT	Telco and Utility
2100	Other Charges	8	16,2	NUMBER	Yes	COL7	EDX_RPT_ACCOUNT_CHARGE_FACT	OTHER_CHARGE_AMT	Telco and Utility
2100	Taxes and Fees	9	16,2	NUMBER	Yes	COL8	EDX_RPT_ACCOUNT_CHARGE_FACT	TAXES_SURCHARGES _FEE	Telco and Utility
2100	Total Charge Amount	10	16,2	NUMBER	Yes	COL9	EDX_RPT_ACCOUNT_CHARGE_FACT	TOTAL_CHARGE_AMT	Telco and Utility
2100	Charge Note	11	255	VARCHAR2	No	COL10	EDX_RPT_ACCOUNT_CHARGE_FACT	CHARGE_NOTE	Telco and Utility

Implementation Guide for Oracle Self-Service E-Billing		Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.