CREATE TABLE `rooms101_rtsdev`.`tbl_hotel_billing`  (
                                               `id` int(0) NOT NULL AUTO_INCREMENT,
                                               `batch_id` int(0) NOT NULL,
                                               `salesIds` json NULL,
                                               `property_id` int(0) NULL,
                                               `check_num` varchar(40) NULL,
                                               `costs` decimal(8, 2) NULL,
                                               `addon_costs` decimal(8, 2) NULL,
                                               `promo_costs` decimal(8, 2) NULL,
                                               `ticket_costs` decimal(8, 2) NULL,
                                               `tax` decimal(8, 2) NULL,
                                               `credits` decimal(8,2) NULL,
                                               `grandtotal` decimal(8, 2) NULL,
                                               `post_date` datetime(0) NULL,
                                               `create_date` datetime(0) NULL,
                                               `post_by` varchar(40) NULL,
                                               `comments` varchar(255) NULL,
                                               PRIMARY KEY (`id`),
                                               INDEX `batchIdx`(`batch_id`) USING BTREE
);
