JDBC Driver for Reckon

Build 24.0.9062

ReportBudgetSummary

Generates budget reports.

Input

Name Type Description
Reporttype String The type of the report.

使用できる値は次のとおりです。BALANCESHEETBUDGETOVERVIEW, BALANCESHEETBUDGETVSACTUAL, PROFITANDLOSSBUDGETOVERVIEW, PROFITANDLOSSBUDGETPERFORMANCE, PROFITANDLOSSBUDGETVSACTUAL

デフォルト値はBALANCESHEETBUDGETOVERVIEWです。

Fiscalyear String The fiscal year of the budget to be queried. For example, 2014.
Budgetcriterion String Specifies what this budget covers.

使用できる値は次のとおりです。NONE, ACCOUNTS, ACCOUNTSANDCLASSES, ACCOUNTSANDCUSTOMERS

デフォルト値はNONEです。

Summarizebudgetcolumnsby String The data the report calculates and how the columns will be labeled across the top of the report.

使用できる値は次のとおりです。NONE, CLASS, CUSTOMER, DATE

デフォルト値はNONEです。

Summarizebudgetrowsby String How rows are to be labeled in the report. For example, if you set the value to Account, the row labels of the report might be Checking, Savings, and so on.

使用できる値は次のとおりです。NONE, CLASS, CUSTOMER, ACCOUNT

デフォルト値はNONEです。

Delimiter String Set the delimiter character for the fields

デフォルト値は;です。

Result Set Columns

Name Type Description
Rowtype String The type of row being output. For example, TitleRow, TextRow, DataRow, SubtotalRow, or TotalRow.
Column_value String The data in this row in a semicolon separated list of the report.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062