paycheck
The table storing paycheck records, used for tracking employee payments, deductions, and pay periods.
Columns
| Name | Type | References | Description |
| account | String | The account associated with the transaction or record, used to categorize financial data (for example, accounts receivable, payable, or bank account). | |
| address | String | The physical address associated with the record, often used for billing, shipping, or contact purposes. | |
| balance | Decimal | The current balance of the account or transaction, representing the amount due, owed, or remaining. | |
| chkamount | Decimal | The amount of the check associated with the transaction, used in accounting to track payments made via check. | |
| class | String | The classification or grouping of the transaction, used to organize records by department, region, or other criteria. | |
| cleared | Boolean | Indicates whether the transaction has been cleared in the system, often referring to whether a payment has been processed or reconciled. | |
| cleareddate | Date | The date when the transaction was cleared, indicating when it was fully processed or reconciled in the system. | |
| createddate | Datetime | The date and time when the record was created, typically used for tracking the creation timeline. | |
| department | String | The department or business unit associated with the transaction or record, used for organizational and financial reporting. | |
| entity | String | The entity associated with the record (such as a customer, supplier, or partner), used for categorization and tracking. | |
| externalid | String | A unique identifier for the record as assigned by an external system, used for integration and synchronization purposes. | |
| lastmodifieddate | Datetime | The date and time when the record was last modified, used for auditing and tracking changes. | |
| memo | String | A brief note or description added to the record, often used for internal reference or clarifying details about the transaction. | |
| periodending | Date | The end date of the accounting period associated with the transaction or record, often used for financial reporting and closing periods. | |
| postingperiod | String | The accounting period in which the transaction is recorded, used for period-specific financial reporting. | |
| startdate | Date | The start date of the accounting period, contract, or transaction, marking the beginning of the relevant period. | |
| status | String | The current status of the record or transaction (such as 'open', 'closed', or 'pending'), indicating its progress or completion. | |
| statusref | String | A reference to the status code or status description, used for more detailed tracking of the record’s current state. | |
| taxperiod | String | The tax period associated with the transaction or record, typically used for tax reporting or compliance purposes. | |
| trandate | Date | The date of the transaction, indicating when the transaction or event occurred. | |
| tranid | String | A unique identifier for the transaction, used for tracking and referencing individual transactions. | |
| useramount | Decimal | The amount entered or associated with the transaction by the user, often used for custom amounts or adjustments. | |
| workplace | String | The workplace or location associated with the transaction or entity, used for organizational purposes or tracking regional data. |