JDBC Driver for Sage Intacct

Build 22.0.8462

CNSAcctBal

Retrieves CNSAcctBal report data.

Columns

Name Type Description
Recordno [KEY] String The Recordno field of the CNSAcctBal object.
Subsidiarykey String The Subsidiarykey field of the CNSAcctBal object.
Subaccountkey String The Subaccountkey field of the CNSAcctBal object.
Subaccountno String The Subaccountno field of the CNSAcctBal object.
Subtitle String The Subtitle field of the CNSAcctBal object.
Cnsperiodkey String The Cnsperiodkey field of the CNSAcctBal object.
Consbsrrate String The Consbsrrate field of the CNSAcctBal object.
Conswarrate String The Conswarrate field of the CNSAcctBal object.
Subaccttype String The Subaccttype field of the CNSAcctBal object.
JournalNUM Int64 The Journal# field of the CNSAcctBal object.
Symbol String The Symbol field of the CNSAcctBal object.
Batch_title String The Batch_title field of the CNSAcctBal object.
Batch_date Datetime The Batch_date field of the CNSAcctBal object.
AccountNUM Int64 The Account# field of the CNSAcctBal object.
Acct_no String The Acct_no field of the CNSAcctBal object.
Entry_date Datetime The Entry_date field of the CNSAcctBal object.
Timeperiod Int64 The Timeperiod field of the CNSAcctBal object.
Debit Double The Debit field of the CNSAcctBal object.
Credit Double The Credit field of the CNSAcctBal object.
PeriodNUM Int64 The Period# field of the CNSAcctBal object.
Pname String The Pname field of the CNSAcctBal object.
Subsidiaryid String The Subsidiaryid field of the CNSAcctBal object.
Formula_debit Double The Formula_debit field of the CNSAcctBal object.
Formula_credit Double The Formula_credit field of the CNSAcctBal object.
Record_url String The Record_url field of the CNSAcctBal object.

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