REL_TYPE_IDN=No
Y=Yes
RD_ACCT_REL_VW(SQL View) |
Index Back |
|---|---|
Account Rep Rel Owner ViewView to find whether a relationship for account representative is primary ror not. |
| SELECT REL_TYPE_ID , CASE WHEN BO_REL_CATEGORY_ID = 19 THEN 'Y' ELSE 'N' END FROM %Table(BO_REL_CAT_ITEM) WHERE BO_REL_CATEGORY_ID IN (19, 20) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REL_TYPE_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Relationship Type ID |
| 2 | ACCT_OWNER | Character(1) | VARCHAR2(1) NOT NULL |
Account Team Owners....................
N=No Y=Yes |