EPPaymentItem
Retrieves EPPaymentItem report data.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | The Recordno field of the EPPaymentItem object. |
| Recordtype | String | The Recordtype field of the EPPaymentItem object. |
| Entry_date | Datetime | The Entry_date field of the EPPaymentItem object. |
| Recordkey | Int64 | The Recordkey field of the EPPaymentItem object. |
| Vendoracctnokeyversion | Int64 | The Vendoracctnokeyversion field of the EPPaymentItem object. |
| Entrydescription | String | The Entrydescription field of the EPPaymentItem object. |
| Accountkey | Int64 | The Accountkey field of the EPPaymentItem object. |
| Glaccountno | String | The Glaccountno field of the EPPaymentItem object. |
| Glaccounttitle | String | The Glaccounttitle field of the EPPaymentItem object. |
| Amount | Double | The Amount field of the EPPaymentItem object. |
| Locationid | String | The Locationid field of the EPPaymentItem object. |
| Locationname | String | The Locationname field of the EPPaymentItem object. |
| Departmentid | String | The Departmentid field of the EPPaymentItem object. |
| Departmentname | String | The Departmentname field of the EPPaymentItem object. |
| Line_no | String | The Line_no field of the EPPaymentItem object. |
| Form1099 | String | The Form1099 field of the EPPaymentItem object. |
| Accountlabel | String | The Accountlabel field of the EPPaymentItem object. |
| Totalselected | Double | The Totalselected field of the EPPaymentItem object. |
| Totalpaid | Double | The Totalpaid field of the EPPaymentItem object. |
| Parententry | Int64 | The Parententry field of the EPPaymentItem object. |
| Lineitem | String | The Lineitem field of the EPPaymentItem object. |
| Gloffset | Int64 | The Gloffset field of the EPPaymentItem object. |
| Baselocation | Int64 | The Baselocation field of the EPPaymentItem object. |
| Allocationkey | Int64 | The Allocationkey field of the EPPaymentItem object. |
| Allocation | String | The Allocation field of the EPPaymentItem object. |
| Subtotal | String | The Subtotal field of the EPPaymentItem object. |
| Deferrevenue | Boolean | The Deferrevenue field of the EPPaymentItem object. |
| Revrectemplatekey | Int64 | The Revrectemplatekey field of the EPPaymentItem object. |
| Revrectemplate | String | The Revrectemplate field of the EPPaymentItem object. |
| Deferredrevacctkey | Int64 | The Deferredrevacctkey field of the EPPaymentItem object. |
| Deferredrevacctno | String | The Deferredrevacctno field of the EPPaymentItem object. |
| Deferredrevaccttitle | String | The Deferredrevaccttitle field of the EPPaymentItem object. |
| Revrecstartdate | Datetime | The Revrecstartdate field of the EPPaymentItem object. |
| Revrecenddate | Datetime | The Revrecenddate field of the EPPaymentItem object. |
| Entrycurrency | String | The Entrycurrency field of the EPPaymentItem object. |
| Entryexchratedate | Datetime | The Entryexchratedate field of the EPPaymentItem object. |
| Entryexchratetype | Int64 | The Entryexchratetype field of the EPPaymentItem object. |
| Entryexchrate | Double | The Entryexchrate field of the EPPaymentItem object. |
| Trx_amount | Double | The Trx_amount field of the EPPaymentItem object. |
| Trx_totalselected | Double | The Trx_totalselected field of the EPPaymentItem object. |
| Trx_totalpaid | Double | The Trx_totalpaid field of the EPPaymentItem object. |
| Billable | Boolean | The Billable field of the EPPaymentItem object. |
| Billed | Boolean | The Billed field of the EPPaymentItem object. |
| State | String | The State field of the EPPaymentItem object. |
| Releasetopay | Boolean | The Releasetopay field of the EPPaymentItem object. |
| Whencreated | Datetime | The Whencreated field of the EPPaymentItem object. |
| Whenmodified | Datetime | The Whenmodified field of the EPPaymentItem object. |
| Createdby | Int64 | The Createdby field of the EPPaymentItem object. |
| Modifiedby | Int64 | The Modifiedby field of the EPPaymentItem object. |
| Locationkey | Int64 | The Locationkey field of the EPPaymentItem object. |
| Departmentkey | Int64 | The Departmentkey field of the EPPaymentItem object. |
| Currency | String | The Currency field of the EPPaymentItem object. |
| Accountno | String | The Accountno field of the EPPaymentItem object. |
| Accounttitle | String | The Accounttitle field of the EPPaymentItem object. |
| Exch_rate_date | Datetime | The Exch_rate_date field of the EPPaymentItem object. |
| Exch_rate_type_id | Int64 | The Exch_rate_type_id field of the EPPaymentItem object. |
| Exchange_rate | Double | The Exchange_rate field of the EPPaymentItem object. |
| Projectdimkey | Int64 | The Projectdimkey field of the EPPaymentItem object. |
| Projectid | String | The Projectid field of the EPPaymentItem object. |
| Projectname | String | The Projectname field of the EPPaymentItem object. |
| Customerdimkey | Int64 | The Customerdimkey field of the EPPaymentItem object. |
| Customerid | String | The Customerid field of the EPPaymentItem object. |
| Customername | String | The Customername field of the EPPaymentItem object. |
| Vendordimkey | Int64 | The Vendordimkey field of the EPPaymentItem object. |
| Vendorid | String | The Vendorid field of the EPPaymentItem object. |
| Vendorname | String | The Vendorname field of the EPPaymentItem object. |
| Itemdimkey | Int64 | The Itemdimkey field of the EPPaymentItem object. |
| Itemid | String | The Itemid field of the EPPaymentItem object. |
| Itemname | String | The Itemname field of the EPPaymentItem object. |
| Classdimkey | Int64 | The Classdimkey field of the EPPaymentItem object. |
| Classid | String | The Classid field of the EPPaymentItem object. |
| Classname | String | The Classname field of the EPPaymentItem object. |
| Record_url | String | The Record_url field of the EPPaymentItem object. |