377 lines
102 KiB
SQL
377 lines
102 KiB
SQL
|
|
|
|
|
|
-- 柜号导入显示模板
|
|
|
|
delete from BF_TEMPLATE where id='091cbd1a827243ae821e75fcddc5319b';
|
|
|
|
insert into `BF_TEMPLATE` (`ID`, `SERIALNO`, `SORTNUMBER`, `TEMPLATENAME`, `TEMPLATESHOWNAME`, `TEMPLATEPATH`, `TEMPLATETYPE`, `OPERATETYPE`, `CALLBACK`, `CREATEMETHOD`, `DOCTYPE`, `ONECLASSIFY`, `TWOCLASSIFY`, `THREECLASSIFY`, `FOURCLASSIFY`, `TEMPLATEVERSION`, `STATUS`, `REMARK`, `INPUTUSERID`, `INPUTORGID`, `INPUTTIME`, `UPDATEUSERID`, `UPDATEORGID`, `UPDATETIME`, `CREATECONDITION`, `CREATESHEETCONDITION`) values('091cbd1a827243ae821e75fcddc5319b',NULL,'','邮寄柜号导入','邮寄柜号导入','柜号导入.xlsx','excel','create','',NULL,'','','','','','1','','','administrator','8009001','2020/03/24 23:29:48','administrator','8009001','2020/04/13 17:51:44','','');
|
|
|
|
-- 邮寄柜号导入菜单
|
|
delete from AWE_MENU_INFO where menuid='3000500110';
|
|
delete from AWE_Role_Menu where menuid='3000500110';
|
|
|
|
Insert Into AWE_MENU_INFO (menuid,menuname,displayname,sortno,url,urlparam,target,style,isinuse,remark,inputorgid,inputuserid,inputtime,updateorgid,updateuserid,updatetime,accesstype,icon,appicon) Values ('3000500110','邮寄柜号导入','邮寄柜号导入','3000500110','/Tenwa/Lease/Flow/Comm/LBImportPage/FileInformationImportList.jsp','','_self','','1','',null,'SYS_Designer','2020/03/15 20:55:01',null,'SYS_Designer','2020/04/27 17:09:26','10','','');
|
|
Insert Into AWE_Role_Menu (roleid,menuid) Values ('099','3000500110');
|
|
Insert Into AWE_Role_Menu (roleid,menuid) Values ('299','3000500110');
|
|
Insert Into AWE_Role_Menu (roleid,menuid) Values ('399','3000500110');
|
|
|
|
|
|
|
|
-- 导入配置列表
|
|
|
|
delete from BF_IMPORTCONFIG where id='018d0e31593a4c1398c27c2ce4bb0ae2';
|
|
|
|
insert into `BF_IMPORTCONFIG` (`ID`, `IMPORTTABLE`, `ROWLINE`, `DATEINDEX`, `SHEETNAME`, `ISDELDATE`, `DELCONDITION`, `IMPORTCLASS`, `CENOTE`, `INPUTUSERID`, `INPUTORGID`, `INPUTTIME`, `UPDATEUSERID`, `UPDATEORGID`, `UPDATETIME`, `RELATIVECLASS`, `TEMPLATEID`, `ISSAVE`) values('018d0e31593a4c1398c27c2ce4bb0ae2','LB_FILE_ARCHIVING_INFO','1','2','','','','com.tenwa.apzl.comm.MailingContainerNumberImport','','','','','','','','jbo.com.tenwa.lease.comm.LB_FILE_ARCHIVING_INFO','091cbd1a827243ae821e75fcddc5319b','');
|
|
|
|
|
|
|
|
|
|
-- 导入配置字段列
|
|
delete from BF_IMPORTCOLUMN where importconfig='018d0e31593a4c1398c27c2ce4bb0ae2';
|
|
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('1c5b2c3e42d34d979168da2187a3410c','档案柜号','ARCHIVING_CABINET_NO','data_type7','yes','data_source2','','','018d0e31593a4c1398c27c2ce4bb0ae2','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('731e555ba01045109732982a0e49759a','备注','DEMO','data_type7','no','data_source2','','','018d0e31593a4c1398c27c2ce4bb0ae2','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('7476e2a145f44a87834da43d2f7af832','档案编号','FILE_NUMBER','data_type7','yes','data_source2','','','018d0e31593a4c1398c27c2ce4bb0ae2','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('87cfd97b234a4d6ca729c95d7c2d69cd','合同编号','CONTRACT_NUMBER','data_type7','yes','data_source2','','','018d0e31593a4c1398c27c2ce4bb0ae2','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('b21873fe55bd48c8a7b4bb9e5aa05fbc','归档时间','ARCHIVING_TIME','data_type7','yes','data_source2','','','018d0e31593a4c1398c27c2ce4bb0ae2','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('bb38006e501e40a5983ff84c3a243c5e','归档人','ARCHIVING_PERSON','data_type7','no','data_source4','com.tenwa.lease.function.ImportContractId','','018d0e31593a4c1398c27c2ce4bb0ae2','','','','','','');
|
|
|
|
|
|
|
|
|
|
-- 柜号导入info模板
|
|
|
|
|
|
delete from AWE_DO_CATALOG where dono='FilingCabinetinfo';
|
|
delete from awe_do_library where dono='FilingCabinetinfo';
|
|
|
|
|
|
Insert Into AWE_DO_CATALOG (dono,doname,dodescribe,dotype,doclass,isinuse,colcount,modeid,jboclass,jbofrom,jbowhere,jbogroup,jboorder,businessprocess,exportflag,inputuser,inputtime,updateuser,updatetime,remark,isvalidate,parent) Values ('FilingCabinetinfo','档案柜号导入',null,'30030',null,'1','2','default','jbo.com.tenwa.lease.comm.LB_FILE_ARCHIVING_INFO','O','id=:id','','','',null,'SYS_Designer','2020/03/24 23:35:10','SYS_Designer','2020/04/16 18:52:34','','1','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetinfo','0010','0010','1','O','ID','ID','String','','主键','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:29','SYS_Designer','2020/04/16 18:52:34','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetinfo','0020','0020','1','O','CONTRACT_NUMBER','CONTRACT_NUMBER','String','','合同编号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:29','SYS_Designer','2020/04/16 18:52:34','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetinfo','0030','0030','1','O','ARCHIVING_TIME','ARCHIVING_TIME','String','','归档时间','','1','Date','3','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:29','SYS_Designer','2020/04/17 17:20:21','0','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetinfo','0040','0040','1','O','ARCHIVING_CABINET_NO','ARCHIVING_CABINET_NO','String','','档案柜号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:29','SYS_Designer','2020/04/16 18:52:34','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetinfo','0050','0060','1','O','DEMO','DEMO','String','','备注','','1','Textarea','1','1','','','style={height:100px; width:650px}','1000','1','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:29','SYS_Designer','2020/04/16 18:52:34','0','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetinfo','0060','0050','1','O','FILE_NUMBER','FILE_NUMBER','String','','档案编号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:29','SYS_Designer','2020/04/16 18:52:34','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetinfo','0070','0070','1','O','INPUTUSERID','INPUTUSERID','String','','登记人','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:52:34','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetinfo','0080','0080','1','O','INPUTORGID','INPUTORGID','String','','登记部门','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:52:34','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetinfo','0090','0090','1','O','INPUTTIME','INPUTTIME','String','','登记时间','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:52:34','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetinfo','0100','0100','1','O','UPDATEUSERID','UPDATEUSERID','String','','更新人','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:52:34','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetinfo','0110','0110','1','O','UPDATEORGID','UPDATEORGID','String','','更新部门','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:52:34','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetinfo','0120','0120','1','O','UPDATETIME','UPDATETIME','String','','更新时间','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:52:34','','','1','','','','');
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- 柜号导入list模板
|
|
|
|
|
|
delete from AWE_DO_CATALOG where dono='FilingCabinetlist';
|
|
delete from awe_do_library where dono='FilingCabinetlist';
|
|
|
|
|
|
|
|
Insert Into AWE_DO_CATALOG (dono,doname,dodescribe,dotype,doclass,isinuse,colcount,modeid,jboclass,jbofrom,jbowhere,jbogroup,jboorder,businessprocess,exportflag,inputuser,inputtime,updateuser,updatetime,remark,isvalidate,parent) Values ('FilingCabinetlist','档案柜号导入',null,'30030',null,'1','1','default','jbo.com.tenwa.lease.comm.LB_FILE_ARCHIVING_INFO','O','','','','',null,'SYS_Designer','2020/03/24 23:20:34','SYS_Designer','2020/04/16 18:46:52','','1','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetlist','0010','0010','1','O','ID','ID','String','','主键','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:46:52','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetlist','0020','0020','1','O','CONTRACT_NUMBER','CONTRACT_NUMBER','String','','合同编号','','1','Text','1','1','','','','32','1','0','0','1','1',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:52:34','0','','1','','','','Like,Equals');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetlist','0030','0030','1','O','ARCHIVING_TIME','ARCHIVING_TIME','String','','归档时间','','1','Date','3','1','','','','32','1','0','0','1','1',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/17 18:03:30','0','','1','','','','Like,Equals');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetlist','0040','0040','1','O','ARCHIVING_CABINET_NO','ARCHIVING_CABINET_NO','String','','档案柜号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:46:52','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetlist','0050','0060','1','O','REMARKS','REMARKS','String','','备注','','1','Text','1','1','','','','1000','1','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/26 10:07:24','0','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetlist','0060','0050','1','O','FILE_NUMBER','FILE_NUMBER','String','','档案编号','','1','Text','1','1','','','','32','1','0','0','1','1',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:52:34','0','','1','','','','Like,Equals');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetlist','0070','0070','1','O','INPUTUSERID','INPUTUSERID','String','','登记人','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:46:52','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetlist','0080','0080','1','O','INPUTORGID','INPUTORGID','String','','登记部门','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:46:52','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetlist','0090','0090','1','O','INPUTTIME','INPUTTIME','String','','登记时间','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:46:52','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetlist','0100','0100','1','O','UPDATEUSERID','UPDATEUSERID','String','','更新人','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:46:52','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetlist','0110','0110','1','O','UPDATEORGID','UPDATEORGID','String','','更新部门','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:46:52','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('FilingCabinetlist','0120','0120','1','O','UPDATETIME','UPDATETIME','String','','更新时间','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/04/16 11:31:30','SYS_Designer','2020/04/16 18:46:52','','','1','','','','');
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- 新增微信账单导入表
|
|
|
|
CREATE TABLE `wx_pay_the_bills` (
|
|
`id` varchar(32) NOT NULL COMMENT '标识',
|
|
`Trading_hours` varchar(32) DEFAULT NULL COMMENT '交易时间',
|
|
`merchants_number` varchar(32) DEFAULT NULL COMMENT '商户号',
|
|
`Engaged_merchant_number` varchar(32) DEFAULT NULL COMMENT '特约商户号',
|
|
`Device_number` varchar(32) DEFAULT NULL COMMENT '设备号',
|
|
`WX_order_number` varchar(32) DEFAULT NULL COMMENT '微信订单号',
|
|
`Merchant_order_no` varchar(32) DEFAULT NULL COMMENT '商户订单号',
|
|
`User_identification` varchar(32) DEFAULT NULL COMMENT '用户标识',
|
|
`Transaction_type` varchar(32) DEFAULT NULL COMMENT '交易类型',
|
|
`Transaction_status` varchar(32) DEFAULT NULL COMMENT '交易状态',
|
|
`payment_bank` varchar(32) DEFAULT NULL COMMENT '付款银行',
|
|
`Currency_type` varchar(32) DEFAULT NULL COMMENT '货币种类',
|
|
`order_amount_money` varchar(32) DEFAULT NULL COMMENT '应结订单金额',
|
|
`voucher_money` varchar(32) DEFAULT NULL COMMENT '代金券金额',
|
|
`WX_refund_number` varchar(32) DEFAULT NULL COMMENT '微信退款单号',
|
|
`merchant_refund_number` varchar(32) DEFAULT NULL COMMENT '商户退款单号',
|
|
`refund_money` varchar(32) DEFAULT NULL COMMENT '退款金额',
|
|
`voucher_refund_money` varchar(32) DEFAULT NULL COMMENT '充值券退款金额',
|
|
`refund_type` varchar(32) DEFAULT NULL COMMENT '退款类型',
|
|
`refund_state` varchar(32) DEFAULT NULL COMMENT '退款状态',
|
|
`goods_name` varchar(32) DEFAULT NULL COMMENT '商品名称',
|
|
`merchant_data` varchar(32) DEFAULT NULL COMMENT '商户数据包',
|
|
`poundage` varchar(32) DEFAULT NULL COMMENT '手续费',
|
|
`rate` varchar(32) DEFAULT NULL COMMENT '费率',
|
|
`order_money` varchar(32) DEFAULT NULL COMMENT '订单金额',
|
|
`Refund_amount` varchar(32) DEFAULT NULL COMMENT '申请退款金额',
|
|
`Rate_note` varchar(32) DEFAULT NULL COMMENT '费率备注',
|
|
`Total_transaction_number` varchar(32) DEFAULT NULL COMMENT '总交易单数',
|
|
`Total_order_amount_money` varchar(32) DEFAULT NULL COMMENT '应结订单总金额',
|
|
`Total_refund` varchar(32) DEFAULT NULL COMMENT '退款总金额',
|
|
`voucher_Total_refund` varchar(32) DEFAULT NULL COMMENT '充值券退款总金额',
|
|
`poundage_total_amount` varchar(32) DEFAULT NULL COMMENT '手续费总金额',
|
|
`Total_order_amount` varchar(32) DEFAULT NULL COMMENT '订单总金额',
|
|
`apply_Total_refund` varchar(32) DEFAULT NULL COMMENT '申请退款总金额',
|
|
`money` varchar(32) DEFAULT NULL COMMENT '金额',
|
|
`INPUTUSERID` varchar(32) DEFAULT NULL COMMENT '登记人',
|
|
`INPUTORGID` varchar(32) DEFAULT NULL COMMENT '登记部门',
|
|
`INPUTTIME` varchar(32) DEFAULT NULL COMMENT '登记时间',
|
|
`UPDATEUSERID` varchar(32) DEFAULT NULL COMMENT '更新人',
|
|
`UPDATEORGID` varchar(32) DEFAULT NULL COMMENT '更新部门',
|
|
`UPDATETIME` varchar(32) DEFAULT NULL COMMENT '更新日期',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- 微信账单导入菜单
|
|
delete from AWE_MENU_INFO where menuid='980200';
|
|
delete from AWE_Role_Menu where menuid='980200';
|
|
Insert Into AWE_MENU_INFO (menuid,menuname,displayname,sortno,url,urlparam,target,style,isinuse,remark,inputorgid,inputuserid,inputtime,updateorgid,updateuserid,updatetime,accesstype,icon,appicon) Values ('980200','微信支付账单导入','微信支付账单导入','980200','/Tenwa/Lease/Flow/Comm/LBImportPage/PayBillImportList.jsp','','_self','','1','',null,'SYS_Designer','2020/03/17 19:20:36',null,'SYS_Designer','2020/03/17 19:20:36','10','','');
|
|
Insert Into AWE_Role_Menu (roleid,menuid) Values ('099','980200');
|
|
Insert Into AWE_Role_Menu (roleid,menuid) Values ('299','980200');
|
|
Insert Into AWE_Role_Menu (roleid,menuid) Values ('399','980200');
|
|
Insert Into AWE_Role_Menu (roleid,menuid) Values ('800','980200');
|
|
|
|
|
|
|
|
|
|
-- 微信账单导入显示模板
|
|
|
|
delete from BF_TEMPLATE where id='8f9770f5088b487abd3f6a03d56d7dd0';
|
|
|
|
insert into `BF_TEMPLATE` (`ID`, `SERIALNO`, `SORTNUMBER`, `TEMPLATENAME`, `TEMPLATESHOWNAME`, `TEMPLATEPATH`, `TEMPLATETYPE`, `OPERATETYPE`, `CALLBACK`, `CREATEMETHOD`, `DOCTYPE`, `ONECLASSIFY`, `TWOCLASSIFY`, `THREECLASSIFY`, `FOURCLASSIFY`, `TEMPLATEVERSION`, `STATUS`, `REMARK`, `INPUTUSERID`, `INPUTORGID`, `INPUTTIME`, `UPDATEUSERID`, `UPDATEORGID`, `UPDATETIME`, `CREATECONDITION`, `CREATESHEETCONDITION`) values('8f9770f5088b487abd3f6a03d56d7dd0',NULL,'','微信账单导入','微信支付账单导入','微信账单导入.xlsx','excel','upload','',NULL,'','','','','','1','','','administrator','8009001','2020/03/18 15:39:16','administrator','8009001','2020/03/19 11:32:12','','');
|
|
|
|
|
|
|
|
|
|
-- 导入配置列表
|
|
|
|
delete from BF_IMPORTCONFIG where id='c135318397dc49f29f13029be7cf07b8';
|
|
|
|
insert into `BF_IMPORTCONFIG` (`ID`, `IMPORTTABLE`, `ROWLINE`, `DATEINDEX`, `SHEETNAME`, `ISDELDATE`, `DELCONDITION`, `IMPORTCLASS`, `CENOTE`, `INPUTUSERID`, `INPUTORGID`, `INPUTTIME`, `UPDATEUSERID`, `UPDATEORGID`, `UPDATETIME`, `RELATIVECLASS`, `TEMPLATEID`, `ISSAVE`) values('c135318397dc49f29f13029be7cf07b8','wx_pay_the_bills','1','2','','','','com.tenwa.apzl.comm.BillstopayImport','','','','','','','','jbo.com.tenwa.lease.comm.WX_PAY_THE_BILLS','8f9770f5088b487abd3f6a03d56d7dd0','');
|
|
|
|
|
|
|
|
|
|
|
|
-- 导入配置字段列
|
|
delete from BF_IMPORTCOLUMN where importconfig='c135318397dc49f29f13029be7cf07b8';
|
|
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('076575442cd24f48953d92d072b6a3fa','特约商户号','Engaged_merchant_number','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('18222c55f91742f38e855b83b9091fbd','金额','money','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('1fe016c6b05c407cb8d871d2f8cc055d','交易时间','Trading_hours','data_type3','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('2e05ed8f9ab549c8af39f030543528d9','应结订单总金额','Total_order_amount_money','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('322d2b3ca539493fbf8365aab05a4fbb','总交易单数','Total_transaction_number','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('3457d466fe2e4de990fce6aad9cc71dd','交易状态','Transaction_status','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('4020fb61187e4276ab2aee1e49e149ff','退款状态','refund_state','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('40a26f499c4046a9bd23b2039c6e29da','货币种类','Currency_type','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('476e3f4eed0c430797e53593ce9696c1','退款类型','refund_type','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('4b4e0e9a864443529f6681585fcd0b12','申请退款总金额','apply_Total_refund','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('4d44acfe7b0445fca890ef563022ea9e','订单总金额','Total_order_amount','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('5c88fa1b96f340fd9937b1539d91c69a','商品名称','goods_name','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('601bb745ae814938afd738b194d08ba9','充值券退款金额','voucher_refund_money','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('612f4b5a710b43a5a8b0102cdf734033','手续费','poundage','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('6e04fcf8d6cd463dba47b89cabd2cfc9','微信退款单号','WX_refund_number','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('6e3cb8c7219e4717a70dd81b0f684ca4','商户数据包','merchant_data','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('7495eeb09af241d0b34a1adf051947b3','充值券退款总金额','voucher_Total_refund','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('7fd4c45f904e44f3a7e8ea930acf2be8','退款金额','refund_money','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('85daddc04a114393bbd9a89c587cffe5','付款银行','payment_bank','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('878a2b02004d4678aa05bcb3515e729b','微信订单号','WX_order_number','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('897f0ed52be348ecab63be485bb256a6','商户退款单号','merchant_refund_number','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('975dcc6940dd4e8d9f34e23f520c3600','费率备注','Rate_note','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('97ce1c0319e443cb97cfc90045eb6662','代金券金额','voucher_money','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('9bfce7ccd2e24469ab7f169f9d3bcca1','用户标识','User_identification','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('bd6b03e7c65944299dde7cb3bc58755b','商户订单号','Merchant_order_no','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('c422ec717f8f4fd289c21af65232c353','设备号','Device_number','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('ceb26f0a32814069bec41224f3007951','订单金额','order_money','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('da32c6db130d4efa8baff209cee06b07','交易类型','Transaction_type','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('e6154574d7e64a3791d915fe0032b3be','费率','rate','data_type8','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('eb5795b00e24424e841878ea2ec6f8a2','手续费总金额','poundage_total_amount','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('ebee1fb71a9b4a37b867a72e1c7c59af','申请退款金额','Refund_amount','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('ed7903d2141e415584a9e531222daed3','应结订单金额','order_amount_money','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('f3609f692fdb478ba5529c5692bd8a45','退款总金额','Total_refund','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
insert into `BF_IMPORTCOLUMN` (`ID`, `IMPORTTITLE`, `IMPORTCOLUMN`, `DATATYPE`, `ISIMPORT`, `DATESOURCE`, `SOURESQL`, `MEMO`, `IMPORTCONFIG`, `INPUTUSERID`, `INPUTORGID`, `UPDATEUSERID`, `UPDATEORGID`, `INPUTTIME`, `UPDATETIME`) values('f735a6e7253447868f861f30751dca93','商户号','merchants_number','data_type7','yes','data_source2','','','c135318397dc49f29f13029be7cf07b8','','','','','','');
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- 微信账单导入info模板
|
|
|
|
|
|
delete from AWE_DO_CATALOG where dono='LCPayBillInfo';
|
|
delete from awe_do_library where dono='LCPayBillInfo';
|
|
|
|
Insert Into AWE_DO_CATALOG (dono,doname,dodescribe,dotype,doclass,isinuse,colcount,modeid,jboclass,jbofrom,jbowhere,jbogroup,jboorder,businessprocess,exportflag,inputuser,inputtime,updateuser,updatetime,remark,isvalidate,parent) Values ('LCPayBillInfo','微信账单导入',null,'30120',null,'1','2','default','jbo.com.tenwa.lease.comm.WX_PAY_THE_BILLS','','','','','',null,'SYS_Designer','2020/03/17 19:06:09','SYS_Designer','2020/03/19 11:40:20','','1','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0010','0010','1','O','ID','ID','String','','标识','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:21','SYS_Designer','2020/03/19 12:16:57','0','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0020','0020','1','O','Trading_hours','Trading_hours','String','','交易时间','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:21','SYS_Designer','2020/03/19 11:42:21','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0030','0030','1','O','merchants_number','merchants_number','String','','商户号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:21','SYS_Designer','2020/03/19 11:42:21','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0040','0040','1','O','Engaged_merchant_number','Engaged_merchant_number','String','','特约商户号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:21','SYS_Designer','2020/03/19 11:42:21','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0050','0050','1','O','Device_number','Device_number','String','','设备号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:21','SYS_Designer','2020/03/19 11:42:21','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0060','0060','1','O','WX_order_number','WX_order_number','String','','微信订单号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:21','SYS_Designer','2020/03/19 11:42:21','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0070','0070','1','O','Merchant_order_no','Merchant_order_no','String','','商户订单号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0080','0080','1','O','User_identification','User_identification','String','','用户标识','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0090','0090','1','O','Transaction_type','Transaction_type','String','','交易类型','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0100','0100','1','O','Transaction_status','Transaction_status','String','','交易状态','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0110','0110','1','O','payment_bank','payment_bank','String','','付款银行','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0120','0120','1','O','Currency_type','Currency_type','String','','货币种类','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0130','0130','1','O','order_amount_money','order_amount_money','String','','应结订单金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0140','0140','1','O','voucher_money','voucher_money','String','','代金券金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0150','0150','1','O','WX_refund_number','WX_refund_number','String','','微信退款单号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0160','0160','1','O','merchant_refund_number','merchant_refund_number','String','','商户退款单号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0170','0170','1','O','refund_money','refund_money','String','','退款金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0180','0180','1','O','voucher_refund_money','voucher_refund_money','String','','充值券退款金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0190','0190','1','O','refund_type','refund_type','String','','退款类型','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0200','0200','1','O','refund_state','refund_state','String','','退款状态','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0210','0210','1','O','goods_name','goods_name','String','','商品名称','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0220','0220','1','O','merchant_data','merchant_data','String','','商户数据包','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0230','0230','1','O','poundage','poundage','String','','手续费','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0240','0240','1','O','rate','rate','String','','费率','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0250','0250','1','O','order_money','order_money','String','','订单金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0260','0260','1','O','Refund_amount','Refund_amount','String','','申请退款金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0270','0270','1','O','Rate_note','Rate_note','String','','费率备注','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0280','0280','1','O','Total_transaction_number','Total_transaction_number','String','','总交易单数','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0290','0290','1','O','Total_order_amount_money','Total_order_amount_money','String','','应结订单总金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0300','0300','1','O','Total_refund','Total_refund','String','','退款总金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0310','0310','1','O','voucher_Total_refund','voucher_Total_refund','String','','充值券退款总金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0320','0320','1','O','poundage_total_amount','poundage_total_amount','String','','手续费总金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0330','0330','1','O','Total_order_amount','Total_order_amount','String','','订单总金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0340','0340','1','O','apply_Total_refund','apply_Total_refund','String','','申请退款总金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0350','0350','1','O','money','money','String','','金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0360','0360','1','O','INPUTUSERID','INPUTUSERID','String','','登记人','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0370','0370','1','O','INPUTORGID','INPUTORGID','String','','登记部门','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0380','0380','1','O','INPUTTIME','INPUTTIME','String','','登记时间','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0390','0390','1','O','UPDATEUSERID','UPDATEUSERID','String','','更新人','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0400','0400','1','O','UPDATEORGID','UPDATEORGID','String','','更新部门','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillInfo','0410','0410','1','O','UPDATETIME','UPDATETIME','String','','更新日期','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
-- 微信账单导入list模板
|
|
|
|
|
|
delete from AWE_DO_CATALOG where dono='LCPayBillList';
|
|
delete from awe_do_library where dono='LCPayBillList';
|
|
|
|
|
|
Insert Into AWE_DO_CATALOG (dono,doname,dodescribe,dotype,doclass,isinuse,colcount,modeid,jboclass,jbofrom,jbowhere,jbogroup,jboorder,businessprocess,exportflag,inputuser,inputtime,updateuser,updatetime,remark,isvalidate,parent) Values ('LCPayBillList','微信账单导入',null,'30120',null,'1','1','default','jbo.com.tenwa.lease.comm.WX_PAY_THE_BILLS','','','','','',null,'SYS_Designer','2020/03/17 19:05:34','SYS_Designer','2020/03/19 11:40:34','','1','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0010','0010','1','O','ID','ID','String','','标识','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 12:17:18','0','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0020','0020','1','O','Trading_hours','Trading_hours','String','','交易时间','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0030','0030','1','O','merchants_number','merchants_number','String','','商户号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0040','0040','1','O','Engaged_merchant_number','Engaged_merchant_number','String','','特约商户号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0050','0050','1','O','Device_number','Device_number','String','','设备号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0060','0060','1','O','WX_order_number','WX_order_number','String','','微信订单号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0070','0070','1','O','Merchant_order_no','Merchant_order_no','String','','商户订单号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0080','0080','1','O','User_identification','User_identification','String','','用户标识','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0090','0090','1','O','Transaction_type','Transaction_type','String','','交易类型','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0100','0100','1','O','Transaction_status','Transaction_status','String','','交易状态','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0110','0110','1','O','payment_bank','payment_bank','String','','付款银行','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0120','0120','1','O','Currency_type','Currency_type','String','','货币种类','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0130','0130','1','O','order_amount_money','order_amount_money','String','','应结订单金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0140','0140','1','O','voucher_money','voucher_money','String','','代金券金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0150','0150','1','O','WX_refund_number','WX_refund_number','String','','微信退款单号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0160','0160','1','O','merchant_refund_number','merchant_refund_number','String','','商户退款单号','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:22','SYS_Designer','2020/03/19 11:42:22','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0170','0170','1','O','refund_money','refund_money','String','','退款金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0180','0180','1','O','voucher_refund_money','voucher_refund_money','String','','充值券退款金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0190','0190','1','O','refund_type','refund_type','String','','退款类型','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0200','0200','1','O','refund_state','refund_state','String','','退款状态','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0210','0210','1','O','goods_name','goods_name','String','','商品名称','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0220','0220','1','O','merchant_data','merchant_data','String','','商户数据包','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0230','0230','1','O','poundage','poundage','String','','手续费','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0240','0240','1','O','rate','rate','String','','费率','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0250','0250','1','O','order_money','order_money','String','','订单金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0260','0260','1','O','Refund_amount','Refund_amount','String','','申请退款金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0270','0270','1','O','Rate_note','Rate_note','String','','费率备注','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0280','0280','1','O','Total_transaction_number','Total_transaction_number','String','','总交易单数','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0290','0290','1','O','Total_order_amount_money','Total_order_amount_money','String','','应结订单总金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0300','0300','1','O','Total_refund','Total_refund','String','','退款总金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0310','0310','1','O','voucher_Total_refund','voucher_Total_refund','String','','充值券退款总金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0320','0320','1','O','poundage_total_amount','poundage_total_amount','String','','手续费总金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0330','0330','1','O','Total_order_amount','Total_order_amount','String','','订单总金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0340','0340','1','O','apply_Total_refund','apply_Total_refund','String','','申请退款总金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0350','0350','1','O','money','money','String','','金额','','1','Text','1','1','','','','32','1','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0360','0360','1','O','INPUTUSERID','INPUTUSERID','String','','登记人','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0370','0370','1','O','INPUTORGID','INPUTORGID','String','','登记部门','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0380','0380','1','O','INPUTTIME','INPUTTIME','String','','登记时间','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0390','0390','1','O','UPDATEUSERID','UPDATEUSERID','String','','更新人','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0400','0400','1','O','UPDATEORGID','UPDATEORGID','String','','更新部门','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
Insert Into awe_do_library (dono,colindex,sortno,isinuse,coltablename,colactualname,colname,coltype,coldefaultvalue,colheader,colunit,colcolumntype,coleditstyle,colcheckformat,colalign,coleditsourcetype,coleditsource,colhtmlstyle,collimit,colvisible,colreadonly,colrequired,colsortable,isfilter,colspan,isautocomplete,groupid,colfilterrefid,inputuser,inputtime,updateuser,updatetime,isaudit,colfilterattrs,isupdate,parentcolindex,tips,colinnerbtevent,colfilteroptions) Values ('LCPayBillList','0410','0410','1','O','UPDATETIME','UPDATETIME','String','','更新日期','','1','Text','1','1','','','','32','0','0','0','1','0',0,'','','','SYS_Designer','2020/03/19 11:42:23','SYS_Designer','2020/03/19 11:42:23','','','1','','','','');
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|