guomao/DOC/DB/00_table/ap_supply_chain_interest.sql

CREATE TABLE AP_SUPPLY_CHAIN_INTEREST (
  ASCI_ID				varchar(20) 	NOT NULL 	COMMENT 'ID',
  ASCI_SUPPLY_CHAIN_ID	varchar(20) 	NOT NULL	COMMENT '供应链id',
  ASCI_DATE				varchar(8) 		NOT NULL	COMMENT '产生日期',
  ASCI_INTEREST 		VARCHAR(20) 	NOT NULL	COMMENT '利息值',
  ASCI_PAYMENT_ID		VARCHAR(20) 	NOT NULL	COMMENT '利息来源',
  ASCI_AMOUNT 			VARCHAR(20) 	NOT NULL	COMMENT '本金额度',
  ASCI_RATE 			VARCHAR(20) 	NOT NULL	COMMENT '利率',
  ASCI_STATE 			VARCHAR(2) 		DEFAULT '00' COMMENT '状态00正常01失效',
  PRIMARY KEY (ASCI_ID)
)  ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='供应链利息表';