VIEW: APPS.AMS_LEAD_MAPPING_V

Source

View Text - Preformatted

SELECT IMPORT_SOURCE_LINE_ID IMPORT_SOURCE_LINE_ID, IMPORT_LIST_HEADER_ID IMPORT_LIST_HEADER_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 , LOAD_STATUS LOAD_STATUS, IMPORT_SUCCESSFUL_FLAG IMPORT_SUCCESSFUL_FLAG, object_version_number object_version_number, COL1 SOURCE_SYSTEM, COL2 IMP_LIST_HEADER_NUMBER, COL243 LEAD_NOTE, COL3 PROMOTION_CODE , COL244 CUSTOMER_NAME , COL4 SIC_CODE , COL5 ANALYSIS_FY , COL6 CUSTOMER_CATEGORY_CODE , COL7 FISCAL_YEAREND_MONTH , COL8 NUM_OF_EMPLOYEES , COL9 POTENTIAL_REVENUE_CURR_FY , COL10 POTENTIAL_REVENUE_NEXT_FY , COL11 CUSTOMER_RANK , COL12 TAX_REFERENCE , COL13 YEAR_ESTABLISHED , COL14 ADDR_DO_NOT_MAIL_FLAG , COL245 URL , COL15 CONT_DO_NOT_MAIL_FLAG , COL246 COUNTRY , COL247 ADDRESS1 , COL248 ADDRESS2 , COL249 ADDRESS3 , COL250 ADDRESS4 , COL16 CITY , COL17 POSTAL_CODE , COL18 STATE , COL19 PROVINCE , COL20 COUNTY , COL21 EMAIL_ADDRESS , COL22 SEX_CODE , COL23 SALUTATION , COL24 LAST_NAME , COL25 TITLE , COL26 FIRST_NAME , COL27 JOB_TITLE , COL28 PHONE_NUMBER , COL29 PHONE_STATUS , COL30 PHONE_TYPE , COL31 AREA_CODE , COL32 EXTENSION , COL33 MIDDLE_INITIAL, COL34 JOB_TITLE_CODE, COL35 MAIL_STOP, COL36 FAX_NUMBER, COL37 FAX_AREA_CODE , COL38 DO_NOT_EMAIL_FLAG, COL39 DO_NOT_FAX_FLAG, COL40 DO_NOT_PHONE_FLAG, COL41 CONTACT_ROLE_CODE, COL42 CHANNEL_CODE, COL43 BUDGET_AMOUNT, COL44 BUDGET_STATUS_CODE, COL45 CURRENCY_CODE, COL46 DECISION_TIMEFRAME_CODE, COL47 CLOSE_REASON, COL48 PARENT_PROJECT, COL49 DESCRIPTION, COL50 VEHICLE_RESPONSE_CODE, COL51 INTEREST_TYPE_ID_1, COL52 PRIMARY_INTEREST_CODE_ID_1, COL53 SECONDARY_INTEREST_CODE_ID_1, COL54 INVENTORY_ITEM_ID_1, COL55 ORGANIZATION_ID_1, COL56 UOM_CODE_1, COL57 QUANTITY_1, COL58 BUDGET_AMOUNT_1, COL59 SOURCE_PROMOTION_ID_1, COL60 OFFER_ID_1, COL61 INTEREST_TYPE_ID_2, COL62 PRIMARY_INTEREST_CODE_ID_2, COL63 SECONDARY_INTEREST_CODE_ID_2, COL64 INVENTORY_ITEM_ID_2, COL65 ORGANIZATION_ID_2, COL66 UOM_CODE_2, COL67 QUANTITY_2, COL68 BUDGET_AMOUNT_2, COL69 SOURCE_PROMOTION_ID_2, COL70 OFFER_ID_2, COL71 INTEREST_TYPE_ID_3, COL72 PRIMARY_INTEREST_CODE_ID_3, COL73 SECONDARY_INTEREST_CODE_ID_3, COL74 INVENTORY_ITEM_ID_3, COL75 ORGANIZATION_ID_3, COL76 UOM_CODE_3, COL77 QUANTITY_3, COL78 BUDGET_AMOUNT_3, COL79 SOURCE_PROMOTION_ID_3, COL80 OFFER_ID_3, COL81 INTEREST_TYPE_ID_4, COL82 PRIMARY_INTEREST_CODE_ID_4, COL83 SECONDARY_INTEREST_CODE_ID_4, COL84 INVENTORY_ITEM_ID_4, COL85 ORGANIZATION_ID_4, COL86 UOM_CODE_4, COL87 QUANTITY_4, COL88 BUDGET_AMOUNT_4, COL89 SOURCE_PROMOTION_ID_4, COL90 OFFER_ID_4, COL91 INTEREST_TYPE_ID_5, COL92 PRIMARY_INTEREST_CODE_ID_5, COL93 SECONDARY_INTEREST_CODE_ID_5, COL94 INVENTORY_ITEM_ID_5, COL95 ORGANIZATION_ID_5, COL96 UOM_CODE_5, COL97 QUANTITY_5, COL98 BUDGET_AMOUNT_5, COL99 SOURCE_PROMOTION_ID_5, COL100 OFFER_ID_5, COL101 ORIG_SYSTEM_REFERENCE, COL102 ORIG_SYSTEM_CODE, COL103 URGENT_FLAG, COL104 ACCEPT_FLAG, COL105 ASSIGN_DATE, COL106 ASSIGN_SALES_GROUP_ID, COL107 ASSIGN_TO_PERSON_ID, COL108 ASSIGN_TO_SALESFORCE_ID, COL109 AUTO_ASSIGNMENT_TYPE, COL110 DELETED_FLAG, COL111 IMPORT_FLAG, COL112 KEEP_FLAG, COL113 PRM_ASSIGNMENT_TYPE, COL114 QUALIFIED_FLAG, COL115 REJECT_REASON_CODE, COL116 SCORECARD_ID, COL117 PRIMARY_CONTACT_FLAG, COL118 ADDRESS_EFFECTIVE_DATE, COL119 ADDRESS_LINES_PHONETIC, COL120 ADDRESS_STYLE, COL121 CONTENT_SOURCE_TYPE, COL122 LOC_DESCRIPTION, COL123 LOC_HIERARCHY_ID, COL124 FA_LOCATION_ID, COL125 FLOOR, COL126 HOUSE_NUMBER, COL127 LANGUAGE, COL128 LOCATION_DIRECTIONS, COL129 PO_BOX_NUMBER, COL130 LOCATION_POSITION, COL131 POSTAL_PLUS4_CODE, COL132 SALES_TAX_GEOCODE, COL133 SALES_TAX_INSIDE_CITY_LIMITS, COL134 SHORT_DESCRIPTION, COL135 STREET, COL136 STREET_NUMBER, COL137 STREET_SUFFIX, COL138 SUITE, COL139 TIME_ZONE, COL140 LOC_VALIDATED_FLAG, COL141 DUNS_NUMBER, COL142 GROUP_TYPE, COL143 GSA_INDICATOR_FLAG, COL144 HQ_BRANCH_IND, COL145 JGZZ_FISCAL_CODE, COL146 KNOWN_AS, COL147 KNOWN_AS2, COL148 KNOWN_AS3, COL149 KNOWN_AS4, COL150 KNOWN_AS5, COL151 LANGUAGE_NAME, COL152 LAST_ORDERED_DATE, COL153 MISSION_STATEMENT, COL154 ORGANIZATION_NAME_PHONETIC, COL155 PARTY_NUMBER, COL156 PERSON_FIRST_NAME_PHONETIC, COL157 PERSON_IDEN_TYPE, COL158 PERSON_IDENTIFIER, COL159 PERSON_LAST_NAME_PHONETIC, COL160 PERSON_NAME_SUFFIX, COL161 PERSON_PREVIOUS_LAST_NAME, COL162 PARTY_REFERENCE_USE_FLAG, COL163 SIC_CODE_TYPE, COL164 TAX_NAME, COL165 TOTAL_NUM_OF_ORDERS, COL166 TOTAL_ORDERED_AMOUNT, COL167 PARTIES_VALIDATED_FLAG, COL168 PS_USES_COMMENTS, COL169 PRIMARY_PER_TYPE, COL170 SITE_USE_TYPE, COL171 ADDRESSEE, COL172 MAILSTOP, COL173 PARTY_SITE_NAME, COL174 PARTY_SITE_NUMBER, COL175 ORG_CNT_COMMENTS, COL176 CONTACT_NUMBER, COL177 DECISION_MAKER_FLAG, COL178 DEPARTMENT, COL179 DEPARTMENT_CODE, COL180 RANK, COL181 PROMOTION_ID, COL182 ROLE_LEVEL, COL183 PRIMARY_CONTACT_PER_ROLE_TYPE, COL184 CNT_PNT_CONTENT_SOURCE_TYPE, COL185 PHONE_COUNTRY_CODE, COL186 FAX_COUNTRY_CODE, COL225 PHONE_CALLING_CALENDAR, COL187 CNT_PNT_TIME_ZONE, COL188 RAW_PHONE_NUMBER, COL189 EMAIL_FORMAT, COL190 FAX_EXTENSION, COL191 ORG_CNT_TITLE, COL192 OFFER_ID, COL193 REQUEST_ID, COL194 PROGRAM_APPLICATION_ID, COL195 PROGRAM_ID, COL196 PROGRAM_UPDATE_DATE, COL197 LOAD_ERROR_MESSAGE, COL198 PHONE_ID, COL199 CONTACT_PARTY_ID, COL200 SECURITY_GROUP_ID, COL201 NET_WORTH, COL202 LEAD_NUMBER, COL203 PRM_SALES_LEAD_TYPE, COL204 PRM_EXEC_SPONSOR_FLAG, COL205 PRM_PRJ_LEAD_IN_PLACE_FLAG, COL206 INCUMBENT_PARTNER_PARTY_ID, COL207 INCUMBENT_PARTNER_RESOURCE_ID, COL208 PRM_IND_CLASSIFICATION_CODE, COL209 PARTY_TYPE, COL210 PARTY_ID, COL211 PARTY_SITE_ID, COL212 LOCATION_ID, COL213 REL_PARTY_ID, COL214 SALES_LEAD_ID, COL215 CUSTOMER_KEY, COL216 ADDRESS_KEY, COL217 CONTACT_KEY, COL218 NEW_PARTY_FLAG, COL219 NEW_LOC_FLAG, COL220 NEW_PS_FLAG, COL221 NEW_REL_FLAG, COL222 NEW_CON_FLAG, COL223 LEAD_RANK_ID, COL224 MARKETING_SCORE, COL225 LEAD_DATE, COL226 PERSON_INITIALS, COL227 CATEGORY_ID_1, COL228 CATEGORY_ID_2, COL229 CATEGORY_ID_3, COL230 CATEGORY_ID_4, COL231 CATEGORY_ID_5, COL232 SALES_METHODOLOGY_ID, COL233 DUNS_NUMBER_C, COL234 SOURCE_PRIMARY_REFERENCE, COL235 SOURCE_SECONDARY_REFERENCE, COL236 NOTE_TYPE, batch_id batch_id, CUSTOM_PROCESSING_STATUS CUSTOM_PROCESSING_STATUS, COL242 AMS_COL201 , COL242 AMS_COL202 , COL242 AMS_COL203 , COL242 AMS_COL204 , COL242 AMS_COL205 , COL242 AMS_COL206 , COL242 AMS_COL207 , COL242 AMS_COL208 , COL242 AMS_COL209 , COL242 AMS_COL210 , COL242 AMS_COL211 , COL242 AMS_COL212 , COL242 AMS_COL213 , COL242 AMS_COL214 , COL242 AMS_COL215 , COL242 AMS_COL216 , COL242 AMS_COL217 , COL242 AMS_COL218 , COL242 AMS_COL219 , COL242 AMS_COL220 , COL242 AMS_COL221 , COL242 AMS_COL222 , COL242 AMS_COL223 , COL242 AMS_COL224 , COL242 AMS_COL225 , COL242 AMS_COL226 , COL242 AMS_COL227 , COL242 AMS_COL228 , COL242 AMS_COL229 , COL242 AMS_COL230 , COL242 AMS_COL231 , COL242 AMS_COL232 , COL242 AMS_COL233 , COL242 AMS_COL234 , COL242 AMS_COL235 , COL242 AMS_COL236 , COL242 AMS_COL237 , COL242 AMS_COL238 , COL242 AMS_COL239 , COL242 AMS_COL240 , COL242 AMS_COL241 , COL242 AMS_COL242 , COL242 AMS_COL243 , COL242 AMS_COL244 , COL242 AMS_COL245 , COL242 AMS_COL246 , COL242 AMS_COL247 , COL242 AMS_COL248 , COL242 AMS_COL249 , COL242 AMS_COL250, COL242 AMS_COL251, COL242 AMS_COL252, COL242 AMS_COL253, COL242 AMS_COL254, COL242 AMS_COL255, COL242 AMS_COL256, COL242 AMS_COL257, COL242 AMS_COL258, COL242 AMS_COL259, COL242 AMS_COL260, COL242 AMS_COL261, COL242 AMS_COL262, COL242 AMS_COL263, COL242 AMS_COL264, COL242 AMS_COL265, COL242 AMS_COL266, COL242 AMS_COL267, COL242 AMS_COL268, COL242 AMS_COL269, COL242 AMS_COL270, COL242 AMS_COL271, COL242 AMS_COL272, COL242 AMS_COL273, COL242 AMS_COL274, COL242 AMS_COL275, COL242 AMS_COL276, COL242 AMS_COL277, COL242 AMS_COL278, COL242 AMS_COL279, COL242 AMS_COL280, COL242 AMS_COL281, COL242 AMS_COL282, COL242 AMS_COL283, COL242 AMS_COL284, COL242 AMS_COL285, COL242 AMS_COL286, COL242 AMS_COL287, COL242 AMS_COL288, COL242 AMS_COL289, COL242 AMS_COL290, COL242 AMS_COL291, COL242 AMS_COL292, COL242 AMS_COL293, COL242 AMS_COL294, COL242 AMS_COL295, COL242 AMS_COL296, COL242 AMS_COL297, COL242 AMS_COL298, COL242 AMS_COL299, COL242 AMS_COL300, COL242 AMS_COL301 , COL242 AMS_COL302 , COL242 AMS_COL303 , COL242 AMS_COL304 , COL242 AMS_COL305 , COL242 AMS_COL306 , COL242 AMS_COL307 , COL242 AMS_COL308 , COL242 AMS_COL309 , COL242 AMS_COL310 , COL242 AMS_COL311 , COL242 AMS_COL312 , COL242 AMS_COL313 , COL242 AMS_COL314 , COL242 AMS_COL315 , COL242 AMS_COL316 , COL242 AMS_COL317 , COL242 AMS_COL318 , COL242 AMS_COL319 , COL242 AMS_COL320 , COL242 AMS_COL321 , COL242 AMS_COL322 , COL242 AMS_COL323 , COL242 AMS_COL324 , COL242 AMS_COL325 , COL242 AMS_COL326 , COL242 AMS_COL327 , COL242 AMS_COL328 , COL242 AMS_COL329 , COL242 AMS_COL330 , COL242 AMS_COL331 , COL242 AMS_COL332 , COL242 AMS_COL333 , COL242 AMS_COL334 , COL242 AMS_COL335 , COL242 AMS_COL336 , COL242 AMS_COL337 , COL242 AMS_COL338 , COL242 AMS_COL339 , COL242 AMS_COL340 , COL242 AMS_COL341 , COL242 AMS_COL342 , COL242 AMS_COL343 , COL242 AMS_COL344 , COL242 AMS_COL345 , COL242 AMS_COL346 , COL242 AMS_COL347 , COL242 AMS_COL348 , COL242 AMS_COL349 , COL242 AMS_COL350, COL242 AMS_COL351, COL242 AMS_COL352, COL242 AMS_COL353, COL242 AMS_COL354, COL242 AMS_COL355, COL242 AMS_COL356, COL242 AMS_COL357, COL242 AMS_COL358, COL242 AMS_COL359, COL242 AMS_COL360, COL242 AMS_COL361, COL242 AMS_COL362, COL242 AMS_COL363, COL242 AMS_COL364, COL242 AMS_COL365, COL242 AMS_COL366, COL242 AMS_COL367, COL242 AMS_COL368, COL242 AMS_COL369, COL242 AMS_COL370, COL242 AMS_COL371, COL242 AMS_COL372, COL242 AMS_COL373, COL242 AMS_COL374, COL242 AMS_COL375, COL242 AMS_COL376, COL242 AMS_COL377, COL242 AMS_COL378, COL242 AMS_COL379, COL242 AMS_COL380, COL242 AMS_COL381, COL242 AMS_COL382, COL242 AMS_COL383, COL242 AMS_COL384, COL242 AMS_COL385, COL242 AMS_COL386, COL242 AMS_COL387, COL242 AMS_COL388, COL242 AMS_COL389, COL242 AMS_COL390, COL242 AMS_COL391, COL242 AMS_COL392, COL242 AMS_COL393, COL242 AMS_COL394, COL242 AMS_COL395, COL242 AMS_COL396, COL242 AMS_COL397, COL242 AMS_COL398, COL242 AMS_COL399, COL242 AMS_COL400, COL242 AMS_COL401, COL242 AMS_COL402, COL242 AMS_COL403, COL242 AMS_COL404, COL242 AMS_COL405, COL242 AMS_COL406, COL242 AMS_COL407, COL242 AMS_COL408, COL242 AMS_COL409, COL242 AMS_COL410, COL242 AMS_COL411, COL242 AMS_COL412, COL242 AMS_COL413, COL242 AMS_COL414, COL242 AMS_COL415, COL242 AMS_COL416, COL242 AMS_COL417, COL242 AMS_COL418, COL242 AMS_COL419, COL242 AMS_COL420, COL242 AMS_COL421, COL242 AMS_COL422, COL242 AMS_COL423, COL242 AMS_COL424, COL242 AMS_COL425, COL242 AMS_COL426, COL242 AMS_COL427, COL242 AMS_COL428, COL242 AMS_COL429, COL242 AMS_COL430, COL242 AMS_COL431, COL242 AMS_COL432, COL242 AMS_COL433, COL242 AMS_COL434, COL242 AMS_COL435, COL242 AMS_COL436 from ams_imp_source_lines

