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_CREDIT_LIMIT	double	The credit limit of the account, in the account currency. The source of the value depends on how the credit limit is configured for the account: If the account uses the credit limit from its credit terms, the field shows the credit limit of these credit terms. If no credit terms are assigned to the account, the field shows 0. If a credit limit is specified for the account itself, the field shows this credit limit.	1000.00
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