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')

  • Related Language Record for AR_FLD_DT_VW
  • # 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