PO_ITM_STG_VW5(SQL View) |
Index Back |
|---|---|
Summed By Line |
| SELECT PROCESS_INSTANCE , BUSINESS_UNIT , PO_ID , PO_LINE_NBR , ITM_SETID , INV_ITEM_ID , CONSOLIDATE_FLG , CALC_PRICE_FLG , PRICE_COMPL_FLG , STAGE_STATUS , SUM(QTY_REQ) , SUM(QTY_REQ_STD) , SUM(MERCHANDISE_AMT) FROM PS_PO_ITM_STG_UD WHERE STAGE_STATUS = 'V' GROUP BY PROCESS_INSTANCE, BUSINESS_UNIT, PO_ID, PO_LINE_NBR, ITM_SETID, INV_ITEM_ID, CONSOLIDATE_FLG, CALC_PRICE_FLG, PRICE_COMPL_FLG, STAGE_STATUS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 4 | PO_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Purchase Order Line Number |
| 5 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 6 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | CONSOLIDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Consolidate with other Reqs
N=No Y=Yes |
| 8 | CALC_PRICE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculate Price? |
| 9 | PRICE_COMPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Price Complete Flag |
| 10 | 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 |
| 11 | QTY_REQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Requisition Quantity |
| 12 | QTY_REQ_STD | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Requested Stand. UOM |
| 13 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |