CP_KITCOMPS_VW

(SQL View)
 Index Back

Product Kit Component Vw

Joined View of tables: PRODKIT_COMPS PROD_ITEM

SELECT A.SETID , A.PRODUCT_ID , A.PROD_COMPONENT_ID , B.DESCR , A.DATE_IN_EFFECT , A.DATE_OBSOLETE , A.QTY_PER , A.QTY_CODE , A.OPTIONAL_SHIP , A.UNIT_OF_MEASURE , A.SEQ_NUM , B.PRODUCT_KIT_FLAG , B.PRICE_KIT_FLAG , 1 , 0 , 0 , 'N' , 0 , 0 , A.MIN_QTY_PER , A.MAX_QTY_PER , 0 , ' ' , 0 FROM PS_PRODKIT_COMPS A , PS_PROD_ITEM B WHERE A.SETID = B.SETID AND A.PROD_COMPONENT_ID = B.PRODUCT_ID AND B.EFF_STATUS = 'A'

  • Related Language Record: CP_KITCOMPS_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 PROD_COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL Product Component ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label
    6 DATE_OBSOLETE Date(10) DATE Obsolete Date
    7 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
    8 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
    ASY=Assembly
    ORD=Order
    9 OPTIONAL_SHIP Character(1) VARCHAR2(1) NOT NULL OK to Ship Without
    10 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    11 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    12 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit
    13 PRICE_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Price Kit Flag
    C=Price Kit at Component Level
    T=Price Kit at Top Level
    14 LEVEL_NUM Number(3,0) SMALLINT NOT NULL Level
    15 CP_PARENT_ROW Number(5,0) INTEGER NOT NULL Parent Row Number Field
    16 CP_NUM_COMPS Number(5,0) INTEGER NOT NULL Number of Components Field
    17 LT_CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Litely configured package flag
    18 MIN_COMP Number(17,0) DECIMAL(17) NOT NULL Minimum Component Quantity
    19 MAX_COMP Number(17,0) DECIMAL(17) NOT NULL Maximum Component Quantity
    20 MIN_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Minimum Quantity
    21 MAX_QTY Signed Number(20,6) DECIMAL(18,6) NOT NULL Maximum Quantity
    22 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
    23 PPRC_RECUR_FREQ Character(2) VARCHAR2(2) NOT NULL Recurring Frequency
    00=Daily
    05=Weekly
    10=Monthly
    15=Quarterly
    20=Annually
    24 RECUR_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Recurring Price