--***************************************************************************************
--* Program: XXAVX_CUSTOMERS_LOAD.ctl *
--* Author: Intelligroup *
--* Created: o4-NOV-08 *
--* *
--* Description: Control File to import the customers from the flat *
--* file to the XXAVX_CUSTOMERS_STG staging table. *
--* *
--* *
--* Modifications: *
--* ------------- *
--* Date Name Version Description *
--* --------- --------------- ------- ----------- *
--* o4-NOV-08 Intelligroup 1.0 Initial Version *
--* *
--***************************************************************************************
LOAD DATA
INFILE '$file'
TRUNCATE
INTO TABLE XXCUS.XXAVX_CUSTOMERS_STG
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
ORGANIZATION_NAME "LTRIM(RTRIM(:ORGANIZATION_NAME))"
,PARTY_NUMBER "LTRIM(RTRIM(:PARTY_NUMBER))"
,ORIG_SYSTEM_REFERENCE "LTRIM(RTRIM(:ORIG_SYSTEM_REFERENCE))"
,ACCOUNT_NUMBER "LTRIM(RTRIM(:ACCOUNT_NUMBER))"
,ACCOUNT_NAME "LTRIM(RTRIM(:ACCOUNT_NAME))"
,CREATED_BY_MODULE "LTRIM(RTRIM(:CREATED_BY_MODULE))"
,DUNNING_LETTERS_FLAG "LTRIM(RTRIM(:DUNNING_LETTERS_FLAG))"
,DUNNING_LETTERS_SET_ID "LTRIM(RTRIM(:DUNNING_LETTERS_SET_ID))"
,ORIG_SYSTEM_ADDRESS_REF "LTRIM(RTRIM(:ORIG_SYSTEM_ADDRESS_REF))"
,COUNTRY "LTRIM(RTRIM(:COUNTRY))"
,STATE "LTRIM(RTRIM(:STATE))"
,PROVINCE "LTRIM(RTRIM(:PROVINCE))"
,ADDRESS1 "LTRIM(RTRIM(:ADDRESS1))"
,ADDRESS2 "LTRIM(RTRIM(:ADDRESS2))"
,ADDRESS3 "LTRIM(RTRIM(:ADDRESS3))"
,ADDRESS4 "LTRIM(RTRIM(:ADDRESS4))"
,CITY "LTRIM(RTRIM(:CITY))"
,POSTAL_CODE "LTRIM(RTRIM(:POSTAL_CODE))"
,ADDRESSEE "LTRIM(RTRIM(:ADDRESSEE))"
,IDENTIFYING_ADDRESS_FLAG "LTRIM(RTRIM(:IDENTIFYING_ADDRESS_FLAG))"
,LANGUAGE "LTRIM(RTRIM(:LANGUAGE))"
,SITE_USE_CODE "LTRIM(RTRIM(:SITE_USE_CODE))"
,PERSON_FLAG "LTRIM(RTRIM(:PERSON_FLAG))"
,FIRST_NAME "LTRIM(RTRIM(:FIRST_NAME))"
,LAST_NAME "LTRIM(RTRIM(:LAST_NAME))"
,ORG_CONTACT_PRE_NAME_ADJUNT "LTRIM(RTRIM(:ORG_CONTACT_PRE_NAME_ADJUNT))"
,ORG_CONTACT_FIRST_NAME "LTRIM(RTRIM(:ORG_CONTACT_FIRST_NAME))"
,ORG_CONTACT_LAST_NAME "LTRIM(RTRIM(:ORG_CONTACT_LAST_NAME))"
,ORG_CONTACT_DEPARTMENT_CODE "LTRIM(RTRIM(:ORG_CONTACT_DEPARTMENT_CODE))"
,ORG_CONTACT_JOB_TITLE "LTRIM(RTRIM(:ORG_CONTACT_JOB_TITLE))"
,ORGCONTACT_DECISIONMAKERFLAG "LTRIM(RTRIM(:ORGCONTACT_DECISIONMAKERFLAG))"
,ORG_CONTACT_JOB_TITLE_CODE "LTRIM(RTRIM(:ORG_CONTACT_JOB_TITLE_CODE))"
,ORG_CONTACT_ROLE_TYPE "LTRIM(RTRIM(:ORG_CONTACT_ROLE_TYPE))"
,ORG_CONTACT_PHONE_NUMBER "LTRIM(RTRIM(:ORG_CONTACT_PHONE_NUMBER))"
,ORG_CONTACT_PHONE_LINE_TYPE "LTRIM(RTRIM(:ORG_CONTACT_PHONE_LINE_TYPE))"
,SITE_CONTACT_PRE_NAME_ADJUNT "LTRIM(RTRIM(:SITE_CONTACT_PRE_NAME_ADJUNT))"
,SITE_CONTACT_FIRST_NAME "LTRIM(RTRIM(:SITE_CONTACT_FIRST_NAME))"
,SITE_CONTACT_LAST_NAME "LTRIM(RTRIM(:SITE_CONTACT_LAST_NAME))"
,SITE_CONTACT_DEPARTMENT_CODE "LTRIM(RTRIM(:SITE_CONTACT_DEPARTMENT_CODE))"
,SITE_CONTACT_JOB_TITLE "LTRIM(RTRIM(:SITE_CONTACT_JOB_TITLE))"
,SITECONTACT_DECISIONMAKERFLAG "LTRIM(RTRIM(:SITECONTACT_DECISIONMAKERFLAG))"
,SITE_CONTACT_JOB_TITLE_CODE "LTRIM(RTRIM(:SITE_CONTACT_JOB_TITLE_CODE))"
,SITE_CONTACT_ROLE_TYPE "LTRIM(RTRIM(:SITE_CONTACT_ROLE_TYPE))"
,SITECONTACT_PHONE_COUNTRY_CODE "LTRIM(RTRIM(:SITECONTACT_PHONE_COUNTRY_CODE))"
,SITE_CONTACT_PHONE_AREA_CODE "LTRIM(RTRIM(:SITE_CONTACT_PHONE_AREA_CODE))"
,SITE_CONTACT_PHONE_NUMBER "LTRIM(RTRIM(:SITE_CONTACT_PHONE_NUMBER))"
,SITE_CONTACT_PHONE_EXTENSION "LTRIM(RTRIM(:SITE_CONTACT_PHONE_EXTENSION))"
,SITE_CONTACT_PHONE_LINE_TYPE "LTRIM(RTRIM(:SITE_CONTACT_PHONE_LINE_TYPE))"
,CUSTOMER_PROFILE_CLASS "LTRIM(RTRIM(:CUSTOMER_PROFILE_CLASS))"
,PRIMARY_SALES_PERSON_NUMBER "LTRIM(RTRIM(:PRIMARY_SALES_PERSON_NUMBER))"
,PAYMENT_TERM_ID "LTRIM(RTRIM(:PAYMENT_TERM_ID))"
,PROFILE_CREDIT_CHECKING_FLAG "LTRIM(RTRIM(:PROFILE_CREDIT_CHECKING_FLAG))"
,PROFILE_INTEREST_CHARGES_FLAG "LTRIM(RTRIM(:PROFILE_INTEREST_CHARGES_FLAG))"
,PROFILE_OVERALL_CREDIT_LIMIT "LTRIM(RTRIM(:PROFILE_OVERALL_CREDIT_LIMIT))"
,DUNS_NUMBER "LTRIM(RTRIM(:DUNS_NUMBER))"
,ACCOUNT_ROLE_TYPE "LTRIM(RTRIM(:ACCOUNT_ROLE_TYPE))"
,CREDITPROFILE_ATTRIBCATEGORY "LTRIM(RTRIM(:CREDITPROFILE_ATTRIBCATEGORY))"
,CREDIT_PROFILE_ATTRIBUTE_1 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_1))"
,CREDIT_PROFILE_ATTRIBUTE_2 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_2))"
,CREDIT_PROFILE_ATTRIBUTE_3 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_3))"
,CREDIT_PROFILE_ATTRIBUTE_4 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_4))"
,CREDIT_PROFILE_ATTRIBUTE_5 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_5))"
,CREDIT_PROFILE_ATTRIBUTE_6 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_6))"
,CREDIT_PROFILE_ATTRIBUTE_7 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_7))"
,CREDIT_PROFILE_ATTRIBUTE_8 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_8))"
,CREDIT_PROFILE_ATTRIBUTE_9 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_9))"
,CREDIT_PROFILE_ATTRIBUTE_10 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_10))"
,CREDIT_PROFILE_ATTRIBUTE_11 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_11))"
,CREDIT_PROFILE_ATTRIBUTE_12 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_12))"
,CREDIT_PROFILE_ATTRIBUTE_13 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_13))"
,CREDIT_PROFILE_ATTRIBUTE_14 "LTRIM(RTRIM(:CREDIT_PROFILE_ATTRIBUTE_14))"
,PROFILEAMNTS_ATTRIBCATEGORY "LTRIM(RTRIM(:PROFILEAMNTS_ATTRIBCATEGORY))"
,PROFILE_AMOUNTS_ATTRIBUTE_1 "LTRIM(RTRIM(:PROFILE_AMOUNTS_ATTRIBUTE_1))"
,PROFILE_AMOUNTS_ATTRIBUTE_2 "LTRIM(RTRIM(:PROFILE_AMOUNTS_ATTRIBUTE_2))"
,PROFILE_AMOUNTS_ATTRIBUTE_3 "LTRIM(RTRIM(:PROFILE_AMOUNTS_ATTRIBUTE_3))"
,PROFILE_AMOUNTS_ATTRIBUTE_4 "LTRIM(RTRIM(:PROFILE_AMOUNTS_ATTRIBUTE_4))"
,PROFILE_AMOUNTS_ATTRIBUTE_5 "LTRIM(RTRIM(:PROFILE_AMOUNTS_ATTRIBUTE_5))"
,PROFILE_AMOUNTS_ATTRIBUTE_6 "LTRIM(RTRIM(:PROFILE_AMOUNTS_ATTRIBUTE_6))"
,PROFILE_AMOUNTS_ATTRIBUTE_7 "LTRIM(RTRIM(:PROFILE_AMOUNTS_ATTRIBUTE_7))"
,PROFILE_AMOUNTS_ATTRIBUTE_8 "LTRIM(RTRIM(:PROFILE_AMOUNTS_ATTRIBUTE_8))"
,PROFILE_AMOUNTS_ATTRIBUTE_9 "LTRIM(RTRIM(:PROFILE_AMOUNTS_ATTRIBUTE_9))"
,PROFILE_AMOUNTS_ATTRIBUTE_10 "LTRIM(RTRIM(:PROFILE_AMOUNTS_ATTRIBUTE_10))"
,PROFILE_AMOUNTS_ATTRIBUTE_11 "LTRIM(RTRIM(:PROFILE_AMOUNTS_ATTRIBUTE_11))"
,SITE_USE_ATTRIBUTESCATEGORY "LTRIM(RTRIM(:SITE_USE_ATTRIBUTESCATEGORY))"
,SITE_USE_ATTRIBUTE_1 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_1))"
,SITE_USE_ATTRIBUTE_2 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_2))"
,SITE_USE_ATTRIBUTE_3 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_3))"
,SITE_USE_ATTRIBUTE_4 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_4))"
,SITE_USE_ATTRIBUTE_5 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_5))"
,SITE_USE_ATTRIBUTE_6 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_6))"
,SITE_USE_ATTRIBUTE_7 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_7))"
,SITE_USE_ATTRIBUTE_8 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_8))"
,SITE_USE_ATTRIBUTE_9 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_9))"
,SITE_USE_ATTRIBUTE_10 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_10))"
,SITE_USE_ATTRIBUTE_11 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_11))"
,SITE_USE_ATTRIBUTE_12 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_12))"
,SITE_USE_ATTRIBUTE_13 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_13))"
,SITE_USE_ATTRIBUTE_14 "LTRIM(RTRIM(:SITE_USE_ATTRIBUTE_14))"
,STANDARD_TERMS "LTRIM(RTRIM(:STANDARD_TERMS))"
,COLLECTOR_ID "LTRIM(RTRIM(:COLLECTOR_ID))"
,RISK_CODE "LTRIM(RTRIM(:RISK_CODE))"
,CURRENCY_CODE "LTRIM(RTRIM(:CURRENCY_CODE))"
,CREDIT_CLASSIFICATION "LTRIM(RTRIM(:CREDIT_CLASSIFICATION))"
,LOCATION "LTRIM(RTRIM(:LOCATION))"
,BILL_TO_SITE_USE_ID "LTRIM(RTRIM(:BILL_TO_SITE_USE_ID))"
,EMAIL_ADDRESS "LTRIM(RTRIM(:EMAIL_ADDRESS))"
,DISCOUNT_GRACE_DAYS "LTRIM(RTRIM(:DISCOUNT_GRACE_DAYS))"
,DELIVERY_METHOD_INVOICE "LTRIM(RTRIM(:DELIVERY_METHOD_INVOICE))"
,E_MAIL_ID "LTRIM(RTRIM(:E_MAIL_ID))"
,FAX_PHONE_COUNTRY "LTRIM(RTRIM(:FAX_PHONE_COUNTRY))"
,FAX_PHONE_AREA "LTRIM(RTRIM(:FAX_PHONE_AREA))"
,FAX_PHONE_NUMBER "LTRIM(RTRIM(:FAX_PHONE_NUMBER))"
,FAX_PHONE_EXTENSION "LTRIM(RTRIM(:FAX_PHONE_EXTENSION))"
,CONTACT_INFORMATION_CATEGORY "LTRIM(RTRIM(:CONTACT_INFORMATION_CATEGORY))"
,CONTACTINFORMATION_ATTRIBUTE1 "LTRIM(RTRIM(:CONTACTINFORMATION_ATTRIBUTE1))"
)