FIELDNAMEAR_FLD_DT_VW(SQL View) |
Index Back |
|---|---|
Item Record Date References |
| SELECT F.fieldname , L.longname FROM psrecfield F , PSDBFIELD D , psdbfldlabl L WHERE F.recname = 'ITEM' AND F.fieldname = D.fieldname AND D.fieldtype = 4 AND D.fieldname = L.fieldname AND L.default_label = 1 AND F.fieldname NOT IN ('DISPUTE_DT', 'DISC_DT', 'DISC_DT1','DUN_DT', 'ST_DT', 'FC_DT', 'COLLECTION_DT', 'LAST_ACTIVITY_DT', 'OC_ADMIN_DT', 'OC_PNLTY_DT', 'POST_DT') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |