Expense Credit Card Reconciliation Domain

5.1.x to 5.4.4

Expense Credit Card Reconciliation 5.0.x

Domains

5.5 and higher

Expense Credit Card Reconciliation

DomainsV55

APPLIED_PERS_AMOUNT

Applied Personal Amount

Decimal

Applied the personal amount on the expense line charge.

APPLIED_REIM_AMOUNT

Applied Business Amount

Decimal

Applied Business Amount on the expense report

APPLIED_TOTAL_AMOUNT

Applied Total Amount

Decimal

Applied Total Amount on the expense report

BATCH_DATE
(XP_CC_LOAD_DATE)

Loaded Date

Date

Date Batch was Loaded

BILLING_CURR_AMT
(CC_BILL_AMT)

Credit Card Billing Amount

Decimal

Credit Card billing amount

BILLING_CURR_CODE
(CC_BILL_CURR)

Credit Card Billing Currency

String

Credit Card Billing Currency

CC_BATCH_NO

Batch No

Integer

Credit Card Batch Number

CC_IND_CODE

Industrial Code

String

Credit Card Industrial Code

CC_IND_CODE_NAME

Industrial Code Name

String

Credit Card Industrial Code Name

CC_NUMBER

Credit Card Number

String

Credit Card Number

CC_TRANS_NO

Internal Trans. No

Integer

Databasics internal Transaction Number

DEPT_CODE
(HOME_DEPT_CODE)

Home Department Code

String

Home Department Code

DESCR

Description

String

Credit Card Charge Description

EMP_ACTIVE

Active Employee

String

Employee Active Yes or No

EMPLY_ID

Employee ID

String

Employee Id

EMPLY_TYPE_NAME

Employee Type

String

Employee Type Name

EXCHANGE_RATE
(CC_EXCHANGE_RATE)

Credit Card Exchange Rate

Decimal

Currency Rate if the Currency From is different than Report Currency

FILE_NAME
(XP_CC_FILE_NAME)

File Name

String

Batch File Name

HDR_STATUS
(XP_REPORT_STATUS)

Report Status

String

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

HDR_TITLE

Report Title

String

Report Title

HOME_DEPT_NAME

Home Department

String

Home Department Name

HOME_OPT_NAME

Home Operating Unit

String

Home Operating Unit Name

LAST_FIRST

Full Name (Last, First)

String

Employee/User Last Name, First Name

OPT_CODE
(HOME_OPT_CODE)

Home Operating Unit Code

String

Home Operating Unit Code

OTHER_EMPLY_ID1

Other Employee ID1

String

Employee Other id1 that is mapped to OTHER_EMPLY_ID1 in the employee table

OTHER_EMPLY_ID1

Other Employee ID2

String

Employee Other id2

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

PROCESS_STATUS
(XP_REPORT_PROC_STATUS)

Process Status

String

Process Status of the expense report that the Credit Card charge got applied to. 
Process Status could be one of the following:
Fully Paid 
Partially Paid 
Posted for Payment 
No action (Default - Not posted)

REPORT_ID

Report ID

String

Report Id, if Transaction is not applied will be blank

REPORT_ID_SORT

Report ID Sort

String

Report Id in which the Transaction was applied, if Transaction is not applied will be blank

ROUTED_BY

Routed by

String

Employee Id of user who routed transaction

ROUTED_FROM_EMPLY_ID

Routed from User

String

Employee Id user that transaction was routed from

ROUTED_NOTE

Routed Notes

String

Routed note

RPT_CURR

Report Currency

Decimal

Currency of Report

SOURCE_CURR_AMT 
(CC_LOCAL_AMT)

Credit Card Local Amount

Decimal 

Credit Card Amount in the local currency before converting to the billing currency

SOURCE_CURR_CODE 
(CC_LOCAL_CURR)

Credit Card Local Currency

String 

Credit Card Local Currency (Charged currency)

SOURCE_TRANS_NO

Transaction No.

String 

Credit Card Source Transaction Number.

SSN

SSN

String

Employee Other id that is mapped to SSN field.

VENDOR_ID

Vendor ID

String

Vendor ID that is linked to the report that got requested

VENDOR_NAME

Vendor

String

Vendor Name

XP_CERT_STATUS

Certify Status

String

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

BUSINESS_CHARGE

Business Charges

String

Credit Card Business Charges

TRANS_STATUS_NAME

Transaction Status

String

Transaction Status Name

EXP_TYPE

Expense Type Code

String

Default Expense Type ID

EXP_TYPE_NAME

Expense Type

String

Default Expense Type Name

CHARGED_DATE

Charge Date

Date

Credit Card Charge Date

POST_DATE

Post Date

Date

Credit Card Charge Post Date

ROUTED_DT

Routed Date

DateTime

Date and time stamp of when transaction was routed

LOCATION_CODE 
(HOME_LOC_CODE)

Home Location Code

String

Home Location Code

HOME_LOC_NAME

Home Location

String

Home Location Name

TODAY_DATE

Date

Today's Date - Used for Scheduling Report