USF_VNDR_XREF (SQL Table)	Index Back
USF Vendor Cross Reference SAM Entities to PeopleSoft Vendors Cross Reference

USF_VNDR_XREF

(SQL Table)

USF Vendor Cross Reference

SAM Entities to PeopleSoft Vendors Cross Reference

# 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
Default Value: 0000

3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

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

6 USF_DODAAC Character(9) VARCHAR2(9) NOT NULL Department of Defense Activity Address Code

7 VNDR_USF_ORGIN Character(1) VARCHAR2(1) NOT NULL Vendor Origin
A=Automatic
F=Federal
M=Manual

8 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

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

10 FILE_PATH_NAME Character(254) VARCHAR2(254) NOT NULL File Path

11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

12 USF_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix

#	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 Default Value: 0000
3	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	DUNS_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	DUNS Number
6	USF_DODAAC	Character(9)	VARCHAR2(9) NOT NULL	Department of Defense Activity Address Code
7	VNDR_USF_ORGIN	Character(1)	VARCHAR2(1) NOT NULL	Vendor Origin A=Automatic F=Federal M=Manual
8	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
9	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.
10	FILE_PATH_NAME	Character(254)	VARCHAR2(254) NOT NULL	File Path
11	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
12	USF_DUNS_PLUS4	Character(4)	VARCHAR2(4) NOT NULL	DUNS Suffix