SETIDPrompt Table: SP_SETID_NONVW
SHIP_TO_CUST_IDCUSTOMER_GROUPEFFDTA=Active
I=Inactive
CUST_TAXGPSH_VW(SQL View) |
Index Back |
|---|---|
Cust-Tax grp link view |
| SELECT cln.setid , cln.cust_id , cln.customer_group , c1.effdt , c1.eff_status , cln.default_tax_grp 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' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | SHIP_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 3 | CUSTOMER_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Customer Group |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | DEFAULT_TAX_GRP | Character(1) | VARCHAR2(1) NOT NULL | Default Tax Group |