SETIDTEMPLATE_LIST_IDITM_CHG_REC_LISTIN_ITMC_FL_LST(SQL View) |
Index Back |
|---|---|
Item Change Field ListItem Change Process - Field List |
| SELECT DISTINCT B.SETID ,B.TEMPLATE_LIST_ID ,B.ITM_CHG_REC_LIST ,'N' ,B.FIELDNAME ,B.FIELD_ID , ' ' FROM PS_IN_ITM_CHG_DT B WHERE ALLOW_MODIFY = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | TEMPLATE_LIST_ID |
Character(20) | VARCHAR2(20) NOT NULL | Item Template List ID |
| 3 | ITM_CHG_REC_LIST |
Character(3) | VARCHAR2(3) NOT NULL | 10/05/2012 : Created New Field for FDAM-01 Item Maintenance Template.Contains translate value for Record names for Change Value Page in Item Template. |
| 4 | SEL | Character(1) | VARCHAR2(1) NOT NULL | Select |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 6 | FIELD_ID | Character(24) | VARCHAR2(24) NOT NULL | Config Field Id |
| 7 | ALLOW_MODIFY | Character(1) | VARCHAR2(1) NOT NULL | Allow Modify Comments |