ReportPayrollDetail
Generates payroll reports.
Input
| Name | Type | Description |
| Reporttype | String | The type of the report.
使用できる値は次のとおりです。EMPLOYEESTATETAXESDETAIL, PAYROLLITEMDETAIL, PAYROLLREVIEWDETAIL, PAYROLLTRANSACTIONDETAIL, PAYROLLTRANSACTIONSBYPAYEE デフォルト値はEMPLOYEESTATETAXESDETAILです。 |
| 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です。 |
| 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. |
| Modifieddaterange | String | Modified 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. |
| 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です。 |
| Postingstatus | String | Allows the user to query for posting reports, non-posting reports, or reports that are either one.
使用できる値は次のとおりです。EITHER, NONPOSTING, POSTING デフォルト値はEITHERです。 |
| 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. For example, if you set the value to Account, the report's row labels might be Checking, Savings, and so on.
使用できる値は次のとおりです。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 デフォルト値はNONEです。 |
| Includecolumn | String | A list of enum values showing which columns you want the report to return.
使用できる値は次のとおりです。ACCOUNT, AGING, AMOUNT, AMOUNTDIFFERENCE, AVERAGECOST, BILLEDDATE, BILLINGSTATUS, CALCULATEDAMOUNT, CLASS, CLEAREDSTATUS, COSTPRICE, CREDIT, CURRENCY, DATE, DEBIT, DELIVERYDATE, DUEDATE, ESTIMATEACTIVE, EXCHANGERATE, FOB, INCOMESUBJECTTOTAX, INVOICED, ITEM, ITEMDESC, LASTMODIFIEDBY, LATESTORPRIORSTATE, MEMO, MODIFIEDTIME, NAME, NAMEACCOUNTNUMBER, NAMEADDRESS, NAMECITY, NAMECONTACT, NAMEEMAIL, NAMEFAX, NAMEPHONE, NAMESTATE, NAMEZIP, OPENBALANCE, ORIGINALAMOUNT, PAIDAMOUNT, PAIDSTATUS, PAIDTHROUGHDATE, PAYMENTMETHOD, PAYROLLITEM, PONUMBER, PRINTSTATUS, PROGRESSAMOUNT, PROGRESSPERCENT, QUANTITY, QUANTITYAVAILABLE, QUANTITYONHAND, QUANTITYONSALESORDER, RECEIVEDQUANTITY, REFNUMBER, RUNNINGBALANCE, SALESREP, SALESTAXCODE, SHIPDATE, SHIPMETHOD, SOURCENAME, SPLITACCOUNT, SSNORTAXID, TAXLINE, TAXTABLEVERSION, TERMS, TXNID, TXNNUMBER, TXNTYPE, UNITPRICE, USEREDIT, VALUEONHAND, WAGEBASE, WAGEBASETIPS デフォルト値はACCOUNTです。 |
| Includeaccounts | String | Indicates whether this report should include all accounts or just those that are currently in use.
使用できる値は次のとおりです。ALL, INUSE デフォルト値はALLです。 |
| Reportasof | String | The report will return open balance information up to the reportopenbalanceasof date.
使用できる値は次のとおりです。REPORTENDDATE, TODAY デフォルト値はTODAYです。 |
| 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. |