GenerateAccountListReport()

Generates an Account List Report based on the specified details.

Note:

All of the parameters for this stored procedure are optional query parameters. If you do not specify a value for a parameter, the connector uses the default value instead.

For complete information about the default and supported values for these parameters, see the "Query Parameters" section for the report resource that you are using the stored procedure for in the QuickBooks Online Accounting API Reference: https://developer.intuit.com/docs/api/accounting.

Parameters

Account_Status

SQL_VARCHAR(255)

The status of the account. The default value is Not_Deleted.

Account_Type

SQL_VARCHAR(255)

The account type from which to include transactions. By default, transactions from all account types are included.

Columns

SQL_VARCHAR(255)

The column types to include in the report.

Createdate_Macro

SQL_VARCHAR(255)

A predefined date range for account creation dates. Set this parameter if you want the report to only include data from accounts that were created within the specified standard date range. The default value is This Fiscal Year-to-date.

Moddate_Macro

SQL_VARCHAR(255)

A predefined date range for the dates when the accounts were last modified. Set this parameter if you want the report to only include data from accounts that were last modified within the specified standard date range. Otherwise, use Start_Moddate and End_Moddate to specify a custom date range. The default value is This Fiscal Year-to-date.

Sort_By

SQL_VARCHAR(255)

The column type on which to base sorting for the rows in the report. The default value is txn_type.

Sort_Order

SQL_VARCHAR(255)

The sort order for the rows in the report. By default, the rows are sorted in ascending order based on the column type specified in the sort_by parameter.

Start_Date

SQL_VARCHAR(255)

The start date to use for the report.

End_Date

SQL_VARCHAR(255)

The end date to use for the report.

Start_Moddate

SQL_VARCHAR(255)

The start date for filtering accounts based on when they were last modified. The report only includes data for accounts that were last modified at or after the specified date.

End_Moddate

SQL_VARCHAR(255)

The end date for filtering accounts based on when they were last modified. The report only includes data for accounts that were last modified at or before the specified date.

Returns

A table with a single row of data.

AccountListReport

SQL_LONGVARCHAR(2147483647)

The Account List Report.