RECV_GNV_VW(SQL View) |
Index Back |
|---|---|
Receipt and Performance DataDate Initials Reference# Description 02/28/2021 Nash G-Invoicing Created a new view that helps to load corresponding receipt and performance data. |
| SELECT P.GNV_ORDER_NUM , S.BUSINESS_UNIT_PO , S.PO_ID , S.RECEIVER_ID , H.RECEIPT_DT , H.SHIPMENT_NO , S.RECEIPT_DTTM , S.RECV_LN_NBR , S.GNV_PRFORM_DTL_NBR , S.SHIP_QTY_STATUS , S.QTY_SH_ACCPT , S.QTY_SH_RECVD , S.QTY_SH_RTN , S.QTY_SH_NETRCV_VUOM , S.QTY_SH_REJCT , S.REJECT_ACTION , S.QTY_SH_ACCPT - S.QTY_SH_RTN , P.GNV_ORDER_LINE_NBR , P.GNV_SCHED_NBR FROM PS_RECV_HDR H , PS_RECV_LN_SHIP S , PS_PO_GNV_VW P WHERE H.BUSINESS_UNIT = S.BUSINESS_UNIT AND H.RECEIVER_ID = S.RECEIVER_ID AND H.SHIPMENT_NO <> ' ' AND S.BUSINESS_UNIT_PO = P.BUSINESS_UNIT AND S.PO_ID = P.PO_ID AND S.LINE_NBR = P.LINE_NBR AND S.SCHED_NBR = P.SCHED_NBR AND S.SHIP_QTY_STATUS <> '2' AND S.RECV_SHIP_STATUS IN ('C','R','X') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GNV_ORDER_NUM | Character(20) | VARCHAR2(20) NOT NULL | G-INVOICING MANINSRI 15/06/2021 |
| 2 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 3 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 4 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 5 | RECEIPT_DT | Date(10) | DATE | Received Date |
| 6 | SHIPMENT_NO | Character(30) | VARCHAR2(30) NOT NULL | Shipment Number |
| 7 | RECEIPT_DTTM | DateTime(26) | TIMESTAMP | Receipt Datetime |
| 8 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 9 | GNV_PRFORM_DTL_NBR | Number(6,0) | INTEGER NOT NULL | Uniquely identifies a specific detail record within the performance transaction. (Agency supplied). G_INVOICING MANINSRI |
| 10 | SHIP_QTY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Quantity Status
1=Passes Quantity Check 2=Over Shipment 3=Under Shipment |
| 11 | QTY_SH_ACCPT | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Accepted in Receipt UOM |
| 12 | QTY_SH_RECVD | Number(16,4) | DECIMAL(15,4) NOT NULL | F_KDHIL_R87H8 062804 MLM: Added new Line Quantity Received Label |
| 13 | QTY_SH_RTN | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Returned in Receipt UOM |
| 14 | QTY_SH_NETRCV_VUOM | Number(16,4) | DECIMAL(15,4) NOT NULL | Net Receipt Quantity |
| 15 | QTY_SH_REJCT | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Rejected in Receipt UOM |
| 16 | REJECT_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Action On Rejection
C=Return for Credit R=Return For Replacement |
| 17 | CURR_ACCPT_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Current Accept Receipt Qty |
| 18 | GNV_ORDER_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Identifier of a specific Line Item within the Order. G_INVOICING MANINSRI 17/06/2021 |
| 19 | GNV_SCHED_NBR | Number(5,0) | INTEGER NOT NULL | Schedule Number |