SETIDTRFT_KEY_CDTRFT_FEATURE_CD1=Freight & Transportation Lead
2=Backorder Rule Defaulting
3=Supply Sources
FIELDNAMEPrompt Table: TRFT_KEY_FIELD
TRFT_KEY_SET_VW(SQL View) |
Index Back |
|---|---|
Freight Key Unit |
| SELECT k.setid , k.trft_key_cd , k.trft_feature_cd , k.fieldname , f.length , l.longname , kf.seq_num , kf.trft_key_fld_cd FROM psdbfldlabl l , PSDBFIELD f , ps_trft_key_field kf , ps_trft_key_set k WHERE f.fieldname = k.fieldname AND kf.fieldname = k.fieldname AND kf.trft_feature_cd = k.trft_feature_cd AND l.fieldname = f.fieldname AND l.default_label = 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | TRFT_KEY_CD |
Character(50) | VARCHAR2(50) NOT NULL | Select Key Fields |
| 3 | TRFT_FEATURE_CD |
Character(1) | VARCHAR2(1) NOT NULL |
Feature Code
1=Freight & Transportation Lead 2=Backorder Rule Defaulting 3=Supply Sources |
| 4 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: TRFT_KEY_FIELD |
| 5 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
| 6 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |
| 7 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 8 | TRFT_KEY_FLD_CD | Character(2) | VARCHAR2(2) NOT NULL | Trft Key field code |