SPSHTLNADJ_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	ADJUST_DT	Date(10)	DATE	Transaction Date
5	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
6	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 Default Value: PND
7	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
8	SHEET_RCPT_NUM	Number(3,0)	SMALLINT NOT NULL	Receipt Number
9	SHEET_RCPT_TOTAL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Local Amount
10	ARRIVAL_DATE	Date(10)	DATE	Arrival Date
11	DEPARTURE_DATE	Date(10)	DATE	Departure Date
12	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type Prompt Table: EX_TYPES_TBL
13	TRANS_DT	Date(10)	DATE	Transaction Date
14	REIMBURSEMENT_CD	Character(1)	VARCHAR2(1) NOT NULL	Deny N=Nonreimburseable P=Prepaid R=Reimburseable Default Value: R
15	PERSONAL_EXPENSE	Character(1)	VARCHAR2(1) NOT NULL	Personal Expense N=No Y=Yes Y/N Table Edit Default Value: N
16	REIMB_ACTION	Character(5)	VARCHAR2(5) NOT NULL	Reason Prompt Table: EX_ACTION_TBL
17	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.
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
19	TXN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Transaction Amount
20	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency Prompt Table: CURRENCY_CD_TBL
21	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
22	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor Default Value: 1
23	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. Prompt Table: RT_TYPE_TBL
24	GROSS_UP_EST_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Up Estimated Amount
25	TXN_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Expense Location Prompt Table: EX_LOCATION_VW
26	EXPEND_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Payment Type Prompt Table: EX_EXP_MTHD_TBL Set Control Field: BUSINESS_UNIT_GL
27	PREF_MRCHNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Preferred Merchant N=No Y=Yes Y/N Table Edit Default Value: N
28	MERCHANT_CD	Character(10)	VARCHAR2(10) NOT NULL	Preferred Merchant Prompt Table: EX_MERCHANT_VW
29	MERCHANT	Character(40)	VARCHAR2(40) NOT NULL	Merchant
30	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
31	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
32	AIRFARE_RCPT_NBR	Character(16)	VARCHAR2(16) NOT NULL	Airfare Receipt Number
33	DISTANCE	Number(8,2)	DECIMAL(7,2) NOT NULL	Distance Traveled
34	DISTANCE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Distance Type 3=Metres K=Kilometers M=Miles
35	DISTANCE_RT	Number(9,4)	DECIMAL(8,4) NOT NULL	Standard Distance Rate
36	NBR_NIGHTS	Number(3,0)	SMALLINT NOT NULL	Number of Nights Default Value: 1
37	EE_LOCAMT_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	Location Amount Comment
38	EE_NORCPT_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	No Receipt Comment
39	EE_PRFMRC_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	Preferred Vendor Comment
40	EE_DPLCAT_COMMENT	Character(80)	VARCHAR2(80) NOT NULL	Duplicate Comment
41	RECEIPT_VERIFIED	Character(1)	VARCHAR2(1) NOT NULL	Receipt Verified Y/N Table Edit Default Value: N
42	OUT_OF_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Authorized Amount Exceeded Y/N Table Edit Default Value: N
43	NO_RECEIPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	No Receipt Y/N Table Edit Default Value: N
44	PREF_MRCH_NOT_USED	Character(1)	VARCHAR2(1) NOT NULL	Non-Preferred Merchant Y/N Table Edit Default Value: N
45	TAX_IMPLICATIONS	Character(1)	VARCHAR2(1) NOT NULL	Items with Tax Implications Y/N Table Edit Default Value: N
46	DUPLICATES_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Duplicates Exist Y/N Table Edit Default Value: N
47	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. Y/N Table Edit Default Value: N
48	SPA_BILLING_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Billing Action B=Billable U=Nonbillable Default Value: B
49	BILLING_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Billing Action B=Billable I=Internal P=Personal U=Nonbillable
50	OVRRIDE_SPLT_SW	Character(1)	VARCHAR2(1) NOT NULL	Override Accounting Split Y/N Table Edit Default Value: N
51	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.
52	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross Up Indicator Y/N Table Edit Default Value: N
53	SEPCHK	Number(1,0)	SMALLINT NOT NULL	Separate Check Indicator
54	EX_CREDIT_REF	Character(60)	VARCHAR2(60) NOT NULL	Informational field used for reference when a credit line is entered in an expense sheet.
55	TRANS_DT_JULIAN	Number(3,0)	SMALLINT NOT NULL	Julian Transaction Date
56	STARTTM_PERDIEM	Time(15)	TIMESTAMP	Start Time (HH:MI)
57	ENDTM_PERDIEM	Time(15)	TIMESTAMP	End Time (HH:MI)
58	CRDMEM_ACCT_NBR	Character(44)	VARCHAR2(44) NOT NULL	Cardmember Number
59	BREAKFAST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Breakfast Provided Y/N Table Edit Default Value: N
60	LUNCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	Lunch Provided Y/N Table Edit Default Value: N
61	DINNER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Dinner Provided Y/N Table Edit Default Value: N
62	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
63	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
64	VAT_RECEIPT	Character(1)	VARCHAR2(1) NOT NULL	No VAT Receipt
65	VAT_INCLUDE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Includes VAT E=Exclude VAT I=Include VAT
66	VAT_ENTRD_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Entered VAT Amount
67	VAT_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Applicable
68	VAT_NRCVR_PRO_FLG	Character(1)	VARCHAR2(1) NOT NULL	Prorate Non-Recoverable VAT
69	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.
70	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.
71	VAT_TREATMENT_EXP	Character(3)	VARCHAR2(3) NOT NULL	VAT Treatment for Expenses DOM=Domestic VAT FOR=Foreign VAT NON=No VAT
72	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.
73	VAT_RECOVERY_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Recovery Percent
74	VAT_REBATE_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	VAT Rebate Percent
75	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
76	VAT_CF_ANLSYS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Chartfield Analysis E=Use Expense Line Chartfields N=Not Applicable V=Use VAT Accounting Chartfields
77	AIR_TKT_RECON_STAT	Character(1)	VARCHAR2(1) NOT NULL	Airline Ticket Reconciliation Status C=Cancelled N=Not Reconciled R=Reconciled Default Value: N
78	AMOUNT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
79	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
80	RATE_MULT_2	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
81	RATE_DIV_2	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
82	TE_INVOICE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Time and expense invoiced flag N=No Y=Yes
83	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
84	INVOICE_LINE	Number(5,0)	INTEGER NOT NULL	Invoice Line
85	INV_LINE_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Invoice Line Status 1=Generated 10=Adjusted by Ent Approver 11=Adjusted by Enterprise 2=Approved by Enterprise 3=Submitted to Enterprise 4=Denied by Enterprise 5=Submitted to Supplier 6=Approved by Supplier 7=Denied by Supplier 8=Canceled 9=Adjusted by Supplier
86	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged
87	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code