JDBC Driver for Sage Intacct

Build 22.0.8462

CCTransaction

Retrieves CCTransaction report data.

Columns

Name Type Description
Recordno [KEY] String The Recordno field of the CCTransaction object.
Financialentity String The Financialentity field of the CCTransaction object.
Whencreated Datetime The Whencreated field of the CCTransaction object.
Recordid String The Recordid field of the CCTransaction object.
Recordtype String The Recordtype field of the CCTransaction object.
Description2 String The Description2 field of the CCTransaction object.
Description String The Description field of the CCTransaction object.
Prbatchkey Int64 The Prbatchkey field of the CCTransaction object.
Basecurr String The Basecurr field of the CCTransaction object.
Currency String The Currency field of the CCTransaction object.
Exch_rate_date Datetime The Exch_rate_date field of the CCTransaction object.
Exch_rate_type_id Int64 The Exch_rate_type_id field of the CCTransaction object.
Exchange_rate Double The Exchange_rate field of the CCTransaction object.
Totalentered Double The Totalentered field of the CCTransaction object.
Trx_totalentered Double The Trx_totalentered field of the CCTransaction object.
Totalpaid Double The Totalpaid field of the CCTransaction object.
Trx_totalpaid Double The Trx_totalpaid field of the CCTransaction object.
Whenpaid Datetime The Whenpaid field of the CCTransaction object.
Reversalkey Int64 The Reversalkey field of the CCTransaction object.
Reversaldate String The Reversaldate field of the CCTransaction object.
Reversedkey Int64 The Reversedkey field of the CCTransaction object.
Reverseddate String The Reverseddate field of the CCTransaction object.
State String The State field of the CCTransaction object.
Rawstate String The Rawstate field of the CCTransaction object.
Cleared String The Cleared field of the CCTransaction object.
Paymentkey Int64 The Paymentkey field of the CCTransaction object.
Auwhencreated Datetime The Auwhencreated field of the CCTransaction object.
Whenmodified Datetime The Whenmodified field of the CCTransaction object.
Createdby Int64 The Createdby field of the CCTransaction object.
Modifiedby Int64 The Modifiedby field of the CCTransaction object.
Megaentitykey Int64 The Megaentitykey field of the CCTransaction object.
Megaentityid String The Megaentityid field of the CCTransaction object.
Megaentityname String The Megaentityname field of the CCTransaction object.
Record_url String The Record_url field of the CCTransaction object.

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