Posted on: 10/13/2013 8:09:36 AM | Views : 817

CREATE TYPE [dbo].[JNLOBJLIST] AS TABLE( [Journal_Master_Id] [int] NULL, [strTransRefNumber] [varchar](50) NULL, [dateGLTransDate] [date] NULL, [decGLTransAmount] [decimal](18, 4) NULL, [strGLTransRemark] [varchar](50) NULL, [guidCompanybranchId] [uniqueidentifier] NULL, [intGLAccountId] [int] NULL, [intFiscalYearId] [int] NULL, [boolGLIsDebit] [binary](1) NULL, [strPerson] [varchar](50) NULL, [inttblReferenceId] [int] NULL, [decGLTransAmount2] [decimal](18, 4) NULL, [strJournalmemo] [varchar](50) NULL) GO and sp as:
CREATE PROCEDURE [dbo].[usp_insertGl_transtemp2] @LIST [dbo].JNLOBJLIST READONLY AS DECLARE @id int BEGIN INSERT INTO tbl_GL_Trans_Detailstemp ( trans_ref_number , GL_trans_date , GL_trans_amount , GL_trans_remark , company_branch_id , GL_Account_id , fiscal_year_id , IsDebit , Person , tbl_ref ...

Go to the complete details ...