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