EX_LVL3_MSTG1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	MC_PROCESS_TRANSID	Character(50)	VARCHAR2(50) NOT NULL	MasterCard ProcessorTransId
3	MC_PROCESS_DT	Date(10)	DATE	MasterCard Process Date
4	MC_ACCT_NUM	Character(19)	VARCHAR2(19) NOT NULL	Master Card Account Number
5	TRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	MC_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	MC Transaction Type
8	MC_DEB_CRD_FLG	Character(1)	VARCHAR2(1) NOT NULL	MC Debit Credit indicator
9	MC_TRANS_DT	Date(10)	DATE	MasterCard Transaction Date
10	MC_TRANS_AMNT	Signed Number(18,4)	DECIMAL(16,4) NOT NULL	MC transaction amount
11	MC_MERCHNT_NM	Character(50)	VARCHAR2(50) NOT NULL	MasterCard Merchant Name
12	MC_MERCHNT_CITY	Character(15)	VARCHAR2(15) NOT NULL	MasterCard Merchant City
13	MC_MERCH_STATE	Character(3)	VARCHAR2(3) NOT NULL	Master Card merchant state/province
14	MC_MERCH_CNTRY	Character(3)	VARCHAR2(3) NOT NULL	MC merchant country
15	MC_MERCH_TYPE	Character(5)	VARCHAR2(5) NOT NULL	MC Merchant Type
16	MC_ORIG_AMNT	Signed Number(18,4)	DECIMAL(16,4) NOT NULL	MC amount in original currency
17	MC_ORIG_CURR_CD	Character(3)	VARCHAR2(3) NOT NULL	Master Card original currency
18	MC_POST_CURR_CD	Character(3)	VARCHAR2(3) NOT NULL	Master Card posted currency
19	MC_INET_EXCH_RT	Signed Number(20,7)	DECIMAL(18,7) NOT NULL	MC Inet conversion Rate
20	MC_MERCH_TYPE1	Character(4)	VARCHAR2(4) NOT NULL	MC Merchant Type
21	MC_MERCHNT_POST	Character(13)	VARCHAR2(13) NOT NULL	MasterCard Merchant Postal
22	MC_CRDHLD_NAME	Character(35)	VARCHAR2(35) NOT NULL	MasterCard card holder name
23	AIRFARE_RCPT_NBR	Character(16)	VARCHAR2(16) NOT NULL	Airfare Receipt Number
24	MC_ARRIVE_DT	Date(10)	DATE	Arrival Date
25	MC_DEPART_DT	Date(10)	DATE	Departure Date
26	MC_NBR_NIGHTS	Number(4,0)	SMALLINT NOT NULL	Number of Nights
27	TXN_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Expense Location
28	ADVANCE_SOURCE	Character(4)	VARCHAR2(4) NOT NULL	Advance Source
29	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
30	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
31	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
32	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type
33	EXPEND_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Payment Type
34	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
35	EX_TRANS_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Expenses Transaction Type, used to categorize external data that is loaded into the expense product, for example corporate card expenses/credits, ATM advances and travel bookings. ALL=All Transaction Types ATMA=ATM Advance CCCR=Credit CCEX=Expense TRBK=Travel Reservation
36	INVALID_EMPLID	Character(1)	VARCHAR2(1) NOT NULL	Invalid Employee
37	INVALID_EX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Invalid Expense Type
38	INVALID_MON_CURR	Character(1)	VARCHAR2(1) NOT NULL	Invalid Monetary Currency
39	INVALID_TXN_CURR	Character(1)	VARCHAR2(1) NOT NULL	Invalid Transaction Currency
40	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
41	DELAY_DATE	Date(10)	DATE	Delay Days Date