ColumnName |
Domain |
Datatype |
NULL |
Definition |
EXP_RPT_ID |
|
VARCHAR2(10) |
NO |
Name: Expense Report ID. Description: The unique identifier for the expense report. |
EXPENSE_ID |
|
NUMBER(10, 0) |
NO |
Name: Expense ID. Description: The unique identifier for the expense. |
EXP_DT |
|
DATE |
NO |
Name: Expense Date. Description: The date of the expense |
BREAKFAST_FL |
|
VARCHAR2(1) |
NO |
Name: Breakfast Flag. Description: Logical as to whether this expense is breakfast. |
LUNCH_FL |
|
VARCHAR2(1) |
NO |
Name: Lunch Flag. Description: Logical as to whether this expense is lunch. |
DINNER_FL |
|
VARCHAR2(1) |
NO |
Name: Dinner Flag. Description: Logical as to whether this expense is dinner. |
TRANS_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Transaction Currency Ceiling Amount. Description: The ceiling amount in transaction currency. |
TRANS_EXPENSE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Transaction Currency Expense Amount. Description: The net expense in the transaction currency. (INCURRED – OTHER) |
PAY_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Pay Currency Ceiling Amount. Description: The ceiling amount in pay currency. |
PAY_EXPENSE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Pay Currency Expense Amount. Description: The net expense in the pay currency. (INCURRED – OTHER) |
BASE_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Base Currency Ceiling Amount. Description: The ceiling amount in system base currency. |
BASE_EXPENSE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Base Currency Expense Amount. Description: The net expense in the system base currency. (INCURRED – OTHER) |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMBER(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |
INCIDENTAL_FL |
|
VARCHAR2(1) |
NO |
Name: Incidental Flag. Description: Logical as to whether expense included incidentals. |
TRANS_BREAKFAST_AMT |
|
NUMBER(15, 5) |
NO |
Name: Transaction Breakfast Amount. Description: The breakfast amount incurred in the transaction currency. |
TRANS_LUNCH_AMT |
|
NUMBER(15, 5) |
NO |
Name: Transaction Lunch Amount. Description: The lunch amount incurred in the transaction currency. |
TRANS_DINNER_AMT |
|
NUMBER(15, 5) |
NO |
Name: Transaction Dinner Amount. Description: The dinner amount incurred in the transaction currency. |
TRANS_INCIDENTAL_AMT |
|
NUMBER(15, 5) |
NO |
Name: Transaction Incidental Amount. Description: The incidental amount incurred in the transaction currency. |
BASE_BREAKFAST_AMT |
|
NUMBER(15, 5) |
NO |
Name: Base Breakfast Amount. Description: The breakfast amount incurred in the system’s base currency. |
BASE_LUNCH_AMT |
|
NUMBER(15, 5) |
NO |
Name: Base Lunch Amount. Description: The lunch amount incurred in the system’s base currency. |
BASE_DINNER_AMT |
|
NUMBER(15, 5) |
NO |
Name: Base Dinner Amount. Description: The dinner amount incurred in the system’s base currency. |
BASE_INCIDENTAL_AMT |
|
NUMBER(15, 5) |
NO |
Name: Base Incidental Amount. Description: The incidental amount incurred in the system’s base currency. |
PAY_BREAKFAST_AMT |
|
NUMBER(15, 5) |
NO |
Name: Pay Breakfast Amount. Description: The breakfast amount incurred in the pay currency. |
PAY_LUNCH_AMT |
|
NUMBER(15, 5) |
NO |
Name: Pay Lunch Amount. Description: The lunch amount incurred in the pay currency. |
PAY_DINNER_AMT |
|
NUMBER(15, 5) |
NO |
Name: Pay Dinner Amount. Description: The dinner amount incurred in the pay currency. |
PAY_INCIDENTAL_AMT |
|
NUMBER(15, 5) |
NO |
Name: Pay Incidental Amount. Description: The incidental amount incurred in the pay currency. |
TRANS_DAILY_ROOM_RATE |
|
NUMBER(15, 5) |
NO |
Name: Daily Transaction Currency Daily Room Rate Description: The daily room rate in transaction currency. |
TRANS_DAILY_TAX_RATE |
|
NUMBER(15, 5) |
NO |
Name: Daily Transaction Currency Daily Tax Rate Description: The daily room tax rate in transaction currency. |
TRANS_ADJUST_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Transaction Currency Over Ceiling Adjustment Amount Description: The over ceiling adjustment amount in transaction currency. |
TRANS_ADJUST_UNDER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Transaction Currency Under Ceiling Adjustment Amount Description: The under ceiling adjustment amount in transaction currency. |
TRANS_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Transaction Currency Over Ceiling Amount Description: The over ceiling amount in transaction currency. |
TRANS_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Transaction Currency Unallowable Amount Description: The unallowable amount in transaction currency. |
TRANS_NON_REIMBURSE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Transaction Currency Non-Reimbursable Amount Description: The non-reimbursable amount in transaction currency. |
ADJUSTMENT_REASON_TEXT |
|
VARCHAR2(254) |
YES |
|
BASE_DAILY_ROOM_RATE |
|
NUMBER(15, 5) |
NO |
Name: Daily Base Currency Daily Room Rate Description: The daily room rate in system base currency. |
BASE_DAILY_TAX_RATE |
|
NUMBER(15, 5) |
NO |
Name: Daily Base Currency Daily Tax Rate Description: The daily room tax rate in system base currency. |
BASE_ADJUST_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Base Currency Over Ceiling Adjustment Amount Description: The over ceiling adjustment amount in system base currency. |
BASE_ADJUST_UNDER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Base Currency Under Ceiling Adjustment Amount Description: The under ceiling adjustment amount in system base currency. |
BASE_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Base Currency Over Ceiling Amount Description: The over ceiling amount in system base currency. |
BASE_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Base Currency Unallowable Amount Description: The unallowable amount in system base currency. |
BASE_NON_REIMBURSE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Base Currency Non-Reimbursable Amount Description: The non-reimbursable amount in system base currency. |
PAY_DAILY_ROOM_RATE |
|
NUMBER(15, 5) |
NO |
Name: Daily Pay Currency Daily Room Rate Description: The daily room rate in pay currency. |
PAY_DAILY_TAX_RATE |
|
NUMBER(15, 5) |
NO |
Name: Daily Pay Currency Daily Tax Rate Description: The daily room tax rate in pay currency. |
PAY_ADJUST_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Pay Currency Over Ceiling Adjustment Amount Description: The over ceiling adjustment amount in pay currency. |
PAY_ADJUST_UNDER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Pay Currency Under Ceiling Adjustment Amount Description: The under ceiling adjustment amount in pay currency. |
PAY_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Pay Currency Over Ceiling Amount Description: The over ceiling amount in pay currency. |
PAY_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Pay Currency Unallowable Amount Description: The unallowable amount in pay currency. |
PAY_NON_REIMBURSE_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Pay Currency Non-Reimbursable Amount Description: The non-reimbursable amount in pay currency. |
PERSONAL_FL |
|
VARCHAR2(1) |
NO |
Name: Personal Flag Description: Logical as to whether this transaction is a personal expense. |
TRANS_PERSONAL_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Transaction Currency Personal Amount Description: The personal amount in transaction currency. |
BASE_PERSONAL_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Pay Currency Personal Amount Description: The personal amount in pay currency. |
PAY_PERSONAL_AMT |
|
NUMBER(15, 5) |
NO |
Name: Daily Base Currency Personal Amount Description: The personal amount in system base currency. |