ExpenseAdjustments
Manages expense adjustment records, detailing changes, statuses, and related financial data.
Columns
| Name | Type | ReadOnly | Description |
| Recordid [KEY] | String | False |
Unique identifier for the expense adjustment record. |
| Contact_lastname | String | False |
Last name of the contact associated with the expense adjustment. |
| Contact_firstname | String | False |
First name of the contact associated with the expense adjustment. |
| Recordno | String | False |
Internal record number for the expense adjustment. |
| Whencreated | Datetime | False |
Timestamp when the expense adjustment was created. |
| Whenposted | Datetime | False |
Timestamp when the expense adjustment was posted. |
| Totalentered | Double | False |
Total amount entered for the expense adjustment. |
| State | String | False |
Current state or status of the expense adjustment. |
| Totalpaid | Double | False |
Total amount paid for the expense adjustment. |
| Totalselected | Double | False |
Total amount selected for processing in the expense adjustment. |
| Totaldue | Double | False |
Total amount due for the expense adjustment. |
| Recordtype | String | False |
Type of record associated with the expense adjustment. |
| Systemgenerated | String | False |
Indicates whether the record was system-generated. |
| Prbatch | String | False |
Batch identifier associated with the expense adjustment. |
| Prbatchkey | Int64 | False |
Key referencing the batch associated with the expense adjustment. |
| Empentity | String | False |
Entity associated with the employee for the expense adjustment. |
| Description | String | False |
Description of the expense adjustment. |
| Whenpaid | Datetime | False |
Timestamp when the payment for the adjustment was made. |
| Whenmodified | Datetime | False |
Timestamp when the expense adjustment was last modified. |
| Currency | String | False |
Currency used for the expense adjustment. |
| Basecurr | String | False |
Base currency used for the expense adjustment. |
| Entity | String | False |
Entity associated with the expense adjustment. |
| Userkey | String | False |
Key referencing the user associated with the expense adjustment. |
| Employeeid | String | False |
Identifier for the employee associated with the expense adjustment. |
| Docnumber | String | False |
Document number associated with the expense adjustment. |
| Nr_totalentered | Double | False |
Non-reconciled total amount entered for the expense adjustment. |
| Nr_trx_totalentered | Double | False |
Non-reconciled transaction total amount entered in the original currency. |
| Auwhencreated | Datetime | False |
Audit timestamp when the expense adjustment was created. |
| Createdby | Int64 | False |
Identifier of the user who created the expense adjustment. |
| Modifiedby | Int64 | False |
Identifier of the user who last modified the expense adjustment. |
| Megaentitykey | Int64 | False |
Key referencing the mega-entity associated with the adjustment. |
| Megaentityid | String | False |
Identifier of the mega-entity associated with the adjustment. |
| Record_url | String | False |
URL link to the expense adjustment record in the system. |