GP_RND_SIZE_LNG

(SQL View)
 Index Back

Round Size Values View

Round Size Values View

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

  • Related Language Record for GP_RND_SIZE_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE Effective Date
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name