SETIDPrompt Table: SP_SETID_NONVW
TRFT_RULE_CDPrompt Table: TRFT_RULE
TRFT_FEATURE_CD1=Freight & Transportation Lead
2=Backorder Rule Defaulting
3=Supply Sources
SEQ_NUMTRFT_KEY_CDLANGUAGE_CDTRFT_RL_SEQ_LNG(SQL View) |
Index Back |
|---|---|
Trft Rule Sequence |
| SELECT DISTINCT s.setid , s.trft_rule_cd , s.trft_feature_cd , r.seq_num , r.trft_key_cd , s.language_cd , s.descr FROM PS_TRFT_RULECD_LNG s , ps_trft_rule_seq r WHERE s.setid = r.setid AND s.trft_rule_cd = r.trft_rule_cd AND s.trft_feature_cd = r.trft_feature_cd |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | TRFT_RULE_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Arbitration Rule Code.
Prompt Table: TRFT_RULE |
| 3 | TRFT_FEATURE_CD |
Character(1) | VARCHAR2(1) NOT NULL |
Feature Code
1=Freight & Transportation Lead 2=Backorder Rule Defaulting 3=Supply Sources |
| 4 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | TRFT_KEY_CD |
Character(50) | VARCHAR2(50) NOT NULL | Select Key Fields |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |