EExpenses
Manages employee expense records, including amounts, dates, and associated accounts.
Columns
| Name | Type | ReadOnly | Description |
| Recordid [KEY] | String | False |
The unique identifier for the employee expense record. |
| Contact_lastname | String | False |
The last name of the contact associated with the expense. |
| Contact_firstname | String | False |
The first name of the contact associated with the expense. |
| Recordno | String | False |
The unique number for the employee expense record. |
| Whencreated | Datetime | False |
The date and time when the expense record was created. |
| Whenposted | Datetime | False |
The date and time when the expense was posted. |
| Totalentered | Double | False |
The total amount entered for the expense. |
| State | String | False |
The current state of the expense record. |
| Totalpaid | Double | False |
The total amount paid for the expense. |
| Totalselected | Double | False |
The total amount selected for the expense. |
| Totaldue | Double | False |
The total amount due for the expense. |
| Recordtype | String | False |
The type of record associated with the expense. |
| Systemgenerated | String | False |
Indicates if the expense record was system-generated. |
| Prbatch | String | False |
The payroll batch associated with the expense. |
| Prbatchkey | Int64 | False |
The internal key for the payroll batch associated with the expense. |
| Empentity | String | False |
The employee entity associated with the expense. |
| Description | String | False |
A description of the expense record. |
| Whenpaid | Datetime | False |
The date and time when the expense was paid. |
| Whenmodified | Datetime | False |
The date and time when the expense record was last modified. |
| Currency | String | False |
The currency used for the expense. |
| Basecurr | String | False |
The base currency for the expense. |
| Entity | String | False |
The entity associated with the expense. |
| Userkey | String | False |
The key for the user associated with the expense. |
| Employeeid | String | False |
The ID of the employee associated with the expense. |
| Nr_totalentered | Double | False |
The total amount entered in non-reporting currency. |
| Nr_trx_totalentered | Double | False |
The transaction total entered in non-reporting currency. |
| Auwhencreated | Datetime | False |
The date and time of the audit creation for the expense record. |
| Createdby | Int64 | False |
The ID of the user who created the expense record. |
| Modifiedby | Int64 | False |
The ID of the user who last modified the expense record. |
| Memo | String | False |
A memo associated with the expense record. |
| Megaentitykey | Int64 | False |
The internal key of the mega entity associated with the expense. |
| Megaentityid | String | False |
The ID of the mega entity associated with the expense. |
| Record_url | String | False |
The URL link to the expense record. |