-- Create Table Statement for 'Amex Processing Cost'
DROP TABLE IF EXISTS `AMEX_PROCESSING_COST`;
CREATE TABLE `AMEX_PROCESSING_COST` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TLRR_AMEX_PAYEE_NUMBER varchar,
	TLRR_AMEX_SE_NUMBER varchar,
	TLRR_SE_UNIT_NUMBER varchar,
	TLRR_PAYMENT_YEAR varchar,
	TLRR_PAYMENT_NUMBER varchar,
	TLRR_SOC_INVOICE_NUMBER varchar,
	TLRR_SOC_AMOUNT varchar,
	TLRR_ROC_AMOUNT varchar,
	TLRR_CM_NUMBER varchar,
	TLRR_CM_REF_NO varchar,
	TLRR_SE_REF_POA varchar,
	NON_COMPLIANT_INDICATOR varchar,
	NON_COMPLIANT_ERROR_CODE1 varchar,
	NON_COMPLIANT_ERROR_CODE2 varchar,
	NON_COMPLIANT_ERROR_CODE3 varchar,
	NON_COMPLIANT_ERROR_CODE4 varchar,
	NON_SWIPED_INDICATOR varchar,
	SE_REJ_IND varchar,
	TRANSACTION_TIME varchar,
	APPROVAL_CODE varchar,
	TERMINAL_ID varchar,
	MERCHANT_CATEGORY_CODE varchar,
	AMEX_PAYEE_NUMBER varchar,
	AMEX_SE_NUMBER varchar,
	SE_UNIT_NUMBER varchar,
	PAYMENT_YEAR varchar,
	PAYMENT_NUMBER varchar,
	FEE_CODE varchar,
	FEE_DESCRIPTION varchar,
	DISCOUNT_RATE varchar,
	DISCOUNT_AMOUNT varchar,
	FEE_RATE varchar,
	FEE_AMOUNT varchar,
	MERCHANT_ID varchar,
	COST_MATCHING_STATUS_CL varchar,
	TLRR_SE_BUSINESS_DATE datetime,
	TLRR_AMEX_PROCESS_DATE datetime,
	TLRR_TRAN_DATE datetime,
	SOC_DETAIL_AMEX_PAYEE_NUMBER varchar,
	SOC_DETAIL_AMEX_SE_NUMBER varchar,
	SOC_DETAIL_SE_UNIT_NUMBER varchar,
	SOC_DETAIL_PAYMENT_NUMBER varchar,
	SOC_DETAIL_SE_BUSINESS_DATE varchar,
	SOC_DETAIL_AMEX_PROCESS_DATE varchar,
	SOC_DETAIL_SOC_INVOICE_NUMBER varchar,
	SOC_DETAIL_SOC_AMOUNT varchar,
	SOC_DETAIL_DISCOUNT_AMOUNT varchar,
	SOC_DETAIL_SERVICE_FEE_AMOUNT varchar,
	SOC_DETAIL_NET_SOC_AMOUNT varchar,
	SOC_DETAIL_DISCOUNT_RATE varchar,
	SOC_DETAIL_SERVICE_FEE_RATE varchar,
	SOC_DETAIL_AMEX_GROSS_AMOUNT varchar,
	SOC_DETAIL_AMEX_ROC_COUNT varchar,
	SOC_DETAIL_TRACKING_ID varchar,
	SOC_DETAIL_CPC_INDICATOR varchar,
	SOC_DETAIL_AMEX_ROC_COUNT_POA varchar,
	SOC_DETAIL_BASE_DISCOUNT_AMOUNT varchar,
	SOC_DETAIL_CARD_NOT_PRESENT_BPA_AMOUNT varchar,
	SOC_DETAIL_CARD_NOT_PRESENT_PTA_AMOUNT varchar,
	SOC_DETAIL_CARD_NOT_PRESENT_BPA_RATE varchar,
	SOC_DETAIL_CARD_NOT_PRESENT_PTA_RATE varchar,
	SOC_DETAIL_TRANSACTION_FEE_AMOUNT varchar,
	SOC_DETAIL_TRANSACTION_FEE_RATE varchar,
	SOC_DETAIL_PAYMENT_YEAR varchar,
	ASSET_BILLING_AMOUNT varchar,
	ASSET_BILLING_DESCRIPTION varchar,
	TAKE_ONE_COMMISION_AMOUNT varchar,
	TAKE_ONE_DESCRIPTION varchar,
	OTHER_FEE_AMOUNT varchar,
	OTHER_FEE_DESCRIPTION varchar,
	ASSET_BILLING_TAX varchar,
	PAY_IN_GROSS_INDICATOR varchar,
	BATCH_CODE varchar,
	BILL_CODE varchar,
	AMEX_PROCESSING_COST_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;