SELY/N Table Edit
Default Value: N
FIELDNAMEITM_TMP_MAST_VW(SQL View) |
Index Back |
|---|---|
Item Mass Update |
| SELECT 'N' , A.FIELDNAME , B.SHORTNAME FROM PSRECFIELD A , PSDBFLDLABL B WHERE A.FIELDNAME = B.FIELDNAME AND B.DEFAULT_LABEL = 1 AND (A.RECNAME = 'MASTER_ITEM_SBR' OR (A.RECNAME = 'MASTER_ITEM_TBL' AND A.FIELDNAME IN ( SELECT C.FIELDNAME FROM PSRECFIELD C WHERE C.FIELDNAME <> 'MASTER_ITEM_SBR' AND C.RECNAME IN ('MASTER_ITEM_EC', 'MASTER_ITEM_ESR') ) ) ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEL |
Character(1) | VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit Default Value: N |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 3 | SHORTNAME | Character(15) | VARCHAR2(15) NOT NULL | Field Short Name |