BUSINESS_UNITVOUCHER_IDVOUCHER_LINE_NUMRECEIVER_IDRECV_LN_NBRRECV_SHIP_SEQ_NBRM=Matched
N=Not Matched
P=Partially Matched
T=To Match
V=Vouchered
VCHR_MM_REC_VW1(SQL View) |
Index Back |
|---|---|
Match Manager Recv View |
| SELECT DISTINCT A.BUSINESS_UNIT_AP , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.BUSINESS_UNIT , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.QTY_SH_ACCPT_VUOM , B.RECEIPT_DT , B.VENDOR_ID , B.MATCH_STATUS_RECV FROM PS_RECV_VCHR_MTCH A , PS_RECV_HDR_FS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RECEIVER_ID = B.RECEIVER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 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_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 5 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 6 | RECV_LN_NBR |
Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 7 | RECV_SHIP_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 8 | QTY_SH_ACCPT_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Accept QTY in Supplier UOM |
| 9 | RECEIPT_DT | Date(10) | DATE | Received Date |
| 10 | VENDOR_RECV | Character(10) | VARCHAR2(10) NOT NULL | Supplier ID |
| 11 | MATCH_STATUS_RECV | Character(1) | VARCHAR2(1) NOT NULL |
Match Status
M=Matched N=Not Matched P=Partially Matched T=To Match V=Vouchered |