ExpenseAdjustmentsItem
Provides line-level details for expense adjustments, documenting accounts, amounts, and allocations.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the expense adjustment item record. |
| Recordkey | Int64 | Key referencing the specific record within the expense adjustment. |
| Accountkey | Int64 | Key identifying the account associated with the expense adjustment item. |
| Entry_date | Datetime | Date when the entry for the expense adjustment item was made. |
| Description | String | Description of the expense adjustment item. |
| Description2 | String | Additional description or notes for the expense adjustment item. |
| Glaccountno | String | General ledger account number associated with the adjustment item. |
| Glaccounttitle | String | Title or name of the general ledger account. |
| Amount | Double | Amount for the expense adjustment item. |
| Locationid | String | Identifier for the location related to the adjustment item. |
| Locationname | String | Name of the location related to the adjustment item. |
| Departmentid | String | Identifier for the department associated with the adjustment item. |
| Departmentname | String | Name of the department associated with the adjustment item. |
| Line_no | String | Line number of the expense adjustment item. |
| Accountlabel | String | Label or alias for the account associated with the adjustment item. |
| Totalselected | Double | Total amount selected for processing in the expense adjustment item. |
| Totalpaid | Double | Total amount paid for the expense adjustment item. |
| Trx_amount | Double | Transaction amount in the original currency for the adjustment item. |
| Trx_totalselected | Double | Total amount selected for processing in the original currency for the adjustment item. |
| Trx_totalpaid | Double | Total paid amount in the original currency for the adjustment item. |
| Billable | Boolean | Indicates whether the adjustment item is billable to a customer. |
| Billed | Boolean | Indicates whether the adjustment item has been billed. |
| State | String | Current state or status of the adjustment item. |
| Form1099 | String | Indicates whether the adjustment item is associated with Form 1099 reporting. |
| Exppmttypekey | Int64 | Key identifying the expense payment type associated with the adjustment item. |
| Exppmttype | String | Expense payment type associated with the adjustment item. |
| Nonreimbursable | Boolean | Indicates whether the adjustment item is non-reimbursable. |
| Nr_amount | Double | Non-reconciled amount for the expense adjustment item. |
| Nr_trx_amount | Double | Non-reconciled transaction amount in the original currency for the adjustment item. |
| Quantity | Double | Quantity associated with the adjustment item. |
| Unitrate | String | Unit rate applied to the adjustment item. |
| Createdby | Int64 | Identifier of the user who created the adjustment item. |
| Modifiedby | Int64 | Identifier of the user who last modified the adjustment item. |
| Whencreated | Datetime | Timestamp when the adjustment item was created. |
| Whenmodified | Datetime | Timestamp when the adjustment item was last modified. |
| Recordtype | String | Type of record associated with the adjustment item. |
| Projectdimkey | Int64 | Key referencing the project dimension associated with the adjustment item. |
| Projectid | String | Identifier for the project associated with the adjustment item. |
| Projectname | String | Name of the project associated with the adjustment item. |
| Customerdimkey | Int64 | Key referencing the customer dimension associated with the adjustment item. |
| Customerid | String | Identifier for the customer associated with the adjustment item. |
| Customername | String | Name of the customer associated with the adjustment item. |
| Vendordimkey | Int64 | Key referencing the vendor dimension associated with the adjustment item. |
| Vendorid | String | Identifier for the vendor associated with the adjustment item. |
| Vendorname | String | Name of the vendor associated with the adjustment item. |
| Itemdimkey | Int64 | Key referencing the item dimension associated with the adjustment item. |
| Itemid | String | Identifier for the item associated with the adjustment item. |
| Itemname | String | Name of the item associated with the adjustment item. |
| Classdimkey | Int64 | Key referencing the class dimension associated with the adjustment item. |
| Classid | String | Identifier for the class associated with the adjustment item. |
| Classname | String | Name of the class associated with the adjustment item. |
| Record_url | String | URL link to the expense adjustment item record in the system. |