CUST_NT_BI_L_VW

(SQL View)
 Index Back

Customer Notes - BI Inv LangVw

This view points to the text of the standard notes (related language) associated with a customer which are to be printed on the invoice (document_cd = 'INVC').

SELECT CNOTE.SETID , CNOTE.CUST_ID , CNOTE.SEQ_NUM , LSNOTE.LANGUAGE_CD , LSNOTE.TEXT254 FROM PS_CUST_NOTE CNOTE , PS_STD_NOTE SNOTE , PS_STD_NOTE_LANG LSNOTE , PS_STD_NOTE_DOC SDOC , PS_SET_CNTRL_REC X WHERE LSNOTE.SETID = SDOC.SETID AND LSNOTE.STD_NOTE_CD = SDOC.STD_NOTE_CD AND LSNOTE.EFFDT = SDOC.EFFDT AND SDOC.DOCUMENT_CD = 'INVC' AND LSNOTE.SETID= X.SETID AND X.SETCNTRLVALUE = CNOTE.SETID AND X.RECNAME = 'STD_NOTE_LANG' AND CNOTE.STD_NOTE_CD = LSNOTE.STD_NOTE_CD AND %EffdtCheck(std_note_lang, LSNOTE, %CurrentDateIn) AND SNOTE.SETID = LSNOTE.SETID AND SNOTE.STD_NOTE_CD = LSNOTE.STD_NOTE_CD AND SNOTE.EFFDT = LSNOTE.EFFDT AND SNOTE.EFF_STATUS = 'A'

  • Related Language Record for CUST_NT_S_BI_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 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 1

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text