CS_POSHP_COMMVW (SQL View)	Index Back
Contract Line Comment Mappings used in bind mappings for PURCHASE ORDER Line comments

CS_POSHP_COMMVW

(SQL View)

Contract Line Comment Mappings

used in bind mappings for PURCHASE ORDER Line comments

SELECT A.BUSINESS_UNIT , A.PO_ID , A.SHIPTO_ID , A.COMMENT_ID , B.COMMENTS_2000 FROM PS_PO_COMMENTS A , PS_COMMENTS_TBL B WHERE A.OPRID = B.OPRID AND A.COMMENT_ID = B.COMMENT_ID AND A.RANDOM_CMMT_NBR = B.RANDOM_CMMT_NBR AND A.SOURCE_FROM = 'PO' AND A.COMMENT_TYPE = 'SHP' AND A.PUBLIC_FLG = 'Y' AND A.STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

3 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

4 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered

5 COMMENTS_2000 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	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
3	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
4	COMMENT_ID	DateTime(26)	TIMESTAMP	DtTm Entered
5	COMMENTS_2000	Long Character	CLOB	Comment Text