CREATE TABLE ida_statement_of_credits_and_grants_historical_data (
"end_of_period" VARCHAR,
"credit_number" VARCHAR,
"region" VARCHAR,
"country_code" VARCHAR,
"country" VARCHAR,
"borrower" VARCHAR,
"credit_status" VARCHAR,
"service_charge_rate" DOUBLE,
"currency_of_commitment" VARCHAR,
"project_id" VARCHAR,
"project_name" VARCHAR,
"original_principal_amount" DOUBLE,
"cancelled_amount" DOUBLE,
"undisbursed_amount" DOUBLE,
"disbursed_amount" DOUBLE,
"repaid_to_ida" DOUBLE,
"due_to_ida" DOUBLE,
"exchange_adjustment" VARCHAR,
"borrower_s_obligation" DOUBLE,
"sold_3rd_party" DOUBLE,
"repaid_3rd_party" DOUBLE,
"due_3rd_party" DOUBLE,
"credits_held" DOUBLE,
"first_repayment_date" VARCHAR,
"last_repayment_date" VARCHAR,
"agreement_signing_date" VARCHAR,
"board_approval_date" VARCHAR,
"effective_date_most_recent" VARCHAR,
"closed_date_most_recent" VARCHAR,
"last_disbursement_date" VARCHAR
);