Tables [dbo].[POOrderDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:27 AM Thursday, March 21, 2019
Last Modified1:13:20 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_POOrderDetails: POID\DetailIDForeign Keys FK_POOrderDetails_POID_POOrderDetails: [dbo].[POOrderDetails].POID\RelatedDetailIDForeign Keys FK_POOrderDetails_POID_POOrders: [dbo].[POOrders].POIDPOIDint4
False
Cluster Primary Key PK_POOrderDetails: POID\DetailIDDetailIDint4
False
Foreign Keys FK_POOrderDetails_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_POOrderDetails_GLID_GLAccounts3: [dbo].[GLAccounts3].GLIDGLIDint4
False
Foreign Keys FK_POOrderDetails_DeptID_GLDepts3: [dbo].[GLDepts3].DeptIDDeptIDint4
True
Foreign Keys FK_POOrderDetails_AdjGLID_GLAccounts3: [dbo].[GLAccounts3].AdjGLIDAdjGLIDint4
True
Foreign Keys FK_POOrderDetails_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))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
False
Foreign Keys FK_POOrderDetails_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
True
Foreign Keys FK_POOrderDetails_StockTypeID_ICStockTypes: [dbo].[ICStockTypes].StockTypeIDStockTypeIDint4
False
((1))
UpdateVendorCostbit1
False
((1))
EstArrivalDatedatetime8
True
EstShipDatedatetime8
True
IsReturnbit1
False
((0))
IsRTVReturnbit1
False
((0))
Foreign Keys FK_POOrderDetails_POID_POOrderDetails: [dbo].[POOrderDetails].POID\RelatedDetailIDRelatedDetailIDint4
True
Foreign Keys FK_POOrderDetails_DetailStatusID_PODetailStatuses: [dbo].[PODetailStatuses].DetailStatusIDDetailStatusIDint4
False
((1))
Arriveddecimal(18,6)9
False
((0))
Transferreddecimal(18,6)9
False
((0))
Disposeddecimal(18,6)9
False
((0))
Shippeddecimal(18,6)9
False
((0))
TransferredAndShippeddecimal(18,6)9
False
((0))
Foreign Keys FK_POOrderDetails_OrigPOID_POOrders: [dbo].[POOrders].OrigPOIDOrigPOIDint4
True
OrigPOOrderDetailIDint4
True
OrigPOCostmoney8
False
((0))
HoldNoDaysint4
False
((0))
ReturnNoDaysint4
False
((0))
EarliestDatedatetime8
True
LatestDatedatetime8
True
Remarksvarchar(1024)1024
False
('')
POOrderDetailIDint4
False
1 - 1
Notesvarchar(1024)1024
False
('')
LineNumbervarchar(100)100
True
ParentKitIDint4
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_POOrderDetails: POID\DetailIDPK_POOrderDetailsPOID, DetailID
True
80
NameColumns
FK_POOrderDetails_AdjDeptID_GLDepts3AdjDeptID->[dbo].[GLDepts3].[DeptID]
FK_POOrderDetails_AdjGLID_GLAccounts3AdjGLID->[dbo].[GLAccounts3].[AccountID]
FK_POOrderDetails_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_POOrderDetails_DeptID_GLDepts3DeptID->[dbo].[GLDepts3].[DeptID]
FK_POOrderDetails_DetailStatusID_PODetailStatusesDetailStatusID->[dbo].[PODetailStatuses].[DetailStatusID]
FK_POOrderDetails_GLID_GLAccounts3GLID->[dbo].[GLAccounts3].[AccountID]
FK_POOrderDetails_ItemID_ICItems1ItemID->[dbo].[ICItems1].[ItemID]
FK_POOrderDetails_OrigPOID_POOrdersOrigPOID->[dbo].[POOrders].[POID]
FK_POOrderDetails_POID_POOrderDetailsPOID->[dbo].[POOrderDetails].[POID]
RelatedDetailID->[dbo].[POOrderDetails].[DetailID]
FK_POOrderDetails_POID_POOrdersPOID->[dbo].[POOrders].[POID]
FK_POOrderDetails_StockTypeID_ICStockTypesStockTypeID->[dbo].[ICStockTypes].[StockTypeID]
CREATE TABLE [dbo].[POOrderDetails]
(
[POID] [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,
[GLID] [int] NOT NULL,
[DeptID] [int] NULL,
[AdjGLID] [int] NULL,
[AdjDeptID] [int] NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_POOrderDetails_Amount] DEFAULT ((0)),
[BackOrdered] [decimal] (18, 6) NOT NULL,
[Received] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetails_Received] DEFAULT ((0)),
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetails_Canceled] DEFAULT ((0)),
[UnReceived] [money] NOT NULL CONSTRAINT [DF_POOrderDetails_UnReceived] DEFAULT ((0)),
[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_POOrderDetails_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_POOrderDetails_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[BranchID] [int] NULL,
[StockTypeID] [int] NOT NULL CONSTRAINT [DF_POOrderDetails_StockTypeID] DEFAULT ((1)),
[UpdateVendorCost] [bit] NOT NULL CONSTRAINT [DF_POOrderDetails_UpdateVendorCost] DEFAULT ((1)),
[EstArrivalDate] [datetime] NULL,
[EstShipDate] [datetime] NULL,
[IsReturn] [bit] NOT NULL CONSTRAINT [DF_POOrderDetails_IsReturn] DEFAULT ((0)),
[IsRTVReturn] [bit] NOT NULL CONSTRAINT [DF_POOrderDetails_IsRTVReturn] DEFAULT ((0)),
[RelatedDetailID] [int] NULL,
[DetailStatusID] [int] NOT NULL CONSTRAINT [DF_POOrderDetails_DetailStatusID] DEFAULT ((1)),
[Arrived] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetails_Arrived] DEFAULT ((0)),
[Transferred] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetails_Transferred] DEFAULT ((0)),
[Disposed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetails_Disposed] DEFAULT ((0)),
[Shipped] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetails_Shipped] DEFAULT ((0)),
[TransferredAndShipped] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POOrderDetails_TransferredAndShipped] DEFAULT ((0)),
[OrigPOID] [int] NULL,
[OrigPOOrderDetailID] [int] NULL,
[OrigPOCost] [money] NOT NULL CONSTRAINT [DF_POOrderDetails_OrigPOCost] DEFAULT ((0)),
[HoldNoDays] [int] NOT NULL CONSTRAINT [DF_POOrderDetails_HoldNoDays] DEFAULT ((0)),
[ReturnNoDays] [int] NOT NULL CONSTRAINT [DF_POOrderDetails_ReturnNoDays] DEFAULT ((0)),
[EarliestDate] [datetime] NULL,
[LatestDate] [datetime] NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrderDetails_Remarks] DEFAULT (''),
[POOrderDetailID] [int] NOT NULL IDENTITY(1, 1),
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POOrderDetails_Notes] DEFAULT (''),
[LineNumber] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ParentKitID] [int] NULL,
[DisplayPrice] [money] NOT NULL CONSTRAINT [DF_POOrderDetails_DisplayPrice] DEFAULT ((0)),
[DisplayAmount] [money] NOT NULL CONSTRAINT [DF_POOrderDetails_DisplayAmount] DEFAULT ((0)),
[KitComponentQuantity] [decimal] (18, 6) NULL,
[KitComponentWeighting] [decimal] (18, 6) NULL,
[TrackKitDiscount] [bit] NOT NULL CONSTRAINT [DF_POOrderDetails_TrackKitDiscount] DEFAULT ((0)),
[KitDiscount] [money] NOT NULL CONSTRAINT [DF_POOrderDetails_KitDiscount] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POOrderDetails] ADD CONSTRAINT [PK_POOrderDetails] PRIMARY KEY CLUSTERED  ([POID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POOrderDetails] ADD CONSTRAINT [FK_POOrderDetails_AdjDeptID_GLDepts3] FOREIGN KEY ([AdjDeptID]) REFERENCES [dbo].[GLDepts3] ([DeptID])
GO
ALTER TABLE [dbo].[POOrderDetails] ADD CONSTRAINT [FK_POOrderDetails_AdjGLID_GLAccounts3] FOREIGN KEY ([AdjGLID]) REFERENCES [dbo].[GLAccounts3] ([AccountID])
GO
ALTER TABLE [dbo].[POOrderDetails] ADD CONSTRAINT [FK_POOrderDetails_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[POOrderDetails] ADD CONSTRAINT [FK_POOrderDetails_DeptID_GLDepts3] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts3] ([DeptID])
GO
ALTER TABLE [dbo].[POOrderDetails] ADD CONSTRAINT [FK_POOrderDetails_DetailStatusID_PODetailStatuses] FOREIGN KEY ([DetailStatusID]) REFERENCES [dbo].[PODetailStatuses] ([DetailStatusID])
GO
ALTER TABLE [dbo].[POOrderDetails] ADD CONSTRAINT [FK_POOrderDetails_GLID_GLAccounts3] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts3] ([AccountID])
GO
ALTER TABLE [dbo].[POOrderDetails] ADD CONSTRAINT [FK_POOrderDetails_ItemID_ICItems1] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems1] ([ItemID])
GO
ALTER TABLE [dbo].[POOrderDetails] ADD CONSTRAINT [FK_POOrderDetails_OrigPOID_POOrders] FOREIGN KEY ([OrigPOID]) REFERENCES [dbo].[POOrders] ([POID])
GO
ALTER TABLE [dbo].[POOrderDetails] ADD CONSTRAINT [FK_POOrderDetails_POID_POOrderDetails] FOREIGN KEY ([POID], [RelatedDetailID]) REFERENCES [dbo].[POOrderDetails] ([POID], [DetailID])
GO
ALTER TABLE [dbo].[POOrderDetails] ADD CONSTRAINT [FK_POOrderDetails_POID_POOrders] FOREIGN KEY ([POID]) REFERENCES [dbo].[POOrders] ([POID])
GO
ALTER TABLE [dbo].[POOrderDetails] ADD CONSTRAINT [FK_POOrderDetails_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO