SCR_ID_NBORG_VW

(SQL View)
Index Back

SCR Additional ID


SELECT SETID ,VENDOR_ID ,STD_ID_NUM_QUAL , STD_ID_NUM , STD_ID_SETID , CREDIT_FLG FROM PS_VENDOR_ID_NBRS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
4 STD_ID_NUM Character(35) VARCHAR2(35) NOT NULL ID Number
5 STD_ID_SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 CREDIT_FLG Character(1) VARCHAR2(1) NOT NULL Credit Flag
N=No
Y=Yes