BATCH_EXPENSE_EDIT 
Default Table Name  BATCH_EXPENSE_EDIT 
Definition 
 Name: Batch Expense Edit.     Description: This table contains the edit table for batch expenses. This table is populated via import or maintain expenses screen.
 

BATCH_EXPENSE_EDIT Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
EXP_BATCH_ID(PK)    VARCHAR(20)  NO 
Name: Batch ID. Description: The Batch ID for the expenses. This typically will be an invoice number or Billing Cycle.
 
EXP_BATCH_TYPE_CD(PK)(FK)    VARCHAR(10)  NO 
Name: Batch Type. Description: The expense import type unique identifier.
 
TRANSACTION_ID(PK)    VARCHAR(65)  NO 
Name: Transaction ID. Description: The transaction unique identification.
 
EMPL_ID(FK)    VARCHAR(20)  YES 
Name: Employee ID. Description: The employee ID of employee that incurred expense.
 
S_TYPE_CD    VARCHAR(10)  NO 
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    DATE  NO 
Name: Expense Date. Description: The date the expense was incurred.
 
PROVIDER_CD(FK)    VARCHAR(20)  YES 
Name: Provider. Description: The provider of the service for the expense.
 
MERCHANT_NAME    VARCHAR(40)  YES 
Name: Merchant Name. Description: Description of Merchant
 
TICKET_NUMBER_S    VARCHAR(20)  YES 
Name: Ticket Number. Description: The ticket number.
 
DEPARTURE_DTT    DATE  YES 
Name: Departure Date. Description: The departure date/time.
 
RETURN_DTT    DATE  YES 
Name: Return date. Description: The return date/time.
 
UNIT_NO    NUMERIC(6, 0)  NO 
Name: Number of Units. Description: The number of units to be expensed.
 
PAY_METHOD_CD(FK)    VARCHAR(10)  NO 
Name: Pay Method . Description: User-specified unique identifier for the pay method
 
TRANS_CURRENCY_CD(FK)    VARCHAR(3)  NO 
Name: Transaction Currency. Description: The currency that the transaction was incurred in.
 
TRANS_BASE_EXCHANGE_RATE    NUMERIC(20, 10)  NO 
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    NUMERIC(15, 5)  NO 
Name: Transaction Currency Unit Rate. Description: The unit rate in transaction currency.
 
TRANS_DAILY_ROOM_RATE    NUMERIC(15, 5)  NO 
Name: Transaction Currency Daily Room Rate. Description: The daily room rate in transaction currency.
 
TRANS_DAILY_TAX_RATE    NUMERIC(15, 5)  NO 
Name: Transaction Currency Daily Tax Rate. Description: The daily room tax rate in transaction currency.
 
TRANS_INCURRED_AMT    NUMERIC(15, 5)  NO 
Name: Transaction Currency Incurred Amount. Description: The incurred amount in transaction currency.
 
TRANS_TAX_AMT    NUMERIC(15, 5)  NO 
Name: Transaction Currency Tax Amount. Description: The combined total of tax amounts in transaction currency.
 
START_DT    DATE  NO 
Name: Start Date. Description: The start date for the expense.
 
END_DT    DATE  NO 
Name: End date. Description: The end date for the expense.
 
DAYS_NIGHTS_NO    NUMERIC(6, 0)  NO 
Name: Number of Nights. Description: The number of days/nights for the expense.
 
ITINERARY_TEXT    VARCHAR(60)  YES 
Name: Intenerary. Description: The itinerary details of the expense.
 
COMMENTS_TEXT    VARCHAR(254)  YES 
Name: Comments. Description: The User Comments about expense.
 
FILTERED_FL    VARCHAR(1)  NO 
Name: Filtered Flag. Description: Logical as to whether this record has been filtered out.
 
MODIFIED_BY    VARCHAR(20)  NO 
Name: Modified by. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMERIC(10, 0)  NO 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time that the record was last modified.
 
EMPL_IDENTIFIER_S    VARCHAR(20)  YES 
Name: Employee Identifier. Description: The position of the employee ID in the imported ASCII file.
 
PROVIDER_IDENTIFIER_S    VARCHAR(30)  YES 
Name: Provider Identifier. Description: The position of the provider code in the imported ASCII file.
 
LOCATION1_S    VARCHAR(30)  YES 
Name: Location 1. Description: First location used for Car Rental Rental Location or Hotel City/State
 
LOCATION2_S    VARCHAR(30)  YES 
Name: Location 2. Description: Second location used for Car Rental Return Location.
 
EMPLOYEE_NAME    VARCHAR(35)  YES 
Name: Employee Name. Description: Used for Airline Passenger Name, Hotel Guest Name, or Car Rental Renter Name.
 
GHOST_CARD_FL    VARCHAR(1)  NO 
Name: Ghost Card Flag. Description: Logical as to whether this is a ghost card transaction.
 
PERSONAL_FL    VARCHAR(1)  NO 
Name: Personal Flag. Description: Logical as to whether this transaction is a personal expense.
 
VISA_EMPL_ID_S    VARCHAR(20)  YES 
Name: Visa Employee Idendtifier. Description: The employee identification ID visa has for employee.
 
VISA_ACCOUNT_ID_S    VARCHAR(44)  YES 
Name: Visa Account. Description: Encrypted Visa Account Number.
 
VISA_ACCOUNT_ID_LAST4_S    VARCHAR(4)  YES 
Name: Last 4 Digits of Visa Account. Description: Last 4 digits of the Visa Account 
 
VISA_EFFECTIVE_DT    DATE  YES 
Name: Effective Date of Visa. Description: Date the account was effective for the employee
 
TRANS_PAY_EXCHANGE_RATE    NUMERIC(20, 10)  NO 
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(FK)    VARCHAR(3)  NO 
Name: Pay Currency. Description: The currency that the transaction was billed in and employee is paid in.
 

BATCH_EXPENSE_EDIT Keys 
Key Name  Key Type  Keys 
RI_F00419  Inversion Entry  PAY_CURRENCY_CD 
RI_F00296  Inversion Entry  TRANS_CURRENCY_CD 
RI_F00295  Inversion Entry  PAY_METHOD_CD 
RI_F00293  Inversion Entry  PROVIDER_CD 
RI_F00292  Inversion Entry  EMPL_ID 
RI_F00291  Inversion Entry  EXP_BATCH_TYPE_CD 
PI_0224  PrimaryKey  EXP_BATCH_ID, EXP_BATCH_TYPE_CD, TRANSACTION_ID 

BATCH_EXPENSE_EDIT Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
EXP_BATCH_TYPE  Identifying  One To Zero or More        EXP_BATCH_TYPE_CD  NO 
EMPL  Non-Identifying  Zero or One to Zero or More        EMPL_ID  NO 
PROVIDER  Non-Identifying  Zero or One to Zero or More        PROVIDER_CD  NO 
PAY_METHOD  Non-Identifying  One To Zero or More        PAY_METHOD_CD  NO 
CURRENCY  Non-Identifying  One To Zero or More        TRANS_CURRENCY_CD  NO 
CURRENCY  Non-Identifying  One To Zero or More        PAY_CURRENCY_CD  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype