CUSTCPY_TEAM_VW

(SQL View)
Index Back

Cust Copy-Sales People Vw

View of Team data on the customer record for copy function.

SELECT SETID, CUST_ID, SUPPORT_TEAM_CD, DEFAULT_FLAG FROM PS_CUST_TEAM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: CUSTOMER.SETID

2 CUST_CPY_ID Character(15) VARCHAR2(15) NOT NULL Customer Copy ID
3 SUPPORT_TEAM_CD Character(6) VARCHAR2(6) NOT NULL Support Team Code

Prompt Table: TEAM_CODE_TBL

4 DEFAULT_FLAG Character(1) VARCHAR2(1) NOT NULL Default

Y/N Table Edit

Default Value: N