[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AMS_IMP_SOURCE_LINES |
|---|---|
| Object Type: | TABLE |
| Owner: | AMS |
| FND Design Data: |  AMS.AMS_IMP_SOURCE_LINES
|
| Subobject Name: | |
| Status: | VALID |
AMS_IMP_SOURCE_LINES stores Persons or Organizations that may become Customers to us later on. This table is usually filled when a list is bought from an external company and should be imported to be part of an marketing activity.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AMS_IMP_SOURCE_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 IMPORT_SOURCE_LINE_ID
|
| AMS_IMP_SOURCE_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
IMPORT_LIST_HEADER_ID
|
| AMS_IMP_SOURCE_LINES_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ADDRESS_KEY
|
| AMS_IMP_SOURCE_LINES_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARTY_LOCATION_ID
|
| AMS_IMP_SOURCE_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DEDUPE_KEY
|
| AMS_IMP_SOURCE_LINES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARTY_ID
|
| AMS_IMP_SOURCE_LINES_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REQUEST_ID
|
| AMS_IMP_SOURCE_LINES_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORG_KEY
IMPORT_LIST_HEADER_ID
|
| AMS_IMP_SOURCE_LINES_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORG_PARTY_ID
|
| AMS_IMP_SOURCE_LINES_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PERSON_KEY
|
| AMS_IMP_SOURCE_LINES_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PERSON_PARTY_ID
|
| AMS_IMP_SOURCE_LINES_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OCONT_PARTY_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| IMPORT_SOURCE_LINE_ID | NUMBER | Yes | Unique Identifier. | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | This column is used for locking purposes. | |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard WHO Column |
| IMPORT_LIST_HEADER_ID | NUMBER | Yes | Reference key to the corresponding import header. | |
| IMPORT_SUCCESSFUL_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the record was successfully processed through business rules. |
| ENABLED_FLAG | VARCHAR2 | (1) | Indicates whether the record is active. | |
| IMPORT_FAILURE_REASON | VARCHAR2 | (4000) | The reason the record failed the business rule processing. | |
| RE_IMPORT_LAST_DONE_DATE | DATE | The date on which the record completed the business processing. | ||
| PARTY_ID | NUMBER | Reference key to the Applications party entity. | ||
| DEDUPE_KEY | VARCHAR2 | (500) | Key used in the de-duplication process. | |
| COL1 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL2 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL3 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL4 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL5 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL6 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL7 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL8 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL9 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL10 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL11 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL12 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL13 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL14 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL15 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL16 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL17 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL18 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL19 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL20 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL21 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL22 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL23 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL24 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL25 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL26 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL27 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL28 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL29 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL30 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL31 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL32 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL33 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL34 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL35 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL36 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL37 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL38 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL39 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL40 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL41 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL42 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL43 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL44 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL45 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL46 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL47 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL48 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL49 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL50 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL51 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL52 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL53 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL54 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL55 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL56 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL57 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL58 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL59 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL60 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL61 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL62 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL63 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL64 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL65 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL66 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL67 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL68 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL69 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL70 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL71 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL72 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL73 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL74 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL75 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL76 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL77 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL78 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL79 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL80 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL81 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL82 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL83 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL84 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL85 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL86 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL87 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL88 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL89 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL90 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL91 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL92 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL93 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL94 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL95 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL96 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL97 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL98 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL99 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL100 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL101 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL102 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL103 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL104 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL105 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL106 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL107 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL108 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL109 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL110 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL111 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL112 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL113 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL114 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL115 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL116 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL117 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL118 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL119 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL120 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL121 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL122 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL123 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL124 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL125 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL126 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL127 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL128 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL129 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL130 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL131 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL132 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL133 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL134 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL135 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL136 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL137 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL138 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL139 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL140 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL141 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL142 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL143 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL144 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL145 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL146 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL147 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL148 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL149 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL150 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL151 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL152 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL153 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL154 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL155 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL156 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL157 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL158 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL159 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL160 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL161 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL162 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL163 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL164 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL165 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL166 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL167 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL168 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL169 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL170 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL171 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL172 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL173 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL174 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL175 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL176 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL177 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL178 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL179 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL180 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL181 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL182 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL183 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL184 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL185 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL186 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL187 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL188 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL189 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL190 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL191 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL192 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL193 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL194 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL195 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL196 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL197 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL198 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL199 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL200 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL201 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL202 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL203 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL204 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL205 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL206 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL207 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL208 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL209 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL210 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL211 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL212 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL213 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL214 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL215 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL216 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL217 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL218 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL219 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL220 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL221 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL222 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL223 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL224 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL225 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL226 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL227 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL228 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL229 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL230 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL231 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL232 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL233 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL234 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL235 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL236 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL237 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL238 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL239 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL240 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL241 | VARCHAR2 | (4000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL242 | VARCHAR2 | (4000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL243 | VARCHAR2 | (4000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL244 | VARCHAR2 | (4000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL245 | VARCHAR2 | (4000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL246 | VARCHAR2 | (4000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL247 | VARCHAR2 | (4000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL248 | VARCHAR2 | (4000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL249 | VARCHAR2 | (4000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| COL250 | VARCHAR2 | (4000) | Generic column used as containers for imported data. Maximum size is 4000 characters. | |
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| DUPLICATE_FLAG | VARCHAR2 | (1) | Duplicate flag, Populated only if the record is duplicate. | |
| CURRENT_USAGE | NUMBER | To store the number of times this entry is used. | ||
| LOAD_STATUS | VARCHAR2 | (30) | Result of the import . | |
| ORGANIZATION_ID | NUMBER | Stores the organization's party id. | ||
| NOTES | VARCHAR2 | (4000) | This column stores the notes. | |
| VEHICLE_RESPONSE_CODE | VARCHAR2 | (30) | Stores the response code | |
| SALES_AGENT_EMAIL_ADDRESS | VARCHAR2 | (2000) | Store the email address. | |
| RESOURCE_ID | NUMBER | Stores the resource ID of sales agent. | ||
| BATCH_ID | NUMBER | Stores the batch_id for the record. | ||
| LOCATION_ID | NUMBER | Stores the location_id for the record. | ||
| CONTACT_POINT_ID | NUMBER | Stores the phone_id | ||
| ORG_KEY | VARCHAR2 | (240) | Stores the organization customer key. | |
| PERSON_KEY | VARCHAR2 | (240) | Stores the customer key for person. | |
| ORG_EXIST | VARCHAR2 | (1) | Stores if the org exists. | |
| ORG_PARTY_ID | NUMBER | Store the party ID for organization. | ||
| OCONT_PARTY_ID | NUMBER | Party ID for org contact. | ||
| OCONT_EXIST | VARCHAR2 | (1) | Stores if the org contact exists. | |
| ADDRESS_KEY | VARCHAR2 | (240) | Stores the address key. | |
| PARTY_LOCATION_ID | NUMBER | Stores the location ID for the party. | ||
| PERSON_PARTY_ID | NUMBER | Stores the party ID for the person. | ||
| PERSON_EXIST | VARCHAR2 | (1) | Stores if the person exists. | |
| REQUEST_ID | NUMBER | Stores the request ID for the record. | ||
| RECORD_PROCESSED | VARCHAR2 | (1) | Indicator to check if the record is processed. | |
| TRANSPOSED_PHONE_NUMBER | VARCHAR2 | (60) | Stores TRANSPOSED_PHONE_NUMBER | |
| COL251 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL252 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL253 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL254 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL255 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL256 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL257 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL258 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL259 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL260 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL261 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL262 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL263 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL264 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL265 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL266 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL267 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL268 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL269 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL270 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL271 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL272 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL273 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL274 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL275 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL276 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL277 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL278 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL279 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL280 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL281 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL282 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL283 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL284 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL285 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL286 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL287 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL288 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL289 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL290 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL291 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL292 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL293 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL294 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL295 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL296 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL297 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL298 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL299 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL300 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL301 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL302 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL303 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL304 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL305 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL306 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL307 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL308 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL309 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL310 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL311 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL312 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL313 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL314 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL315 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL316 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL317 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL318 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL319 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL320 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL321 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL322 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL323 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL324 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL325 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL326 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL327 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL328 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL329 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL330 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL331 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL332 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL333 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL334 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL335 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL336 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL337 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL338 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL339 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL340 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL341 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL342 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL343 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL344 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL345 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL346 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL347 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL348 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL349 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| COL350 | VARCHAR2 | (2000) | Generic column used as containers for imported data. Maximum size is 2000 characters. | |
| CUSTOM_COLUMN1 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN2 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN3 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN4 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN5 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN6 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN7 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN8 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN9 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN10 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN11 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN12 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN13 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN14 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN15 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN16 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN17 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN18 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN19 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN20 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN21 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN22 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN23 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN24 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| CUSTOM_COLUMN25 | VARCHAR2 | (2000) | CUSTOM COLUMNS | |
| ORG_LOCATION_ID | NUMBER | COLUMNS FOR INTERNAL USE. | ||
| ORG_ADDRESS_KEY | VARCHAR2 | (240) | COLUMNS FOR INTERNAL USE. | |
| CUSTOM_PROCESSING_STATUS | VARCHAR2 | (30) | custom processing status. |
Cut, paste (and edit) the following text to query this object:
SELECT IMPORT_SOURCE_LINE_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, IMPORT_LIST_HEADER_ID
, IMPORT_SUCCESSFUL_FLAG
, ENABLED_FLAG
, IMPORT_FAILURE_REASON
, RE_IMPORT_LAST_DONE_DATE
, PARTY_ID
, DEDUPE_KEY
, COL1
, COL2
, COL3
, COL4
, COL5
, COL6
, COL7
, COL8
, COL9
, COL10
, COL11
, COL12
, COL13
, COL14
, COL15
, COL16
, COL17
, COL18
, COL19
, COL20
, COL21
, COL22
, COL23
, COL24
, COL25
, COL26
, COL27
, COL28
, COL29
, COL30
, COL31
, COL32
, COL33
, COL34
, COL35
, COL36
, COL37
, COL38
, COL39
, COL40
, COL41
, COL42
, COL43
, COL44
, COL45
, COL46
, COL47
, COL48
, COL49
, COL50
, COL51
, COL52
, COL53
, COL54
, COL55
, COL56
, COL57
, COL58
, COL59
, COL60
, COL61
, COL62
, COL63
, COL64
, COL65
, COL66
, COL67
, COL68
, COL69
, COL70
, COL71
, COL72
, COL73
, COL74
, COL75
, COL76
, COL77
, COL78
, COL79
, COL80
, COL81
, COL82
, COL83
, COL84
, COL85
, COL86
, COL87
, COL88
, COL89
, COL90
, COL91
, COL92
, COL93
, COL94
, COL95
, COL96
, COL97
, COL98
, COL99
, COL100
, COL101
, COL102
, COL103
, COL104
, COL105
, COL106
, COL107
, COL108
, COL109
, COL110
, COL111
, COL112
, COL113
, COL114
, COL115
, COL116
, COL117
, COL118
, COL119
, COL120
, COL121
, COL122
, COL123
, COL124
, COL125
, COL126
, COL127
, COL128
, COL129
, COL130
, COL131
, COL132
, COL133
, COL134
, COL135
, COL136
, COL137
, COL138
, COL139
, COL140
, COL141
, COL142
, COL143
, COL144
, COL145
, COL146
, COL147
, COL148
, COL149
, COL150
, COL151
, COL152
, COL153
, COL154
, COL155
, COL156
, COL157
, COL158
, COL159
, COL160
, COL161
, COL162
, COL163
, COL164
, COL165
, COL166
, COL167
, COL168
, COL169
, COL170
, COL171
, COL172
, COL173
, COL174
, COL175
, COL176
, COL177
, COL178
, COL179
, COL180
, COL181
, COL182
, COL183
, COL184
, COL185
, COL186
, COL187
, COL188
, COL189
, COL190
, COL191
, COL192
, COL193
, COL194
, COL195
, COL196
, COL197
, COL198
, COL199
, COL200
, COL201
, COL202
, COL203
, COL204
, COL205
, COL206
, COL207
, COL208
, COL209
, COL210
, COL211
, COL212
, COL213
, COL214
, COL215
, COL216
, COL217
, COL218
, COL219
, COL220
, COL221
, COL222
, COL223
, COL224
, COL225
, COL226
, COL227
, COL228
, COL229
, COL230
, COL231
, COL232
, COL233
, COL234
, COL235
, COL236
, COL237
, COL238
, COL239
, COL240
, COL241
, COL242
, COL243
, COL244
, COL245
, COL246
, COL247
, COL248
, COL249
, COL250
, SECURITY_GROUP_ID
, DUPLICATE_FLAG
, CURRENT_USAGE
, LOAD_STATUS
, ORGANIZATION_ID
, NOTES
, VEHICLE_RESPONSE_CODE
, SALES_AGENT_EMAIL_ADDRESS
, RESOURCE_ID
, BATCH_ID
, LOCATION_ID
, CONTACT_POINT_ID
, ORG_KEY
, PERSON_KEY
, ORG_EXIST
, ORG_PARTY_ID
, OCONT_PARTY_ID
, OCONT_EXIST
, ADDRESS_KEY
, PARTY_LOCATION_ID
, PERSON_PARTY_ID
, PERSON_EXIST
, REQUEST_ID
, RECORD_PROCESSED
, TRANSPOSED_PHONE_NUMBER
, COL251
, COL252
, COL253
, COL254
, COL255
, COL256
, COL257
, COL258
, COL259
, COL260
, COL261
, COL262
, COL263
, COL264
, COL265
, COL266
, COL267
, COL268
, COL269
, COL270
, COL271
, COL272
, COL273
, COL274
, COL275
, COL276
, COL277
, COL278
, COL279
, COL280
, COL281
, COL282
, COL283
, COL284
, COL285
, COL286
, COL287
, COL288
, COL289
, COL290
, COL291
, COL292
, COL293
, COL294
, COL295
, COL296
, COL297
, COL298
, COL299
, COL300
, COL301
, COL302
, COL303
, COL304
, COL305
, COL306
, COL307
, COL308
, COL309
, COL310
, COL311
, COL312
, COL313
, COL314
, COL315
, COL316
, COL317
, COL318
, COL319
, COL320
, COL321
, COL322
, COL323
, COL324
, COL325
, COL326
, COL327
, COL328
, COL329
, COL330
, COL331
, COL332
, COL333
, COL334
, COL335
, COL336
, COL337
, COL338
, COL339
, COL340
, COL341
, COL342
, COL343
, COL344
, COL345
, COL346
, COL347
, COL348
, COL349
, COL350
, CUSTOM_COLUMN1
, CUSTOM_COLUMN2
, CUSTOM_COLUMN3
, CUSTOM_COLUMN4
, CUSTOM_COLUMN5
, CUSTOM_COLUMN6
, CUSTOM_COLUMN7
, CUSTOM_COLUMN8
, CUSTOM_COLUMN9
, CUSTOM_COLUMN10
, CUSTOM_COLUMN11
, CUSTOM_COLUMN12
, CUSTOM_COLUMN13
, CUSTOM_COLUMN14
, CUSTOM_COLUMN15
, CUSTOM_COLUMN16
, CUSTOM_COLUMN17
, CUSTOM_COLUMN18
, CUSTOM_COLUMN19
, CUSTOM_COLUMN20
, CUSTOM_COLUMN21
, CUSTOM_COLUMN22
, CUSTOM_COLUMN23
, CUSTOM_COLUMN24
, CUSTOM_COLUMN25
, ORG_LOCATION_ID
, ORG_ADDRESS_KEY
, CUSTOM_PROCESSING_STATUS
FROM AMS.AMS_IMP_SOURCE_LINES;
AMS.AMS_IMP_SOURCE_LINES does not reference any database object
AMS.AMS_IMP_SOURCE_LINES is referenced by following:
APPS
AMS_IMP_SOURCE_LINES
|
|
|
|