FIELDNAMEPL_IP_ITMFLD_VW(SQL View) |
Index Back |
|---|---|
Item fields in DP_PUB_IPMAST01/07/03 EGS (CN#PL880-1): Added |
| SELECT A.FIELDNAME FROM PSRECFIELD A , PSDBFIELD B WHERE A.FIELDNAME = B.FIELDNAME AND (A.RECNAME = 'DP_PUB_IPMAST' AND (A.FIELDNAME LIKE 'ITEM_FIELD%' OR A.FIELDNAME = 'DP_ITEMCODE' OR A.FIELDNAME = 'RELATED_ITEM_ID' OR A.FIELDNAME = 'DESCR') OR (A.RECNAME = 'DP_SUBUDFLDS' AND A.FIELDNAME LIKE 'DP_UD%' AND B.FIELDTYPE = 0)) AND B.LENGTH >= 18 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |