Tables [dbo].[GLBranches]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:51 AM Thursday, March 21, 2019
Last Modified1:16:15 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_GLBranches: BranchIDBranchIDint4
False
100 - 1
BranchNumbervarchar(15)15
False
BranchNamevarchar(50)50
False
Remarksvarchar(1024)1024
False
Foreign Keys FK_GLBranches_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
True
DefaultARBranchIDint4
False
DefaultAPBranchIDint4
False
DefaultPORemitBranchIDint4
False
MainBranchbit1
False
((0))
Activebit1
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_GLBranches_DefaultWarehouseID_ICWarehouses: [dbo].[ICWarehouses].DefaultWarehouseIDDefaultWarehouseIDint4
True
Foreign Keys FK_GLBranches_rptLogoID_SHImages: [dbo].[SHImages].rptLogoIDrptLogoIDint4
True
Foreign Keys FK_GLBranches_rptMsgID_SHMessages: [dbo].[SHMessages].rptMsgIDrptMsgIDint4
True
rptShowHeaderbit1
False
((0))
rptShowFooterbit1
False
((0))
Foreign Keys FK_GLBranches_TimeZoneCodeID_ShTimeZoneCodes: [dbo].[SHTimeZoneCodes].TimeZoneCodeIDTimeZoneCodeIDint4
True
BranchNameExternalvarchar(128)128
False
('')
Addressvarchar(64)64
False
('')
Cityvarchar(32)32
False
('')
Statevarchar(16)16
False
('')
Zipvarchar(16)16
False
('')
Countryvarchar(16)16
False
('')
Countyvarchar(32)32
False
('')
Phone1varchar(30)30
False
('')
Phone2varchar(30)30
False
('')
Faxvarchar(30)30
False
('')
EINvarchar(15)15
False
('')
Address_MapPointvarchar(64)64
False
('')
City_MapPointvarchar(32)32
False
('')
State_MapPointvarchar(16)16
False
('')
Zip_MapPointvarchar(16)16
False
('')
Foreign Keys FK_GLBranches_BillCodeID_SCBillCodes: [dbo].[SCBillCodes].BillCodeIDBillCodeIDint4
True
Foreign Keys FK_GLBranches_PreAssemblyWarehouseID_ICWarehouses: [dbo].[ICWarehouses].PreAssemblyWarehouseIDPreAssemblyWarehouseIDint4
True
Foreign Keys FK_GLBranches_PostAssemblyWarehouseID_ICWarehouses: [dbo].[ICWarehouses].PostAssemblyWarehouseIDPostAssemblyWarehouseIDint4
True
Foreign Keys FK_GLBranches_DropShipWarehouseID_ICWarehouses: [dbo].[ICWarehouses].DropShipWarehouseIDDropShipWarehouseIDint4
True
AllowQueueingint4
False
((0))
SalesInvoiceCopiesint4
False
((0))
ServiceInvoiceCopiesint4
False
((0))
ContractInvoiceCopiesint4
False
((0))
MiscChargeInvoiceCopiesint4
False
((0))
AutoApproveQueuebit1
False
((0))
QueuePrintInvoicesbit1
False
((0))
QueueEmailInvoicesbit1
False
((1))
SendZeroDollarInvoicesbit1
False
((0))
SendCreditMemosbit1
False
((0))
SendRebillingsbit1
False
((1))
Foreign Keys FK_GLBranches_NoteID_GLBranchNotes: [dbo].[GLBranchNotes].NoteIDNoteIDint4
True
NoteFlagint4
False
((0))
Foreign Keys FK_GLBranches_ReturnsWarehouseID_ICWarehouses: [dbo].[ICWarehouses].ReturnsWarehouseIDReturnsWarehouseIDint4
True
Foreign Keys FK_GLBranches_ReturnsUVWarehouseID_ICWarehouses: [dbo].[ICWarehouses].ReturnsUVWarehouseIDReturnsUVWarehouseIDint4
True
Foreign Keys FK_GLBranches_RTVWarehouseID_ICWarehouses: [dbo].[ICWarehouses].RTVWarehouseIDRTVWarehouseIDint4
True
Foreign Keys FK_GLBranches_DisposalWarehouseID_ICWarehouses: [dbo].[ICWarehouses].DisposalWarehouseIDDisposalWarehouseIDint4
True
PurchaseOrderCopiesint4
False
((0))
AutoApprovePOQueuebit1
False
((0))
QueuePrintPOOrdersbit1
False
((0))
QueueEmailPOOrdersbit1
False
((0))
QueueExportPOOrdersbit1
False
((0))
SendZeroDollarPOOrdersbit1
False
((0))
SendCreditPOOrdersbit1
False
((0))
NoteCountint4
False
((0))
Foreign Keys FK_GLBranches_SLACodeID_SCSLACodes: [dbo].[SCSLACodes].SLACodeIDSLACodeIDint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_GLBranches: BranchIDPK_GLBranchesBranchID
True
80
NameNo CheckColumns
FK_GLBranches_BillCodeID_SCBillCodesBillCodeID->[dbo].[SCBillCodes].[BillCodeID]
FK_GLBranches_CustomerID_ARCustomers
True
CustomerID->[dbo].[ARCustomers].[CustomerID]
FK_GLBranches_DefaultWarehouseID_ICWarehousesDefaultWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
FK_GLBranches_DisposalWarehouseID_ICWarehousesDisposalWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
FK_GLBranches_DropShipWarehouseID_ICWarehousesDropShipWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
FK_GLBranches_NoteID_GLBranchNotesNoteID->[dbo].[GLBranchNotes].[NoteID]
FK_GLBranches_PostAssemblyWarehouseID_ICWarehousesPostAssemblyWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
FK_GLBranches_PreAssemblyWarehouseID_ICWarehousesPreAssemblyWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
FK_GLBranches_ReturnsUVWarehouseID_ICWarehousesReturnsUVWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
FK_GLBranches_ReturnsWarehouseID_ICWarehousesReturnsWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
FK_GLBranches_rptLogoID_SHImagesrptLogoID->[dbo].[SHImages].[ImageID]
FK_GLBranches_rptMsgID_SHMessagesrptMsgID->[dbo].[SHMessages].[MessageID]
FK_GLBranches_RTVWarehouseID_ICWarehousesRTVWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
FK_GLBranches_SLACodeID_SCSLACodesSLACodeID->[dbo].[SCSLACodes].[SLACodeID]
FK_GLBranches_TimeZoneCodeID_ShTimeZoneCodesTimeZoneCodeID->[dbo].[SHTimeZoneCodes].[TimeZoneCodeID]
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