Statistical accounts are used for tracking non-financial data.


List Statistical Accounts

readByQuery

<readByQuery>
    <object>STATACCOUNT</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use STATACCOUNT
fields Required string Comma separated list of fields on the account to list. Use * to return all fields.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Set a custom page size between 1 and 1000 items (Default: 100)

Get Statistical Account

read

<read>
    <object>STATACCOUNT</object>
    <keys>1</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use STATACCOUNT
keys Required string The account RECORDNO to get
fields Required string Comma separated list of fields on the account to get. Use * to return all fields.

Get Statistical Account by Name

readByName

<readByName>
    <object>STATACCOUNT</object>
    <keys>9000</keys>
    <fields>*</fields>
</readByName>

Parameters

Name Required Type Description
object Required string Use STATACCOUNT
keys Required string The account ACCOUNTNO to get
fields Required string Comma separated list of fields on the budget to get. Use * to return all fields.

Create Statistical Account

create

<create>
    <STATACCOUNT>
        <ACCOUNTNO>9000</ACCOUNTNO>
        <TITLE>Headcount</TITLE>
    </STATACCOUNT>
</create>

Parameters

Name Required Type Description
STATACCOUNT Optional object The object to create

STATACCOUNT

Name Required Type Description
ACCOUNTNO Required string Statistical Account number
TITLE Required string Title
CATEGORY Optional string System Category
ACCOUNTTYPE Optional string Report type. Use forperiod for a For the period account otherwise use cumulative for a Cumulative balance account (Default: forperiod)
STATUS Optional string Statistical Account status. Use active for Active otherwise use inactive for Inactive (Default: active)
REQUIREDEPT Optional boolean Use true to make department required for this account, otherwise use false. (Default: false)
REQUIRELOC Optional boolean Use true to make location required for this account, otherwise use false. (Default: false)
REQUIREPROJECT Optional boolean Use true to make project required for this account, otherwise use false. (Default: false)
REQUIRECUSTOMER Optional boolean Use true to make customer required for this account, otherwise use false. (Default: false)
REQUIREVENDOR Optional boolean Use true to make vendor required for this account, otherwise use false. (Default: false)
REQUIREEMPLOYEE Optional boolean Use true to make employee required for this account, otherwise use false. (Default: false)
REQUIREITEM Optional boolean Use true to make item required for this account, otherwise use false. (Default: false)
REQUIRECLASS Optional boolean Use true to make class required for this account, otherwise use false. (Default: false)
REQUIRETASK Optional boolean Use true to make task required for this account, otherwise use false. (Default: false)
REQUIREGLDIM* Optional boolean Use true to make user defined dimension required for this account, otherwise use false. UDD object integration name usually appended to REQUIREGLDIM (Default: false)

Update Statistical Account

update

<update>
    <STATACCOUNT>
        <RECORDNO>141</RECORDNO>
        <TITLE>Employee Headcount</TITLE>
    </STATACCOUNT>
</update>

Parameters

Name Required Type Description
STATACCOUNT Optional object The object to update

STATACCOUNT

Name Required Type Description
RECORDNO Required integer Record number of account
TITLE Required string Title
CATEGORY Optional string System Category
ACCOUNTTYPE Optional string Report type. Use forperiod for a For the period account otherwise use cumulative for a Cumulative balance account (Default: forperiod)
STATUS Optional string Statistical Account status. Use active for Active otherwise use inactive for Inactive (Default: active)
REQUIREDEPT Optional boolean Use true to make department required for this account, otherwise use false. (Default: false)
REQUIRELOC Optional boolean Use true to make location required for this account, otherwise use false. (Default: false)
REQUIREPROJECT Optional boolean Use true to make project required for this account, otherwise use false. (Default: false)
REQUIRECUSTOMER Optional boolean Use true to make customer required for this account, otherwise use false. (Default: false)
REQUIREVENDOR Optional boolean Use true to make vendor required for this account, otherwise use false. (Default: false)
REQUIREEMPLOYEE Optional boolean Use true to make employee required for this account, otherwise use false. (Default: false)
REQUIREITEM Optional boolean Use true to make item required for this account, otherwise use false. (Default: false)
REQUIRECLASS Optional boolean Use true to make class required for this account, otherwise use false. (Default: false)
REQUIRETASK Optional boolean Use true to make task required for this account, otherwise use false. (Default: false)
REQUIREGLDIM* Optional boolean Use true to make user defined dimension required for this account, otherwise use false. UDD object integration name usually appended to REQUIREGLDIM (Default: false)

Delete Statistical Account

delete

<delete>
    <object>STATACCOUNT</object>
    <keys>112</keys>
</delete>

Parameters

Name Required Type Description
object Required string Use STATACCOUNT
keys Required string The account RECORDNO to delete

Provide feedback