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

Service Level File Format

This topic shows the file format for account level information.

Table 110 shows the file format for information about the total charges at the service agreement level for an account under a statement.

Table 110. Service Level Total


RECORD TYPE	FIELD	POSITION	MAX LENGTH	DATA TYPE	REQ?	STAGING TABLE (STG_CDR) COLUMN NAME	DB_TABLE_NAME	DB_COLUMN_NAME
3000	Rec Type	1	3	VARCHAR2	Yes	REC_TYPE
3000	Statement Number	2	20	VARCHAR2	Yes	COL1	EDX_RPT_SERVICE_FACT	STATEMENT_KEY
3000	Account Number	3	20	VARCHAR2	Yes	COL2	EDX_RPT_SERVICE_DIM	ACCOUNT_KEY
3000	Service Number	4	20	VARCHAR2	Yes	COL3	EDX_RPT_SERVICE_DIM	SERVICE_NUM
3000	Service Owner Name	5	100	VARCHAR2	No	COL4	N/A	N/A
3000	Monthly Service Charges	6	16,2	NUMBER	Yes	COL5	EDX_RPT_SERVICE_FACT	MONTHLY_CHARGE_AMT
3000	Usage Charges	7	16,2	NUMBER	Yes	COL6	EDX_RPT_SERVICE_FACT	USAGE_CHARGE_AMT
3000	Adjustments	8	16,2	NUMBER	Yes	COL7	EDX_RPT_SERVICE_FACT	CREDIT_ADJUST_AMT
3000	Other Charges	9	16,2	NUMBER	Yes	COL8	EDX_RPT_SERVICE_FACT	OTHER_CHARGE_AMT
3000	Taxes and Fees	10	16,2	NUMBER	Yes	COL9	EDX_RPT_SERVICE_FACT	TAXES_SURCHARGES_FEE
3000	Total Charge Amount	11	16,2	NUMBER	Yes	COL10	EDX_RPT_SERVICE_FACT	TOTAL_CHARGE_AMT
3000	Charge Note	12	255	VARCHAR2	No	COL11	EDX_RPT_SERVICE_FACT	CHARGE_NOTE
3000	Flex Field_1	13	16,2	NUMBER	No	COL12	EDX_RPT_SERVICE_FACT	FLEX_FIELD1
3000	Flex Field_2	14	16,2	NUMBER	No	COL13	EDX_RPT_SERVICE_FACT	FLEX_FIELD2
3000	Flex Field_3	15	16,2	NUMBER	No	COL14	EDX_RPT_SERVICE_FACT	FLEX_FIELD3
3000	Flex Field_4	16	16,2	NUMBER	No	COL15	EDX_RPT_SERVICE_FACT	FLEX_FIELD4
3000	Flex Field_5	17	16,2	NUMBER	No	COL16	EDX_RPT_SERVICE_FACT	FLEX_FIELD5

Format

Table 111 shows the file format for the service level on charge type information.

Table 111. Service Level on Charge Type


RECORD TYPE	FIELD	POSITION	MAX LENGTH	DATA TYPE	REQ?	STAGING TABLE (STG_CDR) COLUMN NAME	DB_TABLE_NAME	DB_COLUMN_NAME
3100	Rec Type	1	3	VARCHAR2	Yes	REC_TYPE	N/A	N/A
3100	Statement Number	2	20	VARCHAR2	Yes	COL1	EDX_RPT_SERVICE_CHARGE_FACT	STATEMENT_KEY
3100	Account Number	3	20	VARCHAR2	Yes	COL2	EDX_RPT_SERVICE_CHARGE_FACT	ACCOUNT_KEY
3100	Service Number	4	20	VARCHAR2	Yes	COL3	EDX_RPT_SERVICE_CHARGE_FACT	SERVICE_KEY
3100	Charge Type Code	5	50	VARCHAR2	Yes	COL4	EDX_RPT_SERVICE_CHARGE_FACT	CHARGE_TYPE_KEY
3100	Sub Charge Type Code	6	50	VARCHAR2	No	COL5	EDX_RPT_SERVICE_CHARGE_FACT	SUB_CHARGE_TYPE_KEY
3100	Monthly Charge Amount	7	10	NUMBER	Yes	COL6	EDX_RPT_SERVICE_CHARGE_FACT	CHARGE_AMT
3100	Charge Note	8	255	VARCHAR2	No	COL7	EDX_RPT_SERVICE_CHARGE_FACT	CHARGE_NOTE

Format

Table 112 shows the file format for the service charge on product and plan information.

Table 112. Service Charge on Product and Plan


