ODBC Driver for Sage Intacct

Build 25.0.9434

SavingsAccount

Stores details for savings accounts, including bank configuration and account offsets, aiding financial transactions and reconciliation.

Columns

Name Type ReadOnly Description
Bankaccountid [KEY] String False

Unique identifier for the savings account.

Bankaccountno String False

Account number for the savings account.

Glaccountno String False

General ledger account number associated with the savings account.

Bankname String False

Name of the bank where the savings account is held.

Routingno String False

Routing number for the bank.

Branchid String False

Identifier for the bank branch.

Bankaccounttype String False

Type of the bank account (e.g., savings, checking).

Phone String False

Contact phone number for the bank or account-related inquiries.

Checklayout_sigline2amount String False

Threshold amount for requiring a second signature line on checks.

Checklayout_checkpaperformat String False

Format of the check paper used.

Checklayout_checkprintformat String False

Print format for the checks.

Checklayout_signatureimage1 String False

Image file for the first signature on checks.

Checklayout_signatureimage2 String False

Image file for the second signature on checks.

Checklayout_printlineitems Boolean False

Indicates whether line items are printed on checks.

Checklayout_displaylocationas String False

Location display format on checks.

Checklayout_bankacctalign String False

Alignment settings for bank account information on checks.

Checklayout_spacestoappend String False

Additional spacing to append to check layouts.

Checklayout_checknolength String False

Length of the check number field.

Checklayout_dfltcnyaddr Boolean False

Indicates whether the default currency address is used on checks.

Checklayout_voidtext String False

Text displayed for voided checks.

Checklayout_usesig1belowamt String False

Amount threshold for using the first signature below a specific value.

Checklayout_usesig2belowamt String False

Amount threshold for using the second signature below a specific value.

Checklayout_micrtranscode Boolean False

Indicates whether MICR transcode is enabled for checks.

Checklayout_usdtext Boolean False

Indicates whether checks include text representation of USD amounts.

Checklayout_onus Boolean False

Indicates whether 'On-Us' encoding is applied to checks.

Checklayout_onus32 String False

Configuration for 'On-Us' encoding on checks.

Mailaddress_address1 String False

Primary address line for mail correspondence.

Mailaddress_address2 String False

Secondary address line for mail correspondence.

Mailaddress_city String False

City for the mailing address.

Mailaddress_state String False

State for the mailing address.

Mailaddress_zip String False

ZIP code for the mailing address.

Mailaddress_country String False

Country for the mailing address.

Mailaddress_countrycode String False

Country code for the mailing address.

Checkinfocontact_contactname String False

Name of the contact for check-related inquiries.

Checkinfocontact_companyname String False

Company name associated with the contact for checks.

Checkinfocontact_mailaddress_address1 String False

Primary address line for the check contact.

Checkinfocontact_mailaddress_address2 String False

Secondary address line for the check contact.

Checkinfocontact_mailaddress_city String False

City for the check contact's mailing address.

Checkinfocontact_mailaddress_state String False

State for the check contact's mailing address.

Checkinfocontact_mailaddress_zip String False

ZIP code for the check contact's mailing address.

Checkinfocontact_mailaddress_country String False

Country for the check contact's mailing address.

Checkinfocontact_mailaddress_countrycode String False

Country code for the check contact's mailing address.

Checkinfocontact_phone1 String False

Phone number for the check contact.

Financialdata_apjournal String False

Accounts payable journal associated with the savings account.

Financialdata_arjournal String False

Accounts receivable journal associated with the savings account.

Servicechargeglaccount String False

General ledger account for service charges.

Servicechargeaccountlabel String False

Label for the service charge account.

Interestearnedglaccount String False

General ledger account for interest earned.

Interestearnedaccountlabel String False

Label for the interest earned account.

Departmentid String False

Department associated with the savings account.

Locationid String False

Location associated with the savings account.

Status String False

Current status of the savings account.

Lastreconciledbalance String False

Last reconciled balance for the savings account.

Lastreconcileddate Datetime False

Date of the last reconciliation for the savings account.

Nextcheck String False

Next check number to be issued.

Sharecheckno Boolean False

Indicates whether the check number is shared.

Cutoffdate Datetime False

Cutoff date for financial data associated with the savings account.

Financialdata_reconmode String False

Reconciliation mode for the savings account.

Currency String False

Currency used for the savings account.

Forwfpm Boolean False

Indicates whether financial processes are managed forward for the savings account.

Achcompanyid String False

Company ID used for ACH transactions associated with the savings account.

Pmchecktemplateid String False

Check template ID used for payment management.

Whencreated Datetime False

Timestamp when the savings account record was created.

Whenmodified Datetime False

Timestamp when the savings account record was last modified.

Createdby Int64 False

User ID of the person who created the savings account record.

Modifiedby Int64 False

User ID of the person who last modified the savings account record.

Recordno Int64 False

Unique record number for the savings account.

Outsourcecheck String False

Indicates whether check processing is outsourced.

Fractionalroutingno String False

Fractional routing number for the bank.

Nameontheaccount String False

Name of the account holder as listed on the account.

Megaentitykey Int64 False

Key for the mega-entity associated with the account.

Megaentityid String False

Identifier for the mega-entity associated with the account.

Megaentityname String False

Name of the mega-entity associated with the account.

Record_url String False

Deep-link URL for accessing the savings account record.

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