ColumnName |
Domain |
Datatype |
NULL |
Definition |
EXP_RPT_ID |
|
VARCHAR2(10) |
NO |
|
EXPENSE_ID |
|
NUMBER(10, 0) |
NO |
|
PARENT_EXPENSE_ID |
|
NUMBER(10, 0) |
YES |
|
EXP_CATEGORY_CD |
|
VARCHAR2(10) |
NO |
|
EXP_TYPE_CD |
|
VARCHAR2(10) |
NO |
|
EXP_DT |
|
DATE |
NO |
|
S_RECEIPT_STATUS_CD |
|
VARCHAR2(1) |
NO |
|
RECEIPT_DTT |
|
DATE |
YES |
|
PROVIDER_CD |
|
VARCHAR2(20) |
YES |
|
EXPENSE_TEXT |
|
VARCHAR2(120) |
YES |
|
OVER_CEILING_REASON_TEXT |
|
VARCHAR2(254) |
YES |
|
TICKET_NUMBER_S |
|
VARCHAR2(20) |
YES |
|
DEPARTURE_DTT |
|
DATE |
YES |
|
RETURN_DTT |
|
DATE |
YES |
|
BREAKFAST_FL |
|
VARCHAR2(1) |
NO |
|
LUNCH_FL |
|
VARCHAR2(1) |
NO |
|
DINNER_FL |
|
VARCHAR2(1) |
NO |
|
START_ODOMETER_NO |
|
NUMBER(15, 5) |
NO |
|
END_ODOMETER_NO |
|
NUMBER(15, 5) |
NO |
|
PERSONAL_MILES_KM_NO |
|
NUMBER(15, 5) |
NO |
|
UNIT_NO |
|
NUMBER(15, 5) |
NO |
|
PAY_METHOD_CD |
|
VARCHAR2(10) |
NO |
|
TRANS_CURRENCY_CD |
|
VARCHAR2(3) |
NO |
|
USER_EXCHANGE_RATE |
|
NUMBER(20, 10) |
NO |
|
TRANS_PAY_EXCHANGE_RATE |
|
NUMBER(20, 10) |
NO |
|
TRANS_BASE_EXCHANGE_RATE |
|
NUMBER(20, 10) |
NO |
|
TRANS_UNIT_RATE |
|
NUMBER(15, 5) |
NO |
|
TRANS_DAILY_ROOM_RATE |
|
NUMBER(15, 5) |
NO |
|
TRANS_DAILY_TAX_RATE |
|
NUMBER(15, 5) |
NO |
|
TRANS_INCURRED_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_COMPANY_PAID_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_PERSONAL_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_NON_REIMBURSE_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_OTHER_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_EXPENSE_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_BILLABLE_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_NON_BILLABLE_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_UNIT_RATE |
|
NUMBER(15, 5) |
NO |
|
PAY_DAILY_ROOM_RATE |
|
NUMBER(15, 5) |
NO |
|
PAY_DAILY_TAX_RATE |
|
NUMBER(15, 5) |
NO |
|
PAY_INCURRED_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_COMPANY_PAID_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_PERSONAL_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_NON_REIMBURSE_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_OTHER_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_EXPENSE_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_BILLABLE_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_NON_BILLABLE_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_UNIT_RATE |
|
NUMBER(15, 5) |
NO |
|
BASE_DAILY_ROOM_RATE |
|
NUMBER(15, 5) |
NO |
|
BASE_DAILY_TAX_RATE |
|
NUMBER(15, 5) |
NO |
|
BASE_INCURRED_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_COMPANY_PAID_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_PERSONAL_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_NON_REIMBURSE_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_OTHER_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_EXPENSE_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_BILLABLE_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_NON_BILLABLE_AMT |
|
NUMBER(15, 5) |
NO |
|
START_DT |
|
DATE |
NO |
|
END_DT |
|
DATE |
NO |
|
DAYS_NIGHTS_NO |
|
NUMBER(6, 0) |
NO |
|
ADJUSTMENT_FL |
|
VARCHAR2(1) |
NO |
|
CREDIT_UDT01_ID |
|
VARCHAR2(50) |
YES |
|
CREDIT_UDT02_ID |
|
VARCHAR2(50) |
YES |
|
CREDIT_UDT03_ID |
|
VARCHAR2(20) |
YES |
|
CREDIT_UDT04_ID |
|
VARCHAR2(20) |
YES |
|
CREDIT_UDT05_ID |
|
VARCHAR2(20) |
YES |
|
CREDIT_UDT06_ID |
|
VARCHAR2(20) |
YES |
|
CREDIT_UDT07_ID |
|
VARCHAR2(20) |
YES |
|
CREDIT_UDT08_ID |
|
VARCHAR2(20) |
YES |
|
CREDIT_UDT09_ID |
|
VARCHAR2(20) |
YES |
|
CREDIT_UDT10_ID |
|
VARCHAR2(20) |
YES |
|
CREDIT_UDT06_CP_COMPANY_CD |
|
VARCHAR2(10) |
YES |
|
CREDIT_UDT07_CP_COMPANY_CD |
|
VARCHAR2(10) |
YES |
|
CREDIT_EXPENSE_REF_CD |
|
VARCHAR2(20) |
YES |
|
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
|
ROWVERSION |
|
NUMBER(10, 0) |
NO |
|
TIME_STAMP |
|
DATE |
NO |
|
ITINERARY_TEXT |
|
VARCHAR2(60) |
YES |
|
ADJUSTMENT_REASON_TEXT |
|
VARCHAR2(254) |
YES |
|
TRANS_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_ADJUST_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_ADJUST_UNDER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_ADJUST_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_ADJUST_UNDER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_ADJUST_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_ADJUST_UNDER_CEILING_AMT |
|
NUMBER(15, 5) |
NO |
|
VENDOR_ID |
|
VARCHAR2(20) |
NO |
|
RECEIPT_EMPL_ID |
|
VARCHAR2(20) |
YES |
|
LATE_FL |
|
VARCHAR2(1) |
NO |
|
PAY_MEAL_DEDUCTION_AMT |
|
NUMBER(15, 5) |
NO |
|
CODE1_CD |
|
VARCHAR2(20) |
YES |
|
CODE2_CD |
|
VARCHAR2(20) |
YES |
|
CODE3_CD |
|
VARCHAR2(20) |
YES |
|
COMMENTS_TEXT |
|
VARCHAR2(254) |
YES |
|
VALIDATED_FL |
|
VARCHAR2(1) |
NO |
|
TAX_SCHEDULE_CD |
|
VARCHAR2(10) |
YES |
|
TAX_LOCATION_S |
|
VARCHAR2(20) |
YES |
|
TAX_ID_S |
|
VARCHAR2(20) |
YES |
|
TRANS_TAX_RATE1_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_TAX_RATE2_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_TAX_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_TAX_RATE1_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_TAX_RATE2_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_TAX_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_TAX_RATE1_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_TAX_RATE2_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_TAX_AMT |
|
NUMBER(15, 5) |
NO |
|
TAX_RECOVERY_RATE1_PCT |
|
NUMBER(3, 2) |
NO |
|
TAX_RECOVERY_RATE2_PCT |
|
NUMBER(3, 2) |
NO |
|
TRANS_TAX_RECOVERY_RATE1_AMT |
|
NUMBER(15, 5) |
NO |
|
TRANS_TAX_RECOVERY_RATE2_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_TAX_RECOVERY_RATE1_AMT |
|
NUMBER(15, 5) |
NO |
|
PAY_TAX_RECOVERY_RATE2_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_TAX_RECOVERY_RATE1_AMT |
|
NUMBER(15, 5) |
NO |
|
BASE_TAX_RECOVERY_RATE2_AMT |
|
NUMBER(15, 5) |
NO |
|
EXP_RPT_TYPE_CD |
|
VARCHAR2(10) |
NO |
|
MISSING_RECEIPT_REASON_TEXT |
|
VARCHAR2(254) |
YES |
|
S_RECEIPT_SUBMIT_STATUS_CD |
|
VARCHAR2(1) |
NO |
|
INCIDENTAL_FL |
|
VARCHAR2(1) |
NO |
|
CREDIT_UDT11_ID |
|
VARCHAR2(20) |
YES |
|
CREDIT_UDT12_ID |
|
VARCHAR2(20) |
YES |
|
CREDIT_UDT13_ID |
|
VARCHAR2(20) |
YES |
|
CREDIT_UDT14_ID |
|
VARCHAR2(20) |
YES |
|
CREDIT_UDT15_ID |
|
VARCHAR2(20) |
YES |
|
UNALLOWABLE_REASON_TEXT |
|
VARCHAR2(254) |
YES |
|
SAVE_WARNING_TEXT |
|
VARCHAR2(1000) |
YES |
|
FIRST_DAY_TRIP_FL |
|
VARCHAR2(1) |
NO |
|
LAST_DAY_TRIP_FL |
|
VARCHAR2(1) |
NO |
|
TAXES_DISTRIBUTED_FL |
|
VARCHAR2(1) |
NO |
|
CONFERENCE_FL |
|
VARCHAR2(1) |
NO |
|
LOCATION_ID |
|
VARCHAR2(40) |
YES |
|
LOCATION_NO |
|
NUMBER(10, 0) |
YES |
|
MERCHANT_NAME |
|
VARCHAR2(40) |
YES |
|