CREATE TABLE [dbo].[ICQTransferOrders]
(
[TOQID] [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,
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToID] [int] NULL,
[ShipToTypeID] [int] NULL,
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQTransferOrders_ShipToName] DEFAULT (''),
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQTransferOrders_ShipToAttn] DEFAULT (''),
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQTransferOrders_ShipToAddress] DEFAULT (''),
[ShipToCity] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQTransferOrders_ShipToCity] DEFAULT (''),
[ShipToState] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQTransferOrders_ShipToState] DEFAULT (''),
[ShipToZip] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQTransferOrders_ShipToZip] DEFAULT (''),
[ShipToCountry] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQTransferOrders_ShipToCountry] DEFAULT (''),
[SourceWarehouseID] [int] NOT NULL,
[BranchID] [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_ICQTransferOrders_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ICQTransferOrders_LastUpdate] DEFAULT (getdate()),
[DestWarehouseID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICQTransferOrders] ADD CONSTRAINT [PK_ICQTransferOrders] PRIMARY KEY CLUSTERED ([TOQID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICQTransferOrders] ADD CONSTRAINT [FK_ICQTransferOrders_AgentID_ShAgents] FOREIGN KEY ([AgentID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[ICQTransferOrders] ADD CONSTRAINT [FK_ICQTransferOrders_DestWarehouseID_ICWarehouses] FOREIGN KEY ([DestWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO