APVM_INQ

(SQL Table)
Index Back

Match Inquiry work

  • Parent Record Of APVM_INQ_FLDS AP_MTCH_WB_FLDS AP_VCHRSTG_FLDS SDN_INQ_FLDS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 MATCH_INQUIRY_TYPE Character(1) VARCHAR2(1) NOT NULL Inquire/Report For
    0=Match-Dispute Vouchers
    1=Match History
    2=To Be Matched
    3=Other

    Default Value: 0

    3 SRCH_CRITERIA Character(30) VARCHAR2(30) NOT NULL Search Criteria

    Prompt Table: SRCH_CRIT_SAV

    4 SRCH_CONFIG_ID Character(20) VARCHAR2(20) NOT NULL Search Configuration ID