PRODUCT_IDCB_CONTRACT_IDUOM_ORDEREDMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
OM_CBQTY_VW(SQL View) |
Index Back |
|---|---|
OM Claimback Quantity ViewOM Claimback Quantity View |
| SELECT L.PRODUCT_ID , S.CB_CONTRACT_ID , L.UNIT_OF_MEASURE , 'N' , C.UNIT_OF_MEASURE , %Round(%DecMult(%Round(SUM(S.QTY_SCHEDULED), 4), (%DecDiv(1, CONV.CONVERSION_RATE))), 4) , CONV.SETID , C.SETID , P.SETID , 0 , 0 FROM PS_ORD_LINE L , PS_ORD_SCHEDULE S , PS_CB_HDR C , PS_INV_ITEM_UOM CONV , PS_PROD_ITEM P WHERE L.BUSINESS_UNIT = S.BUSINESS_UNIT AND L.ORDER_NO = S.ORDER_NO AND L.ORDER_INT_LINE_NO = S.ORDER_INT_LINE_NO AND P.PRODUCT_ID = L.PRODUCT_ID AND CONV.INV_ITEM_ID = P.INV_ITEM_ID AND CONV.UNIT_OF_MEASURE = L.UNIT_OF_MEASURE AND C.CB_CONTRACT_ID = S.CB_CONTRACT_ID GROUP BY L.PRODUCT_ID, S.CB_CONTRACT_ID, C.UNIT_OF_MEASURE, L.UNIT_OF_MEASURE, CONV.CONVERSION_RATE, CONV.SETID, C.SETID, P.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 2 | CB_CONTRACT_ID |
Character(25) | VARCHAR2(25) NOT NULL | Claimback Contract ID |
| 3 | UOM_ORDERED |
Character(3) | VARCHAR2(3) NOT NULL | Unit Of Measure Ordered |
| 4 | CALC_PRICE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculate Price? |
| 5 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 6 | QTY_ORDERED | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Order Qty |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 8 | CB_CONTRACT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Claimback Contract Setid |
| 9 | SETID_PRODUCT | Character(5) | VARCHAR2(5) NOT NULL | Product SetID |
| 10 | QTY_ORDERED_PREV | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Qty Ordered |
| 11 | QTY_TOTAL | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Quantity Total |