EXP_RPT_ID 
ColumnName  EXP_RPT_ID 
Definition 
Name: Expense Report ID. Description: The unique identifier for the correcting 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: Synthetic.
 

PARENT_EXPENSE_ID 
ColumnName  PARENT_EXPENSE_ID 
Definition 
Name: Parent Expense ID. Description: The expense ID of the expense if this expense was generated from it.
 

EXP_CATEGORY_CD 
ColumnName  EXP_CATEGORY_CD 
Definition 
Name: Expense Category. Description: The category of the expense.
 

EXP_TYPE_CD 
ColumnName  EXP_TYPE_CD 
Definition 
Name: Expense Type. Description: The type of the expense.
 

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

S_RECEIPT_STATUS_CD 
ColumnName  S_RECEIPT_STATUS_CD 
Definition 
Name: Receipt Status. Description: The system assigned receipt status code. Values are:, P – Pending, R- Received, N – Not Applicable.
 

RECEIPT_DTT 
ColumnName  RECEIPT_DTT 
Definition 
Name: Receipt Date. Description: The date time the receipt was received.
 

PROVIDER_CD 
ColumnName  PROVIDER_CD 
Definition 
Name: Provide. Description: The provider of the service for the expense.
 

EXPENSE_TEXT 
ColumnName  EXPENSE_TEXT 
Definition 
Name: Expense Description. Description: Description of expense.
 

OVER_CEILING_REASON_TEXT 
ColumnName  OVER_CEILING_REASON_TEXT 
Definition 
Name: Over Ceiling Reason. Description: Reason for over ceiling amount.
 

TICKET_NUMBER_S 
ColumnName  TICKET_NUMBER_S 
Definition 
Name: Ticket Number. Description: The ticket number.
 

DEPARTURE_DTT 
ColumnName  DEPARTURE_DTT 
Definition 
Name: Departure Date Time. Description: The departure date time.
 

RETURN_DTT 
ColumnName  RETURN_DTT 
Definition 
Name: Return Date Time. Description: The return date time.
 

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

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

DINNER_FL 
ColumnName  DINNER_FL 
Definition 
Name: Dinner flag. Description: Logical as to whether expense included dinner.
 

START_ODOMETER_NO 
ColumnName  START_ODOMETER_NO 
Definition 
Name: Start Units. Description: The starting number of miles KM on the odometer.
 

END_ODOMETER_NO 
ColumnName  END_ODOMETER_NO 
Definition 
Name: End Units. Description: The ending number of miles KM on the odometer.
 

PERSONAL_MILES_KM_NO 
ColumnName  PERSONAL_MILES_KM_NO 
Definition 
Name: Personal Units. Description: The number of personal miles incurred.
 

UNIT_NO 
ColumnName  UNIT_NO 
Definition 
Name: Number of Units. Description: The number of units to be expensed.
 

PAY_METHOD_CD 
ColumnName  PAY_METHOD_CD 
Definition 
Name: Pay Method. Description: User-specified unique identifier for the pay method.
 

TRANS_CURRENCY_CD 
ColumnName  TRANS_CURRENCY_CD 
Definition 
Name: Transaction Currency. Description: The currency that the transaction was incurred in.
 

USER_EXCHANGE_RATE 
ColumnName  USER_EXCHANGE_RATE 
Definition 
Name: User Exchange Rate. Description: The exchange rate the user provided.
 

TRANS_PAY_EXCHANGE_RATE 
ColumnName  TRANS_PAY_EXCHANGE_RATE 
Definition 
Name: Transaction to Pay Exchange Rate. Description: The exchange rate provided by the system to take transaction currency to pay currency.
 

TRANS_BASE_EXCHANGE_RATE 
ColumnName  TRANS_BASE_EXCHANGE_RATE 
Definition 
Name: Transaction to Base Exchange Rate. Description: The exchange rate provided by the system to take transaction currency to pay currency.
 

TRANS_UNIT_RATE 
ColumnName  TRANS_UNIT_RATE 
Definition 
Name: Transaction Currency Unit Rate. Description: The unit rate in transaction currency.
 

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

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

TRANS_INCURRED_AMT 
ColumnName  TRANS_INCURRED_AMT 
Definition 
Name: Transaction Currency Incurred Amount. Description: The incurred amount in transaction currency.
 

TRANS_COMPANY_PAID_AMT 
ColumnName  TRANS_COMPANY_PAID_AMT 
Definition 
Name: Transaction Currency Company Paid Amount. Description: The company paid amount in transaction currency.
 

TRANS_PERSONAL_AMT 
ColumnName  TRANS_PERSONAL_AMT 
Definition 
Name: Transaction Currency Personal Amount. Description: The personal amount in transaction currency.
 

TRANS_UNALLOWABLE_AMT 
ColumnName  TRANS_UNALLOWABLE_AMT 
Definition 
Name: 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.
 

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

TRANS_OTHER_AMT 
ColumnName  TRANS_OTHER_AMT 
Definition 
Name: Transaction Currency Other Amount. Description: The other 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).
 

TRANS_BILLABLE_AMT 
ColumnName  TRANS_BILLABLE_AMT 
Definition 
Name: Transaction Currency Billable Amount. Description: The amount of the expense that is billable in transaction currency.
 

TRANS_NON_BILLABLE_AMT 
ColumnName  TRANS_NON_BILLABLE_AMT 
Definition 
Name: Transaction Currency Non-Billable Amount. Description: The amount of the expense that is non billable in transaction currency.
 

PAY_UNIT_RATE 
ColumnName  PAY_UNIT_RATE 
Definition 
Name: Pay Currency Unit Rate. Description: The unit rate in pay currency.
 

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

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

PAY_INCURRED_AMT 
ColumnName  PAY_INCURRED_AMT 
Definition 
Name: Pay Currency Incurred Amount. Description: The incurred amount in pay currency.
 

PAY_COMPANY_PAID_AMT 
ColumnName  PAY_COMPANY_PAID_AMT 
Definition 
Name: Pay Currency Company Paid Amount. Description: The company paid amount in pay currency.
 

PAY_PERSONAL_AMT 
ColumnName  PAY_PERSONAL_AMT 
Definition 
Name: Pay Currency Personal Amount. Description: The personal amount in pay currency.
 

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

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

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

PAY_OTHER_AMT 
ColumnName  PAY_OTHER_AMT 
Definition 
Name: Pay Currency Other Amount. Description: The other 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).
 

PAY_BILLABLE_AMT 
ColumnName  PAY_BILLABLE_AMT 
Definition 
Name: Pay Currency Billable Amount. Description: The amount of the expense that is billable in pay currency.
 

PAY_NON_BILLABLE_AMT 
ColumnName  PAY_NON_BILLABLE_AMT 
Definition 
Name: Pay Currency Non-Billable Amount. Description: The amount of the expense that is non billable in pay currency.
 

BASE_UNIT_RATE 
ColumnName  BASE_UNIT_RATE 
Definition 
Name: Base Currency Unit Rate. Description: The unit rate in system base currency.
 

BASE_DAILY_ROOM_RATE 
ColumnName  BASE_DAILY_ROOM_RATE 
Definition 
Name: 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: Base Currency Daily Tax Rate. Description: The daily room tax rate in system base currency.
 

BASE_INCURRED_AMT 
ColumnName  BASE_INCURRED_AMT 
Definition 
Name: Base Currency Incurred Amount. Description: The incurred amount in system base currency.
 

BASE_COMPANY_PAID_AMT 
ColumnName  BASE_COMPANY_PAID_AMT 
Definition 
Name: Base Currency Company Paid Amount. Description: The company paid amount in system base currency.
 

BASE_PERSONAL_AMT 
ColumnName  BASE_PERSONAL_AMT 
Definition 
Name: Base Currency Personal Amount. Description: The personal amount in system base currency.
 

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

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

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

BASE_OTHER_AMT 
ColumnName  BASE_OTHER_AMT 
Definition 
Name: Base Currency Other Amount. Description: The other 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).
 

BASE_BILLABLE_AMT 
ColumnName  BASE_BILLABLE_AMT 
Definition 
Name: Base Currency Billable Amount. Description: The amount of the expense that is billable in base currency.
 

BASE_NON_BILLABLE_AMT 
ColumnName  BASE_NON_BILLABLE_AMT 
Definition 
Name: Base Currency Non-Billable Amount. Description: The amount of the expense that is non billable in base currency.
 

START_DT 
ColumnName  START_DT 
Definition 
Name: Start Date. Description: The start date for the expense.
 

END_DT 
ColumnName  END_DT 
Definition 
Name: End Date. Description: The end date for the expense.
 

DAYS_NIGHTS_NO 
ColumnName  DAYS_NIGHTS_NO 
Definition 
Name: # of Nights. Description: The number of days nights for the expense.
 

ADJUSTMENT_FL 
ColumnName  ADJUSTMENT_FL 
Definition 
Name: Adjustment Flag. Description: Logical as to whether expense has been adjusted by someone other than employee.
 

CREDIT_UDT01_ID 
ColumnName  CREDIT_UDT01_ID 
Definition 
Name: Credit UDT01 ID. Description: The UDT01 identifier for the line.
 

CREDIT_UDT02_ID 
ColumnName  CREDIT_UDT02_ID 
Definition 
Name: Credit UDT02 ID. Description: The UDT02 identifier for the line.
 

CREDIT_UDT03_ID 
ColumnName  CREDIT_UDT03_ID 
Definition 
Name: Credit UDT03 ID. Description: The UDT03 identifier for the line.
 

CREDIT_UDT04_ID 
ColumnName  CREDIT_UDT04_ID 
Definition 
Name: Credit UDT04 ID. Description: The UDT04 identifier for the line.
 

CREDIT_UDT05_ID 
ColumnName  CREDIT_UDT05_ID 
Definition 
Name: Credit UDT05 ID. Description: The UDT05 identifier for the line.
 

CREDIT_UDT06_ID 
ColumnName  CREDIT_UDT06_ID 
Definition 
Name: Credit UDT06 ID. Description: The UDT06 identifier for the line.
 

CREDIT_UDT07_ID 
ColumnName  CREDIT_UDT07_ID 
Definition 
Name: Credit UDT07 ID. Description: The UDT07 identifier for the line.
 

CREDIT_UDT08_ID 
ColumnName  CREDIT_UDT08_ID 
Definition 
Name: Credit UDT08 ID. Description: The UDT08 identifier for the line.
 

CREDIT_UDT09_ID 
ColumnName  CREDIT_UDT09_ID 
Definition 
Name: Credit UDT09 ID. Description: The UDT09 identifier for the line.
 

CREDIT_UDT10_ID 
ColumnName  CREDIT_UDT10_ID 
Definition 
Name: Credit UDT10 ID. Description: The UDT10 identifier for the line.
 

CREDIT_UDT06_CP_COMPANY_CD 
ColumnName  CREDIT_UDT06_CP_COMPANY_CD 
Definition 
Name: Credit UDT06 Costpoint Company. Description: Costpoint Company Code for UDT06_ID field.
 

CREDIT_UDT07_CP_COMPANY_CD 
ColumnName  CREDIT_UDT07_CP_COMPANY_CD 
Definition 
Name: Credit UDT07 Costpoint Company. Description: Costpoint Company Code for UDT07_ID field.
 

CREDIT_EXPENSE_REF_CD 
ColumnName  CREDIT_EXPENSE_REF_CD 
Definition 
Name: Credit Reference Code. Description: User defined reference code.
 

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.
 

ITINERARY_TEXT 
ColumnName  ITINERARY_TEXT 
Definition 
Name: Intenerary. Description: The itinerary details of the expense.
 

ADJUSTMENT_REASON_TEXT 
ColumnName  ADJUSTMENT_REASON_TEXT 
Definition 
Name: Ceiling Adjustment Reason. Description: Reason for adjustment.
 

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

TRANS_ADJUST_OVER_CEILING_AMT 
ColumnName  TRANS_ADJUST_OVER_CEILING_AMT 
Definition 
Name: 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: Transaction Currency Under Ceiling Adjustment Amount. Description: The under ceiling adjustment amount in transaction currency.
 

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

PAY_ADJUST_OVER_CEILING_AMT 
ColumnName  PAY_ADJUST_OVER_CEILING_AMT 
Definition 
Name: 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: Pay Currency Under Ceiling Adjustment Amount. Description: The under ceiling adjustment amount in pay currency.
 

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

BASE_ADJUST_OVER_CEILING_AMT 
ColumnName  BASE_ADJUST_OVER_CEILING_AMT 
Definition 
Name: 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: Base Currency Under Ceiling Adjustment Amount. Description: The under ceiling adjustment amount in system base currency.
 

VENDOR_ID 
ColumnName  VENDOR_ID 
Definition 
Name: Vendor ID. Description: The ID of vendor for the expense.
 

RECEIPT_EMPL_ID 
ColumnName  RECEIPT_EMPL_ID 
Definition 
Name: Receipt Employee ID. Description: Employee ID of person who recorded receipts for this expense.
 

LATE_FL 
ColumnName  LATE_FL 
Definition 
Name: Late Flag. Description: Logical as to whether Lodging had late checkout or Car Rental had late return.
 

PAY_MEAL_DEDUCTION_AMT 
ColumnName  PAY_MEAL_DEDUCTION_AMT 
Definition 
Name: Pay Currency Meal Deduction Amount. Description: The total amount of meal deductions for Per Diem Reimbursement. The amount is in the employee’s pay currency.
 

CODE1_CD 
ColumnName  CODE1_CD 
Definition 
Name: User Defined Code 1. Description: The Code1 user defined field. The values are based on the expense type.
 

CODE2_CD 
ColumnName  CODE2_CD 
Definition 
Name: User Defined Code 2. Description: The Code2 user defined field. The values are based on the expense type.
 

CODE3_CD 
ColumnName  CODE3_CD 
Definition 
Name: User Defined Code 3. Description: The Code3 user defined field. The values are based on the expense type.
 

COMMENTS_TEXT 
ColumnName  COMMENTS_TEXT 
Definition 
Name: Comments. Description: The User Comments about expense.
 

VALIDATED_FL 
ColumnName  VALIDATED_FL 
Definition 
Name: Validated Flag. Description: Logical as to whether this expense has been validated by user by completing wizard.
 

TAX_SCHEDULE_CD 
ColumnName  TAX_SCHEDULE_CD 
Definition 
Name: Tax Schedule. Description: The tax schedule unique identifier.
 

TAX_LOCATION_S 
ColumnName  TAX_LOCATION_S 
Definition 
Name: Tax Location. Description: The location used in tax schedule.
 

TAX_ID_S 
ColumnName  TAX_ID_S 
Definition 
Name: Tax ID. Description: The tax id of provider of service or goods.
 

TRANS_TAX_RATE1_AMT 
ColumnName  TRANS_TAX_RATE1_AMT 
Definition 
Name: Transaction Currency Tax  1 Rate. Description: The tax rate1 amount in transaction currency.
 

TRANS_TAX_RATE2_AMT 
ColumnName  TRANS_TAX_RATE2_AMT 
Definition 
Name: Transaction Currency Tax  2 Rate. Description: The tax rate2 amount in transaction currency.
 

TRANS_TAX_AMT 
ColumnName  TRANS_TAX_AMT 
Definition 
Name: Transaction Currency Tax Amount. Description: The combined total of tax amounts in transaction currency.
 

PAY_TAX_RATE1_AMT 
ColumnName  PAY_TAX_RATE1_AMT 
Definition 
Name: Pay Currency Tax  1 Rate. Description: The tax rate1 amount in pay currency.
 

PAY_TAX_RATE2_AMT 
ColumnName  PAY_TAX_RATE2_AMT 
Definition 
Name: Pay Currency Tax  2 Rate. Description: The tax rate2 amount in pay currency.
 

PAY_TAX_AMT 
ColumnName  PAY_TAX_AMT 
Definition 
Name: Pay Currency Tax Amount. Description: The combined total of tax amounts in pay currency.
 

BASE_TAX_RATE1_AMT 
ColumnName  BASE_TAX_RATE1_AMT 
Definition 
Name: Base Currency Tax  1 Rate. Description: The tax rate1 amount in transaction currency.
 

BASE_TAX_RATE2_AMT 
ColumnName  BASE_TAX_RATE2_AMT 
Definition 
Name: Base Currency Tax  2 Rate. Description: The tax rate2 amount in transaction currency.
 

BASE_TAX_AMT 
ColumnName  BASE_TAX_AMT 
Definition 
Name: Base Currency Tax Amount. Description: The combined total of tax amounts in base currency.
 

TAX_RECOVERY_RATE1_PCT 
ColumnName  TAX_RECOVERY_RATE1_PCT 
Definition 
Name: Tax Rate 1 Recovery Percentage. Description: The recovery percentage for the rate1 tax.
 

TAX_RECOVERY_RATE2_PCT 
ColumnName  TAX_RECOVERY_RATE2_PCT 
Definition 
Name: Tax Rate 2 Recovery Percentage. Description: The recovery percentage for the rate 2 tax.
 

TRANS_TAX_RECOVERY_RATE1_AMT 
ColumnName  TRANS_TAX_RECOVERY_RATE1_AMT 
Definition 
Name: Transaction Tax Rate 1 Recovery Amount. Description: The amount of rate 1 tax that is recoverable in transaction currency.
 

TRANS_TAX_RECOVERY_RATE2_AMT 
ColumnName  TRANS_TAX_RECOVERY_RATE2_AMT 
Definition 
Name: Transaction Tax Rate 2 Recovery Amount. Description: The amount of rate 2 tax that is recoverable in transaction currency.
 

PAY_TAX_RECOVERY_RATE1_AMT 
ColumnName  PAY_TAX_RECOVERY_RATE1_AMT 
Definition 
Name: Pay Tax Rate 1 Recovery Amount. Description: The amount of rate 1 tax that is recoverable in pay currency.
 

PAY_TAX_RECOVERY_RATE2_AMT 
ColumnName  PAY_TAX_RECOVERY_RATE2_AMT 
Definition 
Name: Pay Tax Rate 2 Recovery Amount. Description: The amount of rate 2 tax that is recoverable in pay currency.
 

BASE_TAX_RECOVERY_RATE1_AMT 
ColumnName  BASE_TAX_RECOVERY_RATE1_AMT 
Definition 
Name: Base Tax Rate 1 Recovery Amount. Description: The amount of rate 1 tax that is recoverable in base currency.
 

BASE_TAX_RECOVERY_RATE2_AMT 
ColumnName  BASE_TAX_RECOVERY_RATE2_AMT 
Definition 
Name: Base Tax Rate 2 Recovery Amount. Description: The amount of rate 2 tax that is recoverable in base currency.
 

EXP_RPT_TYPE_CD 
ColumnName  EXP_RPT_TYPE_CD 
Definition 
Name: Expense Report Type. Description: The type of expense report.
 

MISSING_RECEIPT_REASON_TEXT 
ColumnName  MISSING_RECEIPT_REASON_TEXT 
Definition 
Name: Missing Receipt Explanation. Description: User provided explanation that receipt was not submitted.
 

S_RECEIPT_SUBMIT_STATUS_CD 
ColumnName  S_RECEIPT_SUBMIT_STATUS_CD 
Definition 
Name: Receipt Status. Description: Indicates whether receipt has been submitted by employee. The valid values are as follows:, S – Submitted, M – Missing, N – N A.
 

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

CREDIT_UDT11_ID 
ColumnName  CREDIT_UDT11_ID 
Definition 
Name: Credit UDT 11 ID. Description: The UDT11 identifier for the line.
 

CREDIT_UDT12_ID 
ColumnName  CREDIT_UDT12_ID 
Definition 
Name: Credit UDT 12 ID. Description: The UDT12 identifier for the line.
 

CREDIT_UDT13_ID 
ColumnName  CREDIT_UDT13_ID 
Definition 
Name: Credit UDT 13 ID. Description: The UDT13 identifier for the line.
 

CREDIT_UDT14_ID 
ColumnName  CREDIT_UDT14_ID 
Definition 
Name: Credit UDT 14 ID. Description: The UDT14 identifier for the line.
 

CREDIT_UDT15_ID 
ColumnName  CREDIT_UDT15_ID 
Definition 
Name: Credit UDT 15 ID. Description: The UDT15 identifier for the line.
 

UNALLOWABLE_REASON_TEXT 
ColumnName  UNALLOWABLE_REASON_TEXT 
Definition 
Name: Unallowable Explanation. Description: Reason for unallowable amount.
 

SAVE_WARNING_TEXT 
ColumnName  SAVE_WARNING_TEXT 
Definition 
Name: Save Warnings. Description: Warnings received during most recent expense report save.
 

FIRST_DAY_TRIP_FL 
ColumnName  FIRST_DAY_TRIP_FL 
Definition 
Name: First Day of Trip Flag. Description: Logical as to whether the start date of expense in on the first day of the trip for per diem meal purposes.
 

LAST_DAY_TRIP_FL 
ColumnName  LAST_DAY_TRIP_FL 
Definition 
Name: Last Day of Trip Flag. Description: Logical as to whether the end date of expense in on the last day of the trip for per diem meal purposes.
 

TAXES_DISTRIBUTED_FL 
ColumnName  TAXES_DISTRIBUTED_FL 
Definition 
Name: Distribute Taxes Flag. Description: Logical as to whether or not taxes were distributed for this expense.
 

CONFERENCE_FL 
ColumnName  CONFERENCE_FL 
Definition 
 

LOCATION_ID 
ColumnName  LOCATION_ID 
Definition 
Name: Location ID Description: Unique Identifier for Location.
 

LOCATION_NO 
ColumnName  LOCATION_NO 
Definition