create table b2c_invdetails (
    id int not null PRIMARY KEY AUTO_INCREMENT,
    inv_no varchar(50) not null UNIQUE,
    inv_date varchar(50) not null,
    inv_mot varchar(50), //
    inv_pos varchar(50), //
    inv_sc  varchar(25), //
    inv_top_desc varchar(100),
    inv_btm_desc varchar(200),
    inv_tax_desc varchar(100),
    inv_btm_decl varchar(200),
    inv_btm_place varchar(100),
    inv_btm_date varchar(25),
    extra varchar(50),      //
    extra1 varchar(50),     //
    status int not null     //
)

create table b2c_products (
    id int not null PRIMARY KEY AUTO_INCREMENT,  
    inv_no not null, 
    inv_product_desc varchar(200),
    inv_product_Hsn varchar(10),
    inv_product_Qty varchar(20),
    inv_product_Price varchar(25),
    inv_product_cgst varchar(25),
    inv_product_sgst varchar(25),
    inv_product_igst varchar(25),
    inv_ptoduct_total varchar(50),
    extra varchar(50),
    status int 
)

create table b2c_billedto (
    id int not null PRIMARY KEY AUTO_INCREMENT,   
    inv_no varchar(200),
    consignee_name varchar(25),
    consignee_Addr1 varchar(20),
    consignee_Addr2 varchar(25),
    consignee_Addr3 varchar(25),
    consignee_Addr4 varchar(25),
    gstin varchar(25),
    pan varchar(20),
    extra varchar(50),
    status int not null
)