Untitled

-- x definition

-- Drop table

-- DROP TABLE x;

CREATE TABLE x (
	id bigint IDENTITY(1,1) NOT NULL,
	FicMisDate date NOT NULL,
	NomorUrut int NULL,
	Kode varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	CCY varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	MataUang varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	Neraca decimal(18,2) NULL,
	RekAdministratif decimal(18,2) NULL,
	Jumlah decimal(18,2) NULL,
	JumlahABS decimal(18,2) NULL,
	Persen decimal(18,2) NULL,
	createdAt datetime2 DEFAULT getdate() NOT NULL,
	CONSTRAINT PK_b7f1dc64c4d5d0dfab40ffb57e5 PRIMARY KEY (id)
);

INSERT INTO x (FicMisDate,NomorUrut,Kode,CCY,MataUang,Neraca,RekAdministratif,Jumlah,JumlahABS,Persen,createdAt) VALUES
	 ('2025-07-05',13,N'A01',N'',N'Jumlah',0.00,0.00,0.00,534060.00,0.00,'2024-02-29 11:17:37.1666667'),
	 ('2025-07-05',14,N'A02',N'',N'Jumlah Modal (KPMM bulan Juni 2023)',0.00,0.00,0.00,35004881.00,0.00,'2024-02-29 11:17:37.3733333'),
	 ('2025-07-05',15,N'A03',N'',N'Rasio PDN Keseluruhan',0.00,0.00,0.00,0.02,0.00,'2024-02-29 11:17:37.6800000'),
	 ('2025-07-05',12,N'AUD',N'AUD',N'Dolar Australia',3275.00,0.00,3275.00,3275.00,0.00,'2024-02-29 11:17:37.9833333'),
	 ('2025-07-05',11,N'CAD',N'CAD',N'',0.00,0.00,0.00,0.00,0.00,'2024-02-29 11:17:38.2933333'),
	 ('2025-07-05',10,N'CHF',N'CHF',N'',0.00,0.00,0.00,0.00,0.00,'2024-02-29 11:17:38.2933333'),
	 ('2025-07-05',9,N'CNY',N'CNY',N'',0.00,0.00,0.00,0.00,0.00,'2024-02-29 11:17:38.2933333'),
	 ('2025-07-05',8,N'EUR',N'EUR',N'Euro',10537.00,0.00,10537.00,10537.00,0.00,'2024-02-29 11:17:38.2933333'),
	 ('2025-07-05',7,N'GBP',N'GBP',N'',1408.00,0.00,1408.00,1408.00,0.00,'2024-02-29 11:17:38.2966667'),
	 ('2025-07-05',6,N'HKD',N'HKD',N'Dolar Hongkong',243.00,0.00,243.00,243.00,0.00,'2024-02-29 11:17:38.2966667');
INSERT INTO x (FicMisDate,NomorUrut,Kode,CCY,MataUang,Neraca,RekAdministratif,Jumlah,JumlahABS,Persen,createdAt) VALUES
	 ('2025-07-05',5,N'JPY',N'JPY',N'Yen Jepang',2204.00,0.00,2204.00,2204.00,0.00,'2024-02-29 11:17:38.2966667'),
	 ('2025-07-05',4,N'SAR',N'SAR',N'Riyal',185533.00,39820.00,225353.00,225353.00,0.01,'2024-02-29 11:17:38.2966667'),
	 ('2025-07-05',3,N'SGD',N'SGD',N'Dolar Singapura',13893.00,-33503.00,19610.00,19610.00,0.00,'2024-02-29 11:17:38.2966667'),
	 ('2025-07-05',2,N'AED',N'AED',N'',2013.00,0.00,2013.00,2013.00,0.00,'2024-02-29 11:17:38.2966667'),
	 ('2025-07-05',1,N'USD',N'USD',N'Dolar Amerika Serikat',-135002.00,-134415.00,269417.00,269417.00,0.01,'2024-02-29 11:17:38.2966667');