FIELDNAMEPL_DP_ITMFLD_VW(SQL View) |
Index Back |
|---|---|
PL_DP_ITMFLD_VWPL_DP_ITMFLD_VW |
| SELECT A.FIELDNAME FROM PSRECFIELD A , PSDBFIELD B WHERE A.FIELDNAME = B.FIELDNAME AND A.RECNAME = 'DP_PUB_FCITEMS' AND (A.FIELDNAME LIKE 'ITEM_FIELD%' OR A.FIELDNAME LIKE 'PROD_FIELD%' OR A.FIELDNAME = 'INV_ITEM_ID' OR A.FIELDNAME = 'DP_ITEMCODE') 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). |