Expense Report Status Domain

5.1.x to 5.4.4

Expense Status Domain 51

Domains

5.5 and higher

Expense Report Status

DomainsV55

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

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_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