SSIS Components for Sage Intacct

Build 24.0.9061

DepositEntry

Retrieves DepositEntry report data.

Columns

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

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