EXP_AUTH_ID 
ColumnName  EXP_AUTH_ID 
Definition 
Name: Expense Authorization ID. Description: The unique identifier for the expense .
 

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

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.