ODBC Driver for Reckon

Build 24.0.9062

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.

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