EXM_CASH_ADVANCES
This table contains the details of the travel advances issued to employees, such as cash advance number, advance amount, status of the advance, amount applied to the expense report, and the cash advance balance.
Details
-
Schema: FUSION
-
Object owner: EXM
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
EXM_CASH_ADVANCES_PK |
CASH_ADVANCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CASH_ADVANCE_ID | NUMBER | 18 | Yes | Surrogate key that identifies a row in this table. | |
| SUBMITTER_ID | NUMBER | 18 | Person who submits the cash advance. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| TRIP_ID | NUMBER | 18 | Trip for which the cash advance was requested. | ||
| CASH_ADVANCE_NUMBER | VARCHAR2 | 60 | Yes | Cash advance number is the document number used to identify a cash advance. | |
| PERSON_ID | NUMBER | 18 | Person requesting the cash advance. | ||
| ASSIGNMENT_ID | NUMBER | 18 | Assignment of the person requesting the cash advance. | ||
| CASH_ADVANCE_TYPE | VARCHAR2 | 30 | Type of cash advance. Default value is 'TRAVEL'. References new lookup type EXM_CASH_ADVANCE_TYPE. | ||
| DESCRIPTION | VARCHAR2 | 240 | Description of the cash advance. | ||
| PURPOSE | VARCHAR2 | 240 | Purpose for requesting cash advance. | ||
| TRIP_START_DATE | DATE | Planned start date of trip if advance is requested for an upcoming trip. | |||
| TRIP_END_DATE | DATE | Planned end date of trip if advance is requested for an upcoming trip. | |||
| AMOUNT | NUMBER | Cash advance amount. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code for cash amount. | ||
| PAYMENT_AMOUNT | NUMBER | Amount paid to employee. | |||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | 15 | Currency code for the amount paid to employee. | ||
| EXCHANGE_RATE | NUMBER | Exchange rate used for payment to employee. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Exchange rate type used for payment to employee. | ||
| SUBMITTED_DATE | DATE | Date when cash advance was submitted. | |||
| ADJUSTED_AMOUNT | NUMBER | Amount specified by an auditor during audit. | |||
| UNAPPLIED_AMOUNT | NUMBER | Outstanding balance in payment currency that remains to be applied towards expense reports. | |||
| SETTLEMENT_DATE | DATE | Date by which the cash advance should be applied towards an expense report. | |||
| STATUS_CODE | VARCHAR2 | 30 | Status of the cash advance. References lookup type EXM_CASH_ADVANCE_STATUS. | ||
| PAYMENT_METHOD_CODE | VARCHAR2 | 120 | Payment method for the cash advance | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| EXPORT_REJECT_CODE | VARCHAR2 | 30 | Rejection code from process reimbursement | ||
| LAST_AUDITED_BY | NUMBER | 18 | Auditor who last audited the cash advance. | ||
| AUDIT_RETURN_REASON_CODE | VARCHAR2 | 30 | Reason for auditor to reject the cash advance request. | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| APPROVAL_CORRELATION_ID | VARCHAR2 | 64 | Correlation ID to track approval process related to the cash advance. | ||
| OVERDUE_CORRELATION_ID | VARCHAR2 | 64 | Correlation ID to track overdue process related to the cash advance. | ||
| LOCATION | VARCHAR2 | 200 | Location of the upcoming trip. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | 240 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| exm_cash_adv_applications | exm_cash_advances | CASH_ADVANCE_ID |
| exm_cash_adv_history | exm_cash_advances | CASH_ADVANCE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EXM_CASH_ADVANCES_N1 | Non Unique | Default | PERSON_ID |
| EXM_CASH_ADVANCES_N2 | Non Unique | Default | UPPER("CASH_ADVANCE_NUMBER") |
| EXM_CASH_ADVANCES_N3 | Non Unique | Default | ORG_ID, PERSON_ID |
| EXM_CASH_ADVANCES_N4 | Non Unique | Default | STATUS_CODE |
| EXM_CASH_ADVANCES_PK | Unique | Default | CASH_ADVANCE_ID |