Account code

Account code which descriptive text is to be retrieved.

Company

Company code.

Basic field name

Field code of the field in the Windows client, Company Information, Basic Info tab.
Possible field codes:

• coNumber – Corporate Number;

• fullName – Full Company Name;

• street – Street;

• areaCode – ZIP Code;

• city – City;

• country – Country;

• telephone – Telephone;

• fax – Fax;

• email – Email Address;

• auditorGivenName – Auditor Given Name;

• auditorFamilyName – Auditor Family Name;

• auditFirm – Audit Firm;

• auditPhone – Auditor Telephone;

• auditFax – Auditor ;

• auditEmail – Auditor Email Address;

• status – Status;

• vatNumber – VAT Number;

• activity – Activity;

• inDate – Inc Date;

• comment – Comment.

Period

Period for which data is to be retrieved.

Company

Company code.

Rate Type

Following rate translation types are handled:

• Ope – opening;

• Ave – average;

• Clo – closing.

Period

Period for which data is to be retrieved.

Company

Company code.

Minority type

Minority type:

• DIR – direct;

• IND – indirect;

• TOT – total.

Legal group

Legal group. If left empty, the default value is assumed.

Type

Dimension whose description is to be retrieved:

• "company", "Company", "COMPANY" for company;

• "group" for group;

• dimension name for dimension, e.g. "Business Unit".
  Make sure to spell this exactly as defined in the database, including any spaces and upper/lower case).

Code of entity

Company, group or dimension member code, e.g. "CLOTHES".

Period

Period for which data is to be retrieved.

Currency

Currency code.

Rate Type

Following rate translation types are handled:

• Ope – opening;

• Ave – average;

• Clo – closing.

Period

Period for which data is to be retrieved.

Co

Company code from which data is to be retrieved.

Code

Account code from which data is to be retrieved.

Curr

Currency for which the data to be retrieved.

CurrTrans

Currency translation, e.g. Actual, Budget, LastYear.

AccType

Accounting type, e.g. Normal, IFRS or USGAAP.

AcctStd

Accounting standard (a summary of one or more accounting types).

Dim1, Dim2 etc

These are defined by the dimension name such as "Market" or "Business Unit" (exact names vary depending on the dimensions setup in each AARO installation), followed by ":", followed by value. Group, legal group, 'LegalType', 'CounterCo', counter values, 'FromCo', 'TransCurr' and 'TransAmount' can also be defined in these fields.
In the example above, the dimension, separator ":", and dimension values were entered directly into the cell.

ProformaType

Proforma type, e.g. Normal.

AdjLevel

Adjustment level, e.g. Company.

InvType

Investment type, e.g. Normal.

Period

Period for which data is to be retrieved.

Company

Company code from which data is to be retrieved.

Form

Text form in AARO from which data is to be retrieved.

Account

Account code.

Currency

Currency for the data to be retrieved.

Key Names

Dimension or technical name of 'Text Field' column set up in the form, e.g. "Product" or "StringValue1". Several dimensions or names of 'Text Field' columns can be entered separated by a comma, e.g. "Product,Customer".

Key Values

Dimension or 'Text Field' value. The value for each dimension or 'Text Field' should be entered separated by a comma, e.g. "BIKES,CUST_01" or "Sold old bread".

Period

Period for which data is to be retrieved.

Company

Company code from which data is to be retrieved.

Form

Text form in AARO from which data is to be retrieved.

Return field

Technical name of 'Text Field' column, e.g. 'StringValue1', which description will be returned in the formula result.

Key names

Dimension set up in the form, e.g. "Product". Several dimensions can be entered divided by comma, e.g. "Product,Customer".

Key values

Dimension value. Value for each dimension should be entered divided by comma, e.g. "BIKES,CUST_01".

Account

Account code.