SELY/N Table Edit
Default Value: N
FIELDNAMEITM_TMP_ITVN_VW(SQL View) |
Index Back |
|---|---|
Item Mass Update |
| SELECT 'N' , A.FIELDNAME , C.SHORTNAME FROM PSRECFIELD A , PSDBFLDLABL C WHERE A.RECNAME = 'ITM_VENDOR' AND A.FIELDNAME = C.FIELDNAME AND C.DEFAULT_LABEL = 1 AND EXISTS ( SELECT 'X' FROM PSRECFIELD B WHERE B.FIELDNAME = A.FIELDNAME AND B.RECNAME IN ('ITEM_VENDOR_EC', 'ITM_VND_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 |