IN_SDWC_CCFG_VW

(SQL View)
Index Back

Demand Change Rule

Demand change rule for Delivery Workbench

SELECT BUSINESS_UNIT , FIELDNAME , '00' , '50' , 'Y' , '10' , OPRID , 'Y' FROM PS_IN_DMD_CHANGE

# 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
7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
8 RULE_FLAG Character(1) VARCHAR2(1) NOT NULL Rule Flag