amortizationtemplate
The AmortizationTemplate table stores predefined amortization rules and templates used for expense recognition over time.
Columns
| Name | Type | References | Description |
| acctcontra | String | The contra account that is used in the amortization process. This field ensures that offsetting entries are correctly recorded, maintaining balance sheet accuracy in deferred revenue or expense recognition. | |
| acctdeferral | String | The deferral account where the initial expense or revenue is recorded before amortization. This field tracks deferred costs or revenues that will be systematically recognized over time. | |
| accttarget | String | The target account where the amortized amounts are recognized. This field ensures that financial transactions are properly categorized in the general ledger, aligning with revenue or expense recognition principles. | |
| amortizationperiod | Integer | The total number of periods over which amortization occurs. This field determines the duration of expense or revenue recognition, ensuring compliance with financial reporting standards. | |
| amortizationtype | String | The method that is used to amortize expenses or revenues over time. This method defines whether the amortization follows a straight-line, declining balance, or custom method to allocate amounts systematically. | |
| externalid | String | The unique identifier (Id) assigned to this amortization template by an external system. This Id facilitates data synchronization between NetSuite and third-party financial applications. | |
| initialamount | String | The original amount that is subject to amortization. This field represents the full financial obligation or deferred revenue that will be gradually recognized over the defined amortization period. | |
| isinactive | Boolean | Indicates whether the amortization template is inactive. This setting prevents the template from being used in future amortization schedules while preserving historical data for reference. | |
| name | String | The official name of the amortization template. This official name provides a meaningful reference for users when selecting templates for automated amortization schedules. | |
| periodoffset | Integer | The number of periods by which amortization is offset from the transaction date. This field controls the timing of amortization recognition to align with financial reporting cycles. | |
| recogintervalsrc | String | The source that is used to determine the recognition intervals. This field defines whether amortization is based on fixed periods, transaction settings, or external factors, ensuring flexible financial planning. | |
| recurrencetype | String | The recurrence pattern of amortization postings. This pattern specifies whether amortization is recorded monthly, quarterly, annually, or based on a custom schedule. | |
| residual | String | The final residual value after the amortization process 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, ensuring compliance with revenue recognition rules. | |
| totalamount | Decimal | The total amount that is allocated for amortization. This field represents the full financial value that will be systematically expensed or recognized over the defined periods. |