amortizationschedule
The AmortizationSchedule table outlines the periodic allocation of expenses related to prepaid assets, ensuring accurate financial reporting.
Columns
| Name | Type | References | Description |
| accountingbook | String | The accounting book that is associated with the amortization schedule. This field ensures that amortized expenses or revenues are recorded within the correct financial ledger, supporting multi-book accounting and regulatory compliance. | |
| amortizationtype | String | The type of amortization method applied to the schedule. This type determines how expenses or revenues are systematically allocated over time, such as straight-line or declining balance amortization. | |
| enddate | Date | The final date of the amortization schedule. This date defines when the amortization process is expected to be fully completed, ensuring accurate financial reporting and compliance. | |
| externalid | String | The unique identifier (Id) that is assigned to this amortization schedule by an external system. This Id facilitates integration with third-party financial applications, ensuring consistency in data exchange and reporting. | |
| initialamount | String | The original amount subject to amortization before any allocations or adjustments. This field represents the starting balance used for calculating periodic expense or revenue recognition. | |
| isinactive | Boolean | Indicates whether the amortization schedule is inactive. This setting prevents the schedule from being used in future calculations while retaining historical data for auditing and compliance. | |
| job | String | The job or project that is associated with the amortization schedule. This field ensures that amortized costs or revenues are correctly linked to specific projects for accurate financial tracking. | |
| name | String | The official name of the amortization schedule. This official name provides a meaningful reference for users to identify and manage different amortization plans within the system. | |
| parentSched | String | The parent amortization schedule to which this schedule is linked. This schedule ensures hierarchical structuring of amortization plans, supporting multi-level cost or revenue recognition tracking. | |
| periodoffset | Integer | The number of periods by which amortization is offset from the transaction date. This information controls the timing of amortization recognition, ensuring alignment with financial reporting requirements. | |
| recogintervalsrc | String | The source of the recognition interval for the amortization schedule. This field determines whether amortization intervals are based on fixed periods, transaction settings, or external factors. | |
| recurrencetype | String | The frequency at which amortization entries are posted. This frequency defines whether the schedule follows monthly, quarterly, or annual recognition patterns, ensuring compliance with financial planning standards. | |
| remainingdeferredbalance | Decimal | The outstanding balance that is yet to be amortized. This field tracks deferred expenses or revenues that are scheduled for future recognition, ensuring accurate financial reporting. | |
| residual | String | The final residual value of the amortized amount after the schedule is completed. This value ensures proper handling of any remaining balance that is not fully amortized. | |
| revrecoffset | Integer | The offset period for revenue recognition in relation to the transaction date. This period determines how far amortization is deferred, supporting revenue recognition compliance. | |
| schedulenumber | String | The unique Id that is assigned to the amortization schedule within the system. This Id helps users track and manage amortization schedules efficiently. | |
| sourcetran | String | The originating transaction from which this amortization schedule was created. This field links the amortization process to its source document, ensuring traceability and financial auditability. | |
| startdate | Date | The starting date of the amortization schedule. This date determines when the amortization process begins and ensures accurate financial period alignment. | |
| status | String | The current status of the amortization schedule, such as Active, Completed, or Canceled. This status helps track the progress of amortization and prevents unintended modifications. | |
| totalamortized | Decimal | The total amount that has been amortized to date. This field provides insight into how much of the original amount has been recognized in financial statements. | |
| totalamount | Decimal | The total amount subject to amortization over the entire schedule. This field represents the full financial obligation or revenue recognition amount allocated over time. |