SHEETLINE1_TEO3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
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	SHEET_RCPT_NUM	Number(3,0)	SMALLINT NOT NULL	Receipt Number
6	SHEET_RCPT_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Local Amount
7	ARRIVAL_DATE	Date(10)	DATE	Arrival Date
8	DEPARTURE_DATE	Date(10)	DATE	Departure Date
9	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type
10	TRANS_DT	Date(10)	DATE	Transaction Date
11	REIMBURSEMENT_CD	Character(1)	VARCHAR2(1) NOT NULL	Deny N=Nonreimburseable P=Prepaid R=Reimburseable
12	PERSONAL_EXPENSE	Character(1)	VARCHAR2(1) NOT NULL	Personal Expense N=No Y=Yes
13	REIMB_ACTION	Character(5)	VARCHAR2(5) NOT NULL	Reason
14	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.
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	TXN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
17	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
18	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 Default Value: S
19	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
20	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
21	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.
22	GROSS_UP_EST_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Up Estimated Amount
23	TXN_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Expense Location
24	EXPEND_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Payment Type
25	PREF_MRCHNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Preferred Merchant N=No Y=Yes
26	MERCHANT_CD	Character(10)	VARCHAR2(10) NOT NULL	Preferred Merchant
27	MERCHANT	Character(40)	VARCHAR2(40) NOT NULL	Merchant
28	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
29	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
30	AIRFARE_RCPT_NBR	Character(16)	VARCHAR2(16) NOT NULL	Airfare Receipt Number
31	DISTANCE	Number(8,2)	DECIMAL(7,2) NOT NULL	Distance Traveled
32	DISTANCE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Distance Type 3=Metres K=Kilometers M=Miles
33	DISTANCE_RT	Number(9,4)	DECIMAL(8,4) NOT NULL	Standard Distance Rate
34	NBR_NIGHTS	Number(3,0)	SMALLINT NOT NULL	Number of Nights
35	EE_LOCAMT_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	Location Amount Comment
36	EE_NORCPT_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	No Receipt Comment
37	EE_PRFMRC_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	Preferred Vendor Comment
38	EE_DPLCAT_COMMENT	Character(80)	VARCHAR2(80) NOT NULL	Duplicate Comment
39	RECEIPT_VERIFIED	Character(1)	VARCHAR2(1) NOT NULL	Receipt Verified
40	OUT_OF_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Authorized Amount Exceeded
41	NO_RECEIPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	No Receipt
42	PREF_MRCH_NOT_USED	Character(1)	VARCHAR2(1) NOT NULL	Non-Preferred Merchant
43	TAX_IMPLICATIONS	Character(1)	VARCHAR2(1) NOT NULL	Items with Tax Implications
44	DUPLICATES_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Duplicates Exist
45	CC_FEED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Field used to indicate whether a credit card feed was used to populate an expense sheet or not.
46	BILL_CODE_EX	Character(3)	VARCHAR2(3) NOT NULL	Expense Billing Code
47	BILLING_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Billing Action B=Billable I=Internal P=Personal U=Nonbillable
48	OVRRIDE_SPLT_SW	Character(1)	VARCHAR2(1) NOT NULL	Override Accounting Split
49	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.
50	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross Up Indicator
51	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate Check Indicator
52	EX_CREDIT_REF	Character(60)	VARCHAR2(60) NOT NULL	Informational field used for reference when a credit line is entered in an expense sheet.
53	TRANS_DT_JULIAN	Number(3,0)	SMALLINT NOT NULL	Julian Transaction Date
54	STARTTM_PERDIEM	Time(15)	TIMESTAMP	Start Time (HH:MI)
55	ENDTM_PERDIEM	Time(15)	TIMESTAMP	End Time (HH:MI)
56	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
57	BREAKFAST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Breakfast Provided
58	LUNCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Lunch Provided
59	DINNER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Dinner Provided
60	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
61	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
62	VAT_RECEIPT	Character(1)	VARCHAR2(1) NOT NULL	No VAT Receipt Y/N Table Edit Default Value: N
63	VAT_ENTRD_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Entered VAT Amount
64	VAT_NRCVR_PRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Non-Recoverable VAT Y/N Table Edit
65	VAT_NRCVR_ALL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allocate Non-Recoverable VAT Y/N Table Edit
66	TAX_CD_VAT	Character(8)	VARCHAR2(8) NOT NULL	Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for. Prompt Table: VAT_HEADER_VW
67	TAX_CD_VAT_PCT	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
68	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment
69	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales. Prompt Table: VAT_TXN_CD
70	VAT_RECOVERY_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Recovery Percent
71	VAT_REBATE_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Rebate Percent
72	VAT_ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	" Rounding rule to be applied to VAT calculations. Options are 'Natural' D=Round Down N=Natural Round U=Round Up
73	VAT_APPLICABILITY	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible. E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated
74	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type Prompt Table: VAT_USE_TBL
75	VAT_RECLAIM_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Reclaim Percent
76	VAT_RCLM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Reclaim Amount
77	VAT_RCLM_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base VAT Reclaim Amount
78	VAT_NONTX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Non-Taxable Amount
79	VAT_NONTX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Non-Taxable Amount
80	VAT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
81	VAT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	VAT Amount in Base Curr
82	VAT_AUTO_CALC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Automatically Calculate VAT N=No Y=Yes Y/N Table Edit
83	TXN_CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency Display
84	CURRENCY_CD1	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
85	AIR_TKT_RECON_STAT	Character(1)	VARCHAR2(1) NOT NULL	Airline Ticket Reconciliation Status C=Cancelled N=Not Reconciled R=Reconciled
86	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.
87	NBR_PASSENGERS	Number(2,0)	SMALLINT NOT NULL	Number of Passengers
88	TRANSPORT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Transportation Type
89	TRANSPORT_ID	Character(15)	VARCHAR2(15) NOT NULL	Transportation ID
90	RANGE_SEQ	Number(3,0)	SMALLINT NOT NULL	Per Diem Range
91	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
92	MOBILE_POPWKEY	Character(50)	VARCHAR2(50) NOT NULL	Mobile Id
93	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
94	VAT_DFLT_DONE_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Defaulting Done N=Awaiting Defaulting X=Do not default Y=Defaulting Done
95	APPROVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Approve Flag
96	APPROVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Approver Oprid
97	APPROVER_ACTN_DT	Date(10)	DATE	The Date on which the approver takes necessary action
98	APPROVER_ADD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	New Approver Add Flag
99	UNDENY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Undeny Flag
100	ITINERARY_ID	Character(18)	VARCHAR2(18) NOT NULL	Itinerary ID for Travel Reservations
101	RESERVATION_NBR	Number(3,0)	SMALLINT NOT NULL	reservation sequence number
102	ISCHANGED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Record has been changed
103	EX_TYPE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Expense Type Flag
104	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code