EPPaymentItem
Details line items for employee payments, documenting allocations and associated transactions.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the employee payment item record. |
| Recordtype | String | Type of record associated with the employee payment item. |
| Entry_date | Datetime | Date the entry was recorded in the system. |
| Recordkey | Int64 | Internal key for linking related records in the employee payment item table. |
| Vendoracctnokeyversion | Int64 | Version key for the vendor account number. |
| Entrydescription | String | Description of the payment entry or transaction. |
| Accountkey | Int64 | Key referencing the account associated with the payment item. |
| Glaccountno | String | General ledger account number for the transaction. |
| Glaccounttitle | String | Title or name of the general ledger account. |
| Amount | Double | Payment amount recorded for the item. |
| Locationid | String | Identifier for the location associated with the transaction. |
| Locationname | String | Name of the location associated with the transaction. |
| Departmentid | String | Identifier for the department related to the transaction. |
| Departmentname | String | Name of the department related to the transaction. |
| Line_no | String | Line number within the transaction or payment entry. |
| Form1099 | String | Indicates if the payment is associated with Form 1099 reporting. |
| Accountlabel | String | Label or alias for the account associated with the item. |
| Totalselected | Double | Total amount selected for processing in the transaction. |
| Totalpaid | Double | Total amount paid in the transaction. |
| Parententry | Int64 | Reference to the parent entry for the payment item. |
| Lineitem | String | Details of the specific line item in the payment entry. |
| Gloffset | Int64 | Offset value for the general ledger entry. |
| Baselocation | Int64 | Key identifying the base location for the transaction. |
| Allocationkey | Int64 | Key used to allocate amounts to different accounts or dimensions. |
| Allocation | String | Details of the allocation applied to the transaction. |
| Subtotal | String | Subtotal amount for the payment entry. |
| Deferrevenue | Boolean | Indicates whether the revenue is deferred for this item. |
| Revrectemplatekey | Int64 | Key identifying the revenue recognition template. |
| Revrectemplate | String | Name of the revenue recognition template used. |
| Deferredrevacctkey | Int64 | Key identifying the deferred revenue account. |
| Deferredrevacctno | String | Account number for the deferred revenue account. |
| Deferredrevaccttitle | String | Title or description of the deferred revenue account. |
| Revrecstartdate | Datetime | Start date for recognizing revenue associated with this item. |
| Revrecenddate | Datetime | End date for recognizing revenue associated with this item. |
| Entrycurrency | String | Currency used for the payment entry. |
| Entryexchratedate | Datetime | Date of the exchange rate applied to the entry. |
| Entryexchratetype | Int64 | Type of exchange rate used for the entry. |
| Entryexchrate | Double | Exchange rate applied to the entry currency. |
| Trx_amount | Double | Transaction amount for the payment item in its original currency. |
| Trx_totalselected | Double | Total amount selected for transaction in its original currency. |
| Trx_totalpaid | Double | Total paid amount in the transaction's original currency. |
| Billable | Boolean | Indicates if the item is billable to a customer. |
| Billed | Boolean | Indicates if the item has already been billed. |
| State | String | Current state or status of the payment item. |
| Releasetopay | Boolean | Indicates whether the item is approved for payment release. |
| Whencreated | Datetime | Timestamp when the item was created. |
| Whenmodified | Datetime | Timestamp when the item was last modified. |
| Createdby | Int64 | Identifier of the user who created the item. |
| Modifiedby | Int64 | Identifier of the user who last modified the item. |
| Locationkey | Int64 | Key referencing the location associated with the item. |
| Departmentkey | Int64 | Key referencing the department associated with the item. |
| Currency | String | Currency associated with the payment transaction. |
| Accountno | String | Account number associated with the payment transaction. |
| Accounttitle | String | Title of the account associated with the payment transaction. |
| Exch_rate_date | Datetime | Date the exchange rate was determined. |
| Exch_rate_type_id | Int64 | Identifier for the type of exchange rate applied. |
| Exchange_rate | Double | Exchange rate applied to the transaction. |
| Projectdimkey | Int64 | Key referencing the project dimension for the item. |
| Projectid | String | Identifier for the project associated with the transaction. |
| Projectname | String | Name of the project associated with the transaction. |
| Customerdimkey | Int64 | Key referencing the customer dimension for the item. |
| Customerid | String | Identifier for the customer associated with the item. |
| Customername | String | Name of the customer associated with the item. |
| Vendordimkey | Int64 | Key referencing the vendor dimension for the item. |
| Vendorid | String | Identifier for the vendor associated with the item. |
| Vendorname | String | Name of the vendor associated with the item. |
| Itemdimkey | Int64 | Key referencing the item dimension for the payment. |
| Itemid | String | Identifier for the item associated with the payment. |
| Itemname | String | Name of the item associated with the payment. |
| Classdimkey | Int64 | Key referencing the class dimension for the item. |
| Classid | String | Identifier for the class associated with the item. |
| Classname | String | Name of the class associated with the item. |
| Record_url | String | URL link to the record in the system. |