SSF_CLIEOP_VW (SQL View)	Index Back
Clieop Item SF View NLD Cliep Items view NLD

SSF_CLIEOP_VW

(SQL View)

Clieop Item SF View NLD

Cliep Items view NLD

SELECT DISTINCT A.BUSINESS_UNIT , A.CONTRACT_NUM , A.DUE_DT FROM PS_ITEM_SF A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

3 DUE_DT Date(10) DATE Due Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
3	DUE_DT	Date(10)	DATE	Due Date