Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
EXP_AUTH_ID |
|
VARCHAR(10) |
YES |
Name: Expense Authorization ID. Description: The unique identifier for the expense . |
EMPL_ID |
|
VARCHAR(20) |
YES |
Name: Employee ID. Description: The employee whose expense authorization it is. |
EXP_AUTH_DESC |
|
VARCHAR(30) |
YES |
Name: Expense Authorization Description. Description: Short description of the expense authorization. |
EXP_AUTH_DT |
|
DATE |
YES |
Name: Expense Authorization Date. Description: User assigned date for expense authorization. |
REVISION_NO |
|
NUMERIC(10, 0) |
YES |
Name: Revision Number. Description: The current revision of the expense authorization. |
S_EXP_AUTH_STATUS_CD |
|
VARCHAR(1) |
YES |
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 |
|
DATE |
YES |
Name: Start Date. Description: Starting date of expenses. This mainly for trip type expense authorizations. |
END_DT |
|
DATE |
YES |
Name: End Date. Description: Ending date of expenses. This mainly for trip type expense authorizations. |
PURPOSE_TEXT |
|
VARCHAR(4000) |
YES |
Name: Purpose. Description: The purpose of the expense authorization. |
PER_DIEM_SCHEDULE_CD |
|
VARCHAR(10) |
YES |
Name: Per Diem Schedule. Description: The per diem schedule that applies to the expense authorization. |
CURRENCY_SCHEDULE_CD |
|
VARCHAR(10) |
YES |
Name: Currency Schedule. Description: The currency schedule that applies to the expense authorization. |
EXP_RPT_TYPE_CD |
|
VARCHAR(10) |
YES |
Name: Expense Report Type. Description: The type of expense report for this expense authorization. |
EXP_CLASS_CD |
|
VARCHAR(20) |
YES |
Name: Expense Class. Description: The expense class of the employee at the time of the expense authorization. |
CP_COMPANY_CD |
|
VARCHAR(10) |
YES |
Name: Costpoint Company Code. Description: Costpoint Company Code of expense authorization. |
SUBMIT_WARNING_TEXT |
|
VARCHAR(1000) |
YES |
Name: Sign Warnings. Description: Warnings received during last expense authorization submit. |
PAY_CURRENCY_CD |
|
VARCHAR(3) |
YES |
Name: Pay Currency. Description: The currency code of that the employee will be reimbursed in. |
BASE_CURRENCY_CD |
|
VARCHAR(3) |
YES |
Name: Base Currency. Description: The base currency code of the system. |
EXP_AUTH_UDT_ID |
|
VARCHAR(50) |
YES |
Name: Expense Authorization Header Charge. Description: The configured UDT that is displayed in header. |
MODIFIED_BY |
|
VARCHAR(20) |
YES |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMERIC(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. |
COPIED_AUTH_FL |
|
VARCHAR(1) |
YES |
Name: Copied Authorization Flag. Description: Logical as to whether this authorization was copied from another authorization. |
FIRST_DAY_TRIP_FL |
|
VARCHAR(1) |
YES |
Name: First Day Flag. Description: Logical as to whether this expense authorization contains the first day of the trip. |
LAST_DAY_TRIP_FL |
|
VARCHAR(1) |
YES |
Name: Last Day Flag. Description: Logical as to whether this expense authorization contains the last day of the trip. |
SHORT_HEADER_TEXT |
|
VARCHAR(4000) |
YES |
Name: Notes. Description: Administrative notes pertaining to the entire expense authroization. |
BLANKET_AUTH_FL |
|
VARCHAR(1) |
YES |
Name: Blanket Authorization Flag. Description: Indicates whether this type of expense report allows blanket authorizations. |
BLANKET_CLOSED_FL |
|
VARCHAR(1) |
YES |
Name: Blanket Authorization Closed Flag. Description: Indicates whether the blanket authorization is closed. |