RECV_HDR_CMNT (SQL Table)	Index Back
Receiver Header Comments

RECV_HDR_CMNT

(SQL Table)

Receiver Header Comments

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

3 COMMENT_SEQ Number(3,0) SMALLINT NOT NULL Comment Nbr

4 PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor
Y/N Table Edit
Default Value: Y

5 COMMENTS_LONG Long Character CLOB Comment Text

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
3	COMMENT_SEQ	Number(3,0)	SMALLINT NOT NULL	Comment Nbr
4	PUBLIC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Send to Vendor Y/N Table Edit Default Value: Y
5	COMMENTS_LONG	Long Character	CLOB	Comment Text