[cardcounter0]

You mean there is more than one programming language???

SELECT A.RECNAME,
A.FIELDNAME,
decode(B.FIELDTYPE, '0', 'CHAR', '2', 'NUMERIC', '3', 'DECIMAL', '4', 'DATE', 'NA') as TYPE,
' x ',
B.LENGTH,
C.LONGNAME
FROM PSRECFIELDDB A, PSDBFIELD B, PSDBFLDLABL C
WHERE A.RECNAME in
('MASTER_ITEM_EC',
'INV_ITEMS_EC',
'ITEM_VENDOR_EC',
'ITM_VNDR_LOC_EC',
'ITM_VNDR_UOM_EC',
'ITM_VNDR_UMPR_EC',
'PUR_ITM_ATTR_EC',
'INV_ITM_UOM_EC')
AND A.FIELDNAME = B.FIELDNAME
AND C.FIELDNAME = A.FIELDNAME
AND C.DEFAULT_LABEL = 1
ORDER BY 1, 2