Oracle Billing Insight V7.0: File Formats for Prepaid Information

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

File Formats for Prepaid Information

Table 160 shows the file format for prepaid account information.

Table 160. Prepaid 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
9000	Rec Type	1	4	VARCHAR2	Yes	None	None	None	Telco
9000	Account Number	2	20	VARCHAR2	Yes	COL1	EDX_RPT_PREPAY_ACCOUNT_FACT	ACCOUNT_KEY	Telco
9000	Month Charge Amt	3	16,2	NUMBER	Yes	COL2	EDX_RPT_PREPAY_ACCOUNT_FACT	MONTHLY_CHARGE _AMT	Telco
9000	Usage Amt	4	16,2	NUMBER	No	COL3	EDX_RPT_PREPAY_ACCOUNT_FACT	USAGE_CHARGE _AMT	Telco
9000	Adjustment Amt	5	16,2	NUMBER	No	COL4	EDX_RPT_PREPAY_ACCOUNT_FACT	ADJUST_AMT	Telco
9000	Other Charges Amt	6	16,2	NUMBER	No	COL5	EDX_RPT_PREPAY_ACCOUNT_FACT	OTHER_CHARGE_AMT	Telco
9000	Taxes and Fees	7	16,2	NUMBER	No	COL6	EDX_RPT_PREPAY_ACCOUNT_FACT	TAXES_SURCHARGES_FEE	Telco
9000	Total Charge Amt	8	16,2	NUMBER	Yes	COL7	EDX_RPT_PREPAY_ACCOUNT_FACT	TOTAL_CHARGE_AMT	Telco
9000	Top Off Date	9	8	DATE	Yes	COL8	EDX_RPT_PREPAY_ACCOUNT_FACT	TOP_OFF_DATE	Telco
9000	Expiry Date	10	8	DATE	Yes	COL9	EDX_RPT_PREPAY_ACCOUNT_FACT	EXPIRY_DATE	Telco
9000	FlexField1	17	225	VARCHAR2	No	COL10	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD1	Telco
9000	FlexField2	18	225	VARCHAR2	No	COL11	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD2	Telco
9000	FlexField3	19	225	VARCHAR2	No	COL12	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD3	Telco
9000	FlexField4	20	225	VARCHAR2	No	COL13	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD4	Telco
9000	FlexField5	21	225	VARCHAR2	No	COL14	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD5	Telco
9000	FlexField6	22	16,2	NUMBER	No	COL15	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD6	Telco
9000	FlexField7	23	16,2	NUMBER	No	COL16	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD7	Telco
9000	FlexField8	24	16,2	NUMBER	No	COL17	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD8	Telco
9000	FlexField9	25	8	DATE	No	COL18	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD9	Telco
9000	FlexField10	26	8	DATE	No	COL19	EDX_RPT_PREPAY_ACCOUNT_FACT	FLEX_FIELD10	Telco
9000	Remaining Balance	27	16,2	NUMBER	No	COL20	EDX_RPT_PREPAY_ACCOUNT_FACT	REMAIN_BAL_AMT	Telco
9000	Remaining Balance as of	28	8	DATE	No	COL21	EDX_RPT_PREPAY_ACCOUNT_FACT	REMAIN_BAL_AS_OF	Telco

Table 161 shows the file format for prepaid product information. This table stores charges for a product and plan.

Table 161. Prepaid Product 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
9200	Rec Type	1	4	VARCHAR2	Yes	REC_TYPE	None	None	Telco
9200	Account Number	2	20	VARCHAR2	Yes	COL1	EDX_RPT_PREPAY_PRODUCT_FACT	ACCOUNT_KEY	Telco
9200	Service Number	3	20	VARCHAR2	Yes	COL2	EDX_RPT_PREPAY_PRODUCT_FACT	SERVICE_KEY	Telco
9200	Plan Type Code	4	50	VARCHAR2	Yes	COL3	EDX_RPT_PREPAY_PRODUCT_FACT	PLAN_TYPE_KEY	Telco
9200	Product Code	5	50	VARCHAR2	Yes	COL4	EDX_RPT_PREPAY_PRODUCT_FACT	PRODUCT_PARENT _KEY	Telco
9200	Monthly Charge Amount	6	16,2	NUMBER	Yes	COL5	EDX_RPT_PREPAY_PRODUCT_FACT	CHARGE_AMT	Telco
9200	Product Sub Code	7	50	VARCHAR2	Yes	COL6	EDX_RPT_PREPAY_PRODUCT_FACT	PRODUCT_CHILD _KEY	Telco
9200	Transaction Date	8	8	DATE	Yes	COL7	EDX_RPT_PREPAY_PRODUCT_FACT	TRANS_DT	Telco

