[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AS_IMPORT_INTERFACE# |
|---|---|
| Object Type: | VIEW |
| Owner: | OSM |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| IMPORT_INTERFACE_ID | NUMBER | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| IMP_LIST_HEADER_NUMBER | VARCHAR2 | (30) | ||
| LOAD_TYPE | VARCHAR2 | (20) | ||
| LOAD_DATE | DATE | Yes | ||
| LOAD_STATUS | VARCHAR2 | (20) | ||
| LOAD_ERROR_MESSAGE | VARCHAR2 | (2000) | ||
| PROMOTION_ID | NUMBER | |||
| PROMOTION_CODE | VARCHAR2 | (50) | ||
| CUSTOMER_ID | NUMBER | (15) | ||
| CUSTOMER_NAME | VARCHAR2 | (255) | ||
| CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
| CUSTOMER_STATUS | VARCHAR2 | (1) | ||
| CUSTOMER_TYPE | VARCHAR2 | (30) | ||
| CUSTOMER_PROSPECT_CODE | VARCHAR2 | (30) | ||
| CUSTOMER_CLASS_CODE | VARCHAR2 | (30) | ||
| SALES_CHANNEL_CODE | VARCHAR2 | (30) | ||
| SIC_CODE | VARCHAR2 | (30) | ||
| ANALYSIS_FY | VARCHAR2 | (5) | ||
| CUSTOMER_CATEGORY_CODE | VARCHAR2 | (30) | ||
| CUSTOMER_GROUP_CODE | VARCHAR2 | (30) | ||
| CUSTOMER_KEY | VARCHAR2 | (500) | ||
| CUSTOMER_SUBGROUP_CODE | VARCHAR2 | (30) | ||
| FISCAL_YEAREND_MONTH | VARCHAR2 | (30) | ||
| NET_WORTH | NUMBER | |||
| NUM_OF_EMPLOYEES | NUMBER | (15) | ||
| POTENTIAL_REVENUE_CURR_FY | NUMBER | |||
| POTENTIAL_REVENUE_NEXT_FY | NUMBER | |||
| CUSTOMER_RANK | VARCHAR2 | (30) | ||
| REFERENCE_USE_FLAG | VARCHAR2 | (1) | ||
| TAX_CODE | VARCHAR2 | (50) | ||
| TAX_REFERENCE | VARCHAR2 | (50) | ||
| THIRD_PARTY_FLAG | VARCHAR2 | (1) | ||
| COMPETITOR_FLAG | VARCHAR2 | (1) | ||
| YEAR_ESTABLISHED | NUMBER | (4) | ||
| ADDR_DO_NOT_MAIL_FLAG | VARCHAR2 | (1) | ||
| URL | VARCHAR2 | (2000) | ||
| ADDRESS_ID | NUMBER | (15) | ||
| CONT_DO_NOT_MAIL_FLAG | VARCHAR2 | (1) | ||
| ADDRESS_STATUS | VARCHAR2 | (1) | ||
| COUNTRY | VARCHAR2 | (60) | ||
| ADDRESS1 | VARCHAR2 | (240) | ||
| ADDRESS2 | VARCHAR2 | (240) | ||
| ADDRESS3 | VARCHAR2 | (240) | ||
| ADDRESS4 | VARCHAR2 | (240) | ||
| CITY | VARCHAR2 | (60) | ||
| POSTAL_CODE | VARCHAR2 | (60) | ||
| STATE | VARCHAR2 | (60) | ||
| PROVINCE | VARCHAR2 | (60) | ||
| COUNTY | VARCHAR2 | (60) | ||
| SITE_CONTACT_ID | NUMBER | (15) | ||
| EMAIL_ADDRESS | VARCHAR2 | (240) | ||
| SEX_CODE | VARCHAR2 | (30) | ||
| SALUTATION | VARCHAR2 | (60) | ||
| LAST_NAME | VARCHAR2 | (50) | ||
| TITLE | VARCHAR2 | (40) | ||
| FIRST_NAME | VARCHAR2 | (40) | ||
| JOB_TITLE | VARCHAR2 | (100) | ||
| PHONE_ID | NUMBER | |||
| PHONE_NUMBER | VARCHAR2 | (25) | ||
| PHONE_STATUS | VARCHAR2 | (1) | ||
| PHONE_TYPE | VARCHAR2 | (30) | ||
| AREA_CODE | VARCHAR2 | (10) | ||
| EXTENSION | VARCHAR2 | (20) | ||
| LEAD_NUMBER | VARCHAR2 | (30) | ||
| STATUS_CODE | VARCHAR2 | (30) | ||
| SOURCE_PROMOTION_ID | NUMBER | |||
| INITIATING_CONTACT_ID | NUMBER | |||
| CONTACT_ROLE_CODE | VARCHAR2 | (30) | ||
| CHANNEL_CODE | VARCHAR2 | (30) | ||
| BUDGET_AMOUNT | NUMBER | |||
| BUDGET_STATUS_CODE | VARCHAR2 | (30) | ||
| CURRENCY_CODE | VARCHAR2 | (15) | ||
| DECISION_TIMEFRAME_CODE | VARCHAR2 | (30) | ||
| CLOSE_REASON | VARCHAR2 | (30) | ||
| LEAD_RANK_CODE | VARCHAR2 | (30) | ||
| PARENT_PROJECT | VARCHAR2 | (80) | ||
| DESCRIPTION | VARCHAR2 | (2000) | ||
| STATUS_CODE_1 | VARCHAR2 | (30) | ||
| INTEREST_TYPE_ID_1 | NUMBER | |||
| PRIMARY_INTEREST_CODE_ID_1 | NUMBER | |||
| SECONDARY_INTEREST_CODE_ID_1 | NUMBER | |||
| INVENTORY_ITEM_ID_1 | NUMBER | |||
| ORGANIZATION_ID_1 | NUMBER | |||
| UOM_CODE_1 | VARCHAR2 | (3) | ||
| QUANTITY_1 | NUMBER | |||
| BUDGET_AMOUNT_1 | NUMBER | |||
| STATUS_CODE_2 | VARCHAR2 | (30) | ||
| INTEREST_TYPE_ID_2 | NUMBER | |||
| PRIMARY_INTEREST_CODE_ID_2 | NUMBER | |||
| SECONDARY_INTEREST_CODE_ID_2 | NUMBER | |||
| INVENTORY_ITEM_ID_2 | NUMBER | |||
| ORGANIZATION_ID_2 | NUMBER | |||
| UOM_CODE_2 | VARCHAR2 | (3) | ||
| QUANTITY_2 | NUMBER | |||
| BUDGET_AMOUNT_2 | NUMBER | |||
| STATUS_CODE_3 | VARCHAR2 | (30) | ||
| INTEREST_TYPE_ID_3 | NUMBER | |||
| PRIMARY_INTEREST_CODE_ID_3 | NUMBER | |||
| SECONDARY_INTEREST_CODE_ID_3 | NUMBER | |||
| INVENTORY_ITEM_ID_3 | NUMBER | |||
| ORGANIZATION_ID_3 | NUMBER | |||
| UOM_CODE_3 | VARCHAR2 | (3) | ||
| QUANTITY_3 | NUMBER | |||
| BUDGET_AMOUNT_3 | NUMBER | |||
| STATUS_CODE_4 | VARCHAR2 | (30) | ||
| INTEREST_TYPE_ID_4 | NUMBER | |||
| PRIMARY_INTEREST_CODE_ID_4 | NUMBER | |||
| SECONDARY_INTEREST_CODE_ID_4 | NUMBER | |||
| INVENTORY_ITEM_ID_4 | NUMBER | |||
| ORGANIZATION_ID_4 | NUMBER | |||
| UOM_CODE_4 | VARCHAR2 | (3) | ||
| QUANTITY_4 | NUMBER | |||
| BUDGET_AMOUNT_4 | NUMBER | |||
| STATUS_CODE_5 | VARCHAR2 | (30) | ||
| INTEREST_TYPE_ID_5 | NUMBER | |||
| PRIMARY_INTEREST_CODE_ID_5 | NUMBER | |||
| SECONDARY_INTEREST_CODE_ID_5 | NUMBER | |||
| INVENTORY_ITEM_ID_5 | NUMBER | |||
| ORGANIZATION_ID_5 | NUMBER | |||
| UOM_CODE_5 | VARCHAR2 | (3) | ||
| QUANTITY_5 | NUMBER | |||
| BUDGET_AMOUNT_5 | NUMBER | |||
| INTERACTION_NOTES_1 | VARCHAR2 | (2000) | ||
| PRIORITY_1 | NUMBER | (3) | ||
| TODO_DATE_1 | DATE | |||
| TODO_START_TIME_1 | VARCHAR2 | (5) | ||
| ACTIVITY_CODE_1 | VARCHAR2 | (30) | ||
| INTERACTION_NOTES_2 | VARCHAR2 | (2000) | ||
| PRIORITY_2 | NUMBER | (3) | ||
| TODO_DATE_2 | DATE | |||
| TODO_START_TIME_2 | VARCHAR2 | (5) | ||
| ACTIVITY_CODE_2 | VARCHAR2 | (30) | ||
| INTERACTION_NOTES_3 | VARCHAR2 | (2000) | ||
| PRIORITY_3 | NUMBER | (3) | ||
| TODO_DATE_3 | DATE | |||
| TODO_START_TIME_3 | VARCHAR2 | (5) | ||
| ACTIVITY_CODE_3 | VARCHAR2 | (30) | ||
| INTERACTION_NOTES_4 | VARCHAR2 | (2000) | ||
| PRIORITY_4 | NUMBER | (3) | ||
| TODO_DATE_4 | DATE | |||
| TODO_START_TIME_4 | VARCHAR2 | (5) | ||
| ACTIVITY_CODE_4 | VARCHAR2 | (30) | ||
| INTERACTION_NOTES_5 | VARCHAR2 | (2000) | ||
| PRIORITY_5 | NUMBER | (3) | ||
| TODO_DATE_5 | DATE | |||
| TODO_START_TIME_5 | VARCHAR2 | (5) | ||
| ACTIVITY_CODE_5 | VARCHAR2 | (30) | ||
| INTERACTION_NOTES_6 | VARCHAR2 | (2000) | ||
| PRIORITY_6 | NUMBER | (3) | ||
| TODO_DATE_6 | DATE | |||
| TODO_START_TIME_6 | VARCHAR2 | (5) | ||
| ACTIVITY_CODE_6 | VARCHAR2 | (30) | ||
| INTERACTION_NOTES_7 | VARCHAR2 | (2000) | ||
| PRIORITY_7 | NUMBER | (3) | ||
| TODO_DATE_7 | DATE | |||
| TODO_START_TIME_7 | VARCHAR2 | (5) | ||
| ACTIVITY_CODE_7 | VARCHAR2 | (30) | ||
| INTERACTION_NOTES_8 | VARCHAR2 | (2000) | ||
| PRIORITY_8 | NUMBER | (3) | ||
| TODO_DATE_8 | DATE | |||
| TODO_START_TIME_8 | VARCHAR2 | (5) | ||
| ACTIVITY_CODE_8 | VARCHAR2 | (30) | ||
| INTERACTION_NOTES_9 | VARCHAR2 | (2000) | ||
| PRIORITY_9 | NUMBER | (3) | ||
| TODO_DATE_9 | DATE | |||
| TODO_START_TIME_9 | VARCHAR2 | (5) | ||
| ACTIVITY_CODE_9 | VARCHAR2 | (30) | ||
| INTERACTION_NOTES_10 | VARCHAR2 | (2000) | ||
| PRIORITY_10 | NUMBER | (3) | ||
| TODO_DATE_10 | DATE | |||
| TODO_START_TIME_10 | VARCHAR2 | (5) | ||
| ACTIVITY_CODE_10 | VARCHAR2 | (30) | ||
| LEAD_NOTE | VARCHAR2 | (2000) | ||
| MIDDLE_INITIAL | VARCHAR2 | (10) | ||
| FAX_NUMBER | VARCHAR2 | (25) | ||
| FAX_AREA_CODE | VARCHAR2 | (10) | ||
| MAIL_STOP | VARCHAR2 | (60) | ||
| NUM_ENROLLED | NUMBER | (5) | ||
| CONFIRMED_FLAG | VARCHAR2 | (1) | ||
| PAYMENT_AMOUNT | NUMBER | |||
| NUM_ATTENDED | NUMBER | (5) | ||
| PROMOTION_NAME | VARCHAR2 | (240) | ||
| STATUS_CHANGE_FLAG | VARCHAR2 | (1) | ||
| VEHICLE_RESPONSE_CODE | VARCHAR2 | (30) | ||
| SOURCE_SYSTEM | VARCHAR2 | (30) | ||
| SECURITY_GROUP_ID | NUMBER | |||
| CONTACT_PARTY_ID | NUMBER | |||
| PRM_SALES_LEAD_TYPE | VARCHAR2 | (30) | ||
| PRM_EXEC_SPONSOR_FLAG | VARCHAR2 | (1) | ||
| PRM_PRJ_LEAD_IN_PLACE_FLAG | VARCHAR2 | (1) | ||
| INCUMBENT_PARTNER_PARTY_ID | NUMBER | |||
| INCUMBENT_PARTNER_RESOURCE_ID | NUMBER | |||
| OFFER_ID | NUMBER | |||
| PRM_IND_CLASSIFICATION_CODE | VARCHAR2 | (30) | ||
| PARTY_TYPE | VARCHAR2 | (30) | ||
| BATCH_ID | NUMBER | (15) | ||
| PARTY_ID | NUMBER | (15) | ||
| PARTY_SITE_ID | NUMBER | (15) | ||
| LOCATION_ID | NUMBER | (15) | ||
| REL_PARTY_ID | NUMBER | (15) | ||
| SALES_LEAD_ID | NUMBER | (15) | ||
| ADDRESS_KEY | VARCHAR2 | (500) | ||
| CONTACT_KEY | VARCHAR2 | (80) | ||
| JOB_TITLE_CODE | VARCHAR2 | (30) | ||
| DO_NOT_PHONE_FLAG | VARCHAR2 | (1) | ||
| DO_NOT_FAX_FLAG | VARCHAR2 | (1) | ||
| DO_NOT_EMAIL_FLAG | VARCHAR2 | (1) | ||
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | ||
| LEAD_RANK_ID | NUMBER | (15) | ||
| NEW_PARTY_FLAG | NUMBER | (1) | ||
| NEW_LOC_FLAG | NUMBER | (1) | ||
| NEW_PS_FLAG | NUMBER | (1) | ||
| NEW_REL_FLAG | NUMBER | (1) | ||
| NEW_CON_FLAG | NUMBER | (1) | ||
| ORIG_SYSTEM_CODE | VARCHAR2 | (30) | ||
| SOURCE_PROMOTION_ID_1 | NUMBER | |||
| OFFER_ID_1 | NUMBER | |||
| SOURCE_PROMOTION_ID_2 | NUMBER | |||
| OFFER_ID_2 | NUMBER | |||
| SOURCE_PROMOTION_ID_3 | NUMBER | |||
| OFFER_ID_3 | NUMBER | |||
| SOURCE_PROMOTION_ID_4 | NUMBER | |||
| OFFER_ID_4 | NUMBER | |||
| SOURCE_PROMOTION_ID_5 | NUMBER | |||
| OFFER_ID_5 | NUMBER | |||
| URGENT_FLAG | VARCHAR2 | (1) | ||
| ACCEPT_FLAG | VARCHAR2 | (1) | ||
| ASSIGN_DATE | DATE | |||
| ASSIGN_SALES_GROUP_ID | NUMBER | |||
| ASSIGN_TO_PERSON_ID | NUMBER | |||
| ASSIGN_TO_SALESFORCE_ID | NUMBER | |||
| AUTO_ASSIGNMENT_TYPE | VARCHAR2 | (30) | ||
| DELETED_FLAG | VARCHAR2 | (1) | ||
| IMPORT_FLAG | VARCHAR2 | (1) | ||
| KEEP_FLAG | VARCHAR2 | (1) | ||
| PRM_ASSIGNMENT_TYPE | VARCHAR2 | (30) | ||
| QUALIFIED_FLAG | VARCHAR2 | (1) | ||
| REJECT_REASON_CODE | VARCHAR2 | (30) | ||
| SCORECARD_ID | NUMBER | |||
| LEAD_CONTACT_ID | NUMBER | |||
| PRIMARY_CONTACT_FLAG | VARCHAR2 | (1) | ||
| ADDRESS_EFFECTIVE_DATE | DATE | |||
| ADDRESS_LINES_PHONETIC | VARCHAR2 | (560) | ||
| ADDRESS_STYLE | VARCHAR2 | (30) | ||
| CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | ||
| LOC_DESCRIPTION | VARCHAR2 | (2000) | ||
| LOC_HIERARCHY_ID | NUMBER | (15) | ||
| FA_LOCATION_ID | NUMBER | |||
| FLOOR | VARCHAR2 | (50) | ||
| HOUSE_NUMBER | VARCHAR2 | (50) | ||
| LANGUAGE | VARCHAR2 | (4) | ||
| LOCATION_DIRECTIONS | VARCHAR2 | (640) | ||
| PO_BOX_NUMBER | VARCHAR2 | (50) | ||
| POSITION | VARCHAR2 | (50) | ||
| POSTAL_PLUS4_CODE | VARCHAR2 | (10) | ||
| SALES_TAX_GEOCODE | VARCHAR2 | (30) | ||
| SALES_TAX_INSIDE_CITY_LIMITS | VARCHAR2 | (30) | ||
| SHORT_DESCRIPTION | VARCHAR2 | (240) | ||
| STREET | VARCHAR2 | (50) | ||
| STREET_NUMBER | VARCHAR2 | (50) | ||
| STREET_SUFFIX | VARCHAR2 | (50) | ||
| SUITE | VARCHAR2 | (50) | ||
| TIME_ZONE | VARCHAR2 | (50) | ||
| LOC_VALIDATED_FLAG | VARCHAR2 | (1) | ||
| DUNS_NUMBER | NUMBER | |||
| GROUP_TYPE | VARCHAR2 | (30) | ||
| GSA_INDICATOR_FLAG | VARCHAR2 | (1) | ||
| HQ_BRANCH_IND | VARCHAR2 | (30) | ||
| JGZZ_FISCAL_CODE | VARCHAR2 | (20) | ||
| KNOWN_AS | VARCHAR2 | (240) | ||
| KNOWN_AS2 | VARCHAR2 | (240) | ||
| KNOWN_AS3 | VARCHAR2 | (240) | ||
| KNOWN_AS4 | VARCHAR2 | (240) | ||
| KNOWN_AS5 | VARCHAR2 | (240) | ||
| LANGUAGE_NAME | VARCHAR2 | (30) | ||
| LAST_ORDERED_DATE | DATE | |||
| MISSION_STATEMENT | VARCHAR2 | (2000) | ||
| ORGANIZATION_NAME_PHONETIC | VARCHAR2 | (320) | ||
| PARTY_NUMBER | VARCHAR2 | (30) | ||
| PERSON_FIRST_NAME_PHONETIC | VARCHAR2 | (60) | ||
| PERSON_IDEN_TYPE | VARCHAR2 | (30) | ||
| PERSON_IDENTIFIER | VARCHAR2 | (60) | ||
| PERSON_LAST_NAME_PHONETIC | VARCHAR2 | (60) | ||
| PERSON_NAME_SUFFIX | VARCHAR2 | (30) | ||
| PERSON_PREVIOUS_LAST_NAME | VARCHAR2 | (150) | ||
| PARTY_REFERENCE_USE_FLAG | VARCHAR2 | (1) | ||
| SIC_CODE_TYPE | VARCHAR2 | (30) | ||
| TAX_NAME | VARCHAR2 | (60) | ||
| TOTAL_NUM_OF_ORDERS | NUMBER | |||
| TOTAL_ORDERED_AMOUNT | NUMBER | |||
| PARTIES_VALIDATED_FLAG | VARCHAR2 | (1) | ||
| PS_USES_COMMENTS | VARCHAR2 | (240) | ||
| PRIMARY_PER_TYPE | VARCHAR2 | (1) | ||
| SITE_USE_TYPE | VARCHAR2 | (30) | ||
| ADDRESSEE | VARCHAR2 | (360) | ||
| MAILSTOP | VARCHAR2 | (60) | ||
| PARTY_SITE_NAME | VARCHAR2 | (240) | ||
| PARTY_SITE_NUMBER | VARCHAR2 | (30) | ||
| ORG_CNT_COMMENTS | VARCHAR2 | (240) | ||
| CONTACT_NUMBER | VARCHAR2 | (30) | ||
| DECISION_MAKER_FLAG | VARCHAR2 | (1) | ||
| DEPARTMENT | VARCHAR2 | (60) | ||
| DEPARTMENT_CODE | VARCHAR2 | (30) | ||
| RANK | VARCHAR2 | (30) | ||
| ORG_CNT_TITLE | VARCHAR2 | (30) | ||
| ROLE_LEVEL | VARCHAR2 | (30) | ||
| PRIMARY_CONTACT_PER_ROLE_TYPE | VARCHAR2 | (1) | ||
| CNT_PNT_CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | ||
| PHONE_COUNTRY_CODE | VARCHAR2 | (30) | ||
| FAX_COUNTRY_CODE | VARCHAR2 | (30) | ||
| PHONE_CALLING_CALENDAR | VARCHAR2 | (30) | ||
| CNT_PNT_TIME_ZONE | NUMBER | |||
| RAW_PHONE_NUMBER | VARCHAR2 | (60) | ||
| EMAIL_FORMAT | VARCHAR2 | (30) | ||
| FAX_EXTENSION | VARCHAR2 | (20) | ||
| MARKETING_SCORE | NUMBER | (10) | ||
| LEAD_DATE | DATE | |||
| PERSON_INITIALS | VARCHAR2 | (6) | ||
| NOTE_TYPE | VARCHAR2 | (30) | ||
| INTERACTION_SCORE | NUMBER | |||
| SOURCE_PRIMARY_REFERENCE | VARCHAR2 | (240) | ||
| SOURCE_SECONDARY_REFERENCE | VARCHAR2 | (240) | ||
| CATEGORY_ID_1 | NUMBER | |||
| CATEGORY_ID_2 | NUMBER | |||
| CATEGORY_ID_3 | NUMBER | |||
| CATEGORY_ID_4 | NUMBER | |||
| CATEGORY_ID_5 | NUMBER | |||
| SALES_METHODOLOGY_ID | NUMBER | |||
| DUNS_NUMBER_C | VARCHAR2 | (30) | ||
| CHILD_REQUEST_ID | NUMBER |
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
APPS
AS_IMPORT_INTERFACE
|
|
|
|