PO_TL_POAP_VW(SQL View) |
Index Back |
|---|---|
PO Approval |
| SELECT a.business_unit , a.po_id , a.report_entity ,a.vendor_setid , a.vendor_id , a.po_status , a.hold_status , a.buyer_id , d.oprdefndesc , c.name1 , a.entered_dt , a.currency_cd , a.budget_hdr_status , a.po_dt , a.pend_fr_dt , a.merchandise_amt FROM ps_po_spnd_podt_nd a , PSOPRDEFN d , ps_vendor c WHERE a.PO_status = 'PA' AND d.oprid = a.buyer_id AND c.setid = a.vendor_setid AND c.vendor_id = a.vendor_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | REPORT_ENTITY | Character(5) | VARCHAR2(5) NOT NULL | Reporting Entity ID |
| 4 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 5 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 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 | HOLD_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Hold From Further Processing |
| 8 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 9 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 10 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 11 | ENTERED_DT | Date(10) | DATE | Entered on |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 13 | BUDGET_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid |
| 14 | PO_DT | Date(10) | DATE | Date |
| 15 | PEND_FR_DT | Date(10) | DATE | Select Pend-Cmpl Prdn From Dat |
| 16 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |