SSIS Components for Sage Intacct

Build 24.0.9062

GLEntry

Retrieves GLEntry report data.

Columns

Name Type Description
Recordno [KEY] String The Recordno field of the GLEntry object.
Batchno Int64 The Batchno field of the GLEntry object.
Userno Int64 The Userno field of the GLEntry object.
Line_no Int64 The Line_no field of the GLEntry object.
Tr_type Int64 The Tr_type field of the GLEntry object.
Entry_date Datetime The Entry_date field of the GLEntry object.
Amount Double The Amount field of the GLEntry object.
Trx_amount Double The Trx_amount field of the GLEntry object.
Accountkey Int64 The Accountkey field of the GLEntry object.
Accountno String The Accountno field of the GLEntry object.
Departmentkey Int64 The Departmentkey field of the GLEntry object.
Department String The Department field of the GLEntry object.
Departmenttitle String The Departmenttitle field of the GLEntry object.
Locationkey Int64 The Locationkey field of the GLEntry object.
Location String The Location field of the GLEntry object.
Locationname String The Locationname field of the GLEntry object.
Document String The Document field of the GLEntry object.
Description String The Description field of the GLEntry object.
Units Int64 The Units field of the GLEntry object.
Basecurr String The Basecurr field of the GLEntry object.
Currency String The Currency field of the GLEntry object.
Cleared String The Cleared field of the GLEntry object.
Clrdate Datetime The Clrdate field of the GLEntry object.
Timeperiod Int64 The Timeperiod field of the GLEntry object.
Adj String The Adj field of the GLEntry object.
Exch_rate_date Datetime The Exch_rate_date field of the GLEntry object.
Exch_rate_type_id String The Exch_rate_type_id field of the GLEntry object.
Exchange_rate Double The Exchange_rate field of the GLEntry object.
Recon_date Datetime The Recon_date field of the GLEntry object.
Allocation String The Allocation field of the GLEntry object.
Allocationkey Int64 The Allocationkey field of the GLEntry object.
Whencreated Datetime The Whencreated field of the GLEntry object.
Whenmodified Datetime The Whenmodified field of the GLEntry object.
Createdby Int64 The Createdby field of the GLEntry object.
Modifiedby Int64 The Modifiedby field of the GLEntry object.
State String The State field of the GLEntry object.
Projectdimkey Int64 The Projectdimkey field of the GLEntry object.
Projectid String The Projectid field of the GLEntry object.
Projectname String The Projectname field of the GLEntry object.
Customerdimkey Int64 The Customerdimkey field of the GLEntry object.
Customerid String The Customerid field of the GLEntry object.
Customername String The Customername field of the GLEntry object.
Vendordimkey Int64 The Vendordimkey field of the GLEntry object.
Vendorid String The Vendorid field of the GLEntry object.
Vendorname String The Vendorname field of the GLEntry object.
Employeedimkey Int64 The Employeedimkey field of the GLEntry object.
Employeeid String The Employeeid field of the GLEntry object.
Employeename String The Employeename field of the GLEntry object.
Itemdimkey Int64 The Itemdimkey field of the GLEntry object.
Itemid String The Itemid field of the GLEntry object.
Itemname String The Itemname field of the GLEntry object.
Classdimkey Int64 The Classdimkey field of the GLEntry object.
Classid String The Classid field of the GLEntry object.
Classname String The Classname field of the GLEntry object.
Record_url String The Record_url field of the GLEntry object.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062