AM_BK_CD_VW_LG

(SQL View)
 Index Back

AM Book Code


SELECT A.SETID , A.BOOK_CODE , A.LANGUAGE_CD , A.DESCR , A.DESCRSHORT FROM %Table(BOOK_CODE_LANG) 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 for AM_BOOK_CODE_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 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description