ADO.NET Provider for Sage Intacct

Build 26.0.9655

CheckingAccount

Represents checking accounts used for financial transactions, including ACH payment settings, bank file configurations, reconciliation details, and banking cloud connection information.

Columns

Name Type ReadOnly Description
accountingBankingTimeZone String False

The time zone used for banking transactions on this checking account.

accountingDisableInterEntityTransfer Bool False

Indicates whether inter-entity transfers are disabled for this checking account.

achBankId String False

The bank Id used for ACH transactions on this checking account.

achBatchId String False

The batch Id used for ACH transactions on this checking account.

achCompanyDiscretionaryData String False

The discretionary data field included in ACH company batch headers for this checking account.

achCompanyEntryDescription String False

The entry description included in ACH company batch headers for this checking account.

achCompanyIdentification String False

The company identification number used in ACH transactions for this checking account.

achCompanyName String False

The company name used in ACH transactions for this checking account.

achEnableACH Bool False

Indicates whether ACH payments are enabled for this checking account.

achOriginatingFinancialInstitution String False

The name of the originating financial institution for ACH transactions on this checking account.

achOriginatorStatusCode String True

The originator status code used in ACH transactions for this checking account.

achPaymentNumberSequence String False

The payment number sequence used for ACH transactions on this checking account.

achRecordTypeCode String True

The record type code used in ACH file entries for this checking account.

achServiceClassCode String False

The service class code indicating the type of ACH entries for this checking account.

achTraceNumberSequence String False

The trace number sequence used for ACH transactions on this checking account.

achUseRecommendedSetup Bool False

Indicates whether the recommended ACH setup is applied to this checking account.

achUseTraceNumber String False

The setting that controls whether trace numbers are used in ACH transactions for this checking account.

auditCreatedBy String True

The user who created the checking account.

auditCreatedDateTime Datetime True

The date and time when the checking account was created.

auditModifiedBy String True

The user who last modified the checking account.

auditModifiedDateTime Datetime True

The date and time when the checking account was last modified.

bankAccountDetailsAccountHolderName String False

The name of the account holder on file for this checking account.

bankAccountDetailsAccountNumber String False

The account number for this checking account.

bankAccountDetailsBankName String False

The name of the bank holding this checking account.

bankAccountDetailsBranchId String False

The branch Id of the bank associated with this checking account.

bankAccountDetailsCurrency String False

The currency used for transactions on this checking account.

bankAccountDetailsPhoneNumber String False

The phone number associated with this checking account.

bankAccountDetailsRoutingNumber String False

The routing number of the bank associated with this checking account.

bankFileApcaNumber String False

The APCA number used in bank file exports for this checking account.

bankFileBankCode String False

The bank code used in bank file exports for this checking account.

bankFileBankFileFormat String False

The file format used when generating bank files for this checking account.

bankFileBranchTransitNumber String False

The branch transit number used in bank file exports for this checking account.

bankFileBsbNumber String False

The BSB number used in bank file exports for this checking account.

bankFileBusinessIdCode String False

The business identifier code used in bank file exports for this checking account.

bankFileClientCode String False

The client code used in bank file exports for this checking account.

bankFileCompanyEntryDescription String False

The company entry description included in bank file exports for this checking account.

bankFileCompanyName String False

The company name included in bank file exports for this checking account.

bankFileDebtorBankNumber String False

The debtor bank number used in bank file exports for this checking account.

bankFileEnableBankFile Bool False

Indicates whether bank file export is enabled for this checking account.

bankFileFileIdSequence String False

The file Id sequence used when generating bank files for this checking account.

bankFileImmediateDestinationId String False

The immediate destination Id included in bank file headers for this checking account.

bankFileImmediateDestinationName String False

The immediate destination name included in bank file headers for this checking account.

bankFileImmediateOriginId String False

The immediate origin Id included in bank file headers for this checking account.

bankFileImmediateOriginName String False

The immediate origin name included in bank file headers for this checking account.

bankFileMessageIdPrefix String False

The message Id prefix used in bank file exports for this checking account.

bankFileOriginatorId String False

The originator Id included in bank file exports for this checking account.

bankFilePaymentNumberSequence String False

The payment number sequence used in bank file exports for this checking account.

bankFileProcessingDataCenterCode String False

The processing data center code used in bank file exports for this checking account.

bankFileReturnAccountNumber String False

The return account number used in bank file exports for this checking account.

bankFileSeedValue String False

The seed value used to initialize sequences in bank file exports for this checking account.

bankFileServiceType String False

The service type used in bank file exports for this checking account.

bankFileSortCode String False

The sort code used in bank file exports for this checking account.

bankFileSunNumber String False

The SUN number used in bank file exports for this checking account.

bankFileUserReference String False

The user reference included in bank file exports for this checking account.

bankingCloudConnectionBankName String True

The name of the bank connected through the banking cloud connection for this checking account.

bankingCloudConnectionLastBankTxnDateTime Datetime True

The date and time of the last bank transaction retrieved through the banking cloud connection for this checking account.

bankingCloudConnectionLastRefreshedDateTime Datetime True

The date and time when the banking cloud connection for this checking account was last refreshed.

bankingCloudConnectionName String True

The name of the banking cloud connection associated with this checking account.

bankingCloudConnectionRefreshStatus String True

The refresh status of the banking cloud connection for this checking account.

bankingCloudConnectionStatus String True

The connection status of the banking cloud connection for this checking account.

bankingCloudConnectionSupportMultiAccountLinking Bool True

Indicates whether the banking cloud connection for this checking account supports multi-account linking.

department_Href String True

The URL of the department associated with this checking account.

department_Id String False

The Id of the department associated with this checking account.

department_Key String False

The system-assigned key of the department associated with this checking account.

entity_Href String True

The URL of the entity associated with this checking account.

entity_Id String True

The Id of the entity associated with this checking account.

entity_Key String True

The system-assigned key of the entity associated with this checking account.

entity_Name String True

The name of the entity associated with this checking account.

financialInstitution_Href String True

The URL of the financial institution associated with this checking account.

financialInstitution_Id String True

The Id of the financial institution associated with this checking account.

financialInstitution_Key String True

The system-assigned key of the financial institution associated with this checking account.

href String True

The URL of the checking account resource.

id String False

The unique identifier of the checking account.

key [KEY] String True

The system-assigned key that uniquely identifies the checking account record.

location_Href String True

The URL of the location associated with this checking account.

location_Id String False

The Id of the location associated with this checking account.

location_Key String False

The system-assigned key of the location associated with this checking account.

reconciliationCutOffDate Date True

The cut-off date used for reconciliation of this checking account.

reconciliationInProgressBalance Decimal True

The in-progress reconciliation balance for this checking account.

reconciliationInProgressDate Date True

The date of the in-progress reconciliation for this checking account.

reconciliationLastReconciledBalance Decimal True

The balance as of the last completed reconciliation for this checking account.

reconciliationLastReconciledDate Date True

The date of the last completed reconciliation for this checking account.

reconciliationUseMatchSequenceForAutoMatch Bool False

Indicates whether match sequence is used for automatic reconciliation matching on this checking account.

reconciliationUseMatchSequenceForManualMatch Bool False

Indicates whether match sequence is used for manual reconciliation matching on this checking account.

ruleSet_Href String True

The URL of the rule set associated with this checking account.

ruleSet_Id String False

The Id of the rule set associated with this checking account.

ruleSet_Key String False

The system-assigned key of the rule set associated with this checking account.

ruleSet_Name String True

The name of the rule set associated with this checking account.

status String False

The current status of the checking account, such as active or inactive.

ListAggregate_PaymentProviderBankAccounts String False

The list of payment provider bank accounts associated with this checking account.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655