/* 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');