EOCM_GEN_TBL

(SQL Table)
 Index Back

Generic Schema

Generic Target Schema

  • 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_ROW_ID Number(10,0) DECIMAL(10) NOT NULL Row ID
    6 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    8 EOCM_OFFER_ID Character(32) VARCHAR2(32) NOT NULL Offering ID
    9 EOCM_OFFER_NM Character(64) VARCHAR2(64) NOT NULL Offer Name
    10 EOCM_SUP_OFFER_NM Character(64) VARCHAR2(64) NOT NULL Supplier Offering Name
    11 EOCM_SUP_OFFER_SKU Character(50) VARCHAR2(50) NOT NULL Supplier Offering SKU
    12 EOCM_SUP_OFFER_UOM Character(32) VARCHAR2(32) NOT NULL Supplier Offering UOM
    13 EOCM_SUP_CAT_NM Character(254) VARCHAR2(254) NOT NULL Supplier Category Name
    14 EOCM_SUP_CAT_CD Character(32) VARCHAR2(32) NOT NULL Supplier Category Code
    15 EOCM_SUP_OFFER_PR Number(16,5) DECIMAL(15,5) NOT NULL Supplier Offering Price
    16 EOCM_SUP_OFFER_D Character(64) VARCHAR2(64) NOT NULL Supplier Offering Description
    17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    18 EOCM_EPRO_FILENAME Character(80) VARCHAR2(80) NOT NULL Epro file name
    19 EOCM_FILEEXTENSION Character(3) VARCHAR2(3) NOT NULL Epro File Extension
    20 EOCM_FILEPATH Character(30) VARCHAR2(30) NOT NULL Epro File path
    21 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    22 EOCM_MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Part ID
    23 EOCM_MFG_PART_NUM Character(50) VARCHAR2(50) NOT NULL Manufacturer Part Number
    24 EOCM_CONVERSION_RT Signed Number(17,8) DECIMAL(15,8) NOT NULL ePro field
    25 EOCM_DISCONTINU_DT Date(10) DATE Distcontinue Date for epro
    26 EOCM_MIN_QTY Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity epro
    27 EOCM_LEAD_TIME Number(11,0) DECIMAL(11) NOT NULL Lead Time epro
    28 EOCM_ITMVPRIORITY Number(3,0) SMALLINT NOT NULL epro item vendor priority
    29 EOCM_EPRO_DESCR Character(254) VARCHAR2(254) NOT NULL epro specific field
    30 EOCM_VNDR_PART_NUM Character(50) VARCHAR2(50) NOT NULL Epro specific field
    31 EOCM_VNDR_PART_EXT Character(50) VARCHAR2(50) NOT NULL epro specific field
    32 EOCM_ELM_CEU Number(3,0) SMALLINT NOT NULL Continuing Education Units
    33 EOCM_ELM_KEYWORDS Character(30) VARCHAR2(30) NOT NULL ELM keywords
    34 EOCM_LEARN_OBJ_ID Number(10,0) DECIMAL(10) NOT NULL ELM Learning Objectives ID
    35 EOCM_REQUISITE_ID Number(10,0) DECIMAL(10) NOT NULL ELM Requisite ID
    36 EOCM_ELM_NOTES Character(80) VARCHAR2(80) NOT NULL ELM Notes
    37 EOCM_MODEL_NBR Character(18) VARCHAR2(18) NOT NULL CRM specific field
    38 EOCM_CRM_CAT_NBR Character(18) VARCHAR2(18) NOT NULL CRM specific field
    39 EOCM_PROD_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL CRM specific field

    Y/N Table Edit

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

    Y/N Table Edit

    41 EOCM_PROD_BRAND Character(15) VARCHAR2(15) NOT NULL CRM specific field
    42 EOCM_CRM_ORDERABLE Character(1) VARCHAR2(1) NOT NULL CRM specific field

    Y/N Table Edit

    43 EOCM_PROP_NAME_1 Character(32) VARCHAR2(32) NOT NULL Property 1 Name
    44 EOCM_PROP_VAL_1 Character(64) VARCHAR2(64) NOT NULL Property 1 Value
    45 EOCM_PROP_NAME_2 Character(32) VARCHAR2(32) NOT NULL Property 2 Name
    46 EOCM_PROP_VAL_2 Character(64) VARCHAR2(64) NOT NULL Property Value 2
    47 EOCM_PROP_NAME_3 Character(32) VARCHAR2(32) NOT NULL Property 3 Name
    48 EOCM_PROP_VAL_3 Character(64) VARCHAR2(64) NOT NULL Property 3 Value
    49 EOCM_PROP_NAME_4 Character(32) VARCHAR2(32) NOT NULL Property Name 4
    50 EOCM_PROP_VAL_4 Character(64) VARCHAR2(64) NOT NULL Property 4 Value
    51 EOCM_PROP_NAME_5 Character(32) VARCHAR2(32) NOT NULL Property 5 Name
    52 EOCM_PROP_VAL_5 Character(64) VARCHAR2(64) NOT NULL Property 5 Value
    53 EOCM_OFFER_STATUS Character(1) VARCHAR2(1) NOT NULL Offering Status
    C=Categorized
    E=Error
    L=Loaded
    N=Rejected
    S=Staged
    54 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
    55 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    56 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    57 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.