EmployeeStateTaxesDetail
Generates a detailed report on employee state taxes, including tax types and deductions.
Columns
| Name | Type | References | Description |
| Label | String | Represents the label or category associated with the employee state taxes detail report. | |
| Source_Name | String | Specifies the source name or entity relevant to the tax details in the report. | |
| SSN_Tax_ID | String | The social security number or tax ID associated with the employee in the report. | |
| Date | Date | The transaction or reporting date associated with the state taxes detail entry. | |
| Payroll_Item | String | Identifies the payroll item associated with the specific tax calculation. | |
| Income_Subject_To_Tax | Double | Indicates the amount of income subject to state taxation for the employee. | |
| Wage_Base | Double | The wage base used for calculating state taxes for the employee. | |
| Amount | Double | Specifies the tax amount calculated or reported for the entry. | |
| RowType | String | Denotes the type of data presented in the row, such as 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 | Defines the reporting period as a date range in the format fromdate:todate. You can omit one value for an open-ended range (for example, 2025-12-25:). Supported format: yyyy-MM-dd. Supported macros are 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 | Specifies the account type to filter the report. The allowed values are 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 | Allows specifying a comma-separated list of account names or IDs for targeted reporting. Combine with AccountListType for precise control. | |
| AccountListType | String | Defines how to interpret AccountList. The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, or FULLNAMEWITHCHILDREN. | |
| EntityType | String | Filters report data by entity type. The allowed values are NONE, CUSTOMER, EMPLOYEE, OTHERNAME, VENDOR. | |
| EntityList | String | Specifies a comma-separated list of entity names or IDs to include in the report. Combine with EntityListType for specificity. | |
| EntityListType | String | Determines how EntityList is evaluated. The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN. | |
| ItemType | String | Filters the report by item type. The allowed values are NONE, ALLEXCEPTFIXEDASSET, ASSEMBLY, DISCOUNT, FIXEDASSET, INVENTORY, INVENTORYANDASSEMBLY, NONINVENTORY, OTHERCHARGE, PAYMENT, SALES, SALESTAX, SERVICE. | |
| ItemList | String | Defines a comma-separated list of item names or IDs for filtering the report. | |
| ItemListType | String | Specifies how the ItemList is processed. The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN. | |
| ClassList | String | Includes a comma-separated list of class names or IDs for filtering. Combine with ClassListType for precision. | |
| ClassListType | String | Determines the interpretation of ClassList. The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN. | |
| TransactionTypes | String | Defines a comma-separated list of transaction types to include in the report. The allowed values are 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 | Specifies a date range for filtering modified entries, in the format fromdate:todate. You can omit one value for an open-ended range (for example, 2025-12-25:). Supported format: yyyy-MM-dd. Supported macros are 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 | Sets the level of detail in the report. The allowed values are ALL, ALLEXCEPTSUMMARY, SUMMARYONLY. | |
| PostingStatus | String | Filters data based on posting status. The allowed values are POSTING, NONPOSTING, EITHER. | |
| ReportAsOf | String | Defines the report balance cutoff date. The allowed values are REPORTENDDATE, TODAY. | |
| SummarizeColumnsBy | String | Specifies how to label columns in the report. The allowed values are 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. The allowed values are 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 to include all accounts or only those currently in use. The allowed values are ALL, INUSE. | |
| SummarizeRowsBy | String | Determines what data is calculated for the report and controls how rows are organized and labeled. Usually used with IncludeColumnList. For example, if you set the value to ACCOUNT, the reports row labels might be Checking, Savings, and so on. The allowed values are 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. |