TRFT_R_AN_SRCH

(SQL View)
Index Back

Trft Rule AutoNum Add Srch


SELECT a.setid , a.trft_rule_cd , a.trft_feature_cd FROM PS_TRFT_RULE a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 TRFT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Arbitration Rule Code.

Default Value: NEXT

3 TRFT_FEATURE_CD Character(1) VARCHAR2(1) NOT NULL Feature Code
1=Freight & Transportation Lead
2=Backorder Rule Defaulting
3=Supply Sources