ColumnName |
Domain |
Datatype |
NULL |
Definition |
EXP_RPT_ID |
|
VARCHAR2(10) |
YES |
Name: Expene Report ID. Description: The unique identifier for the expense report. |
EXPENSE_ID |
|
NUMBER(10, 0) |
YES |
Name: Expense ID. Description: Synthetic |
PARENT_EXPENSE_ID |
|
NUMBER(10, 0) |
YES |
Name: Parent Expense ID. Description: The expense ID of the expense if this expense was generated from it. |
EXP_CATEGORY_CD |
|
VARCHAR2(10) |
YES |
Name: Expense Category. Description: The category of the expense. |
EXP_TYPE_CD |
|
VARCHAR2(10) |
YES |
Name: Expense Type. Description: The type of the expense. |
EXP_DT |
|
DATE |
YES |
Name: Expense Date. Description: The date the expense was incurred. |
S_RECEIPT_STATUS_CD |
|
VARCHAR2(1) |
YES |
Name: Receipt Status. Description: The system assigned receipt status code. Values are: P – Pending. R- Received. N – Not Applicable |
RECEIPT_DTT |
|
DATE |
YES |
Name: Receipt Date. Description: The date/time the receipt was received. |
PROVIDER_CD |
|
VARCHAR2(20) |
YES |
Name: Provide. Description: The provider of the service for the expense. |
EXPENSE_TEXT |
|
VARCHAR2(120) |
YES |
Name: Expense Description. Description: Description of expense. |
OVER_CEILING_REASON_TEXT |
|
VARCHAR2(254) |
YES |
Name: Over Ceiling Reason. Description: Reason for over ceiling amount. |
TICKET_NUMBER_S |
|
VARCHAR2(20) |
YES |
Name: Ticket Number. Description: The ticket number. |
DEPARTURE_DTT |
|
DATE |
YES |
Name: Departure Date/Time. Description: The departure date/time. |
RETURN_DTT |
|
DATE |
YES |
Name: Return Date/Time. Description: The return date/time. |
BREAKFAST_FL |
|
VARCHAR2(1) |
YES |
Name: Breakfast Flag. Description: Logical as to whether expense included breakfast. |
LUNCH_FL |
|
VARCHAR2(1) |
YES |
Name: Lunch Flag. Description: Logical as to whether expense included lunch. |
DINNER_FL |
|
VARCHAR2(1) |
YES |
Name: Dinner flag. Description: Logical as to whether expense included dinner. |
START_ODOMETER_NO |
|
NUMBER(15, 5) |
YES |
Name: Start Units. Description: The starting number of miles/KM on the odometer. |
END_ODOMETER_NO |
|
NUMBER(15, 5) |
YES |
Name: End Units. Description: The ending number of miles/KM on the odometer. |
PERSONAL_MILES_KM_NO |
|
NUMBER(15, 5) |
YES |
Name: Personal Units. Description: The number of personal miles incurred. |
UNIT_NO |
|
NUMBER(15, 5) |
YES |
Name: Number of Units. Description: The number of units to be expensed. |
PAY_METHOD_CD |
|
VARCHAR2(10) |
YES |
Name: Pay Method. Description: User-specified unique identifier for the pay method |
TRANS_CURRENCY_CD |
|
VARCHAR2(3) |
YES |
Name: Transaction Currency. Description: The currency that the transaction was incurred in. |
USER_EXCHANGE_RATE |
|
NUMBER(20, 10) |
YES |
Name: User Exchange Rate. Description: The exchange rate the user provided. |
TRANS_PAY_EXCHANGE_RATE |
|
NUMBER(20, 10) |
YES |
Name: Transaction to Pay Exchange Rate. Description: The exchange rate provided by the system to take transaction currency to pay currency. |
TRANS_BASE_EXCHANGE_RATE |
|
NUMBER(20, 10) |
YES |
Name: Transaction to Base Exchange Rate. Description: The exchange rate provided by the system to take transaction currency to pay currency. |
TRANS_UNIT_RATE |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Unit Rate. Description: The unit rate in transaction currency. |
TRANS_DAILY_ROOM_RATE |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Daily Room Rate. Description: The daily room rate in transaction currency. |
TRANS_DAILY_TAX_RATE |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Daily Tax Rate. Description: The daily room tax rate in transaction currency. |
TRANS_INCURRED_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Incurred Amount. Description: The incurred amount in transaction currency. |
TRANS_COMPANY_PAID_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Company Paid Amount. Description: The company paid amount in transaction currency. |
TRANS_PERSONAL_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Personal Amount. Description: The personal amount in transaction currency. |
TRANS_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Unallowable Amount. Description: The unallowable amount in transaction currency. |
TRANS_NON_REIMBURSE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Non-Reimbursable Amount. Description: The non-reimbursable amount in transaction currency. |
TRANS_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Ceiling Amount. Description: The ceiling amount in transaction currency. |
TRANS_OTHER_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Other Amount. Description: The other amount in transaction currency. |
TRANS_EXPENSE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Expense Amount. Description: The net expense in the transaction currency. (INCURRED – OTHER) |
TRANS_BILLABLE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Billable Amount. Description: The amount of the expense that is billable in transaction currency. |
TRANS_NON_BILLABLE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Non-Billable Amount. Description: The amount of the expense that is non billable in transaction currency. |
PAY_UNIT_RATE |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Unit Rate. Description: The unit rate in pay currency. |
PAY_DAILY_ROOM_RATE |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Daily Room Rate. Description: The daily room rate in pay currency. |
PAY_DAILY_TAX_RATE |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Daily Tax Rate. Description: The daily room tax rate in pay currency. |
PAY_INCURRED_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Incurred Amount. Description: The incurred amount in pay currency. |
PAY_COMPANY_PAID_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Company Paid Amount. Description: The company paid amount in pay currency. |
PAY_PERSONAL_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Personal Amount. Description: The personal amount in pay currency. |
PAY_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Unallowable Amount. Description: The unallowable amount in pay currency. |
PAY_NON_REIMBURSE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Non-Reimbursable Amount. Description: The non-reimbursable amount in pay currency. |
PAY_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Ceiling Amount. Description: The ceiling amount in pay currency. |
PAY_OTHER_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Other Amount. Description: The other amount in pay currency. |
PAY_EXPENSE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Expense Amount. Description: The net expense in the pay currency. (INCURRED – OTHER). |
PAY_BILLABLE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Billable Amount. Description: The amount of the expense that is billable in pay currency. |
PAY_NON_BILLABLE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Non-Billable Amount. Description: The amount of the expense that is non billable in pay currency. |
BASE_UNIT_RATE |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Unit Rate. Description: The unit rate in system base currency. |
BASE_DAILY_ROOM_RATE |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Daily Room Rate. Description: The daily room rate in system base currency. |
BASE_DAILY_TAX_RATE |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Daily Tax Rate. Description: The daily room tax rate in system base currency. |
BASE_INCURRED_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Incurred Amount. Description: The incurred amount in system base currency. |
BASE_COMPANY_PAID_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Company Paid Amount. Description: The company paid amount in system base currency. |
BASE_PERSONAL_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Personal Amount. Description: The personal amount in system base currency. |
BASE_UNALLOWABLE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Unallowable Amount. Description: The unallowable amount in system base currency. |
BASE_NON_REIMBURSE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Non-Reimbursable Amount. Description: The non-reimbursable amount in system base currency. |
BASE_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Ceiling Amount. Description: The ceiling amount in system base currency. |
BASE_OTHER_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Other Amount. Description: The other amount in system base currency. |
BASE_EXPENSE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Expense Amount. Description: The net expense in the system base currency. (INCURRED – OTHER) |
BASE_BILLABLE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Billable Amount. Description: The amount of the expense that is billable in base currency. |
BASE_NON_BILLABLE_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Non-Billable Amount. Description: The amount of the expense that is non billable in base currency. |
START_DT |
|
DATE |
YES |
Name: Start Date. Description: The start date for the expense. |
END_DT |
|
DATE |
YES |
Name: End Date. Description: The end date for the expense. |
DAYS_NIGHTS_NO |
|
NUMBER(6, 0) |
YES |
Name: # of Nights. Description: The number of days/nights for the expense. |
ADJUSTMENT_FL |
|
VARCHAR2(1) |
YES |
Name: Adjustment Flag. Description: Logical as to whether expense has been adjusted by someone other than employee. |
CREDIT_UDT01_ID |
|
VARCHAR2(50) |
YES |
Name: Credit UDT01 ID. Description: The UDT01 identifier for the line. |
CREDIT_UDT02_ID |
|
VARCHAR2(50) |
YES |
Name: Credit UDT02 ID. Description: The UDT02 identifier for the line. |
CREDIT_UDT03_ID |
|
VARCHAR2(20) |
YES |
Name: Credit UDT03 ID. Description: The UDT03 identifier for the line. |
CREDIT_UDT04_ID |
|
VARCHAR2(20) |
YES |
Name: Credit UDT04 ID. Description: The UDT04 identifier for the line. |
CREDIT_UDT05_ID |
|
VARCHAR2(20) |
YES |
Name: Credit UDT05 ID. Description: The UDT05 identifier for the line. |
CREDIT_UDT06_ID |
|
VARCHAR2(20) |
YES |
Name: Credit UDT06 ID. Description: The UDT06 identifier for the line. |
CREDIT_UDT07_ID |
|
VARCHAR2(20) |
YES |
Name: Credit UDT07 ID. Description: The UDT07 identifier for the line. |
CREDIT_UDT08_ID |
|
VARCHAR2(20) |
YES |
Name: Credit UDT08 ID. Description: The UDT08 identifier for the line. |
CREDIT_UDT09_ID |
|
VARCHAR2(20) |
YES |
Name: Credit UDT09 ID. Description: The UDT09 identifier for the line. |
CREDIT_UDT10_ID |
|
VARCHAR2(20) |
YES |
Name: Credit UDT10 ID. Description: The UDT10 identifier for the line. |
CREDIT_UDT06_CP_COMPANY_CD |
|
VARCHAR2(10) |
YES |
Name: Credit UDT06 Costpoint Company. Description: Costpoint Company Code for UDT06_ID field. |
CREDIT_UDT07_CP_COMPANY_CD |
|
VARCHAR2(10) |
YES |
Name: Credit UDT07 Costpoint Company. Description: Costpoint Company Code for UDT07_ID field. |
CREDIT_EXPENSE_REF_CD |
|
VARCHAR2(20) |
YES |
Name: Credit Reference Code. Description: User defined reference code. |
MODIFIED_BY |
|
VARCHAR2(20) |
YES |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMBER(10, 0) |
YES |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
YES |
Name: Time Stamp. Description: Date and time the record was last modified. |
ITINERARY_TEXT |
|
VARCHAR2(60) |
YES |
Name: Intenerary. Description: The itinerary details of the expense. |
ADJUSTMENT_REASON_TEXT |
|
VARCHAR2(254) |
YES |
Name: Ceiling Adjustment Reason. Description: Reason for adjustment. |
TRANS_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Over Ceiling Amount. Description: The over ceiling amount in transaction currency. |
TRANS_ADJUST_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Over Ceiling Adjustment Amount. Description: The over ceiling adjustment amount in transaction currency. |
TRANS_ADJUST_UNDER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Under Ceiling Adjustment Amount. Description: The under ceiling adjustment amount in transaction currency. |
PAY_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Over Ceiling Amount. Description: The over ceiling amount in pay currency. |
PAY_ADJUST_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Over Ceiling Adjustment Amount. Description: The over ceiling adjustment amount in pay currency. |
PAY_ADJUST_UNDER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Under Ceiling Adjustment Amount. Description: The under ceiling adjustment amount in pay currency. |
BASE_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Over Ceiling Amount. Description: The over ceiling amount in system base currency. |
BASE_ADJUST_OVER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Over Ceiling Adjustment Amount. Description: The over ceiling adjustment amount in system base currency. |
BASE_ADJUST_UNDER_CEILING_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Under Ceiling Adjustment Amount. Description: The under ceiling adjustment amount in system base currency. |
VENDOR_ID |
|
VARCHAR2(20) |
YES |
Name: Vendor ID. Description: The ID of vendor for the expense. |
RECEIPT_EMPL_ID |
|
VARCHAR2(20) |
YES |
Name: Receipt Employee ID. Description: Employee ID of person who recorded receipts for this expense. |
LATE_FL |
|
VARCHAR2(1) |
YES |
Name: Late Flag. Description: Logical as to whether Lodging had late checkout or Car Rental had late return. |
PAY_MEAL_DEDUCTION_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Meal Deduction Amount. Description: The total amount of meal deductions for Per Diem Reimbursement. The amount is in the employee’s pay currency. |
CODE1_CD |
|
VARCHAR2(20) |
YES |
Name: User Defined Code 1. Description: The Code1 user defined field. The values are based on the expense type. |
CODE2_CD |
|
VARCHAR2(20) |
YES |
Name: User Defined Code 2. Description: The Code2 user defined field. The values are based on the expense type. |
CODE3_CD |
|
VARCHAR2(20) |
YES |
Name: User Defined Code 3. Description: The Code3 user defined field. The values are based on the expense type. |
COMMENTS_TEXT |
|
VARCHAR2(254) |
YES |
Name: Comments. Description: The User Comments about expense. |
VALIDATED_FL |
|
VARCHAR2(1) |
YES |
Name: Validated Flag. Description: Logical as to whether this expense has been validated by user by completing wizard. |
TAX_SCHEDULE_CD |
|
VARCHAR2(10) |
YES |
Name: Tax Schedule. Description: The tax schedule unique identifier |
TAX_LOCATION_S |
|
VARCHAR2(20) |
YES |
Name: Tax Location. Description: The location used in tax schedule. |
TAX_ID_S |
|
VARCHAR2(20) |
YES |
Name: Tax ID. Description: The tax id of provider of service or goods. |
TRANS_TAX_RATE1_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Tax 1 Rate. Description: The tax rate1 amount in transaction currency. |
TRANS_TAX_RATE2_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Tax 2 Rate. Description: The tax rate2 amount in transaction currency. |
TRANS_TAX_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Currency Tax Amount. Description: The combined total of tax amounts in transaction currency. |
PAY_TAX_RATE1_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Tax 1 Rate. Description: The tax rate1 amount in pay currency. |
PAY_TAX_RATE2_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Tax 2 Rate. Description: The tax rate2 amount in pay currency. |
PAY_TAX_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Currency Tax Amount. Description: The combined total of tax amounts in pay currency. |
BASE_TAX_RATE1_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Tax 1 Rate. Description: The tax rate1 amount in transaction currency. |
BASE_TAX_RATE2_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Tax 2 Rate. Description: The tax rate2 amount in transaction currency. |
BASE_TAX_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Currency Tax Amount. Description: The combined total of tax amounts in base currency. |
TAX_RECOVERY_RATE1_PCT |
|
NUMBER(3, 2) |
YES |
Name: Tax Rate 1 Recovery Percentage. Description: The recovery percentage for the rate1 tax. |
TAX_RECOVERY_RATE2_PCT |
|
NUMBER(3, 2) |
YES |
Name: Tax Rate 2 Recovery Percentage. Description: The recovery percentage for the rate 2 tax. |
TRANS_TAX_RECOVERY_RATE1_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Tax Rate 1 Recovery Amount. Description: The amount of rate 1 tax that is recoverable in transaction currency. |
TRANS_TAX_RECOVERY_RATE2_AMT |
|
NUMBER(15, 5) |
YES |
Name: Transaction Tax Rate 2 Recovery Amount. Description: The amount of rate 2 tax that is recoverable in transaction currency. |
PAY_TAX_RECOVERY_RATE1_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Tax Rate 1 Recovery Amount. Description: The amount of rate 1 tax that is recoverable in pay currency. |
PAY_TAX_RECOVERY_RATE2_AMT |
|
NUMBER(15, 5) |
YES |
Name: Pay Tax Rate 2 Recovery Amount. Description: The amount of rate 2 tax that is recoverable in pay currency. |
BASE_TAX_RECOVERY_RATE1_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Tax Rate 1 Recovery Amount. Description: The amount of rate 1 tax that is recoverable in base currency. |
BASE_TAX_RECOVERY_RATE2_AMT |
|
NUMBER(15, 5) |
YES |
Name: Base Tax Rate 2 Recovery Amount. Description: The amount of rate 2 tax that is recoverable in base currency. |
EXP_RPT_TYPE_CD |
|
VARCHAR2(10) |
YES |
Name: Expense Report Type. Description: The type of expense report. |
MISSING_RECEIPT_REASON_TEXT |
|
VARCHAR2(254) |
YES |
Name: Missing Receipt Explanation. Description: User provided explanation that receipt was not submitted. |
S_RECEIPT_SUBMIT_STATUS_CD |
|
VARCHAR2(1) |
YES |
Name: Receipt Status. Description: Indicates whether receipt has been submitted by employee. The valid values are as follows: S – Submitted. M – Missing. N – N/A |
INCIDENTAL_FL |
|
VARCHAR2(1) |
YES |
Name: Incidental Flag. Description: Logical as to whether expense included incidentals. |
CREDIT_UDT11_ID |
|
VARCHAR2(20) |
YES |
Name: Credit UDT 11 ID. Description: The UDT11 identifier for the line. |
CREDIT_UDT12_ID |
|
VARCHAR2(20) |
YES |
Name: Credit UDT 12 ID. Description: The UDT12 identifier for the line. |
CREDIT_UDT13_ID |
|
VARCHAR2(20) |
YES |
Name: Credit UDT 13 ID. Description: The UDT13 identifier for the line. |
CREDIT_UDT14_ID |
|
VARCHAR2(20) |
YES |
Name: Credit UDT 14 ID. Description: The UDT14 identifier for the line. |
CREDIT_UDT15_ID |
|
VARCHAR2(20) |
YES |
Name: Credit UDT 15 ID. Description: The UDT15 identifier for the line. |
UNALLOWABLE_REASON_TEXT |
|
VARCHAR2(254) |
YES |
Name: Unallowable Explanation. Description: Reason for unallowable amount. |
SAVE_WARNING_TEXT |
|
VARCHAR2(1000) |
YES |
Name: Save Warnings. Description: Warnings received during most recent expense report save. |
TAXES_DISTRIBUTED_FL |
|
VARCHAR2(1) |
YES |
Name: Distribute Taxes Flag. Description: Logical as to whether or not taxes were distributed for this expense. |
FIRST_DAY_TRIP_FL |
|
VARCHAR2(1) |
YES |
Name: First Day of Trip Flag. Description: Logical as to whether the start date of expense in on the first day of the trip for per diem meal purposes. |
LAST_DAY_TRIP_FL |
|
VARCHAR2(1) |
YES |
Name: Last Day of Trip Flag. Description: Logical as to whether the end date of expense in on the last day of the trip for per diem meal purposes. |
CONFERENCE_FL |
|
VARCHAR2(1) |
YES |
Name: Conference Flag. Description: Determines whether lodging expense was used for a conference. |
LOCATION_ID |
|
VARCHAR2(40) |
YES |
Name: Location ID Description: Unique Identifier for Location. |
LOCATION_NO |
|
NUMBER(10, 0) |
YES |
|