AM_BOOK_CODE_VW

(SQL View)
 Index Back

AM Book Code


SELECT A.SETID , A.BOOK_CODE , A.DESCR , A.DESCRSHORT FROM %Table(BOOK_CODE_TBL) A WHERE NOT EXISTS ( SELECT 'X' FROM %Table(BKC_DST_GRP_DTL) B WHERE B.SETID = A.SETID AND B.BOOK_CODE = A.BOOK_CODE)

  • Related Language Record: AM_BK_CD_VW_LG

    • # 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 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description