INSERT INTO c0000000.hm_msy032 (id, hm_msy012_trx_id, combination_seq_number, combination_condition, version, user_create, creation_time, user_modify, modification_time) SELECT sys_guid(), 'public.sys_guid()', 1, 'true', 0, 'SofcoGraha', current_timestamp, 'SofcoGraha', current_timestamp;

INSERT INTO c0000000.hm_msy033 (id, hm_msy032_auto_number_id, component_seq_number, component, component_type, component_length, component_format, version, user_create, creation_time, user_modify, modification_time) SELECT sys_guid(), a.id, 1, 'SuratPeringatan', 'Constant', 15, null, 0, 'sofco', current_timestamp, 'sofco', current_timestamp FROM c0000000.hm_msy032 a WHERE a.combination_seq_number = 1 AND a.hm_msy012_trx_id = 'public.sys_guid()';
INSERT INTO c0000000.hm_msy033 (id, hm_msy032_auto_number_id, component_seq_number, component, component_type, component_length, component_format, version, user_create, creation_time, user_modify, modification_time) SELECT sys_guid(), a.id, 2, '/', 'Constant', 1, null, 0, 'sofco', current_timestamp, 'sofco', current_timestamp FROM c0000000.hm_msy032 a WHERE a.combination_seq_number = 1 AND a.hm_msy012_trx_id = 'public.sys_guid()';
INSERT INTO c0000000.hm_msy033 (id, hm_msy032_auto_number_id, component_seq_number, component, component_type, component_length, component_format, version, user_create, creation_time, user_modify, modification_time) SELECT sys_guid(), a.id, 3, 'date', 'DateVariable', 4, 'FourDigitYear', 0, 'sofco', current_timestamp, 'sofco', current_timestamp FROM c0000000.hm_msy032 a WHERE a.combination_seq_number = 1 AND a.hm_msy012_trx_id = 'public.sys_guid()';
INSERT INTO c0000000.hm_msy033 (id, hm_msy032_auto_number_id, component_seq_number, component, component_type, component_length, component_format, version, user_create, creation_time, user_modify, modification_time) SELECT sys_guid(), a.id, 4, '-', 'Constant', 1, null, 0, 'sofco', current_timestamp, 'sofco', current_timestamp FROM c0000000.hm_msy032 a WHERE a.combination_seq_number = 1 AND a.hm_msy012_trx_id = 'public.sys_guid()';
INSERT INTO c0000000.hm_msy033 (id, hm_msy032_auto_number_id, component_seq_number, component, component_type, component_length, component_format, version, user_create, creation_time, user_modify, modification_time) SELECT sys_guid(), a.id, 5, '', 'Counter', 4, null, 0, 'sofco', current_timestamp, 'sofco', current_timestamp FROM c0000000.hm_msy032 a WHERE a.combination_seq_number = 1 AND a.hm_msy012_trx_id = 'public.sys_guid()';

INSERT INTO c0000000.hm_msy034 (id, hm_msy033_auto_num_det_id, component_seq_number, component, component_format, version, user_create, creation_time, user_modify, modification_time) SELECT sys_guid(), a.id, 1, 'date', 'FourDigitYear', 0, 'sofco', current_timestamp, 'sofco', current_timestamp FROM c0000000.hm_msy033 a INNER JOIN c0000000.hm_msy032 b ON a.hm_msy032_auto_number_id = b.id WHERE a.component_seq_number =  AND b.combination_seq_number =  AND b.hm_msy012_trx_id = '';