EX_AMEX_STG_ERR

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