RSF_TERRITORYVW

(SQL View)
Index Back

Territory View

CRM Sales - View for Territory.

SELECT TREE_NAME ,TERRITORY_ID ,BUSINESS_UNIT ,MARKET ,ASSIGN_GROUP ,DESCR , BO_ID_PARTNER FROM PS_RSF_TERRITORY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

Prompt Table: RSF_TR_TREE_VW

2 TERRITORY_ID Character(20) VARCHAR2(20) NOT NULL Territory ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: RSF_OPR_DEF_VW.BUSINESS_UNIT

Prompt Table: SP_BU_RSF_NONVW

4 MARKET Character(3) VARCHAR2(3) NOT NULL Market

Default Value: GBL

5 ASSIGN_GROUP Character(30) VARCHAR2(30) NOT NULL This field is used to specify assignment group name for Territory assignment.

Prompt Table: RSF_ASSIGN_GRP
Set Control Field: BUSINESS_UNIT

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 BO_ID_PARTNER Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID of Partner Company.