paycheckjournal
The table storing journal entries related to paychecks, used for accounting and reconciliation of payroll transactions.
Columns
| Name | Type | References | Description |
| account | String | The account associated with the record, typically used to classify financial transactions such as accounts payable, accounts receivable, or bank accounts. | |
| class | String | The classification or grouping of the transaction or record, often used for organizational purposes like categorizing by department, project, or business unit. | |
| createddate | Datetime | The date and time when the record was created in the system, useful for tracking the origin of transactions or entries. | |
| currency | String | The type of currency used in the transaction or record (such as USD, EUR, or GBP), indicating the financial denomination for the values. | |
| customform | String | The custom form associated with the record, allowing for personalized fields and layouts for specific transaction types or user requirements. | |
| department | String | The department within the organization associated with the transaction or record, used for internal reporting and financial categorization. | |
| employee | String | The employee associated with the record, often used to track transactions or assignments made by specific staff members. | |
| exchangerate | Double | The exchange rate applied to the transaction when dealing with foreign currencies, used to convert amounts between different currencies. | |
| externalid | String | A unique identifier assigned to the record by an external system, used for synchronization and integration purposes across different platforms. | |
| lastmodifieddate | Datetime | The date and time when the record was last modified, often used for auditing and tracking updates or changes made to the record. | |
| location | String | The physical or virtual location associated with the record, often used to track transactions or entities by regional or geographical factors. | |
| postingperiod | String | The accounting period in which the record or transaction is posted, used for managing and reporting financial data in specific time frames. | |
| subsidiary | String | The subsidiary or branch of the parent organization associated with the record, helping to manage multi-entity financials and reporting. | |
| trandate | Date | The date on which the transaction occurred, used to track the timing and relevance of financial activities in relation to other events. |