TransactionAccountingLine
Records accounting line items for transactions, detailing debits and credits for bookkeeping.
Columns
| Name | Type | References | Description |
| account | Integer | Specifies the general ledger account associated with the transaction accounting line, ensuring accurate financial reporting. | |
| accountingbook [KEY] | Integer | Indicates the accounting book in which this transaction is recorded, supporting multi-book accounting compliance. | |
| amount | Decimal | Represents the total monetary value recorded for this transaction line, used for financial calculations and reporting. | |
| amountpaid | Decimal | Indicates the portion of the transaction that has been paid, ensuring accurate tracking of settled amounts. | |
| amountunpaid | Decimal | Specifies the remaining unpaid amount of the transaction, helping in outstanding balance tracking and collections. | |
| credit | Decimal | Records the credit amount applied to the transaction, ensuring accurate double-entry bookkeeping. | |
| debit | Decimal | Represents the debit amount recorded in the transaction, used in financial accounting to balance journal entries. | |
| exchangerate | Decimal | Stores the exchange rate used for currency conversion, ensuring correct valuation of foreign transactions. | |
| netamount | Decimal | Calculates the net amount of the transaction after applicable credits, debits, and adjustments. | |
| overheadparentitem | String | Identifies the parent item associated with material overhead costs, ensuring proper cost allocation in manufacturing. | |
| paymentamountunused | Decimal | Specifies the portion of the payment that remains unused, which can be applied to future transactions. | |
| paymentamountused | Decimal | Indicates the amount of payment that has been applied to the transaction, ensuring accurate financial reconciliation. | |
| posting | Boolean | Determines whether this accounting line has been posted to the general ledger. If the value is true, the entry is finalized. | |
| transaction [KEY] | Integer | Links the accounting line to the related transaction, enabling detailed financial tracking and auditing. | |
| transactionline [KEY] | Integer | Links the accounting impact line to parent transaction line. | |
| amountlinked | Decimal | Total amount (in local currency) linked to this line. | |
| lastmodifieddate | Datetime | Date that this accounting line was last updated. | |
| processedbyrevcommit | Boolean | Whether or not the accounting line should have recognition of revenue separated from billing or shipping. |