PO_CLS_SHORT_VW(SQL View) |
Index Back |
|---|---|
PO Close Short Work ScrollWork scroll used for PO Close Short Workbench |
| SELECT H.BUSINESS_UNIT ,W.WORKBENCH_ID ,H.PO_ID ,L.LINE_NBR ,S.SCHED_NBR ,H.ACTIVITY_DATE ,L.CLOSE_SHORT_FLG ,L.DESCR254_MIXED ,S.DUE_DT ,S.PCT_UNDER_QTY ,H.PO_DT ,S.PRICE_PO ,S.QTY_PO ,0 ,H.BUYER_ID ,L.INV_ITEM_ID ,H.VENDOR_ID ,L.CNTRCT_SETID ,L.CNTRCT_ID ,L.GPO_ID , L.RECV_REQ , L.AMT_ONLY_FLG , S.MATCH_LINE_OPT , S.MATCH_STATUS_LN_PO , SUM(S.MERCHANDISE_AMT) FROM PS_PO_CLS_SHORT_WB W , PS_PO_HDR H , PS_PO_LINE L , PS_PO_LINE_SHIP S WHERE W.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.PO_ID = L.PO_ID AND H.PO_STATUS NOT IN ('I', 'X', 'C') AND L.CANCEL_STATUS NOT IN ('X', 'C') AND H.BUSINESS_UNIT = S.BUSINESS_UNIT AND H.PO_ID = S.PO_ID AND L.LINE_NBR = S.LINE_NBR AND S.WORK_ORDER_ID = ' ' GROUP BY H.BUSINESS_UNIT, W.WORKBENCH_ID, H.PO_ID, L.LINE_NBR, S.SCHED_NBR, H.ACTIVITY_DATE, L.CLOSE_SHORT_FLG, L.DESCR254_MIXED, S.DUE_DT, S.PCT_UNDER_QTY, H.PO_DT, S.PRICE_PO, S.QTY_PO, H.BUYER_ID, L.INV_ITEM_ID, H.VENDOR_ID, L.CNTRCT_SETID, L.CNTRCT_ID, L.GPO_ID, L.RECV_REQ, L.AMT_ONLY_FLG, S.MATCH_LINE_OPT, S.MATCH_STATUS_LN_PO |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
| 2 | WORKBENCH_ID |
Character(10) | VARCHAR2(10) NOT NULL | WorkBench ID |
| 3 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 4 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 5 | SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL |
Schedule Number
Default Value: 1 |
| 6 | ACTIVITY_DATE | Date(10) | DATE | Last Activity |
| 7 | CLOSE_SHORT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Close Short Flag |
| 8 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 9 | DUE_DATE | Date(10) | DATE | Delivery Due Date from PO |
| 10 | PCT_UNDER_QTY | Signed Number(4,0) | DECIMAL(3) NOT NULL | Close PO Under Qty Pct Tol |
| 11 | PO_DT | Date(10) | DATE | Date |
| 12 | PRICE_PO | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Purchase Order Price |
| 13 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |
| 14 | QTY_RECEIVED | Number(16,4) | DECIMAL(15,4) NOT NULL | Received Qty |
| 15 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL |
Buyer
Prompt Table: BUYER_ALL_VW |
| 16 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: ITM_PURCH_VW |
| 17 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_VW |
| 18 | CNTRCT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 19 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table: PO_L1_CNTRCT_VW |
| 20 | GPO_ID | Character(18) | VARCHAR2(18) NOT NULL |
GPO ID
Prompt Table: GPO_TBL_VW |
| 21 | RECV_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Receiving Required
N=Optional X=Do Not Y=Required Default Value: N |
| 22 | AMT_ONLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Amount Only
N=No Y=Yes |
| 23 | MATCH_LINE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Match Line Option
E=ERS F=Full Match N=Don't Match |
| 24 | MATCH_STATUS_LN_PO | Character(1) | VARCHAR2(1) NOT NULL |
Match Status PO
M=Matched N=Not Matched P=Partially Matched |
| 25 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |