EM_SPOUTBL1_LNG (SQL View)	Index Back
Customer Outstanding Bal-REG Seller Bill Presentment / Customer Outstanding Balance view 1 - REG

EM_SPOUTBL1_LNG

(SQL View)

Customer Outstanding Bal-REG

Seller Bill Presentment / Customer Outstanding Balance view 1 - REG

SELECT DISTINCT BU.BUSINESS_UNIT , SEC.OPRID , BUL.LANGUAGE_CD , BUL.DESCRSHORT FROM PSOPRDEFN SEC , PS_BUS_UNIT_LANG BU , PS_BUS_UNIT_LANG BUL WHERE BU.BUSINESS_UNIT = BUL.BUSINESS_UNIT

Related Language Record for EM_SPOUTBAL1_VW EM_SPOUTBAL2_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

4 EM_BU_NAME_SHORT Character(10) VARCHAR2(10) NOT NULL Buyer Short Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	EM_BU_NAME_SHORT	Character(10)	VARCHAR2(10) NOT NULL	Buyer Short Name