Tables [dbo].[GLAssets]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:18 AM Thursday, March 21, 2019
Last Modified1:15:05 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__GLAssets__434923729D091936: AssetIDAssetIDint4
False
1 - 1
AssetNumbervarchar(32)32
False
Descriptionvarchar(128)128
False
Foreign Keys FK_GLAssets_AssetCodeID_GLAssetCodes: [dbo].[GLAssetCodes].AssetCodeIDAssetCodeIDint4
False
Foreign Keys FK_GLAssets_AssetDeprCodeID_GLAssetDeprCodes: [dbo].[GLAssetDeprCodes].AssetDeprCodeIDAssetDeprCodeIDint4
False
Foreign Keys FK_GLAssets_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
AcquiredDatedatetime8
False
ActivatedDatedatetime8
False
DisposalDatedatetime8
True
Foreign Keys FK_GLAssets_DeprCycleID_SCBillingCycles: [dbo].[SCBillingCycles].DeprCycleIDDeprCycleIDint4
False
LastDeprDatedatetime8
False
NextDeprDatedatetime8
False
DeprThruDatedatetime8
True
Foreign Keys FK_GLAssets_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
Foreign Keys FK_GLAssets_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
True
SerialNumbervarchar(32)32
False
('')
CostOrBasismoney8
False
((0))
AccumDeprBookmoney8
False
((0))
AccumDeprTaxmoney8
False
((0))
SalvageValuemoney8
False
((0))
MarketValuemoney8
False
((0))
RecoveryPeriodBookint4
False
RecoveryPeriodTaxint4
False
Locationvarchar(128)128
False
Activebit1
False
Remarksvarchar(1024)1024
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
Foreign Keys FK_GLAssets_NoteID_GLAssetNotes: [dbo].[GLAssetNotes].NoteIDNoteIDint4
True
NoteFlagint4
False
((0))
Foreign Keys FK_GLAssets_SerialNumberID_ICSerialNumbers: [dbo].[ICSerialNumbers].SerialNumberIDSerialNumberIDint4
True
Foreign Keys FK_GLAssets_WarehouseID_ICWarehouses: [dbo].[ICWarehouses].WarehouseIDWarehouseIDint4
True
Foreign Keys FK_GLAssets_BinID_ICBins: [dbo].[ICBins].BinIDBinIDint4
True
NoteCountint4
False
((0))
Foreign Keys FK_GLAssets_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_GLAssets_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Quantitydecimal(18,6)9
False
((1))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__GLAssets__434923729D091936: AssetIDPK__GLAssets__434923729D091936AssetID
True
80
NameColumns
FK_GLAssets_AssetCodeID_GLAssetCodesAssetCodeID->[dbo].[GLAssetCodes].[AssetCodeID]
FK_GLAssets_AssetDeprCodeID_GLAssetDeprCodesAssetDeprCodeID->[dbo].[GLAssetDeprCodes].[AssetDeprCodeID]
FK_GLAssets_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_GLAssets_BinID_ICBinsBinID->[dbo].[ICBins].[BinID]
FK_GLAssets_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_GLAssets_DeprCycleID_SCBillingCyclesDeprCycleID->[dbo].[SCBillingCycles].[BillingCycleID]
FK_GLAssets_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_GLAssets_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_GLAssets_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_GLAssets_NoteID_GLAssetNotesNoteID->[dbo].[GLAssetNotes].[NoteID]
FK_GLAssets_SerialNumberID_ICSerialNumbersSerialNumberID->[dbo].[ICSerialNumbers].[LookUpID]
FK_GLAssets_WarehouseID_ICWarehousesWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
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