TRFT_KEY_FLD_VW

(SQL View)
 Index Back

Freight Key fields

Date Init. Issue # Description 02/07/01 JJM R-ED.WON-3S567 Added Related Language Record

SELECT p.fieldname , p.seq_num , p.trft_feature_cd , p.trft_key_fld_cd , f.length , L.longname FROM psdbfldlabl l , PSDBFIELD f , ps_trft_key_field p WHERE f.fieldname = p.fieldname AND l.fieldname = f.fieldname AND l.default_label = 1

  • Related Language Record: TRFT_KYFLDV_LNG

    • # 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 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 1

    3 TRFT_FEATURE_CD Character(1) VARCHAR2(1) NOT NULL Feature Code
    1=Freight & Transportation Lead
    2=Backorder Rule Defaulting
    3=Supply Sources
    4 TRFT_KEY_FLD_CD Character(2) VARCHAR2(2) NOT NULL Trft Key field code
    5 LENGTH Number(5,0) INTEGER NOT NULL Length
    6 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name