| 1234567891011121314151617181920212223242526272829 |
- CREATE TABLE VM_SET_RECORD(
- PSR_BATCHNO VARCHAR(30) NOT NULL COMMENT '批次号',
- PSR_CHANNEL VARCHAR(5) COMMENT '渠道(V01:自助售货机)',
- PSR_VERSION VARCHAR(10) NOT NULL COMMENT '版本号',
- PSR_CSTTYPE VARCHAR(2) COMMENT '客户类型(0商户 1代理商)',
- PSR_CSTNO VARCHAR(10) COMMENT '客户号,记录商户、代理商id,既IM_USER表主键',
- PSR_SET_INF_NO VARCHAR(10) COMMENT '结算规则编号',
- PSR_BEGINSETDATE VARCHAR(14) COMMENT '结算起始时间',
- PSR_ENDSETDATE VARCHAR(14) COMMENT '结算结束时间',
- PSR_REFUNDCOUNT VARCHAR(10) COMMENT '退款总数',
- PSR_SUMREFUNDAMOUNT VARCHAR(18) COMMENT '退款金额',
- PSR_TRXCOUNT VARCHAR(10) COMMENT '交易总数',
- PSR_SUMTRXAMOUNT VARCHAR(18) COMMENT '交易金额',
- PSR_SUMTRXFEEACOUNT VARCHAR(10) COMMENT '手续费笔数',
- PSR_SUMTRXFEEAMOUNT VARCHAR(18) COMMENT '手续费金额',
- PSR_BKGEAMT VARCHAR(18) COMMENT '佣金金额',
- PSR_SUMREALAMOUNT VARCHAR(18) COMMENT '实际打款金额',
- PSR_SETTLEFEE VARCHAR(18) COMMENT '结算手续费',
- PSR_STATUS CHAR(1) COMMENT '状态(0.未审核，1已审核，2审核拒绝态,3已结算)',
- PSR_REMARKS VARCHAR(300) COMMENT '备注',
- PSR_REASON VARCHAR(300) COMMENT '拒绝原因',
- PSR_SETTLEMENTDATE VARCHAR(14) COMMENT '结算时间',
- PSR_SETTLEMENTTYPE VARCHAR(1) DEFAULT '1' COMMENT '结算类型(0:手动结算;1:自动结算)',
- PSR_TYPE VARCHAR(2) COMMENT '交易类型70结算',
- PSR_CYCLETYPE VARCHAR(10) COMMENT '结算周期类型(1:每日;2:每周;3:每月)',
- PSR_CYCLEDATA VARCHAR(10) COMMENT '结算周期',
- PSR_CYCLETIME VARCHAR(2) COMMENT '结算时间点(日结)',
- PRIMARY KEY (PSR_BATCHNO)
- )ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='结算记录表';
|