View Text - HTML Formatted

SELECT IMPORT_SOURCE_LINE_ID IMPORT_SOURCE_LINE_ID
, IMPORT_LIST_HEADER_ID IMPORT_LIST_HEADER_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
, LOAD_STATUS LOAD_STATUS
, IMPORT_SUCCESSFUL_FLAG IMPORT_SUCCESSFUL_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, COL1 SOURCE_SYSTEM
, COL2 IMP_LIST_HEADER_NUMBER
, COL243 LEAD_NOTE
, COL3 PROMOTION_CODE
, COL244 CUSTOMER_NAME
, COL4 SIC_CODE
, COL5 ANALYSIS_FY
, COL6 CUSTOMER_CATEGORY_CODE
, COL7 FISCAL_YEAREND_MONTH
, COL8 NUM_OF_EMPLOYEES
, COL9 POTENTIAL_REVENUE_CURR_FY
, COL10 POTENTIAL_REVENUE_NEXT_FY
, COL11 CUSTOMER_RANK
, COL12 TAX_REFERENCE
, COL13 YEAR_ESTABLISHED
, COL14 ADDR_DO_NOT_MAIL_FLAG
, COL245 URL
, COL15 CONT_DO_NOT_MAIL_FLAG
, COL246 COUNTRY
, COL247 ADDRESS1
, COL248 ADDRESS2
, COL249 ADDRESS3
, COL250 ADDRESS4
, COL16 CITY
, COL17 POSTAL_CODE
, COL18 STATE
, COL19 PROVINCE
, COL20 COUNTY
, COL21 EMAIL_ADDRESS
, COL22 SEX_CODE
, COL23 SALUTATION
, COL24 LAST_NAME
, COL25 TITLE
, COL26 FIRST_NAME
, COL27 JOB_TITLE
, COL28 PHONE_NUMBER
, COL29 PHONE_STATUS
, COL30 PHONE_TYPE
, COL31 AREA_CODE
, COL32 EXTENSION
, COL33 MIDDLE_INITIAL
, COL34 JOB_TITLE_CODE
, COL35 MAIL_STOP
, COL36 FAX_NUMBER
, COL37 FAX_AREA_CODE
, COL38 DO_NOT_EMAIL_FLAG
, COL39 DO_NOT_FAX_FLAG
, COL40 DO_NOT_PHONE_FLAG
, COL41 CONTACT_ROLE_CODE
, COL42 CHANNEL_CODE
, COL43 BUDGET_AMOUNT
, COL44 BUDGET_STATUS_CODE
, COL45 CURRENCY_CODE
, COL46 DECISION_TIMEFRAME_CODE
, COL47 CLOSE_REASON
, COL48 PARENT_PROJECT
, COL49 DESCRIPTION
, COL50 VEHICLE_RESPONSE_CODE
, COL51 INTEREST_TYPE_ID_1
, COL52 PRIMARY_INTEREST_CODE_ID_1
, COL53 SECONDARY_INTEREST_CODE_ID_1
, COL54 INVENTORY_ITEM_ID_1
, COL55 ORGANIZATION_ID_1
, COL56 UOM_CODE_1
, COL57 QUANTITY_1
, COL58 BUDGET_AMOUNT_1
, COL59 SOURCE_PROMOTION_ID_1
, COL60 OFFER_ID_1
, COL61 INTEREST_TYPE_ID_2
, COL62 PRIMARY_INTEREST_CODE_ID_2
, COL63 SECONDARY_INTEREST_CODE_ID_2
, COL64 INVENTORY_ITEM_ID_2
, COL65 ORGANIZATION_ID_2
, COL66 UOM_CODE_2
, COL67 QUANTITY_2
, COL68 BUDGET_AMOUNT_2
, COL69 SOURCE_PROMOTION_ID_2
, COL70 OFFER_ID_2
, COL71 INTEREST_TYPE_ID_3
, COL72 PRIMARY_INTEREST_CODE_ID_3
, COL73 SECONDARY_INTEREST_CODE_ID_3
, COL74 INVENTORY_ITEM_ID_3
, COL75 ORGANIZATION_ID_3
, COL76 UOM_CODE_3
, COL77 QUANTITY_3
, COL78 BUDGET_AMOUNT_3
, COL79 SOURCE_PROMOTION_ID_3
, COL80 OFFER_ID_3
, COL81 INTEREST_TYPE_ID_4
, COL82 PRIMARY_INTEREST_CODE_ID_4
, COL83 SECONDARY_INTEREST_CODE_ID_4
, COL84 INVENTORY_ITEM_ID_4
, COL85 ORGANIZATION_ID_4
, COL86 UOM_CODE_4
, COL87 QUANTITY_4
, COL88 BUDGET_AMOUNT_4
, COL89 SOURCE_PROMOTION_ID_4
, COL90 OFFER_ID_4
, COL91 INTEREST_TYPE_ID_5
, COL92 PRIMARY_INTEREST_CODE_ID_5
, COL93 SECONDARY_INTEREST_CODE_ID_5
, COL94 INVENTORY_ITEM_ID_5
, COL95 ORGANIZATION_ID_5
, COL96 UOM_CODE_5
, COL97 QUANTITY_5
, COL98 BUDGET_AMOUNT_5
, COL99 SOURCE_PROMOTION_ID_5
, COL100 OFFER_ID_5
, COL101 ORIG_SYSTEM_REFERENCE
, COL102 ORIG_SYSTEM_CODE
, COL103 URGENT_FLAG
, COL104 ACCEPT_FLAG
, COL105 ASSIGN_DATE
, COL106 ASSIGN_SALES_GROUP_ID
, COL107 ASSIGN_TO_PERSON_ID
, COL108 ASSIGN_TO_SALESFORCE_ID
, COL109 AUTO_ASSIGNMENT_TYPE
, COL110 DELETED_FLAG
, COL111 IMPORT_FLAG
, COL112 KEEP_FLAG
, COL113 PRM_ASSIGNMENT_TYPE
, COL114 QUALIFIED_FLAG
, COL115 REJECT_REASON_CODE
, COL116 SCORECARD_ID
, COL117 PRIMARY_CONTACT_FLAG
, COL118 ADDRESS_EFFECTIVE_DATE
, COL119 ADDRESS_LINES_PHONETIC
, COL120 ADDRESS_STYLE
, COL121 CONTENT_SOURCE_TYPE
, COL122 LOC_DESCRIPTION
, COL123 LOC_HIERARCHY_ID
, COL124 FA_LOCATION_ID
, COL125 FLOOR
, COL126 HOUSE_NUMBER
, COL127 LANGUAGE
, COL128 LOCATION_DIRECTIONS
, COL129 PO_BOX_NUMBER
, COL130 LOCATION_POSITION
, COL131 POSTAL_PLUS4_CODE
, COL132 SALES_TAX_GEOCODE
, COL133 SALES_TAX_INSIDE_CITY_LIMITS
, COL134 SHORT_DESCRIPTION
, COL135 STREET
, COL136 STREET_NUMBER
, COL137 STREET_SUFFIX
, COL138 SUITE
, COL139 TIME_ZONE
, COL140 LOC_VALIDATED_FLAG
, COL141 DUNS_NUMBER
, COL142 GROUP_TYPE
, COL143 GSA_INDICATOR_FLAG
, COL144 HQ_BRANCH_IND
, COL145 JGZZ_FISCAL_CODE
, COL146 KNOWN_AS
, COL147 KNOWN_AS2
, COL148 KNOWN_AS3
, COL149 KNOWN_AS4
, COL150 KNOWN_AS5
, COL151 LANGUAGE_NAME
, COL152 LAST_ORDERED_DATE
, COL153 MISSION_STATEMENT
, COL154 ORGANIZATION_NAME_PHONETIC
, COL155 PARTY_NUMBER
, COL156 PERSON_FIRST_NAME_PHONETIC
, COL157 PERSON_IDEN_TYPE
, COL158 PERSON_IDENTIFIER
, COL159 PERSON_LAST_NAME_PHONETIC
, COL160 PERSON_NAME_SUFFIX
, COL161 PERSON_PREVIOUS_LAST_NAME
, COL162 PARTY_REFERENCE_USE_FLAG
, COL163 SIC_CODE_TYPE
, COL164 TAX_NAME
, COL165 TOTAL_NUM_OF_ORDERS
, COL166 TOTAL_ORDERED_AMOUNT
, COL167 PARTIES_VALIDATED_FLAG
, COL168 PS_USES_COMMENTS
, COL169 PRIMARY_PER_TYPE
, COL170 SITE_USE_TYPE
, COL171 ADDRESSEE
, COL172 MAILSTOP
, COL173 PARTY_SITE_NAME
, COL174 PARTY_SITE_NUMBER
, COL175 ORG_CNT_COMMENTS
, COL176 CONTACT_NUMBER
, COL177 DECISION_MAKER_FLAG
, COL178 DEPARTMENT
, COL179 DEPARTMENT_CODE
, COL180 RANK
, COL181 PROMOTION_ID
, COL182 ROLE_LEVEL
, COL183 PRIMARY_CONTACT_PER_ROLE_TYPE
, COL184 CNT_PNT_CONTENT_SOURCE_TYPE
, COL185 PHONE_COUNTRY_CODE
, COL186 FAX_COUNTRY_CODE
, COL225 PHONE_CALLING_CALENDAR
, COL187 CNT_PNT_TIME_ZONE
, COL188 RAW_PHONE_NUMBER
, COL189 EMAIL_FORMAT
, COL190 FAX_EXTENSION
, COL191 ORG_CNT_TITLE
, COL192 OFFER_ID
, COL193 REQUEST_ID
, COL194 PROGRAM_APPLICATION_ID
, COL195 PROGRAM_ID
, COL196 PROGRAM_UPDATE_DATE
, COL197 LOAD_ERROR_MESSAGE
, COL198 PHONE_ID
, COL199 CONTACT_PARTY_ID
, COL200 SECURITY_GROUP_ID
, COL201 NET_WORTH
, COL202 LEAD_NUMBER
, COL203 PRM_SALES_LEAD_TYPE
, COL204 PRM_EXEC_SPONSOR_FLAG
, COL205 PRM_PRJ_LEAD_IN_PLACE_FLAG
, COL206 INCUMBENT_PARTNER_PARTY_ID
, COL207 INCUMBENT_PARTNER_RESOURCE_ID
, COL208 PRM_IND_CLASSIFICATION_CODE
, COL209 PARTY_TYPE
, COL210 PARTY_ID
, COL211 PARTY_SITE_ID
, COL212 LOCATION_ID
, COL213 REL_PARTY_ID
, COL214 SALES_LEAD_ID
, COL215 CUSTOMER_KEY
, COL216 ADDRESS_KEY
, COL217 CONTACT_KEY
, COL218 NEW_PARTY_FLAG
, COL219 NEW_LOC_FLAG
, COL220 NEW_PS_FLAG
, COL221 NEW_REL_FLAG
, COL222 NEW_CON_FLAG
, COL223 LEAD_RANK_ID
, COL224 MARKETING_SCORE
, COL225 LEAD_DATE
, COL226 PERSON_INITIALS
, COL227 CATEGORY_ID_1
, COL228 CATEGORY_ID_2
, COL229 CATEGORY_ID_3
, COL230 CATEGORY_ID_4
, COL231 CATEGORY_ID_5
, COL232 SALES_METHODOLOGY_ID
, COL233 DUNS_NUMBER_C
, COL234 SOURCE_PRIMARY_REFERENCE
, COL235 SOURCE_SECONDARY_REFERENCE
, COL236 NOTE_TYPE
, BATCH_ID BATCH_ID
, CUSTOM_PROCESSING_STATUS CUSTOM_PROCESSING_STATUS
, COL242 AMS_COL201
, COL242 AMS_COL202
, COL242 AMS_COL203
, COL242 AMS_COL204
, COL242 AMS_COL205
, COL242 AMS_COL206
, COL242 AMS_COL207
, COL242 AMS_COL208
, COL242 AMS_COL209
, COL242 AMS_COL210
, COL242 AMS_COL211
, COL242 AMS_COL212
, COL242 AMS_COL213
, COL242 AMS_COL214
, COL242 AMS_COL215
, COL242 AMS_COL216
, COL242 AMS_COL217
, COL242 AMS_COL218
, COL242 AMS_COL219
, COL242 AMS_COL220
, COL242 AMS_COL221
, COL242 AMS_COL222
, COL242 AMS_COL223
, COL242 AMS_COL224
, COL242 AMS_COL225
, COL242 AMS_COL226
, COL242 AMS_COL227
, COL242 AMS_COL228
, COL242 AMS_COL229
, COL242 AMS_COL230
, COL242 AMS_COL231
, COL242 AMS_COL232
, COL242 AMS_COL233
, COL242 AMS_COL234
, COL242 AMS_COL235
, COL242 AMS_COL236
, COL242 AMS_COL237
, COL242 AMS_COL238
, COL242 AMS_COL239
, COL242 AMS_COL240
, COL242 AMS_COL241
, COL242 AMS_COL242
, COL242 AMS_COL243
, COL242 AMS_COL244
, COL242 AMS_COL245
, COL242 AMS_COL246
, COL242 AMS_COL247
, COL242 AMS_COL248
, COL242 AMS_COL249
, COL242 AMS_COL250
, COL242 AMS_COL251
, COL242 AMS_COL252
, COL242 AMS_COL253
, COL242 AMS_COL254
, COL242 AMS_COL255
, COL242 AMS_COL256
, COL242 AMS_COL257
, COL242 AMS_COL258
, COL242 AMS_COL259
, COL242 AMS_COL260
, COL242 AMS_COL261
, COL242 AMS_COL262
, COL242 AMS_COL263
, COL242 AMS_COL264
, COL242 AMS_COL265
, COL242 AMS_COL266
, COL242 AMS_COL267
, COL242 AMS_COL268
, COL242 AMS_COL269
, COL242 AMS_COL270
, COL242 AMS_COL271
, COL242 AMS_COL272
, COL242 AMS_COL273
, COL242 AMS_COL274
, COL242 AMS_COL275
, COL242 AMS_COL276
, COL242 AMS_COL277
, COL242 AMS_COL278
, COL242 AMS_COL279
, COL242 AMS_COL280
, COL242 AMS_COL281
, COL242 AMS_COL282
, COL242 AMS_COL283
, COL242 AMS_COL284
, COL242 AMS_COL285
, COL242 AMS_COL286
, COL242 AMS_COL287
, COL242 AMS_COL288
, COL242 AMS_COL289
, COL242 AMS_COL290
, COL242 AMS_COL291
, COL242 AMS_COL292
, COL242 AMS_COL293
, COL242 AMS_COL294
, COL242 AMS_COL295
, COL242 AMS_COL296
, COL242 AMS_COL297
, COL242 AMS_COL298
, COL242 AMS_COL299
, COL242 AMS_COL300
, COL242 AMS_COL301
, COL242 AMS_COL302
, COL242 AMS_COL303
, COL242 AMS_COL304
, COL242 AMS_COL305
, COL242 AMS_COL306
, COL242 AMS_COL307
, COL242 AMS_COL308
, COL242 AMS_COL309
, COL242 AMS_COL310
, COL242 AMS_COL311
, COL242 AMS_COL312
, COL242 AMS_COL313
, COL242 AMS_COL314
, COL242 AMS_COL315
, COL242 AMS_COL316
, COL242 AMS_COL317
, COL242 AMS_COL318
, COL242 AMS_COL319
, COL242 AMS_COL320
, COL242 AMS_COL321
, COL242 AMS_COL322
, COL242 AMS_COL323
, COL242 AMS_COL324
, COL242 AMS_COL325
, COL242 AMS_COL326
, COL242 AMS_COL327
, COL242 AMS_COL328
, COL242 AMS_COL329
, COL242 AMS_COL330
, COL242 AMS_COL331
, COL242 AMS_COL332
, COL242 AMS_COL333
, COL242 AMS_COL334
, COL242 AMS_COL335
, COL242 AMS_COL336
, COL242 AMS_COL337
, COL242 AMS_COL338
, COL242 AMS_COL339
, COL242 AMS_COL340
, COL242 AMS_COL341
, COL242 AMS_COL342
, COL242 AMS_COL343
, COL242 AMS_COL344
, COL242 AMS_COL345
, COL242 AMS_COL346
, COL242 AMS_COL347
, COL242 AMS_COL348
, COL242 AMS_COL349
, COL242 AMS_COL350
, COL242 AMS_COL351
, COL242 AMS_COL352
, COL242 AMS_COL353
, COL242 AMS_COL354
, COL242 AMS_COL355
, COL242 AMS_COL356
, COL242 AMS_COL357
, COL242 AMS_COL358
, COL242 AMS_COL359
, COL242 AMS_COL360
, COL242 AMS_COL361
, COL242 AMS_COL362
, COL242 AMS_COL363
, COL242 AMS_COL364
, COL242 AMS_COL365
, COL242 AMS_COL366
, COL242 AMS_COL367
, COL242 AMS_COL368
, COL242 AMS_COL369
, COL242 AMS_COL370
, COL242 AMS_COL371
, COL242 AMS_COL372
, COL242 AMS_COL373
, COL242 AMS_COL374
, COL242 AMS_COL375
, COL242 AMS_COL376
, COL242 AMS_COL377
, COL242 AMS_COL378
, COL242 AMS_COL379
, COL242 AMS_COL380
, COL242 AMS_COL381
, COL242 AMS_COL382
, COL242 AMS_COL383
, COL242 AMS_COL384
, COL242 AMS_COL385
, COL242 AMS_COL386
, COL242 AMS_COL387
, COL242 AMS_COL388
, COL242 AMS_COL389
, COL242 AMS_COL390
, COL242 AMS_COL391
, COL242 AMS_COL392
, COL242 AMS_COL393
, COL242 AMS_COL394
, COL242 AMS_COL395
, COL242 AMS_COL396
, COL242 AMS_COL397
, COL242 AMS_COL398
, COL242 AMS_COL399
, COL242 AMS_COL400
, COL242 AMS_COL401
, COL242 AMS_COL402
, COL242 AMS_COL403
, COL242 AMS_COL404
, COL242 AMS_COL405
, COL242 AMS_COL406
, COL242 AMS_COL407
, COL242 AMS_COL408
, COL242 AMS_COL409
, COL242 AMS_COL410
, COL242 AMS_COL411
, COL242 AMS_COL412
, COL242 AMS_COL413
, COL242 AMS_COL414
, COL242 AMS_COL415
, COL242 AMS_COL416
, COL242 AMS_COL417
, COL242 AMS_COL418
, COL242 AMS_COL419
, COL242 AMS_COL420
, COL242 AMS_COL421
, COL242 AMS_COL422
, COL242 AMS_COL423
, COL242 AMS_COL424
, COL242 AMS_COL425
, COL242 AMS_COL426
, COL242 AMS_COL427
, COL242 AMS_COL428
, COL242 AMS_COL429
, COL242 AMS_COL430
, COL242 AMS_COL431
, COL242 AMS_COL432
, COL242 AMS_COL433
, COL242 AMS_COL434
, COL242 AMS_COL435
, COL242 AMS_COL436
FROM AMS_IMP_SOURCE_LINES