Account Setup and Data Loading report fields

Multiple Account Setup and Data Loading report templates are supported in IBM® ESG Suite and similar fields are used across these templates.

The report templates include:

Account Setup and Data Load
Account Setup and Data Load - PM&C
Flat File Format

Table 1 highlights common fields across templates and provides descriptions. It lists the custom fields that are available in specific report templates.

Table 1. Report fields
Field	Field type	Character limit	Mandatory?	Notes
Organization Link	Integer		Yes	You can load data only for one organization at a time.
Organization	String		Yes	Both the organization name and link are validated for file loading.
Location	String	100	Yes, unless you are matching on the Location Ref field instead.	To identify an account for loading records, the account number is searched for in the corresponding location by matching against Location Name, and then by Location Reference. In the first case, if Location Name matches a location in Envizi ESG Suite, if the account exists within the location, the records will be loaded. Otherwise, a new account will be created within the location and the records will be loaded.
Location Ref	String	100	Yes, unless you are matching on the Location field instead.	To identify an account for loading records, the account number is searched for in the corresponding location matching by Location Name, and then by Location Reference. If Location Name does not match Envizi or is blank, it will then search for the account number within any locations matching by Location Reference. If a match of a location is found in Envizi ESG Suite, if the account exists within the location the records will be loaded, else a new account will be created within the location and the records will be loaded. If both Location Name and Location Reference fail to identify a pre-existing location in Envizi, no account will be created, and the record will not be loaded.
Account Style Link	Integer		Yes	Determines the account style used for data loading.
Account Style Caption	String		Yes	Used to validate the account style link ID provided.
Account Subtype	String - list			Only relevant for account styles that have one or more subtypes.
Account Number	String	100	Yes	If the account number is not found in the location, a new account is created with this value.
Account Reference	String	100		Used if you are creating the account for the first time.
Account Supplier	String	100		Used if you are creating the account for the first time.
Account Reader	String	100		Used if you are creating the account for the first time.
Record Start YYYY-MM-DD	Date YYYY-MM-DD		Yes	Must be in ISO standard date format or the row is skipped.
Record End YYYY-MM-DD	Date YYYY-MM-DD		Yes	Must be in ISO standard date format or the row is skipped.
Record Data Quality	String - list			Defaults to `Actual` if left blank. Only relevant if enabled for your organization.
Record Billing Type	String - list			Defaults to `Standard` if left blank. Only relevant if enabled for your organization.
Record Subtype	String - list			Only relevant for account styles that have one or more subtypes.
Record Entry Method	String - list			Defaults to `Overwrite` if left blank. The `Overwrite` option indicates that the new record should overwrite all unlocked records in the account with the same start and end date as the new record. The `Insert` option should only be used in scenarios where multiple entries are expected for the same time period such as with air travel records or fuel purchases. In this scenario, new records may be inserted alongside existing records with the same start and end date.
Record Reference	String	50		An optional reference field for the record.
Record Invoice Number	String	50		Only relevant if it is enabled for your organization.
Account Style Field Label	String			The label of the account style field. Note: Available only in the Flat File Format report template.
Account Style Field Value	Various			The value associated with the account style field label in the respective account style. Various formats are supported for field type, for example, string, decimal, or list. If it is a list, include the label text for the list. Note: Available only in the Flat File Format report template.
Other data capture fields specific to each account style	Various			The additional data capture fields are specific for each account style. For example, a basic electricity account style might have two other fields named kWh Consumption and Total Cost. Note: Available only in the Account Setup and Data Load report template.
Quantity	Decimal			The primary measure consumption field for the account style. Note: Available only in the Account Setup and Data Load report template.
Total Cost	Decimal			The total cost field for the account style. Total cost is assumed to be in local currency based on the Location’s Region. Note: Available only in the Account Setup and Data Load - PM&C report template.