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