AnnualRatePercent | Annual Rate % p.a. | Percent | | The policy's rate converted to per annum: a 2% per month policy shows 24 here. |
BranchId | Branch | Lookup → Branch | | Branch of the overdue item, copied so the posted entries keep it. |
BusinessUnitId | Business Unit | Lookup → BusinessUnit | | Business unit of the overdue item, copied so the posted entries keep it. |
CalculationNote | Calculation Note | LongMultiLineText | | The calculation in words (principal, annual rate, days and denominator, method and day count, and the result), written at compute time. It also becomes the narration of the posted debit note or journal. Use it to check a charge by hand. |
CappedAmount | Capped Amount | Currency | | Filled only when the policy's Maximum Charge % of Principal cut this charge down. Empty means the cap did not apply. |
ChargedDays | Charged Days | Number | | Days billed in this window, counting both ends. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
CumulativeInterestAmount | Cumulative Interest | Currency | | Total interest earned on the item from its first chargeable day to Period To. On the item's latest charge it equals the sum of Interest Amount over all of the item's charges except cancelled ones. |
DayCount | Day Count | PickList | | The day-count convention copied from the policy at compute time: Actual/365, Actual/360, Actual/366, Actual/Actual or 30E/360. Values: Actual/365, Actual/360, Actual/366, Actual/Actual, 30E/360. |
DayCountDenominator | Day Count Denominator | Number | | The days-in-year figure the calculation divided by, for example 365 or 360. |
DebitNoteId | Debit Note | Lookup → DebitNote | | The customer debit note that posting a receivable charge raised: created already approved, posted at once, dated on the run's As Of Date and linked to the original invoice when that invoice still exists. Its posting creates the journal and the receivable open item. |
Direction | Direction | PickList | | Receivable (interest a customer owes you) or Payable (interest on your own overdue supplier items), copied from the open item. Values: Receivable, Payable. |
DocumentNumber | Document Number | Text | | Number of the overdue document, copied from the open item so the charge reads on its own. |
DueDate | Due Date | Date | | Due date of the overdue item, or its document date when it has no due date. Interest starts the day after this date plus the policy's grace days. |
GSTRegistrationId | GST Registration | Lookup → GSTRegistration | | GST registration of the overdue item, copied to the debit note or journal. |
Id | Id | Guid, hidden | Yes | |
InterestAmount | Interest Amount | Currency | | Interest billed by this window, before tax. The system works out the item's total interest since its first chargeable day and bills the part not already taken by earlier Draft, Posted or Waived charges. Posting uses this stored amount. |
InterestOpenTransactionId | Interest Open Item | Lookup → OpenTransaction | | The supplier open item a posted payable charge raised, due on the run's As Of Date. Empty for receivable charges, whose open item belongs to the debit note. |
InterestPolicyId | Interest Policy | Lookup → InterestPolicy | | The interest policy that governed this item when the charge was computed: the most specific active, in-date policy for the item's party and company. Posting takes the interest and tax accounts from it. |
InterestRunId | Interest Run | Lookup → InterestRun | | The run whose Compute Interest created this charge. Posting, cancelling and recomputing all act on a run's charges, never on a charge alone. |
JournalId | Journal | Lookup → Journal | | The journal a posted payable charge wrote directly (interest expense debited, the payable account credited). Empty for receivable charges, whose journal belongs to the debit note. |
Label | Label | Text | | Readable title of the form 'Interest on <document number> (<from>..<to>)'. It is copied to the debit note's label when the charge posts, which is the easiest way to find the note. |
Method | Method | PickList | | Simple or Compound, copied from the policy at compute time. Values: Simple, Compound. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | System-built identifier of the form INT-<document number>-<short item key>-<window end yyyyMMdd>, so two items with the same document number never share a name. |
OpenTransactionId | Open Item | Lookup → OpenTransaction | | The overdue open item (usually a posted invoice) that the interest is charged on. Not the same as Interest Open Item, which is the item a posted payable charge raised. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Company | Lookup → Account | | Company of the overdue item. Posting looks for the company's interest income and tax accounts when the policy names none. |
PartyAccountId | Party | Lookup → Account | | The customer or supplier the overdue item belongs to, and who the debit note or open item is raised against. |
PeriodFrom | Period From | Date | | First day charged in this window: the item's first chargeable day (due date plus grace days plus one), or the day after the end of the item's previous Draft, Posted or Waived charge. |
PeriodTo | Period To | Date | | Last day charged, inclusive. Usually the run's As Of Date; earlier when the item was fully paid before it, because interest stops the day before the day it is cleared. The next run for the item starts the following day. |
PrincipalAmount | Principal Amount | Currency | | The amount the rate was applied to. On the Outstanding Balance basis it is the time-weighted average balance over the window (Weighted Principal-Days divided by the days), not the balance on any single day. |
RecordTypeId | Record Type | Guid, hidden | | |
ReviewReason | Review Reason | LongMultiLineText | | Explains why review is needed, naming how the interest was split across the invoice's rates. |
ReviewRequired | Review Required | Boolean | | Ticked when GST on the interest was split across an invoice that mixes taxable and exempt lines, so a person should confirm the split before posting. It does not stop posting. |
SourceEntityName | Source Entity Name | Text | | The kind of document behind the charged open item, for example Invoice. Only an invoice-sourced charge links its debit note to the original invoice. |
SourceRecordId | Source Record | Guid | | Internal identifier of the document behind the charged open item. |
Status | Status | PickList | | Draft (computed, waiting to post), Posted (in the ledger), Waived (forgiven; its days stay used and are never charged again) or Cancelled (its run was cancelled; its days are released for a later run). Set only by the actions. Recomputing a run removes its Draft charges and builds new ones. Reversed is never set by the system. Values: Draft, Posted, Waived, Cancelled, Reversed. |
SubscriptionKey | Subscription Key | Guid, hidden | Yes | |
TaxAmount | Tax Amount | Currency | | GST on the interest, apportioned from the original invoice's recorded tax. Empty when GST does not apply. Posting refuses the charge if the invoice's tax has changed since compute. |
TaxRatePercent | Tax Rate % | Percent | | Blended GST rate on the interest, for information only. It is empty when the policy does not apply GST. The rate and HSN/SAC of each part are on the debit note's lines, taken from the original invoice's recorded tax. |
TotalAmount | Total Amount | Currency | | Interest plus tax: what the party owes for this window, and the amount of the debit note (or payable open item) raised when the charge posts. |
TotalOverdueDays | Total Overdue Days | Number | | Days the item was past its due date on the run's As Of Date, for information only. It includes grace days and days already billed by earlier charges, so it is usually larger than Charged Days. |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
WaiveReason | Waive Reason | LongMultiLineText | | Filled with 'Waived' when Waive Charge is used. The button asks for no reason, so edit this field afterwards to record why. |
WeightedPrincipalDays | Weighted Principal-Days | Decimal | | Sum of balance times days over the window. Each part-payment lowers the balance from the day it was allocated, so this shows exactly how payments reduced the interest. |
