Expense Advance Reconciliation Domain

5.1.x to 5.4.4

Expense Advance Reconciliation 5.1.x

Domains

Use this domain if you always require the user to apply the advance fully to one report.

5.1.x to 5.4.4

Expense Advance Reconciliation Domain Dtl 51

Domains

Use this domain if the same advance transaction could be applied to multiple reports.

5.5 and higher

Expense Advance Reconciliation Fully Applied Only

DomainsV55

Use this domain if you always require the user to apply the advance fully to one report.

5.5 and higher

Expense Advance Reconciliation Partially and Fully Applied

DomainsV55

Use this domain if the same advance transaction could be applied to multiple reports.

USED_HDR_TITLE

Applied Report Title

String

Report Tile in which the Advance Transaction was applied.

USED_HDR_REPORT_ID

Applied Report ID

Integer

Report ID in which the Advance Transaction was applied

USED_AMOUNT

Applied Amount

Decimal

Applied Advance Amount on a specific report.

XP_REPORT_STATUS

Report Status

String

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

ADV_TRANS_NO

Advance Trans. No

Integer

Advance Transaction Number that is Unique per Advance transaction.  

ADVANCE_AMOUNT

Advance Amount

Decimal

Advance amount

CURR_ID

Currency Code

String

The currency of the advance Amount.

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

Level1

String

WBS Level1 Name

LEVEL2_NAME

Level2

String

WBS Level2 Name

LEVEL3_NAME

Level3

String

WBS Level3 Name

LEVEL4_NAME

Level4

String

WBS Level4 name

TA_HDR_TITLE

TA Report Title

String

Authorization Report Title that created the Advance Transaction

TA_REPORT_ID

TA Report ID

Integer

Authorization Report ID that created the Advance Transaction

ADVANCE_STATUS

Advance Status

String

Advance Transaction Status 
Not Used - N
Partial Used - P
Fully Used - U

DEPT_CODE

Home Department Code

String

Home Department code

HOME_DEPT_NAME

Home Department Name

String

Home Department Name

OPT_CODE

Home Operating Unit Code

String

Home Operating Unit Code

HOME_OPT_NAME

Home Operating Unit

String

Home Operating Unit Name

APPLY_TYPE_NAME
(ADV_APPLY_TYPE)

Applied Type

String

It will let you know if the Transaction is Partially Applied or Fully Applied

SOURCE_HDR_TITLE

Source Report Title

String

Advance Transaction Source Report Title

SOURCE_REPORT_ID

Source Report ID

Integer

Advance Transaction Source Report Id

VENDOR_ID

Vendor ID

String

Vendor ID that is linked to the report that got requested

VENDOR_NAME

Vendor

String

Vendor Name

XP_PROCESS_STATUS
(XP_REPORT_PROC_STATUS)

Process Status

String

Process Status of the expense report that the Advance Transaction got applied to.
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 that the Advance Transaction got applied.   
Certify Status:
Require Certification
Certified Already
No Action (default)
 

AVAL_AMOUNT

Available Amount

Decimal

Available/Remaining Advance Amount =  ADVANCE_AMOUNT - USED_AMOUNT

NOTES

Note

String

Advance Transaction Line Level Note

SSN

SSN

String

Employee Other id that is mapped to SSN field.

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

EMP_ACTIVE

Active Employee

String

Employee Active Yes or No

EMPLY_ID

EMPLY_ID

String

Employee Id

EXP_TYPE

Expense Type Code

String

Expense Type ID

DTSTAMP

DateTime Stamp

Datetime

Transaction Datetime Stamp