AUC_DUMMY3_VW (SQL View)	Index Back
Sourcing Group Summary 3

AUC_DUMMY3_VW

(SQL View)

Sourcing Group Summary 3

SELECT COUNTRY ,'X' , 0 ,' ' , 0 , ' ' FROM PS_INSTALLATION WHERE 1 = 4

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

2 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field for Hiding Groups

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

4 BID_FACTOR_CD Character(18) VARCHAR2(18) NOT NULL Bid Factor Code

5 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals

6 COMMENTS_2000 Long Character CLOB Comment Text

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
2	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field for Hiding Groups
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	BID_FACTOR_CD	Character(18)	VARCHAR2(18) NOT NULL	Bid Factor Code
5	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals
6	COMMENTS_2000	Long Character	CLOB	Comment Text