EX_MC_MNT_ERR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
2	MC_PROCESS_DT	Date(10)	DATE	MasterCard Process Date
3	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
4	MC_ACCT_NUM	Character(19)	VARCHAR2(19) NOT NULL	Master Card Account Number
5	MC_CRDHLD_NAME	Character(35)	VARCHAR2(35) NOT NULL	MasterCard card holder name
6	MC_EXPIRE_DT	Date(10)	DATE	MasterCard Expiry Date
7	MC_ACCT_OPEN_DT	Date(10)	DATE	Account Open Dt
8	MC_CREDIT_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Maximum Credit Limit
9	MC_TRANS_LIMIT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Limit per Transaction
10	MC_EFF_DT	Date(10)	DATE	Master Card Effective Date
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	PROFILE_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	Profile Exists
13	INV_EXP_DT	Character(1)	VARCHAR2(1) NOT NULL	Invalid Expiry Date
14	INV_BUS_UNIT	Character(1)	VARCHAR2(1) NOT NULL	Invalid Business Unit
15	INV_CUR_CD	Character(1)	VARCHAR2(1) NOT NULL	Invalid Currency Code
16	EX_COMP_FLAG	Character(3)	VARCHAR2(3) NOT NULL	Complete CMP=Complete NCP=Not Complete Default Value: NCP
17	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
18	MC_EMPLID	Character(20)	VARCHAR2(20) NOT NULL	MasterCard Employee ID
19	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
20	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
21	CREDIT_CARD_VENDOR	Character(5)	VARCHAR2(5) NOT NULL	Corporate Card Vendor