EX_TRANS_TEO2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSONAL_DATA
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	TRANS_NBR	Character(24)	VARCHAR2(24) NOT NULL	Transaction Number
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	ITEM_SEQ_NBR	Number(5,0)	INTEGER NOT NULL	Item Sequence Number
7	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
8	CCTRANS_TYPE_CD	Character(2)	VARCHAR2(2) NOT NULL	Credit Card Transaction Code
9	EX_DOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Identifies Expenses Document Type A=Cash Advance C=Time Report J=Time Adjustment M=Accrual - My Wallet R=Accrual - Expense Report S=Expense Report T=Travel Authorization
10	ADVANCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Advance ID
11	ADVANCE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Advance Description
12	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
13	SHEET_NAME	Character(30)	VARCHAR2(30) NOT NULL	Report Description
14	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
15	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type
16	RECEIPT_VERIFIED	Character(1)	VARCHAR2(1) NOT NULL	Receipt Verified Y/N Table Edit
17	TRANS_DT	Date(10)	DATE	Transaction Date
18	TXN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
19	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency Prompt Table: CURRENCY_CD_TBL
20	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
21	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
22	CUR_EXCHNG_RT	Number(16,8)	DECIMAL(15,8) NOT NULL	Currency Exchange Rate
23	RATE_USR_DFN	Character(1)	VARCHAR2(1) NOT NULL	The field indicates the type of Exchange rate to be used. User defined or system default D=Custom - Direct I=Custom - Indirect S=System Default
24	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
25	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
26	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
27	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
28	TXN_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Expense Location
29	EXPEND_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Payment Type
30	PREF_MRCHNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Preferred Merchant N=No Y=Yes
31	MERCHANT_CD	Character(10)	VARCHAR2(10) NOT NULL	Preferred Merchant
32	MERCHANT	Character(40)	VARCHAR2(40) NOT NULL	Merchant
33	NBR_NIGHTS	Number(3,0)	SMALLINT NOT NULL	Number of Nights
34	AIRFARE_RCPT_NBR	Character(16)	VARCHAR2(16) NOT NULL	Airfare Receipt Number
35	AIR_TKT_RECON_STAT	Character(1)	VARCHAR2(1) NOT NULL	Airline Ticket Reconciliation Status C=Cancelled N=Not Reconciled R=Reconciled
36	DAYS_OUTSTANDING	Number(4,0)	SMALLINT NOT NULL	Days Outstanding
37	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
38	CORP_ACCT_NBR	Character(20)	VARCHAR2(20) NOT NULL	Corporate Number
39	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
40	SUPPLIER_NBR	Character(11)	VARCHAR2(11) NOT NULL	Supplier Reference Nbr
41	ADVANCE_SOURCE	Character(4)	VARCHAR2(4) NOT NULL	Advance Source
42	TXN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Transaction Status A=Assigned D=Marked for Delete R=Rejected T=All Transaction Statuses U=Unassigned Default Value: R
43	TXN_LOAD_DATE	Date(10)	DATE	Transaction Load Date
44	DESCR_LN1	Character(50)	VARCHAR2(50) NOT NULL	Description Line 1
45	DESCR_LN2	Character(50)	VARCHAR2(50) NOT NULL	Description Line 2
46	DESCR_LN3	Character(50)	VARCHAR2(50) NOT NULL	Description Line 3
47	DESCR_LN4	Character(50)	VARCHAR2(50) NOT NULL	Description Line 4
48	EMP_NOTIFY_SW	Character(1)	VARCHAR2(1) NOT NULL	Employee Notified
49	MOBILE_DWNLD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Picked Up By Mobile N=No Y=Yes
50	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
51	DISTANCE	Number(8,2)	DECIMAL(7,2) NOT NULL	Distance Traveled
52	DISTANCE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Distance Type 3=Metres K=Kilometers M=Miles
53	MOBILE_SYNC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marks the synchronization status of a mobile transaction A=Assigned N=New R=Repeat S=Synchronized
54	MOBILE_POPWKEY	Character(50)	VARCHAR2(50) NOT NULL	Mobile Id
55	EX_DOC_ID	Character(10)	VARCHAR2(10) NOT NULL	Documentation ID
56	PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Processing Flag
57	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
58	PERSONAL_EXPENSE	Character(1)	VARCHAR2(1) NOT NULL	Personal Expense N=No Y=Yes
59	EX_TYPE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Expense Type Flag
60	ENHC_DATA_LOADED	Character(1)	VARCHAR2(1) NOT NULL	Enhanced Data Loaded
61	CC_POSTING_DT	Date(10)	DATE	Credit Card Posting Date
62	EX_AMX_TRANSNBR	Character(50)	VARCHAR2(50) NOT NULL	Amex Global Transaction Nbr
63	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code