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