USF_CST_CODE_VW (SQL View)	Index Back
USF New Cust Codes

USF_CST_CODE_VW

(SQL View)

USF New Cust Codes

SELECT DISTINCT CD.USF_UEID , CD.USF_EFT_IND , CD.USF_CD_QUAL , CD.DUNS_NUMBER , CD.USF_CD_QUAL , %Upper(%Substring(CD.USF_VNDR_CODE, 1, 10)) , ' ' , ' ' FROM PS_USF_VNDR_HDR H , PS_USF_VNDR_CD CD WHERE %Join(COMMON_KEYS, USF_VNDR_HDR H, USF_VNDR_CD CD ) AND H.USF_AGENCY_BUS_PUR IN ('1','3') AND CD.USF_CD_QUAL IN ('USA', 'USE', 'USP')

# 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 CUST_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL Customer Object Type
BUSN=Business Phone
CAF=AP Point of Contact -obsolete
CAP=AP Point of Contact
CUST=Customer
DNS=DUNS Number
DOD=DODAAC Code
DP4=DUNS Plus 4
EIN=Employer ID Number
FAX=Fax Phone
FSC=Federal Supply Class
LAF=Accounts Receivable Address
LAP=Accounts Payable Address
LAR=Accounts Receivable Address
LCN=Corporate Address
LFE=Mailing Address
LRI=Remit Address Contact
LSL=Sales Address Contact
PSC=Public Service Code
SBA=SBA Business Types
SSN=Social Security Number
TIN=Tax Identification Number
USA=NAICS SIC Code
USE=Exception NAICS SIC Code
USP=Primary NAICS SIC Code

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

5 SIC_CD_QUAL Character(3) VARCHAR2(3) NOT NULL SIC Code Type
ANZ=Australia-New Zealand SIC Code
CAN=Canadian NAICS Codes
GER=German SIC Codes
NAF=French SIC Codes
SIC=US SIC Codes
UK=UK 92 SIC Codes
USA=US - NAICS Codes
USE=NAICS Exception Codes
USP=Primary NAICS Codes

6 SIC_CODE Character(10) VARCHAR2(10) NOT NULL Standard Industry Code

7 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number

8 STD_ID_NUM Character(35) VARCHAR2(35) NOT NULL ID Number

#	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	CUST_OBJ_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Customer Object Type BUSN=Business Phone CAF=AP Point of Contact -obsolete CAP=AP Point of Contact CUST=Customer DNS=DUNS Number DOD=DODAAC Code DP4=DUNS Plus 4 EIN=Employer ID Number FAX=Fax Phone FSC=Federal Supply Class LAF=Accounts Receivable Address LAP=Accounts Payable Address LAR=Accounts Receivable Address LCN=Corporate Address LFE=Mailing Address LRI=Remit Address Contact LSL=Sales Address Contact PSC=Public Service Code SBA=SBA Business Types SSN=Social Security Number TIN=Tax Identification Number USA=NAICS SIC Code USE=Exception NAICS SIC Code USP=Primary NAICS SIC Code
4	DUNS_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	DUNS Number
5	SIC_CD_QUAL	Character(3)	VARCHAR2(3) NOT NULL	SIC Code Type ANZ=Australia-New Zealand SIC Code CAN=Canadian NAICS Codes GER=German SIC Codes NAF=French SIC Codes SIC=US SIC Codes UK=UK 92 SIC Codes USA=US - NAICS Codes USE=NAICS Exception Codes USP=Primary NAICS Codes
6	SIC_CODE	Character(10)	VARCHAR2(10) NOT NULL	Standard Industry Code
7	STD_ID_NUM_QUAL	Character(3)	VARCHAR2(3) NOT NULL	Standard ID Number
8	STD_ID_NUM	Character(35)	VARCHAR2(35) NOT NULL	ID Number