USE [LOKETPROD]
GO

/****** Object:  Table [dbo].[TRA_BILL]    Script Date: 11/21/2018 10:26:35 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TRA_BILL](
	[NPA] [varchar](10) NOT NULL,
	[RB] [varchar](2) NOT NULL,
	[RT] [varchar](4) NOT NULL,
	[AIR_MINUM] [float] NULL,
	[AIR_LIMBAH] [float] NULL,
	[MINUM_KE] [nvarchar](2) NULL,
	[MINUM_RP] [float] NULL,
	[LIMBAH_KE] [varchar](2) NULL,
	[LIMBAH_RP] [float] NULL,
	[MATERAI] [float] NULL,
	[DENDA] [float] NULL,
	[JASA_ADM] [float] NULL,
	[TGL_BAYAR] [datetime] NULL,
	[R_METER] [float] NULL,
	[TARIP] [varchar](1) NULL,
	[TGL_PUTUS] [datetime] NULL,
	[NO_BUKU] [varchar](6) NULL,
	[NMTARIP] [varchar](4) NULL,
	[KOCAB] [varchar](2) NULL,
	[INIT] [varchar](1) NULL,
	[KET] [varchar](1) NULL,
	[ID] [varchar](4) NULL,
	[DELETED] [float] NULL,
	[KNDMTR] [varchar](1) NULL,
	[NPAL] [varchar](10) NULL,
	[HAL_BUKU] [varchar](4) NULL,
	[KDJUAL] [varchar](1) NULL,
	[KODE] [varchar](20) NULL,
	[MTR_GNT] [float] NULL,
	[LEVEL_1] [float] NULL,
	[LEVEL_2] [float] NULL,
	[B_CETAK] [float] NULL,
	[JLHRPAIR] [float] NULL,
	[STAW] [float] NULL,
	[STAKH] [float] NULL,
	[STTSR] [float] NULL,
	[UJL] [float] NULL,
	[TGLCTK] [datetime] NULL,
	[TYPE_MTR] [varchar](1) NULL,
	[LEVEL_3] [float] NULL,
	[NO_RMH] [varchar](16) NULL,
 CONSTRAINT [PK_TRA_BILL1] PRIMARY KEY CLUSTERED 
(
	[NPA] ASC,
	[RB] ASC,
	[RT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 70) ON [PRIMARY]
) ON [PRIMARY]
GO

USE [LOKETPROD]
GO

SET ANSI_PADDING ON
GO

/****** Object:  Index [_dta_index_TRA_BILL_7_1925959029__K13_K1_K2_K3]    Script Date: 11/21/2018 10:27:32 AM ******/
CREATE NONCLUSTERED INDEX [_dta_index_TRA_BILL_7_1925959029__K13_K1_K2_K3] ON [dbo].[TRA_BILL]
(
	[TGL_BAYAR] ASC,
	[NPA] ASC,
	[RB] ASC,
	[RT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


USE [LOKETPROD]
GO

SET ANSI_PADDING ON
GO

/****** Object:  Index [_dta_index_TRA_BILL_7_1925959029__K19_K1_K3_K2_4_5_7_9_10_11_12_13_14_37]    Script Date: 11/21/2018 10:27:48 AM ******/
CREATE NONCLUSTERED INDEX [_dta_index_TRA_BILL_7_1925959029__K19_K1_K3_K2_4_5_7_9_10_11_12_13_14_37] ON [dbo].[TRA_BILL]
(
	[KOCAB] ASC,
	[NPA] ASC,
	[RT] ASC,
	[RB] ASC
)
INCLUDE ( 	[AIR_MINUM],
	[AIR_LIMBAH],
	[MINUM_RP],
	[LIMBAH_RP],
	[MATERAI],
	[DENDA],
	[JASA_ADM],
	[TGL_BAYAR],
	[R_METER],
	[UJL]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

USE [LOKETPROD]
GO

SET ANSI_PADDING ON
GO

/****** Object:  Index [_dta_index_TRA_BILL_7_1925959029__K3_K2_K1]    Script Date: 11/21/2018 10:28:20 AM ******/
CREATE NONCLUSTERED INDEX [_dta_index_TRA_BILL_7_1925959029__K3_K2_K1] ON [dbo].[TRA_BILL]
(
	[RT] ASC,
	[RB] ASC,
	[NPA] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

USE [LOKETPROD]
GO

SET ANSI_PADDING ON
GO

/****** Object:  Index [IX_TRA_BILL]    Script Date: 11/21/2018 10:28:31 AM ******/
CREATE NONCLUSTERED INDEX [IX_TRA_BILL] ON [dbo].[TRA_BILL]
(
	[NPA] ASC,
	[TGL_BAYAR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 70) ON [PRIMARY]
GO
USE [LOKETPROD]
GO

SET ANSI_PADDING ON
GO

/****** Object:  Index [PK_TRA_BILL1]    Script Date: 11/21/2018 10:28:44 AM ******/
ALTER TABLE [dbo].[TRA_BILL] ADD  CONSTRAINT [PK_TRA_BILL1] PRIMARY KEY CLUSTERED 
(
	[NPA] ASC,
	[RB] ASC,
	[RT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 70) ON [PRIMARY]
GO



