EXP_RPT_ID 
ColumnName  EXP_RPT_ID 
Definition 
Name: Expense Report ID. Description: The unique identifier for the expense report.
 

CORRECTION_NO 
ColumnName  CORRECTION_NO 
Definition 
Name: Correction Number. Description: The correction number used for this expense report.
 

EXPENSE_ID 
ColumnName  EXPENSE_ID 
Definition 
Name: Expense ID. Description: The unique identifier for the expense.
 

EXP_DT 
ColumnName  EXP_DT 
Definition 
Name: Expense Date. Description: The date of the expense.
 

BREAKFAST_FL 
ColumnName  BREAKFAST_FL 
Definition 
Name: Breakfast Flag. Description: Logical as to whether this expense is breakfast.
 

LUNCH_FL 
ColumnName  LUNCH_FL 
Definition 
Name: Lunch Flag. Description: Logical as to whether this expense is lunch.
 

DINNER_FL 
ColumnName  DINNER_FL 
Definition 
Name: Dinner Flag. Description: Logical as to whether this expense is dinner.
 

TRANS_CEILING_AMT 
ColumnName  TRANS_CEILING_AMT 
Definition 
Name: Transaction Currency Ceiling Amount. Description: The ceiling amount in transaction currency.
 

TRANS_EXPENSE_AMT 
ColumnName  TRANS_EXPENSE_AMT 
Definition 
Name: Transaction Currency Expense Amount. Description: The net expense in the transaction currency. (INCURRED – OTHER).
 

PAY_CEILING_AMT 
ColumnName  PAY_CEILING_AMT 
Definition 
Name: Pay Currency Ceiling Amount. Description: The ceiling amount in pay currency.
 

PAY_EXPENSE_AMT 
ColumnName  PAY_EXPENSE_AMT 
Definition 
Name: Pay Currency Expense Amount. Description: The net expense in the pay currency. , (INCURRED – OTHER).
 

BASE_CEILING_AMT 
ColumnName  BASE_CEILING_AMT 
Definition 
Name: Base Currency Ceiling Amount. Description: The ceiling amount in system base currency.
 

BASE_EXPENSE_AMT 
ColumnName  BASE_EXPENSE_AMT 
Definition 
Name: Base Currency Expense Amount. Description: The net expense in the system base currency. , (INCURRED – OTHER).
 

MODIFIED_BY 
ColumnName  MODIFIED_BY 
Definition 
Name: Modified By. Description: The User ID of the person who last modified this record.
 

ROWVERSION 
ColumnName  ROWVERSION 
Definition 
Name: Row Version. Description: The number of times this record has been updated.
 

TIME_STAMP 
ColumnName  TIME_STAMP 
Definition 
Name: Time Stamp. Description: Date and time the record was last modified.
 

INCIDENTAL_FL 
ColumnName  INCIDENTAL_FL 
Definition 
Name: Incidental Flag. Description: Logical as to whether expense included incidentals.
 

TRANS_BREAKFAST_AMT 
ColumnName  TRANS_BREAKFAST_AMT 
Definition 
 

TRANS_LUNCH_AMT 
ColumnName  TRANS_LUNCH_AMT 
Definition 
 

TRANS_DINNER_AMT 
ColumnName  TRANS_DINNER_AMT 
Definition 
 

TRANS_INCIDENTAL_AMT 
ColumnName  TRANS_INCIDENTAL_AMT 
Definition 
 

BASE_BREAKFAST_AMT 
ColumnName  BASE_BREAKFAST_AMT 
Definition 
 

BASE_LUNCH_AMT 
ColumnName  BASE_LUNCH_AMT 
Definition 
 

BASE_DINNER_AMT 
ColumnName  BASE_DINNER_AMT 
Definition 
 

BASE_INCIDENTAL_AMT 
ColumnName  BASE_INCIDENTAL_AMT 
Definition 
 

PAY_BREAKFAST_AMT 
ColumnName  PAY_BREAKFAST_AMT 
Definition 
 

PAY_LUNCH_AMT 
ColumnName  PAY_LUNCH_AMT 
Definition 
 

PAY_DINNER_AMT 
ColumnName  PAY_DINNER_AMT 
Definition 
 

PAY_INCIDENTAL_AMT 
ColumnName  PAY_INCIDENTAL_AMT 
Definition 
 

TRANS_DAILY_ROOM_RATE 
ColumnName  TRANS_DAILY_ROOM_RATE 
Definition 
Name: Daily Transaction Currency Daily Room Rate Description: The daily room rate in transaction currency.
 

TRANS_DAILY_TAX_RATE 
ColumnName  TRANS_DAILY_TAX_RATE 
Definition 
Name: Daily Transaction Currency Daily Tax Rate  Description: The daily room tax rate in transaction currency.
 

TRANS_ADJUST_OVER_CEILING_AMT 
ColumnName  TRANS_ADJUST_OVER_CEILING_AMT 
Definition 
Name: Daily Transaction Currency Over Ceiling Adjustment Amount  Description: The over ceiling adjustment amount in transaction currency.
 

