PayrollReviewDetail
Returns information of Payroll detail review report (provides detailed information about how QuickBooks calculates tax amounts on employee paychecks and in year-to-date transactions).
Columns
| Name | Type | References | Description |
| Label | String | The Label column of the PayrollReviewDetail report. | |
| Date | Date | The Date column of the PayrollReviewDetail report. | |
| Entered_Last_Modified | String | The Entered_Last_Modified column of the PayrollReviewDetail report. | |
| Tax_Table_Version | String | The Tax_Table_Version column of the PayrollReviewDetail report. | |
| Income_Subject_To_Tax | Double | The Income_Subject_To_Tax column of the PayrollReviewDetail report. | |
| Wage_Base | Double | The Wage_Base column of the PayrollReviewDetail report. | |
| Payroll_Tax_Rate | Double | The Payroll_Tax_Rate column of the PayrollReviewDetail report. | |
| User_Edit_ | String | The User_Edit_ column of the PayrollReviewDetail report. | |
| Amount | Double | The Amount column of the PayrollReviewDetail report. | |
| Calculated_Amount | Double | The Calculated_Amount column of the PayrollReviewDetail report. | |
| Amount_Difference | Double | The Amount_Difference column of the PayrollReviewDetail report. | |
| RowType | String | The type of data in the row. For example, Text, Data, Subtotal, or Total. |
Pseudo-Columns
Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| 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:) or a macro. Supported date format: yyyy-MM-dd. Support Macro values: ALL,TODAY,THISWEEK,THISWEEKTODATE,THISMONTH,THISMONTHTODATE,THISQUARTER,THISQUARTERTODATE,THISYEAR,THISYEARTODATE,YESTERDAY,LASTWEEK,LASTWEEKTODATE,LASTMONTH,LASTMONTHTODATE,LASTQUARTER,LASTQUARTERTODATE,LASTYEAR,LASTYEARTODATE,NEXTWEEK,NEXTFOURWEEKS,NEXTMONTH,NEXTQUARTER,NEXTYEAR | |
| AccountType | String | The specific type of account to request in the report. values: 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 | |
| AccountList | String | A comma separated list of account names or IDs. Also specify a value for AccountListType if specifying a value for this input. | |
| AccountListType | String | Allows the user to query for specific list accounts. values: LISTID,FULLNAME,LISTIDWITHCHILDREN,FULLNAMEWITHCHILDREN | |
| EntityType | String | The specific type of entity to request in the report. values: NONE,CUSTOMER,EMPLOYEE,OTHERNAME,VENDOR | |
| EntityList | String | A comma separated list of entity names or IDs. Also specify a value for EntityListType if specifying a value for this input. | |
| EntityListType | String | Allows the user to query for specific list of entities. values: LISTID,FULLNAME,LISTIDWITHCHILDREN,FULLNAMEWITHCHILDREN | |
| ItemType | String | The specific type of item to request in the report. values: NONE,ALLEXCEPTFIXEDASSET,ASSEMBLY,DISCOUNT,FIXEDASSET,INVENTORY,INVENTORYANDASSEMBLY,NONINVENTORY,OTHERCHARGE,PAYMENT,SALES,SALESTAX,SERVICE | |
| ItemList | String | A comma separated list of item names or IDs. Also specify a value for ItemListType if specifying a value for this input. | |
| ItemListType | String | Allows the user to query for specific list of items. values: LISTID,FULLNAME,LISTIDWITHCHILDREN,FULLNAMEWITHCHILDREN | |
| ClassList | String | A comma separated list of class names or IDs. Also specify a value for ClassListType if specifying a value for this input. | |
| ClassListType | String | Allows the user to query for specific list of classes. values: LISTID,FULLNAME,LISTIDWITHCHILDREN,FULLNAMEWITHCHILDREN | |
| TransactionTypes | String | A comma separated list of the transaction types you want the report to cover. 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. | |
| ModifiedDateRange | String | Date modified range in the format fromdate:todate where either value may be omitted for an open-ended range (e.g., 2009-12-25:) or a macro. Supported date format: yyyy-MM-dd. Support Macro values: ALL,TODAY,THISWEEK,THISWEEKTODATE,THISMONTH,THISMONTHTODATE,THISQUARTER,THISQUARTERTODATE,THISYEAR,THISYEARTODATE,YESTERDAY,LASTWEEK,LASTWEEKTODATE,LASTMONTH,LASTMONTHTODATE,LASTQUARTER,LASTQUARTERTODATE,LASTYEAR,LASTYEARTODATE,NEXTWEEK,NEXTFOURWEEKS,NEXTMONTH,NEXTQUARTER,NEXTYEAR | |
| DetailLevel | String | The level of detail to include in the report. values: ALL, ALLEXCEPTSUMMARY, SUMMARYONLY | |
| PostingStatus | String | Allows you to query for posting reports, nonposting reports, or reports that are either one. values: EITHER,NONPOSTING,POSTING | |
| ReportAsOf | String | The report will return open balance information up to the reportopenbalanceasof date. values: REPORTENDDATE,TODAY | |
| SummarizeColumnsBy | String | Determines which data the report calculates and how the columns will be labeled across the top of the report. values: 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 | |
| IncludeColumns | String | A comma separated list of columns to include. Supported values include 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 | |
| IncludeAccounts | String | Indicates whether this report should include all accounts or just those that are currently in use. values: ALL,INUSE | |
| 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 reports row labels might be Checking, Savings, and so on. values: 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 |