CUST_NT_S_BI_VW

(SQL View)
 Index Back

Cust Std Note - BI Invoice Vw

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

SELECT CNOTE.SETID , CNOTE.CUST_ID , CNOTE.SEQ_NUM , SNOTE.NOTE_TYPE , SNOTE.STD_NOTE_CD , SNOTE.TEXT254 FROM PS_CUST_NOTE CNOTE , PS_STD_NOTE SNOTE , PS_STD_NOTE_DOC SDOC , PS_SET_CNTRL_REC X WHERE SNOTE.SETID = SDOC.SETID AND SNOTE.STD_NOTE_CD = SDOC.STD_NOTE_CD AND SNOTE.EFFDT = SDOC.EFFDT AND SDOC.DOCUMENT_CD = 'INVC' AND SNOTE.SETID= X.SETID AND X.SETCNTRLVALUE = CNOTE.SETID AND RECNAME = 'STD_NOTE' AND CNOTE.STD_NOTE_CD = SNOTE.STD_NOTE_CD AND %EffdtCheck(std_note, SNOTE, %currentdatein) AND SNOTE.EFF_STATUS='A'

  • Related Language Record: CUST_NT_BI_L_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    4 NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL Note Type
    5 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code
    6 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text