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

MKT_IMP_VENDORS

This interface table stores staging data for the marketing vendors. The data gets populated into MKT_TM_VENDORS table. A marketing vendor is a third-party company that performs some defined work items as part of the overall business process e.g campaign fulfilment processes.

Details

  • Schema: FUSION

  • Object owner: MKT

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

MKT_IMP_VENDORS_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 operation to be performed on a row, such as Insert, Update etc. Active
FILE_RECORD_NUM NUMBER 10 File Record Number. Record indicator in the File.
VENDOR_EXT_REF VARCHAR2 30 Vendor Original System Reference. Stored the unique identifier of the vendor in the source system. Used to lookup VENDOR_ID. Maps to MKT_TM_VENDORS.VENDOR_CODE in the Fusion Base table. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
VENDOR_NAME VARCHAR2 240 Vendor Name for this vendor record Active
VENDOR_ADDRESS1 VARCHAR2 240 Vendor Address Line 1 for this vendor record Active
VENDOR_ADDRESS2 VARCHAR2 240 Vendor Address Line 2 for this vendor record Active
VENDOR_ADDRESS3 VARCHAR2 240 Vendor Address Line 3 for this vendor record Active
VENDOR_ADDRESS4 VARCHAR2 240 Vendor Address Line 4 for this vendor record Active
VENDOR_CITY VARCHAR2 60 Vendor City value for this vendor record Active
VENDOR_STATE VARCHAR2 60 Vendor State value for this vendor record Active
VENDOR_POSTAL_CODE VARCHAR2 60 Vendor Postal Code value for this vendor record Active
VENDOR_COUNTRY VARCHAR2 2 Vendor Country value for this vendor record Active
VENDOR_FAX_NUMBER VARCHAR2 60 Vendor Fax Number value for this vendor record Active
CONTACT_NAME VARCHAR2 240 Vendor Contact Name for this vendor record Active
CONTACT_PHONE_NUMBER VARCHAR2 60 Vendor Contact Phone Number for this vendor record Active
CONTACT_EMAIL_ADDRESS VARCHAR2 2000 Vendor Contact Email Address for this vendor record Active
VENDOR_ID NUMBER 18 Fusion ID of Vendor for this vendor record Active
VENDOR_DESC VARCHAR2 1000 Vendor Description for this vendor record Active
DLV_PROF_EXT_REF VARCHAR2 240 Delivery Profile OSR ID for this vendor record. Used to lookup DELV_PROF_ID. Active
DELV_PROF_ID NUMBER 18 Delivery Profile Fusion ID for this vendor record Active
VENDOR_STATUS VARCHAR2 30 Vendor Status for this vendor record Active
ACTIVE_FLAG VARCHAR2 1 Active Flag for Vendor for this vendor 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_VENDORS_PK Unique FUSION_TS_INTERFACE BATCH_ID, INTERFACE_ROW_ID Active