CUSTMST_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

CUSTMST_TEAM_VW

(SQL View)

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

# 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 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Default Value: CUSTOMER.CUST_ID
Prompt Table: CUSTOMER

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

#	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	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Default Value: CUSTOMER.CUST_ID Prompt Table: CUSTOMER
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