--OPTIONS (ERRORS=17000)
LOAD DATA
INFILE "$XXPII_TOP/bin/vgc_supplier.txt"
--LOAD DATA INFILE '/interface/j_gejv/DGEJVI/incoming/Forecast/SFDC_2014c.csv'
BADFILE "$XXPII_TOP/bin/vgc_supplier.bad"
DISCARDFILE "$XXPII_TOP/bin/vgc_supplier.dsc"
REPLACE/APPEND
INTO TABLE VGc_SUPPLIER_STG
FIELDS TERMINATED BY "|" OPTIONALLY ENCLOSED BY "'"
TRAILING NULLCOLS
(LEGACY_VENDORID  CHAR "ltrim (rtrim (:LEGACY_VENDORID))",
VENDOR_SHORTNAME CHAR "ltrim (rtrim (:VENDOR_SHORTNAME))",
VENDOR_NAME  CHAR "ltrim (rtrim (:VENDOR_NAME))",
ADDRESS1  CHAR "ltrim (rtrim (:ADDRESS1))",
ADDRESS2  CHAR "ltrim (rtrim (:ADDRESS2))",
ADDRESS3  CHAR "ltrim (rtrim (:ADDRESS3))",
ADDRESS4  CHAR "ltrim (rtrim (:ADDRESS4))",
CITY   CHAR "ltrim (rtrim (:CITY))",
STATE   CHAR "ltrim (rtrim (:STATE))",
COUNTRY   CHAR "ltrim (rtrim (:COUNTRY))",
ZIP   CHAR "ltrim (rtrim (:ZIP))",
PHONE   CHAR "ltrim (rtrim (:PHONE))",
FAX   CHAR "ltrim (rtrim (:FAX))",
VENDOR_CREATION_DATE    "trunc(sysdate)",
HOLD_FLAG  CHAR "ltrim (rtrim (:HOLD_FLAG))",
TERMS_NAME  CHAR "ltrim (rtrim (:TERMS_NAME))",
CURRENCY_CODE  CHAR "ltrim (rtrim (:CURRENCY_CODE))",
VAT_CODE  CHAR "ltrim (rtrim (:VAT_CODE))",
CONTACT_LAST_NAME CHAR "ltrim (rtrim (:CONTACT_LAST_NAME))",
EMAIL_ADDRESS   CHAR(2000)  "ltrim (rtrim (:EMAIL_ADDRESS))",
CONTACT_PHONE  CHAR "ltrim (rtrim (:CONTACT_PHONE))",
CONTACT_FAX  CHAR "ltrim (rtrim (:CONTACT_FAX))",
VSTATUS   CHAR "ltrim (rtrim (:VSTATUS))",
----------------------------------------------------
LEASE_DEAL            "TRIM(:LEASE_DEAL)",
STAGE            "TRIM(:STAGE)",
DISPOSITION_DATE            DATE   "YYYY-MM-DD",
---------------------------------------------------------
TRANSACTION_QUANTITY,
TRANSACTION_COST,
VENDOR_SERIAL_NUMBER,

 ORDER_DATE                  "trim(:ORDER_DATE)"

)