SCN_LN_NOTE_VW

(SQL View)
Index Back

Sales Contract Line Notes

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.NOTE_TYPE ,A.STD_NOTE_CD ,A.TEXT254 FROM PS_SCON_NOTE A WHERE A.LINE_NBR <> 0 AND A.SCHED_LINE_NBR = 0

  • Related Language Record: SCON_NOTE_LNG
  • # 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

    Default Value: 1

    6 NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL Note Type

    Prompt Table: NOTE_TYPE

    7 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code

    Prompt Table: STD_NOTE

    8 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text