- Column Descriptions for All Monthly Reports (New Portal)

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

or

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 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. Charge applied whenever a CDMA device enters the Suspended state (by the act of suspension). 

BR

DEACTIVATION FEE

Charge applied whenever a CDMA or GSM device enters the Cancelled state (by the act of deactivation). 

BS

REACTIVATION FEE

This column is no longer used. Charge applied whenever a CDMA device enters the Active-Billed state from the Cancelled or the Provisioned state—after the first time (by the act of reactivation). 

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. Charge applied whenever a CDMA device enters the Suspended state (by the act of suspension). 

BS

DEACTIVATION FEE

Charge applied whenever a CDMA or GSM device enters the Cancelled state (by the act of deactivation). 

BT

REACTIVATION FEE

This column is no longer used. Charge applied whenever a CDMA device enters the Active-Billed state from the Cancelled or the Provisioned state—after the first time (by the act of reactivation). 

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. Charge applied the first time a CDMA Device enters the Active-Billed state (by default activation based on triggers or by the act of activation).
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. Charge applied whenever a CDMA device enters the Suspended state (by the act of suspension). 
BC DEACTIVATION FEE Charge applied whenever a CDMA or GSM device enters the Cancelled state (by the act of deactivation). 
BD REACTIVATION FEE This column is no longer used. Charge applied whenever a CDMA device enters the Active-Billed state from the Cancelled or the Provisioned state—after the first time (by the act of reactivation). 
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.

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.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.