EXP_RPT_ID |
ColumnName | EXP_RPT_ID |
Definition | Name: Expense Report ID. Description: The unique identifier for the 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 | Name: Transaction Breakfast Amount. Description: The breakfast amount incurred in the transaction currency. |
TRANS_LUNCH_AMT |
ColumnName | TRANS_LUNCH_AMT |
Definition | Name: Transaction Lunch Amount. Description: The lunch amount incurred in the transaction currency. |
TRANS_DINNER_AMT |
ColumnName | TRANS_DINNER_AMT |
Definition | Name: Transaction Dinner Amount. Description: The dinner amount incurred in the transaction currency. |
TRANS_INCIDENTAL_AMT |
ColumnName | TRANS_INCIDENTAL_AMT |
Definition | Name: Transaction Incidental Amount. Description: The incidental amount incurred in the transaction currency. |
BASE_BREAKFAST_AMT |
ColumnName | BASE_BREAKFAST_AMT |
Definition | Name: Base Breakfast Amount. Description: The breakfast amount incurred in the system’s base currency. |
BASE_LUNCH_AMT |
ColumnName | BASE_LUNCH_AMT |
Definition | Name: Base Lunch Amount. Description: The lunch amount incurred in the system’s base currency. |
BASE_DINNER_AMT |
ColumnName | BASE_DINNER_AMT |
Definition | Name: Base Dinner Amount. Description: The dinner amount incurred in the system’s base currency. |
BASE_INCIDENTAL_AMT |
ColumnName | BASE_INCIDENTAL_AMT |
Definition | Name: Base Incidental Amount. Description: The incidental amount incurred in the system’s base currency. |
PAY_BREAKFAST_AMT |
ColumnName | PAY_BREAKFAST_AMT |
Definition | Name: Pay Breakfast Amount. Description: The breakfast amount incurred in the pay currency. |
PAY_LUNCH_AMT |
ColumnName | PAY_LUNCH_AMT |
Definition | Name: Pay Lunch Amount. Description: The lunch amount incurred in the pay currency. |
PAY_DINNER_AMT |
ColumnName | PAY_DINNER_AMT |
Definition | Name: Pay Dinner Amount. Description: The dinner amount incurred in the pay currency. |
PAY_INCIDENTAL_AMT |
ColumnName | PAY_INCIDENTAL_AMT |
Definition | Name: Pay Incidental Amount. Description: The incidental amount incurred in the pay currency. |
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 | Name: Daily Transaction Currency Personal Amount Description: The personal amount in transaction currency. |
BASE_PERSONAL_AMT |
ColumnName | BASE_PERSONAL_AMT |
Definition | Name: Daily Pay Currency Personal Amount Description: The personal amount in pay currency. |
PAY_PERSONAL_AMT |
ColumnName | PAY_PERSONAL_AMT |
Definition | Name: Daily Base Currency Personal Amount Description: The personal amount in system base currency. |