LED_TMPLT_D_VW

(SQL View)
Index Back

Detail Ledger Templates


SELECT ledger_template ,descr ,ledger_type FROM PS_LED_TMPLT_TBL WHERE ledger_type = 'D'

  • Related Language Record: LED_TMPLT_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LEDGER_TEMPLATE Character(10) VARCHAR2(10) NOT NULL Ledger Template
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 LEDGER_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Type
    D=Detail Ledger
    K=Commitment Control Ledger
    S=Summary Ledger