Untitled

mail@pastecode.io avatar
unknown
plain_text
23 days ago
4.9 kB
2
Indexable
Never
USE [bsi]
GO
/****** Object:  Table [cfa].[LHBU_Form401_PDNKeseluruhan_20230630]    Script Date: 5/21/2024 4:52:14 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [cfa].[LHBU_Form401_PDNKeseluruhan_20230630](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[FicMisDate] [date] NOT NULL,
	[NomorUrut] [int] NULL,
	[Kode] [varchar](10) NULL,
	[CCY] [varchar](10) NULL,
	[MataUang] [varchar](100) NULL,
	[Neraca] [decimal](32, 2) NULL,
	[RekAdministratif] [decimal](32, 2) NULL,
	[Jumlah] [decimal](32, 2) NULL,
	[JumlahABS] [decimal](32, 2) NULL,
	[Persen] [decimal](5, 2) NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [cfa].[LHBU_Form401_PDNKeseluruhan_20230630] ON 

INSERT [cfa].[LHBU_Form401_PDNKeseluruhan_20230630] ([id], [FicMisDate], [NomorUrut], [Kode], [CCY], [MataUang], [Neraca], [RekAdministratif], [Jumlah], [JumlahABS], [Persen]) VALUES (1, CAST(N'2023-06-01' AS Date), 1, N'USD', N'USD', N'Dolar Amerika Serikat', CAST(12910.00 AS Decimal(32, 2)), CAST(-21324.00 AS Decimal(32, 2)), CAST(-8414.00 AS Decimal(32, 2)), CAST(8414.00 AS Decimal(32, 2)), CAST(0.11 AS Decimal(5, 2)))
INSERT [cfa].[LHBU_Form401_PDNKeseluruhan_20230630] ([id], [FicMisDate], [NomorUrut], [Kode], [CCY], [MataUang], [Neraca], [RekAdministratif], [Jumlah], [JumlahABS], [Persen]) VALUES (2, CAST(N'2023-06-01' AS Date), 2, N'SGD', N'SGD', N'Dolar Singapura', CAST(11918.00 AS Decimal(32, 2)), CAST(-10491.00 AS Decimal(32, 2)), CAST(1427.00 AS Decimal(32, 2)), CAST(1427.00 AS Decimal(32, 2)), CAST(0.02 AS Decimal(5, 2)))
INSERT [cfa].[LHBU_Form401_PDNKeseluruhan_20230630] ([id], [FicMisDate], [NomorUrut], [Kode], [CCY], [MataUang], [Neraca], [RekAdministratif], [Jumlah], [JumlahABS], [Persen]) VALUES (3, CAST(N'2023-06-01' AS Date), 3, N'SAR', N'SAR', N'Riyal', CAST(164983.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(32, 2)), CAST(164983.00 AS Decimal(32, 2)), CAST(164983.00 AS Decimal(32, 2)), CAST(2.08 AS Decimal(5, 2)))
INSERT [cfa].[LHBU_Form401_PDNKeseluruhan_20230630] ([id], [FicMisDate], [NomorUrut], [Kode], [CCY], [MataUang], [Neraca], [RekAdministratif], [Jumlah], [JumlahABS], [Persen]) VALUES (4, CAST(N'2023-06-01' AS Date), 4, N'EUR', N'EUR', N'Euro', CAST(3644.00 AS Decimal(32, 2)), CAST(-3389.00 AS Decimal(32, 2)), CAST(255.00 AS Decimal(32, 2)), CAST(255.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(5, 2)))
INSERT [cfa].[LHBU_Form401_PDNKeseluruhan_20230630] ([id], [FicMisDate], [NomorUrut], [Kode], [CCY], [MataUang], [Neraca], [RekAdministratif], [Jumlah], [JumlahABS], [Persen]) VALUES (5, CAST(N'2023-06-01' AS Date), 5, N'AUD', N'AUD', N'Dolar Australia', CAST(668.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(32, 2)), CAST(668.00 AS Decimal(32, 2)), CAST(668.00 AS Decimal(32, 2)), CAST(0.01 AS Decimal(5, 2)))
INSERT [cfa].[LHBU_Form401_PDNKeseluruhan_20230630] ([id], [FicMisDate], [NomorUrut], [Kode], [CCY], [MataUang], [Neraca], [RekAdministratif], [Jumlah], [JumlahABS], [Persen]) VALUES (6, CAST(N'2023-06-01' AS Date), 6, N'JPY', N'JPY', N'Yen Jepang', CAST(251.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(32, 2)), CAST(251.00 AS Decimal(32, 2)), CAST(251.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(5, 2)))
INSERT [cfa].[LHBU_Form401_PDNKeseluruhan_20230630] ([id], [FicMisDate], [NomorUrut], [Kode], [CCY], [MataUang], [Neraca], [RekAdministratif], [Jumlah], [JumlahABS], [Persen]) VALUES (7, CAST(N'2023-06-01' AS Date), 7, N'HKD', N'HKD', N'Dolar Hongkong', CAST(0.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(5, 2)))
INSERT [cfa].[LHBU_Form401_PDNKeseluruhan_20230630] ([id], [FicMisDate], [NomorUrut], [Kode], [CCY], [MataUang], [Neraca], [RekAdministratif], [Jumlah], [JumlahABS], [Persen]) VALUES (8, CAST(N'2023-06-01' AS Date), 8, N'A01', NULL, N'Jumlah', CAST(0.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(32, 2)), CAST(175998.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(5, 2)))
INSERT [cfa].[LHBU_Form401_PDNKeseluruhan_20230630] ([id], [FicMisDate], [NomorUrut], [Kode], [CCY], [MataUang], [Neraca], [RekAdministratif], [Jumlah], [JumlahABS], [Persen]) VALUES (9, CAST(N'2023-06-01' AS Date), 9, N'A02', NULL, N'Jumlah Modal (KPMM bulan Pebruari 2018)', CAST(0.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(32, 2)), CAST(7931975.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(5, 2)))
INSERT [cfa].[LHBU_Form401_PDNKeseluruhan_20230630] ([id], [FicMisDate], [NomorUrut], [Kode], [CCY], [MataUang], [Neraca], [RekAdministratif], [Jumlah], [JumlahABS], [Persen]) VALUES (10, CAST(N'2023-06-01' AS Date), 10, N'A03', NULL, N'Rasio PDN Keseluruhan', CAST(0.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(32, 2)), CAST(0.00 AS Decimal(32, 2)), CAST(2.22 AS Decimal(32, 2)), CAST(2.22 AS Decimal(5, 2)))
SET IDENTITY_INSERT [cfa].[LHBU_Form401_PDNKeseluruhan_20230630] OFF
GO
Leave a Comment