VIEW: OSM.AS_IMPORT_INTERFACE#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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