ColumnName |
Domain |
Datatype |
NULL |
Definition |
EXP_CLASS_CD |
|
VARCHAR2(20) |
NO |
Name: Expense Class. Description: User-specified unique identifier for employee expense class table. |
EXP_CLASS_DESC |
|
VARCHAR2(30) |
NO |
Name: Expense Class Description. Description: Unique description of employee expense class. |
MODIFY_EXCHANGE_RATE_FL |
|
VARCHAR2(1) |
NO |
Name: Modify Exchange Rate. Description: Logical as to whether employees of this class can modify system defaulted exchange rates. |
MODIFIED_BY |
|
VARCHAR2(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMBER(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |
S_REVISION_CD |
|
VARCHAR2(20) |
NO |
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 |
|
VARCHAR2(1) |
NO |
Name: ER Void Draft Flag. Description: Logical as to whether draft expense reports can be voided for this class. |
VOID_SIGNED_FL |
|
VARCHAR2(1) |
NO |
Name: ER Void Signed Flag. Description: Logical as to whether signed expense reports can be voided for this class. |
VOID_UNDER_REVIEW_FL |
|
VARCHAR2(1) |
NO |
Name: ER Void Under Review Flag. Description: Logical as to whether under review expense reports can be voided for this class. |
VOID_APPROVED_FL |
|
VARCHAR2(1) |
NO |
Name: ER Void Approved Flag. Description: Logical as to whether approved expense reports can be voided for this class. |
VOID_REJECTED_FL |
|
VARCHAR2(1) |
NO |
Name: ER Void Rejected Flag. Description: Logical as to whether rejected expense reports can be voided for this class. |
MODIFY_TAX_FL |
|
VARCHAR2(1) |
NO |
Name: Modiy Tax Amount Flag. Description: Logical as to whether employees of this class can modify system calculated tax. |
VOID_AUTH_DRAFT_FL |
|
VARCHAR2(1) |
NO |
Name: EA Void Draft Flag. Description: Logical as to whether draft authorizations can be voided for this class. |
VOID_AUTH_SIGNED_FL |
|
VARCHAR2(1) |
NO |
Name: EA Void Signed Flag. Description: Logical as to whether signed authorizations can be voided for this class. |
VOID_AUTH_UNDER_REVIEW_FL |
|
VARCHAR2(1) |
NO |
Name: EA Void Under Review Flag. Description: Logical as to whether under review authorizations can be voided for this class. |
VOID_AUTH_APPROVED_FL |
|
VARCHAR2(1) |
NO |
Name: EA Void Approved Flag. Description: Logical as to whether approved authorizations can be voided for this class. |
VOID_AUTH_REJECTED_FL |
|
VARCHAR2(1) |
NO |
Name: EA Void Rejected Flag. Description: Logical as to whether rejected authorizations can be voided for this class. |
CASH_ADVANCE_LIMIT_AMT |
|
NUMBER(15, 5) |
NO |
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 |
|
NUMBER(10, 0) |
NO |
Name: Outstanding # of Cash Advance Limit. Description: Number of cash advances the employee can have outstanding at any one time. |
MODIFY_SIGNED_FL |
|
VARCHAR2(1) |
NO |
Name: Modify Signed ER Flag. Description: Logical as to whether signed expense reports can be modified for this class. |
MODIFY_UNDER_REVIEW_FL |
|
VARCHAR2(1) |
NO |
Name: Modify Under Review ER Flag. Description: Logical as to whether under review expense reports can be modified for this class. |
MODIFY_APPROVED_FL |
|
VARCHAR2(1) |
NO |
Name: Modify Approved ER Flag. Description: Logical as to whether approved expense reports can be modified for this class. |
MODIFY_AUTH_SIGNED_FL |
|
VARCHAR2(1) |
NO |
Name: Modify Signed EA Flag. Description: Logical as to whether signed expense authorizations can be modified for this class. |
MODIFY_AUTH_UNDER_REVIEW_FL |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
Name: Modify Approved EA Flag. Description: Logical as to whether approved expense authorizations can be modified for this class. |
CP_PROJECT_LOOKUP_FL |
|
VARCHAR2(1) |
NO |
Name: CP Charge Lookup Project Flag. Description: Logical as to whether Costpoint Charge Lookup should have a Project Tab. |
CP_MO_LOOKUP_FL |
|
VARCHAR2(1) |
NO |
Name: CP Charge Lookup MO Flag. Description: Logical as to whether Costpoint Charge Lookup should have a MO Tab |
CP_ACCOUNT_LOOKUP_FL |
|
VARCHAR2(1) |
NO |
Name: CP Charge Lookup Account Flag. Description: Logical as to whether Costpoint Charge Lookup should have an Account Tab. |
S_CORRECTION_CD |
|
VARCHAR2(1) |
NO |
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 |
|
NUMBER(3, 0) |
NO |
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 |
|
VARCHAR2(1) |
NO |
Name: Active Charges Only. Description: Determines whether only expense reports with active charges can be corrected. |
S_ER_INTERIM_SIGNATURE_CD |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
|
S_EA_ATTACHMENT_RECORD_CD |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(1) |
NO |
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 |
|
VARCHAR2(10) |
NO |
|