MOC_PRDPRCB_VW

(SQL View)
 Index Back

Product Price view.

Mobile Order Capture uses this Level 1 Product Price view to store the Product ID and Pricing related fields.

SELECT A.SETID , A.PRODUCT_ID , A.UNIT_OF_MEASURE , A.CURRENCY_CD , A.EFFDT , B.DESCR , C.DESCR , A.LIST_PRICE , A.UNIT_COST , A.RECUR_PRICE , A.PW_FREQUENCY , A.DATETIME_ADDED , A.LASTUPDDTTM , A.LAST_MAINT_OPRID , A.SYNCID , A.SYNCDTTM FROM PS_PROD_PRICE A , PS_UNITS_TBL B , PS_CURRENCY_CD_TBL C WHERE A.UNIT_OF_MEASURE = B.UNIT_OF_MEASURE AND A.CURRENCY_CD = C.CURRENCY_CD AND A.EFF_STATUS = 'A' AND A.LIST_PRICE = ( SELECT MIN(A_ED.LIST_PRICE) FROM PS_PROD_PRICE A_ED WHERE A.SETID = A_ED.SETID AND A.PRODUCT_ID = A_ED.PRODUCT_ID AND A.UNIT_OF_MEASURE = A_ED.UNIT_OF_MEASURE AND A.CURRENCY_CD = A_ED.CURRENCY_CD AND A_ED.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_PROD_PRICE B WHERE A_ED.SETID = B.SETID AND A_ED.PRODUCT_ID = B.PRODUCT_ID AND A_ED.UNIT_OF_MEASURE = B.UNIT_OF_MEASURE AND A_ED.BUSINESS_UNIT_IN = B.BUSINESS_UNIT_IN AND A_ED.CURRENCY_CD = B.CURRENCY_CD AND B.EFFDT <= %CurrentDateIn) )

  • Related Language Record: MOC_PRDPRCB_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    CS=Case
    EA=Each
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: %EDITTABLE

    4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    8 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
    9 UNIT_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Unit Cost
    10 RECUR_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Recurring Price
    11 PW_FREQUENCY Character(2) VARCHAR2(2) NOT NULL Recurring Frequency
    00=Daily
    05=Weekly
    10=Monthly
    15=Quarterly
    20=Annually
    12 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
    13 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    14 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL This field determines the last user or operator that last changed this item.
    15 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time