CCR_VNDR_XREF (SQL Table)	Index Back
CCR to Supplier Cross Referenc CCR Contractors to PeopleSoft Suppliers Cross Reference

CCR_VNDR_XREF

(SQL Table)

CCR to Supplier Cross Referenc

CCR Contractors to PeopleSoft Suppliers Cross Reference

# 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

5 SOURCE_SYSTEM Character(3) VARCHAR2(3) NOT NULL Source System
CCR=CCR
EBL=eBill Contact Maintenance
FED=FED
PEN=Pension Customer
Default Value: CCR

6 VNDR_CCR_ORGIN Character(1) VARCHAR2(1) NOT NULL Vendor Origin
A=Automatic
M=Manual
Default Value: M

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

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

#	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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	SOURCE_SYSTEM	Character(3)	VARCHAR2(3) NOT NULL	Source System CCR=CCR EBL=eBill Contact Maintenance FED=FED PEN=Pension Customer Default Value: CCR
6	VNDR_CCR_ORGIN	Character(1)	VARCHAR2(1) NOT NULL	Vendor Origin A=Automatic M=Manual Default Value: M
7	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
8	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.