REGION_CATEGORYGEOG=Geography
NMGT=Number Management
PROD=Product Sales
TERR=Territory Assignment
REGION_IDCTRY=Country
PHON=Phone
POST=Postal Code
PWLN=Postal Code-Wireline
PWLS=Postal Code-Wireless
REGN=Region
SRVC=Service Area
STAT=State
RB_REGIONGEO_VW(SQL View) |
Index Back |
|---|---|
RegionCRM Common Object: Region.............................. |
| SELECT a.REGION_CATEGORY ,a.REGION_ID , a.REGION_TYPE , a.DESCR FROM PS_RB_REGION a WHERE a.STATUS = 'A' AND a.REGION_CATEGORY = 'GEOG' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REGION_CATEGORY |
Character(4) | VARCHAR2(4) NOT NULL |
Region Category
GEOG=Geography NMGT=Number Management PROD=Product Sales TERR=Territory Assignment |
| 2 | REGION_ID |
Character(15) | VARCHAR2(15) NOT NULL | This field stores the region id value. |
| 3 | REGION_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Region Type. e.g., Country, Postal Code, Service Area, State, etc.
CTRY=Country PHON=Phone POST=Postal Code PWLN=Postal Code-Wireline PWLS=Postal Code-Wireless REGN=Region SRVC=Service Area STAT=State |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |