ExpenseCashAdvances
Tracks employee cash advances for travel or business-related expenses, capturing key data such as status, requested amounts, and repayment details.
Columns
| Name | Type | Description |
| AdjustedAmount | Decimal | Amount specified by an auditor during an audit, used to reflect any adjustments made to the initial cash advance amount. |
| AdvanceStatus | String | Status of the cash advance, indicating its current stage or approval status. References the lookup type EXM_CASH_ADVANCE_STATUS for predefined values. |
| Amount | Decimal | Total amount of the cash advance requested by the employee, before any adjustments or payments. |
| AssignmentId | Long | Unique identifier for the assignment associated with the employee's request for a cash advance, used to track the specific job or role. |
| BusinessUnit | String | The business unit associated with the cash advance, representing the organizational segment responsible for the cash advance request. |
| CashAdvanceId [KEY] | Long | Unique identifier for a cash advance transaction, allowing the system to reference and track specific advance records. |
| CashAdvanceNumber | String | A unique number assigned to each cash advance to facilitate identification and tracking of the transaction. |
| CashAdvanceType | String | Type of cash advance requested. The default value is TRAVEL, with additional types defined in the lookup type EXM_CASH_ADVANCE_TYPE. |
| CreatedBy | String | The user who initially created the cash advance record, providing accountability and audit tracking. |
| CreationDate | Datetime | The date and time when the cash advance record was created, useful for tracking the history of the record. |
| Currency | String | The currency in which the cash advance is requested, indicating the monetary unit for the transaction. |
| CurrencyCode | String | The standardized code representing the currency of the cash advance (for example, USD, EUR). |
| EmployeeNumber | String | The unique employee number associated with the individual requesting the cash advance, used for payroll and Human Resources (HR) records. |
| ExchangeRate | Decimal | The exchange rate applied when converting the cash advance amount into a different currency, if applicable. |
| LastUpdateDate | Datetime | The date and time when the cash advance record was last updated, tracking changes or amendments to the record. |
| LastUpdateLogin | String | The session login identifier for the user who last modified the cash advance record, providing traceability of changes. |
| LastUpdatedBy | String | The user who made the last update to the cash advance record, enabling accountability for modifications. |
| Location | String | The geographic location related to the upcoming trip, used to associate the cash advance with a specific travel destination. |
| PaymentAmount | Decimal | The actual amount paid to the employee as part of the cash advance, after any necessary deductions or adjustments. |
| PaymentCurrency | String | The currency used for the payment made to the employee for the cash advance. |
| PaymentCurrencyCode | String | The code representing the currency used for the cash advance payment (for example, USD, GBP for British Pound). |
| PaymentMethodCode | String | The code indicating the payment method used to disburse the cash advance (for example, Direct Deposit, Check). |
| PersonId | Long | Unique identifier for the person requesting the cash advance, linking the request to their employee or contractor profile. |
| PersonName | String | Full name of the employee or contractor requesting the cash advance, used for identification purposes. |
| Purpose | String | A brief description of the purpose or reason for the cash advance, providing context for the request (for example, travel, office supplies). |
| SettlementDate | Date | The date when the cash advance is to be applied to an employee's expense report, ensuring proper reconciliation of funds. |
| StatusCode | String | A code representing the current status of the cash advance, such as Pending, Approved, or Paid, helping track its progress. |
| SubmittedDate | Date | The date when the cash advance was submitted for approval or processing, providing a timeline for the request. |
| TripEndDate | Date | The date when the trip associated with the cash advance is scheduled to end, helping track travel-related expenses. |
| TripId | Long | Unique identifier for the trip linked to the cash advance, allowing for better management of travel-related financials. |
| TripStartDate | Date | The date when the trip associated with the cash advance begins, serving as a reference point for travel expenses. |
| UnappliedAmount | Decimal | The remaining balance of the cash advance that has not yet been applied to an employee's expense report. |
| Description | String | A textual description of the cash advance, providing further details or context about the request. |
| SequoiaAdvanceStatus | String | The status of the Sequoia advance associated with the cash advance, tracking its specific workflow or approval process. |
| SequoiaStatusCode | String | A code that indicates the Sequoia status related to the cash advance, helping to monitor its integration with other systems. |
| Finder | String | A keyword or identifier used in searches related to cash advances or financial records, assisting in query filtering. |
| EffectiveDate | Date | A parameter used to fetch resources that are effective as of a specified start date, ensuring data is current as per business requirements. |