AP_MTCH_EX_GRP

(SQL Table)
Index Back

MECC Group Header

Match Exception Group Header

  • Related Language Record: AP_MTCH_EX_RLR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AP_MTCH_EXCP_GRP Character(18) VARCHAR2(18) NOT NULL Match Exception Group
    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 INCL_PO_BUYER Character(1) VARCHAR2(1) NOT NULL Include Buyer from Purchase Order

    Y/N Table Edit

    Default Value: N

    5 INCL_REQUESTOR Character(1) VARCHAR2(1) NOT NULL Include Requestor

    Y/N Table Edit

    Default Value: N

    6 INCL_INVC_ORIGIN Character(1) VARCHAR2(1) NOT NULL Include Invoice Originator

    Y/N Table Edit

    Default Value: N

    7 INCL_RECEIVER Character(1) VARCHAR2(1) NOT NULL Include Receiver

    Y/N Table Edit

    Default Value: N

    8 MTCH_EX_APBU_OPT Character(1) VARCHAR2(1) NOT NULL Payables Business Unit Options

    Y/N Table Edit

    Default Value: Y

    9 MTCH_EX_POBU_OPT Character(1) VARCHAR2(1) NOT NULL Procurement Business Unit Options

    Y/N Table Edit

    Default Value: Y

    10 MTCH_EX_SHIP_OPT Character(1) VARCHAR2(1) NOT NULL Ship To Location Option

    Y/N Table Edit

    Default Value: Y

    11 MTCH_EX_MCID_OPT Character(1) VARCHAR2(1) NOT NULL Match Control Id Filter

    Y/N Table Edit

    Default Value: Y

    12 AP_MTCH_GRPTYPE Character(1) VARCHAR2(1) NOT NULL Match Exception Group Type
    A=All Rules in Exception
    E=Any Rule in Exception

    Default Value: E

    13 AP_TOT_RULES Number(11,0) DECIMAL(11) NOT NULL Total Rules
    14 AP_MEC_INCLD_OPRTR Character(2) VARCHAR2(2) NOT NULL MECC Include User field
    B=Buyer
    I=Invoice Creator
    R=Receiver