Oracle Self-Service E-Billing v6.0: Service Detail Level File Format


RECORD TYPE	FIELD	POSITION	MAX LENGTH	DATA TYPE	REQ?	STAGING TABLE (STG_CDR) COLUMN NAME	DB_TABLE_NAME	DB_COLUMN_NAME
4000	Rec Type	1	3	VARCHAR2	Yes	REC_TYPE	N/A	N/A
4000	Usage Name	2	50	VARCHAR2	Yes	COL1	EDX_RPT_SERVICE_DETAIL_FACT	USAGE_TYPE_KEY
4000	Statement Number	3	20	VARCHAR2	Yes	COL2	EDX_RPT_SERVICE_DETAIL_FACT	STATEMENT_KEY
4000	Account Number	4	20	VARCHAR2	Yes	COL3	EDX_RPT_SERVICE_DETAIL_FACT	ACCOUNT_KEY
4000	Service Number	5	20	VARCHAR2	Yes	COL4	EDX_RPT_SERVICE_DETAIL_FACT	SERVICE_KEY
4000	Called Date	6	8	DATE	Yes	COL5	EDX_RPT_SERVICE_DETAIL_FACT	DATE_KEY
4000	Called Time	7	10	VARCHAR2	Yes	COL6	EDX_RPT_SERVICE_DETAIL_FACT	DURATION
4000	Called Number	8	20	VARCHAR2	Yes	COL7	EDX_RPT_SERVICE_DETAIL_FACT	CALLED_NUM
4000	Tariff Code	9	50	VARCHAR2	Yes	COL8	EDX_RPT_SERVICE_DETAIL_FACT	TARIFF_KEY
4000	Call Type Code	10	50	VARCHAR2	No	COL9	EDX_RPT_SERVICE_DETAIL_FACT	CALL_TYPE_KEY
4000	Direction Code	11	20	VARCHAR2	Yes	COL10	EDX_RPT_SERVICE_DETAIL_FACT	DIRECTION_KEY
4000	Service Type Code	12	50	VARCHAR2	No	COL11	EDX_RPT_SERVICE_DETAIL_FACT	SERVICE_TYPE_KEY
4000	Total Usages	13	16,2	NUMBER	Yes	COL12	EDX_RPT_SERVICE_DETAIL_FACT	TOTAL_USAGE
4000	Usages Unit Code	14	50	VARCHAR2	Yes	COL13	EDX_RPT_SERVICE_DETAIL_FACT	UNIT_KEY
4000	Other Charge	15	16,2	NUMBER	Yes	COL14	EDX_RPT_SERVICE_DETAIL_FACT	OTHER_CHARGE_AMT
4000	Total Charge	16	16,2	NUMBER	Yes	COL15	EDX_RPT_SERVICE_DETAIL_FACT	TOTAL_CHARGE_AMT
4000	Calling City and State	17	100	VARCHAR2	Yes	COL16	EDX_RPT_SERVICE_DETAIL_FACT	CALLING_AREA_CD_KEY
4000	Calling Country Code	18	100	VARCHAR2	Yes	COL17	EDX_RPT_SERVICE_DETAIL_FACT	CALLING_AREA_CD_KEY
4000	Reference Number	19	100	VARCHAR2	No	COL18	EDX_RPT_SERVICE_DETAIL_FACT	REFERENCE_NUM
4000	Carrier Code	20	50	VARCHAR2	No	COL19	EDX_RPT_SERVICE_DETAIL_FACT	CARRIER_KEY
4000	Region Code	21	50	VARCHAR2	No	COL20	EDX_RPT_SERVICE_DETAIL_FACT	REGION_KEY
4000	Note1	22	2000	VARCHAR2	No	COL21	EDX_RPT_SERVICE_DETAIL_FACT	NOTE1
4000	Note2	23	2000	VARCHAR2	No	COL22	EDX_RPT_SERVICE_DETAIL_FACT	NOTE2
4000	Note3	24	2000	VARCHAR2	No	COL23	EDX_RPT_SERVICE_DETAIL_FACT	NOTE3
4000	Note4	25	2000	VARCHAR2	No	COL24	EDX_RPT_SERVICE_DETAIL_FACT	NOTE4
4000	Note5	26	2000	VARCHAR2	No	COL25	EDX_RPT_SERVICE_DETAIL_FACT	NOTE5
4000	Called City and State	27	100	VARCHAR2	Yes	COL26	EDX_RPT_SERVICE_DETAIL_FACT	CALLED_AREA_CD_KEY
4000	Called Country Code	28	100	VARCHAR2	Yes	COL27	EDX_RPT_SERVICE_DETAIL_FACT	CALLED_AREA_CD_KEY

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