VCHRDS_ENTY_VW

(SQL View)
 Index Back

EC Voucher Header


SELECT A.FIELDNAME , B.LONGNAME FROM PSRECFIELDDB A , PSDBFLDLABL B WHERE A.RECNAME = 'VCHDS_ENTRY_WRK' AND A.FIELDNAME = B.FIELDNAME AND B.DEFAULT_LABEL = 1 AND A.FIELDNAME NOT IN ( SELECT T.FIELDNAME FROM PS_FS_CF_TEMPLATE T WHERE T.CF_ACTIVE_STATUS = 'I')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name