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. |