TRANS_ADJUST_UNDER_CEILING_AMT 
ColumnName  TRANS_ADJUST_UNDER_CEILING_AMT 
Definition 
Name: Daily Transaction Currency Under Ceiling Adjustment Amount  Description: The under ceiling adjustment amount in transaction currency.
 

TRANS_OVER_CEILING_AMT 
ColumnName  TRANS_OVER_CEILING_AMT 
Definition 
Name: Daily Transaction Currency Over Ceiling Amount  Description: The over ceiling amount in transaction currency.
 

TRANS_UNALLOWABLE_AMT 
ColumnName  TRANS_UNALLOWABLE_AMT 
Definition 
Name: Daily Transaction Currency Unallowable Amount  Description: The unallowable amount in transaction currency.
 

TRANS_NON_REIMBURSE_AMT 
ColumnName  TRANS_NON_REIMBURSE_AMT 
Definition 
Name: Transaction Currency Non-Reimbursable Amount  Description: The non-reimbursable amount in transaction currency.
 

ADJUSTMENT_REASON_TEXT 
ColumnName  ADJUSTMENT_REASON_TEXT 
Definition 
 

BASE_DAILY_ROOM_RATE 
ColumnName  BASE_DAILY_ROOM_RATE 
Definition 
Name: Daily Base Currency Daily Room Rate  Description: The daily room rate in system base currency.
 

BASE_DAILY_TAX_RATE 
ColumnName  BASE_DAILY_TAX_RATE 
Definition 
Name: Daily Base Currency Daily Tax Rate  Description: The daily room tax rate in system base currency.
 

BASE_ADJUST_OVER_CEILING_AMT 
ColumnName  BASE_ADJUST_OVER_CEILING_AMT 
Definition 
Name: Daily Base Currency Over Ceiling Adjustment Amount  Description: The over ceiling adjustment amount in system base currency.
 

BASE_ADJUST_UNDER_CEILING_AMT 
ColumnName  BASE_ADJUST_UNDER_CEILING_AMT 
Definition 
Name: Daily Base Currency Under Ceiling Adjustment Amount  Description: The under ceiling adjustment amount in system base currency.
 

BASE_OVER_CEILING_AMT 
ColumnName  BASE_OVER_CEILING_AMT 
Definition 
Name: Daily Base Currency Over Ceiling Amount  Description: The over ceiling amount in system base currency.
 

BASE_UNALLOWABLE_AMT 
ColumnName  BASE_UNALLOWABLE_AMT 
Definition 
Name: Daily Base Currency Unallowable Amount  Description: The unallowable amount in system base currency.
 

BASE_NON_REIMBURSE_AMT 
ColumnName  BASE_NON_REIMBURSE_AMT 
Definition 
Name: Daily Base Currency Non-Reimbursable Amount  Description: The non-reimbursable amount in system base currency.
 

PAY_DAILY_ROOM_RATE 
ColumnName  PAY_DAILY_ROOM_RATE 
Definition 
Name: Daily Pay Currency Daily Room Rate  Description: The daily room rate in pay currency.
 

PAY_DAILY_TAX_RATE 
ColumnName  PAY_DAILY_TAX_RATE 
Definition 
Name: Daily Pay Currency Daily Tax Rate  Description: The daily room tax rate in pay currency.
 

PAY_ADJUST_OVER_CEILING_AMT 
ColumnName  PAY_ADJUST_OVER_CEILING_AMT 
Definition 
Name: Daily Pay Currency Over Ceiling Adjustment Amount  Description: The over ceiling adjustment amount in pay currency.
 

PAY_ADJUST_UNDER_CEILING_AMT 
ColumnName  PAY_ADJUST_UNDER_CEILING_AMT 
Definition 
Name: Daily Pay Currency Under Ceiling Adjustment Amount  Description: The under ceiling adjustment amount in pay currency.
 

PAY_OVER_CEILING_AMT 
ColumnName  PAY_OVER_CEILING_AMT 
Definition 
Name: Daily Pay Currency Over Ceiling Amount  Description: The over ceiling amount in pay currency.
 

PAY_UNALLOWABLE_AMT 
ColumnName  PAY_UNALLOWABLE_AMT 
Definition 
Name: Daily Pay Currency Unallowable Amount  Description: The unallowable amount in pay currency.
 

PAY_NON_REIMBURSE_AMT 
ColumnName  PAY_NON_REIMBURSE_AMT 
Definition 
Name: Daily Pay Currency Non-Reimbursable Amount  Description: The non-reimbursable amount in pay currency.
 

PERSONAL_FL 
ColumnName  PERSONAL_FL 
Definition 
Name: Personal Flag Description: Logical as to whether this transaction is a personal expense.
 

TRANS_PERSONAL_AMT 
ColumnName  TRANS_PERSONAL_AMT 
Definition 
 

BASE_PERSONAL_AMT 
ColumnName  BASE_PERSONAL_AMT 
Definition 
 

PAY_PERSONAL_AMT 
ColumnName  PAY_PERSONAL_AMT 
Definition