EXP_CLASS_CD 
ColumnName  EXP_CLASS_CD 
Definition 
Name: Expense Class. Description: User-specified unique identifier for employee expense class table.
 

EXP_CLASS_DESC 
ColumnName  EXP_CLASS_DESC 
Definition 
Name: Expense Class Description. Description: Unique description of employee expense class.
 

MODIFY_EXCHANGE_RATE_FL 
ColumnName  MODIFY_EXCHANGE_RATE_FL 
Definition 
Name: Modify Exchange Rate. Description: Logical as to whether employees of this class can modify system defaulted exchange rates.
 

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.
 

S_REVISION_CD 
ColumnName  S_REVISION_CD 
Definition 
Name: Revision Explanation Option. Description: The revision explanation options that are valid for employees assigned to this expense class. The valid options are as follows:DISABLED. OPTIONAL. REQUIRED. 
 

VOID_DRAFT_FL 
ColumnName  VOID_DRAFT_FL 
Definition 
Name: ER Void Draft Flag. Description: Logical as to whether draft expense reports can be voided for this class.
 

VOID_SIGNED_FL 
ColumnName  VOID_SIGNED_FL 
Definition 
Name: ER Void Signed Flag. Description: Logical as to whether signed expense reports can be voided for this class.
 

VOID_UNDER_REVIEW_FL 
ColumnName  VOID_UNDER_REVIEW_FL 
Definition 
Name: ER Void Under Review Flag. Description: Logical as to whether under review expense reports can be voided for this class.
 

VOID_APPROVED_FL 
ColumnName  VOID_APPROVED_FL 
Definition 
Name: ER Void Approved Flag. Description: Logical as to whether approved expense reports can be voided for this class.
 

VOID_REJECTED_FL 
ColumnName  VOID_REJECTED_FL 
Definition 
Name: ER Void Rejected Flag. Description: Logical as to whether rejected expense reports can be voided for this class.
 

MODIFY_TAX_FL 
ColumnName  MODIFY_TAX_FL 
Definition 
Name: Modiy Tax Amount Flag. Description: Logical as to whether employees of this class can modify system calculated tax.
 

VOID_AUTH_DRAFT_FL 
ColumnName  VOID_AUTH_DRAFT_FL 
Definition 
Name: EA Void Draft Flag. Description: Logical as to whether draft authorizations can be voided for this class.
 

VOID_AUTH_SIGNED_FL 
ColumnName  VOID_AUTH_SIGNED_FL 
Definition 
Name: EA Void Signed Flag. Description: Logical as to whether signed authorizations can be voided for this class.
 

VOID_AUTH_UNDER_REVIEW_FL 
ColumnName  VOID_AUTH_UNDER_REVIEW_FL 
Definition 
Name: EA Void Under Review Flag. Description: Logical as to whether under review authorizations can be voided for this class.
 

VOID_AUTH_APPROVED_FL 
ColumnName  VOID_AUTH_APPROVED_FL 
Definition 
Name: EA Void Approved Flag. Description: Logical as to whether approved authorizations can be voided for this class.
 

VOID_AUTH_REJECTED_FL 
ColumnName  VOID_AUTH_REJECTED_FL 
Definition 
Name: EA Void Rejected Flag. Description: Logical as to whether rejected authorizations can be voided for this class.
 

CASH_ADVANCE_LIMIT_AMT 
ColumnName  CASH_ADVANCE_LIMIT_AMT 
Definition 
Name: Cash Advance Limit. Description: The cash advance limit for employees of this class to have as outstanding. A limit of zero or the employee exceeding limit means employees of this cash can not request cash advances. The amount is in the system’s base currency.
 

OUTSTANDING_CASH_ADVANCE_NO 
ColumnName  OUTSTANDING_CASH_ADVANCE_NO 
Definition 
Name: Outstanding # of Cash Advance Limit. Description: Number of cash advances the employee can have outstanding at any one time.
 

MODIFY_SIGNED_FL 
ColumnName  MODIFY_SIGNED_FL 
Definition 
Name: Modify Signed ER Flag. Description: Logical as to whether signed expense reports can be modified for this class.
 

MODIFY_UNDER_REVIEW_FL 
ColumnName  MODIFY_UNDER_REVIEW_FL 
Definition 
Name: Modify Under Review ER Flag. Description: Logical as to whether under review expense reports can be modified for this class.
 

MODIFY_APPROVED_FL 
ColumnName  MODIFY_APPROVED_FL 
Definition 
Name: Modify Approved ER Flag. Description: Logical as to whether approved expense reports can be modified for this class.
 

MODIFY_AUTH_SIGNED_FL 
ColumnName  MODIFY_AUTH_SIGNED_FL 
Definition 
Name: Modify Signed EA Flag. Description: Logical as to whether signed expense authorizations can be modified for this class.
 

MODIFY_AUTH_UNDER_REVIEW_FL 
ColumnName  MODIFY_AUTH_UNDER_REVIEW_FL 
Definition 
Name: Modify Under Review EA Flag. Description: Logical as to whether under review expense authorizations can be modified for this class.
 

MODIFY_AUTH_APPROVED_FL 
ColumnName  MODIFY_AUTH_APPROVED_FL 
Definition 
Name: Modify Approved EA Flag. Description: Logical as to whether approved expense authorizations can be modified for this class.
 

CP_PROJECT_LOOKUP_FL 
ColumnName  CP_PROJECT_LOOKUP_FL 
Definition 
Name: CP Charge Lookup Project Flag. Description: Logical as to whether Costpoint Charge Lookup should have a Project Tab.
 

CP_MO_LOOKUP_FL 
ColumnName  CP_MO_LOOKUP_FL 
Definition 
Name: CP Charge Lookup MO Flag. Description: Logical as to whether Costpoint Charge Lookup should have a MO Tab
 

CP_ACCOUNT_LOOKUP_FL 
ColumnName  CP_ACCOUNT_LOOKUP_FL 
Definition 
Name: CP Charge Lookup Account Flag. Description: Logical as to whether Costpoint Charge Lookup should have an Account Tab.
 

S_CORRECTION_CD 
ColumnName  S_CORRECTION_CD 
Definition 
Name: Correction Code. Description: Determines whether employees with this class can perform expense report corrections and what type can be performed. Valid values are: 0 – not allowed,1 – Net Zero Only,2 – All Corrections Allowed.
 

DAYS_PAST_EXP_RPT_NO 
ColumnName  DAYS_PAST_EXP_RPT_NO 
Definition 
Name: Days Past Expense Report Date. Description: Number of days past the expense report’s date that corrections can be performed.
 

ACTIVE_CHARGES_ONLY_FL 
ColumnName  ACTIVE_CHARGES_ONLY_FL 
Definition 
Name: Active Charges Only. Description: Determines whether only expense reports with active charges can be corrected.
 

S_ER_INTERIM_SIGNATURE_CD 
ColumnName  S_ER_INTERIM_SIGNATURE_CD 
Definition 
Name: Notify Interim Signature   Description: Logical as to whether or not the system shall send notification when an interim signature is completed on the expense report. Valid values are: O for Owner and N for None.
 

S_ER_APPROVE_CD 
ColumnName  S_ER_APPROVE_CD 
Definition 
Name: Notify ER Approval   Description: Logical as to whether or not the system shall send notification when an expense report has been approved. Valid values are: O for Owner and N for None.
 

S_ER_REVISE_CD 
ColumnName  S_ER_REVISE_CD 
Definition 
Name: Notify ER Revised   Description: Logical as to whether or not the system shall send notification when an expense report has been revised. Valid values are: O for Owner and N for None.
 

S_ER_REJECT_CD 
ColumnName  S_ER_REJECT_CD 
Definition 
Name: Notify ER Rejected   Description: Logical as to whether or not the system shall send notification when an expense report has been rejected. Valid values are: O for Owner and N for None.
 

S_ER_VOID_CD 
ColumnName  S_ER_VOID_CD 
Definition 
Name: Notify ER Voided   Description: Logical as to whether or not the system shall send notification when an expense report has been voided. Valid values are: O for Owner and N for None.
 

S_ER_PAID_CD 
ColumnName  S_ER_PAID_CD 
Definition 
Name: Notify ER Paid   Description: Logical as to whether or not the system shall send notification when an expense report has been paid. Valid values are: O for Owner and N for None.
 

S_ER_CHARGE_APPROVE_CD 
ColumnName  S_ER_CHARGE_APPROVE_CD 
Definition 
Name: Notify ER Charge Approved    Description: Logical as to whether or not the system shall send notification when a charge has been approved on an expense report. Valid values are: O for Owner and N for None.
 

S_ER_CHARGE_REJECT_CD 
ColumnName  S_ER_CHARGE_REJECT_CD 
Definition 
Name: Notify ER Charge Rejected   Description: Logical as to whether or not the system shall send notification when a charge has been rejected on an expense report. Valid values are: O for Owner and N for None.
 

S_ER_ATTACHMENT_ATTACH_CD 
ColumnName  S_ER_ATTACHMENT_ATTACH_CD 
Definition 
Name: Notify ER Attachment Attached   Description: Logical as to whether or not the system shall send notification when an attachment has been attached to an expense report. Valid values are: O for Owner and N for None.
 

S_ER_ATTACHMENT_RECORD_CD 
ColumnName  S_ER_ATTACHMENT_RECORD_CD 
Definition 
Name: Notify ER Attachment Recorded   Description: Logical as to whether or not the system shall send notification when an attachment has been recorded on an expense report. Valid values are: O for Owner and N for None.
 

S_ER_ATTACHMENT_APPROVE_CD 
ColumnName  S_ER_ATTACHMENT_APPROVE_CD 
Definition 
Name: Notify ER Attachment Approved   Description: Logical as to whether or not the system shall send notification when an attachment has been approved on an expense report. Valid values are: O for Owner and N for None.
 

S_ER_ATTACHMENT_REJECT_CD 
ColumnName  S_ER_ATTACHMENT_REJECT_CD 
Definition 
Name: Notify ER Attachment Rejected   Description: Logical as to whether or not the system shall send notification when an attachment has been rejected on an expense report. Valid values are: O for Owner and N for None.
 

S_ER_EXPENSE_IMPORT_CD 
ColumnName  S_ER_EXPENSE_IMPORT_CD 
Definition 
Name: Notify Expense Imported   Description: Logical as to whether or not the system shall send notification when an expense has been imported for an employee in this class. Valid values are: O for Owner and N for None.
 

S_EA_INTERIM_SIGNATURE_CD 
ColumnName  S_EA_INTERIM_SIGNATURE_CD 
Definition 
Name: Notify Interim Signature   Description: Logical as to whether or not the system shall send notification when an interim signature is completed on the expense authorization. Valid values are: O for Owner and N for None.
 

S_EA_APPROVE_CD 
ColumnName  S_EA_APPROVE_CD 
Definition 
Name: Notify EA Approved   Description: Logical as to whether or not the system shall send notification when an expense authorization has been approved. Valid values are: O for Owner and N for None.
 

S_EA_REVISE_CD 
ColumnName  S_EA_REVISE_CD 
Definition 
Name: Notify EA Revised   Description: Logical as to whether or not the system shall send notification when an expense authorization has been revised. Valid values are: O for Owner and N for None.
 

S_EA_REJECT_CD 
ColumnName  S_EA_REJECT_CD 
Definition 
Name: Notify EA Rejected   Description: Logical as to whether or not the system shall send notification when an expense authorization has been rejected. Valid values are: O for Owner and N for None.
 

S_EA_VOID_CD 
ColumnName  S_EA_VOID_CD 
Definition 
Name: Notify EA Voided   Description: Logical as to whether or not the system shall send notification when an expense authorization has been voided. Valid values are: O for Owner and N for None.
 

S_EA_CHARGE_APPROVE_CD 
ColumnName  S_EA_CHARGE_APPROVE_CD 
Definition 
Name: Notify EA Charge Approved   Description: Logical as to whether or not the system shall send notification when a charge has been approved on an expense authorization. Valid values are: O for Owner and N for None.
 

S_EA_CHARGE_REJECT_CD 
ColumnName  S_EA_CHARGE_REJECT_CD 
Definition 
Name: Notify EA Charge Rejected   Description: Logical as to whether or not the system shall send notification when a charge has been rejected on an expense authorization. Valid values are: O for Owner and N for None.
 

S_EA_ATTACHMENT_ATTACH_CD 
ColumnName  S_EA_ATTACHMENT_ATTACH_CD 
Definition 
 

S_EA_ATTACHMENT_RECORD_CD 
ColumnName  S_EA_ATTACHMENT_RECORD_CD 
Definition 
Name: Notify EA Attachment Recorded   Description: Logical as to whether or not the system shall send notification when an attachment has been recorded on an expense authorization. Valid values are: O for Owner and N for None.
 

S_EA_ATTACHMENT_APPROVE_CD 
ColumnName  S_EA_ATTACHMENT_APPROVE_CD 
Definition 
Name: Notify EA Attachment Approved   Description: Logical as to whether or not the system shall send notification when an attachment has been approved on an expense authorization. Valid values are: O for Owner and N for None.
 

S_EA_ATTACHMENT_REJECT_CD 
ColumnName  S_EA_ATTACHMENT_REJECT_CD 
Definition 
Name: Notify EA Attachment Rejected    Description: Logical as to whether or not the system shall send notification when an attachment has been rejected on an expense authorization. Valid values are: O for Owner and N for None.
 

S_ADVANCE_APPROVE_CD 
ColumnName  S_ADVANCE_APPROVE_CD 
Definition 
Name: Notify Advance Approved   Description: Logical as to whether or not the system shall send notification when an attachment has been rejected on an expense authorization. Valid values are: O for Owner and N for None.
 

S_ADVANCE_REJECT_CD 
ColumnName  S_ADVANCE_REJECT_CD 
Definition 
Name: Notify Advance Rejected   Description: Logical as to whether or not the system shall send notification when an attachment has been rejected on an expense authorization. Valid values are: O for Owner and N for None.
 

S_ADVANCE_PAID_CD 
ColumnName  S_ADVANCE_PAID_CD 
Definition 
Name: Notify Advance Paid   Description: Logical as to whether or not the system shall send notification when an attachment has been rejected on an expense authorization. Valid values are: O for Owner and N for None.
 

S_ADVANCE_REQUEST_CD 
ColumnName  S_ADVANCE_REQUEST_CD 
Definition