-- Create Table Statement for 'First Data Provisioning Report'
DROP TABLE IF EXISTS `FIRST_DATA_PROVISIONING_REPORT`;
CREATE TABLE `FIRST_DATA_PROVISIONING_REPORT` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	PIN_DLRS_CURRENT_MONTH int(11),
	ACCOUNT_OPENED datetime,
	BUSINESS_CHANGE_CODE_CL varchar,
	MERCHANT_URL varchar,
	SUBTRACT_WITHDRAW_RSRV_COLLATERAL int(11),
	MONTH12_CC_CNT_WITH_CURRENT_MONTH int(11),
	DATE_OF_LAST_SALES_TRANSACTION int(11),
	PRINCIPAL_CONTACT_EMAIL varchar,
	MERCHANT_BILL_TO_ZIP varchar,
	PRINCIPAL_CHANGE_CODE_CL varchar,
	MERCHANT_LEGAL_NAME varchar,
	MONTH12_KEYED_AMOUNT int(11),
	PIN_COUNT_CURRENT_MONTH int(11),
	MERCHANT_TIN varchar,
	PRINCIPAL_DOB datetime,
	GROSS_AMT_FUNDED12_MONTHS int(11),
	MERCHANT_CARDHOLDER_DESCRIPTOR varchar,
	PRINCIPAL_MIDDLE_NAME varchar,
	KEYED_COUNT_CURRENT_MONTH int(11),
	CC_REFUND_DOLLARS_CURRENT_MONTH int(11),
	MERCHANT_COUNTRY varchar,
	PRINCIPAL_ZIP varchar,
	FIRST_DATA_PROVISIONING_REPORT_BATCH_FK bigint(20),
	OPENING_BALANCE_RSRV_COLLATERAL int(11),
	MONTH12_CC_DLLRS_WITH_CURRENT_MONTH int(11),
	MERCHANT_PHONE varchar,
	AMTS_OFFSET_DEBITED12_MONTHS int(11),
	PRINCIPAL_ID varchar,
	GROSS_AMT_FUNDED_CURRENT_MONTH int(11),
	MERCHANT_BILL_TO_STATE varchar,
	MONTH12_CB_DLLRS_WITH_CURRENT_MONTH int(11),
	ACCOUNT_CLOSED datetime,
	PRINCIPAL_LAST_NAME varchar,
	MERCHANT_DBA_CITY varchar,
	MERCHANT_DBA_STATE varchar,
	MERCHANT_DBA_ADDRESS2 varchar,
	PRINCIPAL_SSN varchar,
	PROVISIONING_TRANSACTION_FK bigint(20),
	CC_REFUND_COUNT_CURRENT_MONTH int(11),
	MERCHANT_DBA_NAME varchar,
	CC_CB_COUNT_CURRENT_MONTH int(11),
	CARD_TYPE varchar,
	CLOSE_BALANCE_RSRV_COLLATERAL int(11),
	CURRENCY_ISO_CODE varchar,
	MONTH12_KEYED_COUNT int(11),
	MERCHANT_BILL_TO_ADDRESS1 varchar,
	PRINCIPAL_TITLE varchar,
	MONTH12_PIN_CNT_WITH_CURRENT_MONTH int(11),
	CC_CB_DOLLAR_CURRENT_MONTH int(11),
	MERCHANT_BILL_TO_ADDRESS2 varchar,
	MERCHANT_DBA_ADDRESS varchar,
	PRINCIPAL_CITY varchar,
	MERCHANT_DBA_ZIP varchar,
	MONTH12_CC_REFUND_CNT_WITH_CURRENT_MONTH int(11),
	KEYED_AMOUNT_CURRENT_MONTH int(11),
	MONTH12_REFUND_DLLRS_WITH_CURRENT_MONTH int(11),
	MERCHANT_ACCOUNT_STATUS varchar,
	ADD_TO_RSRV_COLLATERAL int(11),
	PRINCIPAL_ADDRESS varchar,
	PRINCIPAL_ADDRESS2 varchar,
	PRINCIPAL_COUNTRY varchar,
	MERCHANT_ABA varchar,
	PRINCIPAL_STATE varchar,
	CC_SALES_COUNT_CURRENT_MONTH int(11),
	PRINCIPAL_PHONE varchar,
	CC_SALES_DOLLARS_CURRENT_MONTH int(11),
	MONTH12_PIN_DLLRS_WITH_CURRENT_MONTH int(11),
	AMTS_OFFSET_DEBITED_CURRENT_MONTH int(11),
	MERCHANT_BILL_TO_CITY varchar,
	MERCHANT_MCC varchar,
	MONTH12_CB_CNT_WITH_CURRENT_MONTH int(11),
	PRINCIPAL_FIRST_NAME varchar,
	MERCHANT_FAX varchar,
	MERCHANT_BILL_TO_COUNTRY varchar,
	MERCHANT_DDA varchar,
	PROVISIONING_TRANSACTION_FK bigint(20),
	FIRST_DATA_PROVISIONING_REPORT_BATCH_FK bigint(20),
	FIRST_DATA_PROVISIONING_REPORT_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;