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