AUC_DUP_ENT_VW3 (SQL View)	Index Back
Duplicate Entity View This View is meant to be a place holder for a level 1 grid and a level 2 grid. It doesn't have any functional use besides allowing for grids to be placed on the page and based on work record data.

AUC_DUP_ENT_VW3

(SQL View)

Duplicate Entity View

This View is meant to be a place holder for a level 1 grid and a level 2 grid. It doesn't have any functional use besides allowing for grids to be placed on the page and based on work record data.

SELECT SETID , BIDDER_ID , BIDDER_TYPE , CNTCT_SEQ_NUM FROM PS_AUC_USER_CONTCT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID

3 BIDDER_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier

4 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BIDDER_ID	Character(15)	VARCHAR2(15) NOT NULL	Bidder ID
3	BIDDER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bidder Type B=Bidder C=Customer P=Public U=Uploaded V=Supplier
4	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number