REPORT_ENTITYBUYER_IDVENDOR_SETIDVENDOR_IDVNDR_LOCBUSINESS_UNITPO_IDLINE_NBRSCHED_NBRPO_TLPOAPSCH_VW(SQL View) |
Index Back |
|---|---|
PO Approval Schedule |
| SELECT a.REPORT_ENTITY ,a.BUYER_ID ,a.VENDOR_SETID ,a.VENDOR_ID ,a.VNDR_LOC ,a.BUSINESS_UNIT ,a.PO_ID ,a.LINE_NBR , a.SCHED_NBR , a.SHIPTO_SETID ,a.SHIPTO_ID FROM PS_PO_SPND_PONDDTL a WHERE a.PO_status = 'PA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REPORT_ENTITY |
Character(5) | VARCHAR2(5) NOT NULL | Reporting Entity ID |
| 2 | BUYER_ID |
Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 3 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 6 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 8 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 9 | SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 10 | SHIPTO_SETID | Character(5) | VARCHAR2(5) NOT NULL | ShipTo SetID |
| 11 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |