Versions Compared

Old Version 1

changes.mady.by.user DATABASICS, Inc.

Saved on

compared with

New Version 2

changes.mady.by.user Young White (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Validation MessageAllows you to check the validation status of expense reports in the system. Examples:

  • Expense Validation Report
  • Flagged Expense Reports

Supported Version

Domain Name

Domain Folder

5.1.x to 5.4.4

Expense Validation Domain 5.1.x

Domains

5.5 and higher

Expense Validation Detail

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

LAST_FIRST

Full Name (Last, First)

String

Employee/User Last Name, First Name

HDR_TITLE

Report Title

String

Report Tile

REPORT_ID

Report ID

Integer

Report ID

TRAVEL_DATE

Travel Date

Date

Expense Charge charge or travel date.

EXP_TYPE_NAME

Expense Type

String

Expense Type Name Charge that contains attendees

XP_REPORT_STATUS

Report Status

String

Expense report status:    
On Hold    
Open    
Released    
Closed    
In Approval Status    
Rejected    
Approved 

REIMBURSE_AMOUNT
(R_TOTAL_B)

Total Business Amount in Report Currency

Decimal

Expense Line - Reimbursable/Business Amount

VENDOR_ID

Vendor ID

String

Vendor ID that is linked to the report that got requested

VENDOR_NAME

Vendor Name

String

Vendor Name

PROC_STATUS_NAME
(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)

GROUP_TITLE

Line Description

String

Contains the default Expense Type name or the Credit Card Description charge.

MAIN_GROUP_TITLE

Credit Card Charge Description

String

Contains the itemized main group if there are itemized charges.

XP_CERT_STATUS

Certify Status

String

Certify Status by the user for the expense report.      
Certify Status:   
Require Certification   
Certified Already   
No Action (default)   

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.

NOTES

Note

String

Expense Line Notes

EMP_ACTIVE

Active Employee

String

Employee Active Yes or No

E_LINE_NO

Line ID

String

Expense Line Id

ERROR_TYPE

Error Type

String

Validation Type:
*Error
*Warning
*Notes provided

SECTION
(ERROR_SECTION)

Error Location

String

Section of error:
*Report
*Detail
*WBS
*Attendee
*Custom Field

VALIDATION_MSG

Validation Message

String

Validation Message

QUERY_DATE

Query Date

String

Date Used for Queries

VALIDATION_TYPE_NAME
(VALIDATION_TYPE)

Validation Type

String

Validation Type Name:
Report contains advance request while other requests are still outstanding
Advance based on preathorization not paid yet
Trip and TA are not matching
Custom Validation
Report contains possible duplicate charges
Report contains possible duplicate across Approved reports
Report contains Future Charges (None TA Reports)
Report contains invalid expense type
Report is incomplete
Report has invalid OBS
Report has invalid WBS
Only one Lodging is allowed per day
Report contains modified lines different from preauthorized report
Reimbursement Policy
WBS Policy
Report contains no lines

POLICY_NO

Policy Number

String

Policy Number