CUST_TEAM_EVW (SQL View)	Index Back
Customer Team View Customer Team View

CUST_TEAM_EVW

(SQL View)

Customer Team View

SELECT SETID , CUST_ID , SUPPORT_TEAM_CD , DEFAULT_FLAG , LAST_MAINT_OPRID , DATE_LAST_MAINT 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_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

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
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
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