Tableau Connector for Sage Intacct

Build 21.0.7930

CCTransactionEntry

Retrieves CCTransactionEntry report data.

Columns

Name Type Description
Recordno [KEY] String The Recordno field of the CCTransactionEntry object.
Recordkey Int64 The Recordkey field of the CCTransactionEntry object.
Recordtype String The Recordtype field of the CCTransactionEntry object.
Accountkey Int64 The Accountkey field of the CCTransactionEntry object.
Accountno String The Accountno field of the CCTransactionEntry object.
Accounttitle String The Accounttitle field of the CCTransactionEntry object.
Accountlabelkey Int64 The Accountlabelkey field of the CCTransactionEntry object.
Accountlabel String The Accountlabel field of the CCTransactionEntry object.
Amount Double The Amount field of the CCTransactionEntry object.
Trx_amount Double The Trx_amount field of the CCTransactionEntry object.
DeptNUM Int64 The Dept# field of the CCTransactionEntry object.
Departmentid String The Departmentid field of the CCTransactionEntry object.
Departmentname String The Departmentname field of the CCTransactionEntry object.
LocationNUM Int64 The Location# field of the CCTransactionEntry object.
Locationid String The Locationid field of the CCTransactionEntry object.
Locationname String The Locationname field of the CCTransactionEntry object.
Description String The Description field of the CCTransactionEntry object.
Exch_rate_date Datetime The Exch_rate_date field of the CCTransactionEntry object.
Exch_rate_type_id Int64 The Exch_rate_type_id field of the CCTransactionEntry object.
Exchange_rate Double The Exchange_rate field of the CCTransactionEntry object.
Lineitem String The Lineitem field of the CCTransactionEntry object.
Line_no String The Line_no field of the CCTransactionEntry object.
Currency String The Currency field of the CCTransactionEntry object.
Basecurr String The Basecurr field of the CCTransactionEntry object.
Status String The Status field of the CCTransactionEntry object.
Totalpaid Double The Totalpaid field of the CCTransactionEntry object.
Trx_totalpaid Double The Trx_totalpaid field of the CCTransactionEntry object.
Departmentkey Int64 The Departmentkey field of the CCTransactionEntry object.
Whencreated Datetime The Whencreated field of the CCTransactionEntry object.
Whenmodified Datetime The Whenmodified field of the CCTransactionEntry object.
Createdby Int64 The Createdby field of the CCTransactionEntry object.
Modifiedby Int64 The Modifiedby field of the CCTransactionEntry object.
Projectdimkey Int64 The Projectdimkey field of the CCTransactionEntry object.
Projectid String The Projectid field of the CCTransactionEntry object.
Projectname String The Projectname field of the CCTransactionEntry object.
Customerdimkey Int64 The Customerdimkey field of the CCTransactionEntry object.
Customerid String The Customerid field of the CCTransactionEntry object.
Customername String The Customername field of the CCTransactionEntry object.
Vendordimkey Int64 The Vendordimkey field of the CCTransactionEntry object.
Vendorid String The Vendorid field of the CCTransactionEntry object.
Vendorname String The Vendorname field of the CCTransactionEntry object.
Employeedimkey Int64 The Employeedimkey field of the CCTransactionEntry object.
Employeeid String The Employeeid field of the CCTransactionEntry object.
Employeename String The Employeename field of the CCTransactionEntry object.
Itemdimkey Int64 The Itemdimkey field of the CCTransactionEntry object.
Itemid String The Itemid field of the CCTransactionEntry object.
Itemname String The Itemname field of the CCTransactionEntry object.
Classdimkey Int64 The Classdimkey field of the CCTransactionEntry object.
Classid String The Classid field of the CCTransactionEntry object.
Classname String The Classname field of the CCTransactionEntry object.
Record_url String The Record_url field of the CCTransactionEntry object.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930