Tables [dbo].[SOOrderDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:00 AM Thursday, March 21, 2019
Last Modified1:16:11 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SOOrderDetails: SOID\DetailIDForeign Keys FK_SOOrderDetails_SOID_SOOrderDetails: [dbo].[SOOrderDetails].SOID\RelatedDetailIDForeign Keys FK_SOOrderDetails_SOID_SOOrders: [dbo].[SOOrders].SOIDSOIDint4
False
Cluster Primary Key PK_SOOrderDetails: SOID\DetailIDDetailIDint4
False
Foreign Keys FK_SOOrderDetails_ItemID_ICItems1: [dbo].[ICItems1].ItemIDItemIDint4
False
Descriptionvarchar(255)255
False
Quantitydecimal(18,6)9
False
Foreign Keys FK_SOOrderDetails_UMID_ICUnits: [dbo].[ICUnits].UMIDUMIDint4
False
UMvarchar(255)255
False
ConvFactordecimal(16,6)9
False
Pricemoney8
False
Foreign Keys FK_SOOrderDetails_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
Foreign Keys FK_SOOrderDetails_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
True
BSABillForServicesbit1
False
Billbit1
False
Discountdecimal(18,6)9
False
Stockedbit1
False
Foreign Keys FK_SOOrderDetails_GLID_GLAccounts3: [dbo].[GLAccounts3].GLIDGLIDint4
False
Foreign Keys FK_SOOrderDetails_DeptID_GLDepts3: [dbo].[GLDepts3].DeptIDDeptIDint4
True
Amountmoney8
False
((0))
EarnedAmountmoney8
False
((0))
TaxFlagint4
False
Foreign Keys FK_SOOrderDetails_CostGLID_GLAccounts3: [dbo].[GLAccounts3].CostGLIDCostGLIDint4
True
Foreign Keys FK_SOOrderDetails_CostDeptID_GLDepts3: [dbo].[GLDepts3].CostDeptIDCostDeptIDint4
True
Foreign Keys FK_SOOrderDetails_CostAppliedGLID_GLAccounts3: [dbo].[GLAccounts3].CostAppliedGLIDCostAppliedGLIDint4
True
Foreign Keys FK_SOOrderDetails_CostAppliedDeptID_GLDepts3: [dbo].[GLDepts3].CostAppliedDeptIDCostAppliedDeptIDint4
True
Foreign Keys FK_SOOrderDetails_UnearnedRevenueGLID_GLAccounts3: [dbo].[GLAccounts3].UnearnedRevenueGLIDUnearnedRevenueGLIDint4
True
Costmoney8
False
BackOrdereddecimal(18,6)9
False
Picketeddecimal(18,6)9
False
((0))
Shippeddecimal(18,6)9
False
((0))
Canceleddecimal(18,6)9
False
((0))
Billeddecimal(18,6)9
False
((0))
PreBilleddecimal(18,6)9
False
((0))
Foreign Keys FK_SOOrderDetails_WorkOrderID_ICWorkOrders: [dbo].[ICWorkOrders].WorkOrderIDWorkOrderIDint4
True
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
False
Foreign Keys FK_SOOrderDetails_PriceSourceID_ARPriceSources: [dbo].[ARPriceSources].PriceSourceIDPriceSourceIDint4
False
((1))
SystemComputedPricemoney8
False
((0))
Foreign Keys FK_SOOrderDetails_ReturnCodeID_ICReturnCodes: [dbo].[ICReturnCodes].ReturnCodeIDReturnCodeIDint4
True
ReturnRemarksvarchar(255)255
False
('')
Foreign Keys FK_SOOrderDetails_StockTypeID_ICStockTypes: [dbo].[ICStockTypes].StockTypeIDStockTypeIDint4
False
((1))
OverriddenCostbit1
False
((0))
ChargeOutCostmoney8
False
((0))
Foreign Keys FK_SOOrderDetails_ContractItemLimitID_SCContractItemLimits: [dbo].[SCContractItemLimits].ContractItemLimitIDContractItemLimitIDint4
True
SerialNumbervarchar(50)50
True
ParentDetailIDint4
True
Fulfilleddecimal(18,6)9
False
((0))
Remarksvarchar(1024)1024
False
('')
IsReturnbit1
False
((0))
IsRMAReturnbit1
False
((0))
Foreign Keys FK_SOOrderDetails_SOID_SOOrderDetails: [dbo].[SOOrderDetails].SOID\RelatedDetailIDRelatedDetailIDint4
True
Foreign Keys FK_SOOrderDetails_DetailStatusID_SODetailStatuses: [dbo].[SODetailStatuses].DetailStatusIDDetailStatusIDint4
False
((1))
Foreign Keys FK_SOOrderDetails_OrigVendorID_APVendors: [dbo].[APVendors].OrigVendorIDOrigVendorIDint4
True
Foreign Keys FK_SOOrderDetails_OrigPOID_POOrders: [dbo].[POOrders].OrigPOIDOrigPOIDint4
True
OrigPOOrderDetailIDint4
True
OrigPOCostmoney8
False
((0))
TrackingNumbervarchar(64)64
False
('')
HoldNoDaysint4
False
((0))
ReturnNoDaysint4
False
((0))
EarliestDatedatetime8
True
LatestDatedatetime8
True
CalculatedOutCostmoney8
False
((0))
OutCostmoney8
False
((0))
UseBaseOutCostbit1
False
((0))
OverrideOutCostbit1
False
((0))
OutCostRatedecimal(18,6)9
False
((0))
OutCostExtendedmoney8
False
((0))
Notesvarchar(1024)1024
False
('')
ParentIDint4
True
RollUpPricebit1
False
((0))
Hiddenbit1
False
((0))
SortOrderint4
False
((0))
Depthsmallint2
False
((0))
Foreign Keys FK_SOOrderDetails_ShipToContactID_CMContacts: [dbo].[CMContacts].ShipToContactIDShipToContactIDint4
True
LineNumbervarchar(100)100
True
ParentKitIDint4
True
DisplayPricemoney8
False
((0))
DisplayAmountmoney8
False
((0))
DisplayDiscountdecimal(18,6)9
False
((0))
KitComponentQuantitydecimal(18,6)9
True
KitComponentWeightingdecimal(18,6)9
True
TrackKitDiscountbit1
False
((0))
UnitCostmoney8
False
((0))
Foreign Keys FK_SOOrderDetails_ContractDetailID_SCContractDetails: [dbo].[SCContractDetails].ContractDetailIDContractDetailIDint4
True
ContractDetailLinkFlagint4
True
Foreign Keys FK_SOOrderDetails_ConfigQuoteDetailID_SAConfigQuoteDetails: [dbo].[SAConfigQuoteDetails].ConfigQuoteDetailIDConfigQuoteDetailIDint4
True
Foreign Keys FK_SOOrderDetails_TaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].TaxFlagIDTaxFlagIDint4
False
HideOnPackingListbit1
False
((0))
HideOnPickingListbit1
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SOOrderDetails: SOID\DetailIDPK_SOOrderDetailsSOID, DetailID
True
80
NameColumns
FK_SOOrderDetails_ConfigQuoteDetailID_SAConfigQuoteDetailsConfigQuoteDetailID->[dbo].[SAConfigQuoteDetails].[ConfigQuoteDetailID]
FK_SOOrderDetails_ContractDetailID_SCContractDetailsContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
FK_SOOrderDetails_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
FK_SOOrderDetails_ContractItemLimitID_SCContractItemLimitsContractItemLimitID->[dbo].[SCContractItemLimits].[ContractItemLimitID]
FK_SOOrderDetails_CostAppliedDeptID_GLDepts3CostAppliedDeptID->[dbo].[GLDepts3].[DeptID]
FK_SOOrderDetails_CostAppliedGLID_GLAccounts3CostAppliedGLID->[dbo].[GLAccounts3].[AccountID]
FK_SOOrderDetails_CostDeptID_GLDepts3CostDeptID->[dbo].[GLDepts3].[DeptID]
FK_SOOrderDetails_CostGLID_GLAccounts3CostGLID->[dbo].[GLAccounts3].[AccountID]
FK_SOOrderDetails_DeptID_GLDepts3DeptID->[dbo].[GLDepts3].[DeptID]
FK_SOOrderDetails_DetailStatusID_SODetailStatusesDetailStatusID->[dbo].[SODetailStatuses].[DetailStatusID]
FK_SOOrderDetails_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SOOrderDetails_GLID_GLAccounts3GLID->[dbo].[GLAccounts3].[AccountID]
FK_SOOrderDetails_ItemID_ICItems1ItemID->[dbo].[ICItems1].[ItemID]
FK_SOOrderDetails_OrigPOID_POOrdersOrigPOID->[dbo].[POOrders].[POID]
FK_SOOrderDetails_OrigVendorID_APVendorsOrigVendorID->[dbo].[APVendors].[VendorID]
FK_SOOrderDetails_PriceSourceID_ARPriceSourcesPriceSourceID->[dbo].[ARPriceSources].[PriceSourceID]
FK_SOOrderDetails_ReturnCodeID_ICReturnCodesReturnCodeID->[dbo].[ICReturnCodes].[ReturnCodeID]
FK_SOOrderDetails_ShipToContactID_CMContactsShipToContactID->[dbo].[CMContacts].[ContactID]
FK_SOOrderDetails_SOID_SOOrderDetailsSOID->[dbo].[SOOrderDetails].[SOID]
RelatedDetailID->[dbo].[SOOrderDetails].[DetailID]
FK_SOOrderDetails_SOID_SOOrdersSOID->[dbo].[SOOrders].[SOID]
FK_SOOrderDetails_StockTypeID_ICStockTypesStockTypeID->[dbo].[ICStockTypes].[StockTypeID]
FK_SOOrderDetails_TaxFlagID_ShTaxFlagsTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SOOrderDetails_UMID_ICUnitsUMID->[dbo].[ICUnits].[ID]
FK_SOOrderDetails_UnearnedRevenueGLID_GLAccounts3UnearnedRevenueGLID->[dbo].[GLAccounts3].[AccountID]
FK_SOOrderDetails_WorkOrderID_ICWorkOrdersWorkOrderID->[dbo].[ICWorkOrders].[WorkOrderID]
CREATE TABLE [dbo].[SOOrderDetails]
(
[SOID] [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,
[UMID] [int] NOT NULL,
[UM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ConvFactor] [decimal] (16, 6) NOT NULL,
[Price] [money] NOT NULL,
[EquipmentID] [int] NULL,
[ContractID] [int] NULL,
[BSABillForServices] [bit] NOT NULL,
[Bill] [bit] NOT NULL,
[Discount] [decimal] (18, 6) NOT NULL,
[Stocked] [bit] NOT NULL,
[GLID] [int] NOT NULL,
[DeptID] [int] NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_SOOrderDetails_Amount] DEFAULT ((0)),
[EarnedAmount] [money] NOT NULL CONSTRAINT [DF_SOOrderDetails_EarnedAmount] DEFAULT ((0)),
[TaxFlag] [int] NOT NULL,
[CostGLID] [int] NULL,
[CostDeptID] [int] NULL,
[CostAppliedGLID] [int] NULL,
[CostAppliedDeptID] [int] NULL,
[UnearnedRevenueGLID] [int] NULL,
[Cost] [money] NOT NULL,
[BackOrdered] [decimal] (18, 6) NOT NULL,
[Picketed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOOrderDetails_Picketed] DEFAULT ((0)),
[Shipped] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOOrderDetails_Shipped] DEFAULT ((0)),
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOOrderDetails_Canceled] DEFAULT ((0)),
[Billed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOOrderDetails_Billed] DEFAULT ((0)),
[PreBilled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOOrderDetails_PreBilled] DEFAULT ((0)),
[WorkOrderID] [int] 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_SOOrderDetails_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SOOrderDetails_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[PriceSourceID] [int] NOT NULL CONSTRAINT [DF_SOOrderDetails_PriceSourceID] DEFAULT ((1)),
[SystemComputedPrice] [money] NOT NULL CONSTRAINT [DF_SOOrderDetails_SystemComputedPrice] DEFAULT ((0)),
[ReturnCodeID] [int] NULL,
[ReturnRemarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOOrderDetails_ReturnRemarks] DEFAULT (''),
[StockTypeID] [int] NOT NULL CONSTRAINT [DF_SOOrderDetails_StockTypeID] DEFAULT ((1)),
[OverriddenCost] [bit] NOT NULL CONSTRAINT [DF_SOOrderDetails_OverriddenCost] DEFAULT ((0)),
[ChargeOutCost] [money] NOT NULL CONSTRAINT [DF_SOOrderDetails_ChargeOutCost] DEFAULT ((0)),
[ContractItemLimitID] [int] NULL,
[SerialNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ParentDetailID] [int] NULL,
[Fulfilled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOOrderDetails_FulFilled] DEFAULT ((0)),
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOOrderDetails_Remarks] DEFAULT (''),
[IsReturn] [bit] NOT NULL CONSTRAINT [DF_SOOrderDetails_IsReturn] DEFAULT ((0)),
[IsRMAReturn] [bit] NOT NULL CONSTRAINT [DF_SOOrderDetails_IsRMAReturn] DEFAULT ((0)),
[RelatedDetailID] [int] NULL,
[DetailStatusID] [int] NOT NULL CONSTRAINT [DF_SOOrderDetails_DetailStatusID] DEFAULT ((1)),
[OrigVendorID] [int] NULL,
[OrigPOID] [int] NULL,
[OrigPOOrderDetailID] [int] NULL,
[OrigPOCost] [money] NOT NULL CONSTRAINT [DF_SOOrderDetails_OrigPOCost] DEFAULT ((0)),
[TrackingNumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOOrderDetails_TrackingNumber] DEFAULT (''),
[HoldNoDays] [int] NOT NULL CONSTRAINT [DF_SOOrderDetails_HoldNoDays] DEFAULT ((0)),
[ReturnNoDays] [int] NOT NULL CONSTRAINT [DF_SOOrderDetails_ReturnNoDays] DEFAULT ((0)),
[EarliestDate] [datetime] NULL,
[LatestDate] [datetime] NULL,
[CalculatedOutCost] [money] NOT NULL CONSTRAINT [DF_SOOrderDetails_CalculatedOutCost] DEFAULT ((0)),
[OutCost] [money] NOT NULL CONSTRAINT [DF_SOOrderDetails_OutCost] DEFAULT ((0)),
[UseBaseOutCost] [bit] NOT NULL CONSTRAINT [DF_SOOrderDetails_UseBaseOutCost] DEFAULT ((0)),
[OverrideOutCost] [bit] NOT NULL CONSTRAINT [DF_SOOrderDetails_OverrideOutCost] DEFAULT ((0)),
[OutCostRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOOrderDetails_OutCostRate] DEFAULT ((0)),
[OutCostExtended] [money] NOT NULL CONSTRAINT [DF_SOOrderDetails_OutCostExtended] DEFAULT ((0)),
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOOrderDetails_Notes] DEFAULT (''),
[ParentID] [int] NULL,
[RollUpPrice] [bit] NOT NULL CONSTRAINT [DF_SOOrderDetails_RollUpPrice] DEFAULT ((0)),
[Hidden] [bit] NOT NULL CONSTRAINT [DF_SOOrderDetails_Hidden] DEFAULT ((0)),
[SortOrder] [int] NOT NULL CONSTRAINT [DF_SOOrderDetails_SortOrder] DEFAULT ((0)),
[Depth] [smallint] NOT NULL CONSTRAINT [DF_SOOrderDetails_Depth] DEFAULT ((0)),
[ShipToContactID] [int] NULL,
[LineNumber] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ParentKitID] [int] NULL,
[DisplayPrice] [money] NOT NULL CONSTRAINT [DF_SOOrderDetails_DisplayPrice] DEFAULT ((0)),
[DisplayAmount] [money] NOT NULL CONSTRAINT [DF_SOOrderDetails_DisplayAmount] DEFAULT ((0)),
[DisplayDiscount] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOOrderDetails_DisplayDiscount] DEFAULT ((0)),
[KitComponentQuantity] [decimal] (18, 6) NULL,
[KitComponentWeighting] [decimal] (18, 6) NULL,
[TrackKitDiscount] [bit] NOT NULL CONSTRAINT [DF_SOOrderDetails_TrackKitDiscount] DEFAULT ((0)),
[UnitCost] [money] NOT NULL CONSTRAINT [DF_SOOrderDetails_UnitCost] DEFAULT ((0)),
[ContractDetailID] [int] NULL,
[ContractDetailLinkFlag] [int] NULL,
[ConfigQuoteDetailID] [int] NULL,
[TaxFlagID] [int] NOT NULL,
[HideOnPackingList] [bit] NOT NULL CONSTRAINT [DF_SOOrderDetails_HideOnPackingList] DEFAULT ((0)),
[HideOnPickingList] [bit] NOT NULL CONSTRAINT [DF_SOOrderDetails_HideOnPickingList] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [PK_SOOrderDetails] PRIMARY KEY CLUSTERED  ([SOID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_ConfigQuoteDetailID_SAConfigQuoteDetails] FOREIGN KEY ([ConfigQuoteDetailID]) REFERENCES [dbo].[SAConfigQuoteDetails] ([ConfigQuoteDetailID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_ContractDetailID_SCContractDetails] FOREIGN KEY ([ContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_ContractItemLimitID_SCContractItemLimits] FOREIGN KEY ([ContractItemLimitID]) REFERENCES [dbo].[SCContractItemLimits] ([ContractItemLimitID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_CostAppliedDeptID_GLDepts3] FOREIGN KEY ([CostAppliedDeptID]) REFERENCES [dbo].[GLDepts3] ([DeptID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_CostAppliedGLID_GLAccounts3] FOREIGN KEY ([CostAppliedGLID]) REFERENCES [dbo].[GLAccounts3] ([AccountID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_CostDeptID_GLDepts3] FOREIGN KEY ([CostDeptID]) REFERENCES [dbo].[GLDepts3] ([DeptID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_CostGLID_GLAccounts3] FOREIGN KEY ([CostGLID]) REFERENCES [dbo].[GLAccounts3] ([AccountID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_DeptID_GLDepts3] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts3] ([DeptID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_DetailStatusID_SODetailStatuses] FOREIGN KEY ([DetailStatusID]) REFERENCES [dbo].[SODetailStatuses] ([DetailStatusID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_GLID_GLAccounts3] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts3] ([AccountID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_ItemID_ICItems1] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems1] ([ItemID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_OrigPOID_POOrders] FOREIGN KEY ([OrigPOID]) REFERENCES [dbo].[POOrders] ([POID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_OrigVendorID_APVendors] FOREIGN KEY ([OrigVendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_PriceSourceID_ARPriceSources] FOREIGN KEY ([PriceSourceID]) REFERENCES [dbo].[ARPriceSources] ([PriceSourceID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_ReturnCodeID_ICReturnCodes] FOREIGN KEY ([ReturnCodeID]) REFERENCES [dbo].[ICReturnCodes] ([ReturnCodeID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_ShipToContactID_CMContacts] FOREIGN KEY ([ShipToContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_SOID_SOOrderDetails] FOREIGN KEY ([SOID], [RelatedDetailID]) REFERENCES [dbo].[SOOrderDetails] ([SOID], [DetailID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_SOID_SOOrders] FOREIGN KEY ([SOID]) REFERENCES [dbo].[SOOrders] ([SOID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_TaxFlagID_ShTaxFlags] FOREIGN KEY ([TaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_UMID_ICUnits] FOREIGN KEY ([UMID]) REFERENCES [dbo].[ICUnits] ([ID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_UnearnedRevenueGLID_GLAccounts3] FOREIGN KEY ([UnearnedRevenueGLID]) REFERENCES [dbo].[GLAccounts3] ([AccountID])
GO
ALTER TABLE [dbo].[SOOrderDetails] ADD CONSTRAINT [FK_SOOrderDetails_WorkOrderID_ICWorkOrders] FOREIGN KEY ([WorkOrderID]) REFERENCES [dbo].[ICWorkOrders] ([WorkOrderID])
GO