ReportTime
Generates summary and detail reports related by time.
Input
| Name | Type | Description |
| Reporttype | String | The type of the report.
使用できる値は次のとおりです。TIMEBYITEM, TIMEBYJOBDETAIL, TIMEBYJOBSUMMARY, TIMEBYNAME デフォルト値はTIMEBYITEMです。 |
| Reportperiod | String | Report date range in the format fromdate:todate where 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です。 |
| 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. |
| 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 デフォルト値はNONEです。 |
| 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です。 |
| 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. |