ColumnName |
Domain |
Datatype |
NULL |
Definition |
EXP_RPT_ID |
|
VARCHAR2(10) |
YES |
|
EXPENSE_ID |
|
NUMBER(10, 0) |
YES |
|
EXP_DT |
|
DATE |
YES |
|
BREAKFAST_FL |
|
VARCHAR2(1) |
YES |
|
LUNCH_FL |
|
VARCHAR2(1) |
YES |
|
DINNER_FL |
|
VARCHAR2(1) |
YES |
|
TRANS_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
|
TRANS_EXPENSE_AMT |
|
NUMBER(15, 5) |
YES |
|
PAY_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
|
PAY_EXPENSE_AMT |
|
NUMBER(15, 5) |
YES |
|
BASE_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
|
BASE_EXPENSE_AMT |
|
NUMBER(15, 5) |
YES |
|
MODIFIED_BY |
|
VARCHAR2(20) |
YES |
|
ROWVERSION |
|
NUMBER(10, 0) |
YES |
|
TIME_STAMP |
|
DATE |
YES |
|
INCIDENTAL_FL |
|
VARCHAR2(1) |
YES |
|
TRANS_BREAKFAST_AMT |
|
NUMBER(15, 5) |
YES |
|
TRANS_LUNCH_AMT |
|
NUMBER(15, 5) |
YES |
|
TRANS_DINNER_AMT |
|
NUMBER(15, 5) |
YES |
|
TRANS_INCIDENTAL_AMT |
|
NUMBER(15, 5) |
YES |
|
BASE_BREAKFAST_AMT |
|
NUMBER(15, 5) |
YES |
|
BASE_LUNCH_AMT |
|
NUMBER(15, 5) |
YES |
|
BASE_DINNER_AMT |
|
NUMBER(15, 5) |
YES |
|
BASE_INCIDENTAL_AMT |
|
NUMBER(15, 5) |
YES |
|
PAY_BREAKFAST_AMT |
|
NUMBER(15, 5) |
YES |
|
PAY_LUNCH_AMT |
|
NUMBER(15, 5) |
YES |
|
PAY_DINNER_AMT |
|
NUMBER(15, 5) |
YES |
|
PAY_INCIDENTAL_AMT |
|
NUMBER(15, 5) |
YES |
|
TRANS_DAILY_ROOM_RATE |
|
NUMBER(15, 5) |
YES |
|
TRANS_DAILY_TAX_RATE |
|
NUMBER(15, 5) |
YES |
|
TRANS_ADJUST_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
|
TRANS_ADJUST_UNDER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
|
TRANS_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
|
TRANS_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
YES |
|
TRANS_NON_REIMBURSE_AMT |
|
NUMBER(15, 5) |
YES |
|
ADJUSTMENT_REASON_TEXT |
|
VARCHAR2(254) |
YES |
|
BASE_DAILY_ROOM_RATE |
|
NUMBER(15, 5) |
YES |
|
BASE_DAILY_TAX_RATE |
|
NUMBER(15, 5) |
YES |
|
BASE_ADJUST_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
|
BASE_ADJUST_UNDER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
|
BASE_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
|
BASE_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
YES |
|
BASE_NON_REIMBURSE_AMT |
|
NUMBER(15, 5) |
YES |
|
PAY_DAILY_ROOM_RATE |
|
NUMBER(15, 5) |
YES |
|
PAY_DAILY_TAX_RATE |
|
NUMBER(15, 5) |
YES |
|
PAY_ADJUST_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
|
PAY_ADJUST_UNDER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
|
PAY_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
|
PAY_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
YES |
|
PAY_NON_REIMBURSE_AMT |
|
NUMBER(15, 5) |
YES |
|
PERSONAL_FL |
|
VARCHAR2(1) |
YES |
|
TRANS_PERSONAL_AMT |
|
NUMBER(15, 5) |
YES |
|
BASE_PERSONAL_AMT |
|
NUMBER(15, 5) |
YES |
|
PAY_PERSONAL_AMT |
|
NUMBER(15, 5) |
YES |
|