payrollitem
The table storing payroll item details, used to categorize and manage the different types of compensation or deductions within payroll records.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | A unique internal identifier assigned to the record, used to reference and manage the record within the system. | |
| assetaccount | String | The account associated with the asset, used for tracking and managing the value of owned resources or properties. | |
| employeepaid | Boolean | Indicates whether the employee has been paid, typically used to track payroll or compensation status. | |
| expenseaccount | String | The account associated with expenses, used for tracking and categorizing business expenditures or operational costs. | |
| externalid | String | A unique identifier for the record as assigned by an external system, used for integration or synchronization purposes. | |
| inactive | Boolean | Indicates whether the record is inactive, often used to flag records that are no longer in use or should be excluded from active processes. | |
| itemtype | String | The type of item (such as product, service, or resource), used to classify the record based on its nature and function. | |
| liabilityaccount | String | The account associated with liabilities, used for tracking amounts owed by the company or organization. | |
| name | String | The name associated with the item, typically used for identification in reports, transactions, and user interfaces. | |
| subsidiary | String | The subsidiary or branch of the parent company associated with the record, useful for managing multi-entity financials and reporting. | |
| vendor | String | The vendor or agency associated with the record, often used to identify the supplier or service provider in the transaction. |