PO_GNV_PER_RCVW(SQL View) |
Index Back |
|---|---|
Performance ReceiptPerformance Receipt MANINSRI 04/01/2022 |
| SELECT P.SETID, P.GNV_PERFORM_NBR, P.GNV_ORDER_NUM, P.GNV_PERFORM_TYPE, P.BUSINESS_UNIT_PO, P.PO_ID, P.RECEIVER_ID, R.RECEIPT_DT, R.RECV_STATUS FROM PS_PO_GNV_PER_HDR P, PS_RECV_HDR R WHERE P.BUSINESS_UNIT_PO = R.BUSINESS_UNIT AND P.RECEIVER_ID = R.RECEIVER_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | GNV_PERFORM_NBR | Character(20) | VARCHAR2(20) NOT NULL | A number for a Performance transaction, assigned by G-Invoicing (GINV) at the time the transaction is recorded in GINV. MANINSRI 16/06/2021 |
| 3 | GNV_ORDER_NUM | Character(20) | VARCHAR2(20) NOT NULL | G-INVOICING MANINSRI 15/06/2021 |
| 4 | GNV_PERFORM_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Identifies the nature of the performance in the reported transaction. G-INVOICING MANINSRI 16/06/2021
014=Deferred Payment 035=Delivered/Performed 050=Received/Accepted 548=Advance |
| 5 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 6 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 7 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 8 | RECEIPT_DT | Date(10) | DATE | Received Date |
| 9 | RECV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Status
C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled |