CC_PO_SCHED_VW(SQL View) |
Index Back |
|---|---|
ProCard PO_SCHED_NBR prompt03/02/2020 MANINSRI PSFTPO-5336 Streamline PCard Processing-Added 2 fields-DUE_DT and SHIPTO_ID |
| SELECT A.BUSINESS_UNIT , A.PO_ID , B.LINE_NBR , C.SCHED_NBR , A.PO_DT , A.PO_STATUS , C.CANCEL_STATUS , C.DUE_DT , C.SHIPTO_ID FROM PS_PO_HDR A , PS_PO_LINE B , PS_PO_LINE_SHIP C WHERE A.PO_STATUS IN ('A', 'D') AND A.MID_ROLL_STATUS <> 'Y' AND A.MATCH_STATUS_PO <> 'M' AND C.CANCEL_STATUS = 'A' AND %Join(COMMON_KEYS, PO_HDR A, PO_LINE B) AND %Join(COMMON_KEYS, PO_LINE B, PO_LINE_SHIP C) |
| # | 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 | PO_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Purchase Order Line Number |
| 4 | PO_SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL | PO Schedule Number |
| 5 | PO_DT | Date(10) | DATE | Date |
| 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 | CANCEL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Cancel Status
A=Active C=Closed D=Denied H=Hold O=Open P=Pending Approval X=Canceled |
| 8 | DUE_DT | Date(10) | DATE | Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. |
| 9 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |