CUSTTMP_TEAM_VW

(SQL View)
 Index Back

Customer Sales People

This table stores the support team code associated with a Ship To customer. Date Init. Issue # Description 08/14/01 JJM DI-EDWONG-17 Inverted CUST_ID, SETID in index

SELECT A.SETID , A.CUST_ID , A.SUPPORT_TEAM_CD , A.DEFAULT_FLAG , A.LAST_MAINT_OPRID , A.DATE_LAST_MAINT FROM PS_CUST_TEAM A , PS_CUSTOMER C WHERE %Join(COMMON_KEYS, CUST_TEAM A, CUSTOMER C) AND A.DEFAULT_FLAG = 'Y' AND C.CUST_STATUS = 'T'

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

Default Value: CUSTOMER.SETID

Prompt Table: SP_SETID_NONVW

2 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
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

5 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
6 DATE_LAST_MAINT Date(10) DATE Date Last Maintained