PTAFCRTA_REC

Return to Index

Table: PS_PTAFCRTA_REC

Criteria can be defined as queries, application classes & SQL Definitions.

  • Related language record: PTAFCRTA_RECLNG

    • PeopleSoft Field NameDescription
    PTAFCRTA_IDCriteria ID
    SEQ_NBRSequence Number
    RECNAMERecord (Table) Name

    Prompt Table: RECDEFN_VW

    FIELDNAMEField Name

    Prompt Table: PSRECFIELDALL

    AMT_RECNAMEAmount Record

    Prompt Table: PTAFAMT_REC_VW

    AMT_FLDNAMEAmount Field Name

    Prompt Table: PTAFAMTRECFIELD

    PTAFCRITERIA_FLGFlag for whether all criteria are needed or any
    A=All
    O=One
    PTAFAMOUNT_SWAmount Field
    N=No (default)
    Y=Yes
    PTAFCRTA_OP_NUMCriteria Operator
    <=Less Than
    >=Greater Than (default)
    B=Between(Inclusive)
    AMOUNT_1Amount Work Field
    AMOUNT_2Amount Work Field
    CURRENCY_CDCurrency Code

    Prompt Table: CURRENCY_CD_TBL

    CUR_RT_TYPECurrency Rate Type

    Prompt Table: CUR_RT_TYPE_TBL

    RECNAME_CURCurrency Record

    Prompt Table: PSRECDEFNPVW

    FIELDNAME_CURCurrency Field

    Prompt Table: PTAFAMTRECFIELD

    DESCR254_MIXEDDescription

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 24 July 2010