CREATE TABLE [dbo].[GLBranches]
(
[BranchID] [int] NOT NULL IDENTITY(100, 1),
[BranchNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BranchName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CustomerID] [int] NULL,
[DefaultARBranchID] [int] NOT NULL,
[DefaultAPBranchID] [int] NOT NULL,
[DefaultPORemitBranchID] [int] NOT NULL,
[MainBranch] [bit] NOT NULL CONSTRAINT [DF_GLBranches_MainBranch] DEFAULT ((0)),
[Active] [bit] NOT NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_GLBranches_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_GLBranches_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[DefaultWarehouseID] [int] NULL,
[rptLogoID] [int] NULL,
[rptMsgID] [int] NULL,
[rptShowHeader] [bit] NOT NULL CONSTRAINT [DF_GLBranches_rptShowHeader] DEFAULT ((0)),
[rptShowFooter] [bit] NOT NULL CONSTRAINT [DF_GLBranches_rptShowFooter] DEFAULT ((0)),
[TimeZoneCodeID] [int] NULL,
[BranchNameExternal] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_BranchNameExternal] DEFAULT (''),
[Address] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_Address] DEFAULT (''),
[City] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_City] DEFAULT (''),
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_State] DEFAULT (''),
[Zip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_Zip] DEFAULT (''),
[Country] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_Country] DEFAULT (''),
[County] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_County] DEFAULT (''),
[Phone1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_Phone1] DEFAULT (''),
[Phone2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_Phone2] DEFAULT (''),
[Fax] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_Fax] DEFAULT (''),
[EIN] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_EIN] DEFAULT (''),
[Address_MapPoint] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_Address_MapPoint] DEFAULT (''),
[City_MapPoint] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_City_MapPoint] DEFAULT (''),
[State_MapPoint] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_State_MapPoint] DEFAULT (''),
[Zip_MapPoint] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLBranches_Zip_MapPoint] DEFAULT (''),
[BillCodeID] [int] NULL,
[PreAssemblyWarehouseID] [int] NULL,
[PostAssemblyWarehouseID] [int] NULL,
[DropShipWarehouseID] [int] NULL,
[AllowQueueing] [int] NOT NULL CONSTRAINT [DF_GLBranches_AllowQueueing] DEFAULT ((0)),
[SalesInvoiceCopies] [int] NOT NULL CONSTRAINT [DF_GLBranches_SalesInvoiceCopies] DEFAULT ((0)),
[ServiceInvoiceCopies] [int] NOT NULL CONSTRAINT [DF_GLBranches_ServiceInvoiceCopies] DEFAULT ((0)),
[ContractInvoiceCopies] [int] NOT NULL CONSTRAINT [DF_GLBranches_ContractInvoiceCopies] DEFAULT ((0)),
[MiscChargeInvoiceCopies] [int] NOT NULL CONSTRAINT [DF_GLBranches_MiscChargeInvoiceCopies] DEFAULT ((0)),
[AutoApproveQueue] [bit] NOT NULL CONSTRAINT [DF_GLBranches_AutoApproveQueue] DEFAULT ((0)),
[QueuePrintInvoices] [bit] NOT NULL CONSTRAINT [DF_GLBranches_QueuePrintInvoices] DEFAULT ((0)),
[QueueEmailInvoices] [bit] NOT NULL CONSTRAINT [DF_GLBranches_QueueEmailInvoices] DEFAULT ((1)),
[SendZeroDollarInvoices] [bit] NOT NULL CONSTRAINT [DF_GLBranches_SendZeroDollarInvoices] DEFAULT ((0)),
[SendCreditMemos] [bit] NOT NULL CONSTRAINT [DF_GLBranches_SendCreditMemos] DEFAULT ((0)),
[SendRebillings] [bit] NOT NULL CONSTRAINT [DF_GLBranches_SendRebillings] DEFAULT ((1)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_GLBranches_NoteFlag] DEFAULT ((0)),
[ReturnsWarehouseID] [int] NULL,
[ReturnsUVWarehouseID] [int] NULL,
[RTVWarehouseID] [int] NULL,
[DisposalWarehouseID] [int] NULL,
[PurchaseOrderCopies] [int] NOT NULL CONSTRAINT [DF_GLBranches_PurchaseOrderCopies] DEFAULT ((0)),
[AutoApprovePOQueue] [bit] NOT NULL CONSTRAINT [DF_GLBranches_AutoApprovePOQueue] DEFAULT ((0)),
[QueuePrintPOOrders] [bit] NOT NULL CONSTRAINT [DF_GLBranches_QueuePrintPOOrders] DEFAULT ((0)),
[QueueEmailPOOrders] [bit] NOT NULL CONSTRAINT [DF_GLBranches_QueueEmailPOOrders] DEFAULT ((0)),
[QueueExportPOOrders] [bit] NOT NULL CONSTRAINT [DF_GLBranches_QueueExportPOOrders] DEFAULT ((0)),
[SendZeroDollarPOOrders] [bit] NOT NULL CONSTRAINT [DF_GLBranches_SendZeroDollarPOOrders] DEFAULT ((0)),
[SendCreditPOOrders] [bit] NOT NULL CONSTRAINT [DF_GLBranches_SendCreditPOOrders] DEFAULT ((0)),
[NoteCount] [int] NOT NULL CONSTRAINT [DF_GLBranches_NoteCount] DEFAULT ((0)),
[SLACodeID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [PK_GLBranches] PRIMARY KEY CLUSTERED ([BranchID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_BillCodeID_SCBillCodes] FOREIGN KEY ([BillCodeID]) REFERENCES [dbo].[SCBillCodes] ([BillCodeID])
GO
ALTER TABLE [dbo].[GLBranches] WITH NOCHECK ADD CONSTRAINT [FK_GLBranches_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_DefaultWarehouseID_ICWarehouses] FOREIGN KEY ([DefaultWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_DisposalWarehouseID_ICWarehouses] FOREIGN KEY ([DisposalWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_DropShipWarehouseID_ICWarehouses] FOREIGN KEY ([DropShipWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_NoteID_GLBranchNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[GLBranchNotes] ([NoteID])
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_PostAssemblyWarehouseID_ICWarehouses] FOREIGN KEY ([PostAssemblyWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_PreAssemblyWarehouseID_ICWarehouses] FOREIGN KEY ([PreAssemblyWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_ReturnsUVWarehouseID_ICWarehouses] FOREIGN KEY ([ReturnsUVWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_ReturnsWarehouseID_ICWarehouses] FOREIGN KEY ([ReturnsWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_rptLogoID_SHImages] FOREIGN KEY ([rptLogoID]) REFERENCES [dbo].[SHImages] ([ImageID])
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_rptMsgID_SHMessages] FOREIGN KEY ([rptMsgID]) REFERENCES [dbo].[SHMessages] ([MessageID])
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_RTVWarehouseID_ICWarehouses] FOREIGN KEY ([RTVWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_SLACodeID_SCSLACodes] FOREIGN KEY ([SLACodeID]) REFERENCES [dbo].[SCSLACodes] ([SLACodeID])
GO
ALTER TABLE [dbo].[GLBranches] ADD CONSTRAINT [FK_GLBranches_TimeZoneCodeID_ShTimeZoneCodes] FOREIGN KEY ([TimeZoneCodeID]) REFERENCES [dbo].[SHTimeZoneCodes] ([TimeZoneCodeID])
GO