RECORD TYPE	FIELD	POSITION	MAX LENGTH	DATA TYPE	REQ?	STAGING TABLE (STG_CDR) COLUMN NAME	DB_TABLE_NAME	DB_COLUMN_NAME
3200	Rec Type	1	3	VARCHAR2	Yes	REC_TYPE	N/A	N/A
3200	Statement Number	2	20	VARCHAR2	Yes	COL1	EDX_RPT_SERVICE_PRODUCT_FACT	STATEMENT_KEY
3200	Account Number	3	20	VARCHAR2	Yes	COL2	EDX_RPT_SERVICE_PRODUCT_FACT	ACCOUNT_KEY
3200	Service Number	4	20	VARCHAR2	Yes	COL3	EDX_RPT_SERVICE_PRODUCT_FACT	SERVICE_KEY
3200	Plan Type Code	5	50	VARCHAR2	Yes	COL4	EDX_RPT_SERVICE_PRODUCT_FACT	PLAN_TYPE_KEY
3200	Product Code	6	50	VARCHAR2	Yes	COL5	EDX_RPT_SERVICE_PRODUCT_FACT	PRODUCT_CHILD_KEY
3200	Monthly Charge Amount	7	16,2	NUMBER	Yes	COL6	EDX_RPT_SERVICE_PRODUCT_FACT	CHARGE_AMT
3200	Product Note	8	255	VARCHAR2	No	COL7	EDX_RPT_SERVICE_PRODUCT_FACT	PRODUCT_NOTE

Format

Table 113 shows the file format for service charge on usage type information.

Table 113. Service Charge on Usage Type


RECORD TYPE	FIELD	POSITION	MAX LENGTH	DATA TYPE	REQ?	STAGING TABLE (STG_CDR) COLUMN NAME	DB_TABLE_NAME	DB_COLUMN_NAME
3300	Rec Type	1	3	VARCHAR2	Yes	REC_TYPE
3300	Statement Number	2	20	VARCHAR2	Yes	COL1	EDX_RPT_SERVICE_USAGE_FACT	STATEMENT_KEY
3300	Account Number	3	20	VARCHAR2	Yes	COL2	EDX_RPT_SERVICE_USAGE_FACT	ACCOUNT_KEY
3300	Service Number	4	20	VARCHAR2	Yes	COL3	EDX_RPT_SERVICE_USAGE_FACT	SERVICE_KEY
3300	Usage Type Code	5	50	VARCHAR2	Yes	COL4	EDX_RPT_SERVICE_USAGE_FACT	USAGE_TYPE_KEY
3300	Total Usage	6	16,2	NUMBER	Yes	COL5	EDX_RPT_SERVICE_USAGE_FACT	TOTAL_USAGE
3300	Usage Unit Code	7	50	VARCHAR2	Yes	COL6	EDX_RPT_SERVICE_USAGE_FACT	UNIT_KEY
3300	Amount	8	16,2	NUMBER	Yes	COL7	EDX_RPT_SERVICE_USAGE_FACT	TOTAL_CHARGE_AMT
3300	Usage Note	9	255	VARCHAR2	No	COL8	EDX_RPT_SERVICE_USAGE_FACT	USAGE_NOTE

Format

Table 114 shows the file format for the service charges on various tariff information.

Table 114. Service Charges on Various Tariff


RECORD TYPE	FIELD	POSITION	MAX LENGTH	DATA TYPE	REQ?	STAGING TABLE (STG_CDR) COLUMN NAME	DB_TABLE_NAME	DB_COLUMN_NAME
3400	Rec Type	1	3	VARCHAR2	Yes	REC_TYPE	N/A	N/A
3400	Statement Number	2	20	VARCHAR2	Yes	COL1	EDX_RPT_SERVICE_TARIFF_FACT	STATEMENT_KEY
3400	Account Number	3	20	VARCHAR2	Yes	COL2	EDX_RPT_SERVICE_TARIFF_FACT	ACCOUNT_KEY
3400	Service Number	4	20	VARCHAR2	Yes	COL3	EDX_RPT_SERVICE_TARIFF_FACT	SERVICE_KEY
3400	Usage Type Code	5	50	VARCHAR2	Yes	COL4	EDX_RPT_SERVICE_TARIFF_FACT	USAGE_TYPE_KEY
3400	Tariff Code	6	50	VARCHAR2	Yes	COL5	EDX_RPT_SERVICE_TARIFF_FACT	TARIFF_KEY
3400	Allowance	7	20	VARCHAR2	Yes	COL6	EDX_RPT_SERVICE_TARIFF_FACT	ALLOWANCE
3400	Total Usages	8	16,2	NUMBER	Yes	COL7	EDX_RPT_SERVICE_TARIFF_FACT	TOTAL_USAGE
3400	Usage Unit Code	9	50	VARCHAR2	Yes	COL8	EDX_RPT_SERVICE_TARIFF_FACT	UNIT_KEY
3400	Billable	10	16,2	NUMBER	Yes	COL9	EDX_RPT_SERVICE_TARIFF_FACT	BILLABLE
3400	Amount	11	16,2	NUMBER	Yes	COL10	EDX_RPT_SERVICE_TARIFF_FACT	CHARGE_AMT

Format

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