MTCH_VCHR_MSG(SQL Table) |
Index Back |
|---|---|
Voucher Match Message recordRecord on Voucher Match Record |
| # | 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 |
| 3 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 4 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 5 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 6 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 7 | BUSINESS_UNIT_RECV |
Character(5) | VARCHAR2(5) NOT NULL |
Receiving Business Unit
Prompt Table: SP_BUINRV_NONVW |
| 8 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 9 | RECV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 10 | MATCH_CNTRL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Match Rule |
| 11 | MATCH_RULE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Match Rule ID |
| 12 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: ROLEXLATOPR |
| 13 | MATCH_LEVEL | Character(3) | VARCHAR2(3) NOT NULL |
Match Type
ERS=Evaluated Receipts STD=Standard Rule SYS=System Rule |
| 14 | EXCEPTION_ROUTE | Character(3) | VARCHAR2(3) NOT NULL |
Match Exception Route
BUY=Buyer PO=PO Operator RCV=Receiving Operator VCH=Voucher Operator |
| 15 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |