BI_STD_NOTE_VW

(SQL View)
Index Back

Eff. Std Notes for Inv Docs


select s.setid, s.std_note_cd, s.effdt, s.eff_status, s.descr, s.text254, s.note_type from PS_STD_NOTE s, PS_STD_NOTE_doc t where t.document_cd = 'INVC' and s.effdt = (select max(effdt) from PS_STD_NOTE where setid=s.setid and std_note_cd = s.std_note_cd and effdt <= %currentdatein) and s.eff_status='A' and s.setid = t.setid and s.std_note_cd = t.std_note_cd and t.effdt = (select max(effdt) from PS_STD_NOTE_doc where setid = t.setid and std_note_cd = t.std_note_cd and effdt <= %currentdatein)

  • Related Language Record: BI_STDNOTVW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
    7 NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL Note Type

    Prompt Table: NOTE_TYPE