PayrollTransactionDetail
Generates detailed payroll transaction reports, showing line-item details for all payroll transactions.
Columns
| Name | Type | References | Description |
| Date | String | The date of the payroll transaction, providing a chronological reference for each entry in the Payroll Transaction Detail report. | |
| Num | String | The reference number or unique identifier associated with the transaction, useful for tracking and reconciliation. | |
| Type | String | The type of payroll transaction, such as paycheck, adjustment, or expense, categorizing the nature of the entry. | |
| Source_Name | String | The name of the source associated with the transaction, such as the employee or vendor involved. | |
| Payroll_Item | String | The specific payroll item related to the transaction, for example, wages, bonuses, or deductions. | |
| Wage_Base | Double | The base wage amount for the payroll transaction, representing the gross pay before adjustments or deductions. | |
| Amount | Double | The monetary value of the payroll transaction, reflecting the debited or credited amount. | |
| RowType | String | The classification of the row in the report, such as Text, Data, Subtotal, or Total, providing context for its role in the report. |
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 | The date range for the report in the format fromdate:todate, where either value may be omitted for open-ended ranges (for example, 2024-12-25:) or specified using macros like TODAY, LASTWEEK, NEXTMONTH. | |
| AccountType | String | The type of account to include in the report. The allowed values are NONE, ACCOUNTSPAYABLE, ACCOUNTSRECEIVABLE, BANK, CREDITCARD, INCOME, EXPENSE, and more. | |
| AccountList | String | A comma-separated list of account names or IDs. Specify AccountListType to refine the query. | |
| AccountListType | String | Defines the format of the AccountList query. The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN. | |
| EntityType | String | The type of entity to include in the report. The allowed values are NONE, CUSTOMER, EMPLOYEE, VENDOR, OTHERNAME. | |
| EntityList | String | A comma-separated list of entity names or IDs to include in the report. Specify EntityListType to refine the query. | |
| EntityListType | String | Defines the format of the EntityList query. The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN. | |
| ItemType | String | The type of item to include in the report. The allowed values are NONE, INVENTORY, SERVICE, SALES, FIXEDASSET, and more. | |
| ItemList | String | A comma-separated list of item names or IDs to include in the report. Specify ItemListType to refine the query. | |
| ItemListType | String | Defines the format of the ItemList query. The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN. | |
| ClassList | String | A comma-separated list of class names or IDs to include in the report. Specify ClassListType to refine the query. | |
| ClassListType | String | Defines the format of the ClassList query. The allowed values are LISTID, FULLNAME, LISTIDWITHCHILDREN, FULLNAMEWITHCHILDREN. | |
| TransactionTypes | String | A comma-separated list of transaction types to include in the report. The allowed values are ALL, ARREFUNDCREDITCARD, BILL, BILLPAYMENTCHECK, INVOICE, SALESRECEIPT, and more. | |
| ModifiedDateRange | String | The date range for transactions based on modification date, in the format fromdate:todate. Macros like TODAY, LASTMONTH, and NEXTYEAR are supported. | |
| DetailLevel | String | Specifies the level of detail in the report. The allowed values are ALL, ALLEXCEPTSUMMARY, SUMMARYONLY. | |
| PostingStatus | String | Indicates whether to include posting, non-posting, or both types of transactions. The allowed values are POSTING, NONPOSTING, EITHER. | |
| ReportAsOf | String | Specifies a date for generating the report's open balance information. The allowed values are REPORTENDDATE, TODAY. | |
| SummarizeColumnsBy | String | Determines how report data is summarized and columns are labeled. The allowed values are NONE, ACCOUNT, CLASS, CUSTOMER, PAYEE, and more. | |
| IncludeColumns | String | A comma-separated list of columns to include in the report. Examples: ACCOUNT, DATE, AMOUNT, MEMO, PAYROLLITEM, REFNUMBER, SHIPMETHOD. | |
| IncludeAccounts | String | Indicates whether to include all accounts or only those currently in use. The allowed values are ALL, INUSE. | |
| SummarizeRowsBy | String | Determines how rows are organized and labeled in the report. The allowed values are NONE, ACCOUNT, CLASS, CUSTOMER, PAYEE, and more. |