RTV_RECV_VW(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT , VENDOR_ID , RECEIVER_ID , RECEIPT_DT , RECV_STATUS FROM PS_RECV_HDR WHERE RECV_STATUS IN ('R', 'M', 'C', 'P') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PM.BUSINESS_UNIT_RECV |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Receiver number
Default Value: NEXT |
| 4 | RECEIPT_DT | Date(10) | DATE NOT NULL |
Received Date
Default Value: %date |
| 5 | 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 Default Value: O |