PO_PRINT_COM_WS

(SQL Table)
Index Back

PO Print Comments Working Scr

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered
3 RANDOM_CMMT_NBR Number(4,0) SMALLINT NOT NULL Random Comments Number
4 COMMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Comment Type
BF=Bid Factor
CBF=Analysis Collab Bid Factor
HDR=Header
LIN=Line
SHP=Ship To Location
5 PUBLIC_FLG Character(1) VARCHAR2(1) NOT NULL Send to Vendor
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
8 COMMENTS_2000 Long Character CLOB Comment Text