Power BI Connector for QuickBooks

Build 23.0.8839

PayrollTransactionDetail

Returns information of Payroll transaction detail report (shows the line-item detail that appears on each payroll transaction).

Columns

Name Type References Description
Date String The Date column of the PayrollTransactionDetail report.
Num String The Num column of the PayrollTransactionDetail report.
Type String The Type column of the PayrollTransactionDetail report.
Source_Name String The Source_Name column of the PayrollTransactionDetail report.
Payroll_Item String The Payroll_Item column of the PayrollTransactionDetail report.
Wage_Base Double The Wage_Base column of the PayrollTransactionDetail report.
Amount Double The Amount column of the PayrollTransactionDetail 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

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