AP_MTCH_RULECFG

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 MATCH_RULE_ID Character(10) VARCHAR2(10) NOT NULL Match Rule ID

Prompt Table: AP_MTCH_RULES

5 MTCH_RULE_TYPE Character(15) VARCHAR2(15) NOT NULL Match Rule Type
6 MTCH_RULE_LEVEL Character(2) VARCHAR2(2) NOT NULL Match Rule Level
HS=Header Summary
LS=Line Summary
7 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
    • 8 QUAL_APPL_NXT_RULE Character(1) VARCHAR2(1) NOT NULL Apply Next Rule True

    Y/N Table Edit

    9 AP_RULE_ACTION_F Character(1) VARCHAR2(1) NOT NULL Action When False
    D=Debit Memo
    E=Exception
    M=Match
    10 AP_RULE_ACTION_T Character(1) VARCHAR2(1) NOT NULL If Rule is True Take Action
    D=Debit Memo
    E=Exception
    M=Match
    11 OTH_APPL_NXT_RULE Character(1) VARCHAR2(1) NOT NULL Apply Next Rule False

    Y/N Table Edit

    12 AP_PCT_UNDERAMT Signed Number(6,0) DECIMAL(5) NOT NULL Percent Under Amount
    13 AP_PCT_OVERAMT Signed Number(6,0) DECIMAL(5) NOT NULL Close PO Under Qty Pct Tol
    14 AMT_TOL_DOWN Signed Number(17,2) DECIMAL(15,2) NOT NULL Under Amount
    15 AMT_TOL_UP Signed Number(17,2) DECIMAL(15,2) NOT NULL Over Amount
    16 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence