SCN_LN_NOTE_KY

(SQL View)
Index Back

SCntrct Line Notes Key Words

This record holds the order header, line and schedules standard note code or custom text. It is the parent of ORD_NOTE_DOC and ORD_NOTE_KEYWD.

SELECT A.SETID ,A.CNTRCT_ID ,A.LINE_NBR ,A.SCHED_LINE_NBR ,A.SEQ_NUM ,A.key_word FROM PS_SCON_NOTE_KEYWD A WHERE A.LINE_NBR <> 0 AND A.SCHED_LINE_NBR = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

Prompt Table: SCON_HDR

3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

Prompt Table: SCON_LINE

4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
6 KEY_WORD Character(20) VARCHAR2(20) NOT NULL Key Word