IN_SDMC_CONFIG

(SQL Table)
Index Back

Mass Change field setup

Lists the fields available for mass change by functional area

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 IN_SD_FUNC_AREA Character(2) VARCHAR2(2) NOT NULL Functional Application Area
IN=Inventory
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: IN_SDMCSETUP_VW

4 NOTIFY_IN Character(1) VARCHAR2(1) NOT NULL Notify Inventory Manager

Y/N Table Edit

Default Value: Y

5 NOTIFY_OM Character(1) VARCHAR2(1) NOT NULL Notify Sales Order Owner

Y/N Table Edit

Default Value: Y

6 SEND_EMAIL Character(1) VARCHAR2(1) NOT NULL Action Workflow Flag

Default Value: Y

7 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL System Data

Y/N Table Edit

Default Value: N

8 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template

Prompt Table: IN_SDMC_TMPH_VW