EX_EM_MAP_TBL

(SQL Table)
 Index Back

CC Code to Expnd Mthd Mapping

Corporate card code to expenditure method mapping.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 DATA_SOURCE_EX Character(3) VARCHAR2(3) NOT NULL External Data Sources for PS Expenses
AIR=Airline Ticket
AMA=American Express
AMG=American Express
AMH=American Express-Hotel Folio
AMM=American Express - Member List
AMX=American Express
CNS=CONUS
DC=Diners Club
IPH=iReceipts
MC=MasterCard CDFv2
MCX=MasterCard CDFv3
MSG=Text Message
NAP=PS NA Payroll
PDA=PDA
RNZ=Runzheimer
SAB=Sabre
UBT=User Chatbot
USB=US Bank
USR=User Input
VI4=Visa
VIS=Visa
3 SETID_VENDOR_CC Character(5) VARCHAR2(5) NOT NULL SetID Card Issuer

Prompt Table: SP_SETID_NONVW

4 CREDIT_CARD_VENDOR Character(5) VARCHAR2(5) NOT NULL Corporate Card Vendor

Prompt Table: %EDITTABLE5

5 CC_TO_EM_CD Character(10) VARCHAR2(10) NOT NULL Credit Card Code
6 CC_TO_EM_CD_DESCR Character(36) VARCHAR2(36) NOT NULL Description
7 EXPEND_MTHD Character(3) VARCHAR2(3) NOT NULL Payment Type

Prompt Table: EX_EXP_MTHD_TBL