PTAFCRTA_REC

index back

Criteria Definition

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

  • Related language record: PTAFCRTA_RECLNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTAFCRTA_IDCharacter(100)VARCHAR2(100) NOT NULLCriteria ID
    SEQ_NBRNumber(15,0)DECIMAL(15) NOT NULLSequence Number
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

    Prompt Table: RECDEFN_VW

    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

    Prompt Table: PSRECFIELDALL

    AMT_RECNAMECharacter(15)VARCHAR2(15) NOT NULLAmount Record

    Prompt Table: PTAFAMT_REC_VW

    AMT_FLDNAMECharacter(18)VARCHAR2(18) NOT NULLAmount Field Name

    Prompt Table: PTAFAMTRECFIELD

    PTAFCRITERIA_FLGCharacter(1)VARCHAR2(1) NOT NULLFlag for whether all criteria are needed or any
    A=All
    O=One
    PTAFAMOUNT_SWCharacter(1)VARCHAR2(1) NOT NULLAmount Field
    N=No
    Y=Yes

    Default: N

    PTAFCRTA_OP_NUMCharacter(2)VARCHAR2(2) NOT NULLCriteria Operator
    <=Less Than
    >=Greater Than
    B=Between(Inclusive)

    Default: >

    AMOUNT_1Signed Number(28,3)DECIMAL(26,3) NOT NULLAmount Work Field
    AMOUNT_2Signed Number(28,3)DECIMAL(26,3) NOT NULLAmount Work Field
    CURRENCY_CDCharacter(3)VARCHAR2(3) NOT NULLCurrency Code

    Prompt Table: CURRENCY_CD_TBL

    CUR_RT_TYPECharacter(5)VARCHAR2(5) NOT NULLCurrency Rate Type

    Prompt Table: CUR_RT_TYPE_TBL

    RECNAME_CURCharacter(15)VARCHAR2(15) NOT NULLCurrency Record

    Prompt Table: PSRECDEFNPVW

    FIELDNAME_CURCharacter(18)VARCHAR2(18) NOT NULLCurrency Field

    Prompt Table: PTAFAMTRECFIELD

    DESCR254_MIXEDCharacter(254)VARCHAR2(254) NOT NULLDescription
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19