| Tang Cheng | defd94a | 2019-06-27 16:16:12 +0800 | [diff] [blame] | 1 | --pg-- |
| 2 | INSERT INTO "tb_period" ("period_year", "period_month", "startdate", "enddate", "settleflag" , "tenantid") |
| 3 | VALUES (to_number(to_char(CURRENT_TIMESTAMP,'yyyy'),'9999'),to_number(to_char(CURRENT_TIMESTAMP,'MM'),'99'), to_char(CURRENT_TIMESTAMP,'yyyyMM')||'01', to_char((to_date(to_char(CURRENT_TIMESTAMP+'1 month','yyyyMM')||'01','yyyyMMdd')-1)::Timestamp,'yyyyMMdd'), 0, '{tenantid}'); |
| 4 | |
| 5 | insert into TB_SETTLECTL(BOOKSETNO,PERIODYEAR,PERIODMONTH,STATDATE,SETTLEDATE,STATUS,updtime, "tenantid") |
| 6 | values (1,to_number(to_char(CURRENT_TIMESTAMP,'yyyy'),'9999'),to_number(to_char(CURRENT_TIMESTAMP,'MM'),'99'),to_number(to_char(CURRENT_TIMESTAMP,'yyyyMMdd'),'99999999'),to_number(to_char(CURRENT_TIMESTAMP,'yyyyMMdd'),'99999999'),0,to_char(CURRENT_TIMESTAMP,'yyyyMMddhh24miss'), '{tenantid}'); |
| 7 | |
| 8 | insert into TB_VOUCHERNOCTL(VOUCHERTYPE,PERIODMONTH,VOUCHERNO,"tenantid") |
| 9 | values (1,to_number(to_char(CURRENT_TIMESTAMP,'MM'),'99'),0, , '{tenantid}'); |
| 10 | |
| Tang Cheng | 91d822d | 2019-07-02 21:54:52 +0800 | [diff] [blame] | 11 | update TB_SUBJECT set opendate = to_number(to_char(CURRENT_TIMESTAMP,'yyyymmdd'),'99999999'); |
| 12 | |
| Tang Cheng | defd94a | 2019-06-27 16:16:12 +0800 | [diff] [blame] | 13 | CREATE SEQUENCE seq_refno; |
| 14 | |
| 15 | --------- end of script |
| 16 | commit; |