Tableau Connector for NetSuite

Build 25.0.9434

automatedclearinghouse

The AutomatedClearingHouse table manages electronic funds transfer (EFT) transactions, facilitating ACH payments and settlements.

Columns

Name Type References Description
accountownername String The name of the individual or entity that owns the bank account that is associated with the Automated Clearing House (ACH) process in NetSuite. This field ensures proper identification of the account holder for transaction processing and compliance purposes.
accounttype String The classification of the bank account that is used in the ACH process in NetSuite. This field specifies whether the account is a checking, savings, or other type of financial account, ensuring appropriate handling of transactions.
bankaccountnumber String The bank account number that is associated with the ACH process in NetSuite. This field stores the account details necessary for electronic fund transfers while adhering to security and compliance regulations.
bankname String The name of the financial institution that is associated with the ACH process in NetSuite. This field identifies the bank facilitating the electronic transactions to ensure accurate processing and reconciliation.
customerconsent String The recorded authorization that is provided by the customer for ACH transactions in NetSuite. This field ensures compliance with financial regulations and confirms that electronic payments can be processed.
entity String The classification of the customer, vendor, or other business entity that is associated with the ACH process in NetSuite. This field ensures proper linkage of payment records to the relevant entity for transaction tracking and financial reporting.
externalid String The unique identifier (Id) that is assigned to the ACH record from an external system in NetSuite. This field supports integration with third-party financial platforms, ensuring seamless data synchronization and consistency.
id Integer The system-generated Id that is assigned to the ACH record in NetSuite. This field ensures uniqueness and traceability of ACH transactions for auditing and financial tracking.
instrumenttype String The classification of the financial instrument that is used in the ACH process in NetSuite. This field defines whether the payment method is a direct debit, credit transfer, or other form of electronic payment.
isdefault Boolean Indicates whether this ACH account is the primary payment method for the associated entity in NetSuite. This field ensures that default settings are correctly applied for seamless transaction processing.
isinactive Boolean Indicates whether this ACH account is inactive in NetSuite. This field ensures that deactivated accounts are not used for processing transactions, maintaining data integrity and security.
limit String The maximum transaction amount that is allowed for ACH payments associated with this record in NetSuite. This field enforces financial controls and regulatory compliance for payment processing.
mask String A masked representation of the bank account number that is associated with the ACH process in NetSuite. This field enhances security by displaying only partial account details to protect sensitive financial information.
memo String A descriptive note that is associated with the ACH transaction in NetSuite. This field provides additional context for payments, assisting in recordkeeping and financial reconciliation.
paymentmethod String The payment method that is associated with the ACH transaction in NetSuite. This field specifies whether the transaction is processed via ACH debit, credit, or another electronic payment format.
preserveonfile Boolean Indicates whether this ACH payment record should be retained for future transactions in NetSuite. This field ensures continuity in payment processing while adhering to data retention policies.
routingnumber String The routing number of the financial institution that is associated with the ACH process in NetSuite. This field ensures that transactions are correctly routed through the banking system for processing.
state String The current status of the ACH record in NetSuite. This field tracks whether the payment method is active, pending, or deactivated for transaction processing.
supportedoperations String The list of permitted operations for this ACH payment method in NetSuite. This field specifies whether the account supports debit, credit, refund, or other transaction types, ensuring proper payment handling.

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