periodendjournal
The table storing period-end journal entries, used for recording financial transactions at the close of a financial period.
Columns
| Name | Type | References | Description |
| accountingbook | String | The accounting book associated with the record, used to track financial data within a specific accounting framework or ledger. | |
| class | String | The classification or category assigned to the record, typically used for organizational purposes like department, project, or financial grouping. | |
| createddate | Datetime | The date and time when the record was created, used for tracking the origin and history of the transaction. | |
| credittotal | Decimal | The total credit amount associated with the transaction, representing the sum of credits applied or received. | |
| currency | String | The currency used for the transaction (such as USD, EUR, or GBP), specifying the denomination for the amounts involved. | |
| customform | String | The custom form used for the transaction, allowing for personalized fields or layouts specific to the business process. | |
| debittotal | Decimal | The total debit amount associated with the transaction, representing the sum of debits applied or owed. | |
| department | String | The department within the organization associated with the transaction, often used for financial reporting or cost allocation. | |
| externalid | String | A unique identifier for the record assigned by an external system, used for integration or synchronization across platforms. | |
| lastmodifieddate | Datetime | The date and time when the record was last modified, used for auditing and tracking changes to the record. | |
| location | String | The physical or virtual location associated with the transaction, often used for logistics, reporting, or geographical categorization. | |
| mainaccount | String | The primary account associated with the transaction, used for referencing the main financial record or ledger. | |
| memo | String | A brief note or description attached to the transaction, often used to provide additional context or information about the record. | |
| postingperiod | String | The accounting period during which the transaction is recorded, used for period-specific reporting and financial management. | |
| sourcesubsidiary | String | The subsidiary from which the transaction originates, used for multi-entity financial tracking or reporting. | |
| subsidiary | String | The subsidiary or branch of the parent organization associated with the transaction, used for managing transactions across multiple entities. | |
| trandate | Date | The date the transaction occurred, used to record when the transaction took place for accounting and reporting purposes. | |
| tranid | String | A unique identifier for the transaction, used for tracking and referencing specific transactions within the system. | |
| transactionnumber | String | A number assigned to the transaction for identification and tracking purposes, often used for referencing and reporting. |