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 |