Table 162 shows the file format for prepay detail information. This file contains details for each transaction performed by a user.

Table 162. Prepaid 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
9500	Rec Type	1	4	VARCHAR2	Yes	REC_TYPE	None	None	Telco
9500	Account Number	2	20	VARCHAR2	Yes	COL1	EDX_RPT_PREPAY_DETAIL_FACT	ACCOUNT_KEY	Telco
9500	Service Number	3	20	VARCHAR2	Yes	COL2	EDX_RPT_PREPAY_DETAIL_FACT	SERVICE_KEY	Telco
9500	Transaction Date	4	8	DATE	Yes	COL3	EDX_RPT_PREPAY_DETAIL_FACT	TRANS_DT	Telco
9500	Called Number	5	20	VARCHAR2	Yes	COL4	EDX_RPT_PREPAY_DETAIL_FACT	CALLED_NUM	Telco
9500	Usage Type Code	6	50	VARCHAR2	Yes	COL5	EDX_RPT_PREPAY_DETAIL_FACT	USAGE_TYPE_KEY	Telco
9500	Tariff Code	7	50	VARCHAR2	Yes	COL6	EDX_RPT_PREPAY_DETAIL_FACT	TARIFF_KEY	Telco
9500	Usage Unit Code	8	50	VARCHAR2	Yes	COL7	EDX_RPT_PREPAY_DETAIL_FACT	UNIT_KEY	Telco
9500	Call Type Code	9	50	VARCHAR2	No	COL8	EDX_RPT_PREPAY_DETAIL_FACT	CALL_TYPE_KEY	Telco
9500	Direction Code	10	20	VARCHAR2	Yes	COL9	EDX_RPT_PREPAY_DETAIL_FACT	DIRECTION_KEY	Telco
9500	Calling City, State Code	11	100	VARCHAR2	Yes	COL10	EDX_RPT_PREPAY_DETAIL_FACT	CALLING_AREA_CD_KEY	Telco
9500	Calling Country Code	12	100	VARCHAR2	Yes	COL11	EDX_RPT_PREPAY_DETAIL_FACT	CALLING_AREA_CD_KEY	Telco
9500	Called City, State Code	13	100	VARCHAR2	Yes	COL12	EDX_RPT_PREPAY_DETAIL_FACT	CALLED_AREA_CD_KEY	Telco
9500	Called Country Code	14	100	VARCHAR2	Yes	COL13	EDX_RPT_PREPAY_DETAIL_FACT	CALLED_AREA_CD_KEY	Telco
9500	Total Usages	15	16,2	NUMBER	Yes	COL14	EDX_RPT_PREPAY_DETAIL_FACT	TOTAL_USAGE	Telco
9500	Total Charge	16	16,2	NUMBER	Yes	COL15	EDX_RPT_PREPAY_DETAIL_FACT	TOTAL_CHARGE_AMT	Telco
9500	Other Charge	17	16,2	NUMBER	No	COL16	EDX_RPT_PREPAY_DETAIL_FACT	OTHER_CHARGE_AMT	Telco
9500	FlexField1	18	255	VARCHAR2	No	COL17	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD1	Telco
9500	FlexField2	19	255	VARCHAR2	No	COL18	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD2	Telco
9500	FlexField3	20	255	VARCHAR2	No	COL19	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD3	Telco
9500	FlexField4	21	255	VARCHAR2	No	COL20	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD4	Telco
9500	FlexField5	22	255	VARCHAR2	No	COL21	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD5	Telco
9500	FlexField6	23	16,2	NUMBER	No	COL22	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD6	Telco
9500	FlexField7	24	16,2	NUMBER	No	COL23	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD7	Telco
9500	FlexField8	25	16,2	NUMBER	No	COL24	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD8	Telco
9500	FlexField9	26	8	DATE	No	COL25	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD9	Telco
9500	FlexField10	27	8	DATE	No	COL26	EDX_RPT_PREPAY_DETAIL_FACT	FLEX_FIELD10	Telco
9500	Gross Amount	28	16,2	NUMBER	No	COL27	EDX_RPT_PREPAY_DETAIL_FACT	GROSS_AMT	Telco
9500	Discount Amount	29	16,2	NUMBER	No	COL28	EDX_RPT_PREPAY_DETAIL_FACT	DISCOUNT_AMT	Telco
9500	Tax Amount	30	16,2	NUMBER	No	COL29	EDX_RPT_PREPAY_DETAIL_FACT	DISCOUNT_AMT	Telco

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