RF_SHOW_PRICE

(SQL Table)
 Index Back

Agreement Line Price info

Agreement Line Price info used for displaying on Entitlement page

  • Related Language Record: RF_SHOW_PCE_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AG_SVC_LINE_PRICE Number(12,2) DECIMAL(11,2) NOT NULL Transaction price for service on an agreement line
    2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.
    3 SVC_UNIT_TYPE Character(4) VARCHAR2(4) NOT NULL This field is used to represent the transaction price unit type
    CASE=Case
    DAY=Day
    HOUR=Hour
    MON=Month
    SO=Service Order
    WEEK=Week
    YEAR=Year
    4 SVC_PURCH_OPT Character(4) VARCHAR2(4) NOT NULL This field is used to represent the transaction price purchase option
    FLAT=Flat Rate
    PRPD=Prepaid Services/Cases
    TM=Time & Materials
    5 SERVICE_CTR Signed Number(10,2) DECIMAL(8,2) NOT NULL This field is used to represent the remaining quantity available for pre-paid services
    6 PURCHASE_OPTN Character(4) VARCHAR2(4) NOT NULL This field is used to represent the purchase option (used in agreement pricing)
    FLAT=Flat Rate
    PRPD=Prepaid Cases/Services
    TM=Time & Material
    7 PRPD_UNIT_TYPE Character(4) VARCHAR2(4) NOT NULL This field is used to represent the prepaid unit type
    CASE=Case
    DAY=Day
    HOUR=Hour
    MON=Month
    SO=Service Order
    WEEK=Week
    YEAR=Year
    8 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service ID
    9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 SELECTION Character(1) VARCHAR2(1) NOT NULL EI Repos: Selection
    N=N
    Y=Y

    Default Value: N

    12 PROD_PREPAID_QTY Number(6,0) INTEGER NOT NULL Product prepaid quantity - store product level prepaid on agreemnt line product grid.
    13 PROD_PREPAID_UNIT Character(4) VARCHAR2(4) NOT NULL Prepaid unit for agreement line setup - product grid when agreement category is external no pricing.
    CASE=Case
    HOUR=Hour
    SO=Service Order
    14 PROD_REMAINING_QTY Number(9,2) DECIMAL(8,2) NOT NULL product remaining quantity on agreement setup page - product grid when agreement category is external no pricing.
    15 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    16 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement
    17 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
    18 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number
    19 WARRANTY_NAME Character(40) VARCHAR2(40) NOT NULL This field is used to store the name of the warranty.