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

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


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	4	VARCHAR2	Yes	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

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


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	Yes	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 © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.