CUST_SSBRKR_VW

(SQL View)
 Index Back

Brokers - OM


SELECT C.OPRID ,A.SETID ,A.CUST_ID ,A.NAME1 ,A.ADDRESS_SEQ_SOLD ,A.CNTCT_SEQ_SOLD ,A.CURRENCY_CD ,A.CUST_LEVEL ,A.CUR_RT_TYPE ,B.PHONE ,B.CITY ,B.STATE ,B.POSTAL FROM ps_customer A , ps_cust_address B , PSOPRALIAS C , ps_contact D WHERE A.setid = B.setid AND A.cust_id = B.cust_id AND %EffdtCheck(cust_address,B,%currentdatein) AND B.eff_status='A' AND A.SHIP_TO_FLG = 'Y' AND A.CUST_STATUS = 'A' AND %Sql(OMSS_VALID_CUST_SQL, C, D, A.SETID, A.CUST_ID, BROKER_FLG)

  • Related Language Record: CUST_SSBRKR_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    3 BROKER_ID Character(15) VARCHAR2(15) NOT NULL Broker ID
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    5 ADDRESS_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Address - Sold To
    6 CNTCT_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Contact - Sold To
    7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    8 CUST_LEVEL Character(1) VARCHAR2(1) NOT NULL Customer Level
    N=New
    P=Prospect
    R=Regular
    S=Short-Term
    T=Temporary
    9 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
    10 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    11 CITY Character(30) VARCHAR2(30) NOT NULL City
    12 STATE Character(6) VARCHAR2(6) NOT NULL State
    13 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal