EX_ENHC_SMAMX_H

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSONAL_DATA
4	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
5	TRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	EX_ENHNC_DATA	Character(1)	VARCHAR2(1) NOT NULL	Enhanced Data Type A=Air Travel Enhanced Data C=Car Rental Enhanced Data D=Hotel Folio Enhc Data Visa 4.4 H=Hotel Folio Enhanced Data N=No Enhanced Data
8	EX_ENHC_DATE	Date(10)	DATE	Enhanced Data Date
9	EX_ENHC_DAYS	Number(5,0)	INTEGER NOT NULL	Enhanced Number of Days
10	EX_ENHC_TYPE_NBR	Character(50)	VARCHAR2(50) NOT NULL	Hotel Folio
11	ENHC_NAME_EX	Character(125)	VARCHAR2(125) NOT NULL	Renter Name
12	AMX_RETURN_LOC	Character(30)	VARCHAR2(30) NOT NULL	Amex Return Location
13	AMX_AIR_CARRIER_EX	Character(42)	VARCHAR2(42) NOT NULL	Air Carrier
14	AMX_AIR_CLASS_EX	Character(40)	VARCHAR2(40) NOT NULL	Air Class
15	AMX_AIR_ROUTING_EX	Character(100)	VARCHAR2(100) NOT NULL	Air Routing
16	ROOM_RATE_EX	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Room Rate
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code