/*
 Navicat Premium Data Transfer

 Source Server         : kgte2022
 Source Server Type    : PostgreSQL
 Source Server Version : 90525
 Source Host           : localhost:5432
 Source Catalog        : kgte2022
 Source Schema         : KGTENOV2022

 Target Server Type    : PostgreSQL
 Target Server Version : 90525
 File Encoding         : 65001

 Date: 28/03/2023 17:20:50
*/


-- ----------------------------
-- Table structure for pg_transactions
-- ----------------------------
DROP TABLE IF EXISTS "KGTENOV2022"."pg_transactions";
CREATE TABLE "KGTENOV2022"."pg_transactions" (
  "id" int4 NOT NULL DEFAULT nextval('"KGTENOV2022".pg_transactions_seq'::regclass),
  "application_no" char(32) COLLATE "pg_catalog"."default" NOT NULL,
  "app_date" date NOT NULL,
  "amount" float8 NOT NULL,
  "transaction_no" varchar(255) COLLATE "pg_catalog"."default",
  "grn" varchar(150) COLLATE "pg_catalog"."default",
  "bank_reference_no" varchar(150) COLLATE "pg_catalog"."default",
  "cin" varchar(150) COLLATE "pg_catalog"."default",
  "challan_time_stamp" varchar(70) COLLATE "pg_catalog"."default",
  "bank_time_stamp" varchar(70) COLLATE "pg_catalog"."default",
  "bank_code" varchar(50) COLLATE "pg_catalog"."default",
  "payment_status" varchar(1) COLLATE "pg_catalog"."default",
  "party_name" varchar(200) COLLATE "pg_catalog"."default",
  "remarks" text COLLATE "pg_catalog"."default",
  "certificate_type" varchar(1) COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Records of pg_transactions
-- ----------------------------
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (1, '4JE45                           ', '2023-02-26', 10, '12', 'G', '1245', 'V', '2023-02-26', '2023-02-26', '56', 'Y', 'gggh', 'jj', 'k');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (2, '4JE45                           ', '2023-02-26', 10, '12', 'G', '1245', 'V', '2023-02-26', '2023-02-26', '56', 'Y', 'gggh', 'jj', 'k');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (3, '4JE45                           ', '2023-02-26', 10, '12', 'G', '1245', 'V', '2023-02-26', '2023-02-26', '56', 'Y', 'gggh', 'jj', 'k');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (4, 'RTE05                           ', '2023-02-28', 1, 'KGTE2022#RTE05#C#20230228826', 'KL000004162202223E', '83733232', '83733232', '2023-02-28 15:41:01.162704', '2023-02-28-15.41.16.000000', 'FPN ', 'N', 'DIYA                                                                       ', '', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (5, 'RTE05                           ', '2023-02-28', 1, 'KGTE2022#RTE05#C#20230228826', 'KL000004162202223E', '83733232', '83733232', '2023-02-28 15:41:01.162704', '2023-02-28-15.41.16.000000', 'FPN ', 'N', 'DIYA                                                                       ', '', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (6, 'RTE05                           ', '2023-02-28', 1, 'KGTE2022#RTE05#C#20230228826', 'KL000004162202223E', '83733232', '83733232', '2023-02-28 15:41:01.162704', '2023-02-28-15.41.16.000000', 'FPN ', 'N', 'DIYA                                                                       ', '', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (7, 'U4U3I                           ', '2023-02-28', 1, 'KGTE2022#U4U3I#C#20230228735', 'KL000004164202223E', '83735539', '83735539', '2023-02-28 16:02:27.205143', '2023-02-28-16.02.43.000000', 'FPN ', 'N', 'S                                                                          ', '', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (8, '1X9JT                           ', '2023-02-28', 1, 'KGTE2022#1X9JT#C#20230228890', 'KL000004165202223E', '83737138', '83737138', '2023-02-28 16:15:46.203410', '2023-02-28-16.16.15.000000', 'FPN ', 'N', 'MEENU                                                                      ', '', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (9, '9C9NU                           ', '2023-02-28', 1, 'KGTE2022#9C9NU#C#20230228653', 'KL000004166202223E', '83738165', '83738165', '2023-02-28 16:25:10.834205', '2023-02-28-16.25.27.000000', 'FPN ', 'N', 'R                                                                          ', '', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (10, '9C9NU                           ', '2023-02-28', 1, 'KGTE2022#9C9NU#C#20230228653', 'KL000004166202223E', '83738165', '83738165', '2023-02-28 16:25:10.834205', '2023-02-28-16.25.27.000000', 'FPN ', 'N', 'R                                                                          ', '', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (11, '1927V                           ', '2023-02-28', 1, 'KGTE2022#1927V#C#20230228399', 'KL000004172202223E', '83741565', '83741565', '2023-02-28 16:59:11.768374', '2023-02-28-16.59.28.000000', 'FPN ', 'N', 'Anu                                                                        ', '', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (12, 'JL3K0                           ', '2023-02-28', 1, 'KGTE2022#JL3K0#C#20230228989', 'KL000004179202223E', '83743060', '83743060', '2023-02-28 17:16:24.136560', '2023-02-28-17.16.39.000000', 'FPN ', 'N', 'HEMA                                                                       ', '', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (13, 'JL3K0                           ', '2023-02-28', 1, 'KGTE2022#JL3K0#C#20230228989', 'KL000004179202223E', '83743060', '83743060', '2023-02-28 17:16:24.136560', '2023-02-28-17.16.39.000000', 'FPN ', 'N', 'HEMA                                                                       ', '', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (14, 'JL3K0                           ', '2023-02-28', 1, 'KGTE2022#JL3K0#C#20230228989', 'KL000004179202223E', '83743060', '83743060', '2023-02-28 17:16:24.136560', '2023-02-28-17.16.39.000000', 'FPN ', 'N', 'HEMA                                                                       ', '', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (15, 'K7QA6                           ', '2023-02-28', 1, 'KGTE2022#K7QA6#C#20230228823', 'KL000004188202223E', 'T23059174524JF936', '23059174524207', '2023-02-28 17:45:01.665186', '2023-02-28-17.48.00.00000', 'UPI ', 'Y', 'SDH', 'SUCCESS', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (16, 'K7QA6                           ', '2023-02-28', 1, 'KGTE2022#K7QA6#C#20230228823', 'KL000004188202223E', 'T23059174524JF936', '23059174524207', '2023-02-28 17:45:01.665186', '2023-02-28-17.48.00.00000', 'UPI ', 'Y', 'SDH', 'SUCCESS', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (17, 'K7QA6                           ', '2023-02-28', 1, 'KGTE2022#K7QA6#C#20230228823', 'KL000004188202223E', 'T23059174524JF936', '23059174524207', '2023-02-28 17:45:01.665186', '2023-02-28-17.48.00.00000', 'UPI ', 'Y', 'SDH', 'SUCCESS', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (18, 'K7QA6                           ', '2023-02-28', 1, 'KGTE2022#K7QA6#C#20230228823', 'KL000004188202223E', 'T23059174524JF936', '23059174524207', '2023-02-28 17:45:01.665186', '2023-02-28-17.48.00.00000', 'UPI ', 'Y', 'SDH', 'SUCCESS', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (19, 'K7QA6                           ', '2023-02-28', 1, 'KGTE2022#K7QA6#C#20230228823', 'KL000004188202223E', 'T23059174524JF936', '23059174524207', '2023-02-28 17:45:01.665186', '2023-02-28-17.48.00.00000', 'UPI ', 'Y', 'SDH', 'SUCCESS', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (20, 'K7QA6                           ', '2023-02-28', 1, 'KGTE2022#K7QA6#C#20230228823', 'KL000004188202223E', 'T23059174524JF936', '23059174524207', '2023-02-28 17:45:01.665186', '2023-02-28-17.48.00.00000', 'UPI ', 'Y', 'SDH', 'SUCCESS', 'C');
INSERT INTO "KGTENOV2022"."pg_transactions" VALUES (21, 'K7QA6                           ', '2023-02-28', 1, 'KGTE2022#K7QA6#C#20230228823', 'KL000004188202223E', 'T23059174524JF936', '23059174524207', '2023-02-28 17:45:01.665186', '2023-02-28-17.48.00.00000', 'UPI ', 'Y', 'SDH', 'SUCCESS', 'C');
