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. |