ITM_TMPLT_PR_VW

(SQL View)
 Index Back

Item Mass Update


SELECT RECNAME , RECDESCR FROM PSRECDEFN WHERE RECNAME IN ('MASTER_ITEM_TBL', 'INV_ITEMS', 'INV_ITEM_UOM', 'BU_ITEMS_INV', 'BU_ITEMS_WTVOL', 'EN_REVISION', 'PURCH_ITEM_ATTR', 'ITM_VENDOR', 'ITM_VENDOR_LOC', 'ITM_VNDR_UOM', 'ITM_VNDR_UOM_PR')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description