INV_SHPKEY_VW

(SQL View)
 Index Back

BUIN key fields with name

BUIN_SHP_KEYFLD with names.

SELECT s.fieldname , l.longname FROM ps_inv_shpkey_fld s , PSDBFLDLABL l WHERE l.fieldname = s.fieldname AND l.default_label = 1

  • Related Language Record: INV_SHPKEY_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name