- Column Descriptions for All Monthly Reports – Aeris

Depending on the SIMs and network services that you use in your IoT implementation, you will receive a variety of monthly reports at the end of each billing period. You will receive at least three system-generated reports monthly: Invoice Detail, New Summary, and at least one traffic detail report. This article describes the columns in the various forms of monthly reports.

Report Name and Description

Link to Column Descriptions

General Reports

InvoiceDetailReport_nnnnn_yyyymm.csv

The Invoice Detail Report provides the first-level breakout of the charges included on your invoice.

Report Description

Column Listing

yyyymm_New_Summary_nnnnn_yyyymm.zip

and

yyyymm_New_Summary_Esim_nnnnn_yyyymm.zip

The Account Summary Report provides a detailed accounting on a device-by-device basis.

Report Description

Column Listing for New Summary

Column Listing for New Summary Esim

yyyymm_New-Consolidated_ Account_Summary_nnnnn_yyyymm.csv.zip

The New Consolidated Summary Report is available only to "Master Account" Users. This report provides a summary of traffic during the billing period for each device in the hierarchy (Parent Account and Child Accounts).

Report Description

Column Listing

yyyymm_Pool_Summary_nnnnn_yyyymm.csv

The Pool Summary Report provides an account-level breakdown of usage, overage, and charges incurred on each pool during a particular billing period.

Report Description

Column Listing

TRAFFIC DETAIL REPORTS

Description

Global SIM Traffic Reports

yyyymm_SMS_MB_Dtl_nnnnn_yyyymm.csv.zip

yyyymm_SMS_Dtl_nnnnn_yyyymm.csv.zip

These reports provides a detailed listing of Global SIM SMS traffic during the billing period for each device.

Report Description

MB_Dtl Column Listing

Dtl Column Listing

yyyymm-GPRS_Dtl_nnnnn_yyyymm.csv.zip

This report provides a detailed listing of GSM Packet Data traffic during the billing period for each device.

Report Description

Column Listing

yyyymm-Voice_GSM_Dtl_nnnnn_yyyymm.csv.zip

This report provides a detailed listing of GSM Voice traffic during the billing period for each session.

Report Description

Column Listing

LTE Traffic Reports

yyyymm_LTE_SMS_Dtl_nnnnn_yyyymm.csv.zip

This report provides a detailed listing of LTE SMS traffic during the billing period for each device.

Report Description

Column Listing

yyyymm-LTE_Dtl_nnnnn_yyyymm.csv.zip

This report provides a detailed listing of LTE Packet Data traffic during the billing period for each device.

Report Description

Column Listing

Invoice Detail Report Description and Columns

This report is titled:

InvoiceDetailReport_nnnnn_yyyymm.csv

where nnnnn is your account number, and yyyy and mm are the year and month of the billing period for the invoice.

The Invoice Detail Report provides the first-level breakout of the charges included on your invoice. The information in this report breaks down each charge type found on your invoice into the chargeable components of each rate plan and also includes details by billing zone and SIM/device status. This report is particularly useful in determining contributions to charges summarized on the invoice for each rate plan and the zone in which services were utilized.

This report provides an account-level breakdown of charges incurred on each rate plan during a particular billing period.

Columns for InvoiceDetailReport_nnnnn_yyyymm.csv

Column	Value	Definition
A	type	The type of fee. Possible values are: Access Fee Activation Fee Deactivation Fee Reactivation Fee Suspend Fee Unsuspend Fee Data Charges SMS Charges Voice Charges
B	rate plan label	The rate plan represented by this row.
C	zone	The zone represented by this row.
D	rate	Unit price of the service for the given charge type and zone as defined in the rate plan: For state changes, this column shows the fee as defined in the rate plan For traffic charges, this column shows the rate at which overage is charged as defined in the rate plan
E	product or technology	If this column is "product": The Aeris product represented by this row. Possible values are: Dual-Mode A-LH Fusion Global Fusion Global HD Fusion NA Global eSIM Global SIM SelfServe SIM USCC If this column is "technology": The technology defined in the rate plan. Possible values are: GSM LTE
F	status	The subscriber status. Possible values are: BILL PROV SUSP NULL (for fees that are not dependent upon device status such as activation fees, suspend fees, or cancellation fees)
G	total quantity	Included quantity + overage quantity For state change fees, this is the total number of devices on the rate plan that incurred this fee For traffic charges, this is the total traffic usage across all devices on the rate plan Data usage is shown in KB SMS usage is shown in number of SMS Voice usage is shown in minutes
H	included quantity	The usage generated across all devices on the rate plan that was not charged separately because the device did not exceed the usage included in the rate plan during the billing period For state changes, this will be 0 Data usage is shown in KB SMS usage is shown in number of SMS Voice usage is shown in minutes
I	overage quantity	The usage generated across all devices on the rate plan that was considered overage and was billed per the rate defined in the rate plan For state changes, this will be 0 Data usage is shown in KB SMS usage is shown in number of SMS Voice usage is shown in minutes
J	total charge	Total charges in dollars for state change fees: total quantity * rate for traffic charges: overage quantity * rate

New Summary and New Summary Esim (Account Summary Report)

This report is titled

yyyymm_New_Summary_nnnnn_yyyymm.zip
which contains
New_Summary_nnnnn_yyyymm-1.csv

yyyymm_New_Summary_Esim_nnnn_yyyymm.zip
which contans
New_Summary_Esim_nnnnn_yyyymm-1.csv
The eSIM version of the report is provided if your account includes one or more eSIMs. 
It contains one extra column, Column L, which displays the EID of the eSIM.

where nnnnn is your account number, and yyyy and mm are the year and month of the billing period for the invoice. If the report exceeds 1 million rows, additional rows are captured in a second CSV file, and so on.

The account summary report provides a detailed accounting on a device-by-device basis. This report provides the most detail with respect to charges. Found within this report are the billable activities for each individual SIM/device within each zone it accessed during the month. Each row is a unique device-zone combination; that is, the billable activity for a single SIM/device may be detailed in multiple rows depending on the breadth of its activity defined by zones.

You may want to leverage this report to ascertain charges from particular SIMs/devices. For example, a SIM/device may show a concentration of charges within a specific geographic zone for which its assigned rate plan is not particularly designed to accommodate whereas another rate plan may be a better fit.

Columns for New_Summary_nnnnn_yyyymm-1.csv

Column	Value	Definition
A	ACCOUNT ID	Customer account number.
B	REPORT GROUP	Optional logical grouping of devices. Please refer to the current AerAdmin System Specification for more information.
C	SUBSCRIBER_ID	A unique Subscriber ID used in certain network and billing elements.
D	CARRIER	Underlying carrier providing the connectivity for the device.
E	PRODUCT NAME	The Product under which the device was provisioned.
F	DEVICE ID	Unique identifier for each Device Subscription.
G	IMSI	International Mobile Subscriber Identity. This is a unique 15-digit identification number associated with a SIM (in GSM) used by a device.
H	ICCID	Integrated Circuit Card Identifier. This is a unique 18- to 20-digit number used to identify a specific SIM card.
I	PRIMARY MIN	Primary Mobile Identification Number or PMIN. This is also referred to as the Mobile Station Identifer (“MSID”).
J	ESN	Electronic Serial Number or, in the case of a radio that uses a Mobile Equipment Identifier (“MEID”), the Pseudo ESN (“pESN”). A pESN always has 128 (0x80) as the first three digits.
K	MSISDN	Mobile Station International Subscriber Directory Number, which is the reference used for GSM. For convenience, MSISDN usage in the United States drops the international prefix (+1).
L	BILL PERIOD	Period being billed, in format “YYYYMM”. For example, the March 2019 billing period is represented as 201903.
M	BILL STATUS	Short for Billing Period Status. This is the device’s status on the Aeris network for this record during the billing period in this report. A device may have more than 1 record if it changed status during a billing period.
N	BILL STATUS START	This is the first day in the billing period that the device was in the active billed state.
O	BILL STATUS END	This is the last day in the billing period that the device was in the active billed state.
P	RATE PLAN NAME	The name of the Rate Plan that was assigned to the device during the billing period in this report.
Q	HOME ZONE	Y/N - Whether the zone defined in ZONE_NAME is the home zone.
R	ZONE_NAME	The name of the zone in represented by this row.
S	POOL NAME	The device's rate plan pool if applicable.
T	RATE PLAN START	The date that the rate plan became effective for the device.
U	RATE PLAN END	The date that the rate plan will expire for the device.
V	ACTIVE DAYS IN PLAN	Number of days that the device was in the Active-Billed state during the billing period. It is used to calculate the prorated post-paid monthly Access Fee during the billing period in this report.
W	PRORATE FACTOR	The factor used to prorate the Access Fee. It is calculated by dividing the number of days in the billing month by the number of days in the month. This field applies only to Home zones.
X	ACCESS FEE PRICE	Specified in the Rate Plan (MRC).
Y	NON-BILL STATUS SMS MO PRICE	Specified in the Rate Plan. It is a per message price for Mobile Originated SMS messages while the device is in the Provisioned or Suspended state.
Z	NON-BILL STATUS SMS MT PRICE	Specified in the Rate Plan. It is a per message price for Mobile Terminated SMS messages while the device is in the Provisioned or Suspended state.
AA	NON-BILL STATUS VOICE MO PRICE	Specified in the Rate Plan. It is a per minute price for Mobile Terminated voice while the device is in the Provisioned or Suspended state.
AB	NON-BILL STATUS VOICE MT PRICE	Specified in the Rate Plan. It is a per minute price for Mobile Originated voice while the device is in the Provisioned or Suspended state.
AC	NON-BILL STATUS PKT PRICE	Specified in the Rate Plan. It is a per kilobyte (KB) price for packet data traffic while the device is in the Provisioned or Suspended state.
AD	BILL SMS MO PRICE	Overage - Specified in the Rate Plan. It is a per message price for Mobile Originated SMS packets while the device is in the Active-Billed state.
AE	BILL SMS MT PRICE	Overage - Specified in the Rate Plan. It is a per message price for Mobile Terminated SMS packets while the device is in the Active-Billed state.
AF	BILL VOICE MO PRICE	Overage - Specified in the Rate Plan. It is per minute price for Mobile Originated voice over the Mobile Originated voice included amount while the device is in the Active-Billed state.
AG	BILL VOICE MT PRICE	Overage - Specified in the Rate Plan. It is per minute price for Mobile Terminated voice over the Mobile Terminated voice included amount while the device is in the Active-Billed state.
AH	BILL PKT PRICE	Overage - Specified in the Rate Plan. It is a per kilobyte (KB) price for packet data traffic packets while the device is in the Active-Billed state.
AI	PLAN INCLUDED SMS MO MSGS	Specified in the Rate Plan. Number of included Mobile Originated SMS messages in the rate plan.
AJ	PLAN INCLUDED SMS MT MSGS	Specified in the Rate Plan. Number of included Mobile Terminated SMS messages in the rate plan.
AK	PLAN INCLUDED VOICE MO MINUTES	Specified in the Rate Plan. Number of included Mobile Originated voice minutes in the rate plan.
AL	PLAN INCLUDED VOICE MT MINUTES	Specified in the Rate Plan. Number of included Mobile Terminated voice minutes in the rate plan.
AM	PLAN INCLUDED PKT KB	Specified in the Rate Plan. Amount of data in kilobytes (KB) included in the rate plan.
AN	NON-BILL STATUS SMS MO MSGS	Number of Mobile Originated SMS messages transmitted by the device while in the Provisioned state during the billing period in this report.
AO	NON-BILL STATUS SMS MT MSGS	Number of Mobile Terminated SMS messages transmitted by the device while in the Provisioned state during the billing period in this report.
AP	NON-BILL STATUS VOICE MO MINUTES	Number of Mobile Originated voice minutes used by the device while in the Provisioned state during the billing period in this report.
AQ	NON-BILL STATUS VOICE MT MINUTES	Number of Mobile Terminated voice minutes used by the device while in the Provisioned state during the billing period in this report.
AR	NON-BILL STATUS PKT KB	Number of kilobytes (KB) of packet data sent and received by the Device (including TCP/UDP/IP overhead) while in the Provisioned or Suspended state during the billing period in this report.
AS	BILL SMS MO MSGS	Number of Mobile Originated SMS messages while in the Active-Billed state during the billing period in this report.
AT	BILL SMS MT MSGS	Number of Mobile Terminated SMS messages while in the Active-Billed state during the billing period in this report.
AU	BILL VOICE MO MINUTES	Number of Mobile Originated voice minutes while in the Active-Billed state during the billing period in this report.
AV	BILL VOICE MT MINUTES	Number of Mobile Terminated voice minutes while in the Active-Billed state during the billing period in this report.
AW	BILL PKT KB	Number of data kilobytes (KB) sent and received by the device (including TCP/UDP/IP overhead) while in the Active-Billed state during the billing period in this report.
AX	INCLUDED SMS MO MSGS	Number of Mobile Originated SMS messages that were not charged separately because that number did not exceed the number of SMS messages included in the Rate Plan for the device during the billing period in this report.
AY	INCLUDED SMS MT MSGS	Number of Mobile Terminated SMS messages that were not charged separately because that number did not exceed the number of SMS messages included in the Rate Plan for the device during the billing period in this report.
AZ	INCLUDED VOICE MO MINUTES	Number of Mobile Originated voice minutes that were not charged separately because that number did not exceed the number of Voice minutes included in the Rate Plan for the device during the billing period in this report.
BA	INCLUDED VOICE MT MINUTES	Number of Mobile Terminated voice minutes that were not charged separately because that number did not exceed the number of Voice minutes included in the Rate Plan for the device during the billing period in this report.
BB	INCLUDED PKT BYTES	Number of data bytes (input and output including TCP/UDP/IP overhead) that were not charged separately because that number did not exceed the number of bytes included in the Rate Plan for the device during the billing period in this report.
BC	NON-BILL STATUS SMS MO TRAFFIC CHARGES	Charges for Mobile Originated SMS while the device was in the Provisioned or Suspended state.
BD	NON-BILL STATUS SMS MT TRAFFIC CHARGES	Charges for Mobile Terminated SMS while the device was in the Provisioned or Suspended state.
BE	NON-BILL STATUS VOICE MO CHARGES	Charges for Mobile Originated voice while the device was in the Provisioned or Suspended state.
BF	NON-BILL STATUS VOICE MT CHARGES	Charges for Mobile Terminated voice while the device was in the Provisioned or Suspended state.
BG	NON-BILL STATUS PKT TRAFFIC CHARGES	Charges for packet data traffic (input and output including TCP/UDP/IP overhead) for the device in the Provisioned state during the billing period in this report.
BH	NON-BILL STATUS TOTAL TRAFFIC CHARGES	Abbreviated from Billing Period Total Provisioned State Traffic Charges.
BI	BILL SMS MO TRAFFIC CHARGES	Overage charges for Mobile Originated SMS while the device is in the Active-Billed state.
BJ	BILL SMS MT TRAFFIC CHARGES	Overage charges for Mobile Terminated SMS while the device is in the Active-Billed state.
BK	BILL VOICE MO CHARGES	Overage charges for Mobile Originated Voice while the device is in the Active-Billed state.
BL	BILL VOICE MT CHARGES	Overage charges for Mobile Terminated Voice while the device is in the Active-Billed state.
BM	BILL PKT TRAFFIC CHARGES	Overage charges for packet data traffic while the device is in the Active-Billed state.
BN	BILL TOTAL TRAFFIC CHARGES	Abbreviated from Billing Period Total Active-Billed State Traffic Charges.
BO	PRORATED ACCESS FEE	Billing period Access Fee.
BP	ACTIVATION FEE	Charge applied the first time a GSM device enters the Active-Billed state (by the act of activation).
BQ	SUSPEND FEE	This column is no longer used.
BR	DEACTIVATION FEE	Charge applied whenever a GSM device enters the Cancelled state (by the act of deactivation).
BS	REACTIVATION FEE	This column is no longer used.
BT	TOTAL MONTHLY CHARGES	Abbreviated from Billing Period Total Monthly Fixed Charges.
BU	TOTAL DEVICE CHARGES	Abbreviated from Billing Period Total Charges.
BV	CUSTOM FIELD 1	Value from custom text field 1.
BW	CUSTOM FIELD 2	Value from custom text field 2.
BX	CUSTOM FIELD 3	Value from custom text field 3.
BY	CUSTOM FIELD 4	Value from custom text field 4.
BZ	CUSTOM FIELD 5	Value from custom text field 5.

