JDBC Driver for Reckon

Build 24.0.9062

ReportCustomSummary

Generates a custom summary report.

Input

Name Type Description
Reporttype String The type of the report.

使用できる値は次のとおりです。BALANCESHEETPREVYEARCOMP, BALANCESHEETSTANDARD, BALANCESHEETSUMMARY, CUSTOMERBALANCESUMMARY, EXPENSEBYVENDORSUMMARY, INCOMEBYCUSTOMERSUMMARY, INVENTORYSTOCKSTATUSBYITEM, INVENTORYSTOCKSTATUSBYVENDOR, INCOMETAXSUMMARY, INVENTORYVALUATIONSUMMARY, PHYSICALINVENTORYWORKSHEET, PROFITANDLOSSBYCLASS, PROFITANDLOSSBYJOB, PROFITANDLOSSPREVYEARCOMP, PROFITANDLOSSSTANDARD, PROFITANDLOSSYTDCOMP, PURCHASEBYITEMSUMMARY, PURCHASEBYVENDORSUMMARY, SALESBYCUSTOMERSUMMARY, SALESBYITEMSUMMARY, SALESBYREPSUMMARY, SALESTAXLIABILITY, SALESTAXREVENUESUMMARY, TRIALBALANCE, VENDORBALANCESUMMARY

デフォルト値はBALANCESHEETPREVYEARCOMPです。

Reportperiod String Report date range in the format fromdate:todate. Either value may be omitted for an open ended range (e.g., 2009-12-25:). Supported date format: yyyy-MM-dd.
Reportdaterangemacro String Use a predefined date range.

使用できる値は次のとおりです。ALL, TODAY, THISWEEK, THISWEEKTODATE, THISMONTH, THISMONTHTODATE, THISQUARTER, THISQUARTERTODATE, THISYEAR, THISYEARTODATE, YESTERDAY, LASTWEEK, LASTWEEKTODATE, LASTMONTH, LASTMONTHTODATE, LASTQUARTER, LASTQUARTERTODATE, LASTYEAR, LASTYEARTODATE, NEXTWEEK, NEXTFOURWEEKS, NEXTMONTH, NEXTQUARTER, NEXTYEAR

デフォルト値はALLです。

Accounttype String Allows the user to query for a specified account type.

使用できる値は次のとおりです。NONE, ACCOUNTSPAYABLE, ACCOUNTSRECEIVABLE, ALLOWEDFOR1099, APANDSALESTAX, APORCREDITCARD, ARANDAP, ASSET, BALANCESHEET, BANK, BANKANDARANDAPANDUF, BANKANDUF, COSTOFSALES, CREDITCARD, CURRENTASSET, CURRENTASSETANDEXPENSE, CURRENTLIABILITY, EQUITY, EQUITYANDINCOMEANDEXPENSE, EXPENSEANDOTHEREXPENSE, FIXEDASSET, INCOMEANDEXPENSE, INCOMEANDOTHERINCOME, LIABILITY, LIABILITYANDEQUITY, LONGTERMLIABILITY, NONPOSTING, ORDINARYEXPENSE, ORDINARYINCOME, ORDINARYINCOMEANDCOGS, ORDINARYINCOMEANDEXPENSE, OTHERASSET, OTHERCURRENTASSET, OTHERCURRENTLIABILITY, OTHEREXPENSE, OTHERINCOME, OTHERINCOMEOREXPENSE

デフォルト値はNONEです。

Accountlisttype String Allows the user to query for specific list elements.

使用できる値は次のとおりです。LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN

デフォルト値はFULLNAMEです。

Accountlists String The list elements to report on. For LISTIDLIST and FULLNAMELIST, use a comma-separated list.
Entitytype String Allows the user to query for a specified name type.

使用できる値は次のとおりです。NONE, CUSTOMER, EMPLOYEE, OTHERNAME, VENDOR

デフォルト値はNONEです。

Entitylisttype String Allows the user to query for specific list elements.

使用できる値は次のとおりです。LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN

デフォルト値はFULLNAMEです。

Entitylists String The list elements to report on. For LISTIDLIST and FULLNAMELIST, use a comma-separated list.
Itemtype String Allows the user to query for a specified item type.

使用できる値は次のとおりです。NONE, ALLEXCEPTFIXEDASSET, ASSEMBLY, DISCOUNT, FIXEDASSET, INVENTORY, INVENTORYANDASSEMBLY, NONINVENTORY, OTHERCHARGE, PAYMENT, SALES, SALESTAX, SERVICE

デフォルト値はNONEです。

Itemlisttype String Allows the user to query for specific list elements.

使用できる値は次のとおりです。LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN

デフォルト値はFULLNAMEです。

Itemlists String The list elements to report on. For LISTIDLIST and FULLNAMELIST, use a comma-separated list.
Classlisttype String Allows the user to query for a specified class.

使用できる値は次のとおりです。LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN

デフォルト値はFULLNAMEです。

