JDBC Driver for Sage Intacct

Build 22.0.8462

RecurDocumentEntry

Retrieves RecurDocumentEntry report data.

Columns

Name Type Description
Recordno [KEY] String The Recordno field of the RecurDocumentEntry object.
Dochdrno Int64 The Dochdrno field of the RecurDocumentEntry object.
Line_no Int64 The Line_no field of the RecurDocumentEntry object.
Itemid String The Itemid field of the RecurDocumentEntry object.
Itemdesc String The Itemdesc field of the RecurDocumentEntry object.
Unit String The Unit field of the RecurDocumentEntry object.
Warehouse_location_no String The Warehouse_location_no field of the RecurDocumentEntry object.
Memo String The Memo field of the RecurDocumentEntry object.
Whenmodified Datetime The Whenmodified field of the RecurDocumentEntry object.
Item_taxable Boolean The Item_taxable field of the RecurDocumentEntry object.
Item_computeforshortterm Boolean The Item_computeforshortterm field of the RecurDocumentEntry object.
Item_taxgroup_recordno Int64 The Item_taxgroup_recordno field of the RecurDocumentEntry object.
Item_uomgrpkey Int64 The Item_uomgrpkey field of the RecurDocumentEntry object.
Cost_method String The Cost_method field of the RecurDocumentEntry object.
State String The State field of the RecurDocumentEntry object.
Status String The Status field of the RecurDocumentEntry object.
Linestatus String The Linestatus field of the RecurDocumentEntry object.
Uiqty Double The Uiqty field of the RecurDocumentEntry object.
Uiprice String The Uiprice field of the RecurDocumentEntry object.
Uivalue Double The Uivalue field of the RecurDocumentEntry object.
Department String The Department field of the RecurDocumentEntry object.
Location String The Location field of the RecurDocumentEntry object.
Docentrykey Int64 The Docentrykey field of the RecurDocumentEntry object.
Revrecstartdate Datetime The Revrecstartdate field of the RecurDocumentEntry object.
Revrecenddate Datetime The Revrecenddate field of the RecurDocumentEntry object.
Itemterm String The Itemterm field of the RecurDocumentEntry object.
Termperiod String The Termperiod field of the RecurDocumentEntry object.
Prorateprice Boolean The Prorateprice field of the RecurDocumentEntry object.
Revrectemplate String The Revrectemplate field of the RecurDocumentEntry object.
Retailprice String The Retailprice field of the RecurDocumentEntry object.
Discount_memo String The Discount_memo field of the RecurDocumentEntry object.
Currency String The Currency field of the RecurDocumentEntry object.
Exchratedate Datetime The Exchratedate field of the RecurDocumentEntry object.
Exchratetype String The Exchratetype field of the RecurDocumentEntry object.
Exchrate Double The Exchrate field of the RecurDocumentEntry object.
Trx_price String The Trx_price field of the RecurDocumentEntry object.
Trx_value Double The Trx_value field of the RecurDocumentEntry object.
Discountpercent Double The Discountpercent field of the RecurDocumentEntry object.
Billable Boolean The Billable field of the RecurDocumentEntry object.
Form1099 Boolean The Form1099 field of the RecurDocumentEntry object.
Overridetax Boolean The Overridetax field of the RecurDocumentEntry object.
Projectdimkey Int64 The Projectdimkey field of the RecurDocumentEntry object.
Projectid String The Projectid field of the RecurDocumentEntry object.
Projectname String The Projectname field of the RecurDocumentEntry object.
Vendordimkey Int64 The Vendordimkey field of the RecurDocumentEntry object.
Vendorid String The Vendorid field of the RecurDocumentEntry object.
Vendorname String The Vendorname field of the RecurDocumentEntry object.
Employeedimkey Int64 The Employeedimkey field of the RecurDocumentEntry object.
Employeeid String The Employeeid field of the RecurDocumentEntry object.
Employeename String The Employeename field of the RecurDocumentEntry object.
Record_url String The Record_url field of the RecurDocumentEntry object.

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