PayrollTransactionsByPayee
Creates payroll transaction reports grouped by payee, offering insights into payment patterns and amounts.
Columns
| Name | Type | References | Description |
| Label | String | The label or name associated with a specific entry in the Payroll Transactions By Payee report, helping to identify the type of transaction. | |
| Date | Date | The date the payroll transaction occurred, providing a chronological reference for each entry. | |
| Name | String | The name of the payee involved in the transaction, such as an employee, vendor, or other entity. | |
| Num | String | A reference number associated with the transaction, useful for tracking and reconciling entries. | |
| Type | String | The type of payroll transaction, such as paycheck, adjustment, or expense. | |
| Memo | String | Additional details or notes associated with the payroll transaction, often used for internal documentation. | |
| Account | String | The name of the account to which the transaction is posted, such as payroll expenses or liabilities. | |
| Amount | Double | The monetary amount of the payroll transaction, reflecting the debit or credit recorded. | |
| RowType | String | The classification of the row data in the report, such as Text, Data, Subtotal, or Total, to indicate its context. |
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. Either value may be omitted for open-ended ranges (for example, 2024-12-25:) or specified using macros like TODAY, THISWEEK, LASTMONTH, NEXTYEAR. | |
| 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 for a more targeted 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, BILL, PAYCHECK, 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 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. |