Tables [dbo].[ICQOrders]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:02 AM Thursday, March 21, 2019
Last Modified1:11:50 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_ICQOrders: QOrderIDQOrderIDint4
False
1 - 1
Descriptionvarchar(255)255
False
ReqDatedatetime8
True
Foreign Keys FK_ICQOrders_AgentID_ShAgents: [dbo].[ShAgents].AgentIDAgentIDint4
True
ActionTypeIDint4
True
ShipToIDint4
True
ShipToTypeIDint4
False
((1))
Foreign Keys FK_ICQOrders_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
CustomerIDint4
True
CustomerNamevarchar(128)128
False
('')
CustomerAttnvarchar(64)64
False
('')
CustomerAddressvarchar(64)64
False
('')
CustomerCityvarchar(32)32
False
('')
CustomerStatevarchar(16)16
False
('')
CustomerZipvarchar(16)16
False
('')
CustomerCountryvarchar(16)16
False
('')
ShipToNameInternalvarchar(128)128
False
('')
ShipToNamevarchar(128)128
False
('')
ShipToAttnvarchar(64)64
False
('')
ShipToAddressvarchar(64)64
False
('')
ShipToCityvarchar(32)32
False
('')
ShipToStatevarchar(16)16
False
('')
ShipToZipvarchar(16)16
False
('')
ShipToCountryvarchar(16)16
False
('')
Foreign Keys FK_ICQOrders_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
False
Quantitydecimal(18,6)9
False
Warehousevarchar(128)128
False
Foreign Keys FK_ICQOrders_WarehouseID_ICWarehouses: [dbo].[ICWarehouses].WarehouseIDWarehouseIDint4
False
Foreign Keys FK_ICQOrders_BinID_ICBins: [dbo].[ICBins].BinIDBinIDint4
True
Foreign Keys FK_ICQOrders_CallID_SCCalls: [dbo].[SCCalls].CallIDCallIDint4
True
Foreign Keys FK_ICQOrders_SOID_SOOrders: [dbo].[SOOrders].SOIDSOIDint4
True
Foreign Keys FK_ICQOrders_SODetailBinID_SOOrderDetailBins: [dbo].[SOOrderDetailBins].SODetailBinIDSODetailBinIDint4
True
CallMaterialBinIDint4
True
Foreign Keys FK_ICQOrders_RequestID_ICRequestDetails: [dbo].[ICRequestDetails].RequestID\RequestDetailIDRequestIDint4
True
Foreign Keys FK_ICQOrders_RequestID_ICRequestDetails: [dbo].[ICRequestDetails].RequestID\RequestDetailIDRequestDetailIDint4
True
LinkedTransactionTypeIDint4
True
LinkedTransactionNumbervarchar(64)64
False
LinkedTransactionDatedatetime8
True
LinkedTransactionSettingsvarchar(128)128
False
('')
Foreign Keys FK_ICQOrders_LinkedTransactionBranchID_GLBranches: [dbo].[GLBranches].LinkedTransactionBranchIDLinkedTransactionBranchIDint4
True
StockTypeIDint4
False
SelectedDatetimedatetime8
True
StatusIDint4
False
((1))
Vendorvarchar(128)128
True
Foreign Keys FK_ICQOrders_VendorID_APVendors: [dbo].[APVendors].VendorIDVendorIDint4
True
VendorCostmoney8
False
((0))
SourceWarehousevarchar(128)128
True
SourceWarehouseIDint4
True
ReceivingWarehousevarchar(128)128
True
ReceivingWarehouseIDint4
False
Foreign Keys FK_ICQOrders_POQDetailBinID_POQOrderDetailBins: [dbo].[POQOrderDetailBins].POQDetailBinIDPOQDetailBinIDint4
True
Foreign Keys FK_ICQOrders_POQID_POQOrders: [dbo].[POQOrders].POQIDPOQIDint4
True
Foreign Keys FK_ICQOrders_TOQID_ICQTransferOrderDetails: [dbo].[ICQTransferOrderDetails].TOQID\TOQDetailIDTOQDetailIDint4
True
Foreign Keys FK_ICQOrders_TOQID_ICQTransferOrderDetails: [dbo].[ICQTransferOrderDetails].TOQID\TOQDetailIDTOQIDint4
True
CreatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
Foreign Keys FK_ICQOrders_DeliveryMethodID_ICDeliveryMethods: [dbo].[ICDeliveryMethods].DeliveryMethodIDDeliveryMethodIDint4
True
Notesvarchar(255)255
False
('')
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ICQOrders: QOrderIDPK_ICQOrdersQOrderID
True
80
NameColumns
FK_ICQOrders_AgentID_ShAgentsAgentID->[dbo].[ShAgents].[AgentID]
FK_ICQOrders_BinID_ICBinsBinID->[dbo].[ICBins].[BinID]
FK_ICQOrders_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_ICQOrders_CallID_SCCallsCallID->[dbo].[SCCalls].[CallID]
FK_ICQOrders_DeliveryMethodID_ICDeliveryMethodsDeliveryMethodID->[dbo].[ICDeliveryMethods].[DeliveryMethodID]
FK_ICQOrders_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_ICQOrders_LinkedTransactionBranchID_GLBranchesLinkedTransactionBranchID->[dbo].[GLBranches].[BranchID]
FK_ICQOrders_POQDetailBinID_POQOrderDetailBinsPOQDetailBinID->[dbo].[POQOrderDetailBins].[POQDetailBinID]
FK_ICQOrders_POQID_POQOrdersPOQID->[dbo].[POQOrders].[POQID]
FK_ICQOrders_RequestID_ICRequestDetailsRequestID->[dbo].[ICRequestDetails].[RequestID]
RequestDetailID->[dbo].[ICRequestDetails].[DetailID]
FK_ICQOrders_SODetailBinID_SOOrderDetailBinsSODetailBinID->[dbo].[SOOrderDetailBins].[SODetailBinID]
FK_ICQOrders_SOID_SOOrdersSOID->[dbo].[SOOrders].[SOID]
FK_ICQOrders_TOQID_ICQTransferOrderDetailsTOQID->[dbo].[ICQTransferOrderDetails].[TOQID]
TOQDetailID->[dbo].[ICQTransferOrderDetails].[DetailID]
FK_ICQOrders_VendorID_APVendorsVendorID->[dbo].[APVendors].[VendorID]
FK_ICQOrders_WarehouseID_ICWarehousesWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
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
  • [dbo].[v_ICQOrders]