-- Create Table Statement for 'Paypal Auth Retail Transaction'
DROP TABLE IF EXISTS `PAYPAL_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `PAYPAL_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	PATH_AUTHORIZATION_ID varchar,
	PATH_CAPTURE_ID varchar,
	PATH_ACTION varchar,
	AMOUNT_CURRENCY_CODE varchar,
	AMOUNT_VALUE varchar,
	SOFT_DESCRIPTOR varchar,
	INVOICE_ID varchar,
	ORDER_ID varchar,
	CREATE_TIME varchar,
	UPDATE_TIME varchar,
	STATUS varchar,
	PAYER_EMAIL_ADDRESS varchar,
	PAYER_ID varchar,
	PAYER_GIVEN_NAME varchar,
	PAYER_SURNAME varchar,
	PAYER_PHONE_NUMBER varchar,
	PAYER_BIRTH_DATE varchar,
	PAYER_TAX_ID varchar,
	PAYER_TAX_ID_TYPE varchar,
	PAYER_ADDRESS_LINE1 varchar,
	PAYER_ADDRESS_LINE2 varchar,
	PAYER_ADDRESS_AREA1 varchar,
	PAYER_ADDRESS_AREA2 varchar,
	PAYER_ADDRESS_POSTAL_CODE varchar,
	PAYER_ADDRESS_COUNTRY_CODE varchar,
	PAYMENT_SOURCE_CARD_NAME varchar,
	PAYMENT_SOURCE_CARD_LAST_DIGITS varchar,
	PAYMENT_SOURCE_CARD_BRAND varchar,
	PAYMENT_SOURCE_CARD_TYPE varchar,
	PAYMENT_SOURCE_CARD_BILLING_ADDRESS_LINE1 varchar,
	PAYMENT_SOURCE_CARD_BILLING_ADDRESS_LINE2 varchar,
	PAYMENT_SOURCE_CARD_BILLING_ADDRESS_AREA1 varchar,
	PAYMENT_SOURCE_CARD_BILLING_ADDRESS_AREA2 varchar,
	PAYMENT_SOURCE_CARD_BILLING_ADDRESS_POSTAL_CODE varchar,
	PAYMENT_SOURCE_CARD_BILLING_ADDRESS_COUNTRY_CODE varchar,
	REFERENCE_ID varchar,
	PAYEE_MERCHANT_ID varchar,
	PURCHASE_CUSTOM_ID varchar,
	PURCHASE_INVOICE_ID varchar,
	PURCHASE_DESCRIPTION varchar,
	PURCHASE_ID varchar,
	PURCHASE_SOFT_DESCRIPTOR varchar,
	PURCHASE_AMOUNT_CURRENCY_CODE varchar,
	PURCHASE_AMOUNT_VALUE varchar,
	SHIPPING_ADDRESS_LINE1 varchar,
	SHIPPING_ADDRESS_LINE2 varchar,
	SHIPPING_ADDRESS_AREA1 varchar,
	SHIPPING_ADDRESS_AREA2 varchar,
	SHIPPING_ADDRESS_POSTAL_CODE varchar,
	SHIPPING_ADDRESS_COUNTRY_CODE varchar,
	AUTHORIZATION_ID varchar,
	AUTHORIZATION_AVS_CODE varchar,
	AUTHORIZATION_CVV_CODE varchar,
	AUTHORIZATION_RESPONSE_CODE varchar,
	AUTHORIZATION_PAYMENT_ADVICE_CODE varchar,
	CAPTURE_ID varchar,
	CAPTURE_STATUS varchar,
	CAPTURE_REASON varchar,
	CAPTURE_AMOUNT_CURRENCY_CODE varchar,
	CAPTURE_AMOUNT_VALUE varchar,
	CAPTURE_INVOICE_ID varchar,
	CAPTURE_CUSTOM_ID varchar,
	CAPTURE_FINAL_CAPTURE varchar,
	CAPTURE_GROSS_AMOUNT_CURRENCY_CODE varchar,
	CAPTURE_GROSS_AMOUNT_VALUE varchar,
	CAPTURE_NET_AMOUNT_CURRENCY_CODE varchar,
	CAPTURE_NET_AMOUNT_VALUE varchar,
	CAPTURE_PAYPAL_FEE_CURRENCY_CODE varchar,
	CAPTURE_PAYPAL_FEE_VALUE varchar,
	CAPTURE_AVS_CODE varchar,
	CAPTURE_CVV_CODE varchar,
	CAPTURE_RESPONSE_CODE varchar,
	CAPTURE_PAYMENT_ADVICE_CODE varchar,
	REFUND_ID varchar,
	REFUND_STATUS varchar,
	REFUND_REASON varchar,
	REFUND_AMOUNT_CURRENCY_CODE varchar,
	REFUND_AMOUNT_VALUE varchar,
	REFUND_INVOICE_ID varchar,
	REFUND_NOTE_TO_PAYER varchar,
	REFUND_GROSS_AMOUNT_CURRENCY_CODE varchar,
	REFUND_GROSS_AMOUNT_VALUE varchar,
	REFUND_NET_AMOUNT_CURRENCY_CODE varchar,
	REFUND_NET_AMOUNT_VALUE varchar,
	REFUND_PAYPAL_FEE_CURRENCY_CODE varchar,
	REFUND_PAYPAL_FEE_VALUE varchar,
	REFUND_TOTAL_REFUNDED_AMOUNT_CURRENCY_CODE varchar,
	REFUND_TOTAL_REFUNDED_AMOUNT_VALUE varchar,
	INTENT varchar,
	SHIPPING_NAME varchar,
	PATH_ORDER_ID varchar,
	PATH_REFUND_ID varchar,
	PAYEE_EMAIL_ADDRESS varchar,
	AUTHORIZATION_STATUS varchar,
	AUTHORIZATION_REASON varchar,
	AUTHORIZATION_AMOUNT_CURRENCY_CODE varchar,
	AUTHORIZATION_AMOUNT_VALUE varchar,
	AUTHORIZATION_INVOICE_ID varchar,
	AUTHORIZATION_CUSTOM_ID varchar,
	AUTHORIZATION_EXPIRATION_TIME varchar,
	AUTHORIZATION_CREATE_TIME varchar,
	AUTHORIZATION_UPDATE_TIME varchar,
	CAPTURE_CREATE_TIME varchar,
	CAPTURE_UPDATE_TIME varchar,
	REFUND_CREATE_TIME varchar,
	REFUND_UPDATE_TIME varchar,
	ERROR varchar,
	ERROR_DESCRIPTION varchar,
	ERROR_DETAIL_FIELD varchar,
	ERROR_DETAIL_VALUE varchar,
	ERROR_DETAIL_LOCATION varchar,
	ERROR_DETAIL_ISSUE varchar,
	ERROR_DETAIL_DESCRIPTION varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;