USF_VNDR_VW

(SQL View)
 Index Back

SAM Vendor Entities


SELECT XREF.USF_UEID , XREF.USF_EFT_IND , XREF.DUNS_NUMBER , XREF.USF_DODAAC , XREF.VENDOR_SETID , XREF.VENDOR_ID , VEND.VENDOR_STATUS , VEND.NAME1 , CASE WHEN VEND.CORPORATE_SETID = VEND.SETID THEN CASE WHEN VEND.CORPORATE_VENDOR = VEND.VENDOR_ID THEN ' ' ELSE VEND.CORPORATE_SETID END ELSE VEND.CORPORATE_SETID END , CASE WHEN VEND.CORPORATE_SETID = VEND.SETID THEN CASE WHEN VEND.CORPORATE_VENDOR = VEND.VENDOR_ID THEN ' ' ELSE VEND.CORPORATE_VENDOR END ELSE VEND.CORPORATE_VENDOR END , XREF.USF_DUNS_PLUS4 FROM PS_USF_VNDR_XREF XREF , PS_VENDOR VEND WHERE XREF.VENDOR_SETID = VEND.SETID AND XREF.VENDOR_ID = VEND.VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 USF_UEID Character(12) VARCHAR2(12) NOT NULL Unique Entity Identifier
2 USF_EFT_IND Character(4) VARCHAR2(4) NOT NULL Entity EFT Indicator
3 DUNS_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number
4 USF_DODAAC Character(9) VARCHAR2(9) NOT NULL Department of Defense Activity Address Code
5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 VENDOR_STATUS Character(1) VARCHAR2(1) NOT NULL Vendor Status
A=Approved
D=Denied
E=Unapproved
I=Inactive
X=To Be Archived
8 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
9 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID
10 CORPORATE_VENDOR Character(10) VARCHAR2(10) NOT NULL Corporate Vendor
11 USF_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix