SETIDCUST_IDCUST_PRC_SHP_VW(SQL View) |
Index Back |
|---|---|
Ship-To Customers - OM Pricing |
| SELECT DISTINCT C.SETID , C.CUST_ID , A.CITY , C.NAME1 , B.CR_ANALYST , B.COLLECTOR , A.STATE FROM PS_CUSTOMER C , PS_CUST_OPTION B , PS_CUST_ADDRESS A WHERE C.CUST_STATUS = 'A' AND C.SHIP_TO_FLG = 'Y' AND C.setid = B.setid AND C.cust_id = B.cust_id AND B.effdt = ( SELECT MAX(B2.effdt) FROM ps_cust_option B2 WHERE B2.setid = B.setid AND B2.cust_id = B.cust_id AND B2.effdt <= %CurrentDateIn AND B2.eff_status = 'A') AND C.SETID = A.SETID AND C.CUST_ID = A.CUST_ID AND A.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_CUST_ADDRESS X WHERE X.SETID = A.SETID AND X.CUST_ID = A.CUST_ID AND X.ADDRESS_SEQ_NUM = A.ADDRESS_SEQ_NUM AND X.EFFDT <= %CurrentDateIn AND X.EFF_STATUS = 'A') |
| # | 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. |
| 2 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 3 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 4 | NAME1 | Character(50) | VARCHAR2(50) NOT NULL | Generic 50 character name field for storing names. |
| 5 | CR_ANALYST | Character(8) | VARCHAR2(8) NOT NULL | Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer. |
| 6 | COLLECTOR | Character(8) | VARCHAR2(8) NOT NULL | Specifies the personnel code for the person who works with a customer to collect overdue payments. |
| 7 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |