Power BI Connector for NetSuite

Build 25.0.9454

advintercompanyjournalentry

The AdvInterCompanyJournalEntry table manages advanced intercompany journal entries, facilitating financial adjustments between subsidiaries.

Columns

Name Type References Description
approved Boolean Indicates whether the intercompany journal entry has been approved. This value ensures that only authorized financial transactions are recorded in the system, adhering to approval workflows and compliance requirements.
createddate Datetime The date and time when the intercompany journal entry was created. This timestamp provides an audit trail for financial transactions and ensures accurate record-keeping.
createdfrom String The source transaction or record from which this intercompany journal entry was generated. This field helps track the origin of financial adjustments and supports auditability.
credittotal Decimal The total credit amount that is recorded in the journal entry. This field ensures proper balance between debits and credits in financial transactions.
currency String The currency in which the intercompany journal entry is recorded. This currency name ensures that transactions reflect the appropriate monetary denomination for international financial reporting.
customform String The custom form that is used for this journal entry. This field allows organizations to tailor the layout and fields for journal entry transactions based on specific business needs.
debittotal Decimal The total debit amount that is recorded in the journal entry. This field ensures that the financial entry maintains correct balance in the accounting system.
entitynexus String The tax jurisdiction or nexus associated with the entity initiating the journal entry. This field ensures compliance with regional tax regulations for intercompany transactions.
expenseallocjournalcount String The number of expense-allocation journal entries related to this transaction. This number helps track cost distributions across different entities or departments.
externalid String The unique identifier (Id) assigned to this journal entry by an external system. This Id facilitates data integration and synchronization with third-party financial applications.
isbasecurrency Boolean Indicates whether the transaction is recorded in the subsidiary’s base currency. This setting ensures accurate currency conversion and financial reporting for multinational entities.
iscustomapproval Boolean Indicates whether this journal entry follows a custom approval workflow. This setting ensures that organization-specific approval rules are enforced before the transaction is posted.
lastmodifieddate Datetime The date and time when the journal entry was last modified. This timestamp provides an audit trail and helps track changes to financial records.
memo String A free-text field used to enter a description or note about the intercompany journal entry. This field provides context for the transaction, making it easier to understand in financial reports.
nexus String The tax jurisdiction under which the journal entry is recorded. This information is critical for ensuring compliance with tax regulations across different regions.
parentexpensealloc String The reference to the primary expense allocation entry linked to this journal entry. This reference helps track hierarchical relationships between expense allocations.
postingperiod String The financial period in which the journal entry is posted. This field ensures that transactions are recorded in the correct reporting period for accurate financial statements.
reversaldate Date The date on which this journal entry is scheduled to be reversed. This date ensures that temporary or correcting entries are properly nullified at the designated time.
reversaldefer Boolean Indicates whether the reversal of this journal entry is deferred to a later period. This setting ensures that corrections are timed appropriately for financial reporting.
status String The current status of the journal entry, such as Pending Approval, Approved, or Posted. This status helps track the progress of the transaction in the accounting workflow.
subsidiary String The subsidiary responsible for this journal entry. This information ensures that financial data is properly attributed to the correct legal entity in a multi-subsidiary organization.
taxperiod String The tax reporting period in which this journal entry is recorded. This field ensures that financial transactions align with tax filing and reporting schedules.
tosubsidiaries String The subsidiaries that receive allocations or adjustments from this journal entry. This field ensures accurate financial consolidation across multiple entities.
trandate Date The transaction date of the journal entry. This date determines when the financial impact of the transaction is recognized in accounting records.
tranid String The system-generated Id for the journal entry. This Id provides a unique reference for tracking and retrieving financial transactions.
transactionnumber String The unique transaction number assigned to this journal entry. This transaction number ensures clear identification and organization of journal transactions within the accounting system.

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