BC_NOTE_CI_LVW

(SQL View)
 Index Back

BC_NOTE_CI_LVW -- For CI

This view: BC_NOTE_CI_VW has the same structure as the record: BC_NOTE. BC_NOTE_CI_LVW is the related language record for BC_NOTE_CI_VW

SELECT A.BO_ID , A.NOTE_GUID , A.NOTE_SEQ_NBR , A.LANGUAGE_CD , A.DESCRLONG FROM PS_BC_NOTE_LANG A

  • Related Language Record for BC_NOTE_CI_VW

  • Parent record: BO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
    2 NOTE_GUID Signed Number(32,0) DECIMAL(31) NOT NULL GUID as a number for notes.
    3 NOTE_SEQ_NBR Number(6,0) INTEGER NOT NULL Note ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCRLONG Long Character CLOB Long Description