Implementation Guide for Oracle Billing Insight > Load Input File Specifications and Data Mapping >
File Formats for Prepaid Information
This topic shows the file formats for prepaid data. Table 158 shows the file format for prepaid account information.
Table 158. Prepaid Account File Format
|
|
|
|
|
|
Staging Table (STG_CDR) Column Name
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ACCOUNT_FACT
|
|
|
Table 159 shows the file format for prepaid product information. This table stores charges for a product and plan.
Table 159. Prepaid Product File Format
|
|
|
|
|
|
Staging Table (STG_CDR) Column Name
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_PRODUCT _FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ PRODUCT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ PRODUCT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ PRODUCT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ PRODUCT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ PRODUCT_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_ PRODUCT_FACT
|
|
|
Table 160 shows the file format for prepay detail information. This file contains details for each transaction performed by a user.
Table 160. Prepaid Detail File Format
|
|
|
|
|
|
Staging Table (STG_CDR) Column Name
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|
|
|
|
|
|
|
EDX_RPT_PREPAY_DETAIL_FACT
|
|
|
|