SRM_SRCERR_VW(SQL View) |
Index Back |
|---|---|
Sourcing Errors ViewView of Sourcing Errors. |
| SELECT A.BUYER_ID , A.BUSINESS_UNIT , A.INV_ITEM_ID , A.DESCR254_MIXED , V.NAME1 , B.OPRDEFNDESC , A.REQ_ID , A.PO_ID , A.STAGE_STATUS , A.VENDOR_SETID , A.VENDOR_ID FROM PS_PO_ITM_STG A LEFT OUTER JOIN PS_PO_BUYER_VW B ON A.BUYER_ID = B.BUYER_ID LEFT OUTER JOIN PS_VENDOR V ON A.VENDOR_SETID=V.SETID AND A.VENDOR_ID = V.VENDOR_ID WHERE A.STAGE_STATUS IN ('E', 'N', 'W') |
| # | 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 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 5 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 6 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 7 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 8 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 9 | STAGE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Stage Status
B=Ready to Create C=Completed D=Inv Demand Build in Process E=Error I=In Process N=Needs Approval P=PO Create in Process R=Error Recycle S=Staged V=POCALC in Process W=Warning Issued X=Reset Req and Purge |
| 10 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 11 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |