IN_DMD_CHANGE

(SQL Table)
Index Back

Demand Change Configuration

Date Initials Issue Description 052504 dms F-KNANN-V59N4 New table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
3 OM_CHANGE_STATE Character(2) VARCHAR2(2) NOT NULL Allow OM Changes Thru

Prompt Table: IN_CFG_STATE_VW

4 IN_CHANGE_STATE Character(2) VARCHAR2(2) NOT NULL Allow INV Changes Thru

Prompt Table: IN_CFG_STATE_VW

5 OM_ALLOW_CHG Character(1) VARCHAR2(1) NOT NULL Allow OM Update Past OM State

Y/N Table Edit

Default Value: Y

6 NOTIFY_STATE Character(2) VARCHAR2(2) NOT NULL Notification State

Prompt Table: IN_CFG_STATE_VW

7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: IN_DMD_CNTCT_VW