DDL
CREATE TABLE `61` (
`settlemenId` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
`settlementNo` varchar(20) NOT NULL COMMENT '结算单号',
`settlementType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '结算类型(0:手工结算)',
`shopId` int(11) NOT NULL COMMENT '店铺ID',
`settlementMoney` decimal(11,0) NOT NULL DEFAULT '0' COMMENT '商品总金额',
`commissionFee` decimal(11,0) NOT NULL DEFAULT '0' COMMENT '结算应收的佣金(不含运费)',
`backMoney` decimal(11,0) NOT NULL DEFAULT '0' COMMENT '应返还给商家的金额',
`settlemenStatus` tinyint(4) NOT NULL DEFAULT '0' COMMENT '结算状态(0:申请结算1:已结算)',
`settlementTime` datetime DEFAULT NULL COMMENT '结算处理时间',
`remarks` varchar(255) DEFAULT NULL COMMENT '结算备注(商城填写)',
`createTime` datetime NOT NULL COMMENT '结算单申请时间',
PRIMARY KEY (`settlemenId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;