EXP_BATCH_ID 
ColumnName  EXP_BATCH_ID 
Definition 
Name: Batch ID. Description: The Batch ID for the expenses. This typically will be an invoice number or Billing Cycle.
 

EXP_BATCH_TYPE_CD 
ColumnName  EXP_BATCH_TYPE_CD 
Definition 
Name: Batch Type. Description: The expense import type unique identifier.
 

TRANSACTION_ID 
ColumnName  TRANSACTION_ID 
Definition 
Name: Transaction ID. Description: The transaction unique identification.
 

EMPL_ID 
ColumnName  EMPL_ID 
Definition 
Name: Employee ID. Description: The employee ID of employee that incurred expense.
 

S_TYPE_CD 
ColumnName  S_TYPE_CD 
Definition 
Name: Wizard Type. Description: Internal system reference code of the type of this expense type. The valid values are:CARRENTAL. ENTERTAIN. LODGING. MEALS. MILEAGE. OTHER. TRANSPORT. 
 

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

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

MERCHANT_NAME 
ColumnName  MERCHANT_NAME 
Definition 
Name: Merchant Name. Description: Description of Merchant
 

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

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

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

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.
 

TRANS_BASE_EXCHANGE_RATE 
ColumnName  TRANS_BASE_EXCHANGE_RATE 
Definition 
Name: Transaction to Base Currency 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_TAX_AMT 
ColumnName  TRANS_TAX_AMT 
Definition 
Name: Transaction Currency Tax Amount. Description: The combined total of tax amounts in transaction 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: Number of Nights. Description: The number of days/nights for the expense.
 

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

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

FILTERED_FL 
ColumnName  FILTERED_FL 
Definition 
Name: Filtered Flag. Description: Logical as to whether this record has been filtered out.
 

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 that the record was last modified.
 

EMPL_IDENTIFIER_S 
ColumnName  EMPL_IDENTIFIER_S 
Definition 
Name: Employee Identifier. Description: The position of the employee ID in the imported ASCII file.
 

PROVIDER_IDENTIFIER_S 
ColumnName  PROVIDER_IDENTIFIER_S 
Definition 
Name: Provider Identifier. Description: The position of the provider code in the imported ASCII file.
 

LOCATION1_S 
ColumnName  LOCATION1_S 
Definition 
Name: Location 1. Description: First location used for Car Rental Rental Location or Hotel City/State
 

LOCATION2_S 
ColumnName  LOCATION2_S 
Definition 
Name: Location 2. Description: Second location used for Car Rental Return Location.
 

EMPLOYEE_NAME 
ColumnName  EMPLOYEE_NAME 
Definition 
Name: Employee Name. Description: Used for Airline Passenger Name, Hotel Guest Name, or Car Rental Renter Name.
 

GHOST_CARD_FL 
ColumnName  GHOST_CARD_FL 
Definition 
Name: Ghost Card Flag. Description: Logical as to whether this is a ghost card transaction.
 

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

VISA_EMPL_ID_S 
ColumnName  VISA_EMPL_ID_S 
Definition 
Name: Visa Employee Idendtifier. Description: The employee identification ID visa has for employee.
 

VISA_ACCOUNT_ID_S 
ColumnName  VISA_ACCOUNT_ID_S 
Definition 
Name: Visa Account. Description: Encrypted Visa Account Number.
 

VISA_ACCOUNT_ID_LAST4_S 
ColumnName  VISA_ACCOUNT_ID_LAST4_S 
Definition 
Name: Last 4 Digits of Visa Account. Description: Last 4 digits of the Visa Account 
 

VISA_EFFECTIVE_DT 
ColumnName  VISA_EFFECTIVE_DT 
Definition 
Name: Effective Date of Visa. Description: Date the account was effective for the employee
 

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

PAY_CURRENCY_CD 
ColumnName  PAY_CURRENCY_CD 
Definition 
Name: Pay Currency. Description: The currency that the transaction was billed in and employee is paid in.