FIELDNAMEPL_IP_BUFLD_VW(SQL View) |
Index Back |
|---|---|
BU fields from 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_LOCATION' OR A.FIELDNAME = 'DESCR' OR A.FIELDNAME = 'RELATED_ITEM_ID')) OR (A.RECNAME = 'DP_SUBUDFLDS' AND A.FIELDNAME LIKE 'DP_UD%' AND B.FIELDTYPE = 0)) AND B.LENGTH >= 5 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |