WS_PROFILE_VW

(SQL View)
Index Back

Customer Profile

This record is used in capturing all the contact/customer profile.

SELECT CST.CUSTOMER_SETID , CST.CUST_ID , CNT.SETID , CNT.CONTACT_ID , CST.CNTCT_SEQ_NUM , CST.ADDRESS_SEQ_NUM , CNT.CONTACT_FLAG , CNT.COMM_METHOD , 'N' , CNT.TITLE , CNT.CREATE_CUSTOMER , CST.ALL_ORDERS_FLG , CST.SOLD_TO_FLG , CST.BILL_TO_FLG , CUST.BILL_TO_FLG , CUST.SHIP_TO_FLG , CST.BROKER_FLG , CST.ADDRESS_MAINT , CST.ORDER_SAVE , CUST.CURRENCY_CD , CUST.CUST_STATUS , CNT.EMAILID , CNT.LANGUAGE_PREF , CNT.NAME1 , CUST.NAME1 , CUST.NAMESHORT , 'N' , ' ' , ' ' , ' ' FROM PS_CONTACT CNT , PS_CONTACT_CUST CST , PS_CUSTOMER CUST WHERE %EffdtCheck(CONTACT,CNT,%CurrentDateIn) AND CNT.EFF_STATUS='A' AND CST.SETID=CNT.SETID AND CST.CONTACT_ID=CNT.CONTACT_ID AND CST.EFFDT=CNT.EFFDT AND CST.CUSTOMER_SETID=CUST.SETID AND CST.CUST_ID=CUST.CUST_ID AND CST.EFF_STATUS='A' AND CUST.CUST_STATUS = 'A'

  • Related Language Record: WS_PROFILE_VLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    4 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
    5 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
    6 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: CUST_ADDR_EF_VW

    7 CONTACT_FLAG Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person.
    E=External Contact
    I=Internal Contact
    8 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL Preferred Communication
    A=Email Invoice as Attachment
    C=Call
    E=Email only
    F=Fax
    I=XML only
    M=Standard Mail
    N=Email Notification
    P=Email & Print
    R=XML & Print
    9 EB Character(1) VARCHAR2(1) NOT NULL eBill Payment
    10 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    11 CREATE_CUSTOMER Character(1) VARCHAR2(1) NOT NULL Create New Customer/Contact
    12 ALL_ORDERS_FLG Character(1) VARCHAR2(1) NOT NULL All Orders Flag
    N=No
    Y=Yes
    13 SOLD_TO_FLG Character(1) VARCHAR2(1) NOT NULL Sold To Customer
    14 BILL_TO Character(1) VARCHAR2(1) NOT NULL Bill To
    C=Company
    E=Employee
    15 BILL_TO_FLG Character(1) VARCHAR2(1) NOT NULL Bill To Customer
    N=No
    Y=Yes
    16 SHIP_TO_FLG Character(1) VARCHAR2(1) NOT NULL Ship To Customer
    N=No
    Y=Yes
    17 BROKER_FLG Character(1) VARCHAR2(1) NOT NULL Broker Customer
    18 ADDRESS_MAINT Character(1) VARCHAR2(1) NOT NULL Maintain Addresses
    19 ORDER_SAVE Character(1) VARCHAR2(1) NOT NULL Order Save
    20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    21 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status
    A=Active
    I=Inactive
    T=Template
    22 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    23 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    24 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    25 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name
    26 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name
    27 WS Character(1) VARCHAR2(1) NOT NULL eStore

    Y/N Table Edit

    Default Value: N

    28 WS_HOME_PHONE Character(24) VARCHAR2(24) NOT NULL Home Telephone Number
    29 WS_WORK_PHONE Character(24) VARCHAR2(24) NOT NULL Work Telephone Number
    30 WS_WORK_EXT Character(6) VARCHAR2(6) NOT NULL Phone Extension