TEAM_MEMBER_LNG (SQL View)	Index Back
Related Language Record Related Language Record for TEAM_MEMBER_VW

TEAM_MEMBER_LNG

(SQL View)

Related Language Record

Related Language Record for TEAM_MEMBER_VW

SELECT A.SETID , A.SUPPORT_TEAM_MBR , C.LANGUAGE_CD , A.NAME1 FROM PS_MEMBER_PERSON A , PS_MEMBER_TYPE_TBL B , PS_MEMBER_PRSN_LNG C WHERE A.TEAM_MEMBER_TYPE = B.TEAM_MEMBER_TYPE AND B.SETID = A.SETID AND %EffdtCheck(MEMBER_TYPE_TBL B1, B, %CurrentDateIn) AND B.SALES_PERSON = 'Y' AND A.SETID = C.SETID AND A.SUPPORT_TEAM_MBR = C.SUPPORT_TEAM_MBR

Related Language Record for BI_SALES_PER_VW BI_TEAM_MBR_VW TEAM_MEMBER_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 SALES_PERSON Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	SALES_PERSON	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1