SRM_DB_POAS_VW(SQL View) |
Index Back |
|---|---|
PO Ack status |
| SELECT B.BUYER_ID , A.EIP_CTL_ID , B.BUSINESS_UNIT , B.PO_ID , A.ACKNOWLEGE_DT , B.POA_STATUS , A.PO_ACK_SOURCE , B.VENDOR_SETID , B.VENDOR_ID , D.VNDR_NAME_SHRT_USR , MAX(C.DATETIME_DISP) FROM PS_PO_HDR_EC A , PS_PO_HDR B , PS_PO_DISPATCHED C , PS_VENDOR D , PS_PO_OPRDEFN_VW E , PS_SRM_DB_BU_VW F WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PO_ID = C.PO_ID AND B.VENDOR_SETID = D.SETID AND B.VENDOR_ID = D.VENDOR_ID AND B.BUYER_ID = E.OPRID AND (F.BUYER_ID = B.BUYER_ID AND F.BUSINESS_UNIT = A.BUSINESS_UNIT) AND B.PO_STATUS = 'D' AND B.POA_STATUS = 'SR' AND A.PO_POA_STATUS = 'SRP' GROUP BY B.BUYER_ID , A.EIP_CTL_ID , B.BUSINESS_UNIT , B.PO_ID , A.ACKNOWLEGE_DT , B.POA_STATUS , A.PO_ACK_SOURCE , B.VENDOR_SETID , B.VENDOR_ID, D.VNDR_NAME_SHRT_USR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUYER_ID |
Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 2 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 5 | ACKNOWLEGE_DT | Date(10) | DATE | Acknowledge Date |
| 6 | POA_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
po ack status field that will be on po_hdr.
AC=Acknowledged with changes AK=Acknowledged BA=Approved, Changes Pending IN=Initial Dispatch Acknowledged NR=Not Required SR=Responded, Awaits Review WD=Awaiting PO Dispatch WR=Awaiting Acknowledgement |
| 7 | PO_ACK_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Created on 08/09/01 CN#WV840-4.0 - Purchase Order Acknowledgment source used in PO_HDR_EC
BUY=Online (Buyer) EDI=EDX SUP=Online (Supplier) |
| 8 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 9 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 10 | VNDR_NAME_SHRT_USR | Character(10) | VARCHAR2(10) NOT NULL | Short Vendor Name |
| 11 | DATETIME_DISP | DateTime(26) | TIMESTAMP | Date and Time Dispatched |