USF_CUST_XREF

#	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	CUSTOMER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
4	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.
5	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
6	DUNS_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	DUNS Number
7	USF_DODAAC	Character(9)	VARCHAR2(9) NOT NULL	Department of Defense Activity Address Code
8	CONTACT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Contact SetID
9	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
10	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
11	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
12	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
13	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
14	DATE_LAST_MAINT	Date(10)	DATE	Date Last Maintained
15	USF_DUNS_PLUS4	Character(4)	VARCHAR2(4) NOT NULL	DUNS Suffix