CREATE TABLE [dbo].[ICTransferOrders]
(
[TOID] [int] NOT NULL IDENTITY(1, 1),
[TONumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AgentID] [int] NULL,
[Date] [datetime] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReqDate] [datetime] NULL,
[ShipToTypeID] [int] NULL,
[ShipToID] [int] NULL,
[SourceWarehouseID] [int] NOT NULL,
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToName] DEFAULT (''),
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToAttn] DEFAULT (''),
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToAddress] DEFAULT (''),
[ShipToCity] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToCity] DEFAULT (''),
[ShipToState] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToState] DEFAULT (''),
[ShipToZip] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToZip] DEFAULT (''),
[ShipToCountry] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICTransferOrders_ShipToCountry] DEFAULT (''),
[BranchID] [int] NOT NULL,
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS 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_ICTransferOrders_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICTransferOrders_LastUpdate] DEFAULT (getdate()),
[Batch] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DestWarehouseID] [int] NULL,
[Locked] [bit] NOT NULL CONSTRAINT [DF_ICTransferOrders_Locked] DEFAULT ((0)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_ICTransferOrders_NoteFlag] DEFAULT ((0)),
[RTSourceTechnicianID] [int] NULL,
[RTDestTechnicianID] [int] NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_ICTransferOrders_NoteCount] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICTransferOrders] ADD CONSTRAINT [PK_ICTransferOrders] PRIMARY KEY CLUSTERED ([TOID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICTransferOrders] ADD CONSTRAINT [FK_ICTransferOrders_AgentID_ShAgents] FOREIGN KEY ([AgentID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[ICTransferOrders] ADD CONSTRAINT [FK_ICTransferOrders_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ICTransferOrders] ADD CONSTRAINT [FK_ICTransferOrders_DestWarehouseID_ICWarehouses] FOREIGN KEY ([DestWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[ICTransferOrders] ADD CONSTRAINT [FK_ICTransferOrders_NoteID_ICTransferOrderNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[ICTransferOrderNotes] ([NoteID])
GO
ALTER TABLE [dbo].[ICTransferOrders] ADD CONSTRAINT [FK_ICTransferOrders_SourceWarehouseID_ICWarehouses] FOREIGN KEY ([SourceWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO