PRCR_PRF_OPR

(SQL Table)
 Index Back

Procurement Operator Profile

  • Parent Record Of PRCR_PRF_COL PRCR_PRF_COL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRID_VW

    2 PRCR_PROFILE_ID Character(2) VARCHAR2(2) NOT NULL Procurement Profile ID
    L1=PO Schedule List
    L2=Receiver Schedule List
    L3=Voucher List
    P1=PO History Items
    Q1=Requisition List
    R1=Receiver History Items
    V1=Voucher History Items
    3 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID

    Prompt Table: PRCR_ENTITY_VW

    4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    5 PRCR_INQ_TYPE Character(2) VARCHAR2(2) NOT NULL Inquiry Type
    PH=Procurement History List
    PL=PO Schedule List
    QL=Requisition List
    RL=Receiver Schedule List
    VL=Voucher List

    Default Value: PH

    6 PRCR_VIEW_NAME Character(30) VARCHAR2(30) NOT NULL View By

    Prompt Table: %EDITTABLE2