EX_NONPREFMERCH (SQL Table)	Index Back
Non Preferred Merchant Define Non Preferred Merchant Justifications.

EX_NONPREFMERCH

(SQL Table)

Non Preferred Merchant

Define Non Preferred Merchant Justifications.

# 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
Prompt Table: EX_NONPREF_VW

3 NONPREFMERCH_ID Character(10) VARCHAR2(10) NOT NULL Non-Preferred Merchant ID

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	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 Prompt Table: EX_NONPREF_VW
3	NONPREFMERCH_ID	Character(10)	VARCHAR2(10) NOT NULL	Non-Preferred Merchant ID
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
7	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description