GM_PRDCT_FF_VW

(SQL View)
 Index Back

Product Ids for Fixed Fee


SELECT SETID , PRODUCT_ID , DESCR , CA_BP_TMPL_ID , CA_AP_TMPL_ID , INV_ITEM_ID , PRODUCT_USE , THIRD_PARTY_FLG , RENEWABLE , PERCENTAGE , APPLIES_TO , BP_DTL_TMPL_ID , RNW_TEMPLATE_ID , TAX_TRANS_TYPE , TAX_TRANS_SUB_TYPE , REV_RECOG_METHOD FROM PS_PROD_ITEM WHERE PRODUCT_USE IN ('2', '3') AND EFF_STATUS = 'A' AND PRICING_STRUCTURE <> 'RATE' AND REV_RECOG_METHOD NOT IN (' ', '1') AND PRODUCT_KIT_FLAG = 'N'

  • Related Language Record: PROD_ITEMVLNG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CA_BP_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Bill Plan Template
    5 CA_AP_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Revenue Plan Template
    6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    7 PRODUCT_USE Character(1) VARCHAR2(1) NOT NULL Field for distinguishing which products can use a product definition.
    1=General Use Excluding Contract
    2=Contracts Only
    3=General Use Including Contract
    8 THIRD_PARTY_FLG Character(1) VARCHAR2(1) NOT NULL Third Party Flag
    9 RENEWABLE Character(1) VARCHAR2(1) NOT NULL Renewable
    10 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    11 APPLIES_TO Character(4) VARCHAR2(4) NOT NULL PSIRS-KK
    HDR=% of Total Contract Amount
    LINE=% of Contract Lines
    12 BP_DTL_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Bill Plan Detail Template ID
    13 RNW_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Renewal Plan Template
    14 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
    1=Sale
    2=Rental
    3=Service
    4=Purchase
    5=Lease
    B=Return
    15 TAX_TRANS_SUB_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Sub Type
    1=Property
    2=Freight
    3=Service
    4=Rental or Lease
    5=Expense
    6=Misc
    N=None
    16 REV_RECOG_METHOD Character(4) VARCHAR2(4) NOT NULL Revenue Recognition Method
    1=As Incurred
    2=Apportionment
    3=Percent Complete
    4=Milestone
    5=Billing Manages Revenue