EXP_RPT_ID 
ColumnName  EXP_RPT_ID 
Definition 
Name: Expense Report ID. Description: The identifier for the correcting expense report.
 

CORRECTION_NO 
ColumnName  CORRECTION_NO 
Definition 
Name: Correction Number. Description: The correction number used for this expense report.
 

EMPL_ID 
ColumnName  EMPL_ID 
Definition 
Name: Employee ID. Description: The employee whose correcting expense report it is.
 

EXP_RPT_DESC 
ColumnName  EXP_RPT_DESC 
Definition 
Name: Expense Report Description. Description: Short description of the correcting expense report.
 

EXP_RPT_DT 
ColumnName  EXP_RPT_DT 
Definition 
Name: Expense Report Date. Description: User assigned date for correcting expense report.
 

REVISION_NO 
ColumnName  REVISION_NO 
Definition 
Name: Revision Number. Description: The current revision of the expense report.
 

S_EXP_RPT_STATUS_CD 
ColumnName  S_EXP_RPT_STATUS_CD 
Definition 
Name: Expense Report Status. Description: The valid values are:, P – Processed.
 

S_RECEIPT_STATUS_CD 
ColumnName  S_RECEIPT_STATUS_CD 
Definition 
Name: Receipt Status. Description: P – Pending.
 

START_DT 
ColumnName  START_DT 
Definition 
Name: Start Date. Description: Starting date of expenses. This mainly for trip type expenses.
 

END_DT 
ColumnName  END_DT 
Definition 
Name: End Date. Description: Ending date of expenses. This mainly for trip type expenses.
 

PURPOSE_TEXT 
ColumnName  PURPOSE_TEXT 
Definition 
Name: Purpose. Description: The purpose of the expenses on the report.
 

PER_DIEM_SCHEDULE_CD 
ColumnName  PER_DIEM_SCHEDULE_CD 
Definition 
Name: Per Diem Schedule. Description: The per diem schedule that applies to the correcting expense report.
 

CURRENCY_SCHEDULE_CD 
ColumnName  CURRENCY_SCHEDULE_CD 
Definition 
Name: Currency Schedule. Description: The currency schedule that applies to the correcting expense report.
 

EXP_RPT_TYPE_CD 
ColumnName  EXP_RPT_TYPE_CD 
Definition 
Name: Expense Report Type. Description: The type of expense report.
 

EXP_CLASS_CD 
ColumnName  EXP_CLASS_CD 
Definition 
Name: Expense Class. Description: The expense class of the employee at the time of the expense report.
 

UNAVAILABLE_FL 
ColumnName  UNAVAILABLE_FL 
Definition 
Name: Unavailable Flag. Description: Logical as to whether this correcting expense report is unavailable.
 

BATCH_ID 
ColumnName  BATCH_ID 
Definition 
Name: Batch ID. Description: The ID of the process that currently has the correcting expense report unavailable.
 

CP_COMPANY_CD 
ColumnName  CP_COMPANY_CD 
Definition 
Name: Costpoint Company. Description: Costpoint Company Code of expense report. (Employee).
 

SUBMIT_WARNING_TEXT 
ColumnName  SUBMIT_WARNING_TEXT 
Definition 
Name: Sign Warnings. Description: Warnings received during last expense report submit.
 

PAY_CURRENCY_CD 
ColumnName  PAY_CURRENCY_CD 
Definition 
Name: Pay Currency. Description: The currency code of that the employee will be reimbursed in.
 

BASE_CURRENCY_CD 
ColumnName  BASE_CURRENCY_CD 
Definition 
Name: Base Currency. Description: The base currency code of the system. .
 

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.
 

EXP_RPT_UDT_ID 
ColumnName  EXP_RPT_UDT_ID 
Definition 
Name: Expense Report Header UDT Option. Description: The configured UDT that is displayed in header.
 

S_IMAGE_STATUS_CD 
ColumnName  S_IMAGE_STATUS_CD 
Definition 
Name: Receipt Image Status. Description: The system assigned image status code. The valid values are:, P – Pending, R – Received, N – Not Applicable.
 

EXP_AUTH_ID 
ColumnName  EXP_AUTH_ID 
Definition 
Name: Expene Authorization ID. Description: The Expense Authorization for this correcting expense report.
 

RECEIVABLE_UDT01_ID 
ColumnName  RECEIVABLE_UDT01_ID 
Definition 
Name: Receivable UDT01 ID. Description: The UDT01 identifier for the employee receivable charge.
 

RECEIVABLE_UDT02_ID 
ColumnName  RECEIVABLE_UDT02_ID 
Definition 
Name: Receivable UDT02 ID. Description: The UDT02 identifier for the employee receivable charge.
 

RECEIVABLE_UDT03_ID 
ColumnName  RECEIVABLE_UDT03_ID 
Definition 
Name: Receivable UDT03 ID. Description: The UDT03 identifier for the employee receivable charge.
 

RECEIVABLE_UDT04_ID 
ColumnName  RECEIVABLE_UDT04_ID 
Definition 
Name: Receivable UDT04 ID. Description: The UDT04 identifier for the employee receivable charge.
 

RECEIVABLE_UDT05_ID 
ColumnName  RECEIVABLE_UDT05_ID 
Definition 
Name: Receivable UDT05 ID. Description: The UDT05 identifier for the employee receivable charge.
 

RECEIVABLE_UDT06_ID 
ColumnName  RECEIVABLE_UDT06_ID 
Definition 
Name: Receivable UDT06 ID. Description: The UDT06 identifier for the employee receivable charge.
 

RECEIVABLE_UDT07_ID 
ColumnName  RECEIVABLE_UDT07_ID 
Definition 
Name: Receivable UDT07 ID. Description: The UDT07 identifier for the employee receivable charge.
 

RECEIVABLE_UDT08_ID 
ColumnName  RECEIVABLE_UDT08_ID 
Definition 
Name: Receivable UDT08 ID. Description: The UDT08 identifier for the employee receivable charge.
 

RECEIVABLE_UDT09_ID 
ColumnName  RECEIVABLE_UDT09_ID 
Definition 
Name: Receivable UDT09 ID. Description: The UDT09 identifier for the employee receivable charge.
 

RECEIVABLE_UDT10_ID 
ColumnName  RECEIVABLE_UDT10_ID 
Definition 
Name: Receivable UDT10 ID. Description: The UDT10 identifier for the employee receivable charge.
 

RECEIVABLE_UDT06_CP_COMPANY_CD 
ColumnName  RECEIVABLE_UDT06_CP_COMPANY_CD 
Definition 
Name: Receivable UDT06 Costpoint Company. Description: Costpoint Company Code for employee receivable UDT06_ID field.
 

RECEIVABLE_UDT07_CP_COMPANY_CD 
ColumnName  RECEIVABLE_UDT07_CP_COMPANY_CD 
Definition 
Name: Receivable UDT07 Costpoint Company. Description: Costpoint Company Code for employee receivable UDT07_ID field.
 

RECEIVABLE_EXPENSE_REF_CD 
ColumnName  RECEIVABLE_EXPENSE_REF_CD 
Definition 
Name: Receivable Reference Code. Description: User defined reference code for employee receivable charge.
 

PAY_RECEIVABLE_AMT 
ColumnName  PAY_RECEIVABLE_AMT 
Definition 
Name: Pay Currency Receivable Amount. Description: The employee receivable amount. This amount is in the employee’s pay currency.
 

BASE_RECEIVABLE_AMT 
ColumnName  BASE_RECEIVABLE_AMT 
Definition 
Name: Base Currency Receivable Amount. Description: The employee receivable amount. This amount is in the system’s base currency.
 

S_DUE_COMPANY_PAYMENT_CD 
ColumnName  S_DUE_COMPANY_PAYMENT_CD 
Definition 
Name: Due Company Payment Option. Description: Indicates the method of payment the employee indicated for net due company expense reports. The valid values are as follows:, NONE - None, CASH – Cash, CHECK – Check, DEDUCTION – Payroll Deduction, OTHER – Other.
 

DUE_COMPANY_REFERENCE_S 
ColumnName  DUE_COMPANY_REFERENCE_S 
Definition 
Name: Due Company Payment Reference. Description: Text field where employee can provide details if payment is check or other.
 

PAYMENT_UDT01_ID 
ColumnName  PAYMENT_UDT01_ID 
Definition 
Name: Payment UDT01 ID. Description: The UDT01 identifier for the payment.
 

PAYMENT_UDT02_ID 
ColumnName  PAYMENT_UDT02_ID 
Definition 
Name: Payment UDT02 ID. Description: The UDT02 identifier for the payment.
 

PAYMENT_UDT03_ID 
ColumnName  PAYMENT_UDT03_ID 
Definition 
Name: Payment UDT03 ID. Description: The UDT03 identifier for the payment.
 

PAYMENT_UDT04_ID 
ColumnName  PAYMENT_UDT04_ID 
Definition 
Name: Payment UDT04 ID. Description: The UDT04 identifier for the payment.
 

PAYMENT_UDT05_ID 
ColumnName  PAYMENT_UDT05_ID 
Definition 
Name: Payment UDT05 ID. Description: The UDT05 identifier for the payment.
 

PAYMENT_UDT06_ID 
ColumnName  PAYMENT_UDT06_ID 
Definition 
Name: Payment UDT06 ID. Description: The UDT06 identifier for the payment.
 

PAYMENT_UDT07_ID 
ColumnName  PAYMENT_UDT07_ID 
Definition 
Name: Payment UDT07 ID. Description: The UDT07 identifier for the payment.
 

PAYMENT_UDT08_ID 
ColumnName  PAYMENT_UDT08_ID 
Definition 
Name: Payment UDT08 ID. Description: The UDT08 identifier for the payment.
 

PAYMENT_UDT09_ID 
ColumnName  PAYMENT_UDT09_ID 
Definition 
Name: Payment UDT09 ID. Description: The UDT09 identifier for the payment.
 

PAYMENT_UDT10_ID 
ColumnName  PAYMENT_UDT10_ID 
Definition 
Name: Payment UDT10 ID. Description: The UDT10 identifier for the payment.
 

PAYMENT_UDT06_CP_COMPANY_CD 
ColumnName  PAYMENT_UDT06_CP_COMPANY_CD 
Definition 
Name: Payment UDT06 Costpoint Company. Description: Costpoint Company Code for UDT06_ID field for the payment.
 

PAYMENT_UDT07_CP_COMPANY_CD 
ColumnName  PAYMENT_UDT07_CP_COMPANY_CD 
Definition 
Name: Payment UDT07 Costpoint Company. Description: Costpoint Company Code for UDT07_ID field for the payment.
 

PAYMENT_EXPENSE_REF_CD 
ColumnName  PAYMENT_EXPENSE_REF_CD 
Definition 
Name: Payment Reference Code. Description: User defined reference code for the payment.
 

FIRST_DAY_TRIP_FL 
ColumnName  FIRST_DAY_TRIP_FL 
Definition 
Name: First Day Trip Flag. Description: Logical as to whether this expense report contains the first day of the trip.
 

LAST_DAY_TRIP_FL 
ColumnName  LAST_DAY_TRIP_FL 
Definition 
Name: Last Day Trip Flag. Description: Logical as to whether this expense report contains the last day of the trip.
 

CODE1_CD 
ColumnName  CODE1_CD 
Definition 
Name: User Defined Code 1. Description: The Code1 user defined field. The values are based on the expense report type.
 

CODE2_CD 
ColumnName  CODE2_CD 
Definition 
Name: User Defined Code 2. Description: The Code2 user defined field. The values are based on the expense report type.
 

CODE3_CD 
ColumnName  CODE3_CD 
Definition 
Name: User Defined Code 3. Description: The Code3 user defined field. The values are based on the expense report type.
 

RECEIVABLE_UDT11_ID 
ColumnName  RECEIVABLE_UDT11_ID 
Definition 
Name: Receivable UDT11 ID. Description: The UDT11 identifier for the Receivable line.
 

RECEIVABLE_UDT12_ID 
ColumnName  RECEIVABLE_UDT12_ID 
Definition 
Name: Receivable UDT12 ID. Description: The UDT12 identifier for the Receivable line.
 

RECEIVABLE_UDT13_ID 
ColumnName  RECEIVABLE_UDT13_ID 
Definition 
Name: Receivable UDT13 ID. Description: The UDT13 identifier for the Receivable line.
 

RECEIVABLE_UDT14_ID 
ColumnName  RECEIVABLE_UDT14_ID 
Definition 
Name: Receivable UDT14 ID. Description: The UDT14 identifier for the Receivable line.
 

RECEIVABLE_UDT15_ID 
ColumnName  RECEIVABLE_UDT15_ID 
Definition 
Name: Receivable UDT15 ID. Description: The UDT15 identifier for the Receivable line.
 

PAYMENT_UDT11_ID 
ColumnName  PAYMENT_UDT11_ID 
Definition 
Name: Payment UDT11 ID. Description: The UDT11 identifier for the payment.
 

PAYMENT_UDT12_ID 
ColumnName  PAYMENT_UDT12_ID 
Definition 
Name: Payment UDT12 ID. Description: The UDT12 identifier for the payment.
 

PAYMENT_UDT13_ID 
ColumnName  PAYMENT_UDT13_ID 
Definition 
Name: Payment UDT13 ID. Description: The UDT13 identifier for the payment.
 

PAYMENT_UDT14_ID 
ColumnName  PAYMENT_UDT14_ID 
Definition 
Name: Payment UDT14 ID. Description: The UDT14 identifier for the payment.
 

PAYMENT_UDT15_ID 
ColumnName  PAYMENT_UDT15_ID 
Definition 
Name: Payment UDT15 ID. Description: The UDT15 identifier for the payment.
 

SHORT_HEADER_TEXT 
ColumnName  SHORT_HEADER_TEXT 
Definition 
Name: Expense Report Notes. Description: Administrative notes pertaining to the entire expense report.