Database Preparation

Create master table and master data at schema ERP_ONEWEB with below SQL. (PostgreSQL)

CREATE TABLE erp_oneweb.oneweb_benefit ( 
    id CHARACTER VARYING(20) NOT NULL, 
    travel_date TIMESTAMP(6) WITHOUT TIME ZONE, 
    project_name CHARACTER VARYING(200), 
    description CHARACTER VARYING(500), 
    amount NUMERIC(10,2), 
    status CHARACTER VARYING(20), 
    benefit_type CHARACTER VARYING(20), 
    create_by CHARACTER VARYING(100), 
    create_date TIMESTAMP(6) WITHOUT TIME ZONE, 
    update_by CHARACTER VARYING(100), 
    update_date TIMESTAMP(6) WITHOUT TIME ZONE, 
    username CHARACTER VARYING(100),
    
    CONSTRAINT oneweb_travel_alw_pkey PRIMARY KEY (id) 
);

CREATE sequence erp_oneweb.oneweb_benefit_seq 
START WITH 10 increment 
BY 10 no maxvalue no minvalue cache 20 no cycle;

INSERT INTO oneweb_benefit (id, travel_date, project_name, description, amount, status, benefit_type, create_by, create_date, update_by, update_date, username) 
VALUES ('1', '2019-07-06 15:41:38', 'AVA PROJECT', 'Taxi', 1000, 'Approved', 'Travel', null, null, null, null, 'Alisha');

INSERT INTO oneweb_benefit (id, travel_date, project_name, description, amount, status, benefit_type, create_by, create_date, update_by, update_date, username) 
VALUES ('2', '2019-07-06 15:41:38', 'AVA PROJECT', 'BTS', 500, 'Approved', 'Travel', null, null, null, null, 'Alisha');

INSERT INTO oneweb_benefit (id, travel_date, project_name, description, amount, status, benefit_type, create_by, create_date, update_by, update_date, username) 
VALUES ('4', '2019-07-06 15:42:54', 'AVA PROJECT', 'MRT', 200, 'Approved', 'Travel', null, null, null, null, 'Alisha');

INSERT INTO oneweb_benefit (id, travel_date, project_name, description, amount, status, benefit_type, create_by, create_date, update_by, update_date, username) 
VALUES ('5', '2019-07-06 15:42:55', 'AVA PROJECT', 'BRT', 400, 'Approved', 'Travel', null, null, null, null, 'Alisha');

INSERT INTO oneweb_benefit (id, travel_date, project_name, description, amount, status, benefit_type, create_by, create_date, update_by, update_date, username) 
VALUES ('6', '2019-07-06 15:42:57', 'AVA PROJECT', 'Taxi', 250, 'Approved', 'Travel', null, null, null, null, 'Alisha');