Classlists String The list elements to report on. For LISTIDLIST and FULLNAMELIST, use a comma-separated list.
Transactiontypes String A list of the transaction types you want the report to cover. Available values include: ALL,ARREFUNDCREDITCARD,BILL,BILLPAYMENTCHECK,BILLPAYMENTCREDITCARD,BUILDASSEMBLY,CHARGE,CHECK,CREDITCARDCHARGE,CREDITCARDCREDIT,CREDITMEMO,DEPOSIT,ESTIMATE,INVENTORYADJUSTMENT,INVOICE,ITEMRECEIPT,JOURNALENTRY,LIABILITYADJUSTMENT,PAYCHECK,PAYROLLLIABILITYCHECK,PURCHASEORDER,RECEIVEPAYMENT,SALESORDER,SALESRECEIPT,SALESTAXPAYMENTCHECK,TRANSFER,VENDORCREDIT,YTDADJUSTMENT

デフォルト値はALLです。

Modifieddaterange String Modified date range in the format fromdate:todate. Either value may be omitted for an open ended range (e.g., 2009-12-25:). Supported date format: yyyy-MM-dd.
Modifieddaterangemacro String Use a predefined modified date range.

使用できる値は次のとおりです。ALL, TODAY, THISWEEK, THISWEEKTODATE, THISMONTH, THISMONTHTODATE, THISQUARTER, THISQUARTERTODATE, THISYEAR, THISYEARTODATE, YESTERDAY, LASTWEEK, LASTWEEKTODATE, LASTMONTH, LASTMONTHTODATE, LASTQUARTER, LASTQUARTERTODATE, LASTYEAR, LASTYEARTODATE, NEXTWEEK, NEXTFOURWEEKS, NEXTMONTH, NEXTQUARTER, NEXTYEAR

デフォルト値はALLです。

Detaillevel String The level of detail to include in the report.

使用できる値は次のとおりです。ALL, ALLEXCEPTSUMMARY, SUMMARYONLY

デフォルト値はALLです。

Summarizecolumnsby String Determines which data the report calculates and how the columns will be labeled across the top of the report.

使用できる値は次のとおりです。NONE, ACCOUNT, BALANCESHEET, CLASS, CUSTOMER, CUSTOMERTYPE, DAY, EMPLOYEE, FOURWEEK, HALFMONTH, INCOMESTATEMENT, ITEMDETAIL, ITEMTYPE, MONTH, PAYEE, PAYMENTMETHOD, PAYROLLITEMDETAIL, QUARTER, SALESREP, SALESTAXCODE, SHIPMETHOD, TERMS, TOTALONLY, TWOWEEK, VENDOR, VENDORTYPE, WEEK, YEAR

デフォルト値はACCOUNTです。

Summarizerowsby String Determines along with IncludeColumnList, in most cases, what data is calculated for this report and controls how the rows are organized and labeled.

使用できる値は次のとおりです。NONE, ACCOUNT, BALANCESHEET, CLASS, CUSTOMER, CUSTOMERTYPE, DAY, EMPLOYEE, FOURWEEK, HALFMONTH, INCOMESTATEMENT, ITEMDETAIL, ITEMTYPE, MONTH, PAYEE, PAYMENTMETHOD, PAYROLLITEMDETAIL, QUARTER, SALESREP, SALESTAXCODE, SHIPMETHOD, TAXLINE, TERMS, TOTALONLY, TWOWEEK, VENDOR, VENDORTYPE, WEEK, YEAR

デフォルト値はACCOUNTです。

Includesubcolumns String Determines whether to include any subcolumn information.

使用できる値は次のとおりです。TRUE, FALSE

デフォルト値はFALSEです。

Reportcalendar String Specifies the type of year that will be used for this report.

使用できる値は次のとおりです。NONE, CALENDARYEAR, FISCALYEAR, TAXYEAR

デフォルト値はNONEです。

Returnrows String Specifies whether you want the report to include only rows with active information, only rows with nonzero values, or all rows regardless of their content or active status.

使用できる値は次のとおりです。NONE, ACTIVEONLY, NONZERO, All

デフォルト値はNONEです。

Returncolumns String Specifies whether you want the report to include only columns with active information, only columns with nonzero values, or all columns regardless of their content or active status.

使用できる値は次のとおりです。NONE, ACTIVEONLY, NONZERO, All

デフォルト値はNONEです。

Postingstatus String Allows you to query for posting reports, nonposting reports, or reports that are either.

使用できる値は次のとおりです。EITHER, NONPOSTING, POSTING

デフォルト値はEITHERです。

Reportbasis String If reportbasis is Cash, the report bases income and expenses on the dates when money changed hands. If Accrual, the report bases income on the dates when customers were invoiced and bases expenses on the dates when bills were entered. If None, the report uses the default report basis, which is either the Reckon preference setting or the Reckon default for a given type of report. In a report response, the SDK returns None for reports that do not support a report basis. (The 1099 report, for example, has its own basis for generation.)

使用できる値は次のとおりです。ACCRUAL, CASH, NONE

デフォルト値は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