Fields in the Accounts Data Set

Important: You must enable the respective additional data set to generate this report type.

This report provides detailed information about a user account and all sub-accounts under that user, for a chosen period.

Field Description

The table below describes fields available in this report data set.

Field name	Type	Description	Example
RESELLER_ACCOUNT_ID	integer	The vendor's account ID. The vendor is either a provider or reseller. Note: This is "1" for the provider (L0) account.	1000006
ACCOUNT_ZIP	integer	The account postal or ZIP code.	77701
ACCOUNT_TYPE	text	The account type: Customer, Reseller, or Provider.	Customer
ACCOUNT_TECH_PHONE_NUMBER	integer	The technical contact's telephone number.	56487658
ACCOUNT_TECH_PHONE_EXTENTION	integer	The technical contact's telephone extension.	123
ACCOUNT_TECH_PHONE_COUNTRY_CODE	integer	The technical contact's telephone country code.	7
ACCOUNT_TECH_PHONE_AREA_CODE	integer	The technical contact's telephone area code.	929
ACCOUNT_TECH_MNAME	text	The technical contact's middle name.	Garry
ACCOUNT_TECH_LNAME	text	The technical contact's last name.	Smith
ACCOUNT_TECH_FNAME	text	The technical contact's first name.	John
ACCOUNT_TECH_FAX_NUMBER	integer	The technical contact's fax number.	56487658
ACCOUNT_TECH_FAX_EXTENTION	integer	The technical contact's fax extension.	123
ACCOUNT_TECH_FAX_COUNTRY_CODE	integer	The technical contact's fax country code.	7
ACCOUNT_TECH_FAX_AREA_CODE	integer	The technical contact's fax area code.	929
ACCOUNT_TECH_EMAIL	text	The technical contact's email address.	tech@example.com
ACCOUNT_TAX_REGISTRATION_ID	integer	The account tax registration ID.	12345678
ACCOUNT_TAX_STATUS	text	The account taxation status.	2
ACCOUNT_TAX_ZONE_ID	text	The account taxation zone ID.	Provider-Other-State
ACCOUNT_STATUS_INT	text	The account status, as it is stored in the BSS database.	10
ACCOUNT_STATUS	text	One of the following values: Active Canceled Verification required Not initialized Canceled Credit Hold Administrative Hold Credit + Administrative Hold	Active
ACCOUNT_STATE	text	The account state.	Louisiana
ACCOUNT_POSTALADDRESS	text	The account postal address.	Glenn ave, 15/18
ACCOUNT_PERSONAL_PHONE_NUMBER	integer	The account telephone number.	56487658
ACCOUNT_PERSONAL_PHONE_EXTENTION	integer	The account telephone extension.	123
ACCOUNT_PERSONAL_PHONE_COUNTRY_CODE	integer	The account country telephone code.	7
ACCOUNT_PERSONAL_PHONE_AREA_CODE	integer	The account area telephone code.	929
ACCOUNT_PERSONAL_MNAME	text	The account middle name.	Garry
ACCOUNT_PERSONAL_LNAME	text	The account last name.	Smith
ACCOUNT_PERSONAL_FNAME	text	The account first name.	John
ACCOUNT_PERSONAL_FAX_NUMBER	integer	The account fax number.	56487658
ACCOUNT_PERSONAL_FAX_EXTENTION	integer	The account fax extension.	123
ACCOUNT_PERSONAL_FAX_COUNTRY_CODE	integer	The account country code for fax exchange.	7
ACCOUNT_PERSONAL_FAX_AREA_CODE	integer	The account area code for fax exchange.	929
ACCOUNT_PERSONAL_EMAIL	text	Email address of an account owner	admin@example.com
ACCOUNT_NAME	text	The account company name.	Company Inc
ACCOUNT_LEVEL	integer	The account position in the account hierarchy.	2
ACCOUNT_LAST_BILLING_DATE_INT	integer	The last billing date for the account represented as an integer.	1618312636
ACCOUNT_LAST_BILLING_DATE	text	The last billing date for the account represented in the human-readable format.	2013-12-30 00:00:00
ACCOUNT_IS_RESELLER	boolean	This states whether the account is a reseller or provider.	TRUE
ACCOUNT_ID	integer	The unique account identifier.	1000001
ACCOUNT_CUSTOMER_CLASS_NAME	text	The account Customer Class name.	Customers
ACCOUNT_CUSTOMER_CLASS_ID	integer	The account Customer Class ID.	2
ACCOUNT_CUSTOMER_CLASS_COLOR	integer	The color of the Customer Class.	2
ACCOUNT_CURRENCY_CODE	text	The three-letter currency code.	EUR
ACCOUNT_CRTD_USER_USERIDS	integer	The date when the user updated their account information.	1000006
ACCOUNT_CRTD_DATETIME	integer	The date when the user account information was updated by the platform.	1625440785
ACCOUNT_CREATION_DATE_INT	integer	The date when the account was created.	1618312636
ACCOUNT_CREATION_DATE	datetime	The date and time when the account was created. The format is YYYY-MM-DD HH:mm:ss.	2013-12-30 00:00:00
ACCOUNT_COUNTRY_NAME	text	The account country name.	United Kingdom
ACCOUNT_COUNTRY_CODE	text	The two-letter country code.	gb
ACCOUNT_CITY	text	The account city.	London
ACCOUNT_CANCELLATION_DATE	datetime	The date and time when the account was canceled. The format is YYYY-MM-DD HH:mm:ss	2014-02-15 00:00:00
ACCOUNT_BILLING_PHONE_NUMBER	integer	The Billing contact's telephone number.	56487658
ACCOUNT_BILLING_PHONE_EXTENTION	integer	The Billing contact's telephone extension.	123
ACCOUNT_BILLING_PHONE_COUNTRY_CODE	integer	The Billing contact's telephone country code.	7
ACCOUNT_BILLING_PHONE_AREA_CODE	integer	The Billing contact's telephone area code.	929
ACCOUNT_BILLING_MNAME	text	The Billing contact's middle name.	Garry
ACCOUNT_BILLING_LNAME	text	The Billing contact's last name.	Smith
ACCOUNT_BILLING_FNAME	text	The Billing contact's first name.	John
ACCOUNT_BILLING_FAX_NUMBER	integer	The Billing contact's fax number.	56487658
ACCOUNT_BILLING_FAX_EXTENTION	integer	The Billing contact's fax extension.	123
ACCOUNT_BILLING_FAX_COUNTRY_CODE	integer	The Billing contact's fax country code.	7
ACCOUNT_BILLING_FAX_AREA_CODE	integer	The Billing contact's fax area code.	929
ACCOUNT_BILLING_EMAIL	text	The Billing contact's email address.	bill@example.com
ACCOUNT_SALES_CURRENCY_CODE	text	The three-letter currency code of the account balance.	EUR
ACCOUNT_BALANCE	double	The account balance with two decimal places.	0.00
ACCOUNT_ATTRIBUTES	text	Custom attributes (and their values) assigned to the account.	JSON
ACCOUNT_ADMIN_PHONE_NUMBER	integer	The Administrator's telephone number.	56487658
ACCOUNT_ADMIN_PHONE_EXTENTION	integer	The Administrator's telephone extension.	123
ACCOUNT_ADMIN_PHONE_COUNTRY_CODE	integer	The Administrator's telephone country code.	7
ACCOUNT_ADMIN_PHONE_AREA_CODE	integer	The Administrator's telephone area code.	929
ACCOUNT_ADMIN_MNAME	text	The Administrator's middle name.	Garry
ACCOUNT_ADMIN_LNAME	text	The Administrator's last name.	Smith
ACCOUNT_ADMIN_FNAME	text	The Administrator's first name.	John
ACCOUNT_ADMIN_FAX_NUMBER	integer	The Administrator's fax number.	56487658
ACCOUNT_ADMIN_FAX_EXTENTION	integer	The Administrator's fax number extension.	123
ACCOUNT_ADMIN_FAX_COUNTRY_CODE	integer	The Administrator's fax country code.	7
ACCOUNT_ADMIN_FAX_AREA_CODE	integer	The Administrator's fax area code.	929
ACCOUNT_ADMIN_EMAIL	text	The Administrator's email address.	admin@example.com
ACCOUNT_ADDRESS2	text	The address line #2 of the account.
ACCOUNT_ADDRESS1	text	The address line #1 of the account.	Glenn ave, 15/18