SETIDPrompt Table: SP_SETID_NONVW
SHIP_TO_CUST_IDCUSTOMER_GROUPEFFDTA=Active
I=Inactive
CUST_TAXGPDF_VW(SQL View) |
Index Back |
|---|---|
Cust-Tax grp link viewDate Initials Issue Description 012501 dms SP2 (DI-EDWONG-2) Deferred processing 022802 dms 8.4 performance Changed view text |
| SELECT cgrp.setid , cgrp.cust_id , cgrp.customer_group , cg.effdt , cg.eff_status FROM ps_set_cntrl_rec sc , ps_cust_group_tbl cg , PS_CUST_CGRP_LNK cgrp WHERE sc.setcntrlvalue = cg.setid AND sc.recname = 'CUSTGP_TAX_VW' AND cg.cust_grp_type = 'TAX' AND cgrp.setid = cg.setid AND cgrp.customer_group = cg.customer_group AND cgrp.cust_grp_type = cg.cust_grp_type AND cgrp.default_tax_grp = 'Y' |
| # | 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 |