Tableau Connector for NetSuite

Build 25.0.9434

intercompanyjournalentry

Stores journal entries for intercompany transactions, facilitating accurate financial reporting between subsidiaries.

Columns

Name Type References Description
accountingbook String The specific accounting book used for financial reporting in the intercompany journal entry.
approvalstatus String The current approval status of the intercompany journal entry, indicating whether it is pending, approved, or rejected.
approved Boolean Indicates whether the intercompany journal entry has been fully approved. If the value is 'true', it means it is approved; if not, the value is 'false'.
class String The classification category associated with the journal entry for reporting and tracking purposes.
createddate Datetime The timestamp indicating when the intercompany journal entry was initially created.
createdfrom String Reference to the transaction or document from which this journal entry was created.
credittotal Decimal The total amount of credits recorded in this intercompany journal entry.
currency String The currency in which the intercompany journal entry is denominated.
customform String The custom form used for this journal entry, if applicable.
debittotal Decimal The total amount of debits recorded in this intercompany journal entry.
department String The department associated with this journal entry, used for internal tracking and reporting.
entitynexus String The nexus (tax jurisdiction) associated with the entity involved in this transaction.
exchangerate Decimal The exchange rate applied to convert foreign currency values within the journal entry.
expenseallocjournalcount String The number of expense allocation journal entries linked to this transaction.
externalid String A unique identifier for the journal entry assigned by an external system.
isbasecurrency Boolean Indicates whether the journal entry is in the company's base currency. The value is 'true' if recorded in the base currency and 'false' if recorded in the foreign currency.
lastmodifieddate Datetime The timestamp indicating when the journal entry was last modified.
memo String A brief description or note explaining the purpose of the intercompany journal entry.
nextapprover String The user or role designated as the next approver in the journal entry approval workflow.
nexus String The tax jurisdiction relevant to this intercompany transaction.
parentexpensealloc String Reference to the parent expense allocation entry, if this journal entry is related to an expense allocation.
postingperiod String The accounting period in which this journal entry is posted for financial reporting.
reversaldate Date The date on which this journal entry is scheduled to be reversed, if applicable.
reversaldefer Boolean Indicates whether the reversal of this journal entry is deferred to a later period. If the value is 'true,' it is deferred, and if the value is 'false,' it is not deferred.
status String The current processing status of the intercompany journal entry, such as pending, posted, or voided.
subsidiary String The subsidiary entity that recorded this journal entry.
tosubsidiary String The subsidiary entity receiving the transaction in this intercompany journal entry.
trandate Date The transaction date of the intercompany journal entry.
tranid String A unique identifier assigned to this journal entry for tracking and reference purposes.

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