Columns for New_Summary_Esim_nnnnn_yyyymm-1.csv

Column	Value	Definition
A	ACCOUNT ID	Customer account number.
B	REPORT GROUP	Optional logical grouping of devices. Please refer to the current AerAdmin System Specification for more information.
C	SUBSCRIBER_ID	A unique Subscriber ID used in certain network and billing elements.
D	CARRIER	Underlying carrier providing the connectivity for the device.
E	PRODUCT NAME	The Product under which the device was provisioned.
F	DEVICE ID	Unique identifier for each Device Subscription.
G	IMSI	International Mobile Subscriber Identity. This is a unique 15-digit identification number associated with a SIM (in GSM) used by a device.
H	ICCID	Integrated Circuit Card Identifier. This is a unique 18- to 20-digit number used to identify a specific SIM card.
I	PRIMARY MIN	Primary Mobile Identification Number or PMIN. This is also referred to as the Mobile Station Identifer (“MSID”).
J	ESN	Electronic Serial Number or, in the case of a radio that uses a Mobile Equipment Identifier (“MEID”), the Pseudo ESN (“pESN”). A pESN always has 128 (0x80) as the first three digits.
K	MSISDN	Mobile Station International Subscriber Directory Number, which is the reference used for GSM. For convenience, MSISDN usage in the United States drops the international prefix (+1).
L	EID	eSIM Identifier. This is a unique 32-digit number used to identify a specific eSIM card.
M	BILL PERIOD	Period being billed, in format “YYYYMM”. For example, the March 2019 billing period is represented as 201903.
N	BILL STATUS	Short for Billing Period Status. This is the device’s status on the Aeris network for this record during the billing period in this report. A device may have more than 1 record if it changed status during a billing period.
O	BILL STATUS START	This is the first day in the billing period that the device was in the active billed state.
P	BILL STATUS END	This is the last day in the billing period that the device was in the active billed state.
Q	RATE PLAN NAME	The name of the Rate Plan that was assigned to the device during the billing period in this report.
R	HOME ZONE	Y/N - Whether the zone defined in ZONE_NAME is the home zone.
S	ZONE_NAME	The name of the zone in represented by this row.
T	POOL NAME	The device's rate plan pool if applicable.
U	RATE PLAN START	The date that the rate plan became effective for the device.
V	RATE PLAN END	The date that the rate plan will expire for the device.
W	ACTIVE DAYS IN PLAN	Number of days that the device was in the Active-Billed state during the billing period. It is used to calculate the prorated post-paid monthly Access Fee during the billing period in this report.
X	PRORATE FACTOR	The factor used to prorate the Access Fee. It is calculated by dividing the number of days in the billing month by the number of days in the month. This field applies only to Home zones.
Y	ACCESS FEE PRICE	Specified in the Rate Plan (MRC).
Z	NON-BILL STATUS SMS MO PRICE	Specified in the Rate Plan. It is a per message price for Mobile Originated SMS messages while the device is in the Provisioned or Suspended state.
AA	NON-BILL STATUS SMS MT PRICE	Specified in the Rate Plan. It is a per message price for Mobile Terminated SMS messages while the device is in the Provisioned or Suspended state.
AB	NON-BILL STATUS VOICE MO PRICE	Specified in the Rate Plan. It is a per minute price for Mobile Terminated voice while the device is in the Provisioned or Suspended state.
AC	NON-BILL STATUS VOICE MT PRICE	Specified in the Rate Plan. It is a per minute price for Mobile Originated voice while the device is in the Provisioned or Suspended state.
AD	NON-BILL STATUS PKT PRICE	Specified in the Rate Plan. It is a per kilobyte (KB) price for packet data traffic while the device is in the Provisioned or Suspended state.
AE	BILL SMS MO PRICE	Overage - Specified in the Rate Plan. It is a per message price for Mobile Originated SMS packets while the device is in the Active-Billed state.
AF	BILL SMS MT PRICE	Overage - Specified in the Rate Plan. It is a per message price for Mobile Terminated SMS packets while the device is in the Active-Billed state.
AG	BILL VOICE MO PRICE	Overage - Specified in the Rate Plan. It is per minute price for Mobile Originated voice over the Mobile Originated voice included amount while the device is in the Active-Billed state.
AH	BILL VOICE MT PRICE	Overage - Specified in the Rate Plan. It is per minute price for Mobile Terminated voice over the Mobile Terminated voice included amount while the device is in the Active-Billed state.
AI	BILL PKT PRICE	Overage - Specified in the Rate Plan. It is a per kilobyte (KB) price for packet data traffic packets while the device is in the Active-Billed state.
AJ	PLAN INCLUDED SMS MO MSGS	Specified in the Rate Plan. Number of included Mobile Originated SMS messages in the rate plan.
AK	PLAN INCLUDED SMS MT MSGS	Specified in the Rate Plan. Number of included Mobile Terminated SMS messages in the rate plan.
AL	PLAN INCLUDED VOICE MO MINUTES	Specified in the Rate Plan. Number of included Mobile Originated voice minutes in the rate plan.
AM	PLAN INCLUDED VOICE MT MINUTES	Specified in the Rate Plan. Number of included Mobile Terminated voice minutes in the rate plan.
AN	PLAN INCLUDED PKT KB	Specified in the Rate Plan. Amount of data in kilobytes (KB) included in the rate plan.
AO	NON-BILL STATUS SMS MO MSGS	Number of Mobile Originated SMS messages transmitted by the device while in the Provisioned state during the billing period in this report.
AP	NON-BILL STATUS SMS MT MSGS	Number of Mobile Terminated SMS messages transmitted by the device while in the Provisioned state during the billing period in this report.
AQ	NON-BILL STATUS VOICE MO MINUTES	Number of Mobile Originated voice minutes used by the device while in the Provisioned state during the billing period in this report.
AR	NON-BILL STATUS VOICE MT MINUTES	Number of Mobile Terminated voice minutes used by the device while in the Provisioned state during the billing period in this report.
AS	NON-BILL STATUS PKT KB	Number of kilobytes (KB) of packet data sent and received by the Device (including TCP/UDP/IP overhead) while in the Provisioned or Suspended state during the billing period in this report.
AT	BILL SMS MO MSGS	Number of Mobile Originated SMS messages while in the Active-Billed state during the billing period in this report.
AU	BILL SMS MT MSGS	Number of Mobile Terminated SMS messages while in the Active-Billed state during the billing period in this report.
AV	BILL VOICE MO MINUTES	Number of Mobile Originated voice minutes while in the Active-Billed state during the billing period in this report.
AW	BILL VOICE MT MINUTES	Number of Mobile Terminated voice minutes while in the Active-Billed state during the billing period in this report.
AX	BILL PKT KB	Number of data kilobytes (KB) sent and received by the device (including TCP/UDP/IP overhead) while in the Active-Billed state during the billing period in this report.
AY	INCLUDED SMS MO MSGS	Number of Mobile Originated SMS messages that were not charged separately because that number did not exceed the number of SMS messages included in the Rate Plan for the device during the billing period in this report.
AZ	INCLUDED SMS MT MSGS	Number of Mobile Terminated SMS messages that were not charged separately because that number did not exceed the number of SMS messages included in the Rate Plan for the device during the billing period in this report.
BA	INCLUDED VOICE MO MINUTES	Number of Mobile Originated voice minutes that were not charged separately because that number did not exceed the number of Voice minutes included in the Rate Plan for the device during the billing period in this report.
BB	INCLUDED VOICE MT MINUTES	Number of Mobile Terminated voice minutes that were not charged separately because that number did not exceed the number of Voice minutes included in the Rate Plan for the device during the billing period in this report.
BC	INCLUDED PKT BYTES	Number of data bytes (input and output including TCP/UDP/IP overhead) that were not charged separately because that number did not exceed the number of bytes included in the Rate Plan for the device during the billing period in this report.
BD	NON-BILL STATUS SMS MO TRAFFIC CHARGES	Charges for Mobile Originated SMS while the device was in the Provisioned or Suspended state.
BE	NON-BILL STATUS SMS MT TRAFFIC CHARGES	Charges for Mobile Terminated SMS while the device was in the Provisioned or Suspended state.
BF	NON-BILL STATUS VOICE MO CHARGES	Charges for Mobile Originated voice while the device was in the Provisioned or Suspended state.
BG	NON-BILL STATUS VOICE MT CHARGES	Charges for Mobile Terminated voice while the device was in the Provisioned or Suspended state.
BH	NON-BILL STATUS PKT TRAFFIC CHARGES	Charges for packet data traffic (input and output including TCP/UDP/IP overhead) for the device in the Provisioned state during the billing period in this report.
BI	NON-BILL STATUS TOTAL TRAFFIC CHARGES	Abbreviated from Billing Period Total Provisioned State Traffic Charges.
BJ	BILL SMS MO TRAFFIC CHARGES	Overage charges for Mobile Originated SMS while the device is in the Active-Billed state.
BK	BILL SMS MT TRAFFIC CHARGES	Overage charges for Mobile Terminated SMS while the device is in the Active-Billed state.
BL	BILL VOICE MO CHARGES	Overage charges for Mobile Originated Voice while the device is in the Active-Billed state.
BM	BILL VOICE MT CHARGES	Overage charges for Mobile Terminated Voice while the device is in the Active-Billed state.
BN	BILL PKT TRAFFIC CHARGES	Overage charges for packet data traffic while the device is in the Active-Billed state.
BO	BILL TOTAL TRAFFIC CHARGES	Abbreviated from Billing Period Total Active-Billed State Traffic Charges.
BP	PRORATED ACCESS FEE	Billing period Access Fee.
BQ	ACTIVATION FEE	Charge applied the first time a GSM device enters the Active-Billed state (by the act of activation).
BR	SUSPEND FEE	This column is no longer used.
BS	DEACTIVATION FEE	Charge applied whenever a GSM device enters the Cancelled state (by the act of deactivation).
BT	REACTIVATION FEE	This column is no longer used.
BU	TOTAL MONTHLY CHARGES	Abbreviated from Billing Period Total Monthly Fixed Charges.
BV	TOTAL DEVICE CHARGES	Abbreviated from Billing Period Total Charges.
BW	CUSTOM FIELD 1	Value from custom text field 1.
BX	CUSTOM FIELD 2	Value from custom text field 2.
BY	CUSTOM FIELD 3	Value from custom text field 3.
BZ	CUSTOM FIELD 4	Value from custom text field 4.
CA	CUSTOM FIELD 5	Value from custom text field 5.

