SCN_HDR_ATT_LNG

(SQL View)
 Index Back

Related Language Record

Related Language Record for SCN_HDR_ATT_VW

SELECT A.SETID ,A.CNTRCT_ID ,A.LINE_NBR ,A.SCHED_LINE_NBR ,A.SCM_ATTACH_ID ,A.ATT_VERSION ,B.LANGUAGE_CD ,A.DESCR FROM PS_SCON_ATT A , PS_SCON_ATT_LNG B WHERE A.LINE_NBR = 0 AND A.SCHED_LINE_NBR = 0 AND A.SETID = B.SETID AND A.CNTRCT_ID = B.CNTRCT_ID AND A.LINE_NBR = B.LINE_NBR AND A.SCHED_LINE_NBR = B.SCHED_LINE_NBR AND A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.ATT_VERSION = B.ATT_VERSION

  • Related Language Record for SCN_HDR_ATT_VW

    • # 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]
    4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
    5 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
    6 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description