Statistical Accounts - Sage Intacct Developer

List Statistical Accounts
Get Statistical Account
Get Statistical Account by Name
Create Statistical Account
Update Statistical Account
Delete Statistical Account

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