TRP_FMT_DEFN_VW

(SQL View)
 Index Back

Format Definitions

Add Search Format Definitions

SELECT FORMAT_ID , FORMAT_DOC_TYPE , FORMAT_NAME , TRANSFORM_PROGRAM ,TRANSFORM_MSG FROM PS_PMT_FORMAT_DEFN WHERE FORMAT_DOC_TYPE = 'TRP'

  • Related Language Record: PMT_FRMT_V_LNG1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FORMAT_ID Character(10) VARCHAR2(10) NOT NULL Format ID
    2 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

    Default Value: PMT

    3 FORMAT_NAME Character(30) VARCHAR2(30) NOT NULL Layout Name
    4 TRANSFORM_PROGRAM Character(30) VARCHAR2(30) NOT NULL Transformation Program Name

    Prompt Table: PSRELTRNSFRMVW

    5 TRANSFORM_MSG Character(30) VARCHAR2(30) NOT NULL Result Message Name

    Prompt Table: PSMSGDEFNVW1