RE_SITE_COMMENT (SQL Table)	Index Back
Site Comment Site Comments

RE_SITE_COMMENT

(SQL Table)

Site Comment

Site Comments

# 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 SITE_COMMENT_ID Number(15,0) DECIMAL(15) NOT NULL Site Comment ID

3 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.

4 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.

5 DESCR150_TEXT Character(150) VARCHAR2(150) NOT NULL Description

6 COMMENTS Long Character CLOB Comment

#	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	SITE_COMMENT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Site Comment ID
3	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
4	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
5	DESCR150_TEXT	Character(150)	VARCHAR2(150) NOT NULL	Description
6	COMMENTS	Long Character	CLOB	Comment