FIELDNAMEPL_DP_BUFLD_VW(SQL View) |
Index Back |
|---|---|
PL_DP_BUFLD_VWPL_DP_BUFLD_VW |
| SELECT A.FIELDNAME FROM PSRECFIELD A , PSDBFIELD B WHERE A.FIELDNAME = B.FIELDNAME AND A.RECNAME = 'DP_PUB_FCITEMS' AND (A.FIELDNAME LIKE 'BUSINESS_UNIT%' OR A.FIELDNAME LIKE 'ITEM_FIELD%' OR A.FIELDNAME LIKE 'PROD_FIELD%' OR A.FIELDNAME LIKE 'CUST_FIELD%' OR A.FIELDNAME = 'DP_LOCATION') 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). |