IN_DMD_CHG_CFG(SQL Table) |
Index Back |
|---|---|
Demand Change Config MetadataDate Initials Issue Description 052504 dms F-KNANN-V59N4 New table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: IN_DMDCH_FLD_VW |
| 2 | OM_CHANGE_STATE | Character(2) | VARCHAR2(2) NOT NULL |
Allow OM Changes Thru
Prompt Table: IN_CFG_STATE_VW |
| 3 | OM_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
OM Fieldname
Prompt Table: OM_IN_DMD_FLD |
| 4 | OM_ALLOW_CHG | Character(1) | VARCHAR2(1) NOT NULL |
Allow OM Update Past OM State
Y/N Table Edit Default Value: Y |
| 5 | IN_CHANGE_STATE | Character(2) | VARCHAR2(2) NOT NULL |
Allow INV Changes Thru
Prompt Table: IN_CFG_STATE_VW |
| 6 | IN_FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
INV Fieldname
Prompt Table: IN_IN_DMD_FLD |
| 7 | CHG_ALL_DEMAND | Character(1) | VARCHAR2(1) NOT NULL |
Change Applies to All Demand
Y/N Table Edit Default Value: N |
| 8 | CHNG_ORD_SEQ | Number(3,0) | SMALLINT NOT NULL | Change Order Sequence Number |
| 9 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 10 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 11 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
System Data
Y/N Table Edit Default Value: N |