-- Create Table Statement for 'Anb B2b Processing Cost'
DROP TABLE IF EXISTS `ANB_B2B_PROCESSING_COST`;
CREATE TABLE `ANB_B2B_PROCESSING_COST` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
TRANSACTION_CODE varchar,
POST_DATE varchar,
POSTING_TIME varchar,
VALUE_DATE varchar,
AMOUNT varchar,
CURRENCY_CODE varchar,
NARR1 varchar,
NARR2 varchar,
NARR3 varchar,
REF_NUM varchar,
COUNTER varchar,
STMT varchar,
SRC_ACCT_NUM varchar,
PART_TRN_TYPE varchar,
PART_TRN_SRL_NUM varchar,
RUNNING_BALANCE_AMOUNT varchar,
NETWORK varchar,
TYPE varchar,
POI_NUM varchar,
UNIQUE_ID varchar,
ANB_B2B_PROCESSING_COST_BATCH_FK bigint(20),
CHARGE_TRANSACTION_FK bigint(20),
PROCESSING_COST_TYPE_CL varchar,
TRANSACTION_IDENTITY varchar,
PRIMARY KEY (ID)
) ENGINE=InnoDB;