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 |