新增历史会计期间原创
EAS Cloud-财务
EAS Cloud-知识分享
金蝶云社区-星雨
星雨
12人赞赏了该文章 140次浏览 未经作者许可，禁止转载编辑于2023年11月08日 09:13:35

插入语句：

insert into t_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-01 00:00:00'}, {ts'2021-12-31 00:00:00'}, 0, N'LpQAAAAAAAlfaYmm（会计 期间类型的FID）', '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, N'oDMAAAAAD+nM567U（组织单元的FID）', 202112, null, N'2021年12期', null);

 

insert into t_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-01 00:00:00'}, {ts'2021-10-31 00:00:00'}, 0, N'LpQAAAAAAAlfaYmm', '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, N'oDMAAAAAD+nM567U', 202110, null, N'2021年10期', null);

 

insert into t_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-01 00:00:00'}, {ts'2021-11-30 00:00:00'}, 0, N'LpQAAAAAAAlfaYmm', '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, N'oDMAAAAAD+nM567U', 202111, null, N'2021年11期', null);

 

insert into t_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-01 00:00:00'}, {ts'2021-03-31 00:00:00'}, 0, N'LpQAAAAAAAlfaYmm', '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, N'oDMAAAAAD+nM567U', 202103, null, N'2021年3期', null);

 

insert into t_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-01 00:00:00'}, {ts'2021-04-30 00:00:00'}, 0, N'LpQAAAAAAAlfaYmm', '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, N'oDMAAAAAD+nM567U', 202104, null, N'2021年4期', null);

 

insert into t_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-01 00:00:00'}, {ts'2021-05-31 00:00:00'}, 0, N'LpQAAAAAAAlfaYmm', '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, N'oDMAAAAAD+nM567U', 202105, null, N'2021年5期', null);

 

insert into t_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-01 00:00:00'}, {ts'2021-06-30 00:00:00'}, 0, N'LpQAAAAAAAlfaYmm', '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, N'oDMAAAAAD+nM567U', 202106, null, N'2021年6期', null);

 

insert into t_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-01 00:00:00'}, {ts'2021-07-31 00:00:00'}, 0, N'LpQAAAAAAAlfaYmm', '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, N'oDMAAAAAD+nM567U', 202107, null, N'2021年7期', null);

 

insert into t_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-01 00:00:00'}, {ts'2021-01-31 00:00:00'}, 0, N'LpQAAAAAAAlfaYmm', '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, N'oDMAAAAAD+nM567U', 202101, null, N'2021年1期', null);

 

insert into t_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-01 00:00:00'}, {ts'2021-08-31 00:00:00'}, 0, N'LpQAAAAAAAlfaYmm', '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, N'oDMAAAAAD+nM567U', 202108, null, N'2021年8期', null);

 

insert into t_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-01 00:00:00'}, {ts'2021-02-28 00:00:00'}, 0, N'LpQAAAAAAAlfaYmm', '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, N'oDMAAAAAD+nM567U', 202102, null, N'2021年2期', null);

 

insert into t_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-01 00:00:00'}, {ts'2021-09-30 00:00:00'}, 0, N'LpQAAAAAAAlfaYmm', '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, '256c221a-0106-1000-e000-10d7c0a813f413B7DE7F', {ts'2023-08-08 10:18:44'}, N'oDMAAAAAD+nM567U', 202109, null, N'2021年9期', null);

 


新增历史会计期间.docx(15.37KB)

赞 12

推荐阅读

如何新增一个历史会计期间

举例：想要新增一个2016年的会计期间，请先在前端新增一个2021年的会计期间，再进行修改。 --备份表 Select * into bk_bd_period …

    文章

    662

(FAQ)会计期间:增加历史会计期间？

(FAQ)会计期间:增加历史会计期间？ 对于历史会计期间，前台无法增加，需通过以下步骤，增加新会计期间后，在后台修改成历史会计期间 创建2002年度会计期间： …

    文章

    2,032

新增会计期间时能否增加多个调整期

【系统逻辑】 系统暂时不支持新增多个调整期间。

    知识

    19