SCR_ID_NBRS_VW

#	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	SCR_STDID_NUM_QUAL	Character(3)	VARCHAR2(3) NOT NULL	Standard ID Number ACN=Company Number - Australia BEI=BEI Identifier BUS=Business Types CCM=Municipal Reg Number - Brazil CGC=Comp Tax Reg Number - Brazil CID=Company Identification Number CPF=Ind Tax Reg Number - Brazil CRI=Creditor Identification DB=DUNS Number (With Edit) DNS=DUNS Number (No Edit) DOD=DODAAC Code DP4=DUNS+4 Suffix EIN=Employer ID Number FIC=Fiscal ID - Company - Italy FII=Fiscal ID - Indiv - Italy GLN=Global Location Number IE=State Reg Number - Brazil LER=Legal Entity Registration Num NIC=NIC Number - France NIF=Fiscal ID Number - Spain PSC=Public Service Codes SBA=SBA Business Types SRN=SIREN Number - France SRT=SIRET Number - France SSN=Social Security Number TIN=Tax Identification Number W2=W2 Identification Number
5	STD_ID_NUM	Character(35)	VARCHAR2(35) NOT NULL	ID Number
6	STD_ID_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
7	CREDIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Credit Flag N=No Y=Yes
8	SCR_REMOVE	Character(1)	VARCHAR2(1) NOT NULL	Remove Contact Y/N Table Edit Default Value: N