EOCM_EPRORP_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 EOCM_REPORT_ID Character(32) VARCHAR2(32) NOT NULL Report ID
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID
    4 EOCM_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID

    Prompt Table: EOCM_TRDPARTNER

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

    Prompt Table: EOCM_TP_VER

    6 EOCM_ROW_ID Number(10,0) DECIMAL(10) NOT NULL Row ID
    7 EOCM_SUP_OFFER_NM Character(64) VARCHAR2(64) NOT NULL Supplier Offering Name
    8 EOCM_SUP_OFFER_SKU Character(50) VARCHAR2(50) NOT NULL Supplier Offering SKU
    9 EOCM_SUP_OFFER_UOM Character(32) VARCHAR2(32) NOT NULL Supplier Offering UOM
    10 EOCM_SUP_CAT_NM Character(254) VARCHAR2(254) NOT NULL Supplier Category Name
    11 EOCM_SUP_CAT_CD Character(32) VARCHAR2(32) NOT NULL Supplier Category Code
    12 EOCM_SUP_OFFER_PR Number(16,5) DECIMAL(15,5) NOT NULL Supplier Offering Price
    13 EOCM_SUP_OFFER_D Character(64) VARCHAR2(64) NOT NULL Supplier Offering Description
    14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    15 EOCM_OFFER_ID Character(32) VARCHAR2(32) NOT NULL Offering ID
    16 EOCM_OFFER_NM Character(64) VARCHAR2(64) NOT NULL Offer Name
    17 EOCM_EPRO_FILENAME Character(80) VARCHAR2(80) NOT NULL Epro file name
    18 EOCM_FILEEXTENSION Character(3) VARCHAR2(3) NOT NULL Epro File Extension
    19 EOCM_FILEPATH Character(30) VARCHAR2(30) NOT NULL Epro File path
    20 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
    21 EOCM_SUP_OFFER_NM1 Character(64) VARCHAR2(64) NOT NULL Supplier Offering Name
    22 EOCM_SUP_OFF_SKU1 Character(32) VARCHAR2(32) NOT NULL Supplier Offering SKU
    23 EOCM_SUP_OFF_UOM1 Character(32) VARCHAR2(32) NOT NULL Supplier Offering UOM
    24 EOCM_SUP_CAT_NM1 Character(254) VARCHAR2(254) NOT NULL Supplier Category Name
    25 EOCM_SUP_CAT_CD1 Character(32) VARCHAR2(32) NOT NULL Supplier Category Code
    26 EOCM_SUP_OFFER_PR1 Number(16,5) DECIMAL(15,5) NOT NULL Supplier Offering Price
    27 EOCM_SUP_OFFER_D1 Character(64) VARCHAR2(64) NOT NULL Supplier Offering Description
    28 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code
    29 EOCM_OFFER_ID1 Character(32) VARCHAR2(32) NOT NULL Offering ID
    30 EOCM_OFFER_NM1 Character(64) VARCHAR2(64) NOT NULL Offer Name
    31 EOCM_EPRO_FILENAM1 Character(80) VARCHAR2(80) NOT NULL Epro file name
    32 EOCM_FILEEXTENSN1 Character(3) VARCHAR2(3) NOT NULL Epro File Extension
    33 EOCM_FILEPATH1 Character(30) VARCHAR2(30) NOT NULL Epro File path
    34 URL_1 Character(254) VARCHAR2(254) NOT NULL URL #1
    35 EOCM_MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Part ID
    36 EOCM_MFG_PART_NUM Character(50) VARCHAR2(50) NOT NULL Manufacturer Part Number
    37 EOCM_CONVERSION_RT Signed Number(17,8) DECIMAL(15,8) NOT NULL ePro field
    38 EOCM_DISCONTINU_DT Date(10) DATE Distcontinue Date for epro
    39 EOCM_MIN_QTY Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity epro
    40 EOCM_LEAD_TIME Number(11,0) DECIMAL(11) NOT NULL Lead Time epro
    41 EOCM_ITMVPRIORITY Number(3,0) SMALLINT NOT NULL epro item vendor priority
    42 EOCM_EPRO_DESCR Character(254) VARCHAR2(254) NOT NULL epro specific field
    43 EOCM_VNDR_PART_NUM Character(50) VARCHAR2(50) NOT NULL Epro specific field
    44 EOCM_VNDR_PART_EXT Character(50) VARCHAR2(50) NOT NULL epro specific field
    45 EOCM_MFG_ID1 Character(50) VARCHAR2(50) NOT NULL Manufacturer's Part ID
    46 EOCM_MFG_PART_NUM1 Character(50) VARCHAR2(50) NOT NULL Manufacturer Part Number
    47 EOCM_CONVERSIONRT1 Signed Number(17,8) DECIMAL(15,8) NOT NULL ePro field
    48 EOCM_DISCONTINUDT1 Date(10) DATE Distcontinue Date for epro
    49 EOCM_MIN_QTY1 Number(11,0) DECIMAL(11) NOT NULL Minimum Quantity epro
    50 EOCM_LEAD_TIME1 Number(11,0) DECIMAL(11) NOT NULL Lead Time epro
    51 EOCM_ITMVPRIORITY1 Number(3,0) SMALLINT NOT NULL epro item vendor priority
    52 EOCM_EPRO_DESCR1 Character(254) VARCHAR2(254) NOT NULL epro specific field
    53 EOCM_VNDR_PARTNUM1 Character(50) VARCHAR2(50) NOT NULL Epro specific field
    54 EOCM_VNDR_PARTEXT1 Character(50) VARCHAR2(50) NOT NULL epro specific field
    55 EOCM_PROP_NAME_1 Character(32) VARCHAR2(32) NOT NULL Property 1 Name
    56 EOCM_PROP_VAL_1 Character(64) VARCHAR2(64) NOT NULL Property 1 Value
    57 EOCM_PROP_NAME_2 Character(32) VARCHAR2(32) NOT NULL Property 2 Name
    58 EOCM_PROP_VAL_2 Character(64) VARCHAR2(64) NOT NULL Property Value 2
    59 EOCM_PROP_NAME_3 Character(32) VARCHAR2(32) NOT NULL Property 3 Name
    60 EOCM_PROP_VAL_3 Character(64) VARCHAR2(64) NOT NULL Property 3 Value
    61 EOCM_PROP_NAME_4 Character(32) VARCHAR2(32) NOT NULL Property Name 4
    62 EOCM_PROP_VAL_4 Character(64) VARCHAR2(64) NOT NULL Property 4 Value
    63 EOCM_PROP_NAME_5 Character(32) VARCHAR2(32) NOT NULL Property 5 Name
    64 EOCM_PROP_VAL_5 Character(64) VARCHAR2(64) NOT NULL Property 5 Value
    65 EOCM_PROP_NAME_11 Character(32) VARCHAR2(32) NOT NULL Property 1 Name
    66 EOCM_PROP_VAL_11 Character(64) VARCHAR2(64) NOT NULL Property 1 Value
    67 EOCM_PROP_NAME_21 Character(32) VARCHAR2(32) NOT NULL Property 2 Name
    68 EOCM_PROP_VAL_21 Character(64) VARCHAR2(64) NOT NULL Property Value 2
    69 EOCM_PROP_NAME_31 Character(32) VARCHAR2(32) NOT NULL Property 3 Name
    70 EOCM_PROP_VAL_31 Character(64) VARCHAR2(64) NOT NULL Property 3 Value
    71 EOCM_PROP_NAME_41 Character(32) VARCHAR2(32) NOT NULL Property Name 4
    72 EOCM_PROP_VAL_41 Character(64) VARCHAR2(64) NOT NULL Property 4 Value
    73 EOCM_PROP_NAME_51 Character(32) VARCHAR2(32) NOT NULL Property 5 Name
    74 EOCM_PROP_VAL_51 Character(64) VARCHAR2(64) NOT NULL Property 5 Value