ROLE_TYPE_ID_CUSTBO_CUST_RFCI_VW(SQL View) |
Index Back |
|---|---|
View for Customer Role Type IDView for Customer Role Type ID(Market = FIN) |
| SELECT ROLE_TYPE_ID , DESCR FROM PS_BO_ROLE_TYPE WHERE ROLE_TYPE_ID IN (2, 9, 30, 31) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROLE_TYPE_ID_CUST |
Number(12,0) | DECIMAL(12) NOT NULL | Stores ROLE_TYPE_ID for the customer |
| 2 | ROLE_NAME | Character(40) | VARCHAR2(40) NOT NULL | Role name |