EOCM_GNTB_P_VW

(SQL View)
 Index Back

Generic Schema

Generic Target Schema

SELECT DISTINCT A.SETID , A.EOCM_CATALOG_ID , A.EOCM_ACCESS_ID , A.EOCM_TP_VER_ID , A.EOCM_OFFER_ID , A.EOCM_SUP_OFFER_SKU , A.EFFDT , A.EOCM_SUP_OFFER_UOM , A.EOCM_SUP_OFFER_PR , A.CURRENCY_CD FROM PS_EOCM_GEN_TBL A WHERE A.EOCM_SUP_OFFER_UOM <> ' '

  • Parent record: EOCM_CATALOG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID
    3 EOCM_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID

    Prompt Table: EOCM_TRDPARTNER

    4 EOCM_TP_VER_ID Number(3,0) SMALLINT NOT NULL trading partner version id

    Prompt Table: EOCM_TP_VER

    5 EOCM_OFFER_ID Character(32) VARCHAR2(32) NOT NULL Offering ID

    Prompt Table: EOCM_OFFER_TBL

    6 EOCM_SUP_OFFER_SKU Character(50) VARCHAR2(50) NOT NULL Supplier Offering SKU
    7 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    8 EOCM_SUP_OFFER_UOM Character(32) VARCHAR2(32) NOT NULL Supplier Offering UOM
    9 EOCM_SUP_OFFER_PR Number(16,5) DECIMAL(15,5) NOT NULL Supplier Offering Price
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code