AR_FLD_DT_VWLG(SQL View) |
Index Back |
---|---|
Item Record Date References |
SELECT F.FIELDNAME , G.LANGUAGE_CD , G.LONGNAME FROM PSRECFIELD F , PSDBFIELD D , PSDBFLDLABL L , PSDBFLDLABLLANG G WHERE F.RECNAME = 'ITEM' AND F.FIELDNAME = D.FIELDNAME AND D.FIELDTYPE = 4 AND D.FIELDNAME = L.FIELDNAME AND L.DEFAULT_LABEL = 1 AND L.FIELDNAME = G.FIELDNAME AND L.LABEL_ID = G.LABEL_ID 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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |