BUSINESS_UNITINV_ITEM_IDREVISIONA=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
EN_REVISION_PO(SQL View) |
Index Back |
|---|---|
Item/Revision Used in POs |
| SELECT a.business_unit , b.inv_item_id , c.revision , a.po_id , b.line_nbr , a.po_status , c.qty_po FROM ps_po_hdr a , ps_po_line b , PS_PO_LINE_SHIP c WHERE c.business_unit = a.business_unit AND c.business_unit = b.business_unit AND c.po_id = a.po_id AND c.po_id = b.po_id AND c.line_nbr = b.line_nbr AND a.po_status NOT IN ('X', 'C') AND b.cancel_status = 'A' AND c.cancel_status = 'A' AND c.qty_po > 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | REVISION |
Character(4) | VARCHAR2(4) NOT NULL | 01/27/2000 RML Added "As of" label |
| 4 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 5 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 6 | 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 |
| 7 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |