SETIDCUSTOMER_GROUPCUST_BITAXGP_VW(SQL View) |
Index Back |
|---|---|
Tax grouptax group view |
| SELECT DISTINCT cln.setid , cln.customer_group FROM ps_set_cntrl_rec sc , ps_cust_group_tbl c1 , PS_CUST_CGRP_LNK cln WHERE sc.setcntrlvalue = cln.setid AND sc.recname = 'CUSTGP_TAX_VW' AND c1.setid = sc.setid AND c1.customer_group = cln.customer_group AND c1.customer_group = cln.customer_group AND c1.cust_grp_type = 'TAX' AND cln.cust_grp_type = 'TAX' AND c1.EFF_STATUS = 'A' AND %EffdtCheck(cust_group_tbl, c1, %currentdatein) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CUSTOMER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Customer Group |