Expense Report Validation Domain

Validation MessageAllows you to check the validation status of expense reports in the system. Examples:

Expense Validation Report
Flagged Expense Reports

Supported Version	Domain Name	Domain Folder
5.1.x to 5.4.4	Expense Validation Domain 5.1.x	Domains
5.5 and higher	Expense Validation Detail	DomainsV55

The domains consists of the following columns (NOTE: Column names could be renamed so you might see different names based on your side configuration, so the following names are the base names of the system)

Column ID	Column Name (From DBLabels.properties)	Data Type	Description
LAST_FIRST	Full Name (Last, First)	String	Employee/User Last Name, First Name
HDR_TITLE	Report Title	String	Report Tile
REPORT_ID	Report ID	Integer	Report ID
TRAVEL_DATE	Travel Date	Date	Expense Charge charge or travel date.
EXP_TYPE_NAME	Expense Type	String	Expense Type Name Charge that contains attendees
XP_REPORT_STATUS	Report Status	String	Expense report status: On Hold Open Released Closed In Approval Status Rejected Approved
REIMBURSE_AMOUNT (R_TOTAL_B)	Total Business Amount in Report Currency	Decimal	Expense Line - Reimbursable/Business Amount
VENDOR_ID	Vendor ID	String	Vendor ID that is linked to the report that got requested
VENDOR_NAME	Vendor Name	String	Vendor Name
PROC_STATUS_NAME (XP_REPORT_PROC_STATUS)	Process Status	String	Process Status could be one of the following: Fully Paid Partially Paid Posted for Payment No action (Default - Not posted)
GROUP_TITLE	Line Description	String	Contains the default Expense Type name or the Credit Card Description charge.
MAIN_GROUP_TITLE	Credit Card Charge Description	String	Contains the itemized main group if there are itemized charges.
XP_CERT_STATUS	Certify Status	String	Certify Status by the user for the expense report. Certify Status: Require Certification Certified Already No Action (default)
OTHER_EMPLY_ID1	Other Employee ID1	String	Employee Other id1 that is mapped to OTHER_EMPLY_ID1 in the employee table
OTHER_EMPLY_ID2	Other Employee ID2	String	Employee Other id2
SSN	SSN	String	Employee Other id that is mapped to SSN field.
NOTES	Note	String	Expense Line Notes
EMP_ACTIVE	Active Employee	String	Employee Active Yes or No
E_LINE_NO	Line ID	String	Expense Line Id
ERROR_TYPE	Error Type	String	Validation Type: Error Warning *Notes provided
SECTION (ERROR_SECTION)	Error Location	String	Section of error: Report Detail WBS Attendee *Custom Field
VALIDATION_MSG	Validation Message	String	Validation Message
QUERY_DATE	Query Date	String	Date Used for Queries
VALIDATION_TYPE_NAME (VALIDATION_TYPE)	Validation Type	String	Validation Type Name: Report contains advance request while other requests are still outstanding Advance based on preathorization not paid yet Trip and TA are not matching Custom Validation Report contains possible duplicate charges Report contains possible duplicate across Approved reports Report contains Future Charges (None TA Reports) Report contains invalid expense type Report is incomplete Report has invalid OBS Report has invalid WBS Only one Lodging is allowed per day Report contains modified lines different from preauthorized report Reimbursement Policy WBS Policy Report contains no lines
POLICY_NO	Policy Number	String	Policy Number