EXP_TYPE_CD 
ColumnName  EXP_TYPE_CD 
Definition 
Name: Expense Type. Description: The expense type unique identifier.
 

EXP_TYPE_DESC 
ColumnName  EXP_TYPE_DESC 
Definition 
Name: Expene Type Description. Description: The description of the expense type.
 

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

PROVIDER_REQUIRED_FL 
ColumnName  PROVIDER_REQUIRED_FL 
Definition 
Name: Provider Required Flag. Description: Logical as to whether or not a provider is required for this expense type. This is valid for ALL expense categories.
 

PER_DIEM_FL 
ColumnName  PER_DIEM_FL 
Definition 
Name: Per Diem Flag. Description: Logical as to whether this expense type uses per-diem schedule.
 

S_PER_DIEM_USE_CD 
ColumnName  S_PER_DIEM_USE_CD 
Definition 
Name: Per Diem Option. Description: Determines how the Per Diem rates will be used. Valid values are: ALLOW = Allowance; user will be reimbursed according to the Per Diem table. CEILING = Ceiling; user will enter actual amount spent and Per Diem table rate acts as a ceiling.
 

TICKET_NUMBER_REQUIRED_FL 
ColumnName  TICKET_NUMBER_REQUIRED_FL 
Definition 
Ticket Number Required Flag. If checked, the user must enter a Ticket Number. This is valid for the following expense categories: TRANSPORT. CARRENTAL
 

MEAL_REQUIRED_FL 
ColumnName  MEAL_REQUIRED_FL 
Definition 
Meal Identification Required Flag. If checked, the user must identify any meals that were served. This is valid for the following expense category types: TRANSPORT. ENTERTAIN
 

ODOMETER_MILES_REQUIRED_FL 
ColumnName  ODOMETER_MILES_REQUIRED_FL 
Definition 
Name: Odometer Reading Required Flag. Description: If checked, the user must enter the starting and ending odometer reading. This is valid for the following expense category types: MILEAGE
 

ATTENDEE_REQUIRED_FL 
ColumnName  ATTENDEE_REQUIRED_FL 
Definition 
Name: Attendees Required Flag. Description: If checked, the user will be required to list the people that attended. This is valid for the following expense category types: ENTERTAIN
 

UNIT_LBL 
ColumnName  UNIT_LBL 
Definition 
Unit Label. The label for the miscellaneous unit. This is valid for the following expense category types: MILEAGE. OTHER
 

AP_1099_FL 
ColumnName  AP_1099_FL 
Definition 
Name: AP 1099 Flag. Description: Logical as to whether this expense should be recorded as 1099 information.
 

AP_1099_TYPE_CD 
ColumnName  AP_1099_TYPE_CD 
Definition 
Name: AP 1099 Type. Description: Type of 1099 expense. 
 

RELOCATION_FL 
ColumnName  RELOCATION_FL 
Definition 
Name: Relocation Flag. Description: Logical as to whether this expense is a relocation expense.
 

RELOCATION_CD 
ColumnName  RELOCATION_CD 
Definition 
Name: Relocation Code. Description: Type of relocation expense. 
 

W2_FL 
ColumnName  W2_FL 
Definition 
Name: W2 Flag. Description: Logical as to whether this expense is W2 reimbursement.
 

W2_CD 
ColumnName  W2_CD 
Definition 
Name: W2 Code. Description: Type of W2 expense. 
 

OVERRIDE_RATE_FL 
ColumnName  OVERRIDE_RATE_FL 
Definition 
Name: Override Unit Rate Flag. Description: Logical as to whether user can override unit rate.
 

ACTIVE_FL 
ColumnName  ACTIVE_FL 
Definition 
Name: Active Flag. Description: If checked, this expense type is active.
 

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.
 

MULTI_DAY_FL 
ColumnName  MULTI_DAY_FL 
Definition 
Name: Multi Day Expense Flag. Description: If checked, the expense will cover multiple days. This is valid for the following expense category types: OTHER
 

OVER_CEILING_REQUIRED_FL 
ColumnName  OVER_CEILING_REQUIRED_FL 
Definition 
Name: Over Ceiling Explanation Required Flag. Description: Logical as to whether reason for over ceiling amount charged are required. This is valid for ALL expense category types.
 

ITINERARY_REQUIRED_FL 
ColumnName  ITINERARY_REQUIRED_FL 
Definition 
If checked, the user must enter the Origination and Destination city. This is valid for the following expense category types: TRANSPORT
 

UNALLOWABLE_REQUIRED_FL 
ColumnName  UNALLOWABLE_REQUIRED_FL 
Definition 
Name: Unallowable Flag . Description: If checked, the user will be required to enter the amount of unallowable expenses incurred. (i.e. Alcohol). This is valid for the following expense category types: ENTERTAIN
 

S_OVER_CEILING_CD 
ColumnName  S_OVER_CEILING_CD 
Definition 
Name: Over Ceiling Reimburse Option. Description: Determines whether or not the over ceiling amounts are reimbursed to the employee. The valid values are: R – Reimburse. N – Non-Reimburse
 

DESC_CATEGORY_FL 
ColumnName  DESC_CATEGORY_FL 
Definition 
Description Category Flag. Logical as to whether or not the Category will be used in the description of the expense report. 
 

DESC_EXPENSE_TYPE_FL 
ColumnName  DESC_EXPENSE_TYPE_FL 
Definition 
Name: Description Expense Type Flag. Description: Logical as to whether or not the Expense Type will be used in the description of the expense report.
 

DESC_PROVIDER_FL 
ColumnName  DESC_PROVIDER_FL 
Definition 
Name: Description Provider Flag. Description: Logical as to whether or not the Provider will be used in the description of the expense report.
 

DESC_EXPENSE_DATE_FL 
ColumnName  DESC_EXPENSE_DATE_FL 
Definition 
Name: Description Expense Date Flag. Description: Logical as to whether or not the Expense Date will be used in the description of the expense report.
 

DESC_START_END_DATE_FL 
ColumnName  DESC_START_END_DATE_FL 
Definition 
Name: Description Start/End Date Flag. Description: Logical as to whether or not the Start and End Date will be used in the description of the expense report.
 

DESC_TICKET_NUMBER_FL 
ColumnName  DESC_TICKET_NUMBER_FL 
Definition 
Name: Description Ticket Number Flag. Description: Logical as to whether or not the Ticket Number will be used in the description of the expense report.
 

DESC_ITINERARY_FL 
ColumnName  DESC_ITINERARY_FL 
Definition 
Name: Description Itinerary Flag. Description: Logical as to whether or not the Itinerary will be used in the description of the expense report.
 

COMBINE_PER_DIEM_FL 
ColumnName  COMBINE_PER_DIEM_FL 
Definition 
Name: Combine Per Diem Flag. Description: If checked, the Lodging and Meals Per Diem amounts will be combined.
 

BREAKFAST_FL 
ColumnName  BREAKFAST_FL 
Definition 
Name: Breakfast Flag. Description: If checked, the expense will include Breakfast amounts.
 

LUNCH_FL 
ColumnName  LUNCH_FL 
Definition 
Name: Lunch Flag. Description: If checked, the expense will include Lunch amounts.
 

DINNER_FL 
ColumnName  DINNER_FL 
Definition 
Name: Dinner Flag. Description: If checked, the expense will include Dinner amounts.
 

DESC_EMPL_ID_FL 
ColumnName  DESC_EMPL_ID_FL 
Definition 
Name: Description Employee ID Flag. Description: Logical as to whether or not the Employee ID will be used in the description of the expense report.
 

DESC_EXP_RPT_ID_FL 
ColumnName  DESC_EXP_RPT_ID_FL 
Definition 
Name: Description Expense Report ID Flag. Description: Logical as to whether or not the Expense Report ID will be used in the description of the expense report.
 

SECOND_TIER_CEILING_FL 
ColumnName  SECOND_TIER_CEILING_FL 
Definition 
Name: 2nd Tier Per Diem Ceiling Flag. Description: Logical as to whether a per diem expense should use Expense Type ceiling as 2nd tier ceiling.
 

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
 

CODE1_REQUIRED_FL 
ColumnName  CODE1_REQUIRED_FL 
Definition 
Name: User Defined Code 1 Required Flag. Description: If checked, the user must choose a value for Code1 user defined field.
 

CODE2_REQUIRED_FL 
ColumnName  CODE2_REQUIRED_FL 
Definition 
Name: User Defined Code 2 Required Flag. Description: If checked, the user must choose a value for Code2 user defined field.
 

CODE3_REQUIRED_FL 
ColumnName  CODE3_REQUIRED_FL 
Definition 
Name: User Defined Code 3 Required Flag. Description: If checked, the user must choose a value for Code3 user defined field.
 

DESC_CODE1_FL 
ColumnName  DESC_CODE1_FL 
Definition 
Name: Description User Defined Code 1 Flag. Description: Logical as to whether or not the Code1 will be used in the description of the expense report.
 

DESC_CODE2_FL 
ColumnName  DESC_CODE2_FL 
Definition 
Name: Description User Defined Code 2 Flag. Description: Logical as to whether or not the Code2 will be used in the description of the expense report.
 

DESC_CODE3_FL 
ColumnName  DESC_CODE3_FL 
Definition 
Name: Description User Defined Code 3 Flag. Description: Logical as to whether or not the Code3 will be used in the description of the expense report.
 

CODE1_VALIDATE_FL 
ColumnName  CODE1_VALIDATE_FL 
Definition 
Name: User Defined Code 1 Validate Flag. Description: Logical as to whether code1 is required. If "Y", the user must choose a value for Code1.
 

CODE2_VALIDATE_FL 
ColumnName  CODE2_VALIDATE_FL 
Definition 
Name: User Defined Code 2 Validate Flag. Description: Logical as to whether code2 is required. If "Y", the user must choose a value for Code2.
 

CODE3_VALIDATE_FL 
ColumnName  CODE3_VALIDATE_FL 
Definition 
Name: User Defined Code 3 Validate Flag. Description: Logical as to whether code3 is required. If "Y", the user must choose a value for Code3.
 

REQUIRE_TITLE_COMPANY_FL 
ColumnName  REQUIRE_TITLE_COMPANY_FL 
Definition 
Name: Require Attendee Company/Title Flag. Description: Logical as to whether attendee wizard page should require title and company info for attendee. 
 

SUPPRESS_ATTENDEE_EMPL_ID_FL 
ColumnName  SUPPRESS_ATTENDEE_EMPL_ID_FL 
Definition 
Name: Suppress Attendee Employee ID Flag. Description: Logical as to whether employee ID is suppressed in attendee lookup.
 

S_UNIT_DECIMAL_NO_CD 
ColumnName  S_UNIT_DECIMAL_NO_CD 
Definition 
Name: Unit Decimal Postion Option. Description: Number of decimals that expenses of this Expense Type can go out to the right of the decimal point.
 

INCIDENTAL_FL 
ColumnName  INCIDENTAL_FL 
Definition 
Name: Incidental Flag. Description: If checked, the expense will include Incidental amounts.
 

TRACK_MULTIPLE_LOCATIONS_FL 
ColumnName  TRACK_MULTIPLE_LOCATIONS_FL 
Definition 
Name: Track Multiple Locations Flag. Description: Logical that determines whether multiple locations can be tracked on specific expense types.
 

LOCATION_REQUIRED_FL 
ColumnName  LOCATION_REQUIRED_FL 
Definition 
Name: Location Required Flag. Description: Logical whether location is required.
 

UNALLOWABLE_EXPL_REQUIRED_FL 
ColumnName  UNALLOWABLE_EXPL_REQUIRED_FL 
Definition 
Name: Unallowable Explanation Required Flag. Description: Logical as to whether reason for unallowable amount charged are required. This is valid for ALL expense types.
 

OVERRIDE_FIRST_LAST_DAY_FL 
ColumnName  OVERRIDE_FIRST_LAST_DAY_FL 
Definition 
Name: Override First Last Day Flag. Description: Logical as to whether expenses of this type allow the override of the trip’s first/last day.
 

CONFERENCE_ADJUST_PCT 
ColumnName  CONFERENCE_ADJUST_PCT 
Definition 
Name: Conference Adjustment Percentage. Description: Adjustment value for Per Diem Lodging expenses.
 

ALLOW_DATE_EDIT_FL 
ColumnName  ALLOW_DATE_EDIT_FL 
Definition 
Name: Allow Date Edit. Description: Determines whether the employee can change the Expense Date or Start End Date on Batch Expenses.
 

S_CEILING_CALCULATION_CD 
ColumnName  S_CEILING_CALCULATION_CD 
Definition 
Name: Ceiling Calculation Description: Determines how the system will calculate the ceiling for the Expense Type. Valid values are: EXPENSE – ceiling amount is calculated by taking the ceiling amount one time ATTENDEE – ceiling is calculated by taking the ceiling amount times the number of attendees.
 

S_ENTER_ATTENDEES_CD 
ColumnName  S_ENTER_ATTENDEES_CD 
Definition 
Name: Enter Attendees Description: Logical as to how the user will enter the attendees. Values are: By Number of Attendees By Attendee Name.
 

S_CEILING_CALC_METHOD_CD 
ColumnName  S_CEILING_CALC_METHOD_CD 
Definition 
Name: Ceiling Calculation Method Description: Determines whether the system will calculation ceiling amounts for each day or for all days of the expense combined: DAY – Each Day EXPENSE – all days combined.