Tables [dbo].[POReceiptDetailBins]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:31 AM Thursday, March 21, 2019
Last Modified1:13:15 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Foreign Keys FK_POReceiptDetailBins_ReceiptID_POReceiptDetails: [dbo].[POReceiptDetails].ReceiptID\DetailIDReceiptIDint4
False
Foreign Keys FK_POReceiptDetailBins_ReceiptID_POReceiptDetails: [dbo].[POReceiptDetails].ReceiptID\DetailIDDetailIDint4
False
Foreign Keys FK_POReceiptDetailBins_WarehouseID_ICWarehouses: [dbo].[ICWarehouses].WarehouseIDWarehouseIDint4
False
Foreign Keys FK_POReceiptDetailBins_BinID_ICBins: [dbo].[ICBins].BinIDBinIDint4
False
Quantitydecimal(18,6)9
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
False
Foreign Keys FK_POReceiptDetailBins_PODetailBinID_POOrderDetailBins: [dbo].[POOrderDetailBins].PODetailBinIDPODetailBinIDint4
True
ConvFactordecimal(18,6)9
False
Canceleddecimal(18,6)9
False
((0))
Foreign Keys FK_POReceiptDetailBins_SOID_SOOrders: [dbo].[SOOrders].SOIDSOIDint4
True
Foreign Keys FK_POReceiptDetailBins_SODetailBinID_SOOrderDetailBins: [dbo].[SOOrderDetailBins].SODetailBinIDSODetailBinIDint4
True
Foreign Keys FK_POReceiptDetailBins_CallID_SCCalls: [dbo].[SCCalls].CallIDCallIDint4
True
CallMaterialBinIDint4
True
LinkedTransactionNumbervarchar(32)32
False
('')
Cluster Primary Key PK_POReceiptDetailBins: ReceiptDetailBinIDReceiptDetailBinIDint4
False
1 - 1
Foreign Keys FK_POReceiptDetailBins_RequestID_ICRequestDetails: [dbo].[ICRequestDetails].RequestID\RequestDetailIDRequestIDint4
True
Foreign Keys FK_POReceiptDetailBins_RequestID_ICRequestDetails: [dbo].[ICRequestDetails].RequestID\RequestDetailIDRequestDetailIDint4
True
AppliedReceiptDetailBinIDint4
True
QuantityReverseddecimal(18,6)9
False
((0))
IsReturnbit1
False
((0))
IsRTVReturnbit1
False
((0))
Notesvarchar(1024)1024
False
('')
OrigReceiptDetailBinIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_POReceiptDetailBins: ReceiptDetailBinIDPK_POReceiptDetailBinsReceiptDetailBinID
True
80
NameColumns
FK_POReceiptDetailBins_BinID_ICBinsBinID->[dbo].[ICBins].[BinID]
FK_POReceiptDetailBins_CallID_SCCallsCallID->[dbo].[SCCalls].[CallID]
FK_POReceiptDetailBins_PODetailBinID_POOrderDetailBinsPODetailBinID->[dbo].[POOrderDetailBins].[PODetailBinID]
FK_POReceiptDetailBins_ReceiptID_POReceiptDetailsReceiptID->[dbo].[POReceiptDetails].[ReceiptID]
DetailID->[dbo].[POReceiptDetails].[DetailID]
FK_POReceiptDetailBins_RequestID_ICRequestDetailsRequestID->[dbo].[ICRequestDetails].[RequestID]
RequestDetailID->[dbo].[ICRequestDetails].[DetailID]
FK_POReceiptDetailBins_SODetailBinID_SOOrderDetailBinsSODetailBinID->[dbo].[SOOrderDetailBins].[SODetailBinID]
FK_POReceiptDetailBins_SOID_SOOrdersSOID->[dbo].[SOOrders].[SOID]
FK_POReceiptDetailBins_WarehouseID_ICWarehousesWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
CREATE TABLE [dbo].[POReceiptDetailBins]
(
[ReceiptID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[WarehouseID] [int] NOT NULL,
[BinID] [int] NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[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_POReceiptDetailBins_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_POReceiptDetailBins_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[PODetailBinID] [int] NULL,
[ConvFactor] [decimal] (18, 6) NOT NULL,
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POReceiptDetailBins_Canceled] DEFAULT ((0)),
[SOID] [int] NULL,
[SODetailBinID] [int] NULL,
[CallID] [int] NULL,
[CallMaterialBinID] [int] NULL,
[LinkedTransactionNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POReceiptDetailBins_LinkedTransactionNumber] DEFAULT (''),
[ReceiptDetailBinID] [int] NOT NULL IDENTITY(1, 1),
[RequestID] [int] NULL,
[RequestDetailID] [int] NULL,
[AppliedReceiptDetailBinID] [int] NULL,
[QuantityReversed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POReceiptDetailBins_QuantityReversed] DEFAULT ((0)),
[IsReturn] [bit] NOT NULL CONSTRAINT [DF_POReceiptDetailBins_IsReturn] DEFAULT ((0)),
[IsRTVReturn] [bit] NOT NULL CONSTRAINT [DF_POReceiptDetailBins_IsRTVReturn] DEFAULT ((0)),
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_POReceiptDetailBins_Notes] DEFAULT (''),
[OrigReceiptDetailBinID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [PK_POReceiptDetailBins] PRIMARY KEY CLUSTERED  ([ReceiptDetailBinID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_PODetailBinID_POOrderDetailBins] FOREIGN KEY ([PODetailBinID]) REFERENCES [dbo].[POOrderDetailBins] ([PODetailBinID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_ReceiptID_POReceiptDetails] FOREIGN KEY ([ReceiptID], [DetailID]) REFERENCES [dbo].[POReceiptDetails] ([ReceiptID], [DetailID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_RequestID_ICRequestDetails] FOREIGN KEY ([RequestID], [RequestDetailID]) REFERENCES [dbo].[ICRequestDetails] ([RequestID], [DetailID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_SODetailBinID_SOOrderDetailBins] FOREIGN KEY ([SODetailBinID]) REFERENCES [dbo].[SOOrderDetailBins] ([SODetailBinID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_SOID_SOOrders] FOREIGN KEY ([SOID]) REFERENCES [dbo].[SOOrders] ([SOID])
GO
ALTER TABLE [dbo].[POReceiptDetailBins] ADD CONSTRAINT [FK_POReceiptDetailBins_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO