JDBC Driver for Sage Intacct

Build 22.0.8462

SavingsAccount

Retrieves SavingsAccount report data.

Columns

Name Type ReadOnly Description
Bankaccountid [KEY] String False

The Bankaccountid field of the SavingsAccount object.

Bankaccountno String False

The Bankaccountno field of the SavingsAccount object.

Glaccountno String False

The Glaccountno field of the SavingsAccount object.

Bankname String False

The Bankname field of the SavingsAccount object.

Routingno String False

The Routingno field of the SavingsAccount object.

Branchid String False

The Branchid field of the SavingsAccount object.

Bankaccounttype String False

The Bankaccounttype field of the SavingsAccount object.

Phone String False

The Phone field of the SavingsAccount object.

Checklayout_sigline2amount String False

The Checklayout_sigline2amount field of the SavingsAccount object.

Checklayout_checkpaperformat String False

The Checklayout_checkpaperformat field of the SavingsAccount object.

Checklayout_checkprintformat String False

The Checklayout_checkprintformat field of the SavingsAccount object.

Checklayout_signatureimage1 String False

The Checklayout_signatureimage1 field of the SavingsAccount object.

Checklayout_signatureimage2 String False

The Checklayout_signatureimage2 field of the SavingsAccount object.

Checklayout_printlineitems Boolean False

The Checklayout_printlineitems field of the SavingsAccount object.

Checklayout_displaylocationas String False

The Checklayout_displaylocationas field of the SavingsAccount object.

Checklayout_bankacctalign String False

The Checklayout_bankacctalign field of the SavingsAccount object.

Checklayout_spacestoappend String False

The Checklayout_spacestoappend field of the SavingsAccount object.

Checklayout_checknolength String False

The Checklayout_checknolength field of the SavingsAccount object.

Checklayout_dfltcnyaddr Boolean False

The Checklayout_dfltcnyaddr field of the SavingsAccount object.

Checklayout_voidtext String False

The Checklayout_voidtext field of the SavingsAccount object.

Checklayout_usesig1belowamt String False

The Checklayout_usesig1belowamt field of the SavingsAccount object.

Checklayout_usesig2belowamt String False

The Checklayout_usesig2belowamt field of the SavingsAccount object.

Checklayout_micrtranscode Boolean False

The Checklayout_micrtranscode field of the SavingsAccount object.

Checklayout_usdtext Boolean False

The Checklayout_usdtext field of the SavingsAccount object.

Checklayout_onus Boolean False

The Checklayout_onus field of the SavingsAccount object.

Checklayout_onus32 String False

The Checklayout_onus32 field of the SavingsAccount object.

Mailaddress_address1 String False

The Mailaddress_address1 field of the SavingsAccount object.

Mailaddress_address2 String False

The Mailaddress_address2 field of the SavingsAccount object.

Mailaddress_city String False

The Mailaddress_city field of the SavingsAccount object.

Mailaddress_state String False

The Mailaddress_state field of the SavingsAccount object.

Mailaddress_zip String False

The Mailaddress_zip field of the SavingsAccount object.

Mailaddress_country String False

The Mailaddress_country field of the SavingsAccount object.

Mailaddress_countrycode String False

The Mailaddress_countrycode field of the SavingsAccount object.

Checkinfocontact_contactname String False

The Checkinfocontact_contactname field of the SavingsAccount object.

Checkinfocontact_companyname String False

The Checkinfocontact_companyname field of the SavingsAccount object.

Checkinfocontact_mailaddress_address1 String False

The Checkinfocontact_mailaddress_address1 field of the SavingsAccount object.

Checkinfocontact_mailaddress_address2 String False

The Checkinfocontact_mailaddress_address2 field of the SavingsAccount object.

Checkinfocontact_mailaddress_city String False

The Checkinfocontact_mailaddress_city field of the SavingsAccount object.

Checkinfocontact_mailaddress_state String False

The Checkinfocontact_mailaddress_state field of the SavingsAccount object.

Checkinfocontact_mailaddress_zip String False

The Checkinfocontact_mailaddress_zip field of the SavingsAccount object.

Checkinfocontact_mailaddress_country String False

The Checkinfocontact_mailaddress_country field of the SavingsAccount object.

Checkinfocontact_mailaddress_countrycode String False

The Checkinfocontact_mailaddress_countrycode field of the SavingsAccount object.

Checkinfocontact_phone1 String False

The Checkinfocontact_phone1 field of the SavingsAccount object.

Financialdata_apjournal String False

The Financialdata_apjournal field of the SavingsAccount object.

Financialdata_arjournal String False

The Financialdata_arjournal field of the SavingsAccount object.

Servicechargeglaccount String False

The Servicechargeglaccount field of the SavingsAccount object.

Servicechargeaccountlabel String False

The Servicechargeaccountlabel field of the SavingsAccount object.

Interestearnedglaccount String False

The Interestearnedglaccount field of the SavingsAccount object.

Interestearnedaccountlabel String False

The Interestearnedaccountlabel field of the SavingsAccount object.

Departmentid String False

The Departmentid field of the SavingsAccount object.

Locationid String False

The Locationid field of the SavingsAccount object.

Status String False

The Status field of the SavingsAccount object.

Lastreconciledbalance String False

The Lastreconciledbalance field of the SavingsAccount object.

Lastreconcileddate Datetime False

The Lastreconcileddate field of the SavingsAccount object.

Nextcheck String False

The Nextcheck field of the SavingsAccount object.

Sharecheckno Boolean False

The Sharecheckno field of the SavingsAccount object.

Cutoffdate Datetime False

The Cutoffdate field of the SavingsAccount object.

Financialdata_reconmode String False

The Financialdata_reconmode field of the SavingsAccount object.

Currency String False

The Currency field of the SavingsAccount object.

Forwfpm Boolean False

The Forwfpm field of the SavingsAccount object.

Achcompanyid String False

The Achcompanyid field of the SavingsAccount object.

Pmchecktemplateid String False

The Pmchecktemplateid field of the SavingsAccount object.

Whencreated Datetime False

The Whencreated field of the SavingsAccount object.

Whenmodified Datetime False

The Whenmodified field of the SavingsAccount object.

Createdby Int64 False

The Createdby field of the SavingsAccount object.

Modifiedby Int64 False

The Modifiedby field of the SavingsAccount object.

Recordno Int64 False

The Recordno field of the SavingsAccount object.

Outsourcecheck String False

The Outsourcecheck field of the SavingsAccount object.

Fractionalroutingno String False

The Fractionalroutingno field of the SavingsAccount object.

Nameontheaccount String False

The Nameontheaccount field of the SavingsAccount object.

Megaentitykey Int64 False

The Megaentitykey field of the SavingsAccount object.

Megaentityid String False

The Megaentityid field of the SavingsAccount object.

Megaentityname String False

The Megaentityname field of the SavingsAccount object.

Record_url String False

The Record_url field of the SavingsAccount object.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462