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
...
HDR_TITLE
...
Report Title
...
String
...
Report Tile
...
REPORT_ID
...
Report ID
...
Integer
...
Report ID
...
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 Name
...
String
...
Vendor Name
...
START_DATE
...
Report Start Date
...
Date
...
Expense Report Start Date
...
END_DATE
...
Report End Date
...
Date
...
Expense Report End Date
...
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
...
Total Amount in Report Currency
...
Decimal
...
Expense Report- Total Amount per line item that contains the attendees on the specific report.
...
R_TOTAL_P
...
Business Total Amount in Report Currency
...
Decimal
...
Business Total 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)
...
HDR_DT
...
Report DateTime Stamp
...
Datetime
...
Expense Report Header Datetime Stamp - Last Modified Datetime.
...
PREV_STATUS
(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
...
XP_REPORT_STATUS
...
Report Status
...
String
...
Expense report status:
On Hold
Open
Released
Closed
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_OPT_NAME
...
Home Operating Unit
...
String
...
Home Operating Unit 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.
...
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
...
REPORT_TYPE
...
Repor Type ID
...
String
...
Report Type ID
...
EMPLY_TYPE
...
Employee Type ID
...
String
...
Employee Type ID
...
FIRST_RELEASED_DATE
...
First Released date
...
String
...
Submitted Date
...
LAST_APPROVED_DATE
...
Last Approved Date
...
String
...
Last Approval Date
...
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
...
HOME_FUNC_NAME
...
Home Function
...
String
...
Home Function Name
...
HOME_LOC_NAME
...
Home Location
...
String
...
Home Location Name
...
EMPLY_ID
...
Employee ID
...
String
...
Employee Id
...
FUNCTCODE
(HOME_FUNC_CODE)
...
Home Function Code
...
String
...
Home Function Code
...
LOCATION_CODE
(HOME_LOC_CODE)
...
Home Location Code
...
String
...
Home Location Code
...
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