EX_SHTLN_EXC_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SHEET_ID	Character(10)	VARCHAR2(10) NOT NULL	Report ID
2	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
3	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type
4	OUT_OF_POLICY	Character(1)	VARCHAR2(1) NOT NULL	Authorized Amount Exceeded
5	EE_LOCAMT_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	Location Amount Comment
6	NO_RECEIPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	No Receipt
7	EE_NORCPT_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	No Receipt Comment
8	PREF_MRCH_NOT_USED	Character(1)	VARCHAR2(1) NOT NULL	Non-Preferred Merchant
9	EE_PRFMRC_COMMENT	Character(60)	VARCHAR2(60) NOT NULL	Preferred Vendor Comment
10	TAX_IMPLICATIONS	Character(1)	VARCHAR2(1) NOT NULL	Items with Tax Implications
11	DUPLICATES_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Duplicates Exist
12	EE_DPLCAT_COMMENT	Character(80)	VARCHAR2(80) NOT NULL	Duplicate Comment
13	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.
14	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.
15	VAT_RECEIPT	Character(1)	VARCHAR2(1) NOT NULL	No VAT Receipt