Expense Approval Summary Domain

This domain displays the approval structure tied to an expense report. Examples:

Expense Reports waiting for Approval
Expense Approval Queue by Approver
Expense Report Approval History

Supported Version	Domain Name	Domain Folder
5.1.x to 5.4.4	Expense Approval Summary 5.1.x	Domains
5.5 and higher	Expense Approval Summary	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
REPORT_ID	Report ID	Integer	Report ID
HDR_TITLE	Report Title	String	Report Tile
RPT_CURR	Report Currency	String	Expense Report Currency Code
APPROVAL_ID	Approver ID	String	Approval ID
APP_ACTION	Approval Action	String	Approval Action - Approved or Rejected
HDR_STATUS_NAME	Report Status	String	Expense report status: On Hold Open Released Closed In Approval Status Rejected Approved
APPROVER_NAME	Approver	String	Approver Full Name
NOTES	Note	String	Approver Notes
LAST_FIRST	Full Name (Last, First)	String	Employee/User Last Name, First Name
PROC_STATUS (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)
VENDOR_ID	Vendor ID	String	Vendor ID that is linked to the report that got requested
VENDOR_NAME	Vendor	String	Vendor Name
COMP_BALANCE_CC	Due by Company to CC	Decimal	Expense Report - Company Total Amount due to Credit Card
COMP_BALANCE_EMP	Due by Company to Employee	Decimal	Expense Report - Company Total Amount due to Employee
EMP_BALANCE_CC	Due by Employee to CC	Decimal	Expense Report - Employee Total Amount due to Credit Card
EMP_BALANCE_COMP	Due by Employee to Company	Decimal	Expense Report - Employee Total Amount due to Company
R_TOTAL_B	Total Business Amount in Report Currency	Decimal	Expense Report Total Business Amount in Report Currency
R_TOTAL_P	Personal Amount in Report Currency	Decimal	Expense Report Total Personal Amount in Report Currency
XP_CERT_STATUS	Certify Status	String	Certify Status by the user for the expense report. Certify Status: Require Certification Certified Already No Action (default)
APP_READY_STATUS	Approval Group Status	String	Group Approval Action either Ready or Approved or Waiting
ENTERED_BY	Entered by	String	Expense Report Modified by Employee id
ENTERED_BY_NAME	Entered by Name	String	Expense Report Modified by Employee Full Name
COPY_DT_CHAR	Approver Action DateTime	String	Approval Action Datetime stamp converted to string it is used only for display.
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.
HDR_PLACE_NAME	Cover Page Place Name	String	Expense Report Place Name if existing on the Report Cover Page.
TODAY_DATE	TODAY_DATE	Date	Today's Date - Used for Scheduling Report
EMP_ACTIVE	Active Employee	String	Employee Active Yes or No
EMPLY_ID	Employee ID	String	Employee Id
REF_TYPE	Approval Reference Type	String	Approval Reference Types: WBS Level1 Approval WBS Level2 Approval Department Approval Approval Routing Team Approval Worked Department Policy Exception Approval
END_DATE	END_DATE	Date	Expense Report End Date
HDR_DT	DateTime Stamp	Datetime	When Approver approved/rejected, if no action – it's 01/01/2100
START_DATE	Report Start Date	Date	Expense Report Start Date
LOCATION_CODE (HOME_LOC_CODE)	Home Location Code	String	Home Location Code
HOME_LOC_NAME	Home Location	String	Home Location Name