582 lines
205 KiB
SQL
582 lines
205 KiB
SQL
-- VILCRentPlanListÄ£°å
|
||
delete from AWE_DO_CATALOG where dono='VILCRentPlanList';
|
||
delete from awe_do_library where dono='VILCRentPlanList';
|
||
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 ('VILCRentPlanList','×â½ð¼Æ»®ÊÓͼ±í',null,'30120',null,'1','1','default','jbo.loan.VI_RENT_COLLECT_4_EBANK','O left join jbo.com.tenwa.lease.comm.LB_CAR_LICENSE_PLATE_INFO lcl on O.contract_id=lcl.contract_id','O.businesstype=:businessType and O.subjectid=:subjectId and (O.batch_status<>''process'' or O.batch_status is null) and v.DATE_FORMAT(O.plan_date,''%Y%m'') <= v.DATE_FORMAT(v.SYSDATE(),''%Y%m'') and rent_over>0','','','com.tenwa.flow.rent.rentincome.VILCRentPlanListHandler',null,'SYS_Designer','2017/06/04 20:29:52','SYS_Designer','2020/10/10 18:10:58','','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 ('VILCRentPlanList','1000','1000','1','O','id','id','String','','×â½ð¼Æ»®±àºÅ','','1','Text','1','1','','','','20','0','0','0','1','0',1,'0','','','SYS_DESIGNER','2017/06/04 20:29:52','SYS_Designer','2020/10/10 18:10:58','','','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 ('VILCRentPlanList','1010','1010','1','O','contract_number','contract_number','String','','ÒµÎñºÏͬºÅ','','1','Text','1','1','','','','32','1','0','0','1','1',1,'0','','','SYS_DESIGNER','2017/06/04 20:29:52','SYS_Designer','2020/10/10 18:10:58','0','','1','','','','Equals,Like');
|
||
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 ('VILCRentPlanList','1020','1020','1','O','payment_number','payment_number','String','','Ͷ·Å±àºÅ','','1','Text','1','1','','','','20','0','0','0','1','0',1,'0','','','SYS_DESIGNER','2017/06/04 20:29:52','SYS_Designer','2020/10/10 18:10:58','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 ('VILCRentPlanList','1030','1030','1','O','customername','customername','String','','¿Í»§Ãû³Æ','','1','Text','1','1','','','','20','1','0','0','1','1',1,'0','','','SYS_DESIGNER','2017/06/04 20:29:52','SYS_Designer','2020/10/10 18:10:58','0','','1','','','','Equals,Like');
|
||
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 ('VILCRentPlanList','1050','1050','1','O','plan_list','plan_list','String','','ÆÚ´Î','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_DESIGNER','2017/06/04 20:29:52','SYS_Designer','2020/10/10 18:10:58','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 ('VILCRentPlanList','1060','1060','1','O','plan_date','plan_date','String','','¼Æ»®ÈÕÆÚ','','1','Date','3','1','','','','20','1','0','0','1','1',1,'0','','','SYS_DESIGNER','2017/06/04 20:29:52','SYS_Designer','2020/10/10 18:10:58','0','','1','','','','BigThan,LessThan,Area');
|
||
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 ('VILCRentPlanList','1070','1070','1','O','rent','rent','Number','','¼Æ»®×â½ð','','1','Text','2','3','','','','20','1','0','0','1','0',1,'0','','','SYS_DESIGNER','2017/06/04 20:29:52','SYS_Designer','2020/10/10 18:10:58','','','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 ('VILCRentPlanList','1080','1080','1','O','corpus','corpus','Number','','¼Æ»®±¾½ð','','1','Text','2','3','','','','20','1','0','0','1','0',1,'0','','','SYS_DESIGNER','2017/06/04 20:29:52','SYS_Designer','2020/10/10 18:10:58','','','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 ('VILCRentPlanList','1090','1090','1','O','interest','interest','Number','','¼Æ»®ÀûÏ¢','','1','Text','2','3','','','','20','1','0','0','1','0',1,'0','','','SYS_DESIGNER','2017/06/04 20:29:52','SYS_Designer','2020/10/10 18:10:58','','','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 ('VILCRentPlanList','1095','1095','1','','''''','penalty','Number','','Ó¦ÊÕ·£Ï¢','','1','Text','2','3','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2017/06/26 19:22:54','SYS_Designer','2020/10/10 18:10:58','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 ('VILCRentPlanList','1180','1180','1','O','rent_over','rent_over','Number','','×â½ðÓà¶î','','1','Text','2','3','','','','20','1','0','0','1','1',1,'0','','','SYS_DESIGNER','2017/06/04 20:29:52','SYS_Designer','2020/10/10 18:10:58','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 ('VILCRentPlanList','1190','1190','1','O','corpus_over','corpus_over','Number','','±¾½ðÓà¶î','','1','Text','2','3','','','','20','1','0','0','1','0',1,'0','','','SYS_DESIGNER','2017/06/04 20:29:52','SYS_Designer','2020/10/10 18:10:58','','','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 ('VILCRentPlanList','1200','1200','1','O','interest_over','interest_over','Number','','ÀûÏ¢Óà¶î','','1','Text','2','3','','','','20','1','0','0','1','0',1,'0','','','SYS_DESIGNER','2017/06/04 20:29:52','SYS_Designer','2020/10/10 18:10:58','','','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 ('VILCRentPlanList','1210','1310','1','O','penalty_sum','penalty_sum','Number','','ÒÑÊÕ·£Ï¢½ð¶î','','1','Text','2','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/10/10 18:10:58','SYS_Designer','2020/10/10 18:12:27','','','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 ('VILCRentPlanList','1220','1220','1','','''''','planstatus','String','','»ØÁý״̬','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2017/06/26 12:26:39','SYS_Designer','2020/10/10 18:10:58','','','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 ('VILCRentPlanList','1250','1210','1','','''''','penalty_over','Number','','·£Ï¢Óà¶î','','1','Text','2','3','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2017/06/26 19:38:10','SYS_Designer','2020/10/10 18:10:58','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 ('VILCRentPlanList','1270','1270','1','','''''','all_over','Number','','Ê£ÓàÓ¦»¹½ð¶î','','1','Text','2','3','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/04/02 11:17:52','SYS_Designer','2020/10/10 18:10:58','','','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 ('VILCRentPlanList','1290','1290','1','lcl','plate_number','plate_number','String','','³µÅƺÅ','','1','Text','1','1','','','',null,'1','0','0','1','1',0,'','','','SYS_Designer','2020/04/02 11:52:35','SYS_Designer','2020/10/10 18:10:58','','','1','','','','Like');
|
||
|
||
-- ViLcReviewAuditRentPlanList3Ä£°å
|
||
delete from AWE_DO_CATALOG where dono='ViLcReviewAuditRentPlanList3';
|
||
delete from awe_do_library where dono='ViLcReviewAuditRentPlanList3';
|
||
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 ('ViLcReviewAuditRentPlanList3','ÊÖ¹¤¿¨¿Û',null,'30030',null,'1','1','default','jbo.loan.VI_RENT_COLLECT','O','(O.rent_over>0 or penalty_over>0) and O.BUSINESSTYPE=''1'' and O.collect_status IN (''δÊÕ¿î'',''²¿·ÖÊÕ¿î'',''´ú³¥'') and v.date_format(O.PLAN_DATE,''%Y/%m/%d'') <= v.date_format(v.sysdate(),''%Y/%m/%d'')','','','com.tenwa.lease.flow.rent.rentreback.VILCRentCollectHandler',null,'SYS_Designer','2020/08/03 16:54:59','SYS_Designer','2020/09/29 15:23:57','','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 ('ViLcReviewAuditRentPlanList3','1000','1000','1','O','id','id','String','','id','','1','Text','1','1','','','','20','0','1','0','1','0',1,'0','','','SYS_Designer','2020/08/03 16:54:59','SYS_Designer','2020/09/29 15:23: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 ('ViLcReviewAuditRentPlanList3','1005','1005','1','O','SUBJECTNAME','SUBJECTNAME','String','','Ö÷ÌåÃû³Æ','','1','Text','1','1','','','','20','1','1','0','0','0',0,'','','','SYS_Designer','2020/08/03 16:54:59','SYS_Designer','2020/09/29 15:23: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 ('ViLcReviewAuditRentPlanList3','1020','1010','1','O','contract_number','contract_number','String','','ºÏͬ±àºÅ','','1','Text','1','1','','','','32','1','1','0','1','1',1,'0','','','SYS_Designer','2020/08/03 16:54:59','SYS_Designer','2020/09/29 15:23:57','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 ('ViLcReviewAuditRentPlanList3','1040','1029','1','O','plan_list','plan_list','String','','ÆÚ´Î','','1','Text','1','1','','','','20','1','1','0','1','0',1,'0','','','SYS_Designer','2020/08/03 16:54:59','SYS_Designer','2020/09/29 15:23: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 ('ViLcReviewAuditRentPlanList3','1050','1030','1','O','plan_date','plan_date','String','','¼Æ»®ÈÕÆÚ','','1','Date','3','2','','','','20','1','1','0','1','0',1,'0','','','SYS_Designer','2020/08/03 16:54:59','SYS_Designer','2020/09/29 15:23:57','','','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 ('ViLcReviewAuditRentPlanList3','1060','1031','1','O','rent','rent','Number','','×â½ð','','1','Text','2','1','','','','20','1','1','0','1','0',1,'0','','','SYS_Designer','2020/08/03 16:54:59','SYS_Designer','2020/09/29 15:23:57','','','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 ('ViLcReviewAuditRentPlanList3','1070','1032','1','O','corpus','corpus','Number','','±¾½ð','','1','Text','2','1','','','','20','1','1','0','1','0',1,'0','','','SYS_Designer','2020/08/03 16:54:59','SYS_Designer','2020/09/29 15:23:57','','','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 ('ViLcReviewAuditRentPlanList3','1080','1033','1','O','interest','interest','Number','','ÀûÏ¢','','1','Text','2','1','','','','20','1','1','0','1','0',1,'0','','','SYS_Designer','2020/08/03 16:55:00','SYS_Designer','2020/09/29 15:23:57','','','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 ('ViLcReviewAuditRentPlanList3','1090','1040','1','O','rent_over','rent_over','Number','','δ¸¶×â½ð','','1','Text','2','1','','','','20','1','1','0','1','0',1,'0','','','SYS_Designer','2020/08/03 16:55:00','SYS_Designer','2020/09/29 15:23:57','','','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 ('ViLcReviewAuditRentPlanList3','1100','1050','1','O','corpus_over','corpus_over','Number','','δ¸¶±¾½ð','','1','Text','2','1','','','','20','1','1','0','1','0',1,'0','','','SYS_Designer','2020/08/03 16:55:00','SYS_Designer','2020/09/29 15:23:57','','','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 ('ViLcReviewAuditRentPlanList3','1110','1060','1','O','interest_over','interest_over','Number','','δ¸¶ÀûÏ¢','','1','Text','2','1','','','','20','1','1','0','1','0',1,'0','','','SYS_Designer','2020/08/03 16:55:00','SYS_Designer','2020/09/29 15:23: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 ('ViLcReviewAuditRentPlanList3','1150','1023','1','O','acc_number','acc_number','String','','ÒøÐÐÕ˺Å','','1','Text','1','1','','','','20','1','1','0','1','0',1,'0','','','SYS_Designer','2020/08/03 16:55:00','SYS_Designer','2020/09/29 15:23: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 ('ViLcReviewAuditRentPlanList3','1190','1025','1','O','COLLECT_STATUS','COLLECT_STATUS','String','','ÊÕ¸¶×´Ì¬','','1','Text','1','1','','','','20','1','1','0','1','0',1,'0','','','SYS_Designer','2020/08/03 16:54:59','SYS_Designer','2020/09/29 15:23: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 ('ViLcReviewAuditRentPlanList3','1200','1027','1','O','COLLECT_MSG','COLLECT_MSG','String','','ÊÕ¸¶ÐÅÏ¢','','1','Text','1','1','','','','20','1','1','0','1','0',1,'0','','','SYS_Designer','2020/08/03 16:54:59','SYS_Designer','2020/09/29 15:23: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 ('ViLcReviewAuditRentPlanList3','1230','1460','1','O','BATCH_STATUS','BATCH_STATUS','String','','ÅúÁ¿´¦Àí״̬','','1','Text','','1','','','','20','1','1','0','1','0',0,'','','','SYS_Designer','2020/08/03 16:54:59','SYS_Designer','2020/09/29 15:23:58','','','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 ('ViLcReviewAuditRentPlanList3','1240','1020','1','O','CUSTOMERNAME','CUSTOMERNAME','String','','³Ð×âÈË','','1','Text','1','1','','','',null,'1','1','0','1','1',0,'','','','SYS_Designer','2020/08/03 16:54:59','SYS_Designer','2020/09/29 15:23:57','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 ('ViLcReviewAuditRentPlanList3','1300','1035','1','O','penalty','penalty','Number','','·£Ï¢','','1','Text','2','1','','','','20','1','1','0','1','0',0,'','','','SYS_Designer','2020/08/03 16:55:00','SYS_Designer','2020/09/29 15:23:57','','','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 ('ViLcReviewAuditRentPlanList3','1360','1070','1','','''''','back_rent','Number','','±¾ÆÚÊ£ÓàÓ¦»¹½ð¶î','','1','Text','2','1','','','',null,'1','1','0','1','0',0,'','','','SYS_Designer','2020/08/03 16:55:00','SYS_Designer','2020/09/29 15:23:57','','','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 ('ViLcReviewAuditRentPlanList3','1430','1430','1','O','SUBJECTID','SUBJECTID','String','','Ö÷Ìåid','','1','Text','1','1','','','','20','0','1','0','1','0',0,'','','','SYS_Designer','2020/08/03 16:55:00','SYS_Designer','2020/09/29 15:23:58','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 ('ViLcReviewAuditRentPlanList3','1500','1075','1','','''''','collect_money','Number','','¿Û¿î½ð¶î','','1','Text','2','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/08/05 15:14:20','SYS_Designer','2020/09/29 15:23:58','','','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 ('ViLcReviewAuditRentPlanList3','1570','1065','1','O','penalty_over','penalty_over','Number','','δ¸¶·£Ï¢','','1','Text','2','1','','','',null,'1','1','0','1','0',0,'','','','SYS_Designer','2020/09/27 09:48:31','SYS_Designer','2020/09/29 15:23:57','','','1','','','','');
|
||
|
||
-- customer_account ÐÂÔöcollect_type×Ö¶Î
|
||
alter table customer_account add collect_type varchar(10),add bank_type varchar(10),add bank_code varchar(10);
|
||
alter table customer_account_temp add collect_type varchar(10),add bank_type varchar(10),add bank_code varchar(10);
|
||
|
||
-- collect_limitÊý¾Ý×Öµä
|
||
delete from CODE_CATALOG where codeno='collect_limit';
|
||
delete from Code_Library where codeno='collect_limit';
|
||
Insert Into CODE_CATALOG (codeno,sortno,codetypeone,codetypetwo,codename,codedescribe,codeattribute,inputuser,inputorg,inputtime,updateuser,updatetime,remark) Values ('collect_limit','00216390','1.»ù´¡ÅäÖÃ','ͨÁª¿¨¿Û','ͨÁª´úÊÕÏÞ¶î','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0010','¹¤ÉÌÒøÐÐ','','0010','1','','','','50000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0020','Å©ÒµÒøÐÐ','','0020','1','','','','10000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0030','ÖйúÒøÐÐ','','0030','1','','','','10000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0040','½¨ÉèÒøÐÐ','','0040','1','','','','50000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0050','½»Í¨ÒøÐÐ','','0050','1','','','','10000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0060','ÕÐÉÌÒøÐÐ','','0060','1','','','','30000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0070','ÓÊÕþ´¢Ðî','','0070','1','','','','10000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0080','ÖÐÐÅÒøÐÐ','','0080','1','','','','20000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0090','¹â´óÒøÐÐ','','0090','1','','','','20000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0100','»ªÏÄÒøÐÐ','','0100','1','','','','5000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0110','ÃñÉúÒøÐÐ','','0110','1','','','','50000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0120','ÐËÒµÒøÐÐ','','0120','1','','','','20000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0130','¹ã·¢ÒøÐÐ','','0130','1','','','','10000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0140','ƽ°²ÒøÐÐ','','0140','1','','','','50000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0150','ÆÖ·¢ÒøÐÐ','','0150','1','','','','20000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0160','±±¾©ÒøÐÐ','','0160','1','','','','20000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('collect_limit','0170','ÉϺ£ÒøÐÐ','','0170','1','','','','10000','','','','','','','','SYS_Designer',null,'2020/10/19 14:39:25','SYS_Designer','2020/10/19 14:39:25','','');
|
||
|
||
-- ´´½¨±í¸ñ bank_collec_typet_4_contract
|
||
create table `BANK_COLLEC_TYPET_4_CONTRACT` (
|
||
`id` varchar (32),
|
||
`contract_id` varchar (32),
|
||
`contract_no` varchar (32),
|
||
`start_date` varchar (20),
|
||
`end_date` varchar (20),
|
||
`collect_type` varchar (10),
|
||
`inputuserid` varchar (20),
|
||
`inputtime` varchar (20),
|
||
`updateuserid` varchar (20),
|
||
`updatetime` varchar (20)
|
||
);
|
||
|
||
-- ´´½¨±í¸ñ BANK_COLLECT_TYPE_CONFIG
|
||
create table `BANK_COLLECT_TYPE_CONFIG` (
|
||
`id` varchar (32),
|
||
`bank_code` varchar (10),
|
||
`bank_name` varchar (20),
|
||
`collect_type` varchar (10),
|
||
`inputuserid` varchar (20),
|
||
`inputtime` varchar (20),
|
||
`updateuserid` varchar (20),
|
||
`updatetime` varchar (20)
|
||
);
|
||
|
||
-- BankCollectTypeConfigListÄ£°å
|
||
delete from AWE_DO_CATALOG where dono='BankCollectTypeConfigList';
|
||
delete from awe_do_library where dono='BankCollectTypeConfigList';
|
||
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 ('BankCollectTypeConfigList','ÒøÐпۿʽÅäÖÃ',null,'30020',null,'1','1','default','jbo.loan.BANK_COLLECT_TYPE_CONFIG','O','','','bank_code','',null,'SYS_Designer','2020/10/22 11:40:33','SYS_Designer','2020/10/22 15:30:51','','0','');
|
||
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 ('BankCollectTypeConfigList','1000','1000','1','O','id','id','String','','id','','1','Text','1','1','','','','32','0','0','0','0','0',1,'0','','','SYS_Designer','2020/10/22 11:40:33','SYS_Designer','2020/10/22 15:30:52','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 ('BankCollectTypeConfigList','1010','1010','1','O','bank_code','bank_code','String','','ÒøÐдúÂë','','1','Text','1','1','','','','100','1','0','0','1','0',1,'0','','','SYS_Designer','2020/10/22 11:40:33','SYS_Designer','2020/10/22 15:30:52','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 ('BankCollectTypeConfigList','1020','1020','1','O','bank_name','bank_name','String','','ÒøÐÐÃû³Æ','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/10/22 11:40:33','SYS_Designer','2020/10/22 15:30: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 ('BankCollectTypeConfigList','1030','1030','1','O','collect_type','collect_type','String','','¿Û¿î·½Ê½','','1','Text','1','1','CodeTable','YLcollect,ÒøÁª¿Û¿î,TLcollect,ͨÁª¿Û¿î','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/10/22 11:40:33','SYS_Designer','2020/10/22 15:30: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 ('BankCollectTypeConfigList','1120','1130','1','O','inputtime','inputtime','String','','µÇ¼Çʱ¼ä','','1','Date','3','2','','','','20','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/22 11:40:33','SYS_Designer','2020/10/22 15:30:52','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 ('BankCollectTypeConfigList','1130','1150','1','O','updatetime','updatetime','String','','¸üÐÂʱ¼ä','','1','Date','3','2','','','','20','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/22 11:40:33','SYS_Designer','2020/10/22 15:30:52','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 ('BankCollectTypeConfigList','1140','1120','1','O','inputuserid','inputuserid','String','','µÇ¼ÇÈË','','1','Text','1','1','','','','32','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/22 11:40:33','SYS_Designer','2020/10/22 15:30:52','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 ('BankCollectTypeConfigList','1150','1140','1','O','updateuserid','updateuserid','String','','¸üÐÂÈË','','1','Text','1','1','','','','32','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/22 11:40:33','SYS_Designer','2020/10/22 15:30:52','0','','1','','','','');
|
||
|
||
-- BankTypeConfig4ContractListÄ£°å
|
||
delete from AWE_DO_CATALOG where dono='BankTypeConfig4ContractList';
|
||
delete from awe_do_library where dono='BankTypeConfig4ContractList';
|
||
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 ('BankTypeConfig4ContractList','ÒøÐпۿʽÅäÖÃ(µ¥¸öºÏͬ)',null,'30020',null,'1','1','default','jbo.loan.BANK_COLLEC_TYPET_4_CONTRACT','O','','','contract_no','',null,'SYS_Designer','2020/10/23 09:39:56','SYS_Designer','2020/10/23 09:39:56','','0','');
|
||
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 ('BankTypeConfig4ContractList','1000','1000','1','O','id','id','String','','id','','1','Text','1','1','','','','32','0','0','0','0','0',1,'0','','','SYS_Designer','2020/10/23 09:39:56','SYS_Designer','2020/10/23 09:39:56','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 ('BankTypeConfig4ContractList','1010','1010','1','O','contract_id','contract_id','String','','ºÏͬid','','1','Text','1','1','','','','100','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/23 09:39:56','SYS_Designer','2020/10/23 09:58:08','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 ('BankTypeConfig4ContractList','1020','1020','1','O','contract_no','contract_no','String','','ºÏͬºÅ','','1','Text','1','1','','','',null,'1','0','1','1','0',0,'','','','SYS_Designer','2020/10/23 09:39:56','SYS_Designer','2020/10/23 09:58:08','','','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 ('BankTypeConfig4ContractList','1030','1030','1','O','collect_type','collect_type','String','','¿Û¿î·½Ê½','','1','Text','1','1','CodeTable','YLcollect,ÒøÁª¿Û¿î,TLcollect,ͨÁª¿Û¿î','',null,'1','0','1','1','0',0,'','','','SYS_Designer','2020/10/23 09:39:56','SYS_Designer','2020/10/23 09:41:14','','','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 ('BankTypeConfig4ContractList','1120','1130','1','O','inputtime','inputtime','String','','µÇ¼Çʱ¼ä','','1','Date','3','2','','','','20','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/23 09:39:56','SYS_Designer','2020/10/23 09:45:28','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 ('BankTypeConfig4ContractList','1125','1025','1','O','start_date','start_date','String','','¿ªÊ¼ÈÕÆÚ','','1','Text','1','1','','','',null,'1','0','1','1','0',0,'','','','SYS_Designer','2020/10/23 09:39:56','SYS_Designer','2020/10/23 09:41:14','','','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 ('BankTypeConfig4ContractList','1126','1026','1','O','end_date','end_date','String','','½áÊøÈÕÆÚ','','1','Text','1','1','','','',null,'1','0','1','1','0',0,'','','','SYS_Designer','2020/10/23 09:39:56','SYS_Designer','2020/10/23 09:41:14','','','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 ('BankTypeConfig4ContractList','1130','1150','1','O','updatetime','updatetime','String','','¸üÐÂʱ¼ä','','1','Date','3','2','','','','20','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/23 09:39:56','SYS_Designer','2020/10/23 10:13:25','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 ('BankTypeConfig4ContractList','1140','1120','1','O','inputuserid','inputuserid','String','','µÇ¼ÇÈË','','1','Text','1','1','','','','32','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/23 09:39:56','SYS_Designer','2020/10/23 09:45:28','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 ('BankTypeConfig4ContractList','1150','1140','1','O','updateuserid','updateuserid','String','','¸üÐÂÈË','','1','Text','1','1','','','','32','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/23 09:39:56','SYS_Designer','2020/10/23 10:13:25','0','','1','','','','');
|
||
|
||
-- BankTypeConfig4ContractInfoÄ£°å
|
||
delete from AWE_DO_CATALOG where dono='BankTypeConfig4ContractInfo';
|
||
delete from awe_do_library where dono='BankTypeConfig4ContractInfo';
|
||
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 ('BankTypeConfig4ContractInfo','ÒøÐпۿʽÅäÖÃ(µ¥¸öºÏͬ)',null,'30020',null,'1','1','default','jbo.loan.BANK_COLLEC_TYPET_4_CONTRACT','O','id=:id','','contract_no','com.amarsoft.awe.dw.handler.impl.CommonHandler',null,'SYS_Designer','2020/10/23 09:44:04','SYS_Designer','2020/10/23 10:08:00','','0','');
|
||
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 ('BankTypeConfig4ContractInfo','1000','1000','1','O','id','id','String','','id','','1','Text','1','1','','','','32','0','0','0','0','0',1,'0','','','SYS_Designer','2020/10/23 09:44:04','SYS_Designer','2020/10/23 10:08:01','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 ('BankTypeConfig4ContractInfo','1010','1010','1','O','contract_id','contract_id','String','','ºÏͬid','','1','Text','1','1','','','','100','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/23 09:44:04','SYS_Designer','2020/10/23 10:08:01','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 ('BankTypeConfig4ContractInfo','1020','1020','1','O','contract_no','contract_no','String','','ºÏͬºÅ','','1','Text','1','1','','','',null,'1','0','1','1','0',0,'','','','SYS_Designer','2020/10/23 09:44:04','SYS_Designer','2020/10/23 10:08:01','','','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 ('BankTypeConfig4ContractInfo','1030','1030','1','O','collect_type','collect_type','String','','¿Û¿î·½Ê½','','1','Select','1','1','CodeTable','YLcollect,ÒøÁª¿Û¿î,TLcollect,ͨÁª¿Û¿î','',null,'1','0','1','1','0',0,'','','','SYS_Designer','2020/10/23 09:44:04','SYS_Designer','2020/10/23 10:08:01','','','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 ('BankTypeConfig4ContractInfo','1120','1130','1','O','inputtime','inputtime','String','','µÇ¼Çʱ¼ä','','1','Date','3','2','','','','20','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/23 09:44:04','SYS_Designer','2020/10/23 10:08:01','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 ('BankTypeConfig4ContractInfo','1125','1025','1','O','start_date','start_date','String','','¿ªÊ¼ÈÕÆÚ','','1','Date','3','1','','','',null,'1','0','1','1','0',0,'','','','SYS_Designer','2020/10/23 09:44:04','SYS_Designer','2020/10/23 10:08:01','','','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 ('BankTypeConfig4ContractInfo','1126','1026','1','O','end_date','end_date','String','','½áÊøÈÕÆÚ','','1','Date','3','1','','','',null,'1','0','1','1','0',0,'','','','SYS_Designer','2020/10/23 09:44:04','SYS_Designer','2020/10/23 10:08:01','','','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 ('BankTypeConfig4ContractInfo','1130','1150','1','O','updatetime','updatetime','String','','¸üÐÂʱ¼ä','','1','Date','3','2','','','','20','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/23 09:44:04','SYS_Designer','2020/10/23 10:08:01','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 ('BankTypeConfig4ContractInfo','1140','1120','1','O','inputuserid','inputuserid','String','','µÇ¼ÇÈË','','1','Text','1','1','','','','32','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/23 09:44:04','SYS_Designer','2020/10/23 10:08:01','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 ('BankTypeConfig4ContractInfo','1150','1140','1','O','updateuserid','updateuserid','String','','¸üÐÂÈË','','1','Text','1','1','','','','32','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/23 09:44:04','SYS_Designer','2020/10/23 10:08:01','0','','1','','','','');
|
||
|
||
-- BankCollectTypeConfigInfoÄ£°å
|
||
delete from AWE_DO_CATALOG where dono='BankCollectTypeConfigInfo';
|
||
delete from awe_do_library where dono='BankCollectTypeConfigInfo';
|
||
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 ('BankCollectTypeConfigInfo','ÒøÐпۿʽÅäÖÃ',null,'30020',null,'1','1','default','jbo.loan.BANK_COLLECT_TYPE_CONFIG','O','id=:id','','','com.amarsoft.awe.dw.handler.impl.CommonHandler',null,'SYS_Designer','2020/10/22 11:42:42','SYS_Designer','2020/10/23 10:11:02','','0','');
|
||
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 ('BankCollectTypeConfigInfo','1000','1000','1','O','id','id','String','','id','','1','Text','1','1','','','','32','0','0','0','0','0',1,'0','','','SYS_Designer','2020/10/22 11:42:42','SYS_Designer','2020/10/23 10:11:02','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 ('BankCollectTypeConfigInfo','1010','1010','1','O','bank_code','bank_code','String','','ÒøÐдúÂë','','1','Text','1','1','','','','100','1','1','1','1','0',1,'0','','','SYS_Designer','2020/10/22 11:42:42','SYS_Designer','2020/10/23 16:48:43','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 ('BankCollectTypeConfigInfo','1020','1020','1','O','bank_name','bank_name','String','','ÒøÐÐÃû³Æ','','1','Text','1','1','','','',null,'1','1','1','1','0',0,'','','','SYS_Designer','2020/10/22 11:42:42','SYS_Designer','2020/10/23 16:48:43','','','1','','','selectBankType()','');
|
||
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 ('BankCollectTypeConfigInfo','1030','1030','1','O','collect_type','collect_type','String','','¿Û¿î·½Ê½','','1','Select','1','1','CodeTable','YLcollect,ÒøÁª¿Û¿î,TLcollect,ͨÁª¿Û¿î','',null,'1','0','1','1','0',0,'','','','SYS_Designer','2020/10/22 11:42:42','SYS_Designer','2020/10/23 16:48:43','','','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 ('BankCollectTypeConfigInfo','1120','1130','1','O','inputtime','inputtime','String','','µÇ¼Çʱ¼ä','','1','Date','3','2','','','','20','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/22 11:42:42','SYS_Designer','2020/10/23 10:11:03','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 ('BankCollectTypeConfigInfo','1130','1150','1','O','updatetime','updatetime','String','','¸üÐÂʱ¼ä','','1','Date','3','2','','','','20','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/22 11:42:42','SYS_Designer','2020/10/23 10:11:03','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 ('BankCollectTypeConfigInfo','1140','1120','1','O','inputuserid','inputuserid','String','','µÇ¼ÇÈË','','1','Text','1','1','','','','32','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/22 11:42:42','SYS_Designer','2020/10/23 10:11:03','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 ('BankCollectTypeConfigInfo','1150','1140','1','O','updateuserid','updateuserid','String','','¸üÐÂÈË','','1','Text','1','1','','','','32','0','0','0','1','0',1,'0','','','SYS_Designer','2020/10/22 11:42:42','SYS_Designer','2020/10/23 10:11:03','0','','1','','','','');
|
||
|
||
-- selectBankTypeÑ¡Ôñ¶Ô»°¿ò
|
||
delete from SELECT_CATALOG where selname='selectBankType';
|
||
Insert Into SELECT_CATALOG (selname,seltype,seldescribe,seltablename,selprimarykey,selbrowsemode,selargs,selhidefield,selcode,selfieldname,selfielddisp,selreturnvalue,selfilterfield,isinuse,mutilorsingle,attribute1,attribute2,attribute3,attribute4,attribute5,inputuser,inputorg,inputtime,updateuser,updatetime,remark) Values ('selectBankType','Sql','²éѯÒøÐÐÃû³Æ','bank_code','bank_code','Grid','','','SELECT bank_code,bank_name from bank_code','ÒøÐбàºÅ,ÒøÐÐÃû³Æ','','bank_code@bank_name','bank_name','1','Single','','','','','','SYS_Designer','','2020/10/21 18:46:44','SYS_Designer','2020/10/21 18:48:37','');
|
||
|
||
-- н¨bank_code±í
|
||
CREATE TABLE `bank_code` (
|
||
`id` varchar(32) NOT NULL COMMENT 'Ö÷¼ü',
|
||
`bank_code` varchar(10) DEFAULT NULL,
|
||
`bank_name` varchar(20) DEFAULT NULL,
|
||
`is_use` varchar(1) 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`),
|
||
UNIQUE KEY `bank_code` (`bank_code`)
|
||
) ;
|
||
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('017cc75a15753ac38af9cc0a6024725f', '455', 'ÈÕÕÕÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('038cc2901f386027f86856e84cb9c4e9', '701', 'À¥ÂØÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('03ca046299317ad88308d94d5ba96e83', '404', 'ÑĮ̀ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('043e711295a651330143cdcd8d8a9231', '100', 'ÓÊÕþÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('06fd44f806572d52034595178f7aeed8', '409', 'Æë³ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('07a8e22f93964c0225f757cbf2ee64e1', '497', 'À³ÉÌÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('0b2209e57c7d2f48a5ae375b1682a167', '458', 'ÇຣÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('0e02a2e8ac78b5ba4c58e477fe596c63', '307', 'ƽ°²ÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('14315d5ad380e3309ed3aeed6a3141a9', '424', 'ÄϾ©ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('1533faaa2074fd9ab702382699acd382', '302', 'ÖÐÐÅÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('19d19897cfe6aab5a51a9cfd2d52ed7e', '462', 'Ϋ·»ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('1a71c356016818c7faf90725a4b9f424', '419', 'ÁÉÑôÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('1b358cb0a82e106854b3017f381d7589', '304', '»ªÏÄÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('1b4134b6b1960af6b6078238e45916ec', '430', '¸§Ë³ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('1e4830e59fae00e32fac0214b7e5dc73', '454', '¾Å½ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('1edadf847592f3e8b876277850ed5217', '439', '½õÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('1ee670adac994614b118946bef6fccc5', '310', 'ÆÖ·¢ÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('1f1e6dd42af6327b8c796cf5316a578c', '425', '¶«Ý¸ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('27166b1ee948dc87a29e7a80cc19f8ab', '490', 'ÕżҿÚÊÐÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('29b44b3d0d56af364ef279a95b07b526', '495', 'ÁøÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('2f96e5b9f51e3e6c336fadad8a03d298', '429', '³É¶¼ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('307a2388254e61709cc4046ecf05a736', '438', 'ÆëÉÌÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('3225347921ec48ab35d5be1292ed7849', '446', 'µ¤¶«ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('370aaf650e7df489d81c655c34b01b2a', '447', 'À¼ÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('38f48d6fdd2ee180edbc3a8db599ca6c', '499', 'н®ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('3c2e2d2efe4dda1dc795b30c236a2f07', '431', 'ÁÙÉÌÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('3d41ba15d300704aa565e8305f9d119d', '443', '¹óÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('3d87c0502f7277e8595994d908a0b14a', '422', 'ºÓ±±ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('4268888173f43a7107f41240cf54e6ba', '465', 'Óª¿ÚÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('42c42de9c11da47be87d6ff74cd024ce', '463', '¸ÓÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('45c2ea61f0764097c52364c2359d8fb0', '402', 'ÏÃÃÅÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('49e30a40f7ca5d2aa95b5cb19c6e7e1e', '461', '³¤É³ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('4c1641ff7d0ec6bbf3071d05dbaf0b5d', '303', '¹â´óÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('532ebe7cbc14303895d5830b9f171089', '473', 'Õã½Ì©Â¡ÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('57fea74ab77f50a4198a8439f971dce0', '485', 'ÃàÑôÊÐÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('624f0210e57866b0be5756f9992f0df0', '306', '¹ã·¢ÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('661a082223052c7f3a3844d900f7604f', '467', '¸·ÐÂÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('6817c0f00f7ee3dfab8770c977f6bd18', '305', 'ÃñÉúÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('6963e6822b42fa05df254fb61bc624cd', '308', 'ÕÐÉÌÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('6dd42628e98b9026bfe03ee97a3e8a83', '486', 'ãòÖÝÊÐÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('6fe9ed7ae9d344eda967d725b0024127', '496', 'ÄϳäÊÐÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('7026fa4034a84356b7d51388a296ee29', '423', 'º¼ÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('71c42853df0e3227ca6c03c49460a3e8', '104', 'ÖйúÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('7212301daffe4bba0c4e17dba6e4b0aa', '459', '̨ÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('7417483c4bf4a0036633fd2278001466', '105', '½¨ÉèÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('742b022c964b92736ca7ca36630961b6', '481', 'Íþº£ÊÐÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('74bd0bd45f8f0349762d2efad87c9ef6', '442', '¹þ¶û±õÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('75d91cf714b6eb8b2cc16fe97895bcb1', '417', 'Ê¢¾©ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('79a9ca896f476affce9504958f69d11d', '415', '¸ÊËàÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('79b2d90e8716815017a8299950ecb40f', '483', 'ÅÊÖ¦»¨ÊÐÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('7a25786c6739e7b416d5185f8f1bc05c', '433', 'ºù«µºÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('7c5a49af90be1f3c26bbba8cd5113993', '502', 'Çú¾¸ÊÐÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('7d5d96c0d7e16cdd2d86fc35c6e976ac', '456', '°°É½ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('8006fd7a7294e9beb09eb73bb8398343', '408', 'Äþ²¨ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('80cbe52c28b8737c18c532f4c925784c', '457', 'ÇػʵºÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('835a61ef4785bebd7065d01399ba67ac', '464', 'ȪÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('875bf38b31887bfe01f31752f8529dae', '413', '¹ãÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('887a951e54a0ee5049c6a283a3dd569c', '410', '¸£ÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('8c67f9d093ee7b24cf219a51991ea557', '489', '¹ã¶«ÄÏÔÁÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('904d1c2085c2b85754f5610a812be1bb', '500', 'ÁùÅÌË®ÊÐÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('908708a0691a592ac7fd3d3118120913', '466', '¸»µáÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('91ce3b88002c8de01321bbe223252a69', '498', 'µÂÑôÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('97722a1d8383b07380d22bafa9670515', '411', '½¹×÷ÊÐÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('9e14e3242a8894b9d69eef84f19d86c6', '478', '¹ãÎ÷±±²¿ÍåÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('a271306e5017a9f9ef3cc6365a419254', '451', '¼ªÁÖÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('a664203097466d65ee075a179edb1622', '436', 'ÄþÏÄÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('ac3bce1a64e7a222933112dc1456e3c3', '102', '¹¤ÉÌÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('ac9643ab9f0523f7154517b05c98b5f0', '412', 'ÎÂÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('af9a2b7c467c2d1f56b7c07f1b11c0bd', '311', 'ºã·áÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('b1ceaa9c032727a679d13301cc860d0b', '487', '´óͬÊÐÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('b2fcdfb23b94f0e8acc0b589dd25eede', '448', '½Î÷ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('b6086e0936809c06af0bed571ea310a7', '444', 'Î÷°²ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('b69966abba853c6281cd7432cf501114', '475', 'ºþÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('bc45e957bbb04fb5efaa7f8f45028d18', '434', 'Ìì½òÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('bcef434dac6e4cf63dedf443212e9d1f', '470', '¼ÎÐËÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('bd4e83c28ff83f90e94cc10a62a550d0', '316', 'ÕãÉÌÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('c23e5f1cbf803b6be9d119e9346fcfbc', '432', 'ºþ±±ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('c282f4771162f569610c02391dc1f156', '493', 'ËÕÖݳ¤½ÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('c4235b8f5b22d98e6b330be7e11face3', '435', 'Ö£ÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('cad6dfd82fa5fe80c1eb299234646930', '420', '´óÁ¬ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('ce30a6aee9e66287583562a4a452ea2e', '317', '²³º£ÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('cefe080a073c90e65f81bce07e82a9fd', '103', 'Å©ÒµÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('d0bc731f0b4cbdf9ab5d7923c4e39242', '440', '»ÕÉÌÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('d203f4c776acad5d1c73dd585233b2c1', '418', 'ÂåÑôÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('d238ab00b5fcc981fbc5e9b227c29c22', '427', 'ÎÚ³ľÆëÉÌÒµÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('d685393c4bb44f2016c11275a901f76e', '421', 'ËÕÖÝÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('d7d188d6a67a267f6859214deb285db7', '450', 'ÇൺÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('d7de2fd0bcfe10ac22e15f9af937fff0', '401', 'ÉϺ£ÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('d997a9100c0fae02830331b65884f41d', '309', 'ÐËÒµÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('dbbff537b84ec4328738e0376c6de8bf', '491', '¹ðÁÖÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('def0b500ab6d03ec9eef3117d3d995fb', '414', 'ºº¿ÚÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('e09f86157965cfca9d67a06e018d5113', '441', 'ÖØÇìÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('e17408f10973e5ac0cafa61dccc8357b', '437', 'Ö麣»ªÈóÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('ea5796c6cec222d0084deaf6d8d83454', '488', 'ÈýÃÅÏ¿ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('eac8a602f7803879c2f5cdc433333c47', '301', '½»Í¨ÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('ebaed63492861c0ed8087244be5d53ae', '405', '¸£½¨º£Ï¿ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('efe31e81ce523d7a737fbe6a1b93a781', '321', 'ÖØÇìÈýÏ¿ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('f198be54a17fb6e8a92b1f9aafe8e8df', '472', 'ÀÈ·»ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('f603b135e02089180af80a972b06a016', '474', 'ÄÚÃɹÅÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('fa8176cba828074bfaf9334b6b374215', '449', '½úÉÌÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('fb2ab9417bed83f26b9b0928d9795ea9', '313', '»ªÈÚÏæ½ÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('fb33d0459198404e9004f3c816b4c7b0', '426', '½ð»ªÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('fc399519595335ca75947eb5ff8621a0', '428', 'ÉÜÐËÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('fdace91bc53b81d94d3cabbb294e3b96', '403', '±±¾©ÒøÐÐ', 'Y', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
INSERT INTO `apzl`.`bank_code` (`id`, `bank_code`, `bank_name`, `is_use`, `inputuserid`, `inputorgid`, `inputtime`, `updateuserid`, `updateorgid`, `updatetime`) VALUES ('fe2ccf6e17b46cd3c415456604829e53', '479', '°üÉÌÒøÐÐ', 'N', NULL, NULL, NULL, NULL, NULL, NULL);
|
||
|
||
-- ¶¨Ê±ÈÎÎñ
|
||
delete from Code_Library where codeno='MissionName' and itemno='com.tenwa.lease.app.quartzmession.BankCollectTypeAutoChange';
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('MissionName','com.tenwa.lease.app.quartzmession.BankCollectTypeAutoChange','¸ö±ðºÏͬ¿Û¿î·½Ê½×Ô¶¯±ä¸ü','','25427413','1','¸ö±ðºÏͬ¿Û¿î·½Ê½×Ô¶¯±ä¸ü','','','','','','','','','','','SYS_Designer',null,'2020/10/23 16:06:31','SYS_Designer','2020/10/23 16:06:31','','');
|
||
delete FROM FLOW_MODEL WHERE flowno='ActualPaymentCarFLow' AND phaseno='1000';
|
||
insert into `FLOW_MODEL` (`flowno`, `phaseno`, `phasetype`, `phasename`, `phasedescribe`, `phaseattribute`, `prescript`, `initscript`, `choicedescribe`, `choicescript`, `actiondescribe`, `actionscript`, `postscript`, `attribute1`, `attribute2`, `attribute3`, `attribute4`, `attribute5`, `attribute6`, `attribute7`, `attribute8`, `attribute9`, `attribute10`, `aaenabled`, `aapointinitscript`, `aapointcomp`, `aapointcompurl`, `standardtime1`, `standardtime2`, `costlob`, `strips`, `checklist`, `decisionscript`, `riskscanrule`, `buttonset2`, `inputuser`, `inputtime`, `updateuser`, `updatetime`, `distributerule`, `id`, `type`, `name`, `xcoordinate`, `ycoordinate`, `width`, `height`, `version`, `swimlane`, `nodetype`, `flowphasecontext`, `OPINIONSREQUIRED`, `isreadonly`, `flowpageconfig`, `flowprocessclass`, `flowpagecheck`, `backstepnexttype`, `backsteps`, `backscript`, `deletescript`, `phasescript`, `loadproductcheck`, `nextsteps`, `flowtiptype`, `remindnoticttype`, `flowoverdate`, `overnoticetype`, `overnoticeUser`) values('ActualPaymentCarFLow','1000','1040','½áÊø',NULL,NULL,'!»ù´¡²Ù×÷.ʵ¼Ê¸¶¿îÁÙʱµ½Õýʽ±í-Æû³µ(#ObjectNo)+!»ù´¡²Ù×÷.Ͷ·ÅºóÆð×â(#ObjectNo)+!»ù´¡²Ù×÷.ÒµÎñ״̬±í¼ÈëÓëÒµÎñÏêÇé±í¸üÐÂ(#ObjectNo,31)+!ÉóÅúÁ÷³Ì.Æð×âºó²åÈëÒøÐпۿʽ(#ObjectNo)+!»ù´¡²Ù×÷.±±Æû²ÆÎñ¸¶¿îÐÅÏ¢¸üÐÂ(#ObjectNo)+!ÉóÅúÁ÷³Ì.ƾ֤Êä³ö--Æð×â·Å¿îÀàƾ֤(#ObjectNo)','{\"system\"}',NULL,'commroute',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'378','387','50','50','1',NULL,'END',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
|
||
delete from class_method where methodname='Æð×âºó²åÈëÒøÐпۿʽ';
|
||
INSERT INTO `class_method` (`classname`, `methodname`, `methodtype`, `methoddescribe`, `returntype`, `methodargs`, `methodcode`, `inputuser`, `inputorg`, `inputtime`, `updateuser`, `updatetime`, `remark`) VALUES('ÉóÅúÁ÷³Ì','Æð×âºó²åÈëÒøÐпۿʽ','Bizlet','Æð×âºó²åÈëÒøÐпۿʽ','String','String ObjectNo','com.tenwa.flow.fund.actualpayment.CustomerAccountCollectTypeModify','','','','','','');
|
||
|
||
-- DebitCardInfoÄ£°å
|
||
DELETE FROM awe_do_library WHERE dono='DebitCardInfo';
|
||
DELETE FROM AWE_DO_CATALOG WHERE dono='DebitCardInfo';
|
||
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 ('DebitCardInfo','¿Û¿î¿¨ÐÅÏ¢',NULL,'30',NULL,'1','2','default','jbo.app.tenwa.customer.CUSTOMER_ACCOUNT_TEMP','O','O.flowunid=:flowunid and acc_type=''Debit''',NULL,NULL,'com.amarsoft.awe.dw.handler.impl.CommonHandler',NULL,'SYS_Designer','2017/07/11 12:59:56','SYS_Designer','2018/07/30 21:00:10',NULL,'1',NULL);
|
||
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 ('DebitCardInfo','1000','1000','1','O','id','id','String',NULL,'id',NULL,'1','Text','1','1',NULL,NULL,NULL,'32','0','0','0','1','1',1,'0',NULL,NULL,'SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1010','1020','1','O','acc_number','acc_number','String',NULL,'ÒøÐÐÕ˺Å',NULL,'1','Text','1','1',NULL,NULL,'style={width:53%;}','32','1','0','1','1','1',1,'0','0010',NULL,'SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32','0',NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1020','1030','1','O','bank_name','bank_name','String','','¿ª»§ÒøÐÐ(È«Ãû)','','1','Text','1','1','','','style={width:80%;}','200','1','0','1','1','1',2,'0','0010','','SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32','0','','1','','','',NULL);
|
||
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 ('DebitCardInfo','1030','1010','1','O','account','account','String',NULL,'ÕË»§Ãû³Æ',NULL,'1','Text','1','1',NULL,NULL,NULL,'100','1','1','1','1','1',1,'0','0010',NULL,'SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32','0',NULL,'1',NULL,NULL,'autoSetCustId()',NULL);
|
||
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 ('DebitCardInfo','1040','1040','1','O','is_main','is_main','String',NULL,'ÊÇ·ñÖ÷Õ˺Å',NULL,'1','Text','1','1',NULL,NULL,NULL,'32','0','0','0','1','1',1,'0',NULL,NULL,'SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1050','1050','1','O','acc_info','acc_info','String','Debit','ÕÊ»§Ê¹ÓÃÇé¿ö',NULL,'1','Text','1','1',NULL,NULL,NULL,'600','0','0','0','1','1',1,'0',NULL,NULL,'SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1060','1060','1','O','customerid','customerid','String',NULL,'¿Í»§id',NULL,'1','Text','1','1',NULL,NULL,NULL,'32','0','0','0','1','1',1,'0',NULL,NULL,'SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1070','1070','1','O','inputuserid','inputuserid','String',NULL,'¼ÈëÈË',NULL,'1','Text','1','1',NULL,NULL,NULL,'32','0','0','0','1','1',1,'0',NULL,NULL,'SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1080','1080','1','O','inputorgid','inputorgid','String',NULL,'¼Èë»ú¹¹',NULL,'1','Text','1','1',NULL,NULL,NULL,'32','0','0','0','1','1',1,'0',NULL,NULL,'SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1090','1090','1','O','updateuserid','updateuserid','String',NULL,'¸üÐÂÈË',NULL,'1','Text','1','1',NULL,NULL,NULL,'32','0','0','0','1','1',1,'0',NULL,NULL,'SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1100','1100','1','O','updateorgid','updateorgid','String',NULL,'¸üлú¹¹',NULL,'1','Text','1','1',NULL,NULL,NULL,'32','0','0','0','1','1',1,'0',NULL,NULL,'SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1110','1110','1','O','inputtime','inputtime','String',NULL,'µÇ¼Çʱ¼ä',NULL,'1','Date','3','2',NULL,NULL,NULL,'32','0','0','0','1','1',1,'0',NULL,NULL,'SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1120','1120','1','O','updatetime','updatetime','String',NULL,'¸üÐÂʱ¼ä',NULL,'1','Date','3','2',NULL,NULL,NULL,'32','0','0','0','1','1',1,'0',NULL,NULL,'SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1130','1130','1','O','flowunid','flowunid','String',NULL,'Á÷³Ì±àºÅ',NULL,'1','Text','1','1',NULL,NULL,NULL,'32','0','0','0','1','1',1,'0',NULL,NULL,'SYS_DESIGNER','2017/07/11 12:59:56','8006U00000001','2020/10/22 09:36:32',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1140','1140','1',NULL,'''''','PaymentCard','String',NULL,'³Ð×âÈ˸¶¿î¿¨ÐÅÏ¢',NULL,'1','Text','1','1',NULL,NULL,NULL,NULL,'0','0','0','1','0',0,NULL,'0010',NULL,'SYS_Designer','2017/07/19 11:39:30','8006U00000001','2020/10/22 09:36:33','0',NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1150','1150','1',NULL,'''''','S_PaymentCard','String',NULL,'4S¸¶¿î¿¨ÐÅÏ¢',NULL,'1','Text','1','1',NULL,NULL,NULL,NULL,'0','0','0','1','0',0,NULL,'0030',NULL,'SYS_Designer','2017/08/15 16:14:59','8006U00000001','2020/10/22 09:36:33','0',NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1160','1160','1','O','MOBILE','MOBILE','String',NULL,'Ô¤ÁôÊÖ»úºÅ',NULL,'1','Text','1','1',NULL,NULL,NULL,'32','1','0','1','1','0',0,NULL,'0010',NULL,'SYS_Designer','2017/10/23 10:50:24','8006U00000001','2020/10/22 09:36:33',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1180','1180','1','O','project_id','project_id','String',NULL,'ÏîÄ¿±àºÅ',NULL,'1','Text','1','1',NULL,NULL,NULL,'32','0','0','0','1','0',0,NULL,NULL,NULL,'SYS_Designer','2017/11/08 10:55:43','8006U00000001','2020/10/22 09:36:33',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1190','1190','1','O','contract_id','contract_id','String',NULL,'ºÏͬ±àºÅ',NULL,'1','Text','1','1',NULL,NULL,NULL,'32','0','0','0','1','0',0,NULL,NULL,NULL,'SYS_Designer','2017/11/08 10:55:43','8006U00000001','2020/10/22 09:36:33',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1200','1200','1','O','acc_type','acc_type','String',NULL,'ÒøÐп¨ÀàÐÍ£¨¸¶¿î/¿Û¿î£©',NULL,'1','Text','1','1',NULL,NULL,NULL,'32','0','0','0','1','0',0,NULL,NULL,NULL,'SYS_Designer','2018/02/28 15:23:43','8006U00000021','2018/08/07 17:59:40',NULL,NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1210','1210','1','O','VERIFY','VERIFY','String',NULL,'ÒøÐп¨ËÄÒªËØÑéÖ¤½á¹û',NULL,'1','Textarea','1','1',NULL,NULL,'style={width:400px;height:60px;}','200','0','1','0','1','0',2,NULL,'0010',NULL,'SYS_Designer','2018/03/13 22:18:03','SYS_Designer','2018/07/30 21:00:10','0',NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1220','1220','1','O','CERTID','CERTID','String',NULL,'Ö¤¼þ±àºÅ',NULL,'1','Text','1','1',NULL,NULL,NULL,'40','0','0','0','1','0',0,NULL,NULL,NULL,'SYS_Designer','2018/08/07 19:52:54','SYS_Designer','2018/08/07 19:52:54','0',NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1230','1230','1','O','CUSTTYPE','CUSTTYPE','String',NULL,'¿Í»§ÀàÐÍ',NULL,'1','Text','1','1',NULL,NULL,NULL,'40','0','0','0','1','0',0,NULL,NULL,NULL,'SYS_Designer','2018/08/07 19:52:54','SYS_Designer','2018/08/07 19:52:54','0',NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1240','1240','1','O','sign_status','sign_status','String',NULL,'Ç©Ô¼ÐÅÏ¢',NULL,'1','Text','1','1',NULL,NULL,NULL,'32','0','0','0','1','0',0,NULL,NULL,NULL,'SYS_Designer','2019/01/11 16:49:23','SYS_Designer','2019/01/11 16:49:23','0',NULL,'1',NULL,NULL,NULL,NULL);
|
||
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 ('DebitCardInfo','1250','1025','1','O','bank_type','bank_type','String','','ÒøÐÐÃû³Æ','','1','Text','1','1','','','',NULL,'1','1','1','1','0',0,'','0010','','SYS_Designer','2020/10/21 18:12:10','8006U00000001','2020/10/22 09:36:32','','','1','','','selectBankType()','');
|
||
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 ('DebitCardInfo','1260','1260','1','O','bank_code','bank_code','String','','ÒøÐдúÂë','','1','Text','1','1','','','',NULL,'0','0','0','1','0',0,'','','','SYS_Designer','2020/10/21 18:12:10','SYS_Designer','2020/10/21 18:12:10','','','1','','','','');
|
||
|
||
|
||
|
||
-- ͨÁª¿¨¿Û
|
||
CREATE TABLE `lc_card_payment` (
|
||
`ID` varchar(100) NOT NULL COMMENT 'id',
|
||
`PROJECT_ID` varchar(100) DEFAULT NULL,
|
||
`STATUS` varchar(100) DEFAULT NULL COMMENT '¿Û¿î״̬',
|
||
`SUBMITTIME` varchar(100) DEFAULT NULL COMMENT '·¢Æð¿Û¿îʱ¼ä',
|
||
`FINTIME` varchar(100) DEFAULT NULL COMMENT '¿Û¿îʱ¼ä',
|
||
`AGRMNO` varchar(100) DEFAULT NULL COMMENT 'ÐÒéºÅ',
|
||
`REQ_SN` varchar(100) DEFAULT NULL COMMENT '½»Ò×Á÷Ë®',
|
||
`ACCOUNT_NAME` varchar(100) DEFAULT NULL COMMENT 'ÕË»§Ãû',
|
||
`START_AMOUNT` varchar(100) DEFAULT NULL COMMENT '·¢ÆðµÄ½»Ò×½ð¶î',
|
||
`FINISH_AMOUNT` varchar(100) DEFAULT NULL COMMENT '×îÖյĽ»Ò×½ð¶î',
|
||
`REMARK` varchar(2000) DEFAULT NULL COMMENT '±¸×¢',
|
||
`QUERYTIME` varchar(100) DEFAULT NULL COMMENT '²éѯ¿Û¿îʱ¼ä',
|
||
`ACCOUNTCHECK_ID` varchar(100) DEFAULT NULL COMMENT '¶ÔÕ˱íIDÍâ¼ü',
|
||
`NUM` varchar(100) DEFAULT NULL COMMENT '²éѯ´ÎÊý',
|
||
`SN` varchar(100) DEFAULT NULL COMMENT '½»Ò×ÐòºÅ',
|
||
`TRXDIR` varchar(100) DEFAULT NULL COMMENT '½»Ò×ÀàÐÍ',
|
||
`RET_CODE` varchar(100) DEFAULT NULL COMMENT '½»Ò×״̬',
|
||
`IS_ACCOUNTCHECK` varchar(100) DEFAULT NULL COMMENT 'ÊÇ·ñ¶ÔÕË',
|
||
`REASON` varchar(100) DEFAULT NULL COMMENT '¶ÔÕËʧ°ÜÔÒò',
|
||
`FULLPATH` varchar(100) DEFAULT NULL COMMENT 'Îļþ·¾¶',
|
||
`UUID` varchar(100) DEFAULT NULL COMMENT '¿Û¿îÅú´ÎºÅ'
|
||
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
|
||
|
||
|
||
|
||
-- ==========================Ìì½òË°¿Ø²¿·Ö===========================
|
||
|
||
-- ½¨±í
|
||
CREATE TABLE `li_invoice_tj_info` (
|
||
`id` VARCHAR (32),
|
||
`contract_no` VARCHAR (32),
|
||
`plan_list` VARCHAR (20),
|
||
`fpzl` VARCHAR (2),
|
||
`fpzf` VARCHAR (2),
|
||
`invoice_money` DECIMAL (22,2),
|
||
`tax_type` VARCHAR (20),
|
||
`tax_ratio` VARCHAR (20),
|
||
`tax_money` DECIMAL (22,2),
|
||
`sw_spbm` VARCHAR (20),
|
||
`fpdm` VARCHAR (20),
|
||
`fphm` VARCHAR (20),
|
||
`hztzdh` VARCHAR (20),
|
||
`mxxh` VARCHAR (20),
|
||
`status` VARCHAR (10),
|
||
payee varchar(20),
|
||
`tax_creator` VARCHAR (20),
|
||
`tax_checker` VARCHAR (20),
|
||
`inputtime` VARCHAR (20),
|
||
`updatetime` VARCHAR (20),
|
||
rele_id varchar(32)
|
||
);
|
||
|
||
-- ½¨±í
|
||
create table `tax_operator_info` (
|
||
`id` varchar (32),
|
||
`tax_creator` varchar (20),
|
||
`tax_checker` varchar (20),
|
||
`Payee` varchar (20),
|
||
`is_use` varchar (3)
|
||
);
|
||
|
||
-- ½¨±í
|
||
create table `tax_code_info` (
|
||
`id` varchar (32),
|
||
`code` varchar (32),
|
||
`full_code` varchar (32),
|
||
`tax_type` varchar (20),
|
||
`remark` varchar (50)
|
||
);
|
||
-- ½¨±í
|
||
create table `li_invoice_tj_log` (
|
||
`id` varchar (32),
|
||
`contract_no` varchar (32),
|
||
`customer_name` varchar (20),
|
||
`plan_list` varchar (10),
|
||
`tax_type` varchar (10),
|
||
`fpzl` varchar (2),
|
||
`fpzf` varchar (62),
|
||
`invoice_money` Decimal (22,2),
|
||
`tax_ratio` varchar (10),
|
||
`tax_money` Decimal (22,2),
|
||
`payee` varchar (20),
|
||
`tax_creator` varchar (20),
|
||
`tax_checker` varchar (20),
|
||
`fpdm` varchar (20),
|
||
`fphm` varchar (20),
|
||
`mxxh` varchar (20),
|
||
hztzdh varchar (20),
|
||
`fl` varchar (20),
|
||
`mess` varchar (40),
|
||
`inputtime` varchar (20)
|
||
);
|
||
|
||
|
||
-- Ä£°å
|
||
|
||
-- Invoice_TJ_GpsÄ£°å
|
||
delete from AWE_DO_CATALOG where dono='Invoice_TJ_Gps';
|
||
delete from awe_do_library where dono='Invoice_TJ_Gps';
|
||
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 ('Invoice_TJ_Gps','GPS-רƱ£¨Ìì½ò£©',null,'30',null,'1','1','default','jbo.app.tenwa.calc.VI_LI_INVOICE_TJ_GPS','O','','','','',null,'SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/03 20:37:29','','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 ('Invoice_TJ_Gps','1010','1010','1','O','contract_id','contract_id','String','','ºÏͬid','','1','Text','1','1','','','','20','0','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/03 20:37:29','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 ('Invoice_TJ_Gps','1020','1020','1','O','contract_no','contract_no','String','','ºÏͬ±àºÅ','','1','Text','1','1','','','','32','1','0','0','1','1',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/03 20:37:29','','','1','','','','Like');
|
||
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 ('Invoice_TJ_Gps','1040','1040','1','O','customer_name','customer_name','String','','¿Í»§Ãû³Æ','','1','Text','1','1','','','','20','1','0','0','1','1',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/03 20:37:29','','','1','','','','Like');
|
||
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 ('Invoice_TJ_Gps','1060','1060','1','O','invoice_money','invoice_money','String','','¿ªÆ±½ð¶î','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/03 20:37:29','','','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 ('Invoice_TJ_Gps','1070','1070','1','O','tax_type','tax_type','String','','½ð¶îÀàÐÍ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/03 20:37:29','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 ('Invoice_TJ_Gps','1080','1080','1','O','cert_id','cert_id','String','','ÄÉË°ÈËʶ±ðºÅ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/03 20:37:29','','','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 ('Invoice_TJ_Gps','1090','1090','1','O','account','account','String','','ÕË»§','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/03 20:37:29','','','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 ('Invoice_TJ_Gps','1100','1100','1','O','acc_number','acc_number','String','','¿ª»§Õ˺Å','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/03 20:37:29','','','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 ('Invoice_TJ_Gps','1110','1110','1','O','bank_name','bank_name','String','','¿ª»§ÐÐ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/03 20:37:29','','','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 ('Invoice_TJ_Gps','1120','1120','1','O','telephone','telephone','String','','ÁªÏµµç»°','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/03 20:37:29','','','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 ('Invoice_TJ_Gps','1130','1130','1','O','customer_type','customer_type','String','','¿Í»§ÀàÐÍ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/03 20:37:29','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 ('Invoice_TJ_Gps','1140','1140','1','O','tax_ratio','tax_ratio','String','','Ë°ÂÊ','%','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/27 17:09:08','SYS_Designer','2020/11/03 20:37:29','','','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 ('Invoice_TJ_Gps','1150','1150','1','O','plan_list','plan_list','String','','ÆÚ´Î','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/03 20:37:29','','','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 ('Invoice_TJ_Gps','1160','1160','1','O','tax_no','tax_no','String','','½ð¶îÀà±ð±àºÅ','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/03 20:37:29','','','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 ('Invoice_TJ_Gps','1170','1170','1','O','invoice_status','invoice_status','String','','¿ªÆ±×´Ì¬','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/03 20:37:29','','','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 ('Invoice_TJ_Gps','1180','1180','1','O','fpdm','fpdm','String','','·¢Æ±´úÂë','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/03 20:37:29','','','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 ('Invoice_TJ_Gps','1190','1190','1','O','fphm','fphm','String','','·¢Æ±ºÅÂë','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/03 20:37:29','','','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 ('Invoice_TJ_Gps','1200','1200','1','O','hztzdh','hztzdh','String','','ºì³åºì×Öµ¥ºÅ','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/03 20:37:29','','','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 ('Invoice_TJ_Gps','1210','1210','1','O','mxxh','mxxh','String','','ÌõÄ¿±àºÅ','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/04 09:36:31','SYS_Designer','2020/11/04 09:36:31','','','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 ('Invoice_TJ_Gps','1220','1220','1','O','liti_id','liti_id','String','','·¢Æ±±íid','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/04 16:56:15','SYS_Designer','2020/11/04 16:56:15','','','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 ('Invoice_TJ_Gps','1230','1230','1','O','tax_code','tax_code','String','','Ë°ÂʱàÂë','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/11/26 20:43:54','SYS_Designer','2020/11/26 20:43:54','','','1','','','','');
|
||
|
||
-- Invoice_TJ_Leaseback Ä£°å
|
||
delete from AWE_DO_CATALOG where dono='Invoice_TJ_Leaseback';
|
||
delete from awe_do_library where dono='Invoice_TJ_Leaseback';
|
||
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 ('Invoice_TJ_Leaseback','»Ø×â-ÆÕƱ£¨Ìì½ò£©',null,'30',null,'1','1','default','jbo.app.tenwa.calc.LI_INVOICE_TJ_AUTO','O left join jbo.app.tenwa.calc.LI_INVOICE_TJ_INFO li on O.contract_no=li.contract_no and O.plan_list=li.plan_list and O.tax_no=li.tax_type and li.status=''Y''','O.tax_no in (''interest'',''penalty'',''feetype1'',''feetype4'',''feetype30'') and O.lease_form=''02''','','','com.tenwa.flow.rent.rentincome.TaxRatioListHandler',null,'SYS_Designer','2020/07/22 19:05:36','SYS_Designer','2020/11/27 16:49:40','','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 ('Invoice_TJ_Leaseback','1010','1010','1','O','contract_id','contract_id','String','','ºÏͬid','','1','Text','1','1','','','','20','0','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:40','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 ('Invoice_TJ_Leaseback','1020','1020','1','O','contract_no','contract_no','String','','ºÏͬ±àºÅ','','1','Text','1','1','','','','32','1','0','0','1','1',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:40','','','1','','','','Like');
|
||
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 ('Invoice_TJ_Leaseback','1040','1040','1','O','customer_name','customer_name','String','','¿Í»§Ãû³Æ','','1','Text','1','1','','','','20','1','0','0','1','1',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:40','','','1','','','','Like');
|
||
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 ('Invoice_TJ_Leaseback','1060','1060','1','O','invoice_money','invoice_money','String','','¿ªÆ±½ð¶î','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1070','1070','1','O','tax_type','tax_type','String','','½ð¶îÀàÐÍ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:40','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 ('Invoice_TJ_Leaseback','1080','1080','1','O','cert_id','cert_id','String','','ÄÉË°ÈËʶ±ðºÅ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1090','1090','1','O','account','account','String','','ÕË»§','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1100','1100','1','O','acc_number','acc_number','String','','¿ª»§Õ˺Å','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1110','1110','1','O','bank_name','bank_name','String','','¿ª»§ÐÐ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1120','1120','1','O','telephone','telephone','String','','ÁªÏµµç»°','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1130','1130','1','O','customer_type','customer_type','String','','¿Í»§ÀàÐÍ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:40','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 ('Invoice_TJ_Leaseback','1140','1140','1','','''''','tax_ratio','String','','Ë°ÂÊ','%','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/27 17:09:08','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1150','1150','1','O','plan_list','plan_list','String','','ÆÚ´Î','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1160','1160','1','O','tax_no','tax_no','String','','½ð¶îÀà±ð±àºÅ','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1170','1170','1','li','status','status','String','','¿ªÆ±×´Ì¬','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1180','1180','1','li','fpdm','fpdm','String','','·¢Æ±´úÂë','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1190','1190','1','li','fphm','fphm','String','','·¢Æ±ºÅÂë','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1200','1200','1','li','hztzdh','hztzdh','String','','ºì³åºì×Öµ¥ºÅ','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1210','1210','1','li','mxxh','mxxh','String','','ÌõÄ¿±àºÅ','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/04 09:36:31','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1220','1220','1','li','id','id','String','','·¢Æ±±íid','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/04 16:56:15','SYS_Designer','2020/11/27 16:49:40','','','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 ('Invoice_TJ_Leaseback','1230','1230','1','O','tax_code','tax_code','String','','Ë°ÂʱàÂë','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/11/26 20:43:54','SYS_Designer','2020/11/27 16:49:41','','','1','','','','');
|
||
|
||
-- Invoice_TJ_Leasedirect Ä£°å
|
||
delete from AWE_DO_CATALOG where dono='Invoice_TJ_Leasedirect';
|
||
delete from awe_do_library where dono='Invoice_TJ_Leasedirect';
|
||
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 ('Invoice_TJ_Leasedirect','Ö±×â-רƱ£¨Ìì½ò£©',null,'30',null,'1','1','default','jbo.app.tenwa.calc.LI_INVOICE_TJ_AUTO','O left join jbo.app.tenwa.calc.LI_INVOICE_TJ_INFO li on O.contract_no=li.contract_no and O.plan_list=li.plan_list and O.tax_no=li.tax_type and li.status=''Y''','O.tax_no in (''rent'',''penalty'',''feetype1'',''feetype4'',''feetype30'') and O.lease_form=''01''','','','com.tenwa.flow.rent.rentincome.TaxRatioListHandler',null,'SYS_Designer','2020/07/23 14:16:12','SYS_Designer','2020/11/27 16:49:41','','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 ('Invoice_TJ_Leasedirect','1010','1010','1','O','contract_id','contract_id','String','','ºÏͬid','','1','Text','1','1','','','','20','0','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:41','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 ('Invoice_TJ_Leasedirect','1020','1020','1','O','contract_no','contract_no','String','','ºÏͬ±àºÅ','','1','Text','1','1','','','','32','1','0','0','1','1',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:41','','','1','','','','Like');
|
||
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 ('Invoice_TJ_Leasedirect','1040','1040','1','O','customer_name','customer_name','String','','¿Í»§Ãû³Æ','','1','Text','1','1','','','','20','1','0','0','1','1',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:41','','','1','','','','Like');
|
||
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 ('Invoice_TJ_Leasedirect','1060','1060','1','O','invoice_money','invoice_money','String','','¿ªÆ±½ð¶î','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:41','','','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 ('Invoice_TJ_Leasedirect','1070','1070','1','O','tax_type','tax_type','String','','½ð¶îÀàÐÍ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:41','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 ('Invoice_TJ_Leasedirect','1080','1080','1','O','cert_id','cert_id','String','','ÄÉË°ÈËʶ±ðºÅ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:41','','','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 ('Invoice_TJ_Leasedirect','1090','1090','1','O','account','account','String','','ÕË»§','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:41','','','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 ('Invoice_TJ_Leasedirect','1100','1100','1','O','acc_number','acc_number','String','','¿ª»§Õ˺Å','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:41','','','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 ('Invoice_TJ_Leasedirect','1110','1110','1','O','bank_name','bank_name','String','','¿ª»§ÐÐ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:41','','','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 ('Invoice_TJ_Leasedirect','1120','1120','1','O','telephone','telephone','String','','ÁªÏµµç»°','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:41','','','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 ('Invoice_TJ_Leasedirect','1130','1130','1','O','customer_type','customer_type','String','','¿Í»§ÀàÐÍ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/07/23 15:11:17','SYS_Designer','2020/11/27 16:49:41','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 ('Invoice_TJ_Leasedirect','1140','1140','1','','''''','tax_ratio','String','','Ë°ÂÊ','%','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/27 17:09:08','SYS_Designer','2020/11/27 16:49:41','','','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 ('Invoice_TJ_Leasedirect','1150','1150','1','O','plan_list','plan_list','String','','ÆÚ´Î','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/27 16:49:41','','','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 ('Invoice_TJ_Leasedirect','1160','1160','1','O','tax_no','tax_no','String','','½ð¶îÀà±ð±àºÅ','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/27 16:49:41','','','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 ('Invoice_TJ_Leasedirect','1170','1170','1','li','status','status','String','','¿ªÆ±×´Ì¬','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/27 16:56: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 ('Invoice_TJ_Leasedirect','1180','1180','1','li','fpdm','fpdm','String','','·¢Æ±´úÂë','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/27 16:56: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 ('Invoice_TJ_Leasedirect','1190','1190','1','li','fphm','fphm','String','','·¢Æ±ºÅÂë','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/27 16:56: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 ('Invoice_TJ_Leasedirect','1200','1200','1','li','hztzdh','hztzdh','String','','ºì³åºì×Öµ¥ºÅ','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/03 14:18:58','SYS_Designer','2020/11/27 16:56: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 ('Invoice_TJ_Leasedirect','1210','1210','1','li','mxxh','mxxh','String','','ÌõÄ¿±àºÅ','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/04 09:36:31','SYS_Designer','2020/11/27 16:56: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 ('Invoice_TJ_Leasedirect','1220','1220','1','li','id','id','String','','·¢Æ±±íid','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/04 16:56:15','SYS_Designer','2020/11/27 16:56: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 ('Invoice_TJ_Leasedirect','1230','1230','1','O','tax_code','tax_code','String','','Ë°ÂʱàÂë','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/11/26 20:43:54','SYS_Designer','2020/11/27 16:49:41','','','1','','','','');
|
||
|
||
-- taxCodeList Ä£°å
|
||
delete from AWE_DO_CATALOG where dono='taxCodeList';
|
||
delete from awe_do_library where dono='taxCodeList';
|
||
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 ('taxCodeList','Ë°ÂʱàÂëÐÅÏ¢',null,'30',null,'1','1','default','jbo.app.tenwa.calc.TAX_CODE_INFO','O','','','','',null,'SYS_Designer','2020/07/30 16:05:18','SYS_Designer','2020/07/30 16:05:49','','0','');
|
||
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 ('taxCodeList','0010','0010','1','O','id','id','String','','id','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/07/30 16:05:18','SYS_Designer','2020/07/30 16:05:49','','','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 ('taxCodeList','0020','0020','1','O','code','code','String','','±àÂë','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/30 16:05:18','SYS_Designer','2020/07/30 16:05:49','','','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 ('taxCodeList','0030','0030','1','O','full_code','full_code','String','','ºÏ²¢±àÂë','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/30 16:05:18','SYS_Designer','2020/07/30 16:05:49','','','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 ('taxCodeList','0040','0040','1','O','tax_type','tax_type','String','','Ãû³Æ','','1','Select','1','1','Code','tax_type','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/30 16:05:18','SYS_Designer','2020/07/30 16:24: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 ('taxCodeList','0050','0050','1','O','remark','remark','String','','¼ò³Æ','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/30 16:05:18','SYS_Designer','2020/07/30 16:05:50','','','1','','','','');
|
||
|
||
-- taxCodeInfo Ä£°å
|
||
delete from AWE_DO_CATALOG where dono='taxCodeInfo';
|
||
delete from awe_do_library where dono='taxCodeInfo';
|
||
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 ('taxCodeInfo','Ë°ÂʱàÂëÐÅÏ¢',null,'30',null,'1','1','default','jbo.app.tenwa.calc.TAX_CODE_INFO','O','id=:id','','','',null,'SYS_Designer','2020/07/30 16:05:18','SYS_Designer','2020/07/30 16:05:50','','0','');
|
||
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 ('taxCodeInfo','0010','0010','1','O','id','id','String','','id','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/07/30 16:05:18','SYS_Designer','2020/07/30 16:05:50','','','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 ('taxCodeInfo','0020','0020','1','O','code','code','String','','±àÂë','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/30 16:05:18','SYS_Designer','2020/07/30 16:05:50','','','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 ('taxCodeInfo','0030','0030','1','O','full_code','full_code','String','','ºÏ²¢±àÂë','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/30 16:05:18','SYS_Designer','2020/07/30 16:05:50','','','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 ('taxCodeInfo','0040','0040','1','O','tax_type','tax_type','String','','Ãû³Æ','','1','Select','1','1','Code','tax_type','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/30 16:05:18','SYS_Designer','2020/07/30 16:24:28','','','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 ('taxCodeInfo','0050','0050','1','O','remark','remark','String','','¼ò³Æ','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/30 16:05:18','SYS_Designer','2020/07/30 16:05:50','','','1','','','','');
|
||
|
||
-- taxOperatorList Ä£°å
|
||
delete from AWE_DO_CATALOG where dono='taxOperatorList';
|
||
delete from awe_do_library where dono='taxOperatorList';
|
||
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 ('taxOperatorList','·¢Æ±²Ù×÷ÕßÐÅÏ¢',null,'30',null,'1','1','default','jbo.app.tenwa.calc.TAX_OPERATOR_INFO','O','','','','',null,'SYS_Designer','2020/07/28 09:51:11','SYS_Designer','2020/07/28 11:00:22','','0','');
|
||
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 ('taxOperatorList','0010','0010','1','O','id','id','String','','id','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/07/28 09:51:11','SYS_Designer','2020/07/28 11:00: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 ('taxOperatorList','0020','0020','1','O','tax_creator','tax_creator','String','','¿ªÆ±ÈË','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/28 09:51:11','SYS_Designer','2020/07/28 11:00: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 ('taxOperatorList','0030','0030','1','O','tax_checker','tax_checker','String','','¸´ºËÈË','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/28 09:51:11','SYS_Designer','2020/07/28 11:00: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 ('taxOperatorList','0040','0040','1','O','is_use','is_use','String','','ÊÇ·ñÆôÓÃ','','1','Select','1','1','Code','YesOrNo','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/28 10:24:54','SYS_Designer','2020/07/28 11:00: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 ('taxOperatorList','0050','0005','1','O','Payee','Payee','String','','ÊÕ¿îÈË','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/11/04 17:45:06','SYS_Designer','2020/11/04 17:45:06','','','1','','','','');
|
||
|
||
-- taxOperatorInfo Ä£°å
|
||
delete from AWE_DO_CATALOG where dono='taxOperatorInfo';
|
||
delete from awe_do_library where dono='taxOperatorInfo';
|
||
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 ('taxOperatorInfo','·¢Æ±²Ù×÷ÕßÐÅÏ¢',null,'30',null,'1','1','default','jbo.app.tenwa.calc.TAX_OPERATOR_INFO','O','id=:id','','','',null,'SYS_Designer','2020/07/28 10:58:05','SYS_Designer','2020/07/28 10:58:05','','0','');
|
||
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 ('taxOperatorInfo','0010','0010','1','O','id','id','String','','id','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/07/28 10:58:05','SYS_Designer','2020/07/28 10:58:05','','','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 ('taxOperatorInfo','0020','0020','1','O','tax_creator','tax_creator','String','','¿ªÆ±ÈË','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/28 10:58:05','SYS_Designer','2020/07/28 10:58:05','','','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 ('taxOperatorInfo','0030','0030','1','O','tax_checker','tax_checker','String','','¸´ºËÈË','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/28 10:58:05','SYS_Designer','2020/07/28 10:58:05','','','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 ('taxOperatorInfo','0040','0040','1','O','is_use','is_use','String','','ÊÇ·ñÆôÓÃ','','1','Select','1','1','Code','YesOrNo','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/07/28 10:58:05','SYS_Designer','2020/07/28 10:58:05','','','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 ('taxOperatorInfo','0050','0005','1','O','Payee','Payee','String','','ÊÕ¿îÈË','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/11/04 17:45:06','SYS_Designer','2020/11/04 17:45:06','','','1','','','','');
|
||
|
||
-- Êý¾Ý×Öµä
|
||
delete from CODE_CATALOG where codeno='tax_type';
|
||
delete from Code_Library where codeno='tax_type';
|
||
Insert Into CODE_CATALOG (codeno,sortno,codetypeone,codetypetwo,codename,codedescribe,codeattribute,inputuser,inputorg,inputtime,updateuser,updatetime,remark) Values ('tax_type','','»ù±¾ÅäÖÃ','·¢Æ±¹ÜÀí','·¢Æ±ÀàÐÍ','','','SYS_Designer',null,'2020/07/30 16:24:11','SYS_Designer','2020/07/30 16:24:11','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('tax_type','feetype1','ÊÖÐø·Ñ','','0040','1','','','','','','','','','','','','SYS_Designer',null,'2020/07/30 16:24:11','SYS_Designer','2020/11/03 11:15:46','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('tax_type','feetype24','GPS°²×°·þÎñ·Ñ','','0070','1','','','','','','','','','','','','SYS_Designer',null,'2020/07/30 16:26:33','SYS_Designer','2020/11/03 11:15:46','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('tax_type','feetype30','Î¥Ô¼½ð','','0060','1','','','','','','','','','','','','SYS_Designer',null,'2020/07/30 16:24:11','SYS_Designer','2020/11/03 11:15:46','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('tax_type','feetype4','Áô¹º¼Û¿î','','0050','1','','','','','','','','','','','','SYS_Designer',null,'2020/07/30 16:24:11','SYS_Designer','2020/11/03 11:15:46','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('tax_type','interest','ÀûÏ¢','','0010','1','','','','','','','','','','','','SYS_Designer',null,'2020/07/30 16:24:11','SYS_Designer','2020/11/03 11:15:46','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('tax_type','penalty','ÓâÆÚÀûÏ¢','','0020','1','','','','','','','','','','','','SYS_Designer',null,'2020/07/30 16:24:11','SYS_Designer','2020/11/03 11:15:46','','');
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('tax_type','rent','×â½ð','','0030','1','','','','','','','','','','','','SYS_Designer',null,'2020/07/30 16:24:11','SYS_Designer','2020/11/03 11:15:46','','');
|
||
|
||
-- Invoice_TJ_Gps_hadÄ£°å
|
||
delete from AWE_DO_CATALOG where dono='Invoice_TJ_Gps_had';
|
||
delete from awe_do_library where dono='Invoice_TJ_Gps_had';
|
||
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 ('Invoice_TJ_Gps_had','GPS-רƱ£¨Ìì½ò£©(ÒÑ¿ª)',null,'30',null,'1','1','default','jbo.app.tenwa.calc.VI_LI_INVOICE_TJ_GPS','O','','','','',null,'SYS_Designer','2020/11/05 10:19:07','SYS_Designer','2020/11/05 10:19:07','','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 ('Invoice_TJ_Gps_had','1010','1010','1','O','contract_id','contract_id','String','','ºÏͬid','','1','Text','1','1','','','','20','0','0','0','1','0',1,'0','','','SYS_Designer','2020/11/05 10:19:07','SYS_Designer','2020/11/05 10:19:07','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 ('Invoice_TJ_Gps_had','1020','1020','1','O','contract_no','contract_no','String','','ºÏͬ±àºÅ','','1','Text','1','1','','','','32','1','0','0','1','1',1,'0','','','SYS_Designer','2020/11/05 10:19:07','SYS_Designer','2020/11/05 10:19:07','','','1','','','','Like');
|
||
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 ('Invoice_TJ_Gps_had','1040','1040','1','O','customer_name','customer_name','String','','¿Í»§Ãû³Æ','','1','Text','1','1','','','','20','1','0','0','1','1',1,'0','','','SYS_Designer','2020/11/05 10:19:07','SYS_Designer','2020/11/05 10:19:07','','','1','','','','Like');
|
||
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 ('Invoice_TJ_Gps_had','1060','1060','1','O','invoice_money','invoice_money','String','','¿ªÆ±½ð¶î','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/11/05 10:19:07','SYS_Designer','2020/11/05 10:19:07','','','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 ('Invoice_TJ_Gps_had','1070','1070','1','O','tax_type','tax_type','String','','½ð¶îÀàÐÍ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:08','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 ('Invoice_TJ_Gps_had','1080','1080','1','O','cert_id','cert_id','String','','ÄÉË°ÈËʶ±ðºÅ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:08','','','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 ('Invoice_TJ_Gps_had','1090','1090','1','O','account','account','String','','ÕË»§','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:08','','','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 ('Invoice_TJ_Gps_had','1100','1100','1','O','acc_number','acc_number','String','','¿ª»§Õ˺Å','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:08','','','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 ('Invoice_TJ_Gps_had','1110','1110','1','O','bank_name','bank_name','String','','¿ª»§ÐÐ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:08','','','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 ('Invoice_TJ_Gps_had','1120','1120','1','O','telephone','telephone','String','','ÁªÏµµç»°','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:08','','','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 ('Invoice_TJ_Gps_had','1130','1130','1','O','customer_type','customer_type','String','','¿Í»§ÀàÐÍ','','1','Text','1','1','','','','20','1','0','0','1','0',1,'0','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:08','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 ('Invoice_TJ_Gps_had','1140','1140','1','O','tax_ratio','tax_ratio','String','','Ë°ÂÊ','%','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:08','','','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 ('Invoice_TJ_Gps_had','1150','1150','1','O','plan_list','plan_list','String','','ÆÚ´Î','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:08','','','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 ('Invoice_TJ_Gps_had','1160','1160','1','O','tax_no','tax_no','String','','½ð¶îÀà±ð±àºÅ','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:08','','','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 ('Invoice_TJ_Gps_had','1170','1170','1','O','invoice_status','invoice_status','String','','¿ªÆ±×´Ì¬','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:08','','','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 ('Invoice_TJ_Gps_had','1180','1180','1','O','fpdm','fpdm','String','','·¢Æ±´úÂë','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:59','','','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 ('Invoice_TJ_Gps_had','1190','1190','1','O','fphm','fphm','String','','·¢Æ±ºÅÂë','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:59','','','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 ('Invoice_TJ_Gps_had','1200','1200','1','O','hztzdh','hztzdh','String','','ºì³åºì×Öµ¥ºÅ','','1','Text','1','1','','','',null,'1','0','0','1','0',0,'','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:59','','','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 ('Invoice_TJ_Gps_had','1210','1210','1','O','mxxh','mxxh','String','','ÌõÄ¿±àºÅ','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:08','','','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 ('Invoice_TJ_Gps_had','1220','1220','1','O','liti_id','liti_id','String','','·¢Æ±±íid','','1','Text','1','1','','','',null,'0','0','0','1','0',0,'','','','SYS_Designer','2020/11/05 10:19:08','SYS_Designer','2020/11/05 10:19:08','','','1','','','','');
|
||
|
||
--
|
||
Insert Into Code_Library (codeno,itemno,itemname,bankno,sortno,isinuse,itemdescribe,itemattribute,relativecode,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,inputuser,inputorg,inputtime,updateuser,updatetime,remark,helptext) Values ('MissionName','com.tenwa.lease.app.quartzmession.AutoCopyTaxInfoTJ','Ìì½òË°¿Ø×Ô¶¯¿½±í','','30509016','1','','','','','','','','','','','','SYS_Designer',null,'2020/11/27 14:38:14','SYS_Designer','2020/11/27 14:38:14','','');
|
||
ALTER TABLE `li_invoice_tj_info` ADD INDEX indx_contract_no ( `contract_no` ) ;
|
||
ALTER TABLE `li_invoice_tj_info` ADD INDEX indx_plan_list ( `plan_list` ) ;
|
||
ALTER TABLE `li_invoice_tj_info` ADD INDEX indx_tax_type ( `tax_type` ) ; |