CCR_CUST_XREF

#	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	SOURCE_SYSTEM	Character(3)	VARCHAR2(3) NOT NULL	Source System CCR=CCR EBL=eBill Contact Maintenance FED=FED PEN=Pension Customer
4	CUSTOMER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
5	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.
6	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
7	CONTACT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Contact SetID
8	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
9	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
10	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
11	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
12	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
13	DATE_LAST_MAINT	Date(10)	DATE	Date Last Maintained