Tables [dbo].[SOFulfillDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:54 AM Thursday, March 21, 2019
Last Modified1:15:46 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SOFulfillDetails: FulfillID\DetailIDForeign Keys FK_SOFulfillDetails_FulfillID_SOFulfills: [dbo].[SOFulfills].FulfillIDForeign Keys FK_SOFulfillDetails_FulfillID_SOFulfillShipTos: [dbo].[SOFulfillShipTos].FulfillID\ShipToDetailIDFulfillIDint4
False
Cluster Primary Key PK_SOFulfillDetails: FulfillID\DetailIDDetailIDint4
False
Foreign Keys FK_SOFulfillDetails_SOID_SOOrderDetails: [dbo].[SOOrderDetails].SOID\SODetailIDSOIDint4
True
Foreign Keys FK_SOFulfillDetails_SOID_SOOrderDetails: [dbo].[SOOrderDetails].SOID\SODetailIDSODetailIDint4
True
Foreign Keys FK_SOFulfillDetails_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
False
ConvFactordecimal(16,6)9
False
SerialNumbervarchar(30)30
False
Stockedbit1
False
Quantitydecimal(18,6)9
False
Foreign Keys FK_SOFulfillDetails_UMID_ICUnits: [dbo].[ICUnits].UMIDUMIDint4
False
Pricemoney8
False
Discountdecimal(18,6)9
False
Foreign Keys FK_SOFulfillDetails_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
Foreign Keys FK_SOFulfillDetails_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
True
BSABillForServicesbit1
False
Billbit1
False
Foreign Keys FK_SOFulfillDetails_GLID_GLAccounts5: [dbo].[GLAccounts5].GLIDGLIDint4
True
Foreign Keys FK_SOFulfillDetails_DeptID_GLDepts5: [dbo].[GLDepts5].DeptIDDeptIDint4
True
Foreign Keys FK_SOFulfillDetails_UnearnedRevenueGLID_GLAccounts5: [dbo].[GLAccounts5].UnearnedRevenueGLIDUnearnedRevenueGLIDint4
True
Amountmoney8
False
((0))
Foreign Keys FK_SOFulfillDetails_CostGLID_GLAccounts5: [dbo].[GLAccounts5].CostGLIDCostGLIDint4
True
Foreign Keys FK_SOFulfillDetails_CostDeptID_GLDepts5: [dbo].[GLDepts5].CostDeptIDCostDeptIDint4
True
Foreign Keys FK_SOFulfillDetails_CostAppliedGLID_GLAccounts5: [dbo].[GLAccounts5].CostAppliedGLIDCostAppliedGLIDint4
True
Foreign Keys FK_SOFulfillDetails_CostAppliedDeptID_GLDepts5: [dbo].[GLDepts5].CostAppliedDeptIDCostAppliedDeptIDint4
True
Costmoney8
False
((0))
Canceleddecimal(18,6)9
False
((0))
BackOrdereddecimal(18,6)9
False
Foreign Keys FK_SOFulfillDetails_EmployeeID_ShAgents: [dbo].[ShAgents].EmployeeIDEmployeeIDint4
True
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
False
Descriptionvarchar(255)255
True
Foreign Keys FK_SOFulfillDetails_PriceSourceID_ARPriceSources: [dbo].[ARPriceSources].PriceSourceIDPriceSourceIDint4
False
((1))
SystemComputedPricemoney8
False
((0))
Foreign Keys FK_SOFulfillDetails_ReturnCodeID_ICReturnCodes: [dbo].[ICReturnCodes].ReturnCodeIDReturnCodeIDint4
True
ReturnRemarksvarchar(255)255
False
('')
Foreign Keys FK_SOFulfillDetails_StockTypeID_ICStockTypes: [dbo].[ICStockTypes].StockTypeIDStockTypeIDint4
False
((1))
OverriddenCostbit1
False
((0))
ChargeOutCostmoney8
False
((0))
Foreign Keys FK_SOFulfillDetails_ContractItemLimitID_SCContractItemLimits: [dbo].[SCContractItemLimits].ContractItemLimitIDContractItemLimitIDint4
True
Foreign Keys FK_SOFulfillDetails_ShipmentID_SOShipments: [dbo].[SOShipments].ShipmentIDShipmentIDint4
True
ShipQuantitydecimal(18,6)9
False
((0))
ShipQuantityFulfilleddecimal(18,6)9
False
((0))
ShipQuantityReverseddecimal(18,6)9
False
((0))
ShipAmountmoney8
False
((0))
FulFillDescriptionvarchar(255)255
True
SerialNumberWasAllocatedbit1
False
((0))
Foreign Keys FK_SOFulfillDetails_InvoiceID_ARInvoices: [dbo].[ARInvoices].InvoiceIDInvoiceIDint4
True
BillQuantitydecimal(18,6)9
False
BillAmountmoney8
False
((0))
TaxFlagint4
False
UMvarchar(255)255
False
('')
Ordereddecimal(18,6)9
False
IsReturnbit1
False
((0))
IsRMAReturnbit1
False
((0))
CalculatedOutCostmoney8
False
((0))
OutCostmoney8
False
((0))
UseBaseOutCostbit1
False
((0))
OverrideOutCostbit1
False
((0))
OutCostExtendedmoney8
False
((0))
OutCostRatedecimal(18,6)9
False
((0))
Remarksvarchar(1024)1024
False
('')
Notesvarchar(1024)1024
False
('')
ParentIDint4
True
RollUpPricebit1
False
((0))
Hiddenbit1
False
((0))
SortOrderint4
False
((0))
Depthsmallint2
False
((0))
Foreign Keys FK_SOFulfillDetails_ShipToContactID_CMContacts: [dbo].[CMContacts].ShipToContactIDShipToContactIDint4
True
Foreign Keys FK_SOFulfillDetails_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SOFulfillDetails_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_SOFulfillDetails_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Foreign Keys FK_SOFulfillDetails_IntercompanyGLID_GLAccounts: [dbo].[GLAccounts].IntercompanyGLIDIntercompanyGLIDint4
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))
LocationNotesvarchar(255)255
True
UnitCostmoney8
False
((0))
Foreign Keys FK_SOFulfillDetails_FulfillID_SOFulfillShipTos: [dbo].[SOFulfillShipTos].FulfillID\ShipToDetailIDShipToDetailIDint4
False
((1))
Foreign Keys FK_SOFulfillDetails_ContractDetailID_SCContractDetails: [dbo].[SCContractDetails].ContractDetailIDContractDetailIDint4
True
ContractDetailLinkFlagint4
True
Foreign Keys FK_SOFulfillDetails_TaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].TaxFlagIDTaxFlagIDint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SOFulfillDetails: FulfillID\DetailIDPK_SOFulfillDetailsFulfillID, DetailID
True
80
NameColumns
FK_SOFulfillDetails_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SOFulfillDetails_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SOFulfillDetails_ContractDetailID_SCContractDetailsContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
FK_SOFulfillDetails_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
FK_SOFulfillDetails_ContractItemLimitID_SCContractItemLimitsContractItemLimitID->[dbo].[SCContractItemLimits].[ContractItemLimitID]
FK_SOFulfillDetails_CostAppliedDeptID_GLDepts5CostAppliedDeptID->[dbo].[GLDepts5].[DeptID]
FK_SOFulfillDetails_CostAppliedGLID_GLAccounts5CostAppliedGLID->[dbo].[GLAccounts5].[AccountID]
FK_SOFulfillDetails_CostDeptID_GLDepts5CostDeptID->[dbo].[GLDepts5].[DeptID]
FK_SOFulfillDetails_CostGLID_GLAccounts5CostGLID->[dbo].[GLAccounts5].[AccountID]
FK_SOFulfillDetails_DeptID_GLDepts5DeptID->[dbo].[GLDepts5].[DeptID]
FK_SOFulfillDetails_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SOFulfillDetails_EmployeeID_ShAgentsEmployeeID->[dbo].[ShAgents].[AgentID]
FK_SOFulfillDetails_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SOFulfillDetails_FulfillID_SOFulfillsFulfillID->[dbo].[SOFulfills].[FulfillID]
FK_SOFulfillDetails_FulfillID_SOFulfillShipTosFulfillID->[dbo].[SOFulfillShipTos].[FulfillID]
ShipToDetailID->[dbo].[SOFulfillShipTos].[DetailID]
FK_SOFulfillDetails_GLID_GLAccounts5GLID->[dbo].[GLAccounts5].[AccountID]
FK_SOFulfillDetails_IntercompanyGLID_GLAccountsIntercompanyGLID->[dbo].[GLAccounts].[AccountID]
FK_SOFulfillDetails_InvoiceID_ARInvoicesInvoiceID->[dbo].[ARInvoices].[InvoiceID]
FK_SOFulfillDetails_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_SOFulfillDetails_PriceSourceID_ARPriceSourcesPriceSourceID->[dbo].[ARPriceSources].[PriceSourceID]
FK_SOFulfillDetails_ReturnCodeID_ICReturnCodesReturnCodeID->[dbo].[ICReturnCodes].[ReturnCodeID]
FK_SOFulfillDetails_ShipmentID_SOShipmentsShipmentID->[dbo].[SOShipments].[ShipmentID]
FK_SOFulfillDetails_ShipToContactID_CMContactsShipToContactID->[dbo].[CMContacts].[ContactID]
FK_SOFulfillDetails_SOID_SOOrderDetailsSOID->[dbo].[SOOrderDetails].[SOID]
SODetailID->[dbo].[SOOrderDetails].[DetailID]
FK_SOFulfillDetails_StockTypeID_ICStockTypesStockTypeID->[dbo].[ICStockTypes].[StockTypeID]
FK_SOFulfillDetails_TaxFlagID_ShTaxFlagsTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SOFulfillDetails_UMID_ICUnitsUMID->[dbo].[ICUnits].[ID]
FK_SOFulfillDetails_UnearnedRevenueGLID_GLAccounts5UnearnedRevenueGLID->[dbo].[GLAccounts5].[AccountID]
CREATE TABLE [dbo].[SOFulfillDetails]
(
[FulfillID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[SOID] [int] NULL,
[SODetailID] [int] NULL,
[ItemID] [int] NOT NULL,
[ConvFactor] [decimal] (16, 6) NOT NULL,
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Stocked] [bit] NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[UMID] [int] NOT NULL,
[Price] [money] NOT NULL,
[Discount] [decimal] (18, 6) NOT NULL,
[EquipmentID] [int] NULL,
[ContractID] [int] NULL,
[BSABillForServices] [bit] NOT NULL,
[Bill] [bit] NOT NULL,
[GLID] [int] NULL,
[DeptID] [int] NULL,
[UnearnedRevenueGLID] [int] NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_Amount] DEFAULT ((0)),
[CostGLID] [int] NULL,
[CostDeptID] [int] NULL,
[CostAppliedGLID] [int] NULL,
[CostAppliedDeptID] [int] NULL,
[Cost] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_Cost] DEFAULT ((0)),
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetails_Canceled] DEFAULT ((0)),
[BackOrdered] [decimal] (18, 6) NOT NULL,
[EmployeeID] [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_SOFulfillDetails_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SOFulfillDetails_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PriceSourceID] [int] NOT NULL CONSTRAINT [DF_SOFulfillDetails_PriceSourceID] DEFAULT ((1)),
[SystemComputedPrice] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_SystemComputedPrice] DEFAULT ((0)),
[ReturnCodeID] [int] NULL,
[ReturnRemarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOFulfillDetails_ReturnRemarks] DEFAULT (''),
[StockTypeID] [int] NOT NULL CONSTRAINT [DF_SOFulfillDetails_StockTypeID] DEFAULT ((1)),
[OverriddenCost] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_OverriddenCost] DEFAULT ((0)),
[ChargeOutCost] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_ChargeOutCost] DEFAULT ((0)),
[ContractItemLimitID] [int] NULL,
[ShipmentID] [int] NULL,
[ShipQuantity] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetails_ShipQuantity] DEFAULT ((0)),
[ShipQuantityFulfilled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetails_ShipQuantityFulfilled] DEFAULT ((0)),
[ShipQuantityReversed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetails_ShipQuantityReversed] DEFAULT ((0)),
[ShipAmount] [money] NOT NULL CONSTRAINT [DF_SOFulFillDetails_ShipAmount] DEFAULT ((0)),
[FulFillDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SerialNumberWasAllocated] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_SerialNumberWasAllocated] DEFAULT ((0)),
[InvoiceID] [int] NULL,
[BillQuantity] [decimal] (18, 6) NOT NULL,
[BillAmount] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_BillAmount] DEFAULT ((0)),
[TaxFlag] [int] NOT NULL,
[UM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOFulfillDetails_UM] DEFAULT (''),
[Ordered] [decimal] (18, 6) NOT NULL,
[IsReturn] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_IsReturn] DEFAULT ((0)),
[IsRMAReturn] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_IsRMAReturn] DEFAULT ((0)),
[CalculatedOutCost] [money] NOT NULL CONSTRAINT [DF_SOFulFillDetails_CalculatedOutCost] DEFAULT ((0)),
[OutCost] [money] NOT NULL CONSTRAINT [DF_SOFulFillDetails_OutCost] DEFAULT ((0)),
[UseBaseOutCost] [bit] NOT NULL CONSTRAINT [DF_SOFulFillDetails_UseBaseOutCost] DEFAULT ((0)),
[OverrideOutCost] [bit] NOT NULL CONSTRAINT [DF_SOFulFillDetails_OverrideOutCost] DEFAULT ((0)),
[OutCostExtended] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_OutCostExtended] DEFAULT ((0)),
[OutCostRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetails_OutCostRate] DEFAULT ((0)),
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOFulfillDetails_Remarks] DEFAULT (''),
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOFulfillDetails_Notes] DEFAULT (''),
[ParentID] [int] NULL,
[RollUpPrice] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_RollUpPrice] DEFAULT ((0)),
[Hidden] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_Hidden] DEFAULT ((0)),
[SortOrder] [int] NOT NULL CONSTRAINT [DF_SOFulfillDetails_SortOrder] DEFAULT ((0)),
[Depth] [smallint] NOT NULL CONSTRAINT [DF_SOFulfillDetails_Depth] DEFAULT ((0)),
[ShipToContactID] [int] NULL,
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[IntercompanyGLID] [int] NULL,
[LineNumber] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ParentKitID] [int] NULL,
[DisplayPrice] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_DisplayPrice] DEFAULT ((0)),
[DisplayAmount] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_DisplayAmount] DEFAULT ((0)),
[DisplayDiscount] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetails_DisplayDiscount] DEFAULT ((0)),
[KitComponentQuantity] [decimal] (18, 6) NULL,
[KitComponentWeighting] [decimal] (18, 6) NULL,
[TrackKitDiscount] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_TrackKitDiscount] DEFAULT ((0)),
[LocationNotes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UnitCost] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_UnitCost] DEFAULT ((0)),
[ShipToDetailID] [int] NOT NULL CONSTRAINT [DF_SOFulfillDetails_ShipToDetailID] DEFAULT ((1)),
[ContractDetailID] [int] NULL,
[ContractDetailLinkFlag] [int] NULL,
[TaxFlagID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [PK_SOFulfillDetails] PRIMARY KEY CLUSTERED  ([FulfillID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ContractDetailID_SCContractDetails] FOREIGN KEY ([ContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ContractItemLimitID_SCContractItemLimits] FOREIGN KEY ([ContractItemLimitID]) REFERENCES [dbo].[SCContractItemLimits] ([ContractItemLimitID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_CostAppliedDeptID_GLDepts5] FOREIGN KEY ([CostAppliedDeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_CostAppliedGLID_GLAccounts5] FOREIGN KEY ([CostAppliedGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_CostDeptID_GLDepts5] FOREIGN KEY ([CostDeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_CostGLID_GLAccounts5] FOREIGN KEY ([CostGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_DeptID_GLDepts5] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_EmployeeID_ShAgents] FOREIGN KEY ([EmployeeID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_FulfillID_SOFulfills] FOREIGN KEY ([FulfillID]) REFERENCES [dbo].[SOFulfills] ([FulfillID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_FulfillID_SOFulfillShipTos] FOREIGN KEY ([FulfillID], [ShipToDetailID]) REFERENCES [dbo].[SOFulfillShipTos] ([FulfillID], [DetailID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_GLID_GLAccounts5] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_IntercompanyGLID_GLAccounts] FOREIGN KEY ([IntercompanyGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_InvoiceID_ARInvoices] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_PriceSourceID_ARPriceSources] FOREIGN KEY ([PriceSourceID]) REFERENCES [dbo].[ARPriceSources] ([PriceSourceID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ReturnCodeID_ICReturnCodes] FOREIGN KEY ([ReturnCodeID]) REFERENCES [dbo].[ICReturnCodes] ([ReturnCodeID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ShipmentID_SOShipments] FOREIGN KEY ([ShipmentID]) REFERENCES [dbo].[SOShipments] ([ShipmentID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ShipToContactID_CMContacts] FOREIGN KEY ([ShipToContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_SOID_SOOrderDetails] FOREIGN KEY ([SOID], [SODetailID]) REFERENCES [dbo].[SOOrderDetails] ([SOID], [DetailID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_TaxFlagID_ShTaxFlags] FOREIGN KEY ([TaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_UMID_ICUnits] FOREIGN KEY ([UMID]) REFERENCES [dbo].[ICUnits] ([ID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_UnearnedRevenueGLID_GLAccounts5] FOREIGN KEY ([UnearnedRevenueGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO