1593 lines
174 KiB
SQL
1593 lines
174 KiB
SQL
-- Generate periods for 2018 in GardenWorld
|
|
-- Oct 31, 2017 9:35:26 PM CET
|
|
INSERT INTO C_Year (C_Year_ID,AD_Client_ID,AD_Org_ID,IsActive,CreatedBy,Created,UpdatedBy,FiscalYear,Updated,C_Calendar_ID,Processing,C_Year_UU) VALUES (200006,11,0,'Y',100,TO_TIMESTAMP('2017-10-31 21:35:25','YYYY-MM-DD HH24:MI:SS'),100,'2018',TO_TIMESTAMP('2017-10-31 21:35:25','YYYY-MM-DD HH24:MI:SS'),102,'N','46816e37-1090-4341-82c7-e9ea3cf73978')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:28 PM CET
|
|
INSERT INTO C_Period (Name,StartDate,C_Period_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,PeriodNo,C_Year_ID,PeriodType,EndDate,Processing,C_Period_UU) VALUES ('Jan-18',TO_TIMESTAMP('2018-01-01','YYYY-MM-DD'),200072,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:28','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:28','YYYY-MM-DD HH24:MI:SS'),100,1,200006,'S',TO_TIMESTAMP('2018-01-31','YYYY-MM-DD'),'N','1060893a-7ae9-43dc-8c3e-e483a935e6e6')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:29 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202232,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:28','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:28','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','MMS','796e1e8e-da6e-4dce-89d1-89a85f1dd927')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:29 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202233,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:29','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:29','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','PJI','da2059a9-6215-4325-8d74-c4b5bef40fc1')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:30 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202234,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:29','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:29','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','MXI','93a2cbf3-2e48-4319-ab67-5825d3f9e032')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:30 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202235,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:30','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:30','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','MMP','43d7c7d3-7829-47d3-8a85-20c519361eeb')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:30 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202236,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:30','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:30','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','GLD','1003a8dd-4a22-4329-946c-87f7b79d19b4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:31 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202237,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:30','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:30','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','CMC','0ded57b9-c472-4233-a65f-9a359f04895f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:31 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202238,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:31','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:31','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','MXP','df9a576e-2e7d-4fa9-8d73-a2e95c434297')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:31 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202239,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:31','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:31','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','ARF','79b17870-5e48-415d-85ba-30320a55d168')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:32 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202240,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:31','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:31','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','CMB','c9d20b3c-b7ec-43c8-860c-7ece4e6b58e4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:32 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202241,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:32','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:32','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','API','eec11152-f282-48cd-908e-8c8068f471e4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:33 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202242,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:32','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:32','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','APC','849e977e-8c1c-43fc-a65a-f8744cc52050')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:33 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202243,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:33','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:33','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','GLJ','e2ceb8cc-5566-467d-9560-2baf560795b9')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:34 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202244,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:33','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:33','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','ARI','b2c4b4ef-bec2-45ce-8ed9-6b3c7c6618e4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:34 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202245,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:34','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:34','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','ARC','f3a659e7-f2bb-4875-ae9d-849ac79d59f4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:34 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202246,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:34','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:34','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','ARR','7b6574b0-8aee-48d7-a565-e0d094c30730')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:35 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202247,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:34','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:34','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','APP','f05809da-803d-427a-bf7b-65c2a0478252')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:35 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202248,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:35','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:35','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','SOO','bb67e956-21cd-4f46-adf0-4f7150aabcb3')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:36 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202249,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:35','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:35','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','POO','c06fb2cc-f1d3-496e-8674-a960dcccc37e')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:36 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202250,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:36','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:36','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','HRP','682f4370-fb77-4274-9e95-197d433dfa68')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:36 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202251,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:36','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:36','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','MOP','a7bb9bb0-fbdc-4d86-a293-053f5d6ef2d5')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:37 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202252,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:36','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:36','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','MMR','d1baf96e-b209-4bf1-8d1c-fe883d6d9a10')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:37 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202253,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:37','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:37','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','MQO','cda02b05-2c33-4f8b-882d-1c4d672a4c40')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:38 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202254,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:37','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:37','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','DOO','03dabd9e-aadb-4380-8c02-dda6c09fb859')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:38 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202255,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:38','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:38','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','CMA','eec804ac-83ae-4cdb-a3ea-d0b968e24787')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:39 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202256,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:38','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:38','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','MMM','05924b24-5a04-4de8-9b3f-a4e4d719e6b3')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:39 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202257,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:39','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:39','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','POR','70f0469d-084b-47da-8c0c-d49b4ade8690')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:40 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202258,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:39','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:39','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','MOF','4fa7514a-7179-4549-a5a6-5425d024e973')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:40 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202259,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:40','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:40','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','MCC','308a194b-50af-470c-a367-be716b72c95f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:41 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202260,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:40','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:40','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','MMI','a650f53c-ad4e-47bc-98f9-bd765389784f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:41 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202261,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:41','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:41','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','FAA','03c3be89-af87-4ddf-a7b6-ae6d9d2f9144')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:41 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202262,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:41','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:41','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','FDP','5b27a7eb-a5fe-4ab9-b197-1c5845f4558b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:42 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202263,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:41','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:41','YYYY-MM-DD HH24:MI:SS'),100,200072,'N','N','N','FAD','b5860e78-8b2d-4ca4-a887-596da1ae26b5')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:42 PM CET
|
|
INSERT INTO C_Period (Name,StartDate,C_Period_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,PeriodNo,C_Year_ID,PeriodType,EndDate,Processing,C_Period_UU) VALUES ('Feb-18',TO_TIMESTAMP('2018-02-01','YYYY-MM-DD'),200073,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:42','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:42','YYYY-MM-DD HH24:MI:SS'),100,2,200006,'S',TO_TIMESTAMP('2018-02-28','YYYY-MM-DD'),'N','72fcb221-c5fc-42cf-8eff-e996b7733480')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:43 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202264,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:42','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:42','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','MMS','eb616834-ad76-4af5-acad-6a1eb502a39e')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:43 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202265,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:43','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:43','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','PJI','d8f7e907-9bd4-41a6-a6bf-cd09db2a4a14')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:43 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202266,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:43','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:43','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','MXI','4557e46a-8a2c-4dd9-a236-b6d4f65c382b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:44 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202267,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:43','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:43','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','MMP','d57a46a5-aa53-4e15-a1c2-95ccfdb57145')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:44 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202268,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:44','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:44','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','GLD','2abf7653-b536-4db0-a8af-9063d2d72e1f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:44 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202269,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:44','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:44','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','CMC','296e54bc-c57c-4fc2-9a01-29ffc2516508')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:45 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202270,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:44','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:44','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','MXP','a7509dec-7ee3-45c9-b682-a881b84af77e')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:45 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202271,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:45','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:45','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','ARF','6ed541e2-df99-428b-897e-67c205334597')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:46 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202272,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:45','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:45','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','CMB','02a589e7-ca58-4924-887f-02940ba23c0d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:46 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202273,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:46','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:46','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','API','51c8d963-58de-40bb-9e21-3a8a8a2d2ae4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:46 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202274,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:46','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:46','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','APC','b0ece25c-0f6a-4674-bea1-05c3cb26f206')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:47 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202275,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:46','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:46','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','GLJ','7ec1f449-c7f7-4efb-ad2a-e3065c37435f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:47 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202276,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:47','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:47','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','ARI','75b2620f-d199-4700-81c5-724b704b4f20')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:47 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202277,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:47','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:47','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','ARC','0e6d7876-3a20-41fc-b110-c797c62167b9')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:48 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202278,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:47','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:47','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','ARR','fbd3d4c6-952a-491f-8917-351d90f8192d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:48 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202279,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:48','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:48','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','APP','dc298f7e-b978-4b37-9f69-19f973b2c940')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:49 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202280,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:48','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:48','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','SOO','6136f096-4889-4507-898b-cc998bc17122')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:49 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202281,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:49','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:49','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','POO','c315654a-45b4-4fc5-9845-24a9d260cf2b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:49 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202282,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:49','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:49','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','HRP','bf3c803e-f3d0-4672-a418-55ee0d66a9df')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:50 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202283,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:49','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:49','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','MOP','691cd30a-7ca0-464b-92a4-d2360a928260')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:50 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202284,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:50','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:50','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','MMR','d5d16619-d561-49f8-aa5f-5a8d24519d1c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:50 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202285,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:50','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:50','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','MQO','655a78c4-6ada-43a6-9fe3-f63ff41d4d54')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:51 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202286,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:50','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:50','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','DOO','8075a3c8-d108-4ff7-88b5-74b5b10a4765')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:51 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202287,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:51','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:51','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','CMA','1decbf51-fafa-4cef-8852-3db7eec10fd9')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:51 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202288,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:51','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:51','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','MMM','753de4a7-88a8-4091-b56d-e8f16c24ef85')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:52 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202289,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:51','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:51','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','POR','2abfc84c-9c48-4552-bd1a-7c79e5f02eca')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:52 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202290,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:52','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:52','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','MOF','c6bf5b8e-e7f7-4dad-8663-668862004276')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:53 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202291,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:52','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:52','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','MCC','6ff620ee-1770-4dc4-9e6d-d9698bcf7e53')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:53 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202292,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:53','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:53','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','MMI','3d5ed910-9ce5-4fb6-a4b7-833c0dc85f06')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:53 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202293,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:53','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:53','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','FAA','ef4e853d-92a0-422d-8cd0-63f266a9a918')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:54 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202294,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:53','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:53','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','FDP','0e5e8b0c-c1d4-4cd0-b89a-04a3620226ae')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:54 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202295,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:54','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:54','YYYY-MM-DD HH24:MI:SS'),100,200073,'N','N','N','FAD','68328e02-74cf-42e9-beae-7a5e8c5bf5bf')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:54 PM CET
|
|
INSERT INTO C_Period (Name,StartDate,C_Period_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,PeriodNo,C_Year_ID,PeriodType,EndDate,Processing,C_Period_UU) VALUES ('Mar-18',TO_TIMESTAMP('2018-03-01','YYYY-MM-DD'),200074,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:54','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:54','YYYY-MM-DD HH24:MI:SS'),100,3,200006,'S',TO_TIMESTAMP('2018-03-31','YYYY-MM-DD'),'N','fbedcd89-d3c2-450e-aea6-d7078e6bec20')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:55 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202296,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:54','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:54','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','MMS','4a1c9693-a267-4da0-a10c-a2b561adbe03')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:55 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202297,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:55','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:55','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','PJI','841b07d3-4e3c-4265-a457-2238c961ce2f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:55 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202298,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:55','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:55','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','MXI','2ee38f69-f6b9-4f8c-8ca3-fac890214898')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:56 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202299,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:55','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:55','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','MMP','fb87beb7-0d88-4291-8867-b719c684b8dc')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:56 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202300,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:56','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:56','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','GLD','810f3c71-df10-44ee-832b-d7041eb3e4aa')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:57 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202301,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:56','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:56','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','CMC','13286a4a-6b1e-4ca2-9860-8bf15d46d8a8')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:57 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202302,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:57','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:57','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','MXP','2564afd3-1791-42ed-8392-03469460f713')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:57 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202303,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:57','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:57','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','ARF','a6321456-92c9-43e7-abc1-d3bb1cdcdd82')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:58 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202304,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:57','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:57','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','CMB','5ce0ac5c-1571-4727-b30b-6842f00a344e')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:58 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202305,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:58','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:58','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','API','34b74cbb-6004-4f94-9916-df4320923eee')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:58 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202306,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:58','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:58','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','APC','947742af-c2c2-4615-a4be-af271d5db1ad')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:59 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202307,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:58','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:58','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','GLJ','c1f092f6-77e3-4bc5-a93e-8696995ad55b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:35:59 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202308,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:59','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:59','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','ARI','893f204a-49d4-475a-9db4-8ba242dc70f6')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:00 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202309,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:35:59','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:35:59','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','ARC','ab1f5c4b-875c-4ab8-90ce-3c0b2dd482a5')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:00 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202310,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:00','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:00','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','ARR','3a72e68b-54dd-4c4a-9e31-502b9deaecf8')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:00 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202311,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:00','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:00','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','APP','2b0ad4a4-0ffb-4f35-a0cf-3c6860f82268')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:01 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202312,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:00','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:00','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','SOO','2db5fc08-bef5-4995-b432-d048b5e64004')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:01 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202313,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:01','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:01','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','POO','de932e6d-926f-4566-bc80-18b1a6cc0bb4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:01 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202314,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:01','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:01','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','HRP','03d14ec4-dd71-4a0f-b7f9-997f29537810')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:02 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202315,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:01','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:01','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','MOP','baf123a4-6809-42a9-80f8-b0dc1bfe6dc7')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:02 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202316,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:02','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:02','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','MMR','4299389e-9ad3-4bca-8873-d79fb0106042')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:03 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202317,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:02','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:02','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','MQO','64befadc-656a-4980-b8cf-f96c0a316d56')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:03 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202318,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:03','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:03','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','DOO','e374474d-5308-4f76-a8ce-2e80daac4d5f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:03 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202319,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:03','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:03','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','CMA','70214d60-a62c-420a-a987-0496a4cc8e5d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:04 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202320,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:03','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:03','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','MMM','80daaf78-884e-4d33-bd88-c779bfbfab90')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:04 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202321,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:04','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:04','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','POR','984b5b1e-7dce-4080-be68-6ca8fd2ea32d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:05 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202322,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:04','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:04','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','MOF','fd3bff16-e62e-40cc-8e73-48871588c36c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:05 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202323,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:05','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:05','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','MCC','66682d47-edcb-4335-8e70-df2cbbefdad4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:05 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202324,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:05','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:05','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','MMI','7c9505e5-a0d1-4041-8b4c-45ca31c7c511')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:06 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202325,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:05','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:05','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','FAA','c074afb1-aaa5-4a46-82ef-ce9db60eceb8')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:06 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202326,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:06','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:06','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','FDP','710ddc25-ede3-4e88-ae97-7f7212a0662a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:07 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202327,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:06','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:06','YYYY-MM-DD HH24:MI:SS'),100,200074,'N','N','N','FAD','e57689a0-5600-46ac-b3b8-ec41db94ff4a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:07 PM CET
|
|
INSERT INTO C_Period (Name,StartDate,C_Period_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,PeriodNo,C_Year_ID,PeriodType,EndDate,Processing,C_Period_UU) VALUES ('Apr-18',TO_TIMESTAMP('2018-04-01','YYYY-MM-DD'),200075,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:07','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:07','YYYY-MM-DD HH24:MI:SS'),100,4,200006,'S',TO_TIMESTAMP('2018-04-30','YYYY-MM-DD'),'N','6d44a192-c25c-4072-9aca-20192624e35c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:08 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202328,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:07','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:07','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','MMS','a82854c1-4474-4890-8b60-d883d78aa064')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:08 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202329,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:08','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:08','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','PJI','2c16f07c-3c43-4da3-8083-3e17c1c98d7f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:08 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202330,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:08','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:08','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','MXI','6657f12b-e432-4b43-bd2c-d93c349b0656')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:09 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202331,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:08','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:08','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','MMP','43fc35d4-baf2-4716-9bff-e67f3e4ab468')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:09 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202332,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:09','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:09','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','GLD','5d9b0688-38bc-4a1d-a3cf-95959e52223b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:09 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202333,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:09','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:09','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','CMC','9b59319c-c508-4af3-a282-d970426a3a3a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:10 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202334,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:09','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:09','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','MXP','d5bd0800-2e43-4e27-aa15-0a53c512cb06')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:10 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202335,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:10','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:10','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','ARF','ddc8e345-38bc-4e8b-a115-5c10f6a1dfc7')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:11 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202336,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:10','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:10','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','CMB','c7171350-1286-43ea-8e8c-52296e980e84')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:11 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202337,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:11','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:11','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','API','a3abd644-019e-456e-99b6-09e71e49487a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:11 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202338,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:11','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:11','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','APC','d7d1cbb3-5095-495a-a095-cbd0adebb5a0')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:12 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202339,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:11','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:11','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','GLJ','a9dfab4c-9f24-400b-ab8d-3a0bce8e68fe')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:13 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202340,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:12','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:12','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','ARI','e7d5a0c0-c903-4a56-ae1e-b694ac440844')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:13 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202341,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:13','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:13','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','ARC','5550202c-0135-4e54-81fd-0cad19e43375')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:14 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202342,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:13','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:13','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','ARR','1bb38723-9aed-4667-941e-5d1a9ff68a98')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:14 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202343,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:14','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:14','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','APP','85441841-84cb-4e28-9c4f-14707bf83e68')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:15 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202344,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:14','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:14','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','SOO','cad549c4-bfda-4108-bebc-a3c29c3d95af')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:15 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202345,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:15','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:15','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','POO','1d80f37b-d1c6-4a0c-bc85-36cc4a9ae29d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:16 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202346,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:15','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:15','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','HRP','f5314cc0-a307-4fe8-848a-8ea76abb67fd')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:16 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202347,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:16','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:16','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','MOP','7de2351b-b359-40a2-b7ab-b08314fc0f25')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:16 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202348,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:16','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:16','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','MMR','a7741a3b-ac31-432b-98e8-abd5ca855414')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:17 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202349,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:16','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:16','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','MQO','a52ab13b-28fe-41d2-86d7-78ded21d5d7a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:17 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202350,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:17','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:17','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','DOO','157f6acf-f950-414a-8d44-3608b9f59358')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:18 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202351,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:17','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:17','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','CMA','fa73cf06-b318-4f5b-8616-4b24361ffaad')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:18 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202352,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:18','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:18','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','MMM','10f578b4-8505-4dea-9ae5-40006ae681ab')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:19 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202353,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:18','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:18','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','POR','50d78699-163f-463c-8767-af514db6303b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:19 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202354,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:19','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:19','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','MOF','6ab52f92-d0b5-4bbe-aca4-9eab8014f3e9')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:19 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202355,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:19','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:19','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','MCC','d22b668f-cc10-4796-ab69-aac8d32ca0cc')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:20 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202356,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:19','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:19','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','MMI','083481b7-196f-43bb-a453-967ca67039a3')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:20 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202357,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:20','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:20','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','FAA','61fc4f9d-db84-4e97-b7bc-0d4e772cc9e1')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:21 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202358,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:20','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:20','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','FDP','e4a78549-4b01-4a6a-8ca8-09b9580acf0f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:21 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202359,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:21','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:21','YYYY-MM-DD HH24:MI:SS'),100,200075,'N','N','N','FAD','04f89067-aa8a-4c56-a10c-75eeed509bb8')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:21 PM CET
|
|
INSERT INTO C_Period (Name,StartDate,C_Period_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,PeriodNo,C_Year_ID,PeriodType,EndDate,Processing,C_Period_UU) VALUES ('May-18',TO_TIMESTAMP('2018-05-01','YYYY-MM-DD'),200076,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:21','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:21','YYYY-MM-DD HH24:MI:SS'),100,5,200006,'S',TO_TIMESTAMP('2018-05-31','YYYY-MM-DD'),'N','dab1c7af-070f-4017-a05a-6b0e91cdb9b9')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:22 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202360,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:21','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:21','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','MMS','93648e89-a849-4d6c-bbe4-82c7a99a8beb')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:22 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202361,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:22','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:22','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','PJI','b1b7c5f8-5261-4163-99cf-a6cea0f954de')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:23 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202362,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:22','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:22','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','MXI','1a8d6c4b-4188-4d5f-9038-80b19084df57')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:23 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202363,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:23','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:23','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','MMP','a77e2af6-ca76-4f50-9718-aa5c332d424a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:23 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202364,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:23','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:23','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','GLD','9ed77956-5c22-4463-ae57-2fe46c744e0c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:24 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202365,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:24','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:24','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','CMC','76b2b85b-41ec-4bc0-8ee8-c854fa315322')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:25 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202366,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:24','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:24','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','MXP','72343062-674e-4318-bc75-bdc337a7d4e6')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:25 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202367,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:25','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:25','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','ARF','2284cb43-2ba1-4274-a2e9-aa53360f324c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:26 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202368,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:25','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:25','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','CMB','bab0532e-1ef8-4ebf-abec-dfe6a7321159')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:26 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202369,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:26','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:26','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','API','fce47aa1-d9b8-4f77-b7e6-48439c0599c5')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:26 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202370,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:26','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:26','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','APC','32dd04a4-b443-443e-a67f-ce19b2748cc6')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:27 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202371,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:26','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:26','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','GLJ','683febf8-aad8-41aa-8349-e1fbebd5dfd6')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:27 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202372,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:27','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:27','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','ARI','43c2ce99-ae4b-4180-ac2e-f26f401914c7')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:27 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202373,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:27','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:27','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','ARC','a216026a-f027-4468-b9f1-248125352981')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:28 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202374,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:28','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:28','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','ARR','fcbb04e3-a681-4684-8405-4cb071a64bbb')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:28 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202375,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:28','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:28','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','APP','f213e055-7c2e-46a1-87b0-4187ea59271c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:29 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202376,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:28','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:28','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','SOO','67b33a90-a518-47cc-ab57-b44de35b118f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:29 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202377,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:29','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:29','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','POO','f5a0a0fb-e4f8-4176-aea8-137b42b41b0a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:29 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202378,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:29','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:29','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','HRP','519c37c7-29e6-4baa-9bbd-58e56550a6fa')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:30 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202379,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:29','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:29','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','MOP','1fddf1b7-e964-461f-8c78-5755872beebe')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:30 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202380,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:30','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:30','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','MMR','fbcb99d9-3878-4940-a40f-3b5c6429cf4a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:30 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202381,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:30','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:30','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','MQO','430ea79e-24dd-4aaf-ba58-0d8b7a304ad1')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:31 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202382,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:30','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:30','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','DOO','2230754c-8fc5-48d4-9b47-8a410752358b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:31 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202383,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:31','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:31','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','CMA','421f1c2c-7774-49e7-a6bc-2805a07d2bd2')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:32 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202384,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:31','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:31','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','MMM','26d233b4-41ec-47fe-aa0a-4541ab0486aa')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:32 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202385,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:32','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:32','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','POR','03c43fa3-55a0-4403-b52a-d5144d329bb0')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:33 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202386,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:32','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:32','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','MOF','169af238-7152-491b-aa81-94e7eb86fe84')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:33 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202387,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:33','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:33','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','MCC','9cf8c988-eebd-4d63-8fcf-2fddff7c0121')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:33 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202388,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:33','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:33','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','MMI','701f2a50-2e54-468d-bc96-038468841f5b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:34 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202389,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:33','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:33','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','FAA','d49a6fba-e810-499e-ac8d-a0a4318bee86')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:34 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202390,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:34','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:34','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','FDP','9c8ede82-c026-41ac-82e9-15ffd396dcd1')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:34 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202391,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:34','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:34','YYYY-MM-DD HH24:MI:SS'),100,200076,'N','N','N','FAD','4a3181bc-d469-452d-9736-1fce31d31398')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:35 PM CET
|
|
INSERT INTO C_Period (Name,StartDate,C_Period_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,PeriodNo,C_Year_ID,PeriodType,EndDate,Processing,C_Period_UU) VALUES ('Jun-18',TO_TIMESTAMP('2018-06-01','YYYY-MM-DD'),200077,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:35','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:35','YYYY-MM-DD HH24:MI:SS'),100,6,200006,'S',TO_TIMESTAMP('2018-06-30','YYYY-MM-DD'),'N','24c9aea8-0be1-44a7-a11a-e98c585d0d20')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:35 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202392,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:35','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:35','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','MMS','940abb21-17bd-42ae-b14e-42c2707856f0')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:36 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202393,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:35','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:35','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','PJI','8268879d-ff72-46b4-8583-048539f1cca2')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:36 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202394,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:36','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:36','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','MXI','97e9c206-1c90-4cdd-bf17-d09141608509')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:36 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202395,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:36','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:36','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','MMP','d29de92a-c8c9-4e61-bbe5-8be1332c80f0')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:37 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202396,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:36','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:36','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','GLD','0a52cb4c-2074-424e-b1ce-1d8331bd9336')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:37 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202397,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:37','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:37','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','CMC','e03a82f5-25d3-41e6-8031-3404ec926bf5')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:38 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202398,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:37','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:37','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','MXP','c36cda18-e09b-4431-99c3-9c7114eaf48f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:38 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202399,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:38','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:38','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','ARF','67024e0f-68e9-4167-934b-bdf94963251c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:39 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202400,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:38','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:38','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','CMB','b17a7112-76d5-41a8-ba8d-f5cda9c05fc0')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:39 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202401,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:39','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:39','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','API','dbc86ba7-cfb1-428c-9387-a27e0dc9db87')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:39 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202402,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:39','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:39','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','APC','f416dfc7-8f9a-49a6-9edb-e7d8438fded6')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:40 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202403,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:39','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:39','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','GLJ','127b56cd-98c3-4475-b282-d93a69fd119b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:40 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202404,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:40','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:40','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','ARI','5e58d636-1340-41d4-b49b-8bfbc4a5dd2c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:41 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202405,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:40','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:40','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','ARC','453d1e8e-069a-402f-b616-2e1ff63109b5')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:41 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202406,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:41','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:41','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','ARR','d34bb50a-40fd-456a-8283-d0dc64c1fbf4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:41 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202407,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:41','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:41','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','APP','cdb6e18a-b968-4cb6-acb8-afd9363a7020')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:42 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202408,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:41','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:41','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','SOO','8db455bc-5f31-4c61-9cf1-c8746bb911f7')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:42 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202409,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:42','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:42','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','POO','3656b18b-8f6c-4dc0-8a4f-761ee796dec0')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:42 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202410,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:42','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:42','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','HRP','f88e330c-c35b-4ef7-8f9b-aebde1f9d47a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:43 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202411,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:42','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:42','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','MOP','7bc40ab4-4ac9-43af-afce-a9e982ecf9eb')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:43 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202412,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:43','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:43','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','MMR','fba3391f-006e-457b-8dc3-aabbc47961eb')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:44 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202413,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:43','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:43','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','MQO','2cd49de5-ee63-439f-8c1f-628f484cbe23')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:44 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202414,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:44','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:44','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','DOO','b9ab4f88-52f4-420a-86ef-696dd5d321c4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:45 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202415,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:44','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:44','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','CMA','ee4be494-d236-4d28-ace6-d75a2325735d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:45 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202416,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:45','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:45','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','MMM','c7b75202-fb75-4134-b891-1a583ac40d43')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:45 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202417,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:45','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:45','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','POR','ab858fb9-fbfe-465f-a234-8c418a208a27')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:46 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202418,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:45','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:45','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','MOF','00f9999c-3c07-4544-8f45-3a1a1d491fde')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:46 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202419,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:46','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:46','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','MCC','5a16ba6d-423a-4c23-864a-8d7b80882b01')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:46 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202420,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:46','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:46','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','MMI','a3ce1f84-b5ef-4dea-8849-358905a0c2d4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:47 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202421,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:46','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:46','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','FAA','3c11d527-779e-4023-b2ed-49b7dd80079f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:48 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202422,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:47','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:47','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','FDP','4b1993fa-d8e6-487a-8ee3-3a03220ece8a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:48 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202423,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:48','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:48','YYYY-MM-DD HH24:MI:SS'),100,200077,'N','N','N','FAD','fcc07d61-9213-4618-b001-89b4155465b3')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:49 PM CET
|
|
INSERT INTO C_Period (Name,StartDate,C_Period_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,PeriodNo,C_Year_ID,PeriodType,EndDate,Processing,C_Period_UU) VALUES ('Jul-18',TO_TIMESTAMP('2018-07-01','YYYY-MM-DD'),200078,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:48','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:48','YYYY-MM-DD HH24:MI:SS'),100,7,200006,'S',TO_TIMESTAMP('2018-07-31','YYYY-MM-DD'),'N','64641829-1a63-4c01-aa68-0d805a726176')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:49 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202424,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:49','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:49','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','MMS','5598d5f3-f05d-4d79-ac1e-35ce18e51b0d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:49 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202425,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:49','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:49','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','PJI','1b72c676-a927-4f8e-8363-9ab08c645778')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:50 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202426,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:49','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:49','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','MXI','87afcd08-127b-4c90-a959-7aa6253c8d80')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:50 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202427,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:50','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:50','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','MMP','d85a78c9-e210-44f3-93da-2867094708e9')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:51 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202428,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:50','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:50','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','GLD','5ab09dc9-1985-42a3-a51a-450399938221')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:51 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202429,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:51','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:51','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','CMC','ce0c59e4-2f65-4217-9d5e-d30329fc0ebd')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:51 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202430,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:51','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:51','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','MXP','81d1c8f5-e8ce-47a6-a2c6-99f68e1f3e20')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:52 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202431,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:51','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:51','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','ARF','79a05441-0820-4b1a-83b8-a8d80e361764')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:52 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202432,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:52','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:52','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','CMB','dd5d3dbe-78e2-4f10-9c4e-0ba6fbe6120b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:53 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202433,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:52','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:52','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','API','74c960f2-46db-4ea4-b1ce-734cce8cd50b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:53 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202434,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:53','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:53','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','APC','098b5076-e552-4f86-ad7a-965e9e06d283')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:53 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202435,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:53','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:53','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','GLJ','fe4d0796-5932-4f3b-bacb-e49b0d3340d3')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:54 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202436,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:53','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:53','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','ARI','1d629c5c-38c1-4ecd-acaa-952bd11b1ead')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:54 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202437,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:54','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:54','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','ARC','9718fca3-bfe7-4f40-b78c-ecdba781340f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:55 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202438,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:54','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:54','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','ARR','03b7f11d-0810-4825-a97b-e1deff1a7bac')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:55 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202439,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:55','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:55','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','APP','26320dc6-b51f-40bd-9757-fd2c0994fa42')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:55 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202440,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:55','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:55','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','SOO','e9a364ed-9f1b-4aa0-8347-f116dec210fa')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:56 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202441,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:55','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:55','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','POO','9131a2f5-4bff-487f-bc26-7b5693f7457e')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:56 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202442,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:56','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:56','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','HRP','dcd1c93c-ffca-49e1-8ca3-252c239697e2')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:57 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202443,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:56','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:56','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','MOP','c99ad5a1-a8c0-47bd-8bdf-8b3cc9c9cb1b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:57 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202444,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:57','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:57','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','MMR','a63f959f-63b9-4252-994b-c9956b10dba6')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:57 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202445,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:57','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:57','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','MQO','292cd194-e7fd-4201-bbca-5ba648d7b1b4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:58 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202446,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:57','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:57','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','DOO','42ba922c-bc2f-473c-a676-efbd39f8ca62')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:58 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202447,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:58','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:58','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','CMA','34daeb3b-6a46-48f2-a182-8d3465017b17')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:59 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202448,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:58','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:58','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','MMM','c63bb7a1-8187-40bc-b360-9bc889310b07')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:59 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202449,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:59','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:59','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','POR','5707b37e-c49b-4c3c-a34f-06827b12dc27')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:36:59 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202450,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:59','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:59','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','MOF','00abbabb-347a-4fb2-ba85-4a093a072c02')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:00 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202451,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:36:59','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:36:59','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','MCC','01023ae2-821f-4487-8f4b-fb97b4ee9083')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:00 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202452,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:00','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:00','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','MMI','8e6d65a7-a985-4058-995b-d0c0c072fefe')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:00 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202453,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:00','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:00','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','FAA','b81f64cc-2673-445b-9b5f-9f6e0a90a26f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:01 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202454,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:00','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:00','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','FDP','244dd0cf-507e-4dfd-ae0f-ba3addba0779')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:01 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202455,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:01','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:01','YYYY-MM-DD HH24:MI:SS'),100,200078,'N','N','N','FAD','b585852a-0da7-4d3a-adb2-155c5409eb4b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:02 PM CET
|
|
INSERT INTO C_Period (Name,StartDate,C_Period_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,PeriodNo,C_Year_ID,PeriodType,EndDate,Processing,C_Period_UU) VALUES ('Aug-18',TO_TIMESTAMP('2018-08-01','YYYY-MM-DD'),200079,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:01','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:01','YYYY-MM-DD HH24:MI:SS'),100,8,200006,'S',TO_TIMESTAMP('2018-08-31','YYYY-MM-DD'),'N','4063edda-fbf0-4d8a-9ec0-b990b85e4a87')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:02 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202456,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:02','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:02','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','MMS','8c7fde0a-f5cb-4fa3-bb10-687b38743a44')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:02 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202457,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:02','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:02','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','PJI','8c6e94e4-60a9-4969-9121-53db9b9e94b5')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:03 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202458,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:02','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:02','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','MXI','b8e6f4ad-afd9-4ee6-a2eb-39ddc1d45095')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:03 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202459,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:03','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:03','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','MMP','37481c6f-4479-476d-b934-2fb30a9b615d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:04 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202460,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:03','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:03','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','GLD','22f2445a-41a0-484e-9a18-110a304a56f9')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:04 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202461,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:04','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:04','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','CMC','af3dd15f-b0f4-490b-b97f-40c1b0b462b3')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:04 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202462,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:04','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:04','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','MXP','0a691e08-ae43-4143-bc64-5843252fb242')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:05 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202463,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:04','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:04','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','ARF','69d8482e-ea31-44d6-9b12-b86460990e52')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:06 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202464,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:05','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:05','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','CMB','982beb52-64ef-4a3d-8a5d-286d8b9d1f68')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:06 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202465,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:06','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:06','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','API','860bb756-f272-480c-8ed4-378586f32940')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:07 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202466,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:06','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:06','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','APC','a843ab17-899a-4c2b-bc39-21ef3e1dcf1c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:07 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202467,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:07','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:07','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','GLJ','3ff9549b-13d6-4c64-b793-8ae75fe22490')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:08 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202468,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:07','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:07','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','ARI','f080a443-56c0-4e21-a875-3d5a2ae9ecd7')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:08 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202469,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:08','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:08','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','ARC','99448c6f-7c5f-4cf3-bb89-96652294f07c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:09 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202470,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:08','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:08','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','ARR','0e3df0a6-017a-4844-b470-7f2193f70b96')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:09 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202471,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:09','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:09','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','APP','58341a12-ceec-4f9a-8bbd-9ac6b3bac698')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:09 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202472,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:09','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:09','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','SOO','34955b19-70d9-483f-aff0-aa42ffa1e1d6')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:10 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202473,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:09','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:09','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','POO','bd956da6-8e75-447c-9d36-9c89f780e83f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:10 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202474,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:10','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:10','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','HRP','644b5a02-cb13-4a3a-be5b-93cdd8a63921')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:11 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202475,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:10','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:10','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','MOP','042744c9-3386-4a2d-9bee-bece6cd23a54')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:11 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202476,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:11','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:11','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','MMR','f108dfc7-43a6-403c-a99c-7bd1ea7988d3')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:12 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202477,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:11','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:11','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','MQO','ac428a7b-6c28-4035-8587-83873fc90be2')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:13 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202478,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:12','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:12','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','DOO','48fb9fe3-7da7-40fe-a960-03ddee56d1a4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:13 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202479,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:13','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:13','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','CMA','cd6bd91c-b3c6-438a-b023-33b8fd8b5634')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:14 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202480,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:13','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:13','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','MMM','078f7d22-51ff-4d5c-a6da-eff9e00c95d1')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:14 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202481,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:14','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:14','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','POR','cedc5828-b813-4242-a5e7-95cbc2d5a70d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:15 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202482,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:14','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:14','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','MOF','2a97d2df-7a84-4aa5-aff3-5320edc108bb')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:15 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202483,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:15','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:15','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','MCC','a573822f-16f0-48e7-af3a-5a0da0882cd3')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:15 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202484,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:15','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:15','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','MMI','22202818-752b-470a-9558-9da88efd505f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:16 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202485,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:15','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:15','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','FAA','d03305b3-6586-4299-8197-d941837ab66a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:17 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202486,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:16','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:16','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','FDP','5112bebb-8cde-411d-9ee2-f893f4634faa')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:17 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202487,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:17','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:17','YYYY-MM-DD HH24:MI:SS'),100,200079,'N','N','N','FAD','b46c54cc-3167-49fe-a48a-82baf80ee7b9')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:17 PM CET
|
|
INSERT INTO C_Period (Name,StartDate,C_Period_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,PeriodNo,C_Year_ID,PeriodType,EndDate,Processing,C_Period_UU) VALUES ('Sep-18',TO_TIMESTAMP('2018-09-01','YYYY-MM-DD'),200080,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:17','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:17','YYYY-MM-DD HH24:MI:SS'),100,9,200006,'S',TO_TIMESTAMP('2018-09-30','YYYY-MM-DD'),'N','ef432fcf-f289-4c13-bd44-05f71af7b9c2')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:18 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202488,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:17','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:17','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','MMS','96fc80dc-a419-4852-b744-63b0811046cd')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:18 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202489,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:18','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:18','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','PJI','b9f48c75-80ad-4e81-85f5-99dfb3189580')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:19 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202490,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:18','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:18','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','MXI','71f17226-b918-4a90-90f3-4083d8cd8c7b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:19 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202491,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:19','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:19','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','MMP','3bbf1727-b731-45dd-88ba-f9cc14776b5e')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:19 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202492,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:19','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:19','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','GLD','39c349de-191b-472f-bbda-13af4265464a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:20 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202493,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:19','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:19','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','CMC','4bde0e84-db2d-45e0-85b9-ff8206e9e8ec')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:20 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202494,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:20','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:20','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','MXP','6911386c-b1a1-47af-a9bc-3aea13a3da68')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:20 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202495,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:20','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:20','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','ARF','4cfbbe86-6cb9-4f7d-bad3-f689624af81d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:21 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202496,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:20','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:20','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','CMB','78f753d7-89f2-4cef-8249-e74942e4dfaf')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:21 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202497,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:21','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:21','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','API','e39fbf93-e6be-4605-965f-4fa2a8a831dc')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:22 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202498,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:21','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:21','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','APC','e40a9355-a5d2-46f7-8196-70981e3bef33')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:22 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202499,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:22','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:22','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','GLJ','fc3f9e42-6676-49b3-bbd2-2a8c62264b8d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:22 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202500,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:22','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:22','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','ARI','3f8452f6-5b21-4885-abcb-daa7a5053d27')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:23 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202501,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:22','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:22','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','ARC','e593119d-7ced-4e54-a7ae-c6630a553ca0')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:23 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202502,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:23','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:23','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','ARR','66e6dc48-425d-44ba-aec4-8869845e2392')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:24 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202503,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:23','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:23','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','APP','90a25687-c6a6-42bc-b005-5557b1d4449c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:25 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202504,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:24','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:24','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','SOO','91d3030c-3e31-4e7a-9bd5-e560bb1eb9d0')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:25 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202505,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:25','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:25','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','POO','e1165d02-b3d7-4a3b-8037-ca7ca362e4f4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:26 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202506,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:25','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:25','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','HRP','c67a4f3d-4470-42ca-8d61-cfff68e52537')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:26 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202507,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:26','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:26','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','MOP','65d6f109-3ace-4589-96f0-539601cd460f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:26 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202508,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:26','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:26','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','MMR','e486aac6-5539-4e96-86f4-cc932559410f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:27 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202509,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:26','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:26','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','MQO','061af348-d84c-4a5c-891b-c25e1cfb84d1')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:27 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202510,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:27','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:27','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','DOO','6c2e589b-c666-4988-bd33-9f419219f234')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:27 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202511,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:27','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:27','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','CMA','959fdd51-20fc-4332-bd05-ab9cdf92151b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:28 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202512,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:28','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:28','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','MMM','cb58c10e-7d5e-4365-b7e0-84494675ffe2')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:28 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202513,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:28','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:28','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','POR','a8793ddf-eb2b-44de-bc05-ff6e885b1c56')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:29 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202514,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:28','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:28','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','MOF','993a792a-d2eb-453c-8a77-a1712e533e3c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:29 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202515,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:29','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:29','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','MCC','a24059fb-bff7-4846-92c8-3dde342f072d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:29 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202516,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:29','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:29','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','MMI','478ab31c-aec1-41ee-b4b3-e63d31859612')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:30 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202517,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:29','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:29','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','FAA','03633098-bd6e-4d30-a9c3-aac622669fd2')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:30 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202518,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:30','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:30','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','FDP','e9ea20e3-a3d0-417b-941b-85d141b17149')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:31 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202519,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:30','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:30','YYYY-MM-DD HH24:MI:SS'),100,200080,'N','N','N','FAD','b39ca427-4992-47b7-bedb-656ee5b017d2')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:31 PM CET
|
|
INSERT INTO C_Period (Name,StartDate,C_Period_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,PeriodNo,C_Year_ID,PeriodType,EndDate,Processing,C_Period_UU) VALUES ('Oct-18',TO_TIMESTAMP('2018-10-01','YYYY-MM-DD'),200081,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:31','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:31','YYYY-MM-DD HH24:MI:SS'),100,10,200006,'S',TO_TIMESTAMP('2018-10-31','YYYY-MM-DD'),'N','b21155e1-0de2-4f4a-a203-6af6271bc804')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:32 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202520,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:31','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:31','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','MMS','047bf3ef-390d-40bb-bd97-db8a525af4b9')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:32 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202521,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:32','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:32','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','PJI','67519ea5-a695-456c-8cc0-4b83d2d96100')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:32 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202522,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:32','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:32','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','MXI','6e451829-e51b-47c3-bc05-fc297e5e1efa')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:33 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202523,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:32','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:32','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','MMP','672f4b71-879e-4cfe-9b6d-807517a0e1ed')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:33 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202524,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:33','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:33','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','GLD','4a231ed7-6313-4408-b224-fa58fbe90ded')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:33 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202525,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:33','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:33','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','CMC','71e96148-3796-4b2e-a140-7bdf5b44465c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:34 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202526,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:33','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:33','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','MXP','c536b04d-b28f-4a0c-9f3d-a468c429ab58')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:34 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202527,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:34','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:34','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','ARF','dcc85d4f-1d93-4826-8245-d65e4feec936')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:34 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202528,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:34','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:34','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','CMB','a93a438c-184d-4d65-a88c-563fa2bee3bf')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:35 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202529,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:34','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:34','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','API','1b7634cf-168b-48d9-9383-b141ec3dd19e')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:35 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202530,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:35','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:35','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','APC','ec70c319-efa2-413f-9052-644e59332e4d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:35 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202531,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:35','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:35','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','GLJ','b0da28b1-4adf-41c2-96d5-7a26eca970f9')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:36 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202532,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:35','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:35','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','ARI','7baf30e3-c4f8-4e11-aa62-bc432785cd53')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:36 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202533,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:36','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:36','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','ARC','8c0c571c-8f25-4eb5-b5e1-d5a823c14a05')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:37 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202534,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:36','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:36','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','ARR','493463fa-0a6b-4cd0-8658-af58c1003ad7')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:37 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202535,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:37','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:37','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','APP','b8f14764-4b85-4e11-8b2d-54ec6fb830b0')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:37 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202536,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:37','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:37','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','SOO','17144fad-552b-4805-bddb-3d5ca50e423b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:38 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202537,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:37','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:37','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','POO','f304bbef-d4c5-4a2d-b1ec-c0c1878b19c5')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:38 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202538,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:38','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:38','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','HRP','dee18805-a05a-43c3-9dbc-488c3e758917')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:38 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202539,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:38','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:38','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','MOP','8df82fbe-7bca-4888-8472-a4c4db5ffb9a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:39 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202540,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:38','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:38','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','MMR','1ebd9ee5-ae87-416f-a3a6-592485b9bd4e')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:39 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202541,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:39','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:39','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','MQO','6a62ed95-e238-43bf-89dc-120fd2facb71')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:40 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202542,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:39','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:39','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','DOO','f0874630-3b8b-4d84-89d2-b1626b9fc10d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:40 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202543,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:40','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:40','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','CMA','eebf00e4-31cd-4d20-b921-0915c7ffd47b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:40 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202544,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:40','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:40','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','MMM','c70f6c72-ab1f-48d3-ab3e-bc7d0439c66b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:41 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202545,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:40','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:40','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','POR','87f2adeb-3244-4ca0-88fe-b76be9cbd2f5')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:41 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202546,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:41','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:41','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','MOF','880bd4fb-071e-437b-81ca-f067f8b43bb8')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:41 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202547,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:41','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:41','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','MCC','b6c679e2-8e59-4f92-9b8e-519594c04a9d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:42 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202548,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:41','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:41','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','MMI','9df796d3-2224-4824-b7a0-04d66fccf2fe')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:42 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202549,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:42','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:42','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','FAA','66480b39-d53a-49cc-94a7-d387f49f354d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:43 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202550,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:42','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:42','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','FDP','5c4575b3-8e00-4b20-9dc9-3c948f9249ff')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:43 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202551,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:43','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:43','YYYY-MM-DD HH24:MI:SS'),100,200081,'N','N','N','FAD','7a66f3c5-15b4-4af3-9d7f-7c9f4349e92d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:43 PM CET
|
|
INSERT INTO C_Period (Name,StartDate,C_Period_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,PeriodNo,C_Year_ID,PeriodType,EndDate,Processing,C_Period_UU) VALUES ('Nov-18',TO_TIMESTAMP('2018-11-01','YYYY-MM-DD'),200082,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:43','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:43','YYYY-MM-DD HH24:MI:SS'),100,11,200006,'S',TO_TIMESTAMP('2018-11-30','YYYY-MM-DD'),'N','0c3d46bb-5d00-4d0b-a8b0-b28585e4c0d1')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:44 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202552,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:43','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:43','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','MMS','f0931964-f41b-4aeb-b96d-683eef18f707')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:44 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202553,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:44','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:44','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','PJI','52343a0a-d1c1-4a6c-9c4c-41ffb6381a28')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:44 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202554,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:44','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:44','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','MXI','da8be7f4-b49e-4d2b-b9b3-616480508854')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:45 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202555,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:44','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:44','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','MMP','8867274e-00dc-4905-83bf-9cf1c1eef07c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:45 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202556,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:45','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:45','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','GLD','2302c1be-ee42-42c7-b43f-93384a071528')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:45 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202557,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:45','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:45','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','CMC','539ac53e-71d6-4408-88b6-48e43c3ebc8b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:46 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202558,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:45','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:45','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','MXP','0d103f38-4cc0-4188-b8bb-9900b14800de')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:46 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202559,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:46','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:46','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','ARF','cd3078ec-602b-4c6e-98c1-3798e8c17dde')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:47 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202560,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:46','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:46','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','CMB','874a1b30-c530-4eb1-a680-a6c75ef6b32a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:47 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202561,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:47','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:47','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','API','6807a6f0-2f7b-43c5-a4cb-e4542a280245')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:47 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202562,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:47','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:47','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','APC','16fd5273-108f-41fd-b2cc-8b052ec4dc50')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:48 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202563,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:47','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:47','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','GLJ','0d46039d-3360-4176-87cf-df2c73b2f6f8')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:48 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202564,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:48','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:48','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','ARI','490befc7-4c89-4e9b-b5cc-a77e955fae30')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:48 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202565,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:48','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:48','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','ARC','ce322447-b7e4-42e8-a983-1f106a5421fc')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:49 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202566,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:48','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:48','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','ARR','120c746e-9154-4fa8-bfe3-42190a856680')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:49 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202567,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:49','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:49','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','APP','16a84716-12b1-4a2b-967d-c116e006ca24')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:50 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202568,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:49','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:49','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','SOO','afa1ba23-3c2b-4e10-a702-72cbfb6c3a89')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:50 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202569,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:50','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:50','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','POO','813ceaa1-4517-4728-903d-d52f7dbfc40d')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:50 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202570,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:50','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:50','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','HRP','c3ee799a-4cd3-41ad-ae6c-74ed3b414b48')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:51 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202571,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:50','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:50','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','MOP','56a868c7-6c49-49a9-86a7-ace3c98fb346')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:51 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202572,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:51','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:51','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','MMR','f099f172-da4e-4bb3-b496-123a8caab140')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:52 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202573,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:51','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:51','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','MQO','6a2548fa-94cd-474b-bab6-89b443f2257c')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:52 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202574,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:52','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:52','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','DOO','e3724dea-8b53-496b-aece-5aec361f7017')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:52 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202575,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:52','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:52','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','CMA','b9f0a0a6-ec28-41f2-87d6-56059b5c8c73')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:54 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202576,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:52','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:52','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','MMM','1412491d-d7ae-4317-8675-ec25a35c0390')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:54 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202577,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:54','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:54','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','POR','3ca28fc3-555e-40f7-abfb-6acebe99a0fc')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:54 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202578,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:54','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:54','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','MOF','c29118d7-aece-4e08-86b5-05ae11c71ab8')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:55 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202579,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:54','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:54','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','MCC','15f921a3-6579-43b6-8cdf-f039e86d3d4e')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:55 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202580,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:55','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:55','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','MMI','e1dfeabe-2665-4a04-8315-d8efbabcb1d8')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:55 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202581,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:55','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:55','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','FAA','92ea312b-73f0-4155-9461-010ad084db77')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:56 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202582,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:56','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:56','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','FDP','a7c42be4-30d5-4ce8-b091-71ce835007dd')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:56 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202583,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:56','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:56','YYYY-MM-DD HH24:MI:SS'),100,200082,'N','N','N','FAD','4681fa8d-71b5-4aa8-b1a8-6753a17c5230')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:57 PM CET
|
|
INSERT INTO C_Period (Name,StartDate,C_Period_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,PeriodNo,C_Year_ID,PeriodType,EndDate,Processing,C_Period_UU) VALUES ('Dec-18',TO_TIMESTAMP('2018-12-01','YYYY-MM-DD'),200083,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:56','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:56','YYYY-MM-DD HH24:MI:SS'),100,12,200006,'S',TO_TIMESTAMP('2018-12-31','YYYY-MM-DD'),'N','bdd34a91-0cbb-4348-bc9e-7da2c2146bdd')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:57 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202584,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:57','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:57','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','MMS','c704ac07-2c52-452e-bd68-8d9c532e1853')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:57 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202585,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:57','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:57','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','PJI','4a327202-fd89-4e94-8347-623bb36ee610')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:58 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202586,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:57','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:57','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','MXI','2e3b51b0-ce18-4455-9791-5f56e012f9eb')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:58 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202587,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:58','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:58','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','MMP','b3d65490-b914-448b-a452-c0c9d446f965')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:59 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202588,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:58','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:58','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','GLD','8c3d8053-85d8-4f72-b777-88ee85604473')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:59 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202589,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:59','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:59','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','CMC','ed808c4a-2543-4973-b041-9f42b5eb2dd5')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:37:59 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202590,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:59','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:59','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','MXP','b692b110-39b0-46d0-91ff-27f891598785')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:00 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202591,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:37:59','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:37:59','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','ARF','f7e87bc1-dfea-493b-a87a-6b7e21206b23')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:00 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202592,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:00','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:00','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','CMB','9afa61bd-99cd-4abd-9dd4-4300bfc325a9')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:00 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202593,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:00','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:00','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','API','8e0a4adf-ed56-4412-9392-3685952b8bf6')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:01 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202594,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:00','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:00','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','APC','d6af773a-a8b5-46ed-9797-fe024f75e8eb')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:01 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202595,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:01','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:01','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','GLJ','a9ed2a3b-cf66-4ea0-9e08-bc7817e218a0')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:01 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202596,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:01','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:01','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','ARI','993ca972-df5b-464e-8732-ba433b13fc7e')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:02 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202597,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:01','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:01','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','ARC','46aca21d-7764-4765-b49a-5969a48dd62f')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:02 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202598,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:02','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:02','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','ARR','97ab9a12-a4d1-406e-95b2-aa97ef05919a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:02 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202599,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:02','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:02','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','APP','0998b3a5-cc9b-46f0-bc91-fd142ff48d85')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:03 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202600,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:02','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:02','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','SOO','e0df2e54-6e59-4290-af92-c626076f790b')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:03 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202601,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:03','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:03','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','POO','cd07c19b-d1a8-4321-9223-8a23404c1211')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:04 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202602,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:03','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:03','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','HRP','e0465bf9-1baf-4cab-b16f-c31a4a0cb2f0')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:04 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202603,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:04','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:04','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','MOP','a11430fe-00dd-4a89-91b1-42a47845cb29')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:04 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202604,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:04','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:04','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','MMR','d81f407c-3081-4636-a5c2-2ab7b9491779')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:05 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202605,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:04','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:04','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','MQO','9c16c549-dcd3-48f0-a6e6-f78758a24787')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:05 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202606,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:05','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:05','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','DOO','d3aa7772-832a-442c-89a1-f78a21fac957')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:05 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202607,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:05','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:05','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','CMA','fda2ac5b-e628-41b3-847b-96a38a0481ca')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:06 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202608,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:05','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:05','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','MMM','d447b126-7a48-444e-9512-6c2fa0ffb2d5')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:06 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202609,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:06','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:06','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','POR','cf272cb2-3351-4f3d-bdd0-8fc7525154c8')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:07 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202610,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:06','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:06','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','MOF','74cf4fc8-92de-4aa8-a6f7-5d9ddee016c5')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:07 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202611,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:07','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:07','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','MCC','21cd1a70-1521-4d2b-a4b4-0646f3d97700')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:07 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202612,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:07','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:07','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','MMI','2577fa96-afb6-4add-b115-f06fd52c65b4')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:08 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202613,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:07','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:07','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','FAA','34ef8e7a-fb65-43f3-afc5-1639017ff767')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:08 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202614,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:08','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:08','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','FDP','18efb45c-cbb4-4de1-8c7e-3005f343468a')
|
|
;
|
|
|
|
-- Oct 31, 2017 9:38:09 PM CET
|
|
INSERT INTO C_PeriodControl (C_PeriodControl_ID,AD_Client_ID,AD_Org_ID,IsActive,Created,CreatedBy,Updated,UpdatedBy,C_Period_ID,PeriodStatus,PeriodAction,Processing,DocBaseType,C_PeriodControl_UU) VALUES (202615,11,0,'Y',TO_TIMESTAMP('2017-10-31 21:38:08','YYYY-MM-DD HH24:MI:SS'),100,TO_TIMESTAMP('2017-10-31 21:38:08','YYYY-MM-DD HH24:MI:SS'),100,200083,'N','N','N','FAD','4b006842-6243-4230-863a-d6c9ca63dab6')
|
|
;
|
|
|
|
SELECT register_migration_script('201710312138_Generate2018GardenWorld.sql') FROM dual
|
|
;
|
|
|