VIEW: IMC.IMC_CSV_INTERFACE_FIELDS#

Source

View Text - Preformatted

select LOAD_ID LOAD_ID, BATCH_ID BATCH_ID, PARTY_REC_ID PARTY_REC_ID, REC_STATUS REC_STATUS, PARTY_TYPE PARTY_TYPE, ORGANIZATION_NAME ORGANIZATION_NAME, CEO_NAME CEO_NAME, CEO_TITLE CEO_TITLE, PRINCIPAL_NAME PRINCIPAL_NAME, PRINCIPAL_TITLE PRINCIPAL_TITLE, LEGAL_STATUS LEGAL_STATUS, CONTROL_YR CONTROL_YR, EMPLOYEES_TOTAL EMPLOYEES_TOTAL, HQ_BRANCH_IND HQ_BRANCH_IND, BRANCH_FLAG BRANCH_FLAG, OOB_IND OOB_IND, TAX_REFERENCE TAX_REFERENCE, GSA_INDICATOR_FLAG GSA_INDICATOR_FLAG, JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE, ANALYSIS_FY ANALYSIS_FY, FISCAL_YEAREND_MONTH FISCAL_YEAREND_MONTH, CURR_FY_POTENTIAL_REVENUE CURR_FY_POTENTIAL_REVENUE, NEXT_FY_POTENTIAL_REVENUE NEXT_FY_POTENTIAL_REVENUE, YEAR_ESTABLISHED YEAR_ESTABLISHED, MISSION_STATEMENT MISSION_STATEMENT, ORGANIZATION_TYPE ORGANIZATION_TYPE, BUSINESS_SCOPE BUSINESS_SCOPE, KNOWN_AS KNOWN_AS, KNOWN_AS2 KNOWN_AS2, KNOWN_AS3 KNOWN_AS3, KNOWN_AS4 KNOWN_AS4, KNOWN_AS5 KNOWN_AS5, LOCAL_BUS_IDEN_TYPE LOCAL_BUS_IDEN_TYPE, LOCAL_BUS_IDENTIFIER LOCAL_BUS_IDENTIFIER, PREF_FUNCTIONAL_CURRENCY PREF_FUNCTIONAL_CURRENCY, REGISTRATION_TYPE REGISTRATION_TYPE, PARENT_SUB_IND PARENT_SUB_IND, INCORP_YEAR INCORP_YEAR, LINE_OF_BUSINESS LINE_OF_BUSINESS, PUBLIC_PRIVATE_OWNERSHIP_FLAG PUBLIC_PRIVATE_OWNERSHIP_FLAG, TOTAL_PAYMENTS TOTAL_PAYMENTS, DUNS_NUMBER_C DUNS_NUMBER_C, PERSON_PRE_NAME_ADJUNCT PERSON_PRE_NAME_ADJUNCT, PERSON_FIRST_NAME PERSON_FIRST_NAME, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME, PERSON_LAST_NAME PERSON_LAST_NAME, PERSON_NAME_SUFFIX PERSON_NAME_SUFFIX, PERSON_TITLE PERSON_TITLE, PERSON_ACADEMIC_TITLE PERSON_ACADEMIC_TITLE, PERSON_PREVIOUS_LAST_NAME PERSON_PREVIOUS_LAST_NAME, PERSON_INITIALS PERSON_INITIALS, PERSON_FIRST_NAME_PHONETIC PERSON_FIRST_NAME_PHONETIC, PERSON_NAME_PHONETIC PERSON_NAME_PHONETIC, PERSON_MIDDLE_NAME_PHONETIC PERSON_MIDDLE_NAME_PHONETIC, PERSON_LAST_NAME_PHONETIC PERSON_LAST_NAME_PHONETIC, PERSON_IDEN_TYPE PERSON_IDEN_TYPE, PERSON_IDENTIFIER PERSON_IDENTIFIER, DATE_OF_BIRTH DATE_OF_BIRTH, PLACE_OF_BIRTH PLACE_OF_BIRTH, DATE_OF_DEATH DATE_OF_DEATH, GENDER GENDER, DECLARED_ETHNICITY DECLARED_ETHNICITY, MARITAL_STATUS MARITAL_STATUS, MARITAL_STATUS_EFFECTIVE_DATE MARITAL_STATUS_EFFECTIVE_DATE, PERSONAL_INCOME PERSONAL_INCOME, HEAD_OF_HOUSEHOLD_FLAG HEAD_OF_HOUSEHOLD_FLAG, HOUSEHOLD_INCOME HOUSEHOLD_INCOME, HOUSEHOLD_SIZE HOUSEHOLD_SIZE, RENT_OWN_IND RENT_OWN_IND, COUNTRY COUNTRY, ADDRESS1 ADDRESS1, ADDRESS2 ADDRESS2, ADDRESS3 ADDRESS3, ADDRESS4 ADDRESS4, CITY CITY, POSTAL_CODE POSTAL_CODE, STATE STATE, PROVINCE PROVINCE, COUNTY COUNTY, ADDRESS_LINES_PHONETIC ADDRESS_LINES_PHONETIC, DESCRIPTION DESCRIPTION, LANGUAGE LANGUAGE, PARTY_SITE_NAME PARTY_SITE_NAME, CONTACT_POINT_TYPE CONTACT_POINT_TYPE, EMAIL_FORMAT EMAIL_FORMAT, EMAIL_ADDRESS EMAIL_ADDRESS, PHONE_AREA_CODE PHONE_AREA_CODE, PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE, PHONE_NUMBER PHONE_NUMBER, PHONE_EXTENSION PHONE_EXTENSION, PHONE_LINE_TYPE PHONE_LINE_TYPE, WEB_TYPE WEB_TYPE, URL URL, RAW_PHONE_NUMBER RAW_PHONE_NUMBER, CONTACT_POINT_PURPOSE CONTACT_POINT_PURPOSE, CLASS_CATEGORY CLASS_CATEGORY, CLASS_CODE CLASS_CODE, DEPARTMENT_CODE DEPARTMENT_CODE, DEPARTMENT DEPARTMENT, TITLE TITLE, JOB_TITLE JOB_TITLE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TELEX_NUMBER TELEX_NUMBER from "IMC"."IMC_CSV_INTERFACE_FIELDS"

View Text - HTML Formatted

SELECT LOAD_ID LOAD_ID
, BATCH_ID BATCH_ID
, PARTY_REC_ID PARTY_REC_ID
, REC_STATUS REC_STATUS
, PARTY_TYPE PARTY_TYPE
, ORGANIZATION_NAME ORGANIZATION_NAME
, CEO_NAME CEO_NAME
, CEO_TITLE CEO_TITLE
, PRINCIPAL_NAME PRINCIPAL_NAME
, PRINCIPAL_TITLE PRINCIPAL_TITLE
, LEGAL_STATUS LEGAL_STATUS
, CONTROL_YR CONTROL_YR
, EMPLOYEES_TOTAL EMPLOYEES_TOTAL
, HQ_BRANCH_IND HQ_BRANCH_IND
, BRANCH_FLAG BRANCH_FLAG
, OOB_IND OOB_IND
, TAX_REFERENCE TAX_REFERENCE
, GSA_INDICATOR_FLAG GSA_INDICATOR_FLAG
, JGZZ_FISCAL_CODE JGZZ_FISCAL_CODE
, ANALYSIS_FY ANALYSIS_FY
, FISCAL_YEAREND_MONTH FISCAL_YEAREND_MONTH
, CURR_FY_POTENTIAL_REVENUE CURR_FY_POTENTIAL_REVENUE
, NEXT_FY_POTENTIAL_REVENUE NEXT_FY_POTENTIAL_REVENUE
, YEAR_ESTABLISHED YEAR_ESTABLISHED
, MISSION_STATEMENT MISSION_STATEMENT
, ORGANIZATION_TYPE ORGANIZATION_TYPE
, BUSINESS_SCOPE BUSINESS_SCOPE
, KNOWN_AS KNOWN_AS
, KNOWN_AS2 KNOWN_AS2
, KNOWN_AS3 KNOWN_AS3
, KNOWN_AS4 KNOWN_AS4
, KNOWN_AS5 KNOWN_AS5
, LOCAL_BUS_IDEN_TYPE LOCAL_BUS_IDEN_TYPE
, LOCAL_BUS_IDENTIFIER LOCAL_BUS_IDENTIFIER
, PREF_FUNCTIONAL_CURRENCY PREF_FUNCTIONAL_CURRENCY
, REGISTRATION_TYPE REGISTRATION_TYPE
, PARENT_SUB_IND PARENT_SUB_IND
, INCORP_YEAR INCORP_YEAR
, LINE_OF_BUSINESS LINE_OF_BUSINESS
, PUBLIC_PRIVATE_OWNERSHIP_FLAG PUBLIC_PRIVATE_OWNERSHIP_FLAG
, TOTAL_PAYMENTS TOTAL_PAYMENTS
, DUNS_NUMBER_C DUNS_NUMBER_C
, PERSON_PRE_NAME_ADJUNCT PERSON_PRE_NAME_ADJUNCT
, PERSON_FIRST_NAME PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME PERSON_MIDDLE_NAME
, PERSON_LAST_NAME PERSON_LAST_NAME
, PERSON_NAME_SUFFIX PERSON_NAME_SUFFIX
, PERSON_TITLE PERSON_TITLE
, PERSON_ACADEMIC_TITLE PERSON_ACADEMIC_TITLE
, PERSON_PREVIOUS_LAST_NAME PERSON_PREVIOUS_LAST_NAME
, PERSON_INITIALS PERSON_INITIALS
, PERSON_FIRST_NAME_PHONETIC PERSON_FIRST_NAME_PHONETIC
, PERSON_NAME_PHONETIC PERSON_NAME_PHONETIC
, PERSON_MIDDLE_NAME_PHONETIC PERSON_MIDDLE_NAME_PHONETIC
, PERSON_LAST_NAME_PHONETIC PERSON_LAST_NAME_PHONETIC
, PERSON_IDEN_TYPE PERSON_IDEN_TYPE
, PERSON_IDENTIFIER PERSON_IDENTIFIER
, DATE_OF_BIRTH DATE_OF_BIRTH
, PLACE_OF_BIRTH PLACE_OF_BIRTH
, DATE_OF_DEATH DATE_OF_DEATH
, GENDER GENDER
, DECLARED_ETHNICITY DECLARED_ETHNICITY
, MARITAL_STATUS MARITAL_STATUS
, MARITAL_STATUS_EFFECTIVE_DATE MARITAL_STATUS_EFFECTIVE_DATE
, PERSONAL_INCOME PERSONAL_INCOME
, HEAD_OF_HOUSEHOLD_FLAG HEAD_OF_HOUSEHOLD_FLAG
, HOUSEHOLD_INCOME HOUSEHOLD_INCOME
, HOUSEHOLD_SIZE HOUSEHOLD_SIZE
, RENT_OWN_IND RENT_OWN_IND
, COUNTRY COUNTRY
, ADDRESS1 ADDRESS1
, ADDRESS2 ADDRESS2
, ADDRESS3 ADDRESS3
, ADDRESS4 ADDRESS4
, CITY CITY
, POSTAL_CODE POSTAL_CODE
, STATE STATE
, PROVINCE PROVINCE
, COUNTY COUNTY
, ADDRESS_LINES_PHONETIC ADDRESS_LINES_PHONETIC
, DESCRIPTION DESCRIPTION
, LANGUAGE LANGUAGE
, PARTY_SITE_NAME PARTY_SITE_NAME
, CONTACT_POINT_TYPE CONTACT_POINT_TYPE
, EMAIL_FORMAT EMAIL_FORMAT
, EMAIL_ADDRESS EMAIL_ADDRESS
, PHONE_AREA_CODE PHONE_AREA_CODE
, PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, PHONE_NUMBER PHONE_NUMBER
, PHONE_EXTENSION PHONE_EXTENSION
, PHONE_LINE_TYPE PHONE_LINE_TYPE
, WEB_TYPE WEB_TYPE
, URL URL
, RAW_PHONE_NUMBER RAW_PHONE_NUMBER
, CONTACT_POINT_PURPOSE CONTACT_POINT_PURPOSE
, CLASS_CATEGORY CLASS_CATEGORY
, CLASS_CODE CLASS_CODE
, DEPARTMENT_CODE DEPARTMENT_CODE
, DEPARTMENT DEPARTMENT
, TITLE TITLE
, JOB_TITLE JOB_TITLE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TELEX_NUMBER TELEX_NUMBER
FROM "IMC"."IMC_CSV_INTERFACE_FIELDS"