Tableau Connector for NetSuite

Build 25.0.9434

TransactionAccountingLine

Records accounting line items for transactions, detailing debits and credits for bookkeeping.

Columns

Name Type References Description
account String Specifies the general ledger account associated with the transaction accounting line, ensuring accurate financial reporting.
accountingbook String 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 String Links the accounting line to the related transaction, enabling detailed financial tracking and auditing.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434