New Consolidated Account Summary Report

This report is titled:

yyyymm_New-Consolidated_ Account_Summary_nnnnn_yyyymm.csv.zip
which contains
New_Consolidated_ Account_Summary_nnnnn_yyyymm.csv

where nnnnn is your account number, and yyyy and mm are the year and month of the billing period for the invoice. In some cases, multiple files are generated, delineated by -1, -2, and so on.

The New Consolidated Summary Report is only available to "Master Account" Users. This report provides a summary of traffic during the billing period for each device in the hierarchy (Parent Account and Child Accounts).

Columns for New_Consolidated_ Account_Summary_nnnnn_yyyymm.csv

Column	Value	Definition
A	PARENT ACCOUNT ID	Account number of the master account.
B	ACCOUNT ID	Account number of the child account represented in this row.
C	REPORT GROUP	Optional logical grouping of devices. Please refer to the current AerAdmin System Specification for more information.
D	CARRIER	Underlying carrier providing the connectivity for the device.
E	NETSUITE ID	Netsuite account number of the child account.
F	ZONE NAME	This is an Aeris internal field related to the country or region where the device operates.
G	POOL NAME	The device's rate plan pool, if a pool was defined for your account.
H	DEVICE ID	Unique identifier for each Device Subscription.
I	SUBSCRIBER ID	A unique Subscriber ID used in certain network and billing elements.
J	IMSI	International Mobile Subscriber Identity. This is a unique 15-digit identification number associated with a SIM (in GSM) used by a device.
K	ICCID	Integrated Circuit Card Identifier. This is a unique 18- to 20-digit number used to identify a specific SIM card.
L	PRIMARY MIN	Primary Mobile Identification Number or PMIN. This is also referred to as the Mobile Station Identifer (“MSID”).
M	ESN	Electronic Serial Number or, in the case of a radio that uses a Mobile Equipment Identifier (“MEID”), the Pseudo ESN (“pESN”). A pESN always has 128 (0x80) as the first three digits.
N	MSISDN	Mobile Station International Subscriber Directory Number, which is the reference used for GSM. For convenience, MSISDN usage in the United States drops the international prefix (+1).
O	BILL PERIOD	Period being billed, in format “YYYYMM”. For example, the March 2019 billing period is represented as 201903.
P	BILL STATUS	Short for Billing Period Status. This is the device’s status on the Aeris network for this record during the billing period in this report. A device may have more than 1 record if it changed status during a billing period.
Q	BILL STATUS START	This is the first day in the billing period that the device was in the active billed state.
R	BILL STATUS END	This is the last day in the billing period that the device was in the active billed state.
S	RATE PLAN NAME	The name of the Rate Plan that was assigned to the device during the billing period in this report.
T	RATE PLAN START	The date that the rate plan became effective for the device.
U	RATE PLAN END	The date that the rate plan will expire for the device. In most cases, this is a date very far in the future, indicating that there is no end date. However, there may be cases during account setup and testing where the rate plan end date is in the near future.
V	ACTIVE DAYS IN PLAN	Number of days that the device was in the Active-Billed state during the billing period. It is used to calculate the prorated post-paid monthly Access Fee during the billing period in this report.
W	PRORATE FACTOR	The factor used to prorate the Access Fee. It is calculated by dividing the number of days in the billing month by the number of days in the month.
X	ACCESS FEE PRICE	Specified in the Rate Plan (MRC).
Y	NON-BILL STATUS SMS MO PRICE	Specified in the Rate Plan. It is a per message price for Mobile Originated SMS messages while the device is in the Provisioned or Suspended state.
Z	NON-BILL STATUS SMS MT PRICE	Specified in the Rate Plan. It is a per message price for Mobile Terminated SMS messages while the device is in the Provisioned or Suspended state.
AA	NON-BILL STATUS PKT PRICE	Specified in the Rate Plan. It is a per kilobyte (KB) price for packet data traffic while the device is in the Provisioned or Suspended state.
AB	BILL SMS MO PRICE	Overage - Specified in the Rate Plan. It is a per message price for Mobile Originated SMS packets while the device is in the Active-Billed state.
AC	BILL SMS MT PRICE	Overage - Specified in the Rate Plan. It is a per message price for Mobile Terminated SMS packets while the device is in the Active-Billed state.
AD	BILL PKT PRICE	Overage - Specified in the Rate Plan. It is a per kilobyte (KB) price for packet data traffic packets while the device is in the Active-Billed state.
AE	PLAN INCLUDED SMS MO MSGS	Specified in the Rate Plan. Number of included Mobile Originated SMS messages in the rate plan.
AF	PLAN INCLUDED SMS MT MSGS	Specified in the Rate Plan. Number of included Mobile Terminated SMS messages in the rate plan.
AG	PLAN INCLUDED PKT KB	Specified in the Rate Plan. Amount of data in kilobytes (KB) included in the rate plan.
AH	NON-BILL STATUS SMS MO MSGS	Number of Mobile Originated SMS messages transmitted by the device while in the Provisioned state during the billing period in this report.
AI	NON-BILL STATUS SMS MT MSGS	Number of Mobile Terminated SMS messages transmitted by the device while in the Provisioned state during the billing period in this report.
AJ	NON-BILL STATUS PKT KB	Number of kilobytes (KB) of packet data sent and received by the Device (including TCP/UDP/IP overhead) while in the Provisioned or Suspended state during the billing period in this report.
AK	BILL SMS MO MSGS	Number of Mobile Originated SMS messages while in the Active-Billed state during the billing period in this report.
AL	BILL SMS MT MSGS	Number of Mobile Terminated SMS messages while in the Active-Billed state during the billing period in this report.
AM	BILL PKT KB	Number of data kilobytes (KB) sent and received by the device (including TCP/UDP/IP overhead) while in the Active-Billed state during the billing period in this report.
AN	INCLUDED SMS MO MSGS	Number of Mobile Originated SMS messages that were not charged separately because that number did not exceed the number of SMS messages included in the Rate Plan for the device during the billing period in this report.
AO	INCLUDED SMS MT MSGS	Number of Mobile Terminated SMS messages that were not charged separately because that number did not exceed the number of SMS messages included in the Rate Plan for the device during the billing period in this report.
AP	INCLUDED PKT BYTES	Number of data bytes (input and output including TCP/UDP/IP overhead) that were not charged separately because that number did not exceed the number of bytes included in the Rate Plan for the device during the billing period in this report.
AQ	NON-BILL STATUS SMS MO TRAFFIC CHARGES	Charges for Mobile Originated SMS while the device was in the Provisioned or Suspended state.
AR	NON-BILL STATUS SMS MT TRAFFIC CHARGES	Charges for Mobile Terminated SMS while the device was in the Provisioned or Suspended state.
AS	NON-BILL STATUS PKT TRAFFIC CHARGES	Charges for packet data traffic (input and output including TCP/UDP/IP overhead) for the device in the Provisioned state during the billing period in this report.
AT	NON-BILL STATUS TOTAL TRAFFIC CHARGES	Abbreviated from Billing Period Total Provisioned State Traffic Charges.
AU	BILL SMS MO TRAFFIC CHARGES	Overage charges for Mobile Originated SMS while the device is in the Active-Billed state.
AV	BILL SMS MT TRAFFIC CHARGES	Overage charges for Mobile Terminated SMS while the device is in the Active-Billed state.
AW	BILL PKT TRAFFIC CHARGES	Overage charges for packet data traffic while the device is in the Active-Billed state.
AX	BILL TOTAL TRAFFIC CHARGES	Abbreviated from Billing Period Total Active-Billed State Traffic Charges.
AY	PRORATED ACCESS FEE	Billing period Access Fee.
AZ	FIRST BILL FEE	This column is no longer used.
BA	ACTIVATION FEE	Charge applied the first time a GSM device enters the Active-Billed state (by the act of activation).
BB	SUSPEND FEE	This column is no longer used.
BC	DEACTIVATION FEE	Charge applied whenever a GSM device enters the Cancelled state (by the act of deactivation).
BD	REACTIVATION FEE	This column is no longer used.
BE	TOTAL MONTHLY CHARGES	Abbreviated from Billing Period Total Monthly Fixed Charges.
BF	TOTAL CHARGES	Abbreviated from Billing Period Total Charges.
BG	MONTHLY IP FEE	A monthly fee that may apply to a Device with a Static IP address.
BH	PRORATED IP FEE	A prorated monthly fee for a Device with a Static IP address.
BI	NON-BILL STATUS VOICE MO MINUTES	Number of Mobile Originated voice minutes used by the device while in the Provisioned state during the billing period in this report.
BJ	NON-BILL STATUS VOICE MT MINUTES	Number of Mobile Terminated voice minutes used by the device while in the Provisioned state during the billing period in this report.
BK	BILL VOICE MO MINUTES	Number of Mobile Originated voice minutes while in the Active-Billed state during the billing period in this report.
BL	BILL VOICE MT MINUTES	Number of Mobile Terminated voice minutes while in the Active-Billed state during the billing period in this report.
BM	NON-BILL STATUS VOICE MO PRICE	Specified in the Rate Plan. It is a per minute price for Mobile Terminated voice while the device is in the Provisioned or Suspended state.
BN	NON-BILL STATUS VOICE MT PRICE	Specified in the Rate Plan. It is a per minute price for Mobile Originated voice while the device is in the Provisioned or Suspended state.
BO	BILL VOICE MO PRICE	Overage - Specified in the Rate Plan. It is a per minute price for Mobile Originated voice over the Mobile Originated voice included amount while the device is in the Active-Billed state.
BP	BILL VOICE MT PRICE	Overage - Specified in the Rate Plan. It is a per minute price for Mobile Terminated voice over the Mobile Terminated voice included amount while the device is in the Active-Billed state.
BQ	NON-BILL STATUS VOICE MO CHARGES	Charges for Mobile Originated voice while the device was in the Provisioned or Suspended state.
BR	NON-BILL STATUS VOICE MT CHARGES	Charges for Mobile Terminated voice while the device was in the Provisioned or Suspended state.
BS	BILL VOICE MO CHARGES	Overage charges for Mobile Originated Voice while the device is in the Active-Billed state.
BT	BILL VOICE MT CHARGES	Overage charges for Mobile Terminated Voice while the device is in the Active-Billed state.
BU	INCLUDED VOICE MO MINUTES	Number of Mobile Originated voice minutes that were not charged separately because that number did not exceed the number of Voice minutes included in the Rate Plan for the device during the billing period in this report.
BV	INCLUDED VOICE MT MINUTES	Number of Mobile Terminated voice minutes that were not charged separately because that number did not exceed the number of Voice minutes included in the Rate Plan for the device during the billing period in this report.
BW	PLAN INCLUDED VOICE MO MINUTES	Specified in the Rate Plan. Number of included Mobile Originated voice minutes in the rate plan.
BX	PLAN INCLUDED VOICE MT MINUTES	Specified in the Rate Plan. Number of included Mobile Terminated voice minutes in the rate plan.
BY	OVERAGE BUCKET COUNT	The number of additional blocks of data that were used to provide the packet data required in this pool or report group for the billing period reflected in this report. The size of the block/bucket is predefined for the account.
BZ	OVERAGE BUCKET USAGE	The amount of data that was consumed and attributed to the overage block/bucket.
CA	OVERAGE BUCKET CHARGES	This is the cost of data consumption attributed to the overage block/bucket.
CB	CUSTOM FIELD 1	Value from custom text field 1.
CC	CUSTOM FIELD 2	Value from custom text field 2.
CD	CUSTOM FIELD 3	Value from custom text field 3.
CE	CUSTOM FIELD 4	Value from custom text field 4.
CF	CUSTOM FIELD 5	Value from custom text field 5.

