GP_RND_SIZE_VW

(SQL View)
 Index Back

Round Size Values View

Round Size Values View

SELECT %Substring(FIELDVALUE, 1, 3) ,A.effdt ,A.xlatlongname FROM PSXLATITEM A WHERE fieldname = 'RND_SIZE'

  • Related Language Record: GP_RND_SIZE_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RND_SIZE Character(3) VARCHAR2(3) NOT NULL Rounding Size
    -01=x0.000000
    -02=x00.000000
    -03=x,000.000000
    -04=x0,000.000000
    -05=x00,000.000000
    -06=x,000,000.000000
    -07=x0,000,000.000000
    -08=x00,000,000.000000
    -09=x,000,000,000.000000
    -10=x0,000,000,000.000000
    -11=x00,000,000,000.000000
    0=x.000000
    01=x.x00000
    02=x.xx0000
    03=x.xxx000
    04=x.xxxx00
    05=x.xxxxx0
    2 EFFDT Date(10) DATE Effective Date
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name