CREATE TABLE "MIG_NEW_CUSTOMERS" ( "SAP_CODE" NUMBER(26,0), "OFFICE_NAME_NUMBER" VARCHAR2(250 BYTE), "VAT_NUMBER" VARCHAR2(30 BYTE), "OWNER" VARCHAR2(250 BYTE), "REPRESENTATIVE" VARCHAR2(250 BYTE), "EMAIL" VARCHAR2(250 BYTE), "ADDRESS" VARCHAR2(250 BYTE), "POSTAL_CODE" VARCHAR2(50 BYTE), "PHONE" VARCHAR2(50 BYTE) ); CREATE TABLE "MIG_NEW_BOATS" ( "SAP_CODE" NUMBER(26,0), "BOAT_NAME" VARCHAR2(250 BYTE), "BERTH" VARCHAR2(50 BYTE), "REGISTRATION_NUMBER" VARCHAR2(50 BYTE), "VAT_NUMBER" VARCHAR2(30 BYTE), "OWNER_NAME" VARCHAR2(250 BYTE), "COLUMN7" VARCHAR2(26 BYTE), "TYPE_BOAT" VARCHAR2(50 BYTE), "LENGTH" NUMBER(26,2), "BREADTH" NUMBER(26,2), "DRAFT" NUMBER(26,2), "FLAG" VARCHAR2(50 BYTE), "CALL_SIGN" VARCHAR2(26 BYTE), "PORT" VARCHAR2(128 BYTE), "YEAR" NUMBER(26,0), "CHECK_BOX_FLAG" VARCHAR2(26 BYTE), "EXPIRED_FLAG" DATE, "CHECK_BOX_INSURANCE" VARCHAR2(26 BYTE), "EXPIRED_INSURANCE" DATE, "WHOLE_CAPACITY" NUMBER(26,2), "PURE_CAPACITY" NUMBER(26,2), "NUMBER_ENGINNERS" NUMBER(26,0), "HP" NUMBER(26,0), "YEN" VARCHAR2(250 BYTE), "EMHTP" VARCHAR2(26 BYTE), "CITY" VARCHAR2(250 BYTE), "ADDRESS" VARCHAR2(250 BYTE), "AREA" VARCHAR2(50 BYTE), "ZIPCODE" VARCHAR2(30 BYTE), "PHONE_COMPANY" VARCHAR2(50 BYTE), "PHONE_COMPANY2" VARCHAR2(50 BYTE), "REPRESENTATIVE" VARCHAR2(250 BYTE), "CITY2" VARCHAR2(250 BYTE), "ADDRESS2" VARCHAR2(250 BYTE), "AREA2" VARCHAR2(50 BYTE), "VAT_NUMBER2" VARCHAR2(30 BYTE), "ZIPCODE2" VARCHAR2(50 BYTE), "PHONE_REPRESENTATIVE" VARCHAR2(50 BYTE), "PHONE_REPRESENTATIVE2" VARCHAR2(2650 BYTE), "CAPTAIN" VARCHAR2(250 BYTE), "PHONE_CAPTAIN" VARCHAR2(50 BYTE), "PHONE_CAPTAIN2" VARCHAR2(50 BYTE), "EMAIL" VARCHAR2(250 BYTE) );