EX_AMEX_HTLSTG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AMX_TRANS_NO	Character(15)	VARCHAR2(15) NOT NULL	Transaction Number
2	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
3	AMX_CHRG_DATE	Date(10)	DATE	Amex Transaction Charge Date
4	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
5	AMX_BILL_ACCT_NO	Character(19)	VARCHAR2(19) NOT NULL	Account Number
6	AMX_TRANS_TYPE_CD	Character(2)	VARCHAR2(2) NOT NULL	Amex File Transaction Type Code
7	AMX_FINAN_CTGY_CD	Character(2)	VARCHAR2(2) NOT NULL	Amex File Financial Cat Cd
8	AMX_MIS_INDUS_CD	Character(3)	VARCHAR2(3) NOT NULL	MIS Industry Code
9	AMX_BILL_ISOA_CURR	Character(3)	VARCHAR2(3) NOT NULL	Billed Currency Code
10	AMX_TXN_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amex Transaction Amount
11	AMX_LOC_ISOA_CURR	Character(3)	VARCHAR2(3) NOT NULL	Local Currency Code
12	AMX_MON_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amex Monetary Amount
13	AMX_EXCH_RT	Number(24,8)	DECIMAL(23,8) NOT NULL	Amex File Exchange Rate
14	AMX_SE_CITY_NM	Character(40)	VARCHAR2(40) NOT NULL	Amex File SE City Name
15	AMX_ISO_CNTRY_CD	Character(3)	VARCHAR2(3) NOT NULL	Amex File ISO Country Cd
16	AMX_SE_STATE_CD	Character(6)	VARCHAR2(6) NOT NULL	Amex File SE State Cd
17	AMX_SE_NM_1_TX	Character(40)	VARCHAR2(40) NOT NULL	Amex File SE Name 1
18	AMX_LODGING_NIGHTS	Number(2,0)	SMALLINT NOT NULL	Amex Lodging Number of Nights
19	AMX_TICKET_NBR	Character(15)	VARCHAR2(15) NOT NULL	Amex Airline Ticket Number
20	AMX_CRDHLDR_NAME	Character(50)	VARCHAR2(50) NOT NULL	Cardholder's Name
21	AMX_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Emplid from Amex File
22	AMX_EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type
23	AMX_TXN_CURR_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency Code
24	AMX_MON_CURR_CD	Character(3)	VARCHAR2(3) NOT NULL	Monetary Currency Code
25	AMX_CNTRY_CD	Character(3)	VARCHAR2(3) NOT NULL	Country Code
26	AMX_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Amex Location
27	AMX_EXPEND_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Expenditure Method
28	AMX_ADV_SRC	Character(4)	VARCHAR2(4) NOT NULL	Advance Source
29	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
30	INVALID_EX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Invalid Expense Type
31	INVALID_MON_CURR	Character(1)	VARCHAR2(1) NOT NULL	Invalid Monetary Currency
32	INVALID_TXN_CURR	Character(1)	VARCHAR2(1) NOT NULL	Invalid Transaction Currency
33	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
34	DELAY_DATE	Date(10)	DATE	Delay Days Date
35	PERSONAL_EXPENSE	Character(1)	VARCHAR2(1) NOT NULL	Personal Expense N=No Y=Yes
36	EX_TYPE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Expense Type Flag
37	ENHC_DATA_LOADED	Character(1)	VARCHAR2(1) NOT NULL	Enhanced Data Loaded
38	CC_POSTING_DT	Date(10)	DATE	Credit Card Posting Date
39	EX_AMX_TRANSNBR	Character(50)	VARCHAR2(50) NOT NULL	Amex Global Transaction Nbr