001_init_t_task_modify_journal_formula

DELETE FROM t_task WHERE task_type = 'GL' AND task_group IN ('gl.journalformula');


INSERT INTO t_task(
    module_id, task_code, task_name, description,
    task_type, task_group, create_datetime, create_user_id,
    update_datetime, update_user_id, "version", active,
    active_datetime, non_active_datetime, always_allow)
VALUES

    (106,'ADD JOURNAL FORMULA RECURRING','addJournalFormulaRecurring','Add Journal Formula Recurring',
    'GL','gl.journalformula','20160107110000',-1,
    '20160107110000',-1,0,'Y',
    '20160107110000',' ','N' ),

    (106,'ADD JOURNAL FORMULA ALLOCATION','addJournalFormulaAllocation','Add Journal Formula Allocation',
    'GL','gl.journalformula','20160107110000',-1,
    '20160107110000',-1,0,'Y',
    '20160107110000',' ','N' ),

    (106,'VIEW JOURNAL FORMULA','viewJournalFormula','View Journal Formula',
    'GL','gl.journalformula','20160107110000',-1,
    '20160107110000',-1,0,'Y',
    '20160107110000',' ','N' ),

    ( 106,'EDIT JOURNAL FORMULA RECURRING','editJournalFormulaRecurring','Edit Journal Formula Recurring',
    'GL','gl.journalformula','20160107110000',-1,
    '20160107110000',-1,0,'Y',
    '20160107110000',' ','N' ),

    ( 106,'EDIT JOURNAL FORMULA ALLOCATION','editJournalFormulaAllocation','Edit Journal Formula Allocation',
    'GL','gl.journalformula','20160107110000',-1,
    '20160107110000',-1,0,'Y',
    '20160107110000',' ','N' ),

    ( 106,'REMOVE JOURNAL FORMULA RECURRING','removeJournalFormulaRecurring','Remove Journal Formula Recurring',
    'GL','gl.journalformula','20160107110000',-1,
    '20160107110000',-1,0,'Y',
    '20160107110000',' ','N' ),

    ( 106,'REMOVE JOURNAL FORMULA ALLOCATION','removeJournalFormulaAllocation','Remove Journal Formula Allocation',
    'GL','gl.journalformula','20160107110000',-1,
    '20160107110000',-1,0,'Y',
    '20160107110000',' ','N' );