31 lines
1.1 KiB
Transact-SQL
31 lines
1.1 KiB
Transact-SQL
--HSSE/CostGoods/PayRegistration.aspx
|
|
update SYS_MENU set URL='HSSE/CostGoods/PayRegistrationNew.aspx' where menuid='9EFF1A0F-87AA-43E7-83B0-79EEAAC8848E';
|
|
|
|
--HSSE/CostGoods/CostLedger.aspx
|
|
update SYS_MENU set URL='HSSE/CostGoods/CostLedgerNew.aspx' where menuid='19C1370F-92C0-4E31-87B4-8BADA74113E4';
|
|
|
|
CREATE TABLE [dbo].[CostGoods_HseExpense](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[UnitId] [nvarchar](50) NULL,
|
|
[PayDate] [datetime] NULL,
|
|
[PayMonth] [nvarchar](50) NULL,
|
|
[SMonthType1] [decimal](18, 2) NULL,
|
|
[SMonthType2] [decimal](18, 2) NULL,
|
|
[SMonthType3] [decimal](18, 2) NULL,
|
|
[SMonthType4] [decimal](18, 2) NULL,
|
|
[SMonthType5] [decimal](18, 2) NULL,
|
|
[SMonthType6] [decimal](18, 2) NULL,
|
|
[SMonthType7] [decimal](18, 2) NULL,
|
|
[SMonthType8] [decimal](18, 2) NULL,
|
|
[SMonthType9] [decimal](18, 2) NULL,
|
|
[SMonthType10] [decimal](18, 2) NULL,
|
|
[CompileMan] [nvarchar](50) NULL,
|
|
[CompileDate] [datetime] NULL,
|
|
CONSTRAINT [PK_CostGoods_HseExpense] PRIMARY KEY CLUSTERED
|
|
(
|
|
[Id] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
GO
|