Tables [dbo].[SOHFulFillDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:46 AM Thursday, March 21, 2019
Last Modified1:15:50 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_SOHFulFillDetails: HFulfillID\DetailIDForeign Keys FK_SOHFulFillDetails_HFulfillID_SOHFulFills: [dbo].[SOHFulFills].HFulfillIDHFulfillIDint4
False
Cluster Primary Key PK_SOHFulFillDetails: HFulfillID\DetailIDDetailIDint4
False
Foreign Keys FK_SOHFulFillDetails_SOID_SOOrderDetails: [dbo].[SOOrderDetails].SOID\SODetailIDSOIDint4
True
SONumbervarchar(15)15
True
Foreign Keys FK_SOHFulFillDetails_SOID_SOOrderDetails: [dbo].[SOOrderDetails].SOID\SODetailIDSODetailIDint4
True
Foreign Keys FK_SOHFulFillDetails_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
True
Itemvarchar(255)255
True
ConvFactordecimal(18,0)9
True
SerialNumbervarchar(30)30
True
Stockedbit1
True
Quantitydecimal(18,0)9
True
Foreign Keys FK_SOHFulFillDetails_UMID_ICUnits: [dbo].[ICUnits].UMIDUMIDint4
True
UMvarchar(255)255
True
Pricemoney8
True
Discountdecimal(18,0)9
True
Foreign Keys FK_SOHFulFillDetails_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
EquipmentNumbervarchar(32)32
True
Foreign Keys FK_SOHFulFillDetails_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
True
ContractNumbervarchar(35)35
True
BSABillForServicesbit1
True
Billbit1
True
Amountmoney8
True
Costmoney8
True
Canceleddecimal(18,0)9
True
BackOrdereddecimal(18,0)9
True
Foreign Keys FK_SOHFulFillDetails_EmployeeID_ShAgents: [dbo].[ShAgents].EmployeeIDEmployeeIDint4
True
Employeevarchar(50)50
True
Descriptionvarchar(255)255
True
Foreign Keys FK_SOHFulFillDetails_PriceSourceID_ARPriceSources: [dbo].[ARPriceSources].PriceSourceIDPriceSourceIDint4
True
PriceSourcevarchar(32)32
True
SystemComputedPricemoney8
True
Foreign Keys FK_SOHFulFillDetails_ReturnCodeID_ICReturnCodes: [dbo].[ICReturnCodes].ReturnCodeIDReturnCodeIDint4
True
ReturnCodevarchar(15)15
True
ReturnRemarksvarchar(255)255
True
StockTypevarchar(15)15
True
OverriddenCostbit1
True
Foreign Keys FK_SOHFulFillDetails_ContractItemLimitID_SCContractItemLimits: [dbo].[SCContractItemLimits].ContractItemLimitIDContractItemLimitIDint4
True
Foreign Keys FK_SOHFulFillDetails_HShipmentID_SOHShipments: [dbo].[SOHShipments].HShipmentIDHShipmentIDint4
True
HShipmentNumbervarchar(32)32
True
ShipQuantitydecimal(18,0)9
True
ShipQuantityFulfilleddecimal(18,0)9
True
ShipQuantityReverseddecimal(18,0)9
True
ShipAmountmoney8
True
FulFillDescriptionvarchar(255)255
True
RMAbit1
True
SerialNumberWasAllocatedbit1
True
Foreign Keys FK_SOHFulFillDetails_HInvoiceID_ARHInvoices: [dbo].[ARHInvoices].HInvoiceIDHInvoiceIDint4
True
HInvoiceNumbervarchar(32)32
True
BillQuantitydecimal(18,0)9
True
BillAmountmoney8
True
TaxFlagint4
True
Ordereddecimal(18,0)9
True
IsReturnbit1
True
IsRMAReturnbit1
True
Remarksvarchar(1024)1024
True
Notesvarchar(1024)1024
True
CalculatedOutCostmoney8
True
OutCostmoney8
True
UseBaseOutCostbit1
True
OverrideOutCostbit1
True
OutCostExtendedmoney8
True
OutCostRatedecimal(18,0)9
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SOHFulFillDetails: HFulfillID\DetailIDPK_SOHFulFillDetailsHFulfillID, DetailID
True
80
NameColumns
FK_SOHFulFillDetails_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
FK_SOHFulFillDetails_ContractItemLimitID_SCContractItemLimitsContractItemLimitID->[dbo].[SCContractItemLimits].[ContractItemLimitID]
FK_SOHFulFillDetails_EmployeeID_ShAgentsEmployeeID->[dbo].[ShAgents].[AgentID]
FK_SOHFulFillDetails_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SOHFulFillDetails_HFulfillID_SOHFulFillsHFulfillID->[dbo].[SOHFulFills].[HFulfillID]
FK_SOHFulFillDetails_HInvoiceID_ARHInvoicesHInvoiceID->[dbo].[ARHInvoices].[HInvoiceID]
FK_SOHFulFillDetails_HShipmentID_SOHShipmentsHShipmentID->[dbo].[SOHShipments].[HShipmentID]
FK_SOHFulFillDetails_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_SOHFulFillDetails_PriceSourceID_ARPriceSourcesPriceSourceID->[dbo].[ARPriceSources].[PriceSourceID]
FK_SOHFulFillDetails_ReturnCodeID_ICReturnCodesReturnCodeID->[dbo].[ICReturnCodes].[ReturnCodeID]
FK_SOHFulFillDetails_SOID_SOOrderDetailsSOID->[dbo].[SOOrderDetails].[SOID]
SODetailID->[dbo].[SOOrderDetails].[DetailID]
FK_SOHFulFillDetails_UMID_ICUnitsUMID->[dbo].[ICUnits].[ID]
CREATE TABLE [dbo].[SOHFulFillDetails]
(
[HFulfillID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[SOID] [int] NULL,
[SONumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SODetailID] [int] NULL,
[ItemID] [int] NULL,
[Item] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConvFactor] [decimal] (18, 0) NULL,
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Stocked] [bit] NULL,
[Quantity] [decimal] (18, 0) NULL,
[UMID] [int] NULL,
[UM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Price] [money] NULL,
[Discount] [decimal] (18, 0) NULL,
[EquipmentID] [int] NULL,
[EquipmentNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractID] [int] NULL,
[ContractNumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSABillForServices] [bit] NULL,
[Bill] [bit] NULL,
[Amount] [money] NULL,
[Cost] [money] NULL,
[Canceled] [decimal] (18, 0) NULL,
[BackOrdered] [decimal] (18, 0) NULL,
[EmployeeID] [int] NULL,
[Employee] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PriceSourceID] [int] NULL,
[PriceSource] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SystemComputedPrice] [money] NULL,
[ReturnCodeID] [int] NULL,
[ReturnCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReturnRemarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StockType] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OverriddenCost] [bit] NULL,
[ContractItemLimitID] [int] NULL,
[HShipmentID] [int] NULL,
[HShipmentNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipQuantity] [decimal] (18, 0) NULL,
[ShipQuantityFulfilled] [decimal] (18, 0) NULL,
[ShipQuantityReversed] [decimal] (18, 0) NULL,
[ShipAmount] [money] NULL,
[FulFillDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RMA] [bit] NULL,
[SerialNumberWasAllocated] [bit] NULL,
[HInvoiceID] [int] NULL,
[HInvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillQuantity] [decimal] (18, 0) NULL,
[BillAmount] [money] NULL,
[TaxFlag] [int] NULL,
[Ordered] [decimal] (18, 0) NULL,
[IsReturn] [bit] NULL,
[IsRMAReturn] [bit] NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CalculatedOutCost] [money] NULL,
[OutCost] [money] NULL,
[UseBaseOutCost] [bit] NULL,
[OverrideOutCost] [bit] NULL,
[OutCostExtended] [money] NULL,
[OutCostRate] [decimal] (18, 0) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [PK_SOHFulFillDetails] PRIMARY KEY CLUSTERED  ([HFulfillID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_ContractItemLimitID_SCContractItemLimits] FOREIGN KEY ([ContractItemLimitID]) REFERENCES [dbo].[SCContractItemLimits] ([ContractItemLimitID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_EmployeeID_ShAgents] FOREIGN KEY ([EmployeeID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_HFulfillID_SOHFulFills] FOREIGN KEY ([HFulfillID]) REFERENCES [dbo].[SOHFulFills] ([HFulfillID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_HInvoiceID_ARHInvoices] FOREIGN KEY ([HInvoiceID]) REFERENCES [dbo].[ARHInvoices] ([HInvoiceID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_HShipmentID_SOHShipments] FOREIGN KEY ([HShipmentID]) REFERENCES [dbo].[SOHShipments] ([HShipmentID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_PriceSourceID_ARPriceSources] FOREIGN KEY ([PriceSourceID]) REFERENCES [dbo].[ARPriceSources] ([PriceSourceID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_ReturnCodeID_ICReturnCodes] FOREIGN KEY ([ReturnCodeID]) REFERENCES [dbo].[ICReturnCodes] ([ReturnCodeID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_SOID_SOOrderDetails] FOREIGN KEY ([SOID], [SODetailID]) REFERENCES [dbo].[SOOrderDetails] ([SOID], [DetailID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_UMID_ICUnits] FOREIGN KEY ([UMID]) REFERENCES [dbo].[ICUnits] ([ID])
GO