Similar to advance reconciliation, this domain allows you to view the status of pre-paid transactions in the application. Examples:

Unapplied Pre-Paid Transactions

Supported Version	Domain Name	Domain Folder
5.1.x to 5.4.4	Expense Prepaid Reconciliation 5.1.x	Domains
5.5 and higher	Expense Prepaid Reconciliation	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	Applied Report Title	String	Report Tile in which the Pre-paid Transaction was applied.
REPORT_ID	Applied Report ID	Integer	Report ID in which the Pre-paid Transaction was applied
ADV_TRANS_NO	Advance Trans. No	Integer	Pre-paid Transaction Number that is Unique per Pre-paid transaction.
ADVANCE_AMOUNT	Advance Amount	Decimal	Pre-paid amount
CURR_ID	Currency Code	String	The currency of the Pre-paid Amount.
EXP_TYPE	Expense Type Code	String	Expense Type ID
EXP_CODE	Expense Code ID	String	Expense Code
LEVEL1_CODE	Level1 Code	String	WBS Level1 Code
LEVEL2_CODE	Level2 Code	String	WBS Level2 Code
LEVEL3_CODE	Level3 Code	String	WBS Level3 Code
LEVEL4_CODE	Level4 Code	String	WBS Level4 Code
LAST_FIRST	Full Name (Last, First)	String	Employee/User Last Name, First Name
EXP_CODE_NAME	Expense Code	String	Expense Code Name
EXP_TYPE_NAME	Expense Type	String	Expense Type Name
LEVEL1_NAME	Level 1	String	WBS Level1 Name
LEVEL2_NAME	Level 2	String	WBS Level2 Name
LEVEL3_NAME	Level 3	String	WBS Level3 Name
LEVEL4_NAME	Level 4	String	WBS Level4 name
DEPT_CODE	Home Department Code	String	Home Department code
NAME (HOME_DEPT_NAME)	Home Department	String	Home Department Name
OPT_CODE	Home Operating Unit Code	String	Home Operating Unit Code
NAME (HOME_OPT_NAME)	Home Operating Unit	String	Home Operating Unit Name
SOURCE_REPORT_ID	Source Report ID	Integer	Pre-paid Transaction Source Report Id
SOURCE_HDR_TITLE	Source Report Title	String	Pre-paid Transaction Source Report Title
PREPAID_ADJ_AMOUNT	Prepaid Adj. Amount	Decimal	Pre-paid Adjustment Amount
PREPAID_ADJ_NOTE	Prepaid Adj. Note	String	Pre-paid Adjustment Note
ADV_STATUS (ADVANCE_STATUS)	Advance Status	String	Pre-paid Transaction Status Not Used - N Partial Used - P Fully Used - U
HDR_STATUS (XP_REPORT_STATUS)	Report Status	String	Expense report status: On Hold Open Released Closed In Approval Status Rejected Approved
VENDOR_ID	Vendor ID	String	Vendor ID that is linked to the report that got requested
VENDOR_NAME	Vendor	String	Vendor 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)
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.
EMP_ACTIVE	Active Employee	String	Employee Active Yes or No
EMPLY_ID	Employee ID	String	Employee Id
DTSTAMP	DateTime Stamp	Datetime	Transaction Datetime Stamp
PREPAID_ADJ_DATE	Prepaid Adj. Date	Date	Pre-paid Adjustment Date

Browser not supported