RE_SITE_CNTCT (SQL Table)	Index Back
Site Contact Site Contact

RE_SITE_CNTCT

(SQL Table)

Site Contact

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SITE_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.

2 VC_TYPE Character(1) VARCHAR2(1) NOT NULL Vendor or Customer flag
C=Customer
R=My Contacts
V=Supplier

3 VC_ID Character(15) VARCHAR2(15) NOT NULL Vendor or Customer ID

4 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
Default Value: NEXT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SITE_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.
2	VC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Vendor or Customer flag C=Customer R=My Contacts V=Supplier
3	VC_ID	Character(15)	VARCHAR2(15) NOT NULL	Vendor or Customer ID
4	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts Default Value: NEXT