SETIDPrompt Table: SP_SETID_NONVW
CUSTOMER_GROUPLANGUAGE_CDRO_PK_CSTGP_LVW(SQL View) |
Index Back |
|---|---|
Customer Group viewView for determining which Pricing Customer Group the customer belongs. |
| SELECT x.setid , x.customer_group , x.LANGUAGE_CD , x.descr FROM PS_CUST_GROUP_LNG x WHERE cust_grp_type = 'PRC' AND effdt = ( SELECT MAX(y.effdt) FROM ps_cust_group_tbl y WHERE y.setid = x.setid AND y.customer_group = x.customer_group AND y.CUST_GRP_TYPE = x.CUST_GRP_TYPE AND y.effdt <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW |
| 2 | CUSTOMER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Customer Group |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EOEP_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |