AR_CUST_ALL_VW

(SQL View)
 Index Back

AR All Customers

Active or Inactive Status Customers

SELECT DISTINCT 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 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.CUST_ID = B.CUST_ID AND ( %EffdtCheck(cust_address,B,%currentdatein) AND B.EFF_STATUS = 'A') AND A.SETID = C.SETID AND A.CUST_ID = C.CUST_ID AND ( %EffdtCheck(cust_option,C,%currentdatein) AND C.EFF_STATUS = 'A')

  • Related Language Record: AR_CUST_ALL_VLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_INQ Character(5) VARCHAR2(5) NOT NULL SetID
    2 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.
    3 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    5 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
    6 ALT_NAME1 Character(40) VARCHAR2(40) NOT NULL Alternate Name 1
    7 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status
    A=Active
    I=Inactive
    T=Template
    8 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.
    9 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.
    10 REMIT_FROM_CUST_ID Character(15) VARCHAR2(15) NOT NULL Remit From Customer
    11 REMIT_FROM_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    12 SHIP_TO_FLG Character(1) VARCHAR2(1) NOT NULL Ship To Customer
    N=No
    Y=Yes
    13 CORPORATE_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer
    14 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    15 CITY Character(30) VARCHAR2(30) NOT NULL City
    16 STATE Character(6) VARCHAR2(6) NOT NULL State
    17 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    18 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone