File format headers in the scheduled report CSV files

Billing

Account ID,Account Name,Status,Customer No,Type,Currency,Charging Category,Fee Category,Fee Type,Charging Date,Name,Description,Amount,Recurrence,Activated by,Ratezone,SIM & Benefit Fee,No of SIMs,Price per SIM,Price per Threshold,Volume (MB) in Benefit,Volume (MB) ,Price per unit,Unit,No of SMS in Benefit,No of SMS,Price per SMS,No of Networks,Price per Network,Country,Operator,Reference,Sub-total,Total 

Reporting

Reseller or Enterprise user shall then be able to schedule a task to export the data of 4 reports (Billing, Usage, SIM Status and SIM Events) in monthly or weekly frequency. The monthly report shall be generated every 1st of month (UTC 4.00 PM) providing data of the previous month.The weekly report shall be generated every Sunday (UTC 4.00 PM) providing data from previous Sunday to Saturday.The output of the Reporting Scheduled Task is limited to 1.400.000 records. In case the limit is exceeded, the run is cancelled and Recipients are notified.

Billing report (granularity 1 day)

DATE,AccountId,CustomerName,iccid,msisdn,ServiceName,TariffName,RatezoneName,DynamicBenefitName,ChargedCount,ChargedVolume,ChargedAmount,CostCurrency,CategoryName,FeeCategory,FeeType

Usage report (granularity 15min, 1 day, 1 month)

timestampAccount,timestamp,serviceTypeName,subServiceType,parentAccountId,accountId,endpointId,imsi,iccid,msisdn,imei,planId,addonPlanId,dynamicBenefitId,visitedOperatorName,rateZoneName,count,volumeTotal,volumeDownlink,volumeUplink,apn,ratType,revenue,revenueCurrency

SIM events report

date,parentAccountId,accountId,simEvent,iccid,imsi,msisdn,endpointId

SIM status report

date,accountId,parentAccountId,active,readyToActivate,preActive,activeTest,activeInventory,suspend,deactive,total