新增历史会计期间

栏目：eas cloud知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

新增历史会计期间

插入语句：

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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