USE [CRS_QA]
GO
SET IDENTITY_INSERT [dbo].[sltLedgerTemplate] ON
GO
INSERT [dbo].[sltLedgerTemplate] ([sltUId], [sltGId], [sltStcStockId], [sltStoDepotId], [sltNttEndorsedTemplateId], [sltNttFinalizedTemplateId], [sltTypCreatedUserGroupId], [sltTypEndorsedUserGroupId], [sltTypFinalizedUserGroupId], [sltTypLedgerWorkflowId], [sltTypReportGroupId], [sltCode], [sltName], [sltType], [sltLedgerUsage], [sltStatusUsage], [sltWorkflowOrderNo], [sltCodePattern], [sltCodePeriod], [sltCodeGeneration], [sltCodeSequence], [sltEnabled], [sltComments], [sltUsrModifyId], [sltModifyDate], [sltDeleted]) VALUES (0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, N'', N'', N'RQ', N'R', N'C', 1, N'MP-{seqnum}-{yyyy}-{0m}-{0d}', N'X', N'X', 0, 0, N'', 0, CAST(N'1800-01-01T00:00:00.000' AS DateTime), 0)
GO
INSERT [dbo].[sltLedgerTemplate] ([sltUId], [sltGId], [sltStcStockId], [sltStoDepotId], [sltNttEndorsedTemplateId], [sltNttFinalizedTemplateId], [sltTypCreatedUserGroupId], [sltTypEndorsedUserGroupId], [sltTypFinalizedUserGroupId], [sltTypLedgerWorkflowId], [sltTypReportGroupId], [sltCode], [sltName], [sltType], [sltLedgerUsage], [sltStatusUsage], [sltWorkflowOrderNo], [sltCodePattern], [sltCodePeriod], [sltCodeGeneration], [sltCodeSequence], [sltEnabled], [sltComments], [sltUsrModifyId], [sltModifyDate], [sltDeleted]) VALUES (11, 1000000000001, 11, 11, 11, 11, 11, 11, 11, 11, 11, N'testCode11', N'testName11', N'RO', N'R', N'C', 1, N'MP-{seqnum}-{yyyy}-{0m}-{0d}', N'X', N'X', 11, 1, N'sltComments', 11, CAST(N'2200-01-01T00:00:00.000' AS DateTime), 0)
GO
SET IDENTITY_INSERT [dbo].[sltLedgerTemplate] OFF
GO