DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AMS_HZ_B2B_MAPPING_V

Object Details
Object Name: AMS_HZ_B2B_MAPPING_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_HZ_B2B_MAPPING_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
IMPORT_SOURCE_LINE_ID NUMBER
Yes Unique Identifier.
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.
OBJECT_VERSION_NUMBER NUMBER (9)
This column is used for locking purposes.
ENABLED_FLAG VARCHAR2 (1)
Indicates whether the record is active.
LOAD_STATUS VARCHAR2 (30)
Result of the import .
ORGANIZATION_ID NUMBER

Stores the organization's party id.
PARTY_ID NUMBER

Reference key to the Applications party entity.
PARTY_NAME VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
FISCAL_YEAREND_MONTH VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
DUNS_NUMBER VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
LEGAL_STATUS VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
EMPLOYEES_TOTAL VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
LINE_OF_BUSINESS VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
YEAR_ESTABLISHED VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
TAX_REFERENCE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
CEO_NAME VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_FIRST_NAME VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_MIDDLE_NAME VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_LAST_NAME VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_NAME_SUFFIX VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_NAME_PREFIX VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
BEST_TIME_CONTACT_BEGIN VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
BEST_TIME_CONTACT_END VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
COUNTRY VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS1 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS2 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
CITY VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
COUNTY VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
STATE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PROVINCE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
POSTAL_CODE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
TIME_ZONE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
EMAIL_ADDRESS VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PHONE_COUNTRY_CODE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PHONE_AREA_CODE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PHONE_NUMBER VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PHONE_EXTENTION VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
DEPARTMENT VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
JOB_TITLE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
DECISION_MAKER_FLAG VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
SITE_USE_TYPE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
SIC_CODE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
SIC_CODE_TYPE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
TOTAL_NUM_OF_ORDERS VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
TOTAL_ORDERED_AMOUNT VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
LAST_ORDERED_DATE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ANALYSIS_FY VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
CURR_FY_POTENTIAL_REVENUE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
NEXT_FY_POTENTIAL_REVENUE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
GSA_INDICATOR_FLAG VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
MISSION_STATEMENT VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_NAME_PHONETIC VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
CATEGORY_CODE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
JGZZ_FISCAL_CODE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
TAX_NAME VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS3 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS4 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_LINES_PHONETIC VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
APARTMENT_FLAG VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PO_BOX_NUMBER VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
HOUSE_NUMBER VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
STREET_SUFFIX VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
SECONDARY_SUFFIX_ELENENT VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
STREET VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
RURAL_ROUTE_TYPE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
RURAL_ROUTE_NUMBER VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
STREET_NUMBER VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
FLOOR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
SUITE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
POSTAL_PLUS4_CODE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
OVERSEAS_ADDRESS_FLAG VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
IDENTIFYING_ADDRESS_FLAG VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
DEDUPE_KEY VARCHAR2 (500)
Key used in the de-duplication process.
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_IMP_XML_ELEMENT_ID VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADD_IMP_XML_ELEMENT_ID VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
OCONT_IMP_XML_ELEMENT_ID VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
CP_IMP_XML_ELEMENT_ID VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
EM_IMP_XML_ELEMENT_ID VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_EFFECTIVE_DATE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_EXPIRATION_DATE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ANNUAL_REVENUE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ANNUAL_REVENUE_CURRENCY VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
BRANCH_FLAG VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
BUSINESS_LINE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
BUSINESS_SCOPE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
CHIEF_EXECUTIVE_TITLE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
CONGRESSIONAL_DISTRICT_CODE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
CONTROL_YEAR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
CORPORATION_CLASS VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
CREDIT_SCORE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
CREDIT_SCORE_COMMENTARY VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
CUSTOMER_CATEGORY VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
DB_RATING VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
DATE_OF_BIRTH VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
DATE_OF_DEATH VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
DEBARMENTS_COUNT VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
DEBARTMENTS_DATE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
DECLARED_ETHNICITY VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
DEPARTMENT_INDICATOR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
DESCRIPTION VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
DISADVANTAGED_INDICATOR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ENQUIRY_DUNS VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
EXPORT_INDICATOR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
FAILURE_SCORE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
FAILURE_SCORE_COMMENTARY VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
FAILURE_SCORE_NATL_PERCENTILE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
FAILURE_SCORE_OVERRIDE_CODE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
FISCAL_CODE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
GLOBAL_FAILURE_SCORE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
HEADQUARTER_BRANCH_INDICATOR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
HEAD_OF_HOUSEHOLD_FLAG VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
HOUSEHOLD_SIZE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
IMPORT_INDICATOR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_KNOWN_AS VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_KNOWN_AS2 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_KNOWN_AS3 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_KNOWN_AS4 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_KNOWN_AS5 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_KNOWN_AS VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_KNOWN_AS2 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_KNOWN_AS3 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_KNOWN_AS4 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_KNOWN_AS5 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
LABOR_SURPLUS_INDICATOR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
LOCAL_ACTIVITY_CODE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
LOCAL_ACTIVITY_CODE_TYPE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
LOCATION_DIRECTIONS VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
LOCATION_STATUS VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
MARITAL_STATUS VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
MARITAL_STATUS_EFFECTIVE_DATE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
MINORITY_OWNED_INDICATOR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
MINORITY_OWNED_TYPE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ALIAS VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_TYPE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_URL VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
OUT_OF_BUSINESS_INDICATOR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSONAL_INCOME VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ACADEMIC_TITLE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_FIRST_NAME_PHONETIC VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_LAST_NAME_PHONETIC VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
MIDDLE_NAME_PHONETIC VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_NAME_PHONETIC VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_PREVIOUS_TITLE_NAME VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PLACE_OF_BIRTH VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PREFERRED_NAME VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PRINCIPAL_NAME VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PRINCIPAL_TITLE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PUBLIC_PRIVATE_OWNERSHIP_FLAG VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
RENT_OWNED_INDICATOR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
RENT_OWNER_INDICATOR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
SECOND_TITLE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
SHORT_DESCRIPTION VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
SMALL_BUSINESS_INDICATOR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
TAX_ID VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
WOMAN_OWNED_INDICATOR VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE1 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE2 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE3 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE4 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE5 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE6 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE7 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE8 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE9 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE10 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE11 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE12 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE13 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE14 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORGANIZATION_ATTRIBUTE15 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE1 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE2 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE3 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE4 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE5 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE6 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE7 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE8 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE9 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE10 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE11 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE12 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE13 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE14 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE15 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE1 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE2 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE3 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE4 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE5 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE6 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE7 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE8 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE9 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE10 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE11 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE12 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE13 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE14 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE15 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE1 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE2 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE3 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE4 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE5 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE6 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE7 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE8 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE9 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE10 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE11 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE12 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE13 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE14 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE15 VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
FAX_COUNTRY_CODE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
FAX_AREA_CODE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
FAX_NUMBER VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PERSON_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORG_CONTACT_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ADDRESS_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
PARTY_SITE_USE VARCHAR2 (2000)
Generic column used as containers for imported data. Maximum size is 150 characters.
ORIG_SYSTEM_REFERENCE VARCHAR2 (2000)
RELATIONSHIP_TYPE VARCHAR2 (2000)
RELATIONSHIP_CODE VARCHAR2 (2000)
ORG_KEY VARCHAR2 (240)
PERSON_KEY VARCHAR2 (240)
ORG_EXIST VARCHAR2 (1)
ORG_PARTY_ID NUMBER

OCONT_PARTY_ID NUMBER

OCONT_EXIST VARCHAR2 (1)
ADDRESS_KEY VARCHAR2 (240)
PARTY_LOCATION_ID NUMBER

REQUEST_ID NUMBER

RECORD_PROCESSED VARCHAR2 (1)
TRANSPOSED_PHONE_NUMBER VARCHAR2 (60)
CUSTOM_COLUMN1 VARCHAR2 (2000)
CUSTOM_COLUMN2 VARCHAR2 (2000)
CUSTOM_COLUMN3 VARCHAR2 (2000)
CUSTOM_COLUMN4 VARCHAR2 (2000)
CUSTOM_COLUMN5 VARCHAR2 (2000)
CUSTOM_COLUMN6 VARCHAR2 (2000)
CUSTOM_COLUMN7 VARCHAR2 (2000)
CUSTOM_COLUMN8 VARCHAR2 (2000)
CUSTOM_COLUMN9 VARCHAR2 (2000)
CUSTOM_COLUMN10 VARCHAR2 (2000)
CUSTOM_COLUMN11 VARCHAR2 (2000)
CUSTOM_COLUMN12 VARCHAR2 (2000)
CUSTOM_COLUMN13 VARCHAR2 (2000)
CUSTOM_COLUMN14 VARCHAR2 (2000)
CUSTOM_COLUMN15 VARCHAR2 (2000)
CUSTOM_COLUMN16 VARCHAR2 (2000)
CUSTOM_COLUMN17 VARCHAR2 (2000)
CUSTOM_COLUMN18 VARCHAR2 (2000)
CUSTOM_COLUMN19 VARCHAR2 (2000)
CUSTOM_COLUMN20 VARCHAR2 (2000)
CUSTOM_COLUMN21 VARCHAR2 (2000)
CUSTOM_COLUMN22 VARCHAR2 (2000)
CUSTOM_COLUMN23 VARCHAR2 (2000)
CUSTOM_COLUMN24 VARCHAR2 (2000)
CUSTOM_COLUMN25 VARCHAR2 (2000)
ORG_EMAIL_ADDRESS VARCHAR2 (2000)
ORG_PH_COUNTRY_CODE VARCHAR2 (2000)
ORG_PH_AREA_CODE VARCHAR2 (2000)
ORG_PH_NUMBER VARCHAR2 (2000)
ORG_PH_EXTENSION VARCHAR2 (2000)
ORG_COUNTRY VARCHAR2 (2000)
ORG_ADDRESS1 VARCHAR2 (2000)
ORG_ADDRESS2 VARCHAR2 (2000)
ORG_ADDRESS3 VARCHAR2 (2000)
ORG_ADDRESS4 VARCHAR2 (2000)
ORG_CITY VARCHAR2 (2000)
ORG_COUNTY VARCHAR2 (2000)
ORG_STATE VARCHAR2 (2000)
ORG_PROVINCE VARCHAR2 (2000)
ORG_POSTAL_CODE VARCHAR2 (2000)
ORG_ADDR_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
ORG_ADDR_ATTRIBUTE1 VARCHAR2 (2000)
ORG_ADDR_ATTRIBUTE2 VARCHAR2 (2000)
ORG_ADDR_ATTRIBUTE3 VARCHAR2 (2000)
ORG_ADDR_ATTRIBUTE4 VARCHAR2 (2000)
ORG_ADDR_ATTRIBUTE5 VARCHAR2 (4000)
ORG_ADDR_ATTRIBUTE6 VARCHAR2 (4000)
ORG_ADDR_ATTRIBUTE7 VARCHAR2 (4000)
ORG_ADDR_ATTRIBUTE8 VARCHAR2 (4000)
ORG_ADDR_ATTRIBUTE9 VARCHAR2 (4000)
ORG_ADDR_ATTRIBUTE10 VARCHAR2 (4000)
ORG_ADDR_ATTRIBUTE11 VARCHAR2 (4000)
ORG_ADDR_ATTRIBUTE12 VARCHAR2 (4000)
ORG_ADDR_ATTRIBUTE13 VARCHAR2 (4000)
ORG_ADDR_ATTRIBUTE14 VARCHAR2 (2000)
ORG_ADDR_ATTRIBUTE15 VARCHAR2 (2000)
ORG_ADDR_ATTRIBUTE16 VARCHAR2 (2000)
ORG_ADDR_ATTRIBUTE17 VARCHAR2 (2000)
ORG_ADDR_ATTRIBUTE18 VARCHAR2 (2000)
ORG_ADDR_ATTRIBUTE19 VARCHAR2 (2000)
ORG_ADDR_ATTRIBUTE20 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
ORG_PS_ATTRIBUTE1 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE2 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE3 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE4 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE5 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE6 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE7 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE8 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE9 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE10 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE11 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE12 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE13 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE14 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE15 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE16 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE17 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE18 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE19 VARCHAR2 (2000)
ORG_PS_ATTRIBUTE20 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE1 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE2 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE3 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE4 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE5 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE6 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE7 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE8 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE9 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE10 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE11 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE12 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE13 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE14 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE15 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE16 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE17 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE18 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE19 VARCHAR2 (2000)
ORG_CPS_ATTRIBUTE20 VARCHAR2 (2000)
PHONE_TYPE VARCHAR2 (2000)
ORG_PHONE_TYPE VARCHAR2 (2000)
NATIVE_LANGUAGE VARCHAR2 (2000)
ORG_LOCATION_ID NUMBER

ORG_ADDRESS_KEY VARCHAR2 (240)
ORGANIZATION_ATTRIBUTE16 VARCHAR2 (2000)
ORGANIZATION_ATTRIBUTE17 VARCHAR2 (2000)
ORGANIZATION_ATTRIBUTE18 VARCHAR2 (2000)
ORGANIZATION_ATTRIBUTE19 VARCHAR2 (2000)
ORGANIZATION_ATTRIBUTE20 VARCHAR2 (2000)
ORGANIZATION_ATTRIBUTE21 VARCHAR2 (2000)
ORGANIZATION_ATTRIBUTE22 VARCHAR2 (2000)
ORGANIZATION_ATTRIBUTE23 VARCHAR2 (2000)
ORGANIZATION_ATTRIBUTE24 VARCHAR2 (2000)
PERSON_ATTRIBUTE16 VARCHAR2 (2000)
PERSON_ATTRIBUTE17 VARCHAR2 (2000)
PERSON_ATTRIBUTE18 VARCHAR2 (2000)
PERSON_ATTRIBUTE19 VARCHAR2 (2000)
PERSON_ATTRIBUTE20 VARCHAR2 (2000)
PERSON_ATTRIBUTE21 VARCHAR2 (2000)
PERSON_ATTRIBUTE22 VARCHAR2 (2000)
PERSON_ATTRIBUTE23 VARCHAR2 (2000)
PERSON_ATTRIBUTE24 VARCHAR2 (2000)
ORG_CONTACT_ATTRIBUTE16 VARCHAR2 (2000)
ORG_CONTACT_ATTRIBUTE17 VARCHAR2 (2000)
ORG_CONTACT_ATTRIBUTE18 VARCHAR2 (2000)
ORG_CONTACT_ATTRIBUTE19 VARCHAR2 (2000)
ORG_CONTACT_ATTRIBUTE20 VARCHAR2 (2000)
ORG_CONTACT_ATTRIBUTE21 VARCHAR2 (2000)
ORG_CONTACT_ATTRIBUTE22 VARCHAR2 (2000)
ORG_CONTACT_ATTRIBUTE23 VARCHAR2 (2000)
ORG_CONTACT_ATTRIBUTE24 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE16 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE17 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE18 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE19 VARCHAR2 (2000)
ADDRESS_ATTRIBUTE20 VARCHAR2 (2000)
ORG_PS_PH_COUNTRY_CODE VARCHAR2 (2000)
ORG_PS_PH_AREA_CODE VARCHAR2 (2000)
ORG_PS_PH_NUMBER VARCHAR2 (2000)
ORG_PS_PH_EXTENSION VARCHAR2 (2000)
ORG_PS_PH_TYPE VARCHAR2 (2000)
JOB_TITLE_CODE VARCHAR2 (2000)
CUSTOM_PROCESSING_STATUS VARCHAR2 (30)
AMS_COL201 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL202 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL203 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL204 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL205 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL206 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL207 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL208 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL209 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL210 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL211 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL212 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL213 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL214 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL215 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL216 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL217 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL218 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL219 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL220 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL221 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL222 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL223 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL224 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL225 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL226 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL227 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL228 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL229 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL230 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL231 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL232 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL233 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL234 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL235 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL236 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL237 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL238 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL239 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL240 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL241 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL242 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL243 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL244 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL245 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL246 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL247 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL248 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL249 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL250 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL251 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL252 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL253 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL254 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL255 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL256 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL257 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL258 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL259 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL260 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL261 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL262 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL263 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL264 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL265 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL266 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL267 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL268 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL269 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL270 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL271 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL272 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL273 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL274 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL275 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL276 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL277 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL278 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL279 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL280 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL281 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL282 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL283 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL284 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL285 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL286 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL287 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL288 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL289 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL290 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL291 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL292 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL293 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL294 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL295 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL296 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL297 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL298 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL299 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL300 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL301 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL302 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL303 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL304 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL305 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL306 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL307 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL308 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL309 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL310 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL311 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL312 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL313 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL314 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL315 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL316 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL317 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL318 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL319 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL320 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL321 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL322 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL323 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL324 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL325 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL326 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL327 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL328 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL329 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL330 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL331 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL332 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL333 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL334 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL335 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL336 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL337 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL338 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL339 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL340 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL341 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL342 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL343 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL344 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL345 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL346 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL347 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL348 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL349 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL350 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL351 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL352 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL353 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL354 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL355 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL356 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL357 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL358 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL359 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL360 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL361 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL362 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL363 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL364 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL365 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL366 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL367 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL368 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL369 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL370 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL371 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL372 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL373 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL374 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL375 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL376 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL377 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL378 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL379 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL380 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL381 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL382 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL383 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL384 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL385 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL386 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL387 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL388 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL389 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL390 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL391 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL392 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL393 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL394 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL395 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL396 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL397 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL398 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL399 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL400 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL401 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL402 VARCHAR2 (4000)
Generic column used as containers for imported data. Maximum size is 4000 characters.
AMS_COL403 VARCHAR2 (4000)
AMS_COL404 VARCHAR2 (4000)
AMS_COL405 VARCHAR2 (4000)
AMS_COL406 VARCHAR2 (4000)
AMS_COL407 VARCHAR2 (4000)
AMS_COL408 VARCHAR2 (4000)
AMS_COL409 VARCHAR2 (4000)
AMS_COL410 VARCHAR2 (4000)
AMS_COL411 VARCHAR2 (4000)
AMS_COL412 VARCHAR2 (4000)
AMS_COL413 VARCHAR2 (4000)
AMS_COL414 VARCHAR2 (4000)
AMS_COL415 VARCHAR2 (4000)
AMS_COL416 VARCHAR2 (4000)
AMS_COL417 VARCHAR2 (4000)
AMS_COL418 VARCHAR2 (4000)
AMS_COL419 VARCHAR2 (4000)
AMS_COL420 VARCHAR2 (4000)
AMS_COL421 VARCHAR2 (4000)
AMS_COL422 VARCHAR2 (4000)
AMS_COL423 VARCHAR2 (4000)
AMS_COL424 VARCHAR2 (4000)
AMS_COL425 VARCHAR2 (4000)
AMS_COL426 VARCHAR2 (4000)
AMS_COL427 VARCHAR2 (4000)
AMS_COL428 VARCHAR2 (4000)
AMS_COL429 VARCHAR2 (4000)
AMS_COL430 VARCHAR2 (4000)
AMS_COL431 VARCHAR2 (4000)
AMS_COL432 VARCHAR2 (4000)
AMS_COL433 VARCHAR2 (4000)
AMS_COL434 VARCHAR2 (4000)
AMS_COL435 VARCHAR2 (4000)
AMS_COL436 VARCHAR2 (4000)
AMS_COL437 VARCHAR2 (4000)
AMS_COL438 VARCHAR2 (4000)
AMS_COL439 VARCHAR2 (4000)
AMS_COL440 VARCHAR2 (4000)
AMS_COL441 VARCHAR2 (4000)
AMS_COL442 VARCHAR2 (4000)
AMS_COL443 VARCHAR2 (4000)
AMS_COL444 VARCHAR2 (4000)
AMS_COL445 VARCHAR2 (4000)
AMS_COL446 VARCHAR2 (4000)
AMS_COL447 VARCHAR2 (4000)
AMS_COL448 VARCHAR2 (4000)
AMS_COL449 VARCHAR2 (4000)
AMS_COL450 VARCHAR2 (4000)
AMS_COL451 VARCHAR2 (4000)
AMS_COL452 VARCHAR2 (4000)
AMS_COL453 VARCHAR2 (4000)
AMS_COL454 VARCHAR2 (4000)
AMS_COL455 VARCHAR2 (4000)
AMS_COL456 VARCHAR2 (4000)
AMS_COL457 VARCHAR2 (4000)
AMS_COL458 VARCHAR2 (4000)
AMS_COL459 VARCHAR2 (4000)
AMS_COL460 VARCHAR2 (4000)
AMS_COL461 VARCHAR2 (4000)
AMS_COL462 VARCHAR2 (4000)
AMS_COL463 VARCHAR2 (4000)
AMS_COL464 VARCHAR2 (4000)
AMS_COL465 VARCHAR2 (4000)
AMS_COL466 VARCHAR2 (4000)
AMS_COL467 VARCHAR2 (4000)
AMS_COL468 VARCHAR2 (4000)
AMS_COL469 VARCHAR2 (4000)
AMS_COL470 VARCHAR2 (4000)
AMS_COL471 VARCHAR2 (4000)
AMS_COL472 VARCHAR2 (4000)
AMS_COL473 VARCHAR2 (4000)
AMS_COL474 VARCHAR2 (4000)
AMS_COL475 VARCHAR2 (4000)
AMS_COL476 VARCHAR2 (4000)
AMS_COL477 VARCHAR2 (4000)
AMS_COL478 VARCHAR2 (4000)
AMS_COL479 VARCHAR2 (4000)
AMS_COL480 VARCHAR2 (4000)
AMS_COL481 VARCHAR2 (4000)
AMS_COL482 VARCHAR2 (4000)
AMS_COL483 VARCHAR2 (4000)
AMS_COL484 VARCHAR2 (4000)
AMS_COL485 VARCHAR2 (4000)
AMS_COL486 VARCHAR2 (4000)
AMS_COL487 VARCHAR2 (4000)
AMS_COL488 VARCHAR2 (4000)
AMS_COL489 VARCHAR2 (4000)
AMS_COL490 VARCHAR2 (4000)
AMS_COL491 VARCHAR2 (4000)
AMS_COL492 VARCHAR2 (4000)
AMS_COL493 VARCHAR2 (4000)
AMS_COL494 VARCHAR2 (4000)
AMS_COL495 VARCHAR2 (4000)
AMS_COL496 VARCHAR2 (4000)
AMS_COL497 VARCHAR2 (4000)
AMS_COL498 VARCHAR2 (4000)
AMS_COL499 VARCHAR2 (4000)
AMS_COL500 VARCHAR2 (4000)
AMS_COL501 VARCHAR2 (4000)
AMS_COL502 VARCHAR2 (4000)
AMS_COL503 VARCHAR2 (4000)
AMS_COL504 VARCHAR2 (4000)
AMS_COL505 VARCHAR2 (4000)
AMS_COL506 VARCHAR2 (4000)
AMS_COL507 VARCHAR2 (4000)
AMS_COL508 VARCHAR2 (4000)
AMS_COL509 VARCHAR2 (4000)
AMS_COL510 VARCHAR2 (4000)
AMS_COL511 VARCHAR2 (4000)
AMS_COL512 VARCHAR2 (4000)
AMS_COL513 VARCHAR2 (4000)
AMS_COL514 VARCHAR2 (4000)
AMS_COL515 VARCHAR2 (4000)
AMS_COL516 VARCHAR2 (4000)
AMS_COL517 VARCHAR2 (4000)
AMS_COL518 VARCHAR2 (4000)
AMS_COL519 VARCHAR2 (4000)
AMS_COL520 VARCHAR2 (4000)
AMS_COL521 VARCHAR2 (4000)
AMS_COL522 VARCHAR2 (4000)
AMS_COL523 VARCHAR2 (4000)
AMS_COL524 VARCHAR2 (4000)
AMS_COL525 VARCHAR2 (4000)
AMS_COL526 VARCHAR2 (4000)
AMS_COL527 VARCHAR2 (4000)
AMS_COL528 VARCHAR2 (4000)
AMS_COL529 VARCHAR2 (4000)
AMS_COL530 VARCHAR2 (4000)
AMS_COL531 VARCHAR2 (4000)
AMS_COL532 VARCHAR2 (4000)
AMS_COL533 VARCHAR2 (4000)
AMS_COL534 VARCHAR2 (4000)
AMS_COL535 VARCHAR2 (4000)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT IMPORT_SOURCE_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      IMPORT_LIST_HEADER_ID
,      IMPORT_SUCCESSFUL_FLAG
,      OBJECT_VERSION_NUMBER
,      ENABLED_FLAG
,      LOAD_STATUS
,      ORGANIZATION_ID
,      PARTY_ID
,      PARTY_NAME
,      FISCAL_YEAREND_MONTH
,      DUNS_NUMBER
,      LEGAL_STATUS
,      EMPLOYEES_TOTAL
,      LINE_OF_BUSINESS
,      YEAR_ESTABLISHED
,      TAX_REFERENCE
,      CEO_NAME
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_NAME_PREFIX
,      BEST_TIME_CONTACT_BEGIN
,      BEST_TIME_CONTACT_END
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      CITY
,      COUNTY
,      STATE
,      PROVINCE
,      POSTAL_CODE
,      TIME_ZONE
,      EMAIL_ADDRESS
,      PHONE_COUNTRY_CODE
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      PHONE_EXTENTION
,      DEPARTMENT
,      JOB_TITLE
,      DECISION_MAKER_FLAG
,      SITE_USE_TYPE
,      SIC_CODE
,      SIC_CODE_TYPE
,      TOTAL_NUM_OF_ORDERS
,      TOTAL_ORDERED_AMOUNT
,      LAST_ORDERED_DATE
,      ANALYSIS_FY
,      CURR_FY_POTENTIAL_REVENUE
,      NEXT_FY_POTENTIAL_REVENUE
,      GSA_INDICATOR_FLAG
,      MISSION_STATEMENT
,      ORGANIZATION_NAME_PHONETIC
,      CATEGORY_CODE
,      JGZZ_FISCAL_CODE
,      TAX_NAME
,      ADDRESS3
,      ADDRESS4
,      ADDRESS_LINES_PHONETIC
,      APARTMENT_FLAG
,      PO_BOX_NUMBER
,      HOUSE_NUMBER
,      STREET_SUFFIX
,      SECONDARY_SUFFIX_ELENENT
,      STREET
,      RURAL_ROUTE_TYPE
,      RURAL_ROUTE_NUMBER
,      STREET_NUMBER
,      FLOOR
,      SUITE
,      POSTAL_PLUS4_CODE
,      OVERSEAS_ADDRESS_FLAG
,      IDENTIFYING_ADDRESS_FLAG
,      DEDUPE_KEY
,      NOTES
,      VEHICLE_RESPONSE_CODE
,      SALES_AGENT_EMAIL_ADDRESS
,      RESOURCE_ID
,      BATCH_ID
,      LOCATION_ID
,      CONTACT_POINT_ID
,      ORG_IMP_XML_ELEMENT_ID
,      ADD_IMP_XML_ELEMENT_ID
,      OCONT_IMP_XML_ELEMENT_ID
,      CP_IMP_XML_ELEMENT_ID
,      EM_IMP_XML_ELEMENT_ID
,      ADDRESS_EFFECTIVE_DATE
,      ADDRESS_EXPIRATION_DATE
,      ANNUAL_REVENUE
,      ANNUAL_REVENUE_CURRENCY
,      BRANCH_FLAG
,      BUSINESS_LINE
,      BUSINESS_SCOPE
,      CHIEF_EXECUTIVE_TITLE
,      CONGRESSIONAL_DISTRICT_CODE
,      CONTROL_YEAR
,      CORPORATION_CLASS
,      CREDIT_SCORE
,      CREDIT_SCORE_COMMENTARY
,      CUSTOMER_CATEGORY
,      DB_RATING
,      DATE_OF_BIRTH
,      DATE_OF_DEATH
,      DEBARMENTS_COUNT
,      DEBARTMENTS_DATE
,      DECLARED_ETHNICITY
,      DEPARTMENT_INDICATOR
,      DESCRIPTION
,      DISADVANTAGED_INDICATOR
,      ENQUIRY_DUNS
,      EXPORT_INDICATOR
,      FAILURE_SCORE
,      FAILURE_SCORE_COMMENTARY
,      FAILURE_SCORE_NATL_PERCENTILE
,      FAILURE_SCORE_OVERRIDE_CODE
,      FISCAL_CODE
,      GLOBAL_FAILURE_SCORE
,      HEADQUARTER_BRANCH_INDICATOR
,      HEAD_OF_HOUSEHOLD_FLAG
,      HOUSEHOLD_SIZE
,      IMPORT_INDICATOR
,      ORGANIZATION_KNOWN_AS
,      ORGANIZATION_KNOWN_AS2
,      ORGANIZATION_KNOWN_AS3
,      ORGANIZATION_KNOWN_AS4
,      ORGANIZATION_KNOWN_AS5
,      PERSON_KNOWN_AS
,      PERSON_KNOWN_AS2
,      PERSON_KNOWN_AS3
,      PERSON_KNOWN_AS4
,      PERSON_KNOWN_AS5
,      LABOR_SURPLUS_INDICATOR
,      LOCAL_ACTIVITY_CODE
,      LOCAL_ACTIVITY_CODE_TYPE
,      LOCATION_DIRECTIONS
,      LOCATION_STATUS
,      MARITAL_STATUS
,      MARITAL_STATUS_EFFECTIVE_DATE
,      MINORITY_OWNED_INDICATOR
,      MINORITY_OWNED_TYPE
,      ORGANIZATION_ALIAS
,      ORGANIZATION_TYPE
,      ORGANIZATION_URL
,      OUT_OF_BUSINESS_INDICATOR
,      PERSONAL_INCOME
,      PERSON_ACADEMIC_TITLE
,      PERSON_FIRST_NAME_PHONETIC
,      PERSON_LAST_NAME_PHONETIC
,      MIDDLE_NAME_PHONETIC
,      PERSON_NAME_PHONETIC
,      PERSON_PREVIOUS_TITLE_NAME
,      PLACE_OF_BIRTH
,      PREFERRED_NAME
,      PRINCIPAL_NAME
,      PRINCIPAL_TITLE
,      PUBLIC_PRIVATE_OWNERSHIP_FLAG
,      RENT_OWNED_INDICATOR
,      RENT_OWNER_INDICATOR
,      SECOND_TITLE
,      SHORT_DESCRIPTION
,      SMALL_BUSINESS_INDICATOR
,      TAX_ID
,      WOMAN_OWNED_INDICATOR
,      ORGANIZATION_ATTRIBUTE1
,      ORGANIZATION_ATTRIBUTE2
,      ORGANIZATION_ATTRIBUTE3
,      ORGANIZATION_ATTRIBUTE4
,      ORGANIZATION_ATTRIBUTE5
,      ORGANIZATION_ATTRIBUTE6
,      ORGANIZATION_ATTRIBUTE7
,      ORGANIZATION_ATTRIBUTE8
,      ORGANIZATION_ATTRIBUTE9
,      ORGANIZATION_ATTRIBUTE10
,      ORGANIZATION_ATTRIBUTE11
,      ORGANIZATION_ATTRIBUTE12
,      ORGANIZATION_ATTRIBUTE13
,      ORGANIZATION_ATTRIBUTE14
,      ORGANIZATION_ATTRIBUTE15
,      PERSON_ATTRIBUTE1
,      PERSON_ATTRIBUTE2
,      PERSON_ATTRIBUTE3
,      PERSON_ATTRIBUTE4
,      PERSON_ATTRIBUTE5
,      PERSON_ATTRIBUTE6
,      PERSON_ATTRIBUTE7
,      PERSON_ATTRIBUTE8
,      PERSON_ATTRIBUTE9
,      PERSON_ATTRIBUTE10
,      PERSON_ATTRIBUTE11
,      PERSON_ATTRIBUTE12
,      PERSON_ATTRIBUTE13
,      PERSON_ATTRIBUTE14
,      PERSON_ATTRIBUTE15
,      ORG_CONTACT_ATTRIBUTE1
,      ORG_CONTACT_ATTRIBUTE2
,      ORG_CONTACT_ATTRIBUTE3
,      ORG_CONTACT_ATTRIBUTE4
,      ORG_CONTACT_ATTRIBUTE5
,      ORG_CONTACT_ATTRIBUTE6
,      ORG_CONTACT_ATTRIBUTE7
,      ORG_CONTACT_ATTRIBUTE8
,      ORG_CONTACT_ATTRIBUTE9
,      ORG_CONTACT_ATTRIBUTE10
,      ORG_CONTACT_ATTRIBUTE11
,      ORG_CONTACT_ATTRIBUTE12
,      ORG_CONTACT_ATTRIBUTE13
,      ORG_CONTACT_ATTRIBUTE14
,      ORG_CONTACT_ATTRIBUTE15
,      ADDRESS_ATTRIBUTE1
,      ADDRESS_ATTRIBUTE2
,      ADDRESS_ATTRIBUTE3
,      ADDRESS_ATTRIBUTE4
,      ADDRESS_ATTRIBUTE5
,      ADDRESS_ATTRIBUTE6
,      ADDRESS_ATTRIBUTE7
,      ADDRESS_ATTRIBUTE8
,      ADDRESS_ATTRIBUTE9
,      ADDRESS_ATTRIBUTE10
,      ADDRESS_ATTRIBUTE11
,      ADDRESS_ATTRIBUTE12
,      ADDRESS_ATTRIBUTE13
,      ADDRESS_ATTRIBUTE14
,      ADDRESS_ATTRIBUTE15
,      FAX_COUNTRY_CODE
,      FAX_AREA_CODE
,      FAX_NUMBER
,      ORG_ATTRIBUTE_CATEGORY
,      PERSON_ATTRIBUTE_CATEGORY
,      ORG_CONTACT_ATTRIBUTE_CATEGORY
,      ADDRESS_ATTRIBUTE_CATEGORY
,      PARTY_SITE_USE
,      ORIG_SYSTEM_REFERENCE
,      RELATIONSHIP_TYPE
,      RELATIONSHIP_CODE
,      ORG_KEY
,      PERSON_KEY
,      ORG_EXIST
,      ORG_PARTY_ID
,      OCONT_PARTY_ID
,      OCONT_EXIST
,      ADDRESS_KEY
,      PARTY_LOCATION_ID
,      REQUEST_ID
,      RECORD_PROCESSED
,      TRANSPOSED_PHONE_NUMBER
,      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_EMAIL_ADDRESS
,      ORG_PH_COUNTRY_CODE
,      ORG_PH_AREA_CODE
,      ORG_PH_NUMBER
,      ORG_PH_EXTENSION
,      ORG_COUNTRY
,      ORG_ADDRESS1
,      ORG_ADDRESS2
,      ORG_ADDRESS3
,      ORG_ADDRESS4
,      ORG_CITY
,      ORG_COUNTY
,      ORG_STATE
,      ORG_PROVINCE
,      ORG_POSTAL_CODE
,      ORG_ADDR_ATTRIBUTE_CATEGORY
,      ORG_ADDR_ATTRIBUTE1
,      ORG_ADDR_ATTRIBUTE2
,      ORG_ADDR_ATTRIBUTE3
,      ORG_ADDR_ATTRIBUTE4
,      ORG_ADDR_ATTRIBUTE5
,      ORG_ADDR_ATTRIBUTE6
,      ORG_ADDR_ATTRIBUTE7
,      ORG_ADDR_ATTRIBUTE8
,      ORG_ADDR_ATTRIBUTE9
,      ORG_ADDR_ATTRIBUTE10
,      ORG_ADDR_ATTRIBUTE11
,      ORG_ADDR_ATTRIBUTE12
,      ORG_ADDR_ATTRIBUTE13
,      ORG_ADDR_ATTRIBUTE14
,      ORG_ADDR_ATTRIBUTE15
,      ORG_ADDR_ATTRIBUTE16
,      ORG_ADDR_ATTRIBUTE17
,      ORG_ADDR_ATTRIBUTE18
,      ORG_ADDR_ATTRIBUTE19
,      ORG_ADDR_ATTRIBUTE20
,      ORG_PS_ATTRIBUTE_CATEGORY
,      ORG_PS_ATTRIBUTE1
,      ORG_PS_ATTRIBUTE2
,      ORG_PS_ATTRIBUTE3
,      ORG_PS_ATTRIBUTE4
,      ORG_PS_ATTRIBUTE5
,      ORG_PS_ATTRIBUTE6
,      ORG_PS_ATTRIBUTE7
,      ORG_PS_ATTRIBUTE8
,      ORG_PS_ATTRIBUTE9
,      ORG_PS_ATTRIBUTE10
,      ORG_PS_ATTRIBUTE11
,      ORG_PS_ATTRIBUTE12
,      ORG_PS_ATTRIBUTE13
,      ORG_PS_ATTRIBUTE14
,      ORG_PS_ATTRIBUTE15
,      ORG_PS_ATTRIBUTE16
,      ORG_PS_ATTRIBUTE17
,      ORG_PS_ATTRIBUTE18
,      ORG_PS_ATTRIBUTE19
,      ORG_PS_ATTRIBUTE20
,      ORG_CPS_ATTRIBUTE_CATEGORY
,      ORG_CPS_ATTRIBUTE1
,      ORG_CPS_ATTRIBUTE2
,      ORG_CPS_ATTRIBUTE3
,      ORG_CPS_ATTRIBUTE4
,      ORG_CPS_ATTRIBUTE5
,      ORG_CPS_ATTRIBUTE6
,      ORG_CPS_ATTRIBUTE7
,      ORG_CPS_ATTRIBUTE8
,      ORG_CPS_ATTRIBUTE9
,      ORG_CPS_ATTRIBUTE10
,      ORG_CPS_ATTRIBUTE11
,      ORG_CPS_ATTRIBUTE12
,      ORG_CPS_ATTRIBUTE13
,      ORG_CPS_ATTRIBUTE14
,      ORG_CPS_ATTRIBUTE15
,      ORG_CPS_ATTRIBUTE16
,      ORG_CPS_ATTRIBUTE17
,      ORG_CPS_ATTRIBUTE18
,      ORG_CPS_ATTRIBUTE19
,      ORG_CPS_ATTRIBUTE20
,      PHONE_TYPE
,      ORG_PHONE_TYPE
,      NATIVE_LANGUAGE
,      ORG_LOCATION_ID
,      ORG_ADDRESS_KEY
,      ORGANIZATION_ATTRIBUTE16
,      ORGANIZATION_ATTRIBUTE17
,      ORGANIZATION_ATTRIBUTE18
,      ORGANIZATION_ATTRIBUTE19
,      ORGANIZATION_ATTRIBUTE20
,      ORGANIZATION_ATTRIBUTE21
,      ORGANIZATION_ATTRIBUTE22
,      ORGANIZATION_ATTRIBUTE23
,      ORGANIZATION_ATTRIBUTE24
,      PERSON_ATTRIBUTE16
,      PERSON_ATTRIBUTE17
,      PERSON_ATTRIBUTE18
,      PERSON_ATTRIBUTE19
,      PERSON_ATTRIBUTE20
,      PERSON_ATTRIBUTE21
,      PERSON_ATTRIBUTE22
,      PERSON_ATTRIBUTE23
,      PERSON_ATTRIBUTE24
,      ORG_CONTACT_ATTRIBUTE16
,      ORG_CONTACT_ATTRIBUTE17
,      ORG_CONTACT_ATTRIBUTE18
,      ORG_CONTACT_ATTRIBUTE19
,      ORG_CONTACT_ATTRIBUTE20
,      ORG_CONTACT_ATTRIBUTE21
,      ORG_CONTACT_ATTRIBUTE22
,      ORG_CONTACT_ATTRIBUTE23
,      ORG_CONTACT_ATTRIBUTE24
,      ADDRESS_ATTRIBUTE16
,      ADDRESS_ATTRIBUTE17
,      ADDRESS_ATTRIBUTE18
,      ADDRESS_ATTRIBUTE19
,      ADDRESS_ATTRIBUTE20
,      ORG_PS_PH_COUNTRY_CODE
,      ORG_PS_PH_AREA_CODE
,      ORG_PS_PH_NUMBER
,      ORG_PS_PH_EXTENSION
,      ORG_PS_PH_TYPE
,      JOB_TITLE_CODE
,      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
,      AMS_COL437
,      AMS_COL438
,      AMS_COL439
,      AMS_COL440
,      AMS_COL441
,      AMS_COL442
,      AMS_COL443
,      AMS_COL444
,      AMS_COL445
,      AMS_COL446
,      AMS_COL447
,      AMS_COL448
,      AMS_COL449
,      AMS_COL450
,      AMS_COL451
,      AMS_COL452
,      AMS_COL453
,      AMS_COL454
,      AMS_COL455
,      AMS_COL456
,      AMS_COL457
,      AMS_COL458
,      AMS_COL459
,      AMS_COL460
,      AMS_COL461
,      AMS_COL462
,      AMS_COL463
,      AMS_COL464
,      AMS_COL465
,      AMS_COL466
,      AMS_COL467
,      AMS_COL468
,      AMS_COL469
,      AMS_COL470
,      AMS_COL471
,      AMS_COL472
,      AMS_COL473
,      AMS_COL474
,      AMS_COL475
,      AMS_COL476
,      AMS_COL477
,      AMS_COL478
,      AMS_COL479
,      AMS_COL480
,      AMS_COL481
,      AMS_COL482
,      AMS_COL483
,      AMS_COL484
,      AMS_COL485
,      AMS_COL486
,      AMS_COL487
,      AMS_COL488
,      AMS_COL489
,      AMS_COL490
,      AMS_COL491
,      AMS_COL492
,      AMS_COL493
,      AMS_COL494
,      AMS_COL495
,      AMS_COL496
,      AMS_COL497
,      AMS_COL498
,      AMS_COL499
,      AMS_COL500
,      AMS_COL501
,      AMS_COL502
,      AMS_COL503
,      AMS_COL504
,      AMS_COL505
,      AMS_COL506
,      AMS_COL507
,      AMS_COL508
,      AMS_COL509
,      AMS_COL510
,      AMS_COL511
,      AMS_COL512
,      AMS_COL513
,      AMS_COL514
,      AMS_COL515
,      AMS_COL516
,      AMS_COL517
,      AMS_COL518
,      AMS_COL519
,      AMS_COL520
,      AMS_COL521
,      AMS_COL522
,      AMS_COL523
,      AMS_COL524
,      AMS_COL525
,      AMS_COL526
,      AMS_COL527
,      AMS_COL528
,      AMS_COL529
,      AMS_COL530
,      AMS_COL531
,      AMS_COL532
,      AMS_COL533
,      AMS_COL534
,      AMS_COL535
FROM APPS.AMS_HZ_B2B_MAPPING_V;

Dependencies

[top of page]

APPS.AMS_HZ_B2B_MAPPING_V references the following:

SchemaAPPS
SynonymAMS_IMP_LIST_HEADERS_ALL
SynonymAMS_IMP_SOURCE_LINES
APPS.AMS_HZ_B2B_MAPPING_V is referenced by following:

SchemaAPPS
Package BodyAMS_LISTGENERATION_PKG - show dependent code
Package BodyAMS_LISTIMPORT_PVT - show dependent code
Package BodyAMS_LIST_IMPORT_PUB - show dependent code