EX_TYPES_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	EXPENSE_TYPE	Character(7)	VARCHAR2(7) NOT NULL	Expense Type
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	EXPENSE_TYPE_EDIT	Character(3)	VARCHAR2(3) NOT NULL	Expense Type Edit AIR=Airfare ATT=Attendees AUT=Automobile HTL=Hotel NON=None PDL=Per Diem Lodging PDM=Per Diem RTL=Rental Default Value: NON
6	EXPENSE_TYPE_GROUP	Character(7)	VARCHAR2(7) NOT NULL	Expense Type Group Prompt Table: EX_TYPE_GRP_TBL
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
9	PREF_MRCHNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Preferred Merchant N=No Y=Yes Y/N Table Edit Default Value: N
10	LOC_REQD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Location Required Y/N Table Edit Default Value: N
11	DESCR_REQD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Description Required Y/N Table Edit Default Value: N
12	MERCHANT_REQD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Merchant Required Y/N Table Edit Default Value: N
13	TRAVEL_FROM_FLG	Character(1)	VARCHAR2(1) NOT NULL	Originating Location Y/N Table Edit Default Value: N
14	NBR_PASSENGER_FLG	Character(1)	VARCHAR2(1) NOT NULL	Number of Passengers Y/N Table Edit Default Value: N
15	TRANSPORT_TYPE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Transportation Type Y/N Table Edit Default Value: N
16	DURATION_FLG	Character(1)	VARCHAR2(1) NOT NULL	Duration Y/N Table Edit Default Value: N
17	TAX_IMPLICATIONS	Character(1)	VARCHAR2(1) NOT NULL	Items with Tax Implications Y/N Table Edit Default Value: N
18	HSN_CD	Character(10)	VARCHAR2(10) NOT NULL	HSN Code Prompt Table: GST_HSN
19	SAC_CD	Character(10)	VARCHAR2(10) NOT NULL	SAC Code Prompt Table: GST_SAC
20	SERVICE_TYPE_GST	Character(3)	VARCHAR2(3) NOT NULL	GST Service Type 1=Service on Immoveable Property 10=Mobile Telecom PostPd 11=Mobile Telecom PrePd 12=Banking/Financial Services 13=Insurance Services 2=Restaurant/Hotel/Lodging 3=Catering/Beauty/Medical 4=Training/Performance appraisal 5=Admission to Events 6=Organization of Events 7=Courier/Mail for goods 8=Transportation of Passengers 9=Fixed Telecom services 99=Other Services
21	TAX_CATEGORY	Character(10)	VARCHAR2(10) NOT NULL	Tax Category Code Prompt Table: EXS_TAX_CAT_VW1
22	GROSSUP	Character(1)	VARCHAR2(1) NOT NULL	Gross Up Indicator Y/N Table Edit Default Value: N
23	BNCH_THRESHOLD_PCT	Number(7,4)	DECIMAL(6,4) NOT NULL	BenchMark Threshold Percent
24	PER_DIEM_TBL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Per Diem Amounts Default L=Location Amount Table P=Per Diem Table Default Value: L
25	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
26	PERSONAL_EXPENSE	Character(1)	VARCHAR2(1) NOT NULL	Personal Expense N=No Y=Yes Y/N Table Edit Default Value: N
27	MILEAGE_RECEIPT	Character(1)	VARCHAR2(1) NOT NULL	No Receipt Required Y/N Table Edit Default Value: N
28	RECEIPT_REQ_SETUP	Character(3)	VARCHAR2(3) NOT NULL	Receipt Required Ex Types ALW=Always BUS=Default to BU Setup NEV=Never Default Value: BUS
29	LOC_AMT_GRP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Enable Group Location Limits Y/N Table Edit Default Value: Y