JDBC Driver for Sage Intacct

Build 22.0.8462

InvDocumentEntry

Retrieves InvDocumentEntry report data.

Columns

Name Type Description
Recordno [KEY] String The Recordno field of the InvDocumentEntry object.
Dochdrno Int64 The Dochdrno field of the InvDocumentEntry object.
Dochdrid String The Dochdrid field of the InvDocumentEntry object.
Bundlenumber String The Bundlenumber field of the InvDocumentEntry object.
Line_no Int64 The Line_no field of the InvDocumentEntry object.
Itemid String The Itemid field of the InvDocumentEntry object.
Itemname String The Itemname field of the InvDocumentEntry object.
Itemdesc String The Itemdesc field of the InvDocumentEntry object.
Unit String The Unit field of the InvDocumentEntry object.
Warehouse_location_no String The Warehouse_location_no field of the InvDocumentEntry object.
Warehouse_name String The Warehouse_name field of the InvDocumentEntry object.
Memo String The Memo field of the InvDocumentEntry object.
Quantity Double The Quantity field of the InvDocumentEntry object.
Qty_converted Double The Qty_converted field of the InvDocumentEntry object.
Retailprice Double The Retailprice field of the InvDocumentEntry object.
Price Double The Price field of the InvDocumentEntry object.
Total Double The Total field of the InvDocumentEntry object.
Whencreated Datetime The Whencreated field of the InvDocumentEntry object.
Whenmodified Datetime The Whenmodified field of the InvDocumentEntry object.
Item_taxable Boolean The Item_taxable field of the InvDocumentEntry object.
Item_taxgroup_recordno Int64 The Item_taxgroup_recordno field of the InvDocumentEntry object.
Item_renewalmacro_macroid String The Item_renewalmacro_macroid field of the InvDocumentEntry object.
Extended_description String The Extended_description field of the InvDocumentEntry object.
Itemglgroup String The Itemglgroup field of the InvDocumentEntry object.
State String The State field of the InvDocumentEntry object.
Status String The Status field of the InvDocumentEntry object.
Glentrykey1 Int64 The Glentrykey1 field of the InvDocumentEntry object.
Glentrykey2 Int64 The Glentrykey2 field of the InvDocumentEntry object.
Cost Double The Cost field of the InvDocumentEntry object.
Cost_method String The Cost_method field of the InvDocumentEntry object.
Average_cost String The Average_cost field of the InvDocumentEntry object.
Whse_average_cost String The Whse_average_cost field of the InvDocumentEntry object.
Uiqty Double The Uiqty field of the InvDocumentEntry object.
Discountpercent Double The Discountpercent field of the InvDocumentEntry object.
Uiprice Double The Uiprice field of the InvDocumentEntry object.
Uivalue Double The Uivalue field of the InvDocumentEntry object.
Locationid String The Locationid field of the InvDocumentEntry object.
Locationname String The Locationname field of the InvDocumentEntry object.
Departmentid String The Departmentid field of the InvDocumentEntry object.
Departmentname String The Departmentname field of the InvDocumentEntry object.
Deptkey String The Deptkey field of the InvDocumentEntry object.
Locationkey String The Locationkey field of the InvDocumentEntry object.
Timetypekey Int64 The Timetypekey field of the InvDocumentEntry object.
Timetypename String The Timetypename field of the InvDocumentEntry object.
Timenotes String The Timenotes field of the InvDocumentEntry object.
Eeaccountlabelkey Int64 The Eeaccountlabelkey field of the InvDocumentEntry object.
Eeaccountlabel String The Eeaccountlabel field of the InvDocumentEntry object.
Source_dockey String The Source_dockey field of the InvDocumentEntry object.
Source_doclinekey String The Source_doclinekey field of the InvDocumentEntry object.
Revrectemplate String The Revrectemplate field of the InvDocumentEntry object.
Revrectemplatekey String The Revrectemplatekey field of the InvDocumentEntry object.
Revrecstartdate Datetime The Revrecstartdate field of the InvDocumentEntry object.
Itemterm String The Itemterm field of the InvDocumentEntry object.
Termperiod String The Termperiod field of the InvDocumentEntry object.
Revrecenddate Datetime The Revrecenddate field of the InvDocumentEntry object.
Prorateprice Boolean The Prorateprice field of the InvDocumentEntry object.
Deferrevenue String The Deferrevenue field of the InvDocumentEntry object.
Sc_revrectemplate String The Sc_revrectemplate field of the InvDocumentEntry object.
Sc_revrectemplatekey String The Sc_revrectemplatekey field of the InvDocumentEntry object.
Sc_revrecstartdate Datetime The Sc_revrecstartdate field of the InvDocumentEntry object.
Sc_revrecenddate Datetime The Sc_revrecenddate field of the InvDocumentEntry object.
Sc_startdate Datetime The Sc_startdate field of the InvDocumentEntry object.
Item_itemtype String The Item_itemtype field of the InvDocumentEntry object.
Item_numdec_sale String The Item_numdec_sale field of the InvDocumentEntry object.
Item_numdec_std String The Item_numdec_std field of the InvDocumentEntry object.
Item_numdec_pur String The Item_numdec_pur field of the InvDocumentEntry object.
Item_revposting String The Item_revposting field of the InvDocumentEntry object.
Item_computeforshortterm Boolean The Item_computeforshortterm field of the InvDocumentEntry object.
Item_renewalmacrokey Int64 The Item_renewalmacrokey field of the InvDocumentEntry object.
Item_uomgrpkey Int64 The Item_uomgrpkey field of the InvDocumentEntry object.
Discount_memo String The Discount_memo field of the InvDocumentEntry object.
Item_revprinting String The Item_revprinting field of the InvDocumentEntry object.
Currency String The Currency field of the InvDocumentEntry object.
Exchratedate Datetime The Exchratedate field of the InvDocumentEntry object.
Exchratetype String The Exchratetype field of the InvDocumentEntry object.
Exchrate Double The Exchrate field of the InvDocumentEntry object.
Trx_price Double The Trx_price field of the InvDocumentEntry object.
Trx_value Double The Trx_value field of the InvDocumentEntry object.
Schedulename String The Schedulename field of the InvDocumentEntry object.
Scheduleid String The Scheduleid field of the InvDocumentEntry object.
Recurdocid String The Recurdocid field of the InvDocumentEntry object.
Recurdocentrykey Int64 The Recurdocentrykey field of the InvDocumentEntry object.
Renewalmacro String The Renewalmacro field of the InvDocumentEntry object.
Renewalmacrokey String The Renewalmacrokey field of the InvDocumentEntry object.
Overridetax Boolean The Overridetax field of the InvDocumentEntry object.
Sc_createrecursched String The Sc_createrecursched field of the InvDocumentEntry object.
Sc_existingsched String The Sc_existingsched field of the InvDocumentEntry object.
Sc_extendlineperiod Boolean The Sc_extendlineperiod field of the InvDocumentEntry object.
Sc_installpricing Boolean The Sc_installpricing field of the InvDocumentEntry object.
Recurcontractid String The Recurcontractid field of the InvDocumentEntry object.
Source_docid String The Source_docid field of the InvDocumentEntry object.
Billable Boolean The Billable field of the InvDocumentEntry object.
Billed Boolean The Billed field of the InvDocumentEntry object.
Billabletimeentrykey Int64 The Billabletimeentrykey field of the InvDocumentEntry object.
Billableprentrykey Int64 The Billableprentrykey field of the InvDocumentEntry object.
Billabledocentrykey Int64 The Billabledocentrykey field of the InvDocumentEntry object.
Percentval Double The Percentval field of the InvDocumentEntry object.
Taxabsval Double The Taxabsval field of the InvDocumentEntry object.
Taxableamount Double The Taxableamount field of the InvDocumentEntry object.
Linetotal Double The Linetotal field of the InvDocumentEntry object.
Discount Double The Discount field of the InvDocumentEntry object.
Trx_taxabsval Double The Trx_taxabsval field of the InvDocumentEntry object.
Trx_linetotal Double The Trx_linetotal field of the InvDocumentEntry object.
Taxvaloverride Boolean The Taxvaloverride field of the InvDocumentEntry object.
Projectkey String The Projectkey field of the InvDocumentEntry object.
Projectname String The Projectname field of the InvDocumentEntry object.
Taskkey String The Taskkey field of the InvDocumentEntry object.
Taskname String The Taskname field of the InvDocumentEntry object.
Projectdimkey Int64 The Projectdimkey field of the InvDocumentEntry object.
Projectid String The Projectid field of the InvDocumentEntry object.
Record_url String The Record_url field of the InvDocumentEntry object.

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