CA_FC_PRICTY_VW

(SQL View)
 Index Back

Price Type


SELECT B.FIELDVALUE , B.XLATLONGNAME FROM PSXLATITEM B WHERE B.FIELDNAME = 'PRICING_STRUCT' AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PSXLATITEM B1 WHERE B1.FIELDNAME = B.FIELDNAME AND B1.FIELDVALUE = B.FIELDVALUE AND B1.EFFDT <= %CurrentDateIn)

  • Related Language Record: CA_FC_PT_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PRICING_STRUCTURE Character(4) VARCHAR2(4) NOT NULL Price Type
    AMT=Amount
    PCT=Percent
    RATE=Rate
    RCR=Recurring
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description