CA_CUST_LG_VW (SQL View)	Index Back
Contracts Cust Language View Language view for the customer data. This view is used in the prompt for selecting the customer while creating the contract.

CA_CUST_LG_VW

(SQL View)

Contracts Cust Language View

Language view for the customer data. This view is used in the prompt for selecting the customer while creating the contract.

SELECT A.SETID , A.CUST_ID , A.LANGUAGE_CD , A.NAME1 FROM PS_CUSTOMER_LANG A

Related Language Record for CA_CUST_SLD_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL 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.

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