Traffic Detail Reports

The detailed traffic reports provide the activity records for each device over the course of the billing cycle. These files are presented by service type (e.g. GSM or LTE, and Packet, SMS, or Voice). The data in these files can be used to corroborate the information in the account summary report with respect to these individual services.

GSM SMS Report
GSM Packet Data Report
GSM Voice Report
LTE SMS Report
LTE Packet Data Report
LTE Voice Report

If the report exceeds 1 million rows, additional rows are captured in a second CSV file, and so on.

Global SIM SMS Reports

There are two possible GSM SMS reports.

yyyymm_SMS_MB_Dtl_nnnnn_yyyymm.csv.zip
which contains
SMS_MB_Dtl_nnnnn_yyyymm.csv
or
yyyymm_SMS_Dtl_nnnnn_yyyymm.csv.zip
which contains
SMS_Dtl_nnnnn_yyyymm.csv

where nnnnn is your account number, and yyyy and mm are the year and month of the billing period for the invoice.

These reports provides a detailed listing of Global SIM SMS traffic during the billing period for each device. The SMS Detail report provides the charges for each individual SMS message, whereas the SMS MB Detail report provides a summary listing with detailed metadata about the sender and receiver of the messages.

Columns for SMS_Dtl_nnnnn_yyyymm.csv

Column	Value	Definition
A	ACCOUNT ID	Your Aeris account number. It is always a format as follows: NNNNN.
B	BILLING PERIOD	Period being billed, in format “YYYYMM”. For example, the March 2019 billing period is represented as 201903.
C	DEVICE ID	The unique identifier for the device used internally by Aeris. This ID will not appear in any AerTraffic or AerAdmin operations, nor in the AerFrame family of interfaces.
D	IMSI	International Mobile Subscriber Identity. Unique identification number, 15 digits in length, associated with the SIM used by the device.
E	MSISDN	Mobile Station International Subscriber Directory Number, which is the reference used for GSM. For convenience, MSISDN usage in the United States drops the international prefix (+1).
F	MESSAGE_TYPE	“MO” for Mobile-Originated SMS or “MT” for Mobile-Terminated SMS.
G	HOST ID	The number of the Aeris host system providing the data.
H	SEQUENCE ID1	In conjunction with SEQUENCE ID2, a value that uniquely identifies the message.
I	SEQUENCE ID2	In conjunction with SEQUENCE ID1, a value that uniquely identifies the message.
J	MESSAGE_PROTOCOL_CODE	Indicates whether device identifiers are GSM or other.
K	APPLICATION_DATA_LENGTH	Length of SMS message.
L	HOST_NAME	The name of the Aeris host system.
M	SERVICE_NAME	Service name indicates the customer service connection.
N	GMT_DATE	The date and time of receipt of the message in UTC, using the format “M/D/YYYY HH:MM:SS XM” (where XM is either “AM” or “PM”). If the Month (or Day) is greater than 9, then two digits are used for that field.
O	BILL_STATUS	Status of device for this record.
P	PRICE_PER_MSG	Price of message based on the Device Rate Plan.
Q	INCLUDED_MSG	0 = not included, 1 = included.
R	MSG_CHARGE	Dollar amount charged for this message.

Columns for SMS_MB_Dtl_nnnnn_yyyymm.csv

Column	Value	Definition
A	ACCOUNT ID	Your Aeris account number. It is always a format as follows: NNNNN.
B	PMIN	Primary Mobile Identification Number or PMIN. This is also referred to as the Mobile Station Identifer (“MSID”).
C	ESN	Electronic Serial Number or, in the case of a radio that uses a Mobile Equipment Identifier (“MEID”), the Pseudo ESN (“pESN”). A pESN always has 128 (0x80) as the first three digits.
D	PAGED MIN	The paged MIN for the forward packets. This is blank if no paged MIN was used.
E	STATUS	The status of the Primary MIN when the RECC or FOCC packet was sent. Status options include PROV, BILL, SUSP, and CANC.
F	SURCHARGE	Identifies whether the packet incurred a surcharge. A ‘1’ signifies that the packet incurred a surcharge; a ‘0’ signifies that it did not incur a surcharge or that this field does not apply to the Customer pricing plan.
G	HOST ID	The number of the Aeris host system providing the data.
H	SEQID1	In conjunction with SEQUENCE ID2, a value that uniquely identifies the message.
I	SEQID2	In conjunction with SEQUENCE ID1, a value that uniquely identifies the message.
J	PKT_TYPE	“MO” for Mobile-Originated SMS or “MT” for Mobile-Terminated SMS.
K	GMT DATE	The date of receipt of the message in UTC, using the format “M/D/YYYY”. If the Month (or Day) is greater than 9, then two digits are used for that field.
L	GMT TIME	The time of receipt of the message in UTC, using the format “HH:MM:SS” (using a 24-hour clock).
M	DATA	The content is configuration page data.
N	DPC	The Destination Point Code. A node number that identifies the address of the destination of SMSDirect traffic on the SS7 network.
O	OPC	The Originating Point Code. A node number that identifies the origin of SMSDirect traffic on the SS7 network.
P	MSC MARKET	Mobile Switching Center Market ID. This identifies the market that the SMSDirect traffic originated from.
Q	MSC SWITCH NO	Mobile Switching Center Number. This identifies the cellular switch that the SMSDirect traffic originated from.

Global SIM Packet Data Report

This report is titled:

yyyymm-GPRS_Dtl_nnnnn_yyyymm.csv.zip
which contains
GPRS_Dtl_nnnnn_yyyymm.csv

where nnnnn is your account number, and yyyy and mm are the year and month of the billing period for the invoice. In some cases, multiple files are generated, delineated by -1, -2, and so on.

This report provides a detailed listing of GSM Packet Data traffic during the billing period for each device.

Columns for GPRS_Dtl_nnnnn_yyyymm.csv

Column	Value	Defintion
A	Bill Period	Period being billed, in format “YYYYMM”. For example, the March 2019 billing period is represented as 201903.
B	Account ID	Customer account number. It is always a format as follows: NNNNN.
C	IMSI	International Mobile Subscriber Identity.
D	ICCID	Integrated Circuit Card Identifier. An 18- to 20-digit number used to identify a specific SIM card.
E	MSISDN	Mobile Subscriber Integrated Services Digital Network number.
F	Rate Plan	Rate plan the device was on.
G	Session Start	Start date and time of session.
H	Session End	End date and time of session.
I	Stop Reason	Reason the session ended.
J	Input Bytes	Total number of input bytes for the session.
K	Output Bytes	Total number of output bytes for the session.
L	Total Bytes	Total number of input and output bytes for the session.
M	Country	The country of the device location.

Global SIM Voice Report

This report is titled:

yyyymm-Voice_GSM_Dtl_nnnnn_yyyymm.csv.zip
which contains
Voice_GSM_Dtl_nnnnn_yyyymm.csv

where nnnnn is your account number, and yyyy and mm are the year and month of the billing period for the invoice.

This report provides a detailed listing of GSM Voice traffic during the billing period for each session.

Columns for Voice_GSM_Dtl_nnnnn_yyyymm.csv

Column	Value	Definition
A	Account ID	Customer account number. It is always a format as follows: NNNNN.
B	ICCID	Integrated Circuit Card Identifier. An 18- to 20-digit number used to identify a specific SIM card.
C	IMSI	International Mobile Subscriber Identity.
D	Call Start Time	Start date and time of the voice session.
E	Call Duration	Duration of the voice session.
F	Call End Time	End date and time of the voice session.

LTE SMS Report

This report is titled:

yyyymm_LTE_SMS_Dtl_nnnnn_yyyymm.csv.zip
which contains
LTE_SMS_Dtl_nnnnn_yyyymm.csv

where nnnnn is your account number, and yyyy and mm are the year and month of the billing period for the invoice.

This report provides a detailed listing of LTE SMS traffic during the billing period for each device.

Columns for LTE_SMS_Dtl_nnnn_yyyymm.csv

Column	Value	Definition
A	ACCOUNT ID	Your Aeris account number. It is always a format as follows: NNNNN.
B	BILLING PERIOD	Period being billed, in format “YYYYMM”. For example, the March 2019 billing period is represented as 201903.
C	DEVICE ID	The unique identifier for the device used internally by Aeris. This ID will not appear in any AerTraffic or AerAdmin operations, nor in the AerFrame family of interfaces.
D	IMSI	International Mobile Subscriber Identity. Unique identification number, 15 digits in length, associated with the SIM used by the device.
E	MSISDN	Mobile Station International Subscriber Directory Number. For convenience, MSISDN usage in the United States drops the international prefix (+1).
F	MESSAGE_TYPE	“MO” for Mobile-Originated SMS or “MT” for Mobile-Terminated SMS.
G	HOST ID	The number of the Aeris host system providing the data.
H	SEQUENCE ID1	In conjunction with SEQUENCE ID2, a value that uniquely identifies the message.
I	SEQUENCE ID2	In conjunction with SEQUENCE ID1, a value that uniquely identifies the message.
J	MESSAGE_PROTOCOL_CODE	Indicates whether device identifiers are LTE or other.
K	APPLICATION_DATA_LENGTH	Length of SMS message.
L	HOST_NAME	The name of the Aeris host system.
M	SERVICE_NAME	Service name indicates the customer service connection.
N	GMT_DATE	The date and time of receipt of the message in UTC, using the format “M/D/YYYY HH:MM:SS XM” (where XM is either “AM” or “PM”). If the Month (or Day) is greater than 9, then two digits are used for that field.
O	BILL_STATUS	Status of device for this record.
P	PRICE_PER_MSG	Price of message based on the Device Rate Plan.
Q	INCLUDED_MSG	0 = not included, 1 = included.
R	MSG_CHARGE	Dollar amount charged for this message.

LTE Packet Data Report

This report is titled:

yyyymm-LTE_Dtl_nnnnn_yyyymm.csv.zip
which contains
LTE_Dtl_nnnnn_yyyymm.csv

where nnnnn is your account number, and yyyy and mm are the year and month of the billing period for the invoice.

This report provides a detailed listing of LTE Packet Data traffic during the billing period for each device.

Columns for LTE_Dtl_nnnnn_yyyymm.csv

Column	Value	Defintion
A	Bill Period	Period being billed, in format “YYYYMM”. For example, the March 2019 billing period is represented as 201903.
B	Account ID	Customer account number. It is always a format as follows: NNNNN.
C	PMIN	Primary Mobile Identification Number or PMIN. This is also referred to as the Mobile Station Identifer (“MSID”).
D	ESN	Electronic Serial Number or, in the case of a radio that uses a Mobile Equipment Identifier (“MEID”), the Pseudo ESN (“pESN”). A pESN always has 128 (0x80) as the first three digits.
E	IMSI	International Mobile Subscriber Identity.
F	ICCID	Integrated Circuit Card Identifier. An 18- to 20-digit number used to identify a specific SIM card.
G	Rate Plan	Rate plan the device was on.
H	Session Start	Start date and time of session.
I	Session End	End date and time of session.
J	Stop Reason	Reason the session ended.
K	Input Bytes	Total number of input bytes for the session.
L	Output Bytes	Total number of output bytes for the session.
M	Total Bytes	Total number of input and output bytes for the session.
N	Carrier	The name of the specific carrier.
O	Country	The country of the device location.

Pool Summary Report

This report is provided only for customers with rate plans that have the ability to rollover unused quantities from one billing period to another.

This report is titled:

yyyymm_Pool_Summary_nnnnn_yyyymm.csv

where nnnnn is your account number, and yyyy and mm are the year and month of the billing period for the invoice.

This report provides an account-level breakdown of usage, overage, and charges incurred on each pool during a particular billing period.

Columns for yyyymm_Pool_Summary_nnnnn_yyyymm.csv

Column	Value	Defintion
A	Account ID	Customer account number. It is always a format as follows: NNNNN.
B	Billing Period ID	An ID reflecting the period being billed. This is an internal format.
C	Traffic Type	A value reflecting the type of traffic: LTE: LTE data traffic GPRS: GSM data traffic
D	Rate Plan Name	Rate plan associated with the pool described in this row.
E	Rate Plan ID	An ID reflecting the rate plan name. This is an internal format.
F	Traffic Unit Type	KB for kilobytes.
G	Pool Name/ Report Group	The name of the pool or the report group number described in this row.
H	Amount Available from Previous	For pools that carry over unused quantities from the previous month, this is the carryover amount available for the billing period reflected in this report.
I	Amount Added to this BP	This is the amount of monthly data defined for this pool or report group for the billing period reflected in this report.
J	Amount Used this BP	This is the amount of data that has been consumed by devices in this pool or report group for the billing period reflected in this report.
K	Amount Expired this BP	This is the amount of data that was unused by devices in this pool or report group for the billing period reflected in this report, and that will be unavailable to carryover into the next billing period.
L	Amount Available at End	This is the amount of data that is available to carryover into the next month.
M	Overage this BP	This is the amount of data that was consumed beyond the amount defined for this pool or report group for the billing period reflected in this report. Column J - Column I.
N	Overage Rate	This is the rate charged to overage amounts, per KB.
O	Overage Charges	This is the total overage charged. Column M * Column N.

Invoice Detail Report Description and Columns

Columns for InvoiceDetailReport_nnnnn_yyyymm.csv

New Summary and New Summary Esim (Account Summary Report)

Columns for New_Summary_nnnnn_yyyymm-1.csv

Columns for New_Summary_Esim_nnnnn_yyyymm-1.csv

New Consolidated Account Summary Report

Columns for New_Consolidated_ Account_Summary_nnnnn_yyyymm.csv

Traffic Detail Reports

Global SIM SMS Reports

Columns for SMS_Dtl_nnnnn_yyyymm.csv

Columns for SMS_MB_Dtl_nnnnn_yyyymm.csv

Global SIM Packet Data Report

Columns for GPRS_Dtl_nnnnn_yyyymm.csv

Global SIM Voice Report

Columns for Voice_GSM_Dtl_nnnnn_yyyymm.csv

LTE SMS Report

Columns for LTE_SMS_Dtl_nnnn_yyyymm.csv

LTE Packet Data Report

Columns for LTE_Dtl_nnnnn_yyyymm.csv

Pool Summary Report

Columns for yyyymm_Pool_Summary_nnnnn_yyyymm.csv

0 Comments