Expense Report Status Domain

Use this domain to create a status report of expense reports in the application. It can also be used as a summary domain.

Expense Status Report
Rejected Expense Reports

Supported Version	Domain Name	Domain Folder
5.1.x to 5.4.4	Expense Status Domain 51	Domains
5.5 and higher	Expense Report Status	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
HDR_STATUS_NAME	Report Status	String	Expense report status: On Hold Open Released Closed In Approval Status Rejected Approved
LAST_FIRST	Full Name (Last, First)	String	Employee/User Last Name, First Name
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 for that specific expense line charge
COMP_BALANCE_EMP	Due by Company to Employee	Decimal	Expense Report - Company Total Amount due to Employee for that specific expense line charge
EMP_BALANCE_CC	Due by Employee to CC	Decimal	Expense Report - Employee Total Amount due to Credit Card for that specific expense line charge
EMP_BALANCE_COMP	Due by Employee to Company	Decimal	Expense Report - Employee Total Amount due to Company for that specific expense line charge
R_TOTAL _B	Total Business Amount in Report Currency	Decimal	Business Total Amount in Report Currency
R_TOTAL_P	Personal Amount in Report Currency	Decimal	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)
XP_REPORT_PREV_STATUS	Report Previous Status	String	Previous Process Status could be one of the following: On Hold Released In Approval Status Rejected Approved
EMP_ACTIVE	Active Employee	String	Employee Active Yes or No
HOME_DEPT_NAME	Home Department	String	Home Department Name
EMPLY_TYPE_NAME	Employee Type	String	Employee Type Name
HOME_FUNC_NAME	Home Function	String	Home Function Name
HOME_OPT_NAME	Home Operating Unit	String	Home Operating Unit Name
HOME_LOC_NAME	Home Location	String	Home Location Name
REPORT_TYPE_NAME	Report Type	String	Report Type Name
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.
EMPLY_ID	Employee ID	String	Employee Id
DEPT_CODE (HOME_DEPT_CODE)	Home Department Code	String	Home Department Code
OPT_CODE (HOME_OPT_CODE)	Home Operating Unit Code	String	Home Operating Unit Code
FUNCTCODE (HOME_FUNC_CODE)	Home Function Code	String	Home Function Code
REPORT_TYPE	Report Type Code	String	Report Type ID
EMPLY_TYPE	Employee Type Code	String	Employee Type ID
LOCATION_CODE (HOME_LOC_CODE)	Home Location Code	String	Home Location Code
FIRST_RELEASED_DATE	First Released date	String	Submitted Date
LAST_APPROVED_DATE	Last Approved Date	String	Last Approval Date
DAYS_TO_APPROVE	Days to Approve	String	Number of days from submitted to approve
BATCH_ID	Batch ID	String	Batch Id
BATCH_TYPE_NAME	Batch Type	String	Batch Type Name
PAYMENT_DATE	Payment date	String	Date Report was Paid
PAYMENT_NOTES	Payment Notes	String	Payment Notes
PAYMENT_NUMBER	Payment Number	String	Payment Number
POST_DTSTAMP	Post DateTime Stamp	String	Post DateTime Stamp
BATCH_TYPE_1	Databasics Extract Batch Type	String	Databasics Extract Batch Type
BATCH_TYPE_2	DATABASICS ACH	String	DATABASICS ACH
BATCH_TYPE_3	Batch type 3	String	Used for additional batch types
BATCH_TYPE_4	Batch type 4	String	Used for additional batch types
BATCH_TYPE_5	Batch type 5	String	Used for additional batch types
BATCH_TYPE_6	Batch type 6	String	Used for additional batch types
END_DATE	Report End Date	Date	Expense Report End Date
HDR_DT	Report DateTime Stamp	Datetime	Expense Report Header Datetime Stamp - Last Modified Datetime.
START_DATE	Report Start Date	Date	Expense Report Start Date