IN_SDMC_FLD_VW (SQL View)	Index Back
Prompt for MC fields Prompt for fields that potentially qualify for mass change. Note that not all fields in this prompt currently available for mass change in the workcenter or dashboard.

IN_SDMC_FLD_VW

(SQL View)

Prompt for MC fields

Prompt for fields that potentially qualify for mass change. Note that not all fields in this prompt currently available for mass change in the workcenter or dashboard.

SELECT DISTINCT IN_FIELDNAME FROM PS_IN_DMD_CHG_CFG WHERE ((IN_FIELDNAME > ' ' OR IN_CHANGE_STATE > '00') OR (FIELDNAME = 'BUSINESS_UNIT')) AND IN_FIELDNAME NOT IN ('DELIVERY_ID2', ' ','ADDRESS1','QTY_PER','QTY_REQUESTED','ADDR_OVRD_LEVEL','ADDRESS_SEQ_NUM','CONFIG_CODE','SHIP_TO_CUST_ID','LOCATION','CNTCT_SEQ_SHIP','WO_ID','INV_ITEM_ID','UNIT_OF_MEASURE','PEG_STATUS','SUP_PEG_STATUS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).