drop table system_data;

CREATE TABLE system_data (
    mancode character varying(3),
    mcode character varying(3),
    billnum character varying(75) NOT NULL,
    distcode character varying(75),
    servno character varying(75),
    billdate character varying(30),
    paydate timestamp without time zone,
    amount character varying(75),
    cycle character(2),
    acd character varying(75),
    sbmno character varying(75),
    rcfee character varying(75),
    slabtype numeric(1,0),
    chk_server numeric(1,0),
    bnum1 character varying(75)
);