PMT_FMTDCVW_LNG

(SQL View)
 Index Back

Formats for a doc type Lng


SELECT A.FORMAT_DOC_TYPE , A.FORMAT_ID , B.LANGUAGE_CD , B.FORMAT_NAME , B.DESCR254 FROM PS_PMT_FORMAT_DEFN A ,PS_PMT_FORMAT_LNG B WHERE A.FORMAT_ID = B.FORMAT_ID

  • Related Language Record for PMT_FRMTDOC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FORMAT_DOC_TYPE Character(3) VARCHAR2(3) NOT NULL Document Type
    ACK=Payment Acknowledge
    BS=Bank Statement
    BSR=Bank Statement Request
    CAN=Payment Cancellation
    IMP=Import Payment
    PMT=Payment
    REV=Payment Reversal
    SDN=Sanctions List
    SEC=Security Market Values
    SED=Security Definition
    STK=Import Stock Quotes
    TRP=Investment Pools Import
    2 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID

    Prompt Table: PMT_FORMAT_DEFN

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 FORMAT_NAME Character(30) VARCHAR2(30) NOT NULL Layout Name
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254