ADO.NET Provider for Sage Intacct

Build 25.0.9434

CheckingAccount

Retrieves information about checking accounts, including bank details, account configuration, and associated financial data.

Columns

Name Type ReadOnly Description
Bankaccountid [KEY] String False

A unique identifier for the checking account.

Bankaccountno String False

The account number of the checking account.

Glaccountno String False

The general ledger account number linked to the checking account.

Bankname String False

The name of the bank associated with the checking account.

Routingno String False

The routing number of the bank.

Branchid String False

The identifier for the bank branch.

Bankaccounttype String False

The type of the checking account (e.g., savings, checking).

Phone String False

The contact phone number for the bank.

Checklayout_sigline2amount String False

The amount threshold for requiring a second signature on checks.

Checklayout_checkpaperformat String False

The format of the check paper used.

Checklayout_checkprintformat String False

The printing format for checks.

Checklayout_signatureimage1 String False

The first signature image for check printing.

Checklayout_signatureimage2 String False

The second signature image for check printing.

Checklayout_printlineitems Boolean False

Indicates whether line items are printed on checks.

Checklayout_displaylocationas String False

The display format for location details on checks.

Checklayout_bankacctalign String False

The alignment settings for bank account details on checks.

Checklayout_spacestoappend String False

Additional spacing to append to checks.

Checklayout_checknolength String False

The length of the check number field.

Checklayout_dfltcnyaddr Boolean False

Indicates whether the default currency address is used on checks.

Checklayout_voidtext String False

The text displayed when a check is voided.

Checklayout_usesig1belowamt String False

The threshold amount below which only the first signature is used.

Checklayout_usesig2belowamt String False

The threshold amount below which the second signature is required.

Checklayout_micrtranscode Boolean False

Indicates whether MICR encoding is used for transaction codes.

Checklayout_usdtext Boolean False

Indicates whether USD text is printed on checks.

Checklayout_onus Boolean False

Specifies if 'On-us' details are included in the check layout.

Checklayout_onus32 String False

The format for 'On-us' details in check layout 32.

Checklayout_usesecondsignaturechecks Boolean False

Indicates whether second signature checks are enabled.

Checklayout_printcnylogo Boolean False

Indicates whether a CNY logo is printed on checks.

Checklayout_company_logo String False

The logo of the company printed on checks.

Checklayout_usecnyaddress String False

Indicates whether the CNY address is used in the check layout.

Mailaddress_address1 String False

The primary address line for the mailing address.

Mailaddress_address2 String False

The secondary address line for the mailing address.

Mailaddress_city String False

The city for the mailing address.

Mailaddress_state String False

The state for the mailing address.

Mailaddress_zip String False

The ZIP code for the mailing address.

Mailaddress_country String False

The country for the mailing address.

Mailaddress_countrycode String False

The country code for the mailing address.

Checkinfocontact_contactname String False

The name of the contact for check information.

Checkinfocontact_companyname String False

The company name for check information contact.

Checkinfocontact_mailaddress_address1 String False

The primary address line for the check info contact's mailing address.

Checkinfocontact_mailaddress_address2 String False

The secondary address line for the check info contact's mailing address.

Checkinfocontact_mailaddress_city String False

The city for the check info contact's mailing address.

Checkinfocontact_mailaddress_state String False

The state for the check info contact's mailing address.

Checkinfocontact_mailaddress_zip String False

The ZIP code for the check info contact's mailing address.

Checkinfocontact_mailaddress_country String False

The country for the check info contact's mailing address.

Checkinfocontact_mailaddress_countrycode String False

The country code for the check info contact's mailing address.

Checkinfocontact_phone1 String False

The primary phone number for the check info contact.

Financialdata_apjournal String False

The accounts payable journal linked to the checking account.

Financialdata_arjournal String False

The accounts receivable journal linked to the checking account.

Servicechargeglaccount String False

The general ledger account for service charges.

Servicechargeaccountlabel String False

The label for the service charge account.

Interestearnedglaccount String False

The general ledger account for interest earned.

Interestearnedaccountlabel String False

The label for the interest earned account.

Departmentid String False

The department ID linked to the checking account.

Locationid String False

The location ID linked to the checking account.

Status String False

The current status of the checking account.

Lastreconciledbalance String False

The balance at the time of the last reconciliation.

Lastreconcileddate Datetime False

The date of the last reconciliation.

Nextcheck String False

The next check number to be used.

Sharecheckno Boolean False

Indicates whether check numbers are shared across accounts.

Cutoffdate Datetime False

The cutoff date for transactions in the account.

Financialdata_reconmode String False

The reconciliation mode for the checking account.

Currency String False

The currency used for the checking account.

Forwfpm Boolean False

Indicates whether forward payment management is enabled.

Achcompanyid String False

The ACH company ID linked to the checking account.

Pmchecktemplateid String False

The payment management check template ID for the account.

Whencreated Datetime False

The date and time when the checking account was created.

Whenmodified Datetime False

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

Createdby Int64 False

The ID of the user or process that created the account.

Modifiedby Int64 False

The ID of the user or process that last modified the account.

Recordno Int64 False

The record number of the checking account.

Achbankid String False

The ACH bank ID linked to the checking account.

Companyname String False

The name of the company associated with the account.

Companyidentification String False

The company identification number linked to the account.

Financialinstitution String False

The name of the financial institution managing the account.

Description String False

A description of the checking account.

Discretionarydata String False

Discretionary data associated with the account.

Recordtypecode String False

The record type code for the account.

Serviceclasscode String False

The service class code for the checking account.

Originatorstatuscode String False

The originator status code for ACH transactions.

Batchid String False

The batch ID linked to the checking account.

Tracenumberseq String False

The sequence for trace numbers linked to the account.

Docnumberseq String False

The sequence for document numbers linked to the account.

Usetracenumber String False

Indicates whether trace numbers are used for transactions.

Achenabled Boolean False

Indicates whether ACH is enabled for the checking account.

Userecommendedsetup Boolean False

Indicates whether the recommended setup is used for the account.

Printon String False

Specifies the print settings for the account.

Outsourcecheck String False

Indicates whether check printing is outsourced.

Fractionalroutingno String False

The fractional routing number for the bank.

Nameontheaccount String False

The name listed on the checking account.

Automate_check_print Boolean False

Indicates whether check printing is automated.

Automate_pymt_conf Boolean False

Indicates whether payment confirmations are automated.

Automate_ach_pymt_send Boolean False

Indicates whether ACH payment sending is automated.

Automate_ach_pymt_conf Boolean False

Indicates whether ACH payment confirmations are automated.

Amex_payve_accountid String False

The account ID for American Express Payve payments.

Amexchecknum String False

The check number for American Express Payve payments.

Abo_first_name String False

The first name of the account billing owner (ABO).

Abo_middle_name String False

The middle name of the account billing owner (ABO).

Abo_last_name String False

The last name of the account billing owner (ABO).

Abo_phone_number String False

The phone number of the account billing owner (ABO).

Abo_email_id String False

The email ID of the account billing owner (ABO).

Outsourceach String False

Indicates whether ACH transactions are outsourced.

Megaentitykey Int64 False

The key identifying the parent entity linked to the checking account.

Megaentityid String False

The ID of the parent entity linked to the checking account.

Megaentityname String False

The name of the parent entity linked to the checking account.

Record_url String False

A URL providing direct access to the checking account record.

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