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 Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
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 Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

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 Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

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