[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AS_IMPORT_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | OSM |
| FND Design Data: |  AS.AS_IMPORT_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
This interface table holds lead, customer, address,and contact information for lead import. It holds up to 5 lead product interests.
Scope: public
Lifecycle: active
Display Name: Lead Import Interface Table
Product: AMS
Category: BUSINESS_ENTITY AMS_LEAD
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AS_IMPORT_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 IMPORT_INTERFACE_ID
|
| AS_IMPORT_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SOURCE_SYSTEM
PROGRAM_UPDATE_DATE
LOAD_STATUS
|
| AS_IMPORT_INTERFACE_N10 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PROMOTION_CODE
|
| AS_IMPORT_INTERFACE_N11 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SALES_LEAD_ID
|
| AS_IMPORT_INTERFACE_N12 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PROGRAM_UPDATE_DATE
LOAD_STATUS
|
| AS_IMPORT_INTERFACE_N13 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
LAST_UPDATE_DATE
|
| AS_IMPORT_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
BATCH_ID
SOURCE_SYSTEM
CREATION_DATE
|
| AS_IMPORT_INTERFACE_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
BATCH_ID
CUSTOMER_KEY
ADDRESS_KEY
CONTACT_KEY
LOAD_STATUS
|
| AS_IMPORT_INTERFACE_N5 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SOURCE_SYSTEM
LOAD_STATUS
|
| AS_IMPORT_INTERFACE_N7 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
IMP_LIST_HEADER_NUMBER
|
| AS_IMPORT_INTERFACE_N8 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORIG_SYSTEM_REFERENCE
|
| AS_IMPORT_INTERFACE_N9 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRUNC("PROGRAM_UPDATE_DATE")
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| IMPORT_INTERFACE_ID | NUMBER | Yes | Identifier | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| CREATION_DATE | DATE | Yes | Standard Who cloumn | |
| CREATED_BY | NUMBER | Yes | Standard Who cloumn | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who cloumn | ||
| REQUEST_ID | NUMBER | Standard Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update record | ||
| PROGRAM_ID | NUMBER | Identifier of last concurrent program to update record | ||
| PROGRAM_UPDATE_DATE | DATE | Last date concurrent program updated record | ||
| IMP_LIST_HEADER_NUMBER | VARCHAR2 | (30) | Obsolete in 11i | |
| LOAD_TYPE | VARCHAR2 | (20) | Load Type | |
| LOAD_DATE | DATE | Yes | Load Date | |
| LOAD_STATUS | VARCHAR2 | (20) | Load status | |
| LOAD_ERROR_MESSAGE | VARCHAR2 | (2000) | Error message | |
| PROMOTION_ID | NUMBER | For AS_SALES_LEADS.source_promotion_id | ||
| PROMOTION_CODE | VARCHAR2 | (50) | Obsolete in 11i | |
| CUSTOMER_ID | NUMBER | (15) | Obsolete | |
| CUSTOMER_NAME | VARCHAR2 | (255) | Customer name | |
| CUSTOMER_NUMBER | VARCHAR2 | (30) | Obsolete | |
| CUSTOMER_STATUS | VARCHAR2 | (1) | Obsolete | |
| CUSTOMER_TYPE | VARCHAR2 | (30) | Obsolete | |
| CUSTOMER_PROSPECT_CODE | VARCHAR2 | (30) | Obsolete in 11i | |
| CUSTOMER_CLASS_CODE | VARCHAR2 | (30) | Obsolete in 11i | |
| SALES_CHANNEL_CODE | VARCHAR2 | (30) | Obsolete in 11i | |
| SIC_CODE | VARCHAR2 | (30) | SIC code | |
| ANALYSIS_FY | VARCHAR2 | (5) | Analysis fiscal yearf | |
| CUSTOMER_CATEGORY_CODE | VARCHAR2 | (30) | Customer category code | |
| CUSTOMER_GROUP_CODE | VARCHAR2 | (30) | Obsolete in 11i | |
| CUSTOMER_KEY | VARCHAR2 | (500) | Customer key | |
| CUSTOMER_SUBGROUP_CODE | VARCHAR2 | (30) | Obsolete in 11i | |
| FISCAL_YEAREND_MONTH | VARCHAR2 | (30) | Fiscal year end month | |
| NET_WORTH | NUMBER | Obsolete in 11i | ||
| NUM_OF_EMPLOYEES | NUMBER | (15) | Number of employees | |
| POTENTIAL_REVENUE_CURR_FY | NUMBER | Potential revenue in current fiscal year | ||
| POTENTIAL_REVENUE_NEXT_FY | NUMBER | Potential revenue in next fiscal year | ||
| CUSTOMER_RANK | VARCHAR2 | (30) | Customer rank | |
| REFERENCE_USE_FLAG | VARCHAR2 | (1) | Flag to be used as reference | |
| TAX_CODE | VARCHAR2 | (50) | Obsolete | |
| TAX_REFERENCE | VARCHAR2 | (50) | Tax reference | |
| THIRD_PARTY_FLAG | VARCHAR2 | (1) | Flag to identify third party | |
| COMPETITOR_FLAG | VARCHAR2 | (1) | Falg to identify the competitor | |
| YEAR_ESTABLISHED | NUMBER | (4) | Year established | |
| ADDR_DO_NOT_MAIL_FLAG | VARCHAR2 | (1) | Flag to identify the address which is not mailed | |
| URL | VARCHAR2 | (2000) | For hz_contact_points.url | |
| ADDRESS_ID | NUMBER | (15) | Obsolete | |
| CONT_DO_NOT_MAIL_FLAG | VARCHAR2 | (1) | Flag to identify the contact which is not mailed | |
| ADDRESS_STATUS | VARCHAR2 | (1) | Obsolete | |
| COUNTRY | VARCHAR2 | (60) | Country | |
| ADDRESS1 | VARCHAR2 | (240) | Address line1 | |
| ADDRESS2 | VARCHAR2 | (240) | Address line2 | |
| ADDRESS3 | VARCHAR2 | (240) | Address line3 | |
| ADDRESS4 | VARCHAR2 | (240) | Address line4 | |
| CITY | VARCHAR2 | (60) | City | |
| POSTAL_CODE | VARCHAR2 | (60) | Postal code | |
| STATE | VARCHAR2 | (60) | State | |
| PROVINCE | VARCHAR2 | (60) | Province | |
| COUNTY | VARCHAR2 | (60) | County | |
| SITE_CONTACT_ID | NUMBER | (15) | Obsolete | |
| EMAIL_ADDRESS | VARCHAR2 | (240) | For hz_contact_points.email_address | |
| SEX_CODE | VARCHAR2 | (30) | Gender | |
| SALUTATION | VARCHAR2 | (60) | Salutation | |
| LAST_NAME | VARCHAR2 | (50) | Last name | |
| TITLE | VARCHAR2 | (40) | Title | |
| FIRST_NAME | VARCHAR2 | (40) | First name | |
| JOB_TITLE | VARCHAR2 | (100) | Job title | |
| PHONE_ID | NUMBER | The place to hold contact point id | ||
| PHONE_NUMBER | VARCHAR2 | (25) | For hz_contact_points.phone_number | |
| PHONE_STATUS | VARCHAR2 | (1) | Obsolete | |
| PHONE_TYPE | VARCHAR2 | (30) | For hz_contact_points.phone_line_type | |
| AREA_CODE | VARCHAR2 | (10) | For hz_contact_points.phone_area_code | |
| EXTENSION | VARCHAR2 | (20) | For hz_contact_points.phone_extension | |
| LEAD_NUMBER | VARCHAR2 | (30) | Lead number | |
| STATUS_CODE | VARCHAR2 | (30) | Status code | |
| SOURCE_PROMOTION_ID | NUMBER | Obsolete | ||
| INITIATING_CONTACT_ID | NUMBER | Obsolete | ||
| CONTACT_ROLE_CODE | VARCHAR2 | (30) | For as_sales_lead_contacts.contact_role_code | |
| CHANNEL_CODE | VARCHAR2 | (30) | Channel code | |
| BUDGET_AMOUNT | NUMBER | Budget amount | ||
| BUDGET_STATUS_CODE | VARCHAR2 | (30) | Budget status code | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
| DECISION_TIMEFRAME_CODE | VARCHAR2 | (30) | Decision timeframe code | |
| CLOSE_REASON | VARCHAR2 | (30) | Close reason | |
| LEAD_RANK_CODE | VARCHAR2 | (30) | Lead rank code | |
| PARENT_PROJECT | VARCHAR2 | (80) | Parent project | |
| DESCRIPTION | VARCHAR2 | (2000) | Description | |
| STATUS_CODE_1 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTEREST_TYPE_ID_1 | NUMBER | For as_sales_lead_lines.interest_type_id | ||
| PRIMARY_INTEREST_CODE_ID_1 | NUMBER | For as_sales_lead_lines.primary_interest_code_id | ||
| SECONDARY_INTEREST_CODE_ID_1 | NUMBER | For as_sales_lead_lines.secondary_interest_code_id | ||
| INVENTORY_ITEM_ID_1 | NUMBER | For as_sales_lead_lines.inventory_item_id | ||
| ORGANIZATION_ID_1 | NUMBER | For as_sales_lead_lines.organization_id | ||
| UOM_CODE_1 | VARCHAR2 | (3) | For as_sales_lead_lines.uom_code | |
| QUANTITY_1 | NUMBER | For as_sales_lead_lines.quantity | ||
| BUDGET_AMOUNT_1 | NUMBER | For as_sales_lead_lines.budget_amount | ||
| STATUS_CODE_2 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTEREST_TYPE_ID_2 | NUMBER | For as_sales_lead_lines.interest_type_id | ||
| PRIMARY_INTEREST_CODE_ID_2 | NUMBER | For as_sales_lead_lines.primary_interest_code_id | ||
| SECONDARY_INTEREST_CODE_ID_2 | NUMBER | For as_sales_lead_lines.secondary_interest_code_id | ||
| INVENTORY_ITEM_ID_2 | NUMBER | For as_sales_lead_lines.inventory_item_id | ||
| ORGANIZATION_ID_2 | NUMBER | For as_sales_lead_lines.organization_id | ||
| UOM_CODE_2 | VARCHAR2 | (3) | For as_sales_lead_lines.uom_code | |
| QUANTITY_2 | NUMBER | For as_sales_lead_lines.quantity | ||
| BUDGET_AMOUNT_2 | NUMBER | For as_sales_lead_lines.budget_amount | ||
| STATUS_CODE_3 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTEREST_TYPE_ID_3 | NUMBER | For as_sales_lead_lines.interest_type_id | ||
| PRIMARY_INTEREST_CODE_ID_3 | NUMBER | For as_sales_lead_lines.primary_interest_code_id | ||
| SECONDARY_INTEREST_CODE_ID_3 | NUMBER | For as_sales_lead_lines.secondary_interest_code_id | ||
| INVENTORY_ITEM_ID_3 | NUMBER | For as_sales_lead_lines.inventory_item_id | ||
| ORGANIZATION_ID_3 | NUMBER | For as_sales_lead_lines.organization_id | ||
| UOM_CODE_3 | VARCHAR2 | (3) | For as_sales_lead_lines.uom_code | |
| QUANTITY_3 | NUMBER | For as_sales_lead_lines.quantity | ||
| BUDGET_AMOUNT_3 | NUMBER | For as_sales_lead_lines.budget_amount | ||
| STATUS_CODE_4 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTEREST_TYPE_ID_4 | NUMBER | For as_sales_lead_lines.interest_type_id | ||
| PRIMARY_INTEREST_CODE_ID_4 | NUMBER | For as_sales_lead_lines.primary_interest_code_id | ||
| SECONDARY_INTEREST_CODE_ID_4 | NUMBER | For as_sales_lead_lines.secondary_interest_code_id | ||
| INVENTORY_ITEM_ID_4 | NUMBER | For as_sales_lead_lines.inventory_item_id | ||
| ORGANIZATION_ID_4 | NUMBER | For as_sales_lead_lines.organization_id | ||
| UOM_CODE_4 | VARCHAR2 | (3) | For as_sales_lead_lines.uom_code | |
| QUANTITY_4 | NUMBER | For as_sales_lead_lines.quantity | ||
| BUDGET_AMOUNT_4 | NUMBER | For as_sales_lead_lines.budget_amount | ||
| STATUS_CODE_5 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTEREST_TYPE_ID_5 | NUMBER | For as_sales_lead_lines.interest_type_id | ||
| PRIMARY_INTEREST_CODE_ID_5 | NUMBER | For as_sales_lead_lines.primary_interest_code_id | ||
| SECONDARY_INTEREST_CODE_ID_5 | NUMBER | For as_sales_lead_lines.secondary_interest_code_id | ||
| INVENTORY_ITEM_ID_5 | NUMBER | For as_sales_lead_lines.inventory_item_id | ||
| ORGANIZATION_ID_5 | NUMBER | For as_sales_lead_lines.organization_id | ||
| UOM_CODE_5 | VARCHAR2 | (3) | For as_sales_lead_lines.uom_code | |
| QUANTITY_5 | NUMBER | For as_sales_lead_lines.quantity | ||
| BUDGET_AMOUNT_5 | NUMBER | For as_sales_lead_lines.budget_amount | ||
| INTERACTION_NOTES_1 | VARCHAR2 | (2000) | Obsolete in 11i | |
| PRIORITY_1 | NUMBER | (3) | Obsolete in 11i | |
| TODO_DATE_1 | DATE | Obsolete in 11i | ||
| TODO_START_TIME_1 | VARCHAR2 | (5) | Obsolete in 11i | |
| ACTIVITY_CODE_1 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTERACTION_NOTES_2 | VARCHAR2 | (2000) | Obsolete in 11i | |
| PRIORITY_2 | NUMBER | (3) | Obsolete in 11i | |
| TODO_DATE_2 | DATE | Obsolete in 11i | ||
| TODO_START_TIME_2 | VARCHAR2 | (5) | Obsolete in 11i | |
| ACTIVITY_CODE_2 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTERACTION_NOTES_3 | VARCHAR2 | (2000) | Obsolete in 11i | |
| PRIORITY_3 | NUMBER | (3) | Obsolete in 11i | |
| TODO_DATE_3 | DATE | Obsolete in 11i | ||
| TODO_START_TIME_3 | VARCHAR2 | (5) | Obsolete in 11i | |
| ACTIVITY_CODE_3 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTERACTION_NOTES_4 | VARCHAR2 | (2000) | Obsolete in 11i | |
| PRIORITY_4 | NUMBER | (3) | Obsolete in 11i | |
| TODO_DATE_4 | DATE | Obsolete in 11i | ||
| TODO_START_TIME_4 | VARCHAR2 | (5) | Obsolete in 11i | |
| ACTIVITY_CODE_4 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTERACTION_NOTES_5 | VARCHAR2 | (2000) | Obsolete in 11i | |
| PRIORITY_5 | NUMBER | (3) | Obsolete in 11i | |
| TODO_DATE_5 | DATE | Obsolete in 11i | ||
| TODO_START_TIME_5 | VARCHAR2 | (5) | Obsolete in 11i | |
| ACTIVITY_CODE_5 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTERACTION_NOTES_6 | VARCHAR2 | (2000) | Obsolete in 11i | |
| PRIORITY_6 | NUMBER | (3) | Obsolete in 11i | |
| TODO_DATE_6 | DATE | Obsolete in 11i | ||
| TODO_START_TIME_6 | VARCHAR2 | (5) | Obsolete in 11i | |
| ACTIVITY_CODE_6 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTERACTION_NOTES_7 | VARCHAR2 | (2000) | Obsolete in 11i | |
| PRIORITY_7 | NUMBER | (3) | Obsolete in 11i | |
| TODO_DATE_7 | DATE | Obsolete in 11i | ||
| TODO_START_TIME_7 | VARCHAR2 | (5) | Obsolete in 11i | |
| ACTIVITY_CODE_7 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTERACTION_NOTES_8 | VARCHAR2 | (2000) | Obsolete in 11i | |
| PRIORITY_8 | NUMBER | (3) | Obsolete in 11i | |
| TODO_DATE_8 | DATE | Obsolete in 11i | ||
| TODO_START_TIME_8 | VARCHAR2 | (5) | Obsolete in 11i | |
| ACTIVITY_CODE_8 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTERACTION_NOTES_9 | VARCHAR2 | (2000) | Obsolete in 11i | |
| PRIORITY_9 | NUMBER | (3) | Obsolete in 11i | |
| TODO_DATE_9 | DATE | Obsolete in 11i | ||
| TODO_START_TIME_9 | VARCHAR2 | (5) | Obsolete in 11i | |
| ACTIVITY_CODE_9 | VARCHAR2 | (30) | Obsolete in 11i | |
| INTERACTION_NOTES_10 | VARCHAR2 | (2000) | Obsolete in 11i | |
| PRIORITY_10 | NUMBER | (3) | Obsolete in 11i | |
| TODO_DATE_10 | DATE | Obsolete in 11i | ||
| TODO_START_TIME_10 | VARCHAR2 | (5) | Obsolete in 11i | |
| ACTIVITY_CODE_10 | VARCHAR2 | (30) | Obsolete in 11i | |
| LEAD_NOTE | VARCHAR2 | (2000) | Sales lead note | |
| MIDDLE_INITIAL | VARCHAR2 | (10) | Middle name initial | |
| FAX_NUMBER | VARCHAR2 | (25) | For hz_contact_points.phone_number (fax) | |
| FAX_AREA_CODE | VARCHAR2 | (10) | For hz_contact_points.area_code (fax) | |
| MAIL_STOP | VARCHAR2 | (60) | mail stop | |
| NUM_ENROLLED | NUMBER | (5) | Obsolete in 11i | |
| CONFIRMED_FLAG | VARCHAR2 | (1) | Obsolete in 11i | |
| PAYMENT_AMOUNT | NUMBER | Obsolete in 11i | ||
| NUM_ATTENDED | NUMBER | (5) | Obsolete in 11i | |
| PROMOTION_NAME | VARCHAR2 | (240) | Obsolete in 11i | |
| STATUS_CHANGE_FLAG | VARCHAR2 | (1) | Obsolete in 11i | |
| VEHICLE_RESPONSE_CODE | VARCHAR2 | (30) | Vehicle response code | |
| SOURCE_SYSTEM | VARCHAR2 | (30) | Source system | |
| SECURITY_GROUP_ID | NUMBER | Subscriber id, for CRM Online Services use | ||
| CONTACT_PARTY_ID | NUMBER | Contact's party_id | ||
| PRM_SALES_LEAD_TYPE | VARCHAR2 | (30) | For prm, use to identify the sales_lead_type. Valid values are DIRECT and INDIRECT based on lookup type PRM_LEAD_TYPE | |
| PRM_EXEC_SPONSOR_FLAG | VARCHAR2 | (1) | PRM use | |
| PRM_PRJ_LEAD_IN_PLACE_FLAG | VARCHAR2 | (1) | PRM use | |
| INCUMBENT_PARTNER_PARTY_ID | NUMBER | Incumbent partner identifier, used for PRM | ||
| INCUMBENT_PARTNER_RESOURCE_ID | NUMBER | Incumbent partner resource identifier, used for PRM | ||
| OFFER_ID | NUMBER | Promotions offer | ||
| PRM_IND_CLASSIFICATION_CODE | VARCHAR2 | (30) | industry classification code for prm. lookup_type - prm_industry_classification_type | |
| PARTY_TYPE | VARCHAR2 | (30) | Party Type | |
| BATCH_ID | NUMBER | (15) | Batch Identifier | |
| PARTY_ID | NUMBER | (15) | Party Identifier | |
| PARTY_SITE_ID | NUMBER | (15) | Party Site Identifier | |
| LOCATION_ID | NUMBER | (15) | Location Identifier | |
| REL_PARTY_ID | NUMBER | (15) | Party relationship's Party Identifier | |
| SALES_LEAD_ID | NUMBER | (15) | Sales Lead Identifier | |
| ADDRESS_KEY | VARCHAR2 | (500) | Address Key | |
| CONTACT_KEY | VARCHAR2 | (80) | Contact Key | |
| JOB_TITLE_CODE | VARCHAR2 | (30) | Job Title Code;ar_lookup: RESPONSIBILITY | |
| DO_NOT_PHONE_FLAG | VARCHAR2 | (1) | Do Not Phone Flag | |
| DO_NOT_FAX_FLAG | VARCHAR2 | (1) | Do Not Fax Flag | |
| DO_NOT_EMAIL_FLAG | VARCHAR2 | (1) | Do Not Email Flag | |
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | Identifies the source for this interface record | |
| LEAD_RANK_ID | NUMBER | (15) | Lead Rank Identifier | |
| NEW_PARTY_FLAG | NUMBER | (1) | During import Concurrent Program sets this flag if party is newly created to 1. Otherwise it is 0. | |
| NEW_LOC_FLAG | NUMBER | (1) | During import Concurrent Program sets this flag if location is newly created to 1. Otherwise it is 0. | |
| NEW_PS_FLAG | NUMBER | (1) | During import Concurrent Program sets this flag if party site is newly created to 1. Otherwise it is 0. | |
| NEW_REL_FLAG | NUMBER | (1) | During import Concurrent Program sets this flag if relationship is newly created to 1. Otherwise it is 0. | |
| NEW_CON_FLAG | NUMBER | (1) | During import Concurrent Program sets this flag if contact is newly created to 1. Otherwise it is 0. | |
| ORIG_SYSTEM_CODE | VARCHAR2 | (30) | Identifies the source Code for this interface record Example: OTN | |
| SOURCE_PROMOTION_ID_1 | NUMBER | For as_sales_lead_lines.source_promotion_id | ||
| OFFER_ID_1 | NUMBER | For as_sales_lead_lines.offer_id | ||
| SOURCE_PROMOTION_ID_2 | NUMBER | For as_sales_lead_lines.source_promotion_id | ||
| OFFER_ID_2 | NUMBER | For as_sales_lead_lines.offer_id | ||
| SOURCE_PROMOTION_ID_3 | NUMBER | For as_sales_lead_lines.source_promotion_id | ||
| OFFER_ID_3 | NUMBER | For as_sales_lead_lines.offer_id | ||
| SOURCE_PROMOTION_ID_4 | NUMBER | For as_sales_lead_lines.source_promotion_id | ||
| OFFER_ID_4 | NUMBER | For as_sales_lead_lines.offer_id | ||
| SOURCE_PROMOTION_ID_5 | NUMBER | For as_sales_lead_lines.source_promotion_id | ||
| OFFER_ID_5 | NUMBER | For as_sales_lead_lines.offer_id | ||
| URGENT_FLAG | VARCHAR2 | (1) | To signify this is an urgent sales lead | |
| ACCEPT_FLAG | VARCHAR2 | (1) | For AS_SALES_LEADS.accept_flag | |
| ASSIGN_DATE | DATE | For AS_SALES_LEADS.assign_date | ||
| ASSIGN_SALES_GROUP_ID | NUMBER | For AS_SALES_LEADS.assign_sales_group_id | ||
| ASSIGN_TO_PERSON_ID | NUMBER | For AS_SALES_LEADS.assign_to_person_id | ||
| ASSIGN_TO_SALESFORCE_ID | NUMBER | For AS_SALES_LEADS.assign_to_salesforce_id | ||
| AUTO_ASSIGNMENT_TYPE | VARCHAR2 | (30) | For AS_SALES_LEADS.auto_assignment_type | |
| DELETED_FLAG | VARCHAR2 | (1) | For AS_SALES_LEADS.deleted_flag | |
| IMPORT_FLAG | VARCHAR2 | (1) | For AS_SALES_LEADS.import_flag | |
| KEEP_FLAG | VARCHAR2 | (1) | For AS_SALES_LEADS.keep_flag | |
| PRM_ASSIGNMENT_TYPE | VARCHAR2 | (30) | For AS_SALES_LEADS.prm_assignment_type | |
| QUALIFIED_FLAG | VARCHAR2 | (1) | For AS_SALES_LEADS.qualified_flag | |
| REJECT_REASON_CODE | VARCHAR2 | (30) | For AS_SALES_LEADS.reject_reason_code | |
| SCORECARD_ID | NUMBER | For AS_SALES_LEADS.scorecard_id | ||
| LEAD_CONTACT_ID | NUMBER | For AS_SALES_LEAD_CONTACTS.lead_contact_id | ||
| PRIMARY_CONTACT_FLAG | VARCHAR2 | (1) | For AS_SALES_LEAD_CONTACTS.primary_contact_flag | |
| ADDRESS_EFFECTIVE_DATE | DATE | For HZ_LOCATIONS.address_effective_date | ||
| ADDRESS_LINES_PHONETIC | VARCHAR2 | (560) | For HZ_LOCATIONS.address_lines_phonetic | |
| ADDRESS_STYLE | VARCHAR2 | (30) | For HZ_LOCATIONS.address_style | |
| CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | For HZ_LOCATIONS.content_source_type | |
| LOC_DESCRIPTION | VARCHAR2 | (2000) | For HZ_LOCATIONS.description | |
| LOC_HIERARCHY_ID | NUMBER | (15) | For HZ_LOCATIONS.loc_heirarchy_id | |
| FA_LOCATION_ID | NUMBER | For HZ_LOCATIONS.fa_location_id | ||
| FLOOR | VARCHAR2 | (50) | For HZ_LOCATIONS.floor | |
| HOUSE_NUMBER | VARCHAR2 | (50) | For HZ_LOCATIONS.house_number | |
| LANGUAGE | VARCHAR2 | (4) | For HZ_LOCATIONS.language | |
| LOCATION_DIRECTIONS | VARCHAR2 | (640) | For HZ_LOCATIONS.location_directions | |
| PO_BOX_NUMBER | VARCHAR2 | (50) | For HZ_LOCATIONS.po_box_number | |
| POSITION | VARCHAR2 | (50) | For HZ_LOCATIONS.position | |
| POSTAL_PLUS4_CODE | VARCHAR2 | (10) | For HZ_LOCATIONS.postal_plus4_code | |
| SALES_TAX_GEOCODE | VARCHAR2 | (30) | For HZ_LOCATIONS.sales_tax_geocode | |
| SALES_TAX_INSIDE_CITY_LIMITS | VARCHAR2 | (30) | For HZ_LOCATIONS.sales_tax_inside_city_limits | |
| SHORT_DESCRIPTION | VARCHAR2 | (240) | For HZ_LOCATIONS.short_description | |
| STREET | VARCHAR2 | (50) | For HZ_LOCATIONS.street | |
| STREET_NUMBER | VARCHAR2 | (50) | For HZ_LOCATIONS.street_number | |
| STREET_SUFFIX | VARCHAR2 | (50) | For HZ_LOCATIONS.street_suffix | |
| SUITE | VARCHAR2 | (50) | For HZ_LOCATIONS.suite | |
| TIME_ZONE | VARCHAR2 | (50) | For HZ_LOCATIONS.time_zone | |
| LOC_VALIDATED_FLAG | VARCHAR2 | (1) | For HZ_LOCATIONS.validated_flag | |
| DUNS_NUMBER | NUMBER | Obsolete. For HZ_PARTIES.duns_number | ||
| GROUP_TYPE | VARCHAR2 | (30) | For HZ_PARTIES.group_type | |
| GSA_INDICATOR_FLAG | VARCHAR2 | (1) | For HZ_PARTIES.gsa_indicator_flag | |
| HQ_BRANCH_IND | VARCHAR2 | (30) | For HZ_PARTIES.hq_branch_ind | |
| JGZZ_FISCAL_CODE | VARCHAR2 | (20) | For HZ_PARTIES.jgzz_fiscal_code | |
| KNOWN_AS | VARCHAR2 | (240) | For HZ_PARTIES.knowns_as | |
| KNOWN_AS2 | VARCHAR2 | (240) | For HZ_PARTIES.known_as2 | |
| KNOWN_AS3 | VARCHAR2 | (240) | For HZ_PARTIES.known_as3 | |
| KNOWN_AS4 | VARCHAR2 | (240) | For HZ_PARTIES.knowns_as4 | |
| KNOWN_AS5 | VARCHAR2 | (240) | For HZ_PARTIES.known_as5 | |
| LANGUAGE_NAME | VARCHAR2 | (30) | For HZ_PARTIES.language_name | |
| LAST_ORDERED_DATE | DATE | For HZ_PARTIES.last_ordered_date | ||
| MISSION_STATEMENT | VARCHAR2 | (2000) | For HZ_PARTIES.mission_statement | |
| ORGANIZATION_NAME_PHONETIC | VARCHAR2 | (320) | For HZ_PARTIES.organization_name_phonetic | |
| PARTY_NUMBER | VARCHAR2 | (30) | For HZ_PARTIES.party_number | |
| PERSON_FIRST_NAME_PHONETIC | VARCHAR2 | (60) | For HZ_PARTIES.person_first_name_phonetic | |
| PERSON_IDEN_TYPE | VARCHAR2 | (30) | For HZ_PARTIES.person_iden_type | |
| PERSON_IDENTIFIER | VARCHAR2 | (60) | For HZ_PARTIES.person_identifier | |
| PERSON_LAST_NAME_PHONETIC | VARCHAR2 | (60) | For HZ_PARTIES.person_last_name_phonetic | |
| PERSON_NAME_SUFFIX | VARCHAR2 | (30) | For HZ_PARTIES.person_name_suffix | |
| PERSON_PREVIOUS_LAST_NAME | VARCHAR2 | (150) | For HZ_PARTIES.person_previous_last_name | |
| PARTY_REFERENCE_USE_FLAG | VARCHAR2 | (1) | For HZ_PARTIES.party_reference_use_flag | |
| SIC_CODE_TYPE | VARCHAR2 | (30) | For HZ_PARTIES.sic_code_type | |
| TAX_NAME | VARCHAR2 | (60) | For HZ_PARTIES.tax_name | |
| TOTAL_NUM_OF_ORDERS | NUMBER | For HZ_PARTIES.total_num_of_orders | ||
| TOTAL_ORDERED_AMOUNT | NUMBER | For HZ_PARTIES.total_ordered_amount | ||
| PARTIES_VALIDATED_FLAG | VARCHAR2 | (1) | For HZ_PARTIES.validated_flag | |
| PS_USES_COMMENTS | VARCHAR2 | (240) | FOR HZ_PARTY_SITE_USES.comments | |
| PRIMARY_PER_TYPE | VARCHAR2 | (1) | FOR HZ_PARTY_SITE_USES.primary_per_type | |
| SITE_USE_TYPE | VARCHAR2 | (30) | FOR HZ_PARTY_SITE_USES.site_use_type | |
| ADDRESSEE | VARCHAR2 | (360) | FOR HZ_PARTY_SITES.addressee | |
| MAILSTOP | VARCHAR2 | (60) | FOR HZ_PARTY_SITES.mailstop | |
| PARTY_SITE_NAME | VARCHAR2 | (240) | FOR HZ_PARTY_SITES.party_site_name | |
| PARTY_SITE_NUMBER | VARCHAR2 | (30) | FOR HZ_PARTY_SITES.party_site_number | |
| ORG_CNT_COMMENTS | VARCHAR2 | (240) | For HZ_ORG_CONTACTS.comments | |
| CONTACT_NUMBER | VARCHAR2 | (30) | For HZ_ORG_CONTACTS.contact_number | |
| DECISION_MAKER_FLAG | VARCHAR2 | (1) | For HZ_ORG_CONTACTS.decision_maker_flag | |
| DEPARTMENT | VARCHAR2 | (60) | For HZ_ORG_CONTACTS.department | |
| DEPARTMENT_CODE | VARCHAR2 | (30) | For HZ_ORG_CONTACTS.department_code | |
| RANK | VARCHAR2 | (30) | For HZ_ORG_CONTACTS.rank | |
| ORG_CNT_TITLE | VARCHAR2 | (30) | For HZ_ORG_CONTACTS.title | |
| ROLE_LEVEL | VARCHAR2 | (30) | For HZ_ORG_CONTACT_ROLES.roll_level | |
| PRIMARY_CONTACT_PER_ROLE_TYPE | VARCHAR2 | (1) | For HZ_ORG_CONTACT_ROLES.primary_contact_roles | |
| CNT_PNT_CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | For HZ_CONTACT_POINTS.content_source_type | |
| PHONE_COUNTRY_CODE | VARCHAR2 | (30) | FOR HZ_CONTACT_POINTS.phone_country_code | |
| FAX_COUNTRY_CODE | VARCHAR2 | (30) | FOR HZ_CONTACT_POINTS.phone_country_code (fax) | |
| PHONE_CALLING_CALENDAR | VARCHAR2 | (30) | For HZ_CONTACT_POINT.phone_calling_calendar | |
| CNT_PNT_TIME_ZONE | NUMBER | For HZ_CONTACT_POINTS.time_zone | ||
| RAW_PHONE_NUMBER | VARCHAR2 | (60) | For HZ_CONTACT_POINTS.raw_phone_number | |
| EMAIL_FORMAT | VARCHAR2 | (30) | For HZ_CONTACT_POINTS.email_format | |
| FAX_EXTENSION | VARCHAR2 | (20) | For hz_contact_points.phone_extension (fax) | |
| MARKETING_SCORE | NUMBER | (10) | Marketing score to elevate the score of the lead | |
| LEAD_DATE | DATE | Lead Date for the sales lead | ||
| PERSON_INITIALS | VARCHAR2 | (6) | For HZ_PERSON_PROFILES.person_initials | |
| NOTE_TYPE | VARCHAR2 | (30) | Type of the Note | |
| INTERACTION_SCORE | NUMBER | Score for mined interaction | ||
| SOURCE_PRIMARY_REFERENCE | VARCHAR2 | (240) | Source System primary refrence number for tracking | |
| SOURCE_SECONDARY_REFERENCE | VARCHAR2 | (240) | Source System secondary refrence number for tracking | |
| CATEGORY_ID_1 | NUMBER | Category Id for product catalog | ||
| CATEGORY_ID_2 | NUMBER | Category Id for product catalog | ||
| CATEGORY_ID_3 | NUMBER | Category Id for product catalog | ||
| CATEGORY_ID_4 | NUMBER | Category Id for product catalog | ||
| CATEGORY_ID_5 | NUMBER | Category Id for product catalog | ||
| SALES_METHODOLOGY_ID | NUMBER | SALES METHODOLOGY ID | ||
| DUNS_NUMBER_C | VARCHAR2 | (30) | Duns Number for HZ_PARTIES | |
| CHILD_REQUEST_ID | NUMBER | Child Request Id |
Cut, paste (and edit) the following text to query this object:
SELECT IMPORT_INTERFACE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, IMP_LIST_HEADER_NUMBER
, LOAD_TYPE
, LOAD_DATE
, LOAD_STATUS
, LOAD_ERROR_MESSAGE
, PROMOTION_ID
, PROMOTION_CODE
, CUSTOMER_ID
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, CUSTOMER_STATUS
, CUSTOMER_TYPE
, CUSTOMER_PROSPECT_CODE
, CUSTOMER_CLASS_CODE
, SALES_CHANNEL_CODE
, SIC_CODE
, ANALYSIS_FY
, CUSTOMER_CATEGORY_CODE
, CUSTOMER_GROUP_CODE
, CUSTOMER_KEY
, CUSTOMER_SUBGROUP_CODE
, FISCAL_YEAREND_MONTH
, NET_WORTH
, NUM_OF_EMPLOYEES
, POTENTIAL_REVENUE_CURR_FY
, POTENTIAL_REVENUE_NEXT_FY
, CUSTOMER_RANK
, REFERENCE_USE_FLAG
, TAX_CODE
, TAX_REFERENCE
, THIRD_PARTY_FLAG
, COMPETITOR_FLAG
, YEAR_ESTABLISHED
, ADDR_DO_NOT_MAIL_FLAG
, URL
, ADDRESS_ID
, CONT_DO_NOT_MAIL_FLAG
, ADDRESS_STATUS
, COUNTRY
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
, SITE_CONTACT_ID
, EMAIL_ADDRESS
, SEX_CODE
, SALUTATION
, LAST_NAME
, TITLE
, FIRST_NAME
, JOB_TITLE
, PHONE_ID
, PHONE_NUMBER
, PHONE_STATUS
, PHONE_TYPE
, AREA_CODE
, EXTENSION
, LEAD_NUMBER
, STATUS_CODE
, SOURCE_PROMOTION_ID
, INITIATING_CONTACT_ID
, CONTACT_ROLE_CODE
, CHANNEL_CODE
, BUDGET_AMOUNT
, BUDGET_STATUS_CODE
, CURRENCY_CODE
, DECISION_TIMEFRAME_CODE
, CLOSE_REASON
, LEAD_RANK_CODE
, PARENT_PROJECT
, DESCRIPTION
, STATUS_CODE_1
, INTEREST_TYPE_ID_1
, PRIMARY_INTEREST_CODE_ID_1
, SECONDARY_INTEREST_CODE_ID_1
, INVENTORY_ITEM_ID_1
, ORGANIZATION_ID_1
, UOM_CODE_1
, QUANTITY_1
, BUDGET_AMOUNT_1
, STATUS_CODE_2
, INTEREST_TYPE_ID_2
, PRIMARY_INTEREST_CODE_ID_2
, SECONDARY_INTEREST_CODE_ID_2
, INVENTORY_ITEM_ID_2
, ORGANIZATION_ID_2
, UOM_CODE_2
, QUANTITY_2
, BUDGET_AMOUNT_2
, STATUS_CODE_3
, INTEREST_TYPE_ID_3
, PRIMARY_INTEREST_CODE_ID_3
, SECONDARY_INTEREST_CODE_ID_3
, INVENTORY_ITEM_ID_3
, ORGANIZATION_ID_3
, UOM_CODE_3
, QUANTITY_3
, BUDGET_AMOUNT_3
, STATUS_CODE_4
, INTEREST_TYPE_ID_4
, PRIMARY_INTEREST_CODE_ID_4
, SECONDARY_INTEREST_CODE_ID_4
, INVENTORY_ITEM_ID_4
, ORGANIZATION_ID_4
, UOM_CODE_4
, QUANTITY_4
, BUDGET_AMOUNT_4
, STATUS_CODE_5
, INTEREST_TYPE_ID_5
, PRIMARY_INTEREST_CODE_ID_5
, SECONDARY_INTEREST_CODE_ID_5
, INVENTORY_ITEM_ID_5
, ORGANIZATION_ID_5
, UOM_CODE_5
, QUANTITY_5
, BUDGET_AMOUNT_5
, INTERACTION_NOTES_1
, PRIORITY_1
, TODO_DATE_1
, TODO_START_TIME_1
, ACTIVITY_CODE_1
, INTERACTION_NOTES_2
, PRIORITY_2
, TODO_DATE_2
, TODO_START_TIME_2
, ACTIVITY_CODE_2
, INTERACTION_NOTES_3
, PRIORITY_3
, TODO_DATE_3
, TODO_START_TIME_3
, ACTIVITY_CODE_3
, INTERACTION_NOTES_4
, PRIORITY_4
, TODO_DATE_4
, TODO_START_TIME_4
, ACTIVITY_CODE_4
, INTERACTION_NOTES_5
, PRIORITY_5
, TODO_DATE_5
, TODO_START_TIME_5
, ACTIVITY_CODE_5
, INTERACTION_NOTES_6
, PRIORITY_6
, TODO_DATE_6
, TODO_START_TIME_6
, ACTIVITY_CODE_6
, INTERACTION_NOTES_7
, PRIORITY_7
, TODO_DATE_7
, TODO_START_TIME_7
, ACTIVITY_CODE_7
, INTERACTION_NOTES_8
, PRIORITY_8
, TODO_DATE_8
, TODO_START_TIME_8
, ACTIVITY_CODE_8
, INTERACTION_NOTES_9
, PRIORITY_9
, TODO_DATE_9
, TODO_START_TIME_9
, ACTIVITY_CODE_9
, INTERACTION_NOTES_10
, PRIORITY_10
, TODO_DATE_10
, TODO_START_TIME_10
, ACTIVITY_CODE_10
, LEAD_NOTE
, MIDDLE_INITIAL
, FAX_NUMBER
, FAX_AREA_CODE
, MAIL_STOP
, NUM_ENROLLED
, CONFIRMED_FLAG
, PAYMENT_AMOUNT
, NUM_ATTENDED
, PROMOTION_NAME
, STATUS_CHANGE_FLAG
, VEHICLE_RESPONSE_CODE
, SOURCE_SYSTEM
, SECURITY_GROUP_ID
, CONTACT_PARTY_ID
, PRM_SALES_LEAD_TYPE
, PRM_EXEC_SPONSOR_FLAG
, PRM_PRJ_LEAD_IN_PLACE_FLAG
, INCUMBENT_PARTNER_PARTY_ID
, INCUMBENT_PARTNER_RESOURCE_ID
, OFFER_ID
, PRM_IND_CLASSIFICATION_CODE
, PARTY_TYPE
, BATCH_ID
, PARTY_ID
, PARTY_SITE_ID
, LOCATION_ID
, REL_PARTY_ID
, SALES_LEAD_ID
, ADDRESS_KEY
, CONTACT_KEY
, JOB_TITLE_CODE
, DO_NOT_PHONE_FLAG
, DO_NOT_FAX_FLAG
, DO_NOT_EMAIL_FLAG
, ORIG_SYSTEM_REFERENCE
, LEAD_RANK_ID
, NEW_PARTY_FLAG
, NEW_LOC_FLAG
, NEW_PS_FLAG
, NEW_REL_FLAG
, NEW_CON_FLAG
, ORIG_SYSTEM_CODE
, SOURCE_PROMOTION_ID_1
, OFFER_ID_1
, SOURCE_PROMOTION_ID_2
, OFFER_ID_2
, SOURCE_PROMOTION_ID_3
, OFFER_ID_3
, SOURCE_PROMOTION_ID_4
, OFFER_ID_4
, SOURCE_PROMOTION_ID_5
, OFFER_ID_5
, URGENT_FLAG
, ACCEPT_FLAG
, ASSIGN_DATE
, ASSIGN_SALES_GROUP_ID
, ASSIGN_TO_PERSON_ID
, ASSIGN_TO_SALESFORCE_ID
, AUTO_ASSIGNMENT_TYPE
, DELETED_FLAG
, IMPORT_FLAG
, KEEP_FLAG
, PRM_ASSIGNMENT_TYPE
, QUALIFIED_FLAG
, REJECT_REASON_CODE
, SCORECARD_ID
, LEAD_CONTACT_ID
, PRIMARY_CONTACT_FLAG
, ADDRESS_EFFECTIVE_DATE
, ADDRESS_LINES_PHONETIC
, ADDRESS_STYLE
, CONTENT_SOURCE_TYPE
, LOC_DESCRIPTION
, LOC_HIERARCHY_ID
, FA_LOCATION_ID
, FLOOR
, HOUSE_NUMBER
, LANGUAGE
, LOCATION_DIRECTIONS
, PO_BOX_NUMBER
, POSITION
, POSTAL_PLUS4_CODE
, SALES_TAX_GEOCODE
, SALES_TAX_INSIDE_CITY_LIMITS
, SHORT_DESCRIPTION
, STREET
, STREET_NUMBER
, STREET_SUFFIX
, SUITE
, TIME_ZONE
, LOC_VALIDATED_FLAG
, DUNS_NUMBER
, GROUP_TYPE
, GSA_INDICATOR_FLAG
, HQ_BRANCH_IND
, JGZZ_FISCAL_CODE
, KNOWN_AS
, KNOWN_AS2
, KNOWN_AS3
, KNOWN_AS4
, KNOWN_AS5
, LANGUAGE_NAME
, LAST_ORDERED_DATE
, MISSION_STATEMENT
, ORGANIZATION_NAME_PHONETIC
, PARTY_NUMBER
, PERSON_FIRST_NAME_PHONETIC
, PERSON_IDEN_TYPE
, PERSON_IDENTIFIER
, PERSON_LAST_NAME_PHONETIC
, PERSON_NAME_SUFFIX
, PERSON_PREVIOUS_LAST_NAME
, PARTY_REFERENCE_USE_FLAG
, SIC_CODE_TYPE
, TAX_NAME
, TOTAL_NUM_OF_ORDERS
, TOTAL_ORDERED_AMOUNT
, PARTIES_VALIDATED_FLAG
, PS_USES_COMMENTS
, PRIMARY_PER_TYPE
, SITE_USE_TYPE
, ADDRESSEE
, MAILSTOP
, PARTY_SITE_NAME
, PARTY_SITE_NUMBER
, ORG_CNT_COMMENTS
, CONTACT_NUMBER
, DECISION_MAKER_FLAG
, DEPARTMENT
, DEPARTMENT_CODE
, RANK
, ORG_CNT_TITLE
, ROLE_LEVEL
, PRIMARY_CONTACT_PER_ROLE_TYPE
, CNT_PNT_CONTENT_SOURCE_TYPE
, PHONE_COUNTRY_CODE
, FAX_COUNTRY_CODE
, PHONE_CALLING_CALENDAR
, CNT_PNT_TIME_ZONE
, RAW_PHONE_NUMBER
, EMAIL_FORMAT
, FAX_EXTENSION
, MARKETING_SCORE
, LEAD_DATE
, PERSON_INITIALS
, NOTE_TYPE
, INTERACTION_SCORE
, SOURCE_PRIMARY_REFERENCE
, SOURCE_SECONDARY_REFERENCE
, CATEGORY_ID_1
, CATEGORY_ID_2
, CATEGORY_ID_3
, CATEGORY_ID_4
, CATEGORY_ID_5
, SALES_METHODOLOGY_ID
, DUNS_NUMBER_C
, CHILD_REQUEST_ID
FROM OSM.AS_IMPORT_INTERFACE;
OSM.AS_IMPORT_INTERFACE does not reference any database object
OSM.AS_IMPORT_INTERFACE is referenced by following:
OSM
AS_IMPORT_INTERFACE#
|
|
|
|