USE [CISPROD_DEV]
GO

/****** Object:  Table [ADVANCED].[BIF041]    Script Date: 11/14/2012 13:00:56 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [ADVANCED].[BIF041](
	[C_CUSTOMER] [char](15) NOT NULL,
	[C_ACCOUNT] [char](15) NOT NULL,
	[T_TRANSDT] [datetime] NOT NULL,
	[C_TRANSCODE] [char](4) NOT NULL,
	[Y_AMOUNT] [decimal](15, 2) NOT NULL,
	[I_BILLNUMBER] [decimal](15, 0) NOT NULL,
	[I_TRANSNUM] [decimal](15, 0) NOT NULL,
	[C_USERID] [char](15) NOT NULL,
	[N_SUMFLAG] [decimal](1, 0) NOT NULL,
	[C_ARCODE] [char](2) NOT NULL,
	[T_DATETIME] [datetime] NOT NULL,
	[I_TOTAL] [int] NOT NULL,
	[C_COMPANY] [char](2) NOT NULL,
	[C_DIVISION] [char](2) NOT NULL,
	[I_SONUM] [numeric](15, 0) NOT NULL,
	[I_BIF041PK] [decimal](15, 0) NOT NULL,
	[D_AGING] [datetime] NULL,
	[L_EXCLUDETRANS] [bit] NOT NULL,
 CONSTRAINT [BIF041_I_BIF041PK] PRIMARY KEY CLUSTERED 
(
	[I_BIF041PK] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [CISDATA]
) ON [CISDATA]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ('') FOR [C_CUSTOMER]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ('') FOR [C_ACCOUNT]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  CONSTRAINT [BIF041_T_TRANSDT_ZDEFA]  DEFAULT (getdate()) FOR [T_TRANSDT]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ('') FOR [C_TRANSCODE]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ((0)) FOR [Y_AMOUNT]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ((0)) FOR [I_BILLNUMBER]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ((0)) FOR [I_TRANSNUM]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ('') FOR [C_USERID]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ((0)) FOR [N_SUMFLAG]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ('') FOR [C_ARCODE]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT (getdate()) FOR [T_DATETIME]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ((0)) FOR [I_TOTAL]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ('01') FOR [C_COMPANY]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ('01') FOR [C_DIVISION]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ((0)) FOR [I_SONUM]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  CONSTRAINT [BIF041_I_BIF041PK_ZDEFA]  DEFAULT ((0)) FOR [I_BIF041PK]
GO

ALTER TABLE [ADVANCED].[BIF041] ADD  DEFAULT ((0)) FOR [L_EXCLUDETRANS]
GO

select L_EXCLUDETRANS, count(*) from ADVANCED.BIF041 group by L_EXCLUDETRANS 

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass