1. Tables and Views for Sales and Fusion Service
  2. MKT_IMP_VENDOR_PROFILES

MKT_IMP_VENDOR_PROFILES

This interface table stores staging data for the marketing vendor's delivery profile and the parameters for that delivery profile. The data gets populated into MKT_TM_DLV_PROFILE and MKT_TM_DLV_PRF_PARAMS tables.

Details

  • Schema: FUSION

  • Object owner: MKT

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

MKT_IMP_VENDOR_PROFILES_PK

BATCH_ID, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments Status
BATCH_ID NUMBER 18 Yes Primary Key - Batch Identifier. Identifier that groups records into a batch Active
INTERFACE_ROW_ID NUMBER 18 Yes Primary Key - Interface Row ID. Used to link this record with the error record. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
IMPORT_STATUS_CODE VARCHAR2 30 Indicates the status of the record being processed. Active
ACTION_CODE VARCHAR2 30 Indicates the Insert or Update Action that was performed for the record Active
FILE_RECORD_NUM NUMBER 10 File Record Number. Record indicator in the File.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
VENDOR_EXT_REF VARCHAR2 30 Vendor Original System Reference for this vendor profile record. Used to lookup VENDOR_ID. Active
VENDOR_DLV_PROF_EXT_REF VARCHAR2 64 Vendor Delivery Profile OSR Id for this vendor profile record. Used to lookup DELV_PROFILE_ID. Maps to MKT_TM_DLV_PROFILE.DELV_PROFILE_NUMBER column in the Fusion Base table. Active
VENDOR_ID NUMBER 18 Fusion Id of Vendor for this vendor profile record Active
DELV_PROFILE_ID NUMBER 18 Fusion Id of Vendor Delivery Profile Active
PARAM_ID NUMBER 18 Fusion Id of Vendor Delivery Profile Param Active
CHANNEL_TYPE VARCHAR2 30 Channel Type for the delivery profile Active
SUPPORTED_CHANNEL_TYPE VARCHAR2 30 Treatment channel used for supported channel type Active
BATCH_SIZE NUMBER 18 Vendor Profile Batch Size for this vendor profile record Active
START_DT DATE Start Date for this vendor profile record Active
END_DT DATE End Date for this vendor profile record Active
CAPACITY_QTY NUMBER Capacity Quantity for this vendor profile record Active
CAPACITY_REPT_FREQ NUMBER 18 Capacity Repeat Frequency for this vendor profile record Active
CAPACITY_REPT_UNIT_CD VARCHAR2 30 Capacitry Repeat Unit for this vendor profile record Active
PROFILE_NAME VARCHAR2 250 Vendor Profile Name for this vendor profile record Active
DLV_PROFILE_STATUS VARCHAR2 30 Delivery Profile Status for this vendor profile record Active
ACTIVE_FLAG VARCHAR2 1 Vendor Profile Active Flag for this vendor profile record Active
DLV_DESC_TEXT VARCHAR2 1000 Delivery Profile Description for this vendor profile record Active
PARAM_NAME VARCHAR2 250 Parameter Name for this vendor profile record Active
PARAM_VALUE VARCHAR2 250 Parameter Value for this vendor profile record Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active

Indexes

Index Uniqueness Tablespace Columns Status
MKT_IMP_VENDOR_PROFILES_FK2 Non Unique FUSION_TS_INTERFACE VENDOR_EXT_REF Active
MKT_IMP_VENDOR_PROFILES_PK Unique FUSION_TS_INTERFACE BATCH_ID, INTERFACE_ROW_ID Active