ITM_TMPLT_BU_VW

(SQL View)
Index Back

Item Mass Update


SELECT 'N' , 'BU_ITM_INV_EC' , A.FIELDNAME , B.SHORTNAME FROM PSRECFIELD A , PSDBFLDLABL B WHERE (A.RECNAME = 'BU_ITM_INV_EC' OR A.RECNAME = 'MASTER_ITEM_SBR' OR A.RECNAME = 'BU_ITM_INV_ESR' AND A.FIELDNAME NOT IN ('MASTER_ITEM_SBR', 'BU_ITM_INV_ESR')) AND A.FIELDNAME = B.FIELDNAME AND B.DEFAULT_LABEL = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEL Character(1) VARCHAR2(1) NOT NULL Select

Y/N Table Edit

Default Value: N

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name