Tables [dbo].[POQOrderDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:29 AM Thursday, March 21, 2019
Last Modified1:13:04 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_POQOrderDetails: POQID\DetailIDForeign Keys FK_POQOrderDetails_POQID_POQOrders: [dbo].[POQOrders].POQIDPOQIDint4
False
Cluster Primary Key PK_POQOrderDetails: POQID\DetailIDDetailIDint4
False
Foreign Keys FK_POQOrderDetails_ItemID_ICItems1: [dbo].[ICItems1].ItemIDItemIDint4
False
Descriptionvarchar(255)255
False
Quantitydecimal(18,6)9
False
UMvarchar(4)4
False
ConvFactordecimal(18,6)9
False
Pricemoney8
False
Discountdecimal(18,6)9
False
Freightmoney8
False
Stockedbit1
False
Foreign Keys FK_POQOrderDetails_StockTypeID_ICStockTypes: [dbo].[ICStockTypes].StockTypeIDStockTypeIDint4
False
((1))
Foreign Keys FK_POQOrderDetails_GLID_GLAccounts3: [dbo].[GLAccounts3].GLIDGLIDint4
False
Foreign Keys FK_POQOrderDetails_DeptID_GLDepts3: [dbo].[GLDepts3].DeptIDDeptIDint4
True
Foreign Keys FK_POQOrderDetails_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
True
Foreign Keys FK_POQOrderDetails_AdjGLID_GLAccounts3: [dbo].[GLAccounts3].AdjGLIDAdjGLIDint4
True
Foreign Keys FK_POQOrderDetails_AdjDeptID_GLDepts3: [dbo].[GLDepts3].AdjDeptIDAdjDeptIDint4
True
Amountmoney8
False
((0))
BackOrdereddecimal(18,6)9
False
Receiveddecimal(18,6)9
False
((0))
Canceleddecimal(18,6)9
False
((0))
UnReceivedmoney8
False
((0))
UpdateVendorCostbit1
False
((1))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
False
EstArrivalDatedatetime8
True
EstShipDatedatetime8
True
IsReturnbit1
False
((0))
IsRTVReturnbit1
False
((0))
RelatedDetailIDint4
True
DetailStatusIDint4
False
((1))
Remarksvarchar(1024)1024
False
('')
ParentKitIDint4
True
LineNumbervarchar(100)100
True
DisplayPricemoney8
False
((0))
DisplayAmountmoney8
False
((0))
KitComponentQuantitydecimal(18,6)9
True
KitComponentWeightingdecimal(18,6)9
True
TrackKitDiscountbit1
False
((0))
KitDiscountmoney8
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_POQOrderDetails: POQID\DetailIDPK_POQOrderDetailsPOQID, DetailID
True
80
NameColumns
FK_POQOrderDetails_AdjDeptID_GLDepts3AdjDeptID->[dbo].[GLDepts3].[DeptID]
FK_POQOrderDetails_AdjGLID_GLAccounts3AdjGLID->[dbo].[GLAccounts3].[AccountID]
FK_POQOrderDetails_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_POQOrderDetails_DeptID_GLDepts3DeptID->[dbo].[GLDepts3].[DeptID]
FK_POQOrderDetails_GLID_GLAccounts3GLID->[dbo].[GLAccounts3].[AccountID]
FK_POQOrderDetails_ItemID_ICItems1ItemID->[dbo].[ICItems1].[ItemID]
FK_POQOrderDetails_POQID_POQOrdersPOQID->[dbo].[POQOrders].[POQID]
FK_POQOrderDetails_StockTypeID_ICStockTypesStockTypeID->[dbo].[ICStockTypes].[StockTypeID]
CREATE TABLE [dbo].[POQOrderDetails]
(
[POQID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[ItemID] [int] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[UM] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ConvFactor] [decimal] (18, 6) NOT NULL,
[Price] [money] NOT NULL,
[Discount] [decimal] (18, 6) NOT NULL,
[Freight] [money] NOT NULL,
[Stocked] [bit] NOT NULL,
[StockTypeID] [int] NOT NULL CONSTRAINT [DF_POQOrderDetails_StockTypeID] DEFAULT ((1)),
[GLID] [int] NOT NULL,
[DeptID] [int] NULL,
[BranchID] [int] NULL,
[AdjGLID] [int] NULL,
[AdjDeptID] [int] NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_POQOrderDetails_Amount] DEFAULT ((0)),
[BackOrdered] [decimal] (18, 6) NOT NULL,
[Received] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POQOrderDetails_Received] DEFAULT ((0)),
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POQOrderDetails_Canceled] DEFAULT ((0)),
[UnReceived] [money] NOT NULL CONSTRAINT [DF_POQOrderDetails_UnReceived] DEFAULT ((0)),
[UpdateVendorCost] [bit] NOT NULL CONSTRAINT [DF_POQOrderDetails_UpdateVendorCost] DEFAULT ((1)),
[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_POQOrderDetails_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_POQOrderDetails_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[EstArrivalDate] [datetime] NULL,
[EstShipDate] [datetime] NULL,
[IsReturn] [bit] NOT NULL CONSTRAINT [DF_POQOrderDetails_IsReturn] DEFAULT ((0)),
[IsRTVReturn] [bit] NOT NULL CONSTRAINT [DF_POQOrderDetails_IsRTVReturn] DEFAULT ((0)),
[RelatedDetailID] [int] NULL,
[DetailStatusID] [int] NOT NULL CONSTRAINT [DF_POQOrderDetails_DetailStatusID] DEFAULT ((1)),
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POQOrderDetails_Remarks] DEFAULT (''),
[ParentKitID] [int] NULL,
[LineNumber] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DisplayPrice] [money] NOT NULL CONSTRAINT [DF_POQOrderDetails_DisplayPrice] DEFAULT ((0)),
[DisplayAmount] [money] NOT NULL CONSTRAINT [DF_POQOrderDetails_DisplayAmount] DEFAULT ((0)),
[KitComponentQuantity] [decimal] (18, 6) NULL,
[KitComponentWeighting] [decimal] (18, 6) NULL,
[TrackKitDiscount] [bit] NOT NULL CONSTRAINT [DF_POQOrderDetails_TrackKitDiscount] DEFAULT ((0)),
[KitDiscount] [money] NOT NULL CONSTRAINT [DF_POQOrderDetails_KitDiscount] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POQOrderDetails] ADD CONSTRAINT [PK_POQOrderDetails] PRIMARY KEY CLUSTERED  ([POQID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POQOrderDetails] ADD CONSTRAINT [FK_POQOrderDetails_AdjDeptID_GLDepts3] FOREIGN KEY ([AdjDeptID]) REFERENCES [dbo].[GLDepts3] ([DeptID])
GO
ALTER TABLE [dbo].[POQOrderDetails] ADD CONSTRAINT [FK_POQOrderDetails_AdjGLID_GLAccounts3] FOREIGN KEY ([AdjGLID]) REFERENCES [dbo].[GLAccounts3] ([AccountID])
GO
ALTER TABLE [dbo].[POQOrderDetails] ADD CONSTRAINT [FK_POQOrderDetails_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[POQOrderDetails] ADD CONSTRAINT [FK_POQOrderDetails_DeptID_GLDepts3] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts3] ([DeptID])
GO
ALTER TABLE [dbo].[POQOrderDetails] ADD CONSTRAINT [FK_POQOrderDetails_GLID_GLAccounts3] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts3] ([AccountID])
GO
ALTER TABLE [dbo].[POQOrderDetails] ADD CONSTRAINT [FK_POQOrderDetails_ItemID_ICItems1] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems1] ([ItemID])
GO
ALTER TABLE [dbo].[POQOrderDetails] ADD CONSTRAINT [FK_POQOrderDetails_POQID_POQOrders] FOREIGN KEY ([POQID]) REFERENCES [dbo].[POQOrders] ([POQID])
GO
ALTER TABLE [dbo].[POQOrderDetails] ADD CONSTRAINT [FK_POQOrderDetails_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO