Expense Pre-paid Reconciliation Domain

5.1.x to 5.4.4

Expense Prepaid Reconciliation 5.1.x

Domains

5.5 and higher

Expense Prepaid Reconciliation

DomainsV55

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