新增历史会计期间，1、ctrl+F全部替换年份比如2017--20162、不同公司新增会计期间的话需要替换会计期间类型的FID以及组织的FID插入语句：insertintot_bd_period(FID,FPeriodYear,FPeriodQuarter,FPeriodNumber,FBeginDate,FEndDate,FIsAdjustPeriod,FTypeID,FCreatorID,FCreateTime,FLastUpdateUserID,FLastUpdateTime,FControlUnitID,Fnumber,FDescription_l1,FDescription_l2,FDescription_l3)values(newbosid('82388C4C'),2021,4,12,{ts'2021-12-0100:00:00'},{ts'2021-12-3100:00:00'},0,N'LpQAAAAAAAlfaYmm（会计期间类型的FID）','256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},'256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},N'oDMAAAAAD+nM567U（组织单元的FID）',202112,null,N'2021年12期',null);insertintot_bd_period(FID,FPeriodYear,FPeriodQuarter,FPeriodNumber,FBeginDate,FEndDate,FIsAdjustPeriod,FTypeID,FCreatorID,FCreateTime,FLastUpdateUserID,FLastUpdateTime,FControlUnitID,Fnumber,FDescription_l1,FDescription_l2,FDescription_l3)values(newbosid('82388C4C'),2021,4,10,{ts'2021-10-0100:00:00'},{ts'2021-10-3100:00:00'},0,N'LpQAAAAAAAlfaYmm','256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},'256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},N'oDMAAAAAD+nM567U',202110,null,N'2021年10期',null);insertintot_bd_period(FID,FPeriodYear,FPeriodQuarter,FPeriodNumber,FBeginDate,FEndDate,FIsAdjustPeriod,FTypeID,FCreatorID,FCreateTime,FLastUpdateUserID,FLastUpdateTime,FControlUnitID,Fnumber,FDescription_l1,FDescription_l2,FDescription_l3)values(newbosid('82388C4C'),2021,4,11,{ts'2021-11-0100:00:00'},{ts'2021-11-3000:00:00'},0,N'LpQAAAAAAAlfaYmm','256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},'256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},N'oDMAAAAAD+nM567U',202111,null,N'2021年11期',null);insertintot_bd_period(FID,FPeriodYear,FPeriodQuarter,FPeriodNumber,FBeginDate,FEndDate,FIsAdjustPeriod,FTypeID,FCreatorID,FCreateTime,FLastUpdateUserID,FLastUpdateTime,FControlUnitID,Fnumber,FDescription_l1,FDescription_l2,FDescription_l3)values(newbosid('82388C4C'),2021,1,3,{ts'2021-03-0100:00:00'},{ts'2021-03-3100:00:00'},0,N'LpQAAAAAAAlfaYmm','256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},'256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},N'oDMAAAAAD+nM567U',202103,null,N'2021年3期',null);insertintot_bd_period(FID,FPeriodYear,FPeriodQuarter,FPeriodNumber,FBeginDate,FEndDate,FIsAdjustPeriod,FTypeID,FCreatorID,FCreateTime,FLastUpdateUserID,FLastUpdateTime,FControlUnitID,Fnumber,FDescription_l1,FDescription_l2,FDescription_l3)values(newbosid('82388C4C'),2021,2,4,{ts'2021-04-0100:00:00'},{ts'2021-04-3000:00:00'},0,N'LpQAAAAAAAlfaYmm','256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},'256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},N'oDMAAAAAD+nM567U',202104,null,N'2021年4期',null);insertintot_bd_period(FID,FPeriodYear,FPeriodQuarter,FPeriodNumber,FBeginDate,FEndDate,FIsAdjustPeriod,FTypeID,FCreatorID,FCreateTime,FLastUpdateUserID,FLastUpdateTime,FControlUnitID,Fnumber,FDescription_l1,FDescription_l2,FDescription_l3)values(newbosid('82388C4C'),2021,2,5,{ts'2021-05-0100:00:00'},{ts'2021-05-3100:00:00'},0,N'LpQAAAAAAAlfaYmm','256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},'256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},N'oDMAAAAAD+nM567U',202105,null,N'2021年5期',null);insertintot_bd_period(FID,FPeriodYear,FPeriodQuarter,FPeriodNumber,FBeginDate,FEndDate,FIsAdjustPeriod,FTypeID,FCreatorID,FCreateTime,FLastUpdateUserID,FLastUpdateTime,FControlUnitID,Fnumber,FDescription_l1,FDescription_l2,FDescription_l3)values(newbosid('82388C4C'),2021,2,6,{ts'2021-06-0100:00:00'},{ts'2021-06-3000:00:00'},0,N'LpQAAAAAAAlfaYmm','256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},'256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},N'oDMAAAAAD+nM567U',202106,null,N'2021年6期',null);insertintot_bd_period(FID,FPeriodYear,FPeriodQuarter,FPeriodNumber,FBeginDate,FEndDate,FIsAdjustPeriod,FTypeID,FCreatorID,FCreateTime,FLastUpdateUserID,FLastUpdateTime,FControlUnitID,Fnumber,FDescription_l1,FDescription_l2,FDescription_l3)values(newbosid('82388C4C'),2021,3,7,{ts'2021-07-0100:00:00'},{ts'2021-07-3100:00:00'},0,N'LpQAAAAAAAlfaYmm','256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},'256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},N'oDMAAAAAD+nM567U',202107,null,N'2021年7期',null);insertintot_bd_period(FID,FPeriodYear,FPeriodQuarter,FPeriodNumber,FBeginDate,FEndDate,FIsAdjustPeriod,FTypeID,FCreatorID,FCreateTime,FLastUpdateUserID,FLastUpdateTime,FControlUnitID,Fnumber,FDescription_l1,FDescription_l2,FDescription_l3)values(newbosid('82388C4C'),2021,1,1,{ts'2021-01-0100:00:00'},{ts'2021-01-3100:00:00'},0,N'LpQAAAAAAAlfaYmm','256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},'256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},N'oDMAAAAAD+nM567U',202101,null,N'2021年1期',null);insertintot_bd_period(FID,FPeriodYear,FPeriodQuarter,FPeriodNumber,FBeginDate,FEndDate,FIsAdjustPeriod,FTypeID,FCreatorID,FCreateTime,FLastUpdateUserID,FLastUpdateTime,FControlUnitID,Fnumber,FDescription_l1,FDescription_l2,FDescription_l3)values(newbosid('82388C4C'),2021,3,8,{ts'2021-08-0100:00:00'},{ts'2021-08-3100:00:00'},0,N'LpQAAAAAAAlfaYmm','256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},'256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},N'oDMAAAAAD+nM567U',202108,null,N'2021年8期',null);insertintot_bd_period(FID,FPeriodYear,FPeriodQuarter,FPeriodNumber,FBeginDate,FEndDate,FIsAdjustPeriod,FTypeID,FCreatorID,FCreateTime,FLastUpdateUserID,FLastUpdateTime,FControlUnitID,Fnumber,FDescription_l1,FDescription_l2,FDescription_l3)values(newbosid('82388C4C'),2021,1,2,{ts'2021-02-0100:00:00'},{ts'2021-02-2800:00:00'},0,N'LpQAAAAAAAlfaYmm','256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},'256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},N'oDMAAAAAD+nM567U',202102,null,N'2021年2期',null);insertintot_bd_period(FID,FPeriodYear,FPeriodQuarter,FPeriodNumber,FBeginDate,FEndDate,FIsAdjustPeriod,FTypeID,FCreatorID,FCreateTime,FLastUpdateUserID,FLastUpdateTime,FControlUnitID,Fnumber,FDescription_l1,FDescription_l2,FDescription_l3)values(newbosid('82388C4C'),2021,3,9,{ts'2021-09-0100:00:00'},{ts'2021-09-3000:00:00'},0,N'LpQAAAAAAAlfaYmm','256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},'256c221a-0106-1000-e000-10d7c0a813f413B7DE7F',{ts'2023-08-0810:18:44'},N'oDMAAAAAD+nM567U',202109,null,N'2021年9期',null);
