CREATE TABLE [dbo].[GLAssets]
(
[AssetID] [int] NOT NULL IDENTITY(1, 1),
[AssetNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AssetCodeID] [int] NOT NULL,
[AssetDeprCodeID] [int] NOT NULL,
[BranchID] [int] NOT NULL,
[AcquiredDate] [datetime] NOT NULL,
[ActivatedDate] [datetime] NOT NULL,
[DisposalDate] [datetime] NULL,
[DeprCycleID] [int] NOT NULL,
[LastDeprDate] [datetime] NOT NULL,
[NextDeprDate] [datetime] NOT NULL,
[DeprThruDate] [datetime] NULL,
[EquipmentID] [int] NULL,
[ItemID] [int] NULL,
[SerialNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_GLAssets_SerialNumber] DEFAULT (''),
[CostOrBasis] [money] NOT NULL CONSTRAINT [DF_GLAssets_CostOrBasis] DEFAULT ((0)),
[AccumDeprBook] [money] NOT NULL CONSTRAINT [DF_GLAssets_AccumDeprBook] DEFAULT ((0)),
[AccumDeprTax] [money] NOT NULL CONSTRAINT [DF_GLAssets_AccumDeprTax] DEFAULT ((0)),
[SalvageValue] [money] NOT NULL CONSTRAINT [DF_GLAssets_SalvageValue] DEFAULT ((0)),
[MarketValue] [money] NOT NULL CONSTRAINT [DF_GLAssets_MarketValue] DEFAULT ((0)),
[RecoveryPeriodBook] [int] NOT NULL,
[RecoveryPeriodTax] [int] NOT NULL,
[Location] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Active] [bit] NOT NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS 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_GLAssets_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_GLAssets_LastUpdate] DEFAULT (getdate()),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_GLAssets_NoteFlag] DEFAULT ((0)),
[SerialNumberID] [int] NULL,
[WarehouseID] [int] NULL,
[BinID] [int] NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_GLAssets_NoteCount] DEFAULT ((0)),
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_GLAssets_Quantity] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GLAssets] ADD CONSTRAINT [PK__GLAssets__434923729D091936] PRIMARY KEY CLUSTERED ([AssetID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GLAssets] ADD CONSTRAINT [FK_GLAssets_AssetCodeID_GLAssetCodes] FOREIGN KEY ([AssetCodeID]) REFERENCES [dbo].[GLAssetCodes] ([AssetCodeID])
GO
ALTER TABLE [dbo].[GLAssets] ADD CONSTRAINT [FK_GLAssets_AssetDeprCodeID_GLAssetDeprCodes] FOREIGN KEY ([AssetDeprCodeID]) REFERENCES [dbo].[GLAssetDeprCodes] ([AssetDeprCodeID])
GO
ALTER TABLE [dbo].[GLAssets] ADD CONSTRAINT [FK_GLAssets_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[GLAssets] ADD CONSTRAINT [FK_GLAssets_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[GLAssets] ADD CONSTRAINT [FK_GLAssets_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[GLAssets] ADD CONSTRAINT [FK_GLAssets_DeprCycleID_SCBillingCycles] FOREIGN KEY ([DeprCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[GLAssets] ADD CONSTRAINT [FK_GLAssets_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[GLAssets] ADD CONSTRAINT [FK_GLAssets_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[GLAssets] ADD CONSTRAINT [FK_GLAssets_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[GLAssets] ADD CONSTRAINT [FK_GLAssets_NoteID_GLAssetNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[GLAssetNotes] ([NoteID])
GO
ALTER TABLE [dbo].[GLAssets] ADD CONSTRAINT [FK_GLAssets_SerialNumberID_ICSerialNumbers] FOREIGN KEY ([SerialNumberID]) REFERENCES [dbo].[ICSerialNumbers] ([LookUpID])
GO
ALTER TABLE [dbo].[GLAssets] ADD CONSTRAINT [FK_GLAssets_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO