SUP_FL_IDNUM_VW

(SQL View)
Index Back

Strat Sourcing ID Numbers view

10/10/2016: CK Supplier/Bidder ID Numbers view.

SELECT A.SETID ,A.BIDDER_ID ,A.SUP_OB_REG_ID ,B.STD_ID_NUM_QUAL ,B.STD_ID_NUM FROM PS_AUC_BIDDER_HDR A , PS_BIDDER_ID_NBRS B WHERE A.SETID=B.SETID AND A.BIDDER_ID =B.BIDDER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 BIDDER_ID Character(15) VARCHAR2(15) NOT NULL Bidder ID
3 SUP_OB_REG_ID Character(10) VARCHAR2(10) NOT NULL * Registration ID
4 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
5 STD_ID_NUM Character(35) VARCHAR2(35) NOT NULL ID Number