[Home] [Help]
View: AMS_LEAD_MAPPING_V
| Product: | AMS - Marketing |
|---|
| Description: | This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file. |
|---|
| Implementation/DBA Data: |
 APPS.AMS_LEAD_MAPPING_V
|
|---|
View Text
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
Columns
| IMPORT_SOURCE_LINE_ID |
| IMPORT_LIST_HEADER_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_LOGIN |
| LOAD_STATUS |
| IMPORT_SUCCESSFUL_FLAG |
| OBJECT_VERSION_NUMBER |
| SOURCE_SYSTEM |
| IMP_LIST_HEADER_NUMBER |
| LEAD_NOTE |
| PROMOTION_CODE |
| CUSTOMER_NAME |
| SIC_CODE |
| ANALYSIS_FY |
| CUSTOMER_CATEGORY_CODE |
| FISCAL_YEAREND_MONTH |
| NUM_OF_EMPLOYEES |
| POTENTIAL_REVENUE_CURR_FY |
| POTENTIAL_REVENUE_NEXT_FY |
| CUSTOMER_RANK |
| TAX_REFERENCE |
| YEAR_ESTABLISHED |
| ADDR_DO_NOT_MAIL_FLAG |
| URL |
| CONT_DO_NOT_MAIL_FLAG |
| COUNTRY |
| ADDRESS1 |
| ADDRESS2 |
| ADDRESS3 |
| ADDRESS4 |
| CITY |
| POSTAL_CODE |
| STATE |
| PROVINCE |
| COUNTY |
| EMAIL_ADDRESS |
| SEX_CODE |
| SALUTATION |
| LAST_NAME |
| TITLE |
| FIRST_NAME |
| JOB_TITLE |
| PHONE_NUMBER |
| PHONE_STATUS |
| PHONE_TYPE |
| AREA_CODE |
| EXTENSION |
| MIDDLE_INITIAL |
| JOB_TITLE_CODE |
| MAIL_STOP |
| FAX_NUMBER |
| FAX_AREA_CODE |
| DO_NOT_EMAIL_FLAG |
| DO_NOT_FAX_FLAG |
| DO_NOT_PHONE_FLAG |
| CONTACT_ROLE_CODE |
| CHANNEL_CODE |
| BUDGET_AMOUNT |
| BUDGET_STATUS_CODE |
| CURRENCY_CODE |
| DECISION_TIMEFRAME_CODE |
| CLOSE_REASON |
| PARENT_PROJECT |
| DESCRIPTION |
| VEHICLE_RESPONSE_CODE |
| 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 |
| SOURCE_PROMOTION_ID_1 |
| OFFER_ID_1 |
| 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 |
| SOURCE_PROMOTION_ID_2 |
| OFFER_ID_2 |
| 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 |
| SOURCE_PROMOTION_ID_3 |
| OFFER_ID_3 |
| 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 |
| SOURCE_PROMOTION_ID_4 |
| OFFER_ID_4 |
| 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 |
| SOURCE_PROMOTION_ID_5 |
| OFFER_ID_5 |
| ORIG_SYSTEM_REFERENCE |
| ORIG_SYSTEM_CODE |
| 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 |
| 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 |
| LOCATION_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 |
| PROMOTION_ID |
| 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 |
| ORG_CNT_TITLE |
| OFFER_ID |
| REQUEST_ID |
| PROGRAM_APPLICATION_ID |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |
| LOAD_ERROR_MESSAGE |
| PHONE_ID |
| CONTACT_PARTY_ID |
| SECURITY_GROUP_ID |
| NET_WORTH |
| LEAD_NUMBER |
| PRM_SALES_LEAD_TYPE |
| PRM_EXEC_SPONSOR_FLAG |
| PRM_PRJ_LEAD_IN_PLACE_FLAG |
| INCUMBENT_PARTNER_PARTY_ID |
| INCUMBENT_PARTNER_RESOURCE_ID |
| PRM_IND_CLASSIFICATION_CODE |
| PARTY_TYPE |
| PARTY_ID |
| PARTY_SITE_ID |
| LOCATION_ID |
| REL_PARTY_ID |
| SALES_LEAD_ID |
| CUSTOMER_KEY |
| ADDRESS_KEY |
| CONTACT_KEY |
| NEW_PARTY_FLAG |
| NEW_LOC_FLAG |
| NEW_PS_FLAG |
| NEW_REL_FLAG |
| NEW_CON_FLAG |
| LEAD_RANK_ID |
| MARKETING_SCORE |
| LEAD_DATE |
| PERSON_INITIALS |
| CATEGORY_ID_1 |
| CATEGORY_ID_2 |
| CATEGORY_ID_3 |
| CATEGORY_ID_4 |
| CATEGORY_ID_5 |
| SALES_METHODOLOGY_ID |
| DUNS_NUMBER_C |
| SOURCE_PRIMARY_REFERENCE |
| SOURCE_SECONDARY_REFERENCE |
| NOTE_TYPE |
| BATCH_ID |
| CUSTOM_PROCESSING_STATUS |
| AMS_COL201 |
| AMS_COL202 |
| AMS_COL203 |
| AMS_COL204 |
| AMS_COL205 |
| AMS_COL206 |
| AMS_COL207 |
| AMS_COL208 |
| AMS_COL209 |
| AMS_COL210 |
| AMS_COL211 |
| AMS_COL212 |
| AMS_COL213 |
| AMS_COL214 |
| AMS_COL215 |
| AMS_COL216 |
| AMS_COL217 |
| AMS_COL218 |
| AMS_COL219 |
| AMS_COL220 |
| AMS_COL221 |
| AMS_COL222 |
| AMS_COL223 |
| AMS_COL224 |
| AMS_COL225 |
| AMS_COL226 |
| AMS_COL227 |
| AMS_COL228 |
| AMS_COL229 |
| AMS_COL230 |
| AMS_COL231 |
| AMS_COL232 |
| AMS_COL233 |
| AMS_COL234 |
| AMS_COL235 |
| AMS_COL236 |
| AMS_COL237 |
| AMS_COL238 |
| AMS_COL239 |
| AMS_COL240 |
| AMS_COL241 |
| AMS_COL242 |
| AMS_COL243 |
| AMS_COL244 |
| AMS_COL245 |
| AMS_COL246 |
| AMS_COL247 |
| AMS_COL248 |
| AMS_COL249 |
| AMS_COL250 |
| AMS_COL251 |
| AMS_COL252 |
| AMS_COL253 |
| AMS_COL254 |
| AMS_COL255 |
| AMS_COL256 |
| AMS_COL257 |
| AMS_COL258 |
| AMS_COL259 |
| AMS_COL260 |
| AMS_COL261 |
| AMS_COL262 |
| AMS_COL263 |
| AMS_COL264 |
| AMS_COL265 |
| AMS_COL266 |
| AMS_COL267 |
| AMS_COL268 |
| AMS_COL269 |
| AMS_COL270 |
| AMS_COL271 |
| AMS_COL272 |
| AMS_COL273 |
| AMS_COL274 |
| AMS_COL275 |
| AMS_COL276 |
| AMS_COL277 |
| AMS_COL278 |
| AMS_COL279 |
| AMS_COL280 |
| AMS_COL281 |
| AMS_COL282 |
| AMS_COL283 |
| AMS_COL284 |
| AMS_COL285 |
| AMS_COL286 |
| AMS_COL287 |
| AMS_COL288 |
| AMS_COL289 |
| AMS_COL290 |
| AMS_COL291 |
| AMS_COL292 |
| AMS_COL293 |
| AMS_COL294 |
| AMS_COL295 |
| AMS_COL296 |
| AMS_COL297 |
| AMS_COL298 |
| AMS_COL299 |
| AMS_COL300 |
| AMS_COL301 |
| AMS_COL302 |
| AMS_COL303 |
| AMS_COL304 |
| AMS_COL305 |
| AMS_COL306 |
| AMS_COL307 |
| AMS_COL308 |
| AMS_COL309 |
| AMS_COL310 |
| AMS_COL311 |
| AMS_COL312 |
| AMS_COL313 |
| AMS_COL314 |
| AMS_COL315 |
| AMS_COL316 |
| AMS_COL317 |
| AMS_COL318 |
| AMS_COL319 |
| AMS_COL320 |
| AMS_COL321 |
| AMS_COL322 |
| AMS_COL323 |
| AMS_COL324 |
| AMS_COL325 |
| AMS_COL326 |
| AMS_COL327 |
| AMS_COL328 |
| AMS_COL329 |
| AMS_COL330 |
| AMS_COL331 |
| AMS_COL332 |
| AMS_COL333 |
| AMS_COL334 |
| AMS_COL335 |
| AMS_COL336 |
| AMS_COL337 |
| AMS_COL338 |
| AMS_COL339 |
| AMS_COL340 |
| AMS_COL341 |
| AMS_COL342 |
| AMS_COL343 |
| AMS_COL344 |
| AMS_COL345 |
| AMS_COL346 |
| AMS_COL347 |
| AMS_COL348 |
| AMS_COL349 |
| AMS_COL350 |
| AMS_COL351 |
| AMS_COL352 |
| AMS_COL353 |
| AMS_COL354 |
| AMS_COL355 |
| AMS_COL356 |
| AMS_COL357 |
| AMS_COL358 |
| AMS_COL359 |
| AMS_COL360 |
| AMS_COL361 |
| AMS_COL362 |
| AMS_COL363 |
| AMS_COL364 |
| AMS_COL365 |
| AMS_COL366 |
| AMS_COL367 |
| AMS_COL368 |
| AMS_COL369 |
| AMS_COL370 |
| AMS_COL371 |
| AMS_COL372 |
| AMS_COL373 |
| AMS_COL374 |
| AMS_COL375 |
| AMS_COL376 |
| AMS_COL377 |
| AMS_COL378 |
| AMS_COL379 |
| AMS_COL380 |
| AMS_COL381 |
| AMS_COL382 |
| AMS_COL383 |
| AMS_COL384 |
| AMS_COL385 |
| AMS_COL386 |
| AMS_COL387 |
| AMS_COL388 |
| AMS_COL389 |
| AMS_COL390 |
| AMS_COL391 |
| AMS_COL392 |
| AMS_COL393 |
| AMS_COL394 |
| AMS_COL395 |
| AMS_COL396 |
| AMS_COL397 |
| AMS_COL398 |
| AMS_COL399 |
| AMS_COL400 |
| AMS_COL401 |
| AMS_COL402 |
| AMS_COL403 |
| AMS_COL404 |
| AMS_COL405 |
| AMS_COL406 |
| AMS_COL407 |
| AMS_COL408 |
| AMS_COL409 |
| AMS_COL410 |
| AMS_COL411 |
| AMS_COL412 |
| AMS_COL413 |
| AMS_COL414 |
| AMS_COL415 |
| AMS_COL416 |
| AMS_COL417 |
| AMS_COL418 |
| AMS_COL419 |
| AMS_COL420 |
| AMS_COL421 |
| AMS_COL422 |
| AMS_COL423 |
| AMS_COL424 |
| AMS_COL425 |
| AMS_COL426 |
| AMS_COL427 |
| AMS_COL428 |
| AMS_COL429 |
| AMS_COL430 |
| AMS_COL431 |
| AMS_COL432 |
| AMS_COL433 |
| AMS_COL434 |
| AMS_COL435 |
| AMS_COL436 |
| Name |