One open AR/AP item per posted document — invoice, bill, credit or debit note, advance receipt or payment — created at posting time by DocumentJournalPostingService and reduced by SettlementAllocation rows. Direction (Receivable or Payable) and ControlGLAccountId place it in the right subledger; the source document is referenced polymorphically through SourceEntityName + SourceRecordId so a new document type needs no schema change. This is the table ageing, statements, balance confirmations, reminders, Rule 37 ITC reversal and the subledger-to-GL verification job all ride on: to answer "what does this party still owe", query OpenTransaction rather than summing document OpenAmount columns.
Fields
| Field | Label | Type | Required | What it does |
|---|
BranchId | Branch | Lookup → Branch | | |
BusinessUnitId | Business Unit | Lookup → BusinessUnit | | |
ControlGLAccountId | Control GL Account | Lookup → GLAccount | | The control (reconciliation) GL account this open item rolls up to — receivables, payables or a tax account. Ageing reports scope themselves by joining this account and filtering on its account type, which is how an AP ageing separates supplier payables from tax payables. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
Direction | Direction | Text | | Receivable or Payable — which subledger the open item belongs to. It is set from the posting purpose, and credit documents flip the sign rather than the direction: a customer credit note is a Receivable item with a negative sign, a purchase return a Payable one. |
DocumentDate | Document Date | Date | | |
DocumentNumber | Document Number | Text | | |
DueDate | Due Date | Date | | When the item falls due; the axis ageing buckets are built on. DocumentDate is when it was raised, and the two differ by the party's payment terms. |
GSTRegistrationId | GST Registration | Lookup → GSTRegistration | | |
Id | Id | Guid | Yes | |
JournalId | Journal | Lookup → Journal | | The journal whose posting created this open item, the link that lets the subledger be reconciled to the general ledger. |
Label | Label | Text | | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text, unique | Yes | |
OpenAmount | Open Amount | Currency | | What is still outstanding on this item. Maintained by SettlementAllocation rows — each allocation reduces it, and reversing an allocation adds the amount back and returns the status to Open. This is the authoritative outstanding figure for ageing and statements, in preference to the OpenAmount columns on the documents themselves. |
OriginalAmount | Original Amount | Currency | | The item's value when it was created at posting time. It never changes, so OriginalAmount minus OpenAmount is how much has been settled. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | |
PartyAccountId | Party Account | Lookup → Account | | The customer or supplier the item is owed to or by — the key for party ageing and statements. Distinct from PartnerAccountId, which carries the trading partner for partner-scoped reporting. |
RecordTypeId | Record Type | Guid, hidden | | |
SourceEntityName | Source Entity Name | Text | | Name of the entity that produced this open item ("Invoice", "Bill", "CreditNote", "DebitNote", "Payment", …). Paired with SourceRecordId it is a polymorphic reference, deliberately used instead of typed FKs so a new document type needs no schema change — which also means it must be filtered as a string, not joined. |
SourceRecordId | Source Record | Lookup → @sourceEntityName | | Id of the source document row, to be read together with SourceEntityName. Reversal of a posted document finds its open items by this pair and sets their status to Reversed. |
Status | Status | Text | | Open, PartiallySettled, Settled or Reversed. Reversed is set when the source document's posting is reversed, and reversing an allocation moves a Settled item back to Open — so exclude Reversed items rather than assuming Settled is terminal. |
UIProps | UI Props | Text | | |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
Actions
| Action | Label | Type | What it does |
|---|
BulkDelete | Delete | Delete | Delete the selected records. |
Clone | Clone | ServerAction (Clone) | Create a copy of this record |
Delete | Delete | Delete | Delete |
DeleteInList | Delete | Delete | Delete in a list page |
Edit | Edit | Edit | Edit |
EditInLine | Edit | EditInline | EditInLine |
EditListRow | Edit | Edit | EditListRow |
New | New | New | New |
