EX_TYPE_MERCHNT (SQL Table)	Index Back
Expense Types Merchant Table This is a child of the Expense Type Setup Table where one can assign one or more preferred merchants to an expense type.

EX_TYPE_MERCHNT

(SQL Table)

Expense Types Merchant Table

This is a child of the Expense Type Setup Table where one can assign one or more preferred merchants to an expense type.

Parent record: 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

4 MERCHANT_CD Character(10) VARCHAR2(10) NOT NULL Preferred Merchant
Prompt Table: EX_MERCHANT_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
4	MERCHANT_CD	Character(10)	VARCHAR2(10) NOT NULL	Preferred Merchant Prompt Table: EX_MERCHANT_TBL