Power BI Connector for NetSuite

Build 25.0.9454

journalentry

Stores financial journal entries, tracking debits and credits for accounting purposes.

Columns

Name Type References Description
accountingbook String Accounting book associated with the journal entry.
approvalstatus String Current approval status of the journal entry.
approved Boolean Indicates whether the journal entry has been approved.
class String Classification category for reporting and tracking purposes.
createddate Datetime Timestamp indicating when the journal entry was created.
createdfrom String Reference to the transaction or record that originated this journal entry.
credittotal Decimal Total credit amount in the journal entry.
currency String Currency used in the journal entry.
customform String Custom form template applied to this journal entry.
debittotal Decimal Total debit amount in the journal entry.
department String Department associated with this journal entry.
entitynexus String Nexus entity related to the journal entry for tax purposes.
exchangerate Decimal Exchange rate applied for currency conversion in this journal entry.
expenseallocjournalcount String Number of expense allocation journal entries associated.
externalid String External identifier used for integrations or external systems.
isbasecurrency Boolean Indicates whether the journal entry is in the base currency of the company.
isreversal String Specifies whether the journal entry is a reversal entry.
lastmodifieddate Datetime Timestamp of the last modification made to this journal entry.
memo String Memo or note providing additional details about the journal entry.
nextapprover String Next person or role responsible for approving the journal entry.
nexus String Tax nexus related to the journal entry.
parentexpensealloc String Reference to the parent expense allocation record, if applicable.
postingperiod String Accounting period in which the journal entry is posted.
reversaldate Date Date on which the reversal of this journal entry is scheduled.
reversaldefer Boolean Indicates whether the reversal should be deferred.
status String Current processing status of the journal entry.
subsidiary String Subsidiary associated with this journal entry.
subsidiarytaxregnum String Tax registration number of the subsidiary.
taxpointdate Date Date used for tax reporting purposes.
taxpointdateoverride Boolean Indicates whether the tax point date was manually overridden.
tosubsidiary String Target subsidiary for intercompany transactions, if applicable.
trandate Date Transaction date of the journal entry.
tranid String Unique transaction ID for this journal entry.
void String Indicates whether the journal entry is voided.
voided String Specifies whether the journal entry has been fully voided.

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