OMPB_SLDINST_VW

(SQL View)
 Index Back

Sold To Customers - Price Book

Price Book Instance Customers

SELECT C.BUSINESS_UNIT ,C.OMPB_BOOK_DEFN_ID ,C.OMPB_BOOK_ID ,C.OMPB_INSTANCE ,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_OMPB_INSTCST_VW C , PS_CUSTOMER A , PS_CUST_ADDRESS B , PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = C.BUSINESS_UNIT AND S.REC_GROUP_ID = 'FS_23' AND S.RECNAME = 'CUSTOMER' AND S.SETID = A.SETID AND C.SOLD_TO_CUST_ID = A.CUST_ID AND A.SETID = B.SETID AND A.CUST_ID = B.CUST_ID AND %EffdtCheck(CUST_ADDRESS,B,%CurrentDateIn) AND B.EFF_STATUS = 'A'

  • Related Language Record: OMPB_SLDINS_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 OMPB_BOOK_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Customer Price Book Definition ID
    3 OMPB_BOOK_ID Character(30) VARCHAR2(30) NOT NULL Customer Price Book ID
    4 OMPB_INSTANCE Number(10,0) DECIMAL(10) NOT NULL price book instance
    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    6 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.
    7 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    8 ADDRESS_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Address - Sold To
    9 CNTCT_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Contact - Sold To
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    11 CUST_LEVEL Character(1) VARCHAR2(1) NOT NULL Customer Level
    N=New
    P=Prospect
    R=Regular
    S=Short-Term
    T=Temporary
    12 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.
    13 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    14 CITY Character(30) VARCHAR2(30) NOT NULL City
    15 STATE Character(6) VARCHAR2(6) NOT NULL State
    16 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal