EXP_AUTH_ID |
ColumnName | EXP_AUTH_ID |
Definition | Name: Expense Authorization ID. Description: The unique identifier for the expense authorization. |
EMPL_ID |
ColumnName | EMPL_ID |
Definition | Name: Employee ID. Description: The employee whose expense authorization it is. |
EXP_AUTH_DESC |
ColumnName | EXP_AUTH_DESC |
Definition | Name: Expense Authorization Description. Description: Short description of the expense authorization. |
EXP_AUTH_DT |
ColumnName | EXP_AUTH_DT |
Definition | Name: Expense Authorization Date. Description: User assigned date for expense authorization. |
REVISION_NO |
ColumnName | REVISION_NO |
Definition | Name: Revision Number. Description: The current revision of the expense authorization. |
S_EXP_AUTH_STATUS_CD |
ColumnName | S_EXP_AUTH_STATUS_CD |
Definition | Name: Expense Report Status. Description: The valid values are:D - Draft. S – Submitted. U – Under Review. A – Approved. R – Rejected. P – Processed. V – Voided. |
START_DT |
ColumnName | START_DT |
Definition | Name: Start Date. Description: Starting date of expenses. This mainly for trip type expense authorizations. |
END_DT |
ColumnName | END_DT |
Definition | Name: End Date. Description: Starting date of expenses. This mainly for trip type expense authorizations. |
PURPOSE_TEXT |
ColumnName | PURPOSE_TEXT |
Definition | Name: Purpose. Description: The purpose of the expense authorization. |
PER_DIEM_SCHEDULE_CD |
ColumnName | PER_DIEM_SCHEDULE_CD |
Definition | Name: Per Diem Schedule. Description: The per diem schedule that applies to the expense authorization. |
CURRENCY_SCHEDULE_CD |
ColumnName | CURRENCY_SCHEDULE_CD |
Definition | Name: Currency Schedule. Description: The currency schedule that applies to the expense authorization. |
EXP_RPT_TYPE_CD |
ColumnName | EXP_RPT_TYPE_CD |
Definition | Name: Expense Report Type. Description: The type of expense report for this expense authorization. |
EXP_CLASS_CD |
ColumnName | EXP_CLASS_CD |
Definition | Name: Expense Class. Description: The expense class of the employee at the time of the expense authorization. |
CP_COMPANY_CD |
ColumnName | CP_COMPANY_CD |
Definition | Name: Costpoint Company Code. Description: Costpoint Company Code of expense authorization. (Employee) |
SUBMIT_WARNING_TEXT |
ColumnName | SUBMIT_WARNING_TEXT |
Definition | Name: Sign Warnings. Description: Warnings received during last expense authorization 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. |
EXP_AUTH_UDT_ID |
ColumnName | EXP_AUTH_UDT_ID |
Definition | Name: Expense Authorization Header Charge. Description: The configured UDT that is displayed in header. |
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. |
COPIED_AUTH_FL |
ColumnName | COPIED_AUTH_FL |
Definition | Name: Copied Authorization Flag. Description: Logical as to whether this authorization was copied from another authorization. |
FIRST_DAY_TRIP_FL |
ColumnName | FIRST_DAY_TRIP_FL |
Definition | Name: First Day Flag. Description: Logical as to whether this expense authorization contains the first day of the trip. |
LAST_DAY_TRIP_FL |
ColumnName | LAST_DAY_TRIP_FL |
Definition | Name: Last Day Flag. Description: Logical as to whether this expense authorization contains the last day of the trip. |
SHORT_HEADER_TEXT |
ColumnName | SHORT_HEADER_TEXT |
Definition | Name: Notes. Description: Administrative notes pertaining to the entire expense authroization. |
BLANKET_AUTH_FL |
ColumnName | BLANKET_AUTH_FL |
Definition | Name: Blanket Authorization Flag. Description: Indicates whether this type of expense report allows blanket authorizations |
BLANKET_CLOSED_FL |
ColumnName | BLANKET_CLOSED_FL |
Definition | Name: Blanket Authorization Closed Flag. Description: Indicates whether the blanket authorization is closed. |