PO_PO_COPY_VW_L(SQL View) |
Index Back |
|---|---|
PO to PO Copy from Document VwPO to PO Copy from Document Vw: used in copy template.. Date Initials Reference # Description 09/07/2009 SF 1916627002 Created a new SQL view PO_PO_COPY_VW_L. |
| SELECT A.business_unit , A.PO_ID , B.LANGUAGE_CD , A.po_status , A.vendor_setid , A.VENDOR_ID , A.VNDR_LOC , B.vendor_name_short , A.buyer_id , A.ORIGIN , A.po_ref , A.PO_DT , 'N' FROM PS_PO_HDR a , PS_VENDOR_LANG b WHERE a.VENDOR_SETID = b.SETID AND a.VENDOR_ID = b.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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | 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 |
| 5 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 6 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 7 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 8 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 9 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 10 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL | Origin |
| 11 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |
| 12 | PO_DT | Date(10) | DATE | Date |
| 13 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes Y/N Table Edit |