Expense Created Reports Domain

Owned by Young White (Deactivated)
Apr 30, 2021
2 min read

This domain allows you to create a report based on expense reports that have been created. This will show you information about the report on a summary level and will not include details of what is included in the report. Expense report header information.

Examples:

  • Report Status (Approved, Closed, In Approval Process, On Hold (Draft), Open, Rejected, Released)

  • Process Status (Fully Paid, No Action, Partially Paid, Posted for Payment)

  • Total Amount per Report

 

Column ID

Column Name (From DBLabels.properties)

Data Type

Description

Column ID

Column Name (From DBLabels.properties)

Data Type

Description

REPORT_ID

Report ID

Integer

Report ID

HDR_TITLE

Report Title

String

Report Title

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

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 Code

String

Home Location Code

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 Department Code

String

Home Department Code

OPT_CODE

Home Operating Unit Code

String

Home Operating Unit Code

FUNCTCODE

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 Location Code

String

Home Location Code

END_DATE

Report End Date

Datetime

Expense Report End Date

HDR_DT

Report DateTime Stamp

Datetime

Report Header Date Time Stamp

START_DATE

Report Start Date

Datetime

Expense Report Start Date

ACCESS_DATE

Access Date

Datetime

Report creation date

R_TOTAL

Total Amount in Report Currency

Decimal

Expense Report- Total Amount per line item that contains the attendees on the specific report.

R_TOTAL_B

Total Business Amount in Report Currency

Decimal

Expense Line - Reimbursable/Business Amount

 

2024 DATABASICS, Inc