Tables [dbo].[POReceiptDetailShipmentLinks]
PropertyValue
Row Count (~)0
Created12:58:31 AM Thursday, March 21, 2019
Last Modified1:13:23 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_POReceiptDetailShipmentLinks: ReceiptDetailShipmentLinkIDReceiptDetailShipmentLinkIDint4
False
1 - 1
Foreign Keys FK_POReceiptDetailShipmentLinks_ReceiptID_POReceiptDetails: [dbo].[POReceiptDetails].ReceiptID\ReceiptDetailIDReceiptIDint4
False
Foreign Keys FK_POReceiptDetailShipmentLinks_ReceiptID_POReceiptDetails: [dbo].[POReceiptDetails].ReceiptID\ReceiptDetailIDReceiptDetailIDint4
False
Foreign Keys FK_POReceiptDetailShipmentLinks_POShipmentDetailID_POShipmentDetails: [dbo].[POShipmentDetails].POShipmentDetailIDPOShipmentDetailIDint4
False
Foreign Keys FK_POReceiptDetailShipmentLinks_POShipmentDetailBinID_POShipmentDetailBins: [dbo].[POShipmentDetailBins].POShipmentDetailBinIDPOShipmentDetailBinIDint4
True
QuantityReceiveddecimal(18,6)9
False
CreateDatedatetime8
False
(getdate())
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_POReceiptDetailShipmentLinks: ReceiptDetailShipmentLinkIDPK_POReceiptDetailShipmentLinksReceiptDetailShipmentLinkID
True
80
NameColumns
FK_POReceiptDetailShipmentLinks_POShipmentDetailBinID_POShipmentDetailBinsPOShipmentDetailBinID->[dbo].[POShipmentDetailBins].[POShipmentDetailBinID]
FK_POReceiptDetailShipmentLinks_POShipmentDetailID_POShipmentDetailsPOShipmentDetailID->[dbo].[POShipmentDetails].[POShipmentDetailID]
FK_POReceiptDetailShipmentLinks_ReceiptID_POReceiptDetailsReceiptID->[dbo].[POReceiptDetails].[ReceiptID]
ReceiptDetailID->[dbo].[POReceiptDetails].[DetailID]
CREATE TABLE [dbo].[POReceiptDetailShipmentLinks]
(
[ReceiptDetailShipmentLinkID] [int] NOT NULL IDENTITY(1, 1),
[ReceiptID] [int] NOT NULL,
[ReceiptDetailID] [int] NOT NULL,
[POShipmentDetailID] [int] NOT NULL,
[POShipmentDetailBinID] [int] NULL,
[QuantityReceived] [decimal] (18, 6) NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_POReceiptDetailShipmentLinks_CreateDate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POReceiptDetailShipmentLinks] ADD CONSTRAINT [PK_POReceiptDetailShipmentLinks] PRIMARY KEY CLUSTERED  ([ReceiptDetailShipmentLinkID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POReceiptDetailShipmentLinks] ADD CONSTRAINT [FK_POReceiptDetailShipmentLinks_POShipmentDetailBinID_POShipmentDetailBins] FOREIGN KEY ([POShipmentDetailBinID]) REFERENCES [dbo].[POShipmentDetailBins] ([POShipmentDetailBinID])
GO
ALTER TABLE [dbo].[POReceiptDetailShipmentLinks] ADD CONSTRAINT [FK_POReceiptDetailShipmentLinks_POShipmentDetailID_POShipmentDetails] FOREIGN KEY ([POShipmentDetailID]) REFERENCES [dbo].[POShipmentDetails] ([POShipmentDetailID])
GO
ALTER TABLE [dbo].[POReceiptDetailShipmentLinks] ADD CONSTRAINT [FK_POReceiptDetailShipmentLinks_ReceiptID_POReceiptDetails] FOREIGN KEY ([ReceiptID], [ReceiptDetailID]) REFERENCES [dbo].[POReceiptDetails] ([ReceiptID], [DetailID])
GO