CREATE TABLE [dbo].[ICQOrders]
(
[QOrderID] [int] NOT NULL IDENTITY(1, 1),
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReqDate] [datetime] NULL,
[AgentID] [int] NULL,
[ActionTypeID] [int] NULL,
[ShipToID] [int] NULL,
[ShipToTypeID] [int] NOT NULL CONSTRAINT [DF_ICQOrders_ShipToTypeID] DEFAULT ((1)),
[BranchID] [int] NOT NULL,
[CustomerID] [int] NULL,
[CustomerName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_CustomerName] DEFAULT (''),
[CustomerAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_CustomerAttn] DEFAULT (''),
[CustomerAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_CustomerAddress] DEFAULT (''),
[CustomerCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_CustomerCity] DEFAULT (''),
[CustomerState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_CustomerState] DEFAULT (''),
[CustomerZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_CustomerZip] DEFAULT (''),
[CustomerCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_CustomerCountry] DEFAULT (''),
[ShipToNameInternal] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_ShipToNameInternal] DEFAULT (''),
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_ShipToName] DEFAULT (''),
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_ShipToAttn] DEFAULT (''),
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_ShipToAddress] DEFAULT (''),
[ShipToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_ShipToCity] DEFAULT (''),
[ShipToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_ShipToState] DEFAULT (''),
[ShipToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_ShipToZip] DEFAULT (''),
[ShipToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_ShipToCountry] DEFAULT (''),
[ItemID] [int] NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[Warehouse] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WarehouseID] [int] NOT NULL,
[BinID] [int] NULL,
[CallID] [int] NULL,
[SOID] [int] NULL,
[SODetailBinID] [int] NULL,
[CallMaterialBinID] [int] NULL,
[RequestID] [int] NULL,
[RequestDetailID] [int] NULL,
[LinkedTransactionTypeID] [int] NULL,
[LinkedTransactionNumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LinkedTransactionDate] [datetime] NULL,
[LinkedTransactionSettings] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_LinkedTransactionSettings] DEFAULT (''),
[LinkedTransactionBranchID] [int] NULL,
[StockTypeID] [int] NOT NULL,
[SelectedDatetime] [datetime] NULL,
[StatusID] [int] NOT NULL CONSTRAINT [DF_ICQOrders_StatusID] DEFAULT ((1)),
[Vendor] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VendorID] [int] NULL,
[VendorCost] [money] NOT NULL CONSTRAINT [DF_ICQOrders_VendorCost] DEFAULT ((0)),
[SourceWarehouse] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SourceWarehouseID] [int] NULL,
[ReceivingWarehouse] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReceivingWarehouseID] [int] NOT NULL,
[POQDetailBinID] [int] NULL,
[POQID] [int] NULL,
[TOQDetailID] [int] NULL,
[TOQID] [int] NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_ICQOrders_CreateDate] DEFAULT (getdate()),
[DeliveryMethodID] [int] NULL,
[Notes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ICQOrders_Notes] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [PK_ICQOrders] PRIMARY KEY CLUSTERED ([QOrderID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_AgentID_ShAgents] FOREIGN KEY ([AgentID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_DeliveryMethodID_ICDeliveryMethods] FOREIGN KEY ([DeliveryMethodID]) REFERENCES [dbo].[ICDeliveryMethods] ([DeliveryMethodID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_LinkedTransactionBranchID_GLBranches] FOREIGN KEY ([LinkedTransactionBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_POQDetailBinID_POQOrderDetailBins] FOREIGN KEY ([POQDetailBinID]) REFERENCES [dbo].[POQOrderDetailBins] ([POQDetailBinID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_POQID_POQOrders] FOREIGN KEY ([POQID]) REFERENCES [dbo].[POQOrders] ([POQID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_RequestID_ICRequestDetails] FOREIGN KEY ([RequestID], [RequestDetailID]) REFERENCES [dbo].[ICRequestDetails] ([RequestID], [DetailID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_SODetailBinID_SOOrderDetailBins] FOREIGN KEY ([SODetailBinID]) REFERENCES [dbo].[SOOrderDetailBins] ([SODetailBinID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_SOID_SOOrders] FOREIGN KEY ([SOID]) REFERENCES [dbo].[SOOrders] ([SOID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_TOQID_ICQTransferOrderDetails] FOREIGN KEY ([TOQID], [TOQDetailID]) REFERENCES [dbo].[ICQTransferOrderDetails] ([TOQID], [DetailID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_VendorID_APVendors] FOREIGN KEY ([VendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO
ALTER TABLE [dbo].[ICQOrders] ADD CONSTRAINT [FK_ICQOrders_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO