MTCH_RULE_OVRD

(SQL Table)
Index Back

Voucher Log Rule Override

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_AP_NONVW

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

Prompt Table: MTCH_RUL_OVR_VW

3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
5 MATCH_RULE_ID Character(10) VARCHAR2(10) NOT NULL Match Rule ID
6 DBMEMO_FLAG Character(1) VARCHAR2(1) NOT NULL Debit Memo
7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
8 OVRD_REASON Character(3) VARCHAR2(3) NOT NULL Hold Reason
ACC=Accounting in Dispute
AMT=Amount in Dispute
CCR=CCR Expired
CRD=Credit Note from Higher Level
CRT=Contract Retention
GDS=Goods in Dispute
IPC=Inbound IPAC Required
OTH=Other
OVR=Overridden from higher level
QTY=Quantity in Dispute
SYS=Automatic System Override
WTH=Withholding Hold
9 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
10 REASONDESCR Character(200) VARCHAR2(200) NOT NULL Rejection Reason