USF_SEARCH

(SQL View)
 Index Back

USF Search Vw


SELECT DISTINCT A.USF_UEID, A.USF_EFT_IND , A.DUNS_NUMBER , A.USF_DODAAC , A.LEGAL_BUS_NAME , A.DBANAME , A.USF_AGENCY_BUS_PUR , B.CUSTOMER_SETID , B.CUST_ID , C.VENDOR_SETID , C.VENDOR_ID , A.USF_DUNS_PLUS4 FROM PS_USF_VNDR_HDR A LEFT OUTER JOIN PS_USF_CUST_XREF B ON A.USF_UEID = B.USF_UEID AND A.USF_EFT_IND = B.USF_EFT_IND AND A.DUNS_NUMBER = B.DUNS_NUMBER LEFT OUTER JOIN PS_USF_VNDR_XREF C ON A.USF_UEID = C.USF_UEID AND A.USF_EFT_IND = C.USF_EFT_IND AND A.DUNS_NUMBER = C.DUNS_NUMBER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 USF_UEID Character(12) VARCHAR2(12) NOT NULL Unique Entity Identifier

Prompt Table: USF_DUNS_VW3

2 USF_EFT_IND Character(4) VARCHAR2(4) NOT NULL Entity EFT Indicator

Prompt Table: USF_DUNS_VW4

3 DUNS_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number

Prompt Table: USF_DUNS_VW

4 USF_DODAAC Character(9) VARCHAR2(9) NOT NULL Department of Defense Activity Address Code
5 LEGAL_BUS_NAME Character(120) VARCHAR2(120) NOT NULL Business Name
6 DBANAME Character(120) VARCHAR2(120) NOT NULL Doing Business As
7 USF_AGENCY_BUS_PUR Character(1) VARCHAR2(1) NOT NULL Business Type
1=Buyer
2=Seller
3=Buyer / Seller
8 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

Prompt Table: SP_SETID_NONVW

9 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
10 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Prompt Table: SP_SETID_NONVW

11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
12 USF_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix

Prompt Table: USF_DUNS_VW2