Page Comparison

Convert to Currency 

String

Convert all the data to one currency - Currency code

CONVERT_RATE

Converted Rate

Decimal

Converted currency rate

LOCAL_CURR 
(CURRENCY_FROM)

Local Currency

String

Expense line charged currency

EXCHANGE_RATE

Exchange Rate

Decimal

Currency Rate if the Currency From is different than Report Currency

HDR_TITLE

Report Title

String

Report Title

REPORT_ID

Report ID

Integer

Report ID

REPORT_TYPE

Report Type ID

String

Report Type ID

REPORT_TYPE_NAME

Report Type

String

Report Type Name

HDR_STATUS_NAME

Report Status

String

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

LOCK_BY

Locked By

String

Locked by if the expense report is in Status: Open or Closed

LOCK_DT

Locked Datetime Stamp

Datetime

Locked Datetime if the expense report is in Status: Open or Closed

NOTE

Note

String

Attendee Line Level Note

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)    

HDR_DT

Report DateTime Stamp

Datetime

Expense Report Header Datetime Stamp - Last Modified Datetime.

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

RPT_CURR

Report Currency

String

Expense Report Currency Code

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

Total Amount in Report Currency

Decimal

Expense Report- Total Amount per line item that contains the attendees on the specific report.

R_ALC_B

Business Alcohol Amount in Report Currency 

Decimal

Expense Line - Reimbursable/ Business Amount for Alcohol to Employee

R_TOTAL_B

Total Business Amount in Report Currency

Decimal

Expense Line - Reimbursable/Business Amount

R_TAX1_B

Business Tax1 Amount in Report Currency

Decimal

Expense Line - Reimbursable/Business Tax 1 Amount

R_TAX2_B

Business Tax2Amount in Report Currency

Decimal

Expense Line - Reimbursable/Business Tax 2 Amount

R_TIP_B

Business Tip Amount in Report Currency

Decimal

Expense Line - Reimbursable/Business Tip Amount

R_ALC_P

Business Alcohol Amount in Report Currency 

Decimal 

 Business Alcohol Amount in Report Currency 

R_TAX1_P

Business Tax Amount in Report Currency 

Decimal 

 Business Tax Amount in Report Currency 

R_TAX2_P

Business Tax2 Amount in Report Currency 

Decimal 

 Business Tax2 Amount in Report Currency 

R_TIP_P

Business Tip Amount in Report Currency 

Decimal 

 Business Tip Amount in Report Currency 

R_TOTAL_P

Business Total Amount in Report Currency 

Decimal 

 Business Total Amount in Report Currency 

R_BASE_B

Base Business Amount in Report Currency

Decimal

Base Business Amount in Report Currency

R_BASE_P

Base Personal Amount in Report Currency

Decimal

Base Personal Amount in Report Currency

R_GRAND_BAL

Grand Total Balance Amount in Report Currency

Decimal

Grand Total Balance Amount in Report Currency

R_TOTAL_B_BAL

Total Business Balance Amount in Report Currency

Decimal

Total Business Balance Amount in Report Currency

R_TOTAL_P_BAL

Total Personal Balance Amount in Report Currency

Total Personal Balance 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)    

REF_NUM

Reference Number

String

Expense Line Reference Number

MAIN_GROUP_TITLE

Credit Card Charge Description

String

Contains the itemized main group if there are itemized charges.

GROUP_TITLE

Line Description 

String

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

EXP_TYPE

Expense Type ID

String

Expense Type ID Charge that contains attendees

EXP_TYPE_NAME

Expense Type

String

Expense Type Name Charge that contains attendees

GRP_EXP_ID

Expense Type Group ID

String

Expense Type Group ID for the charged Expense Type

GRP_EXP_NAME

Expense Type Group

String

Expense Type Group Name for the charge Expense Type

TRAVEL_DATE

Travel Date

Date

Expense Charge charge or travel date.

PAY_ID

Payment Type ID

String

Payment Type ID per the expense line

PAY_ID_NAME

Payment Type

String

Payment Type Name per the expense line

ENTERED_BY

Entered by ID

String

Expense Report Modified by Employee id

ENTERED_BY_NAME

Entered by

String

Expense Report Modified by Employee Full Name

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.

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

Employee ID

String

Employee Id

EMPLY_TYPE

Employee Type ID

String

Employee Type ID

EMPLY_TYPE_NAME

Employee Type

String

Employee Type Name

DEPT_CODE

Home Department Code

String

Home Department Code

HOME_DEPT_NAME

Home Department

String

Home Department Name

OPT_ODE

Home Operating Unit Code

String

Home Operating Unit Code

HOME_OPT_NAME

Home Operating Unit

String

Home Operating Unit Name

L_ALC_B

Business Alcohol Amount in Local Currency

Decimal

Business Alcohol Amount in Local Currency 

L_ALC_P

Personal Alcohol Amount in Local Currency 

Decimal

Personal Alcohol Amount in Local Currency 

L_TAX1_B

Business Tax1 Amount in Local Currency 

Decimal

Business Tax1 Amount in Local Currency 

L_TAX1_P

Personal Tax1 Amount in Local Currency 

Decimal

Personal Tax1 Amount in Local Currency 

L_TAX2_B

Business Tax2 Amount in Local Currency 

Decimal

Business Tax2 Amount in Local Currency 

L_TAX2_P

Personal Tax2 Amount in Local Currency 

Decimal

Personal Tax2 Amount in Local Currency 

L_TIP_B

Business Tip Amount in Local Currency

Decimal

Business Tip Amount in Local Currency

L_TIP_P

Personal Tip Amount in Local Currency

Decimal

Personal Tip Amount in Local Currency

L_TOTAL_B

Total Business Amount in Local Currency 

Decimal

Total Business Amount in Local Currency 

L_TOTAL_P

Personal Business Amount in Local Currency 

Decimal

Personal Business Amount in Local Currency 

L_TOTAL

Total Amount in Local Currency 

Decimal

Total Amount in Local Currency 

C_ALC_B

Business Alcohol Amount in CC Currency

Decimal

Business Alcohol Amount in Credit Card Currency 

C_ALC_P

Personal Alcohol Amount in CC Currency 

Decimal

Personal Alcohol Amount in Credit Card Currency 

C_TAX1_B

Business Tax1 Amount in CC Currency 

Decimal

Business Tax1 Amount in Credit Card Currency 

C_TAX1_P

Personal Tax1 Amount in CC Currency 

Decimal

Personal Tax1 Amount in Credit Card Currency 

C_TAX2_B

Business Tax2 Amount in CC Currency 

Decimal

Business Tax2 Amount in Credit Card Currency 

C_TAX2_P

Personal Tax2 Amount in C Currency 

Decimal

Personal Tax2 Amount in Credit Card Currency 

C_TIP_B

Business Tip Amount in CC Currency

Decimal

Business Tip Amount in Credit Card Currency

C_TIP_P

Personal Tip Amount in CC Currency

Decimal

Personal Tip Amount in Credit Card Currency

C_TOTAL_B

Total Business Amount in CC Currency 

Decimal

Total Business Amount in Credit Card Currency 

C_TOTAL_P

Personal Business Amount in CC Currency 

Decimal

Personal Business Amount in Credit Card Currency 

C_BASE_B

Base Business Amount in CC Currency

Decimal

Base Business Amount in Credit Card Currency

C_BASE_P

Base Personal Amount in CC Currency

Decimal

Base Personal Amount in Credit Card Currency

C_COMP_CC

Due by Company to CC in CC Currency

Decimal

Due by Company to Credit Card in CC Currency

C_EMP_CC

Due by Employee to CC in CC Currency

Decimal

Due by Employee to Credit Card in CC Currency

C_GRAND

Credit Card Billing Amount

Decimal

 Credit Card Billing Amount

C_GRAND_BAL

Credit Card Billing Balance Amount

Decimal

Credit Card Billing Balance Amount

CC_BILL_CURR

Credit Card Billing Currency

String

Credit Card Billing Currency

E_PERSONAL

Entry Personal Amount 

Decimal

Personal Entry Amount

E_BUSINESS

Entry Business Amount

Decimal

 Business Amount entered in the system

E_ALC

Entry Alcohol Amount

Decimal

 Alcohol Amount entered in the system

E_TAX

Entry Tax1 Amount

Decimal

Tax 1 Amount entered in the system

E_TAX2

Entry Tax2 Amount 

Decimal

Tax 2 Amount entered in the system

E_TIP

Entry Tip Amount 

Decimal

 Tip Amount entered in the system

O_ALC_B

Business Alcohol Amount in OBS Currency

Decimal

Business Alcohol Amount in Organization Work Breakdown Structure Currency 

O_ALC_P

Personal Alcohol Amount in OBS Currency 

Decimal

Personal Alcohol Amount in Organization Work Breakdown Structure Currency 

O_TAX1_B

Business Tax1 Amount in OBS Currency 

Decimal

Business Tax1 Amount in Organization Work Breakdown Structure Currency 

O_TAX1_P

Personal Tax1 Amount in OBS Currency 

Decimal

Personal Tax1 Amount in Organization Work Breakdown Structure Currency 

O_TAX2_B

Business Tax2 Amount in OBS Currency 

Decimal

Business Tax2 Amount in Organization Work Breakdown Structure Currency 

O_TAX2_P

Personal Tax2 Amount in OBS Currency 

Decimal

Personal Tax2 Amount in Organization Work Breakdown Structure Currency 

O_TIP_B

Business Tip Amount in OBS Currency

Decimal

Business Tip Amount in Organization Work Breakdown Structure Currency

O_TIP_P

Personal Tip Amount in OBS Currency

Decimal

Personal Tip Amount in Organization Work Breakdown Structure Currency

O_TOTAL_B

Total Business Amount in OBS Currency 

Decimal

Total Business Amount in Organization Work Breakdown Structure Currency 

O_TOTAL_P

Personal Business Amount in OBS Currency 

Decimal

Personal Business Amount in Organization Work Breakdown Structure Currency 

O_BASE_B

Base Business Amount in OBS Currency

Decimal

Base Business Amount in  Organization Work Breakdown Structure Currency

O_BASE_P

Base Personal Amount in OBS Currency

Decimal

Base Personal Amount in Organization Work Breakdown Structure Currency

O_GRAND

Grand Total Amount in OBS Currency

Decimal

Grand Total Amount in Organization Work Breakdown Structure Currency

O_GRAND_BAL

Decimal

Grand Total Balance Amount in Organization Work Breakdown Structure Currency

O_CURR

OBS Currency

String

Organization Work Breakdown Structure Currency

O_CURR_RATE

OBS Currency

Decimal

Organization Work Breakdown Structure Currency

W_ALC_B

Business Alcohol Amount in WBS Currency

Decimal

Business Alcohol Amount in WBS Currency 

W_ALC_P

Personal Alcohol Amount in WBS Currency 

Decimal

Personal Alcohol Amount in WBS Currency 

W_TAX1_B

Business Tax1 Amount in WBS Currency 

Decimal

Business Tax1 Amount in WBS Currency 

W_TAX1_P

Personal Tax1 Amount in WBS Currency 

Decimal

Personal Tax1 Amount in WBS Currency 

W_TAX2_B

Business Tax2 Amount in WBS Currency 

Decimal

Business Tax2 Amount in WBS Currency 

W_TAX2_P

Personal Tax2 Amount in WBS Currency 

Decimal

Personal Business Amount in WBS Currency 

Decimal

Personal Business Amount in WBS Currency 

W_BASE_B

Base Business Amount in WBS Currency

Decimal

Base Business Amount in  WBS Currency

W_BASE_P

Base Personal Amount in WBS Currency

Decimal

Base Personal Amount in WBS Currency

W_GRAND

Grand Total Amount in WBS Currency

Decimal

 Grand Total Amount in WBS Currency

W_GRAND_BAL

Decimal

Grand Total Balance Amount in WBS Currency

W_CURR

WBS Currency

String

WBS Currency Code

W_CURR_RATE

WBS Currency Rate

Decimal

WBS Currency Rate

MILEAGE_BUSINESS

Business Mileage

Decimal

Business Mileage

MILEAGE_PERSONAL

Personal Mileage

Decimal

Personal Mileage

MILEAGE_RATE

Mileage Rate

Decimal

Mileage Rate

MILEAGE_TOTAL

Mileage Total

Decimal

Mileage Total

PARTIAL_DAY_DEDUCTION

Partial Day Deduction 

Decimal

Partial Day Deduction 

PERDIEM_RATE 

Per Diem Rate

Decimal

Per Diem Rate

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

EXP_CODE_NAME

Expense Code

String

Expense Code 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

PAID_VENDOR_ID

Paid Vendor ID

String

Paid to Vendor ID by default it is always the employee vendor for expense reporting.

PAYMENT_ND

Payment ND

String

Payment ND number - Not used.

POST_DATE

Post Date

Date

Extract Post Date that is provided during the extract of expense reports.

TRANS_NO
(XP_POST_TRANS_NO)

Post Transaction No

Integer

Post Transaction Number usually it is the Report ID

TRAN_ND

Transaction ND

Integer

Transaction ND is used for LAWON AP integration.

WORK_DEPT_NAME

Worked Department

String

Charged Department on the distribution line

WORK_OPT_NAME

Worked Operating Unit

String

Charged Operating Unit Name

XP_REPORT_PREV_STATUS

Report Previous Status

String

On Hold       
Released       
In Approval Status    
Rejected    
Approved

XP_REPORT_VAILD_STATUS

Report Validation Status

String

Report Validation Status could be one of the following: 
*Incomplete 
*Invalid Charge 
*Passed 
*Passed with warnings 
*No Action

LEVEL1_FLAG

WBS Level1 Flag

String

WBS Level 1 Flag that is linked to the Level1 Code

LEVEL1_TYPE

WBS Level1 Type

String

WBS Level1 Type

LEVEL2_FLAG

WBS Level2 Flag

String

WBS Level 2 Flag that is linked to the Level2 Code

LEVEL2_TYPE

WBS Level2 Type

String

WBS Level2 Type

MAIN_WBS_CODE

WBS Main WBS Code

String

WBS Main WBS Code

MAIN_WBS_NAME

WBS Main WBS Name

String

WBS Main WBS Name

BATCH_TYPE/POST_STATUS

Extract Batch Type

String

Extract Batch Type for either ACH, GL, AP, Payroll

BATCH_NO

Batch No.

Integer