JDBC Driver for Sage Intacct

Build 22.0.8462

PSADocumentEntry

Retrieves PSADocumentEntry report data.

Columns

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

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