TREE_NAMEBO_ID_PARTNERTERRITORY_IDLANGUAGE_CDRSF_TR_P_LNG_VW(SQL View) |
Index Back |
|---|---|
Partner Territories LanguageView of all Partner Territories for Language translation. |
| SELECT A.TREE_NAME , A.BO_ID_PARTNER , A.TERRITORY_ID , B.LANGUAGE_CD , B.DESCR FROM %Table(RSF_TERRITORY) A , %Table(RSF_TERR_LNG) B WHERE A.TREE_NAME = B.TREE_NAME AND A.TERRITORY_ID = B.TERRITORY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 2 | BO_ID_PARTNER |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID of Partner Company. |
| 3 | TERRITORY_ID |
Character(20) | VARCHAR2(20) NOT NULL | Territory ID |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |