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 , B.AGREEMENT_CODE , 1 , 0 , 0 , 'N' , 0 , 0 , A.MIN_QTY , A.MAX_QTY , 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 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 PROD_COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL Field is used to store components of a product
    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
    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.
    CS=Case
    EA=Each
    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 Flag
    13 PRICE_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Price Kit Flag
    C=at Component Level
    T=at Top Level
    14 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
    15 LEVEL_NUM Number(3,0) SMALLINT NOT NULL Level
    16 CP_PARENT_ROW Number(5,0) INTEGER NOT NULL Parent Row Number Field
    17 CP_NUM_COMPS Number(5,0) INTEGER NOT NULL Number of Components Field
    18 LT_CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Litely configured package flag
    19 MIN_COMP Number(17,0) DECIMAL(17) NOT NULL Minimum Component Quantity
    20 MAX_COMP Number(17,0) DECIMAL(17) NOT NULL Maximum Component Quantity
    21 MIN_QTY Number(10,4) DECIMAL(9,4) NOT NULL Minimum Quantity
    22 MAX_QTY Number(10,4) DECIMAL(9,4) NOT NULL Maximum Quantity
    23 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price
    24 PPRC_RECUR_FREQ Character(2) VARCHAR2(2) NOT NULL Field used to store the recurring frequency.
    00=Daily
    05=Weekly
    10=Monthly
    15=Quarterly
    20=Annually
    25 RECUR_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Recurring Price