一. 如下对账表数据结构
create tablet_cgw_ckjnl
(
CNL_CODEvarchar(10) default ‘ ‘ not null comment ‘通道编码‘,
CNL_PLT_CDvarchar(32) default ‘ ‘ not null comment ‘通道平台号‘,
CNL_TYPvarchar(10) default ‘ ‘ not null comment ‘通道类型‘,
CHK_BAT_NOvarchar(32) default ‘ ‘ not null comment ‘对账批次号‘,
BAT_NOvarchar(32) default ‘ ‘ not null comment ‘交易批次号‘,
SEQ_NOvarchar(8) default ‘ ‘ not null comment ‘批次序列号‘,
CHK_ORD_NOvarchar(64) default ‘ ‘ not null comment ‘对账订单号‘,
CHK_TYPvarchar(10) default ‘ ‘ not null comment ‘对账类型‘,
CHK_MODvarchar(2) default ‘ ‘ not null comment ‘对账方式(预留:通道订单号、交易批次号+通道订单号、交易批次号+批次序列号)‘,
CHK_DTvarchar(8) default ‘ ‘ not null comment ‘对账日期‘,
CHK_TMvarchar(6) default ‘ ‘ not null comment ‘对账时间‘,
CHK_STSvarchar(1) default ‘0‘ not null comment ‘对账状态‘,
REQ_DTvarchar(8) default ‘0‘ not null comment ‘交易请求日期‘,
IIF_TY