ORD_UOMPRC_VW

(SQL View)
 Index Back

Product Pricing UOM View

Product Pricing UOM View

SELECT DISTINCT L.BUSINESS_UNIT , L.ORDER_NO , L.PRODUCT_ID , P.UNIT_OF_MEASURE , P.DFLT_UOM , P.MIN_ORDER_QTY , P.MAX_ORDER_QTY , P.ORDER_INCREMENT , P.PROD_PRICE_FLG , P.PRICING_UOM_FLG , I.ADJUST_ALTCOST_PCT , I.ADJUST_ALTCOST_FLG , I.EOEP_MRGBASE_FLG FROM %Table(ORD_LINE) L , %Table(PROD_UOM) P , %Table(PROD_ITEM) I , %Table(SET_CNTRL_REC) X WHERE L.PRODUCT_ID = P.PRODUCT_ID AND P.SETID = X.SETID AND X.SETCNTRLVALUE = L.BUSINESS_UNIT AND X.RECNAME = 'PROD_ITEM' AND P.PRODUCT_ID = I.PRODUCT_ID AND I.SETID = X.SETID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
4 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
5 DFLT_UOM Character(1) VARCHAR2(1) NOT NULL Vendor Default UOM
6 MIN_ORDER_QTY Number(15,4) DECIMAL(14,4) NOT NULL Minimum Order Quantity
7 MAX_ORDER_QTY Number(15,4) DECIMAL(14,4) NOT NULL Maximum Order Quantity
8 ORDER_INCREMENT Number(15,4) DECIMAL(14,4) NOT NULL Order Increment
9 PROD_PRICE_FLG Character(1) VARCHAR2(1) NOT NULL Pricing Option
0=Regular
1=KVI
2=NDP
10 PRICING_UOM_FLG Character(1) VARCHAR2(1) NOT NULL Pricing UOM Flag
0=No
1=Yes
2=Default
11 ADJUST_ALTCOST_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Alternate Cost Adjust Percent
12 ADJUST_ALTCOST_FLG Character(1) VARCHAR2(1) NOT NULL Adjust Alternate cost flag indicates whether 0% adjustment is a valid value.
13 EOEP_MRGBASE_FLG Character(1) VARCHAR2(1) NOT NULL Margin Base
1=Cost
2=Alternate