JDBC Driver for Sage Intacct

Build 22.0.8462

PODocumentEntry

Retrieves PODocumentEntry report data.

Columns

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

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