BUSINESS_UNITPrompt Table: SP_BU_PM_NONVW
RECEIVER_IDC=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled
C=Closed
H=Hold
M=Moved
O=Open
R=Received
X=Canceled
RECV_INQ_STT_VW(SQL View) |
Index Back |
|---|---|
Receipt Inquiry Status |
| SELECT DISTINCT A.BUSINESS_UNIT , A.RECEIVER_ID , A.RECV_STATUS , A.RECV_STATUS FROM PS_RECV_HDR A |
| # | 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_PM_NONVW |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | 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 |
| 4 | RECV_INQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Status
C=Closed H=Hold M=Moved O=Open R=Received X=Canceled |