RSF_SITECRIT_VW

(SQL View)
Index Back

Sales Site Criteria

Sales site criteria prompt record for configurable assignment.

SELECT A.BO_ID , A.SETID , B.BO_NAME FROM PS_RD_SITE A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
2 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Default Value: OPR_DEF_TBL_RB.SETID

Prompt Table: SP_SETID_NONVW

3 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object