SRM_POONHOLD_VW(SQL View) |
Index Back |
|---|---|
POs On HoldPurchase Order On Hold View. |
| SELECT B.BUYER_ID , B.BUSINESS_UNIT , B.PO_ID , V.NAME1 , C.OPRDEFNDESC , B.PO_DT , B.PO_STATUS , B.RECV_STATUS , B.VENDOR_ID , B.VNDR_LOC FROM PS_PO_HDR B , PS_PO_BUYER_VW C , PS_VENDOR V WHERE B.HOLD_STATUS = 'Y' AND B.BUYER_ID = C.BUYER_ID AND B.VENDOR_SETID = V.SETID AND B.VENDOR_ID = V.VENDOR_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUYER_ID |
Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 4 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 5 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 6 | PO_DT | Date(10) | DATE NOT NULL |
Date
Default Value: %date |
| 7 | PO_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
PO Status
A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled |
| 8 | 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 |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 10 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |