TAUTHLINE_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	TRAVEL_AUTH_ID	Character(10)	VARCHAR2(10) NOT NULL	Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	EX_LINE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	The Line Status of an Expenses transaction (i.e. Expense Report, Cash Advance, Travel Authorization, Time Report) ADJ=Adjusted APR=Approved APY=Approved for Payment CLS=Closed DEN=Denied DNA=Denied by Approver DNC=Denied DNU=Denied by Auditor ESC=Escheated Payment HDA=Hold by Approver HDU=Hold by Auditor HLD=Hold MFS=Marked For Submit OPN=Open PAR=Approvals in Process PD=Paid PND=Pending PRO=In Process RAP=Approved STG=Staged SUB=Submitted XML=Submitted, Pending Validation
5	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type
6	TRANS_DT	Date(10)	DATE	Transaction Date
7	PREPAID_EXPENSE	Character(1)	VARCHAR2(1) NOT NULL	Pre-Paid Expense
8	REIMBURSEMENT_CD	Character(1)	VARCHAR2(1) NOT NULL	Deny N=Nonreimburseable P=Prepaid R=Reimburseable
9	REIMB_ACTION	Character(5)	VARCHAR2(5) NOT NULL	Reason
10	EXPEND_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Payment Type
11	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.
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	TXN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
14	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
15	TXN_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Expense Location
16	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
17	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
18	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
19	AIRFARE_RCPT_NBR	Character(16)	VARCHAR2(16) NOT NULL	Airfare Receipt Number
20	TRAVEL_FROM	Character(5)	VARCHAR2(5) NOT NULL	Used to indicate the starting point of travel for a travel authorization for airline expenditures. Defined on the EX_TAUTH_LINE record and used on various travel auth line panels. Used in conjunction with the TRAVEL_TO field to track the cost of flights to and from various locals.
21	TRAVEL_TO	Character(5)	VARCHAR2(5) NOT NULL	Used to indicate the ending point of travel for a travel authorization for airline expenditures. Defined on the EX_TAUTH_LINE record and used on various travel auth line panels. Used in conjunction with the TRAVEL_FROM field to track the cost of flights to and from various locals.
22	PREF_MRCHNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Preferred Merchant N=No Y=Yes
23	MERCHANT_CD	Character(10)	VARCHAR2(10) NOT NULL	Preferred Merchant
24	MERCHANT	Character(40)	VARCHAR2(40) NOT NULL	Merchant
25	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
26	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
27	DISTANCE	Number(8,2)	DECIMAL(7,2) NOT NULL	Distance Traveled
28	DISTANCE_RT	Number(9,4)	DECIMAL(8,4) NOT NULL	Standard Distance Rate
29	DISTANCE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Distance Type 3=Metres K=Kilometers M=Miles
30	NBR_NIGHTS	Number(3,0)	SMALLINT NOT NULL	Number of Nights
31	NBR_DAYS	Number(3,0)	SMALLINT NOT NULL	Used to specify the number of days associated with a particular expense type for Travel Authorizations, i.e. breakfast, lunch. Found on many of the Travel Auth line records and panels.
32	EE_LOCAMT_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	Location Amount Comment
33	EE_PRFMRC_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	Preferred Vendor Comment
34	OUT_OF_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Authorized Amount Exceeded
35	TRANS_DT_JULIAN	Number(3,0)	SMALLINT NOT NULL	Julian Transaction Date
36	BILL_CODE_EX	Character(3)	VARCHAR2(3) NOT NULL	Expense Billing Code
37	BILLING_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Billing Action B=Billable I=Internal P=Personal U=Nonbillable
38	OVRRIDE_SPLT_SW	Character(1)	VARCHAR2(1) NOT NULL	Override Accounting Split
39	STARTTM_PERDIEM	Time(15)	TIMESTAMP	Start Time (HH:MI)
40	ENDTM_PERDIEM	Time(15)	TIMESTAMP	End Time (HH:MI)
41	NBR_PASSENGERS	Number(2,0)	SMALLINT NOT NULL	Number of Passengers
42	TRANSPORT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transportation Type
43	TRANSPORT_ID	Character(15)	VARCHAR2(15) NOT NULL	Transportation ID
44	RANGE_SEQ	Number(3,0)	SMALLINT NOT NULL	Per Diem Range
45	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
46	APPROVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Approve Flag
47	APPROVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Approver Oprid
48	APPROVER_ACTN_DT	Date(10)	DATE	The Date on which the approver takes necessary action
49	APPROVER_ADD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	New Approver Add Flag
50	UNDENY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Undeny Flag
51	ITINERARY_ID	Character(18)	VARCHAR2(18) NOT NULL	Itinerary ID for Travel Reservations
52	RESERVATION_NBR	Number(3,0)	SMALLINT NOT NULL	reservation sequence number
53	ISCHANGED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Record has been changed
54	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code