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_CDTRFT_RL_SEQ_VW(SQL View) |
Index Back |
|---|---|
Trft Rule Sequence |
| SELECT DISTINCT s.setid , s.trft_rule_cd , s.trft_feature_cd , s.seq_num , s.trft_key_cd , r.descr FROM PS_TRFT_RULE_SEQ s , ps_trft_rule 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |