MBRPERSON_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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
3	SUPPORT_TEAM_MBR	Character(8)	VARCHAR2(8) NOT NULL	Team Member
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSONAL_DATA
5	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1 Default Value: PERSONAL_DATA.NAME
6	TEAM_MEMBER_TYPE	Character(6)	VARCHAR2(6) NOT NULL	Team Member Type Code Prompt Table: MEMBER_TYPE_TBL
7	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
8	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: OM_VNDR_CUST_VW
9	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. Prompt Table: REGNCD_MBR_VW
10	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
11	DEF_COMPCT_SRC	Character(4)	VARCHAR2(4) NOT NULL	Default Commission Pct Source MBR=Commissioned Member SCH=Commission Schedule
12	QUOTA_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Basis B=Bookings S=Shipments
13	COMM_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Commission %
14	COMM_BKS	Number(7,2)	DECIMAL(6,2) NOT NULL	Commission Payable at Bookings
15	COMM_SHP	Number(7,2)	DECIMAL(6,2) NOT NULL	Commission Payable at Shipping
16	COMM_INV	Number(7,2)	DECIMAL(6,2) NOT NULL	Commission Payable at Invoice
17	COMM_CASH	Number(7,2)	DECIMAL(6,2) NOT NULL	Commission Payable at Cash Rec
18	EXT_EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Electronic Mail Address
19	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
20	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code