ColumnName |
Domain |
Datatype |
NULL |
Definition |
EXP_TYPE_CD |
|
VARCHAR2(10) |
NO |
Name: Expense Type. Description: The expense type unique identifier. |
EXP_TYPE_DESC |
|
VARCHAR2(30) |
NO |
Name: Expene Type Description. Description: The description of the expense type. |
EXP_CATEGORY_CD |
|
VARCHAR2(10) |
NO |
Name: Expense Category. Description: The Expense Category Type of the expense type. |
PROVIDER_REQUIRED_FL |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
Name: Per Diem Flag. Description: Logical as to whether this expense type uses per-diem schedule. |
S_PER_DIEM_USE_CD |
|
VARCHAR2(10) |
YES |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(10) |
YES |
Unit Label. The label for the miscellaneous unit. This is valid for the following expense category types: MILEAGE. OTHER |
AP_1099_FL |
|
VARCHAR2(1) |
NO |
Name: AP 1099 Flag. Description: Logical as to whether this expense should be recorded as 1099 information. |
AP_1099_TYPE_CD |
|
VARCHAR2(6) |
YES |
Name: AP 1099 Type. Description: Type of 1099 expense. |
RELOCATION_FL |
|
VARCHAR2(1) |
NO |
Name: Relocation Flag. Description: Logical as to whether this expense is a relocation expense. |
RELOCATION_CD |
|
VARCHAR2(6) |
YES |
Name: Relocation Code. Description: Type of relocation expense. |
W2_FL |
|
VARCHAR2(1) |
NO |
Name: W2 Flag. Description: Logical as to whether this expense is W2 reimbursement. |
W2_CD |
|
VARCHAR2(6) |
YES |
Name: W2 Code. Description: Type of W2 expense. |
OVERRIDE_RATE_FL |
|
VARCHAR2(1) |
NO |
Name: Override Unit Rate Flag. Description: Logical as to whether user can override unit rate. |
ACTIVE_FL |
|
VARCHAR2(1) |
NO |
Name: Active Flag. Description: If checked, this expense type is active. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMBER(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 the record was last modified. |
MULTI_DAY_FL |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
If checked, the user must enter the Origination and Destination city. This is valid for the following expense category types: TRANSPORT |
UNALLOWABLE_REQUIRED_FL |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
Name: Combine Per Diem Flag. Description: If checked, the Lodging and Meals Per Diem amounts will be combined. |
BREAKFAST_FL |
|
VARCHAR2(1) |
NO |
Name: Breakfast Flag. Description: If checked, the expense will include Breakfast amounts. |
LUNCH_FL |
|
VARCHAR2(1) |
NO |
Name: Lunch Flag. Description: If checked, the expense will include Lunch amounts. |
DINNER_FL |
|
VARCHAR2(1) |
NO |
Name: Dinner Flag. Description: If checked, the expense will include Dinner amounts. |
DESC_EMPL_ID_FL |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(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 |
CODE1_REQUIRED_FL |
|
VARCHAR2(1) |
NO |
Name: User Defined Code 1 Required Flag. Description: If checked, the user must choose a value for Code1 user defined field. |
CODE2_REQUIRED_FL |
|
VARCHAR2(1) |
NO |
Name: User Defined Code 2 Required Flag. Description: If checked, the user must choose a value for Code2 user defined field. |
CODE3_REQUIRED_FL |
|
VARCHAR2(1) |
NO |
Name: User Defined Code 3 Required Flag. Description: If checked, the user must choose a value for Code3 user defined field. |
DESC_CODE1_FL |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
Name: Suppress Attendee Employee ID Flag. Description: Logical as to whether employee ID is suppressed in attendee lookup. |
S_UNIT_DECIMAL_NO_CD |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
Name: Incidental Flag. Description: If checked, the expense will include Incidental amounts. |
TRACK_MULTIPLE_LOCATIONS_FL |
|
VARCHAR2(1) |
NO |
Name: Track Multiple Locations Flag. Description: Logical that determines whether multiple locations can be tracked on specific expense types. |
LOCATION_REQUIRED_FL |
|
VARCHAR2(1) |
NO |
Name: Location Required Flag. Description: Logical whether location is required. |
UNALLOWABLE_EXPL_REQUIRED_FL |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
NUMBER(3, 2) |
NO |
Name: Conference Adjustment Percentage. Description: Adjustment value for Per Diem Lodging expenses. |
ALLOW_DATE_EDIT_FL |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(10) |
NO |
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 |
|
VARCHAR2(10) |
YES |
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 |
|
VARCHAR2(10) |
NO |
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. |