FIELD PROPERTIES
----

SELECT DISTINCT
FD.FIELDNAME
,CASE FD.FIELDTYPE
WHEN 0 THEN 'Char'
WHEN 1 THEN 'Long Char'
WHEN 2 THEN 'NBR'
WHEN 3 THEN 'Sign'
WHEN 4 THEN 'Date'
WHEN 5 THEN 'Time'
WHEN 6 THEN 'Dttm'
WHEN 7 THEN 'Img'
WHEN 8 THEN 'Vers'
ELSE ' ' END "TYPE"
,FD.LENGTH
,FL.SHORTNAME
,FL.LONGNAME
FROM PSDBFIELD FD,
PSDBFLDLABL FL,
PSPROJECTITEM PI
WHERE FD.FIELDNAME = FL.FIELDNAME
AND PI.OBJECTVALUE1 = FD.FIELDNAME
AND PI.OBJECTTYPE = 2
AND PI.OBJECTID1 = 6
AND FD.FIELDNAME = '' *** give ur fieldname here
ORDER BY FD.FIELDNAME;

they are not mine but picked from blog http://peoplesofthelp.blogspot.com/

Views: 72

Reply to This

Replies to This Discussion

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)

RSS

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2022   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service