FED_CST_CODE_VW (SQL View)	Index Back
FEDREG New Cust Codes

FED_CST_CODE_VW

(SQL View)

FEDREG New Cust Codes

SELECT CD.DUNS_NUMBER , CD.CCR_DUNS_PLUS4 , CD.CCR_CD_QUAL , CD.CCR_CD_QUAL , %Substring(CD.CCR_VNDR_CODE, 1, 10) , CD.CCR_CD_QUAL , %Substring(CD.CCR_VNDR_CODE, 1, 20) FROM PS_CCR_VNDR_HDR H , PS_CCR_VNDR_CD CD WHERE %Join(COMMON_KEYS, CCR_VNDR_HDR H, CCR_VNDR_CD CD ) AND H.SOURCE_SYSTEM = 'FED' AND H.FR_BUS_TYPE IN ('2','3') AND CD.CCR_CD_QUAL = 'USA'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CCR_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix

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 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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DUNS_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	DUNS Number
2	CCR_DUNS_PLUS4	Character(4)	VARCHAR2(4) NOT NULL	DUNS Suffix
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	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
5	SIC_CODE	Character(10)	VARCHAR2(10) NOT NULL	Standard Industry Code
6	STD_ID_NUM_QUAL	Character(3)	VARCHAR2(3) NOT NULL	Standard ID Number
7	STD_ID_NUM	Character(35)	VARCHAR2(35) NOT NULL	ID Number