CA_REV_RECOG_VW

(SQL View)
Index Back

SELECT A.FIELDVALUE , A.XLATLONGNAME FROM PSXLATITEM A , PS_INSTALLATION_CA B WHERE A.FIELDNAME = 'REV_RECOG_METHOD' AND (A.FIELDVALUE <> '5' OR B.ALLOW_METHOD_CHG = 'Y')

  • Related Language Record: CA_REVREC_VW_LG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description