EOCM_GENTBLC_VW

(SQL View)
 Index Back

Generic Schema

Generic Target Schema

SELECT 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_NM , A.EFF_STATUS , A.EOCM_OFFER_NM , A.EOCM_SUP_CAT_NM , A.EOCM_SUP_CAT_CD , A.EOCM_SUP_OFFER_D , A.URL , %subrec(EOCM_EPRO_SBR, A) , %subrec(EOCM_ELM_SBR, A) , %subrec(EOCM_CRM_SBR, A) , %subrec(EOCM_PROP_SBR, A) , A.EOCM_OFFER_STATUS , A.EOCM_OFFER_STATE , A.MESSAGE_NBR FROM PS_EOCM_GEN_TBL A

  • 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_NM Character(64) VARCHAR2(64) NOT NULL Supplier Offering Name
    9 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    10 EOCM_OFFER_NM Character(64) VARCHAR2(64) NOT NULL Offer Name
    11 EOCM_SUP_CAT_NM Character(254) VARCHAR2(254) NOT NULL Supplier Category Name
    12 EOCM_SUP_CAT_CD Character(32) VARCHAR2(32) NOT NULL Supplier Category Code
    13 EOCM_SUP_OFFER_D Character(64) VARCHAR2(64) NOT NULL Supplier Offering Description
    14 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    15 EOCM_MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Part ID
    16 EOCM_MFG_PART_NUM Character(50) VARCHAR2(50) NOT NULL Manufacturer Part Number
    17 EOCM_CONVERSION_RT Signed Number(17,8) DECIMAL(15,8) NOT NULL ePro field
    18 EOCM_DISCONTINU_DT Date(10) DATE Distcontinue Date for epro
    19 EOCM_MIN_QTY Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity epro
    20 EOCM_LEAD_TIME Number(11,0) DECIMAL(11) NOT NULL Lead Time epro
    21 EOCM_ITMVPRIORITY Number(3,0) SMALLINT NOT NULL epro item vendor priority
    22 EOCM_EPRO_DESCR Character(254) VARCHAR2(254) NOT NULL epro specific field
    23 EOCM_VNDR_PART_NUM Character(50) VARCHAR2(50) NOT NULL Epro specific field
    24 EOCM_VNDR_PART_EXT Character(50) VARCHAR2(50) NOT NULL epro specific field
    25 EOCM_ELM_CEU Number(3,0) SMALLINT NOT NULL Continuing Education Units
    26 EOCM_ELM_KEYWORDS Character(30) VARCHAR2(30) NOT NULL ELM keywords
    27 EOCM_LEARN_OBJ_ID Number(10,0) DECIMAL(10) NOT NULL ELM Learning Objectives ID
    28 EOCM_REQUISITE_ID Number(10,0) DECIMAL(10) NOT NULL ELM Requisite ID
    29 EOCM_ELM_NOTES Character(80) VARCHAR2(80) NOT NULL ELM Notes
    30 EOCM_MODEL_NBR Character(18) VARCHAR2(18) NOT NULL CRM specific field
    31 EOCM_CRM_CAT_NBR Character(18) VARCHAR2(18) NOT NULL CRM specific field
    32 EOCM_PROD_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL CRM specific field

    Y/N Table Edit

    33 EOCM_CRM_SERVICE Character(1) VARCHAR2(1) NOT NULL CRM specific field

    Y/N Table Edit

    34 EOCM_PROD_BRAND Character(15) VARCHAR2(15) NOT NULL CRM specific field
    35 EOCM_CRM_ORDERABLE Character(1) VARCHAR2(1) NOT NULL CRM specific field

    Y/N Table Edit

    36 EOCM_PROP_NAME_1 Character(32) VARCHAR2(32) NOT NULL Property 1 Name
    37 EOCM_PROP_VAL_1 Character(64) VARCHAR2(64) NOT NULL Property 1 Value
    38 EOCM_PROP_NAME_2 Character(32) VARCHAR2(32) NOT NULL Property 2 Name
    39 EOCM_PROP_VAL_2 Character(64) VARCHAR2(64) NOT NULL Property Value 2
    40 EOCM_PROP_NAME_3 Character(32) VARCHAR2(32) NOT NULL Property 3 Name
    41 EOCM_PROP_VAL_3 Character(64) VARCHAR2(64) NOT NULL Property 3 Value
    42 EOCM_PROP_NAME_4 Character(32) VARCHAR2(32) NOT NULL Property Name 4
    43 EOCM_PROP_VAL_4 Character(64) VARCHAR2(64) NOT NULL Property 4 Value
    44 EOCM_PROP_NAME_5 Character(32) VARCHAR2(32) NOT NULL Property 5 Name
    45 EOCM_PROP_VAL_5 Character(64) VARCHAR2(64) NOT NULL Property 5 Value
    46 EOCM_OFFER_STATUS Character(1) VARCHAR2(1) NOT NULL Offering Status
    C=Categorized
    E=Error
    L=Loaded
    N=Rejected
    S=Staged
    47 EOCM_OFFER_STATE Character(1) VARCHAR2(1) NOT NULL State of the suppl product
    A=New/Unapproved
    C=Unchanged
    D=Deleted
    E=Error
    N=New
    U=Updated
    48 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.