JDBC Driver for Sage Intacct

Build 20.0.7654

STKitDocumentEntry

Retrieves STKitDocumentEntry report data.

Columns

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654