Tables [dbo].[POReceiptDetailCosts]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:31 AM Thursday, March 21, 2019
Last Modified1:13:33 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__POReceip__A84798FFE2507FE4: ReceiptDetailCostIDReceiptDetailCostIDint4
False
1 - 1
Foreign Keys FK_POReceiptDetailCosts_ReceiptID_POReceiptDetails: [dbo].[POReceiptDetails].ReceiptID\DetailIDReceiptIDint4
False
Foreign Keys FK_POReceiptDetailCosts_ReceiptID_POReceiptDetails: [dbo].[POReceiptDetails].ReceiptID\DetailIDDetailIDint4
False
Foreign Keys FK_POReceiptDetailCosts_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
False
SerialNumbervarchar(30)30
False
Foreign Keys FK_POReceiptDetailCosts_WarehouseID_ICWarehouses: [dbo].[ICWarehouses].WarehouseIDWarehouseIDint4
False
Foreign Keys FK_POReceiptDetailCosts_BinID_ICBins: [dbo].[ICBins].BinIDBinIDint4
False
Foreign Keys FK_POReceiptDetailCosts_StockTypeID_ICStockTypes: [dbo].[ICStockTypes].StockTypeIDStockTypeIDint4
False
Quantitydecimal(18,6)9
False
((0))
Amountmoney8
False
((0))
PurchaseAmountmoney8
False
((0))
AdjAmountmoney8
False
((0))
Vouchereddecimal(18,6)9
False
((0))
UnVoucheredmoney8
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
Foreign Keys FK_POReceiptDetailCosts_PurchaseBranchID_GLBranches: [dbo].[GLBranches].PurchaseBranchIDPurchaseBranchIDint4
False
Foreign Keys FK_POReceiptDetailCosts_PurchaseDivisionID_GLDivisions: [dbo].[GLDivisions].PurchaseDivisionIDPurchaseDivisionIDint4
False
Foreign Keys FK_POReceiptDetailCosts_PurchaseBalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].PurchaseBalanceSheetGroupIDPurchaseBalanceSheetGroupIDint4
False
Foreign Keys FK_POReceiptDetailCosts_PurchaseIntercompanyGLID_GLAccounts: [dbo].[GLAccounts].PurchaseIntercompanyGLIDPurchaseIntercompanyGLIDint4
True
Foreign Keys FK_POReceiptDetailCosts_AdjBranchID_GLBranches: [dbo].[GLBranches].AdjBranchIDAdjBranchIDint4
False
Foreign Keys FK_POReceiptDetailCosts_AdjDivisionID_GLDivisions: [dbo].[GLDivisions].AdjDivisionIDAdjDivisionIDint4
False
Foreign Keys FK_POReceiptDetailCosts_AdjBalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].AdjBalanceSheetGroupIDAdjBalanceSheetGroupIDint4
False
Foreign Keys FK_POReceiptDetailCosts_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_POReceiptDetailCosts_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_POReceiptDetailCosts_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Foreign Keys FK_POReceiptDetailCosts_IntercompanyGLID_GLAccounts: [dbo].[GLAccounts].IntercompanyGLIDIntercompanyGLIDint4
True
Foreign Keys FK_POReceiptDetailCosts_AppliedReceiptDetailCostID_POReceiptDetailCosts: [dbo].[POReceiptDetailCosts].AppliedReceiptDetailCostIDAppliedReceiptDetailCostIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__POReceip__A84798FFE2507FE4: ReceiptDetailCostIDPK__POReceip__A84798FFE2507FE4ReceiptDetailCostID
True
80
NameColumns
FK_POReceiptDetailCosts_AdjBalanceSheetGroupID_GLBalanceSheetGroupsAdjBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_POReceiptDetailCosts_AdjBranchID_GLBranchesAdjBranchID->[dbo].[GLBranches].[BranchID]
FK_POReceiptDetailCosts_AdjDivisionID_GLDivisionsAdjDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_POReceiptDetailCosts_AppliedReceiptDetailCostID_POReceiptDetailCostsAppliedReceiptDetailCostID->[dbo].[POReceiptDetailCosts].[ReceiptDetailCostID]
FK_POReceiptDetailCosts_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_POReceiptDetailCosts_BinID_ICBinsBinID->[dbo].[ICBins].[BinID]
FK_POReceiptDetailCosts_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_POReceiptDetailCosts_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_POReceiptDetailCosts_IntercompanyGLID_GLAccountsIntercompanyGLID->[dbo].[GLAccounts].[AccountID]
FK_POReceiptDetailCosts_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_POReceiptDetailCosts_PurchaseBalanceSheetGroupID_GLBalanceSheetGroupsPurchaseBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_POReceiptDetailCosts_PurchaseBranchID_GLBranchesPurchaseBranchID->[dbo].[GLBranches].[BranchID]
FK_POReceiptDetailCosts_PurchaseDivisionID_GLDivisionsPurchaseDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_POReceiptDetailCosts_PurchaseIntercompanyGLID_GLAccountsPurchaseIntercompanyGLID->[dbo].[GLAccounts].[AccountID]
FK_POReceiptDetailCosts_ReceiptID_POReceiptDetailsReceiptID->[dbo].[POReceiptDetails].[ReceiptID]
DetailID->[dbo].[POReceiptDetails].[DetailID]
FK_POReceiptDetailCosts_StockTypeID_ICStockTypesStockTypeID->[dbo].[ICStockTypes].[StockTypeID]
FK_POReceiptDetailCosts_WarehouseID_ICWarehousesWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
CREATE TABLE [dbo].[POReceiptDetailCosts]
(
[ReceiptDetailCostID] [int] NOT NULL IDENTITY(1, 1),
[ReceiptID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[ItemID] [int] NOT NULL,
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WarehouseID] [int] NOT NULL,
[BinID] [int] NOT NULL,
[StockTypeID] [int] NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POReceiptDetailCosts_Quantity] DEFAULT ((0)),
[Amount] [money] NOT NULL CONSTRAINT [DF_POReceiptDetailCosts_Amount] DEFAULT ((0)),
[PurchaseAmount] [money] NOT NULL CONSTRAINT [DF_POReceiptDetailCosts_PurchaseAmount] DEFAULT ((0)),
[AdjAmount] [money] NOT NULL CONSTRAINT [DF_POReceiptDetailCosts_AdjAmount] DEFAULT ((0)),
[Vouchered] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_POReceiptDetailCosts_Vouchered] DEFAULT ((0)),
[UnVouchered] [money] NOT NULL CONSTRAINT [DF_POReceiptDetailCosts_UnVouchered] DEFAULT ((0)),
[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_POReceiptDetailCosts_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_POReceiptDetailCosts_LastUpdate] DEFAULT (getdate()),
[PurchaseBranchID] [int] NOT NULL,
[PurchaseDivisionID] [int] NOT NULL,
[PurchaseBalanceSheetGroupID] [int] NOT NULL,
[PurchaseIntercompanyGLID] [int] NULL,
[AdjBranchID] [int] NOT NULL,
[AdjDivisionID] [int] NOT NULL,
[AdjBalanceSheetGroupID] [int] NOT NULL,
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[IntercompanyGLID] [int] NULL,
[AppliedReceiptDetailCostID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [PK__POReceip__A84798FFE2507FE4] PRIMARY KEY CLUSTERED  ([ReceiptDetailCostID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_AdjBalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([AdjBalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_AdjBranchID_GLBranches] FOREIGN KEY ([AdjBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_AdjDivisionID_GLDivisions] FOREIGN KEY ([AdjDivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_AppliedReceiptDetailCostID_POReceiptDetailCosts] FOREIGN KEY ([AppliedReceiptDetailCostID]) REFERENCES [dbo].[POReceiptDetailCosts] ([ReceiptDetailCostID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_IntercompanyGLID_GLAccounts] FOREIGN KEY ([IntercompanyGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_PurchaseBalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([PurchaseBalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_PurchaseBranchID_GLBranches] FOREIGN KEY ([PurchaseBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_PurchaseDivisionID_GLDivisions] FOREIGN KEY ([PurchaseDivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_PurchaseIntercompanyGLID_GLAccounts] FOREIGN KEY ([PurchaseIntercompanyGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_ReceiptID_POReceiptDetails] FOREIGN KEY ([ReceiptID], [DetailID]) REFERENCES [dbo].[POReceiptDetails] ([ReceiptID], [DetailID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[POReceiptDetailCosts] ADD CONSTRAINT [FK_POReceiptDetailCosts_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO