CREATE TABLE [dbo].[ICTransfers]
(
[TransferID] [int] NOT NULL,
[TransferNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Date] [datetime] NOT NULL,
[DatePeriod] [int] NOT NULL,
[Period] [int] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PicketID] [int] NULL,
[VoidID] [int] NULL,
[TransactionTypeID] [int] 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_ICTransfers_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICTransfers_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[ShipToTypeID] [int] NULL,
[ShipToID] [int] NULL,
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransfers_ShipToName] DEFAULT (''),
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransfers_ShipToAttn] DEFAULT (''),
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransfers_ShipToAddress] DEFAULT (''),
[ShipToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransfers_ShipToCity] DEFAULT (''),
[ShipToState] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransfers_ShipToState] DEFAULT (''),
[ShipToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransfers_ShipToZip] DEFAULT (''),
[ShipToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransfers_ShipToCountry] DEFAULT (''),
[BranchID] [int] NOT NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransfers_Remarks] DEFAULT (''),
[Batch] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_ICTransfers_NoteFlag] DEFAULT ((0)),
[POID] [int] NULL,
[TransferTypeID] [int] NOT NULL CONSTRAINT [DF_ICTransfers_TransferTypeID] DEFAULT ((1)),
[SrcWarehouseID] [int] NULL,
[DestWarehouseID] [int] NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_ICTransfers_NoteCount] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICTransfers] ADD CONSTRAINT [PK_ICTransfers] PRIMARY KEY CLUSTERED ([TransferID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICTransfers] ADD CONSTRAINT [FK_ICTransfers_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ICTransfers] ADD CONSTRAINT [FK_ICTransfers_DestWarehouseID_ICWarehouses] FOREIGN KEY ([DestWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[ICTransfers] ADD CONSTRAINT [FK_ICTransfers_NoteID_ICTransferNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[ICTransferNotes] ([NoteID])
GO
ALTER TABLE [dbo].[ICTransfers] ADD CONSTRAINT [FK_ICTransfers_PicketID_ICPickets] FOREIGN KEY ([PicketID]) REFERENCES [dbo].[ICPickets] ([PicketID])
GO
ALTER TABLE [dbo].[ICTransfers] ADD CONSTRAINT [FK_ICTransfers_POID_POOrders] FOREIGN KEY ([POID]) REFERENCES [dbo].[POOrders] ([POID])
GO
ALTER TABLE [dbo].[ICTransfers] ADD CONSTRAINT [FK_ICTransfers_SrcWarehouseID_ICWarehouses] FOREIGN KEY ([SrcWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[ICTransfers] ADD CONSTRAINT [FK_ICTransfers_TransferTypeID_ICTransferTypes] FOREIGN KEY ([TransferTypeID]) REFERENCES [dbo].[ICTransferTypes] ([TransferTypeID])
GO