SP_IDCUST_CLSVW

(SQL View)
 Index Back

SELECT DISTINCT S.OPRCLASS , A.SETID , A.CUST_ID , A.NAMESHORT , A.NAME1 , A.NAME2 , B.ALT_NAME1 , A.CUST_STATUS , C.CR_ANALYST , C.COLLECTOR , A.REMIT_FROM_CUST_ID , A.REMIT_FROM_SETID , A.SHIP_TO_FLG , A.CORPORATE_CUST_ID , A.CORPORATE_SETID , B.CITY , B.STATE , B.POSTAL , B.PHONE FROM PS_CUSTOMER A , PS_CUST_ADDRESS B , PS_CUST_OPTION C , PS_SEC_SETID_CLS S WHERE A.BILL_TO_FLG = 'Y' AND A.CUST_LEVEL <> 'P' AND A.CUST_STATUS IN ('A', 'I') AND A.SETID = B.SETID AND A.SETID = S.SETID AND A.CUST_ID = B.CUST_ID AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_CUST_ADDRESS X WHERE B.SETID = X.SETID AND B.CUST_ID = X.CUST_ID AND B.ADDRESS_SEQ_NUM = X.ADDRESS_SEQ_NUM AND EFFDT <= %CurrentDateIn AND EFF_STATUS = 'A' ) AND A.SETID = C.SETID AND A.CUST_ID = C.CUST_ID AND C.EFFDT = ( SELECT MAX(C2.EFFDT) FROM PS_CUST_OPTION C2 WHERE C2.SETID = C.SETID AND C2.CUST_ID = C.CUST_ID AND C2.EFFDT <= %CurrentDateIn AND C2.EFF_STATUS = 'A')

  • Related Language Record: CUST_SRCH3_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
    4 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name
    5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    6 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    7 ALT_NAME1 Character(40) VARCHAR2(40) NOT NULL Alternate Name 1
    8 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status
    A=Active
    I=Inactive
    T=Template
    9 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.
    10 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.
    11 REMIT_FROM_CUST_ID Character(15) VARCHAR2(15) NOT NULL Remit From Customer
    12 REMIT_FROM_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    13 SHIP_TO_FLG Character(1) VARCHAR2(1) NOT NULL Ship To Customer
    N=No
    Y=Yes
    14 CORPORATE_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer
    15 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    16 CITY Character(30) VARCHAR2(30) NOT NULL City
    17 STATE Character(6) VARCHAR2(6) NOT NULL State
    18 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    19 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone