CUST_BUPPVW_LNG (SQL View)	Index Back
Cust Prompt by BU for PP- RLR Cust Prompt by BU for PP- RLR

CUST_BUPPVW_LNG

(SQL View)

Cust Prompt by BU for PP- RLR

SELECT DISTINCT D.BUSINESS_UNIT , C.CUST_ID , C.LANGUAGE_CD , C.NAME1 FROM PS_CUSTOMER_LANG C , PS_BUS_UNIT_TBL_AR D WHERE C.SETID IN ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = D.BUSINESS_UNIT AND RECNAME = 'CUSTOMER')

Related Language Record for CUST_BU_PP_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PP_MAIN_BU Character(5) VARCHAR2(5) NOT NULL Main Control Account BU

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.

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	PP_MAIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Main Control Account BU
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.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1