JDBC Driver for Sage Intacct

Build 20.0.7654

CheckingAccount

Retrieves CheckingAccount report data.

Columns

Name Type ReadOnly Description
Bankaccountid [KEY] String False

The Bankaccountid field of the CheckingAccount object.

Bankaccountno String False

The Bankaccountno field of the CheckingAccount object.

Glaccountno String False

The Glaccountno field of the CheckingAccount object.

Bankname String False

The Bankname field of the CheckingAccount object.

Routingno String False

The Routingno field of the CheckingAccount object.

Branchid String False

The Branchid field of the CheckingAccount object.

Bankaccounttype String False

The Bankaccounttype field of the CheckingAccount object.

Phone String False

The Phone field of the CheckingAccount object.

Checklayout_sigline2amount String False

The Checklayout_sigline2amount field of the CheckingAccount object.

Checklayout_checkpaperformat String False

The Checklayout_checkpaperformat field of the CheckingAccount object.

Checklayout_checkprintformat String False

The Checklayout_checkprintformat field of the CheckingAccount object.

Checklayout_signatureimage1 String False

The Checklayout_signatureimage1 field of the CheckingAccount object.

Checklayout_signatureimage2 String False

The Checklayout_signatureimage2 field of the CheckingAccount object.

Checklayout_printlineitems Boolean False

The Checklayout_printlineitems field of the CheckingAccount object.

Checklayout_displaylocationas String False

The Checklayout_displaylocationas field of the CheckingAccount object.

Checklayout_bankacctalign String False

The Checklayout_bankacctalign field of the CheckingAccount object.

Checklayout_spacestoappend String False

The Checklayout_spacestoappend field of the CheckingAccount object.

Checklayout_checknolength String False

The Checklayout_checknolength field of the CheckingAccount object.

Checklayout_dfltcnyaddr Boolean False

The Checklayout_dfltcnyaddr field of the CheckingAccount object.

Checklayout_voidtext String False

The Checklayout_voidtext field of the CheckingAccount object.

Checklayout_usesig1belowamt String False

The Checklayout_usesig1belowamt field of the CheckingAccount object.

Checklayout_usesig2belowamt String False

The Checklayout_usesig2belowamt field of the CheckingAccount object.

Checklayout_micrtranscode Boolean False

The Checklayout_micrtranscode field of the CheckingAccount object.

Checklayout_usdtext Boolean False

The Checklayout_usdtext field of the CheckingAccount object.

Checklayout_onus Boolean False

The Checklayout_onus field of the CheckingAccount object.

Checklayout_onus32 String False

The Checklayout_onus32 field of the CheckingAccount object.

Checklayout_usesecondsignaturechecks Boolean False

The Checklayout_usesecondsignaturechecks field of the CheckingAccount object.

Checklayout_printcnylogo Boolean False

The Checklayout_printcnylogo field of the CheckingAccount object.

Checklayout_company_logo String False

The Checklayout_company_logo field of the CheckingAccount object.

Checklayout_usecnyaddress String False

The Checklayout_usecnyaddress field of the CheckingAccount object.

Mailaddress_address1 String False

The Mailaddress_address1 field of the CheckingAccount object.

Mailaddress_address2 String False

The Mailaddress_address2 field of the CheckingAccount object.

Mailaddress_city String False

The Mailaddress_city field of the CheckingAccount object.

Mailaddress_state String False

The Mailaddress_state field of the CheckingAccount object.

Mailaddress_zip String False

The Mailaddress_zip field of the CheckingAccount object.

Mailaddress_country String False

The Mailaddress_country field of the CheckingAccount object.

Mailaddress_countrycode String False

The Mailaddress_countrycode field of the CheckingAccount object.

Checkinfocontact_contactname String False

The Checkinfocontact_contactname field of the CheckingAccount object.

Checkinfocontact_companyname String False

The Checkinfocontact_companyname field of the CheckingAccount object.

Checkinfocontact_mailaddress_address1 String False

The Checkinfocontact_mailaddress_address1 field of the CheckingAccount object.

Checkinfocontact_mailaddress_address2 String False

The Checkinfocontact_mailaddress_address2 field of the CheckingAccount object.

Checkinfocontact_mailaddress_city String False

The Checkinfocontact_mailaddress_city field of the CheckingAccount object.

Checkinfocontact_mailaddress_state String False

The Checkinfocontact_mailaddress_state field of the CheckingAccount object.

Checkinfocontact_mailaddress_zip String False

The Checkinfocontact_mailaddress_zip field of the CheckingAccount object.

Checkinfocontact_mailaddress_country String False

The Checkinfocontact_mailaddress_country field of the CheckingAccount object.

Checkinfocontact_mailaddress_countrycode String False

The Checkinfocontact_mailaddress_countrycode field of the CheckingAccount object.

Checkinfocontact_phone1 String False

The Checkinfocontact_phone1 field of the CheckingAccount object.

Financialdata_apjournal String False

The Financialdata_apjournal field of the CheckingAccount object.

Financialdata_arjournal String False

The Financialdata_arjournal field of the CheckingAccount object.

Servicechargeglaccount String False

The Servicechargeglaccount field of the CheckingAccount object.

Servicechargeaccountlabel String False

The Servicechargeaccountlabel field of the CheckingAccount object.

Interestearnedglaccount String False

The Interestearnedglaccount field of the CheckingAccount object.

Interestearnedaccountlabel String False

The Interestearnedaccountlabel field of the CheckingAccount object.

Departmentid String False

The Departmentid field of the CheckingAccount object.

Locationid String False

The Locationid field of the CheckingAccount object.

Status String False

The Status field of the CheckingAccount object.

Lastreconciledbalance String False

The Lastreconciledbalance field of the CheckingAccount object.

Lastreconcileddate Datetime False

The Lastreconcileddate field of the CheckingAccount object.

Nextcheck String False

The Nextcheck field of the CheckingAccount object.

Sharecheckno Boolean False

The Sharecheckno field of the CheckingAccount object.

Cutoffdate Datetime False

The Cutoffdate field of the CheckingAccount object.

Financialdata_reconmode String False

The Financialdata_reconmode field of the CheckingAccount object.

Currency String False

The Currency field of the CheckingAccount object.

Forwfpm Boolean False

The Forwfpm field of the CheckingAccount object.

Achcompanyid String False

The Achcompanyid field of the CheckingAccount object.

Pmchecktemplateid String False

The Pmchecktemplateid field of the CheckingAccount object.

Whencreated Datetime False

The Whencreated field of the CheckingAccount object.

Whenmodified Datetime False

The Whenmodified field of the CheckingAccount object.

Createdby Int64 False

The Createdby field of the CheckingAccount object.

Modifiedby Int64 False

The Modifiedby field of the CheckingAccount object.

Recordno Int64 False

The Recordno field of the CheckingAccount object.

Achbankid String False

The Achbankid field of the CheckingAccount object.

Companyname String False

The Companyname field of the CheckingAccount object.

Companyidentification String False

The Companyidentification field of the CheckingAccount object.

Financialinstitution String False

The Financialinstitution field of the CheckingAccount object.

Description String False

The Description field of the CheckingAccount object.

Discretionarydata String False

The Discretionarydata field of the CheckingAccount object.

Recordtypecode String False

The Recordtypecode field of the CheckingAccount object.

Serviceclasscode String False

The Serviceclasscode field of the CheckingAccount object.

Originatorstatuscode String False

The Originatorstatuscode field of the CheckingAccount object.

Batchid String False

The Batchid field of the CheckingAccount object.

Tracenumberseq String False

The Tracenumberseq field of the CheckingAccount object.

Docnumberseq String False

The Docnumberseq field of the CheckingAccount object.

Usetracenumber String False

The Usetracenumber field of the CheckingAccount object.

Achenabled Boolean False

The Achenabled field of the CheckingAccount object.

Userecommendedsetup Boolean False

The Userecommendedsetup field of the CheckingAccount object.

Printon String False

The Printon field of the CheckingAccount object.

Outsourcecheck String False

The Outsourcecheck field of the CheckingAccount object.

Fractionalroutingno String False

The Fractionalroutingno field of the CheckingAccount object.

Nameontheaccount String False

The Nameontheaccount field of the CheckingAccount object.

Automate_check_print Boolean False

The Automate_check_print field of the CheckingAccount object.

Automate_pymt_conf Boolean False

The Automate_pymt_conf field of the CheckingAccount object.

Automate_ach_pymt_send Boolean False

The Automate_ach_pymt_send field of the CheckingAccount object.

Automate_ach_pymt_conf Boolean False

The Automate_ach_pymt_conf field of the CheckingAccount object.

Amex_payve_accountid String False

The Amex_payve_accountid field of the CheckingAccount object.

Amexchecknum String False

The Amexchecknum field of the CheckingAccount object.

Abo_first_name String False

The Abo_first_name field of the CheckingAccount object.

Abo_middle_name String False

The Abo_middle_name field of the CheckingAccount object.

Abo_last_name String False

The Abo_last_name field of the CheckingAccount object.

Abo_phone_number String False

The Abo_phone_number field of the CheckingAccount object.

Abo_email_id String False

The Abo_email_id field of the CheckingAccount object.

Outsourceach String False

The Outsourceach field of the CheckingAccount object.

Megaentitykey Int64 False

The Megaentitykey field of the CheckingAccount object.

Megaentityid String False

The Megaentityid field of the CheckingAccount object.

Megaentityname String False

The Megaentityname field of the CheckingAccount object.

Record_url String False

The Record_url field of the CheckingAccount object.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654