Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Error

Author

Topic

JanakiRam
Starting Member

22 Posts

Posted - 2013-08-31 : 15:11:11

'Customer_Ledger_New' table
- Unable to modify table.
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).

I have a problem please resolve it

i have table and it have two computed columns when run this table above mentioned issue will be occur

JanakiRam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-08-31 : 18:51:36

Please show us the DDL of the table including the computed columns.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

JanakiRam
Starting Member

22 Posts

Posted - 2013-09-02 : 03:04:18

/****** Object: UserDefinedFunction [dbo].[Get_LedgerOpenbalance] Script Date: 09/01/2013 12:08:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/*
select dbo.[Get_LedgerOpenbalance] (3967,2273,'08/15/2013')
select dbo.[Get_LedgerOpenbalance] (3968,2273,'08/15/2013')
select dbo.[Get_LedgerOpenbalance] (3969,2273,'08/15/2013')
select dbo.[Get_LedgerOpenbalance] (3970,2273,'08/15/2013')
select dbo.[Get_LedgerOpenbalance] (3971,2273,'08/15/2013')
OB -([dbo].[Get_LedgerOpenbalance]([Customer_Ledger_ID],[User_ID],[DateOfTranscation]))
CB--([dbo].[Get_LedgerOpenbalance]([Customer_Ledger_ID],[User_ID],[DateOfTranscation])+(isnull([DebitAmount],(0))-isnull([CreditAmount],(0))))
*/

ALTER FUNCTION [dbo].[Get_LedgerOpenbalance](@Customer_Ledger_ID int,
@UserID int,
@TransDate datetime)
RETURNS numeric(19,2)
AS
begin
declare @record_count int
declare @amount as numeric(19,2)

Declare @Balance as numeric(19,2)
set @Balance = 0

SELECT @Balance = (SELECT TOP 1 ISNULL(ClosingBalance,0) FROM Customer_Ledger_new
WHERE [user_id]=@UserID
--AND Customer_Ledger_ID<>@Customer_Ledger_ID
--AND Customer_Ledger_ID<@Customer_Ledger_ID
AND DateOfTranscation <> @TransDate
AND DateOfTranscation < @TransDate
ORDER BY Customer_Ledger_ID DESC )

IF isnull(@Balance,0) <>0
BEGIN
set @amount=@Balance
END
ELSE
BEGIN
set @amount=0
END

IF isnull(@amount,0)=0 and isnull(@Balance,0)=0
BEGIN
SELECT @amount =ISNULL((SELECT TOP 1 ISNULL(ClosingBalance,0) FROM Customer_Ledger_new
where [user_id]=@UserID
--AND Customer_Ledger_ID<@Customer_Ledger_ID
AND DateOfTranscation < @TransDate
ORDER BY Customer_Ledger_ID DESC),0)
END

RETURN(@amount)
end

/****** Object: Table [dbo].[Customer_Ledger_New] Script Date: 09/01/2013 12:07:13 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Customer_Ledger_New]') AND type in (N'U'))
DROP TABLE [dbo].[Customer_Ledger_New]
GO
/****** Object: Table [dbo].[Customer_Ledger_New] Script Date: 09/01/2013 12:07:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Customer_Ledger_New]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Customer_Ledger_New](
[Customer_Ledger_ID] [int] IDENTITY(1,1) NOT NULL,
[User_ID] [int] NULL,
[Ledger_Type] [varchar](50) NULL,
[Transcation] [varchar](50) NULL,
[Reference] [varchar](50) NULL,
[Amount] [numeric](18, 2) NULL,
[Particulars] [varchar](500) NULL,
[DateOfTranscation] [datetime] NULL,
[Remarks] [varchar](500) NULL,
[OpeningBalance] AS ([dbo].[Get_LedgerOpenbalance]([Customer_Ledger_ID],[User_ID],[DateOfTranscation])),
[CreditAmount] [decimal](18, 2) NULL,
[DebitAmount] [decimal](18, 2) NULL,
[ClosingBalance] AS ([dbo].[Get_LedgerOpenbalance]([Customer_Ledger_ID],[User_ID],[DateOfTranscation])+(isnull([DebitAmount],(0))-isnull([CreditAmount],(0)))),
[Created_By] [int] NULL,
[Created_On] [datetime] NULL,
[Modified_By] [int] NULL,
[Modified_On] [datetime] NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[Customer_Ledger_New] ON
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (336, 2278, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(7.08 AS Numeric(18, 2)), NULL, CAST(0x0000A2050022749A AS DateTime), NULL, NULL, CAST(7.08 AS Decimal(18, 2)), 2278, CAST(0x0000A2050022749A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (337, 2126, N'Credit', N'Invoice', N'INV10021', CAST(29.12 AS Numeric(18, 2)), NULL, CAST(0x0000A205005E0F05 AS DateTime), NULL, CAST(29.12 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A205005E0F05 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (338, 2126, N'Credit', N'Invoice', N'INV10022', CAST(14.66 AS Numeric(18, 2)), NULL, CAST(0x0000A205005E0F05 AS DateTime), NULL, CAST(14.66 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A205005E0F05 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (339, 2126, N'Credit', N'Invoice', N'INV10024', CAST(3.24 AS Numeric(18, 2)), NULL, CAST(0x0000A205005E0F05 AS DateTime), NULL, CAST(3.24 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A205005E0F05 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (340, 2126, N'Debit', N'Card', N'XXXX XXXX XXXX 1111', CAST(29.12 AS Numeric(18, 2)), NULL, CAST(0x0000A205005E55A4 AS DateTime), NULL, NULL, CAST(29.12 AS Decimal(18, 2)), 22, CAST(0x0000A205005E55A4 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (341, 2126, N'Debit', N'Card', N'XXXX XXXX XXXX 1111', CAST(14.66 AS Numeric(18, 2)), NULL, CAST(0x0000A205005E578D AS DateTime), NULL, NULL, CAST(14.66 AS Decimal(18, 2)), 22, CAST(0x0000A205005E578D AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (342, 2126, N'Debit', N'Card', N'XXXX XXXX XXXX 1111', CAST(3.24 AS Numeric(18, 2)), NULL, CAST(0x0000A205005E5964 AS DateTime), NULL, NULL, CAST(3.24 AS Decimal(18, 2)), 22, CAST(0x0000A205005E5964 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (580, 3290, N'Credit', N'ECheck', N'INV10217', NULL, NULL, CAST(0x0000A21F00D13201 AS DateTime), NULL, CAST(20.00 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A21F00D13201 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (581, 3290, N'Debit', N'ECheck', N'INV10217', NULL, NULL, CAST(0x0000A21F00D13201 AS DateTime), NULL, NULL, CAST(20.00 AS Decimal(18, 2)), 22, CAST(0x0000A21F00D13201 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (585, 3285, N'Credit', N'Card', N'INV10219', NULL, NULL, CAST(0x0000A21F00D700D2 AS DateTime), NULL, CAST(39.43 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A21F00D700D2 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (586, 3285, N'Debit', N'Card', N'INV10219', NULL, NULL, CAST(0x0000A21F00D72677 AS DateTime), NULL, NULL, CAST(39.43 AS Decimal(18, 2)), 22, CAST(0x0000A21F00D72677 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (587, 2276, N'Credit', N'Card', N'INV10222', NULL, NULL, CAST(0x0000A21F00DFED37 AS DateTime), NULL, CAST(4.33 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A21F00DFED37 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (588, 2276, N'Debit', N'Card', N'INV10222', NULL, NULL, CAST(0x0000A21F00DFED37 AS DateTime), NULL, NULL, CAST(4.33 AS Decimal(18, 2)), 2276, CAST(0x0000A21F00DFED37 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (591, 2276, N'Credit', N'Card', N'INV10226', NULL, NULL, CAST(0x0000A21F00FD7A05 AS DateTime), NULL, CAST(42.65 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A21F00FD7A05 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (592, 2276, N'Debit', N'Card', N'INV10226', NULL, NULL, CAST(0x0000A21F00FD7A06 AS DateTime), NULL, NULL, CAST(42.65 AS Decimal(18, 2)), 2276, CAST(0x0000A21F00FD7A06 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (595, 2276, N'Credit', N'Card', N'INV10228', NULL, NULL, CAST(0x0000A21F0112082A AS DateTime), NULL, CAST(2.33 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A21F0112082A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (596, 2276, N'Debit', N'Card', N'INV10228', NULL, NULL, CAST(0x0000A21F0112082A AS DateTime), NULL, NULL, CAST(2.33 AS Decimal(18, 2)), 2276, CAST(0x0000A21F0112082A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1580, 2276, N'Credit', N'Card', N'INV11217', NULL, NULL, CAST(0x0000A223014BBA70 AS DateTime), NULL, CAST(9.73 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A223014BBA70 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1581, 2276, N'Debit', N'Card', N'INV11217', NULL, NULL, CAST(0x0000A223014BBA70 AS DateTime), NULL, NULL, CAST(9.73 AS Decimal(18, 2)), 2276, CAST(0x0000A223014BBA70 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1582, 2276, N'Credit', N'Card', N'INV11218', NULL, NULL, CAST(0x0000A224015C1518 AS DateTime), NULL, CAST(37.29 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A224015C1518 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1583, 2276, N'Debit', N'Card', N'INV11218', NULL, NULL, CAST(0x0000A224015C1519 AS DateTime), NULL, NULL, CAST(37.29 AS Decimal(18, 2)), 2276, CAST(0x0000A224015C1519 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1584, 2276, N'Credit', N'Card', N'INV10192', NULL, NULL, CAST(0x0000A22401615C3C AS DateTime), NULL, CAST(5.90 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22401615C3C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1585, 2276, N'Credit', N'Card', N'INV11219', NULL, NULL, CAST(0x0000A2240162D40A AS DateTime), NULL, CAST(13.50 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A2240162D40A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1586, 2276, N'Debit', N'Card', N'INV11219', NULL, NULL, CAST(0x0000A2240162D40A AS DateTime), NULL, NULL, CAST(13.50 AS Decimal(18, 2)), 2276, CAST(0x0000A2240162D40A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1587, 2276, N'Credit', N'Card', N'INV11220', NULL, NULL, CAST(0x0000A2240163AA08 AS DateTime), NULL, CAST(7.73 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A2240163AA08 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1588, 2276, N'Debit', N'Card', N'INV11220', NULL, NULL, CAST(0x0000A2240163AA08 AS DateTime), NULL, NULL, CAST(7.73 AS Decimal(18, 2)), 2276, CAST(0x0000A2240163AA08 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1589, 2276, N'Credit', N'Card', N'INV11221', NULL, NULL, CAST(0x0000A22401644BAD AS DateTime), NULL, CAST(11.50 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A22401644BAD AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1590, 2276, N'Debit', N'Card', N'INV11221', NULL, NULL, CAST(0x0000A22401644BAD AS DateTime), NULL, NULL, CAST(11.50 AS Decimal(18, 2)), 2276, CAST(0x0000A22401644BAD AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1591, 2276, N'Credit', N'Card', N'INV11222', NULL, NULL, CAST(0x0000A22401699166 AS DateTime), NULL, CAST(3.32 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A22401699166 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1593, 2276, N'Credit', N'Card', N'INV11223', NULL, NULL, CAST(0x0000A22500C45959 AS DateTime), NULL, CAST(14.98 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A22500C45959 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1594, 2276, N'Debit', N'Card', N'INV11223', NULL, NULL, CAST(0x0000A22500C4595A AS DateTime), NULL, NULL, CAST(14.98 AS Decimal(18, 2)), 2276, CAST(0x0000A22500C4595A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1595, 2276, N'Credit', N'Card', N'INV11224', NULL, NULL, CAST(0x0000A22500C6DE47 AS DateTime), NULL, CAST(43.17 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A22500C6DE47 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1596, 2276, N'Debit', N'Card', N'INV11224', NULL, NULL, CAST(0x0000A22500C6DE48 AS DateTime), NULL, NULL, CAST(43.17 AS Decimal(18, 2)), 2276, CAST(0x0000A22500C6DE48 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (369, 2126, N'Credit', N'Invoice', N'INV10025', CAST(25.95 AS Numeric(18, 2)), NULL, CAST(0x0000A20600CF2D1A AS DateTime), NULL, CAST(25.95 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A20600CF2D1A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (370, 2126, N'Debit', N'Card', N'XXXX XXXX XXXX 1111', CAST(25.95 AS Numeric(18, 2)), NULL, CAST(0x0000A20600CFAD61 AS DateTime), NULL, NULL, CAST(25.95 AS Decimal(18, 2)), 22, CAST(0x0000A20600CFAD61 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (371, 3282, N'Credit', N'Invoice', N'INV10098', CAST(6.57 AS Numeric(18, 2)), NULL, CAST(0x0000A20600D8AA29 AS DateTime), NULL, CAST(6.57 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A20600D8AA29 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (372, 3282, N'Debit', N'Card', N'XXXX XXXX XXXX 1111', CAST(6.57 AS Numeric(18, 2)), NULL, CAST(0x0000A20600D8AA29 AS DateTime), NULL, NULL, CAST(6.57 AS Decimal(18, 2)), 22, CAST(0x0000A20600D8AA29 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (373, 2130, N'Credit', N'Invoice', N'INV10099', CAST(7.67 AS Numeric(18, 2)), NULL, CAST(0x0000A20600DB793B AS DateTime), NULL, CAST(7.67 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A20600DB793B AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (374, 2130, N'Debit', N'Card', N'XXXX XXXX XXXX 1111', CAST(7.67 AS Numeric(18, 2)), NULL, CAST(0x0000A20600DB793B AS DateTime), NULL, NULL, CAST(7.67 AS Decimal(18, 2)), 22, CAST(0x0000A20600DB793B AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1597, 2276, N'Credit', N'Card', N'INV11225', NULL, NULL, CAST(0x0000A2260135DD95 AS DateTime), NULL, CAST(46.11 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A2260135DD95 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1598, 2276, N'Debit', N'Card', N'INV11225', NULL, NULL, CAST(0x0000A2260135DD96 AS DateTime), NULL, NULL, CAST(46.11 AS Decimal(18, 2)), 2276, CAST(0x0000A2260135DD96 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1599, 2276, N'Credit', N'Card', N'INV11227', NULL, NULL, CAST(0x0000A22601393B67 AS DateTime), NULL, CAST(3.05 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22601393B67 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1600, 3282, N'Credit', N'Card', N'INV10189', NULL, NULL, CAST(0x0000A22601396521 AS DateTime), NULL, CAST(9.03 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22601396521 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1601, 2276, N'Credit', N'Card', N'INV11230', NULL, NULL, CAST(0x0000A226013F5094 AS DateTime), NULL, CAST(5.05 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A226013F5094 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1602, 3282, N'Credit', N'Card', N'INV11230', NULL, NULL, CAST(0x0000A226013F5094 AS DateTime), NULL, CAST(9.03 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A226013F5094 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1603, 3287, N'Credit', N'Card', N'INV11230', NULL, NULL, CAST(0x0000A226013F5094 AS DateTime), NULL, CAST(22.90 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A226013F5094 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1604, 3288, N'Credit', N'Card', N'INV11230', NULL, NULL, CAST(0x0000A226013F5094 AS DateTime), NULL, CAST(17.75 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A226013F5094 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1605, 2276, N'Credit', N'Card', N'INV11230_1', NULL, NULL, CAST(0x0000A226013FDE6C AS DateTime), NULL, CAST(5.05 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A226013FDE6C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1606, 3282, N'Credit', N'Card', N'INV11230_1', NULL, NULL, CAST(0x0000A226013FDE6C AS DateTime), NULL, CAST(9.03 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A226013FDE6C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1607, 3287, N'Credit', N'Card', N'INV11230_1', NULL, NULL, CAST(0x0000A226013FDE6C AS DateTime), NULL, CAST(22.90 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A226013FDE6C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (386, 2126, N'Credit', N'Credit Note', N'CN386', CAST(100.00 AS Numeric(18, 2)), N'', CAST(0x0000A2070163C93B AS DateTime), N'test', CAST(100.00 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A2070163C93B AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1608, 3288, N'Credit', N'Card', N'INV11230_1', NULL, NULL, CAST(0x0000A226013FDE6C AS DateTime), NULL, CAST(17.75 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A226013FDE6C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1609, 3282, N'Debit', N'Card', N'INV10189', NULL, NULL, CAST(0x0000A22700C5FDE5 AS DateTime), NULL, NULL, CAST(9.03 AS Decimal(18, 2)), 1, CAST(0x0000A22700C5FDE5 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (389, 2126, N'Debit', N'Debit Note', N'DN389', CAST(1000.00 AS Numeric(18, 2)), N'', CAST(0x0000A2070164617C AS DateTime), N'Test', NULL, CAST(1000.00 AS Decimal(18, 2)), 22, CAST(0x0000A2070164617C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (390, 2126, N'Debit', N'Check', N'1234', CAST(2.00 AS Numeric(18, 2)), N'Deposited on 7/26/2013 for Bank California Federal Bank ', CAST(0x0000A2070164D029 AS DateTime), N'Check Date is 7/26/2013', NULL, CAST(2.00 AS Decimal(18, 2)), 22, CAST(0x0000A2070164D029 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1610, 2276, N'Debit', N'Card', N'INV10192', NULL, NULL, CAST(0x0000A22700C5FE48 AS DateTime), NULL, NULL, CAST(5.90 AS Decimal(18, 2)), 1, CAST(0x0000A22700C5FE48 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1611, 2276, N'Debit', N'Card', N'INV10225', NULL, NULL, CAST(0x0000A22700C5FF06 AS DateTime), NULL, NULL, CAST(2.34 AS Decimal(18, 2)), 1, CAST(0x0000A22700C5FF06 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1612, 2276, N'Debit', N'Card', N'INV11227', NULL, NULL, CAST(0x0000A22700C60003 AS DateTime), NULL, NULL, CAST(3.05 AS Decimal(18, 2)), 1, CAST(0x0000A22700C60003 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1613, 2276, N'Debit', N'Card', N'INV11231_1', NULL, NULL, CAST(0x0000A22700C60060 AS DateTime), NULL, NULL, CAST(5.05 AS Decimal(18, 2)), 1, CAST(0x0000A22700C60060 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1614, 3287, N'Debit', N'Card', N'INV11229_1', NULL, NULL, CAST(0x0000A22700C60264 AS DateTime), NULL, NULL, CAST(22.90 AS Decimal(18, 2)), 1, CAST(0x0000A22700C60264 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1615, 3288, N'Debit', N'Card', N'INV11230_1', NULL, NULL, CAST(0x0000A22700C60367 AS DateTime), NULL, NULL, CAST(17.75 AS Decimal(18, 2)), 1, CAST(0x0000A22700C60367 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1616, 2277, N'Credit', N'Card', N'INV11232', NULL, NULL, CAST(0x0000A2270116D839 AS DateTime), NULL, CAST(4.56 AS Decimal(18, 2)), NULL, 2277, CAST(0x0000A2270116D839 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1622, 2277, N'Credit', N'Card', N'INV11238', NULL, NULL, CAST(0x0000A22701860D2A AS DateTime), NULL, CAST(40.44 AS Decimal(18, 2)), NULL, 2277, CAST(0x0000A22701860D2A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1623, 2277, N'Debit', N'Card', N'INV11238', NULL, NULL, CAST(0x0000A22701860D2A AS DateTime), NULL, NULL, CAST(40.44 AS Decimal(18, 2)), 2277, CAST(0x0000A22701860D2A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1624, 3293, N'Credit', N'Card', N'INV11239', NULL, NULL, CAST(0x0000A22800052905 AS DateTime), NULL, CAST(19.09 AS Decimal(18, 2)), NULL, 3293, CAST(0x0000A22800052905 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1625, 3293, N'Debit', N'Card', N'INV11239', NULL, NULL, CAST(0x0000A22800052905 AS DateTime), NULL, NULL, CAST(19.09 AS Decimal(18, 2)), 3293, CAST(0x0000A22800052905 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1626, 3285, N'Credit', N'Card', N'INV11235', NULL, NULL, CAST(0x0000A2280015D510 AS DateTime), NULL, CAST(33.43 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A2280015D510 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1627, 3286, N'Credit', N'Card', N'INV11235', NULL, NULL, CAST(0x0000A2280015D510 AS DateTime), NULL, CAST(68.36 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A2280015D510 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1628, 3285, N'Debit', N'Card', N'INV11234', NULL, NULL, CAST(0x0000A22800163DF9 AS DateTime), NULL, NULL, CAST(33.43 AS Decimal(18, 2)), 22, CAST(0x0000A22800163DF9 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1629, 3286, N'Debit', N'Card', N'INV11235', NULL, NULL, CAST(0x0000A22800163E9C AS DateTime), NULL, NULL, CAST(68.36 AS Decimal(18, 2)), 22, CAST(0x0000A22800163E9C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1631, 3293, N'Credit', N'Credit Note', N'CN1631', NULL, N'', CAST(0x0000A2280018396F AS DateTime), N'late payment Charges', CAST(10.00 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A2280018396F AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1632, 3293, N'Debit', N'Debit Note', N'DN1632', NULL, N'', CAST(0x0000A2280018E6DA AS DateTime), N'excees delivery charges collected', NULL, CAST(5.00 AS Decimal(18, 2)), 22, CAST(0x0000A2280018E6DA AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1633, 3293, N'Credit', N'Credit Note', N'CN1633', NULL, N'', CAST(0x0000A22800194DDF AS DateTime), N'test', CAST(10.00 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22800194DDF AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1592, 2276, N'Debit', N'Card', N'INV11222', NULL, NULL, CAST(0x0000A22401699166 AS DateTime), NULL, NULL, CAST(3.32 AS Decimal(18, 2)), 2276, CAST(0x0000A22401699166 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1617, 2277, N'Debit', N'Card', N'INV11232', NULL, NULL, CAST(0x0000A2270116D839 AS DateTime), NULL, NULL, CAST(4.56 AS Decimal(18, 2)), 2277, CAST(0x0000A2270116D839 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1634, 3293, N'Debit', N'Debit Note', N'DN1634', NULL, N'', CAST(0x0000A22800196A91 AS DateTime), N'test', NULL, CAST(20.00 AS Decimal(18, 2)), 22, CAST(0x0000A22800196A91 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1635, 3287, N'Credit', N'Card', N'INV11245', NULL, NULL, CAST(0x0000A229009134F9 AS DateTime), NULL, CAST(22.90 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A229009134F9 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1636, 3288, N'Credit', N'Card', N'INV11245', NULL, NULL, CAST(0x0000A229009134F9 AS DateTime), NULL, CAST(61.09 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A229009134F9 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1637, 3279, N'Credit', N'Card', N'INV11247', NULL, NULL, CAST(0x0000A22900AA3415 AS DateTime), NULL, CAST(20.35 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22900AA3415 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1638, 3279, N'Debit', N'Card', N'INV11247', NULL, NULL, CAST(0x0000A22900AA3415 AS DateTime), NULL, NULL, CAST(20.35 AS Decimal(18, 2)), 22, CAST(0x0000A22900AA3415 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1639, 3282, N'Credit', N'Card', N'INV11248', NULL, NULL, CAST(0x0000A22900C01649 AS DateTime), NULL, CAST(14.07 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22900C01649 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1641, 22, N'Credit', N'Credit Note', N'CN1641', NULL, N'', CAST(0x0000A22B00CA16E2 AS DateTime), N'test', CAST(100.00 AS Decimal(18, 2)), NULL, 3291, CAST(0x0000A22B00CA16E2 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1642, 2276, N'Debit', N'Card', N'INV10225', NULL, NULL, CAST(0x0000A22B00CAF901 AS DateTime), NULL, NULL, CAST(2.34 AS Decimal(18, 2)), 1, CAST(0x0000A22B00CAF901 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1643, 3289, N'Credit', N'Card', N'INV11252', NULL, NULL, CAST(0x0000A22B00DB7EEB AS DateTime), NULL, CAST(82.45 AS Decimal(18, 2)), NULL, 3289, CAST(0x0000A22B00DB7EEB AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1644, 3289, N'Debit', N'Card', N'INV11252', NULL, NULL, CAST(0x0000A22B00DB7EEC AS DateTime), NULL, NULL, CAST(82.45 AS Decimal(18, 2)), 3289, CAST(0x0000A22B00DB7EEC AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (2641, 22, N'Credit', N'Credit Note', N'CN2641', NULL, N'', CAST(0x0000A22C00000000 AS DateTime), N'Test Remarks', CAST(10.00 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22C00064CBF AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (2642, 22, N'Debit', N'Debit Note', N'DN2642', NULL, N'', CAST(0x0000A22C00000000 AS DateTime), N'reverse of test remarks', NULL, CAST(10.00 AS Decimal(18, 2)), 22, CAST(0x0000A22C000671D5 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (2643, 22, N'Credit', N'Card', N'INV12262', NULL, NULL, CAST(0x0000A22C0009E801 AS DateTime), NULL, CAST(24.72 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22C0009E801 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (2644, 22, N'Debit', N'Card', N'INV12262', NULL, NULL, CAST(0x0000A22C0009FB04 AS DateTime), NULL, NULL, CAST(24.72 AS Decimal(18, 2)), 22, CAST(0x0000A22C0009FB04 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (441, 2126, N'Debit', N'Check', N'1', CAST(100.00 AS Numeric(18, 2)), N'Deposited on 7/29/2013 for Bank Bank Of America', CAST(0x0000A20A00B41A7C AS DateTime), N'Check Date is 7/29/2013', NULL, CAST(100.00 AS Decimal(18, 2)), 22, CAST(0x0000A20A00B41A7C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (442, 3282, N'Credit', N'Invoice', N'INV10124', CAST(34.28 AS Numeric(18, 2)), NULL, CAST(0x0000A20B005ED69B AS DateTime), NULL, CAST(34.28 AS Decimal(18, 2)), NULL, 3282, CAST(0x0000A20B005ED69B AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (443, 3282, N'Debit', N'Card', N'XXXX XXXX XXXX xx11', CAST(34.28 AS Numeric(18, 2)), NULL, CAST(0x0000A20B005ED69B AS DateTime), NULL, NULL, CAST(34.28 AS Decimal(18, 2)), 3282, CAST(0x0000A20B005ED69B AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (444, 3282, N'Credit', N'Invoice', N'INV10125', CAST(34.28 AS Numeric(18, 2)), NULL, CAST(0x0000A20B00603840 AS DateTime), NULL, CAST(34.28 AS Decimal(18, 2)), NULL, 3282, CAST(0x0000A20B00603840 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (445, 3282, N'Debit', N'Card', N'XXXX XXXX XXXX xx11', CAST(34.28 AS Numeric(18, 2)), NULL, CAST(0x0000A20B00603840 AS DateTime), NULL, NULL, CAST(34.28 AS Decimal(18, 2)), 3282, CAST(0x0000A20B00603840 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (446, 3282, N'Credit', N'Invoice', N'INV10126', CAST(16.67 AS Numeric(18, 2)), NULL, CAST(0x0000A20B006D7B01 AS DateTime), NULL, CAST(16.67 AS Decimal(18, 2)), NULL, 3282, CAST(0x0000A20B006D7B01 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (447, 3282, N'Debit', N'Card', N'XXXX XXXX XXXX xx11', CAST(16.67 AS Numeric(18, 2)), NULL, CAST(0x0000A20B006D7B01 AS DateTime), NULL, NULL, CAST(16.67 AS Decimal(18, 2)), 3282, CAST(0x0000A20B006D7B01 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (589, 2276, N'Credit', N'Card', N'INV10225', NULL, NULL, CAST(0x0000A21F00F325AA AS DateTime), NULL, CAST(2.34 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A21F00F325AA AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (477, 2276, N'Credit', N'Invoice', N'INV10151', CAST(7.07 AS Numeric(18, 2)), NULL, CAST(0x0000A20C0072EA1F AS DateTime), NULL, CAST(7.07 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A20C0072EA1F AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (478, 2276, N'Debit', N'Card', N'XXXX XXXX XXXX xx11', CAST(7.07 AS Numeric(18, 2)), NULL, CAST(0x0000A20C0073270A AS DateTime), NULL, NULL, CAST(7.07 AS Decimal(18, 2)), 22, CAST(0x0000A20C0073270A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (479, 2276, N'Debit', N'Check', N'12345678', CAST(10.00 AS Numeric(18, 2)), N'Deposited on 7/31/2013 for Bank Of America', CAST(0x0000A20C0073CB9D AS DateTime), N'Check Date is 7/31/2013', NULL, CAST(10.00 AS Decimal(18, 2)), 22, CAST(0x0000A20C0073CB9D AS DateTime), NULL, NULL)
GO
print 'Processed 100 total records'
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (590, 2276, N'Debit', N'Card', N'INV10225', NULL, NULL, CAST(0x0000A21F00F36F0C AS DateTime), NULL, NULL, CAST(2.34 AS Decimal(18, 2)), 22, CAST(0x0000A21F00F36F0C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (593, 2276, N'Credit', N'Card', N'INV10227', NULL, NULL, CAST(0x0000A21F0100F9A8 AS DateTime), NULL, CAST(9.72 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A21F0100F9A8 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (594, 2276, N'Debit', N'Card', N'INV10227', NULL, NULL, CAST(0x0000A21F0100F9A8 AS DateTime), NULL, NULL, CAST(9.72 AS Decimal(18, 2)), 2276, CAST(0x0000A21F0100F9A8 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (488, 2277, N'Credit', N'Invoice', N'INV10156', CAST(10.90 AS Numeric(18, 2)), NULL, CAST(0x0000A20D00CFFACC AS DateTime), NULL, CAST(10.90 AS Decimal(18, 2)), NULL, 2277, CAST(0x0000A20D00CFFACC AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (489, 2277, N'Debit', N'Card', N'XXXX XXXX XXXX xx11', CAST(10.90 AS Numeric(18, 2)), NULL, CAST(0x0000A20D00CFFACC AS DateTime), NULL, NULL, CAST(10.90 AS Decimal(18, 2)), 2277, CAST(0x0000A20D00CFFACC AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (490, 2277, N'Credit', N'Invoice', N'INV10157', CAST(61.51 AS Numeric(18, 2)), NULL, CAST(0x0000A20E00396659 AS DateTime), NULL, CAST(61.51 AS Decimal(18, 2)), NULL, 2277, CAST(0x0000A20E00396659 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (491, 2277, N'Credit', N'Credit Note', N'CN491', CAST(5.00 AS Numeric(18, 2)), N'', CAST(0x0000A20E00396659 AS DateTime), N'TEST CREDIT', CAST(5.00 AS Decimal(18, 2)), NULL, 2277, CAST(0x0000A20E00396659 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (492, 2277, N'Debit', N'Debit Note', N'DN492', CAST(61.51 AS Numeric(18, 2)), N'', CAST(0x0000A20E00684E4F AS DateTime), N'VOIDED ORDER', NULL, CAST(61.51 AS Decimal(18, 2)), 22, CAST(0x0000A20E00684E4F AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (499, 2277, N'Credit', N'Invoice', N'INV10160', CAST(7.57 AS Numeric(18, 2)), NULL, CAST(0x0000A211005BA727 AS DateTime), NULL, CAST(7.57 AS Decimal(18, 2)), NULL, 2277, CAST(0x0000A211005BA727 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (500, 2277, N'Debit', N'Card', N'XXXX XXXX XXXX xx11', CAST(7.57 AS Numeric(18, 2)), NULL, CAST(0x0000A211005BA727 AS DateTime), NULL, NULL, CAST(7.57 AS Decimal(18, 2)), 2277, CAST(0x0000A211005BA727 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (501, 2277, N'Credit', N'Invoice', N'INV10163', CAST(7.87 AS Numeric(18, 2)), NULL, CAST(0x0000A211006172D7 AS DateTime), NULL, CAST(7.87 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A211006172D7 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (502, 2277, N'Debit', N'Card', N'XXXX XXXX XXXX xx11', CAST(7.87 AS Numeric(18, 2)), NULL, CAST(0x0000A21100619C67 AS DateTime), NULL, NULL, CAST(7.87 AS Decimal(18, 2)), 22, CAST(0x0000A21100619C67 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (503, 2277, N'Credit', N'Invoice', N'INV10164', CAST(18.75 AS Numeric(18, 2)), NULL, CAST(0x0000A2110081506F AS DateTime), NULL, CAST(18.75 AS Decimal(18, 2)), NULL, 2277, CAST(0x0000A2110081506F AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (504, 2277, N'Debit', N'Card', N'XXXX XXXX XXXX xx11', CAST(18.75 AS Numeric(18, 2)), NULL, CAST(0x0000A2110081506F AS DateTime), NULL, NULL, CAST(18.75 AS Decimal(18, 2)), 2277, CAST(0x0000A2110081506F AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (513, 2277, N'Credit', N'Invoice', N'INV10167', CAST(5.11 AS Numeric(18, 2)), NULL, CAST(0x0000A2120060C503 AS DateTime), NULL, CAST(5.11 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A2120060C503 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (514, 2277, N'Debit', N'Card', N'XXXX XXXX XXXX xx11', CAST(5.11 AS Numeric(18, 2)), NULL, CAST(0x0000A2120060C503 AS DateTime), NULL, NULL, CAST(5.11 AS Decimal(18, 2)), 22, CAST(0x0000A2120060C503 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (541, 2277, N'Credit', N'Invoice', N'INV10181', CAST(24.98 AS Numeric(18, 2)), NULL, CAST(0x0000A219014B6E38 AS DateTime), NULL, CAST(24.98 AS Decimal(18, 2)), NULL, 2277, CAST(0x0000A219014B6E38 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (542, 2277, N'Debit', N'Card', N'XXXX XXXX XXXX xx11', CAST(24.98 AS Numeric(18, 2)), NULL, CAST(0x0000A219014B6E39 AS DateTime), NULL, NULL, CAST(24.98 AS Decimal(18, 2)), 2277, CAST(0x0000A219014B6E39 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (543, 2277, N'Credit', N'Invoice', N'INV10182', CAST(3.74 AS Numeric(18, 2)), NULL, CAST(0x0000A2190152FA5D AS DateTime), NULL, CAST(3.74 AS Decimal(18, 2)), NULL, 2277, CAST(0x0000A2190152FA5D AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (544, 2277, N'Debit', N'Card', N'XXXX XXXX XXXX xx11', CAST(3.74 AS Numeric(18, 2)), NULL, CAST(0x0000A2190152FA5D AS DateTime), NULL, NULL, CAST(3.74 AS Decimal(18, 2)), 2277, CAST(0x0000A2190152FA5D AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (545, 2277, N'Credit', N'Invoice', N'INV10185', CAST(9.11 AS Numeric(18, 2)), NULL, CAST(0x0000A2190161B393 AS DateTime), NULL, CAST(9.11 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A2190161B393 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (546, 2277, N'Debit', N'Card', N'XXXX XXXX XXXX xx11', CAST(9.11 AS Numeric(18, 2)), NULL, CAST(0x0000A2190161FBB9 AS DateTime), NULL, NULL, CAST(9.11 AS Decimal(18, 2)), 22, CAST(0x0000A2190161FBB9 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (547, 2276, N'Credit', N'Invoice', N'INV10186', CAST(18.35 AS Numeric(18, 2)), NULL, CAST(0x0000A21A002262E7 AS DateTime), NULL, CAST(18.35 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A21A002262E7 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (548, 2276, N'Debit', N'Card', N'XXXX XXXX XXXX xx11', CAST(18.35 AS Numeric(18, 2)), NULL, CAST(0x0000A21A002262E8 AS DateTime), NULL, NULL, CAST(18.35 AS Decimal(18, 2)), 2276, CAST(0x0000A21A002262E8 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (275, 1050, N'Credit', N'Card', N'XXXX XXXX XXXX 5544', CAST(44.20 AS Numeric(18, 2)), NULL, CAST(0x0000A20101099CA0 AS DateTime), NULL, CAST(44.20 AS Decimal(18, 2)), NULL, 1050, CAST(0x0000A20101099CA0 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (276, 1050, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(44.20 AS Numeric(18, 2)), NULL, CAST(0x0000A20101099CA0 AS DateTime), NULL, NULL, CAST(44.20 AS Decimal(18, 2)), 1050, CAST(0x0000A20101099CA0 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (277, 1050, N'Credit', N'Card', N'XXXX XXXX XXXX 5544', CAST(36.72 AS Numeric(18, 2)), NULL, CAST(0x0000A2010112690F AS DateTime), NULL, CAST(36.72 AS Decimal(18, 2)), NULL, 1050, CAST(0x0000A2010112690F AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (278, 1050, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(36.72 AS Numeric(18, 2)), NULL, CAST(0x0000A2010112690F AS DateTime), NULL, NULL, CAST(36.72 AS Decimal(18, 2)), 1050, CAST(0x0000A2010112690F AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (279, 1050, N'Credit', N'Card', N'XXXX XXXX XXXX 5544', CAST(8.74 AS Numeric(18, 2)), NULL, CAST(0x0000A20101146C64 AS DateTime), NULL, CAST(8.74 AS Decimal(18, 2)), NULL, 1050, CAST(0x0000A20101146C64 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (280, 1050, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(8.74 AS Numeric(18, 2)), NULL, CAST(0x0000A20101146C64 AS DateTime), NULL, NULL, CAST(8.74 AS Decimal(18, 2)), 1050, CAST(0x0000A20101146C64 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (281, 1050, N'Credit', N'Card', N'XXXX XXXX XXXX 5544', CAST(73.37 AS Numeric(18, 2)), NULL, CAST(0x0000A201012392BB AS DateTime), NULL, CAST(73.37 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A201012392BB AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (282, 1050, N'Credit', N'Card', N'XXXX XXXX XXXX 5544', CAST(144.04 AS Numeric(18, 2)), NULL, CAST(0x0000A201012392BB AS DateTime), NULL, CAST(144.04 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A201012392BB AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (283, 1050, N'Credit', N'Card', N'XXXX XXXX XXXX 5544', CAST(130.31 AS Numeric(18, 2)), NULL, CAST(0x0000A20101248263 AS DateTime), NULL, CAST(130.31 AS Decimal(18, 2)), NULL, 1050, CAST(0x0000A20101248263 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (284, 1050, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(130.31 AS Numeric(18, 2)), NULL, CAST(0x0000A20101248263 AS DateTime), NULL, NULL, CAST(130.31 AS Decimal(18, 2)), 1050, CAST(0x0000A20101248263 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (285, 1050, N'Credit', N'Card', N'XXXX XXXX XXXX 5544', CAST(10.35 AS Numeric(18, 2)), NULL, CAST(0x0000A2010124EA0A AS DateTime), NULL, CAST(10.35 AS Decimal(18, 2)), NULL, 1050, CAST(0x0000A2010124EA0A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (286, 1050, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(10.35 AS Numeric(18, 2)), NULL, CAST(0x0000A2010124EA0A AS DateTime), NULL, NULL, CAST(10.35 AS Decimal(18, 2)), 1050, CAST(0x0000A2010124EA0A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (287, 1050, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(73.37 AS Numeric(18, 2)), NULL, CAST(0x0000A2010125C579 AS DateTime), NULL, NULL, CAST(73.37 AS Decimal(18, 2)), 22, CAST(0x0000A2010125C579 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (288, 1050, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(144.04 AS Numeric(18, 2)), NULL, CAST(0x0000A2010125C78C AS DateTime), NULL, NULL, CAST(144.04 AS Decimal(18, 2)), 22, CAST(0x0000A2010125C78C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (289, 1050, N'Credit', N'Card', N'XXXX XXXX XXXX 5544', CAST(30.35 AS Numeric(18, 2)), NULL, CAST(0x0000A2010127D0F6 AS DateTime), NULL, CAST(30.35 AS Decimal(18, 2)), NULL, 1050, CAST(0x0000A2010127D0F6 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (290, 1050, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(30.35 AS Numeric(18, 2)), NULL, CAST(0x0000A2010127D0F7 AS DateTime), NULL, NULL, CAST(30.35 AS Decimal(18, 2)), 1050, CAST(0x0000A2010127D0F7 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (291, 1050, N'Credit', N'Card', N'XXXX XXXX XXXX 5544', CAST(381.13 AS Numeric(18, 2)), NULL, CAST(0x0000A20101341D45 AS DateTime), NULL, CAST(381.13 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A20101341D45 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (292, 1050, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(381.13 AS Numeric(18, 2)), NULL, CAST(0x0000A20101343125 AS DateTime), NULL, NULL, CAST(381.13 AS Decimal(18, 2)), 22, CAST(0x0000A20101343125 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (293, 1050, N'Credit', N'Card', N'XXXX XXXX XXXX 5544', CAST(27.47 AS Numeric(18, 2)), NULL, CAST(0x0000A2010135B1E3 AS DateTime), NULL, CAST(27.47 AS Decimal(18, 2)), NULL, 1050, CAST(0x0000A2010135B1E3 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (294, 1050, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(27.47 AS Numeric(18, 2)), NULL, CAST(0x0000A2010135B1E3 AS DateTime), NULL, NULL, CAST(27.47 AS Decimal(18, 2)), 1050, CAST(0x0000A2010135B1E3 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (295, 1050, N'Credit', N'Card', N'XXXX XXXX XXXX 5544', CAST(8.74 AS Numeric(18, 2)), NULL, CAST(0x0000A2010135C40D AS DateTime), NULL, CAST(8.74 AS Decimal(18, 2)), NULL, 1050, CAST(0x0000A2010135C40D AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (296, 1050, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(8.74 AS Numeric(18, 2)), NULL, CAST(0x0000A2010135C40D AS DateTime), NULL, NULL, CAST(8.74 AS Decimal(18, 2)), 1050, CAST(0x0000A2010135C40D AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (297, 3282, N'Credit', N'Invoice', N'INV10039', CAST(41.63 AS Numeric(18, 2)), NULL, CAST(0x0000A20400576A41 AS DateTime), NULL, CAST(41.63 AS Decimal(18, 2)), NULL, 3282, CAST(0x0000A20400576A41 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (298, 3282, N'Debit', N'Card', N'XXXX XXXX XXXX 1111', CAST(41.63 AS Numeric(18, 2)), NULL, CAST(0x0000A20400576A41 AS DateTime), NULL, NULL, CAST(41.63 AS Decimal(18, 2)), 3282, CAST(0x0000A20400576A41 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (299, 3282, N'Credit', N'Invoice', N'INV10040', CAST(41.63 AS Numeric(18, 2)), NULL, CAST(0x0000A2040058F4B8 AS DateTime), NULL, CAST(41.63 AS Decimal(18, 2)), NULL, 3282, CAST(0x0000A2040058F4B8 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (300, 3282, N'Debit', N'Card', N'XXXX XXXX XXXX 1111', CAST(41.63 AS Numeric(18, 2)), NULL, CAST(0x0000A2040058F4B8 AS DateTime), NULL, NULL, CAST(41.63 AS Decimal(18, 2)), 3282, CAST(0x0000A2040058F4B8 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (301, 2278, N'Credit', N'Invoice', N'INV10042', CAST(47.78 AS Numeric(18, 2)), NULL, CAST(0x0000A20400D28E63 AS DateTime), NULL, CAST(47.78 AS Decimal(18, 2)), NULL, 2278, CAST(0x0000A20400D28E63 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (302, 2278, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(47.78 AS Numeric(18, 2)), NULL, CAST(0x0000A20400D28E63 AS DateTime), NULL, NULL, CAST(47.78 AS Decimal(18, 2)), 2278, CAST(0x0000A20400D28E63 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (303, 2278, N'Credit', N'Invoice', N'INV10043', CAST(4.93 AS Numeric(18, 2)), NULL, CAST(0x0000A204013BBFF5 AS DateTime), NULL, CAST(4.93 AS Decimal(18, 2)), NULL, 2278, CAST(0x0000A204013BBFF5 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (304, 2278, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(4.93 AS Numeric(18, 2)), NULL, CAST(0x0000A204013BBFF5 AS DateTime), NULL, NULL, CAST(4.93 AS Decimal(18, 2)), 2278, CAST(0x0000A204013BBFF5 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (305, 2278, N'Credit', N'Invoice', N'INV10045', CAST(8.17 AS Numeric(18, 2)), NULL, CAST(0x0000A2040150AD16 AS DateTime), NULL, CAST(8.17 AS Decimal(18, 2)), NULL, 2278, CAST(0x0000A2040150AD16 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (306, 2278, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(8.17 AS Numeric(18, 2)), NULL, CAST(0x0000A2040150AD16 AS DateTime), NULL, NULL, CAST(8.17 AS Decimal(18, 2)), 2278, CAST(0x0000A2040150AD16 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (307, 3284, N'Credit', N'Invoice', N'INV10047', CAST(59.06 AS Numeric(18, 2)), NULL, CAST(0x0000A204016957C6 AS DateTime), NULL, CAST(59.06 AS Decimal(18, 2)), NULL, 3284, CAST(0x0000A204016957C6 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (308, 3284, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(59.06 AS Numeric(18, 2)), NULL, CAST(0x0000A204016957C7 AS DateTime), NULL, NULL, CAST(59.06 AS Decimal(18, 2)), 3284, CAST(0x0000A204016957C7 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (309, 2278, N'Credit', N'Invoice', N'INV10048', CAST(44.54 AS Numeric(18, 2)), NULL, CAST(0x0000A204016AECE5 AS DateTime), NULL, CAST(44.54 AS Decimal(18, 2)), NULL, 2278, CAST(0x0000A204016AECE5 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (310, 2278, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(44.54 AS Numeric(18, 2)), NULL, CAST(0x0000A204016AECE5 AS DateTime), NULL, NULL, CAST(44.54 AS Decimal(18, 2)), 2278, CAST(0x0000A204016AECE5 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (311, 3284, N'Credit', N'Invoice', N'INV10049', CAST(19.71 AS Numeric(18, 2)), NULL, CAST(0x0000A204016EA991 AS DateTime), NULL, CAST(19.71 AS Decimal(18, 2)), NULL, 3284, CAST(0x0000A204016EA991 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (312, 3284, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(19.71 AS Numeric(18, 2)), NULL, CAST(0x0000A204016EA991 AS DateTime), NULL, NULL, CAST(19.71 AS Decimal(18, 2)), 3284, CAST(0x0000A204016EA991 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (313, 3284, N'Credit', N'Invoice', N'INV10050', CAST(17.69 AS Numeric(18, 2)), NULL, CAST(0x0000A204016FD1DC AS DateTime), NULL, CAST(17.69 AS Decimal(18, 2)), NULL, 3284, CAST(0x0000A204016FD1DC AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (314, 3284, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(17.69 AS Numeric(18, 2)), NULL, CAST(0x0000A204016FD1DC AS DateTime), NULL, NULL, CAST(17.69 AS Decimal(18, 2)), 3284, CAST(0x0000A204016FD1DC AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (315, 3284, N'Credit', N'Invoice', N'INV10051', CAST(4.14 AS Numeric(18, 2)), NULL, CAST(0x0000A20401719B28 AS DateTime), NULL, CAST(4.14 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A20401719B28 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (316, 3284, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(4.14 AS Numeric(18, 2)), NULL, CAST(0x0000A20401719B28 AS DateTime), NULL, NULL, CAST(4.14 AS Decimal(18, 2)), 22, CAST(0x0000A20401719B28 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (317, 3284, N'Credit', N'Invoice', N'INV10052', CAST(2.70 AS Numeric(18, 2)), NULL, CAST(0x0000A204017420BE AS DateTime), NULL, CAST(2.70 AS Decimal(18, 2)), NULL, 3284, CAST(0x0000A204017420BE AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (318, 3284, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(2.70 AS Numeric(18, 2)), NULL, CAST(0x0000A204017420BE AS DateTime), NULL, NULL, CAST(2.70 AS Decimal(18, 2)), 3284, CAST(0x0000A204017420BE AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (319, 3284, N'Credit', N'Invoice', N'INV10053', CAST(5.25 AS Numeric(18, 2)), NULL, CAST(0x0000A204018568E4 AS DateTime), NULL, CAST(5.25 AS Decimal(18, 2)), NULL, 3284, CAST(0x0000A204018568E4 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (320, 3284, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(5.25 AS Numeric(18, 2)), NULL, CAST(0x0000A204018568E4 AS DateTime), NULL, NULL, CAST(5.25 AS Decimal(18, 2)), 3284, CAST(0x0000A204018568E4 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (321, 2278, N'Credit', N'Invoice', N'INV10054', CAST(17.48 AS Numeric(18, 2)), NULL, CAST(0x0000A205000DDC32 AS DateTime), NULL, CAST(17.48 AS Decimal(18, 2)), NULL, 2278, CAST(0x0000A205000DDC32 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (322, 2278, N'Debit', N'Card', N'XXXX XXXX XXXX 5544', CAST(17.48 AS Numeric(18, 2)), NULL, CAST(0x0000A205000DDC32 AS DateTime), NULL, NULL, CAST(17.48 AS Decimal(18, 2)), 2278, CAST(0x0000A205000DDC32 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (582, 3285, N'Credit', N'Card', N'INV10218', NULL, NULL, CAST(0x0000A21F00D14817 AS DateTime), NULL, CAST(3.27 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A21F00D14817 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (583, 3285, N'Debit', N'Card', N'INV10218', NULL, NULL, CAST(0x0000A21F00D14817 AS DateTime), NULL, NULL, CAST(3.27 AS Decimal(18, 2)), 22, CAST(0x0000A21F00D14817 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (584, 3290, N'Credit', N'Credit Note', N'CN584', NULL, N'', CAST(0x0000A21F00D19EC1 AS DateTime), N'test', CAST(100.00 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A21F00D19EC1 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1620, 3285, N'Credit', N'Card', N'INV11237', NULL, NULL, CAST(0x0000A22701733FD6 AS DateTime), NULL, CAST(3.27 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22701733FD6 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1621, 3285, N'Debit', N'Card', N'INV11237', NULL, NULL, CAST(0x0000A22701733FD6 AS DateTime), NULL, NULL, CAST(3.27 AS Decimal(18, 2)), 22, CAST(0x0000A22701733FD6 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1630, 3289, N'Credit', N'Credit Note', N'CN1630', NULL, N'', CAST(0x0000A22800179C8B AS DateTime), N'test', CAST(12.00 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22800179C8B AS DateTime), 22, CAST(0x0000A22B011693B6 AS DateTime))
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1645, 3289, N'Credit', N'Card', N'INV11253', NULL, NULL, CAST(0x0000A22B00DC7482 AS DateTime), NULL, CAST(19.78 AS Decimal(18, 2)), NULL, 3289, CAST(0x0000A22B00DC7482 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1646, 3289, N'Debit', N'Card', N'INV11253', NULL, NULL, CAST(0x0000A22B00DC7482 AS DateTime), NULL, NULL, CAST(19.78 AS Decimal(18, 2)), 3289, CAST(0x0000A22B00DC7482 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1647, 3290, N'Credit', N'Card', N'INV11256', NULL, NULL, CAST(0x0000A22B00EFDB0D AS DateTime), NULL, CAST(23.05 AS Decimal(18, 2)), NULL, 3290, CAST(0x0000A22B00EFDB0D AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1648, 3290, N'Debit', N'Card', N'INV11256', NULL, NULL, CAST(0x0000A22B00EFDB0D AS DateTime), NULL, NULL, CAST(23.05 AS Decimal(18, 2)), 3290, CAST(0x0000A22B00EFDB0D AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1664, 3290, N'Credit', N'Card', N'INV11283', NULL, NULL, CAST(0x0000A22B0102387B AS DateTime), NULL, CAST(24.00 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B0102387B AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1665, 3290, N'Debit', N'Card', N'INV11283', NULL, NULL, CAST(0x0000A22B0102387C AS DateTime), NULL, NULL, CAST(24.00 AS Decimal(18, 2)), 22, CAST(0x0000A22B0102387C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (335, 2278, N'Credit', N'Invoice', N'INV10064', CAST(7.08 AS Numeric(18, 2)), NULL, CAST(0x0000A2050022749A AS DateTime), NULL, CAST(7.08 AS Decimal(18, 2)), NULL, 2278, CAST(0x0000A2050022749A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (571, 2276, N'Credit', N'Card', N'INV10206', NULL, NULL, CAST(0x0000A21D01065DBC AS DateTime), NULL, CAST(7.84 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A21D01065DBC AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (572, 2276, N'Debit', N'Card', N'INV10206', NULL, NULL, CAST(0x0000A21D01065DBC AS DateTime), NULL, NULL, CAST(7.84 AS Decimal(18, 2)), 2276, CAST(0x0000A21D01065DBC AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (573, 2276, N'Credit', N'Card', N'INV10207', NULL, NULL, CAST(0x0000A21D010802E6 AS DateTime), NULL, CAST(5.84 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A21D010802E6 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (574, 2276, N'Debit', N'Card', N'INV10207', NULL, NULL, CAST(0x0000A21D010802E7 AS DateTime), NULL, NULL, CAST(5.84 AS Decimal(18, 2)), 2276, CAST(0x0000A21D010802E7 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (575, 2276, N'Credit', N'Card', N'INV10208', NULL, NULL, CAST(0x0000A21D0108FBD0 AS DateTime), NULL, CAST(9.35 AS Decimal(18, 2)), NULL, 2276, CAST(0x0000A21D0108FBD0 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (576, 2276, N'Debit', N'Card', N'INV10208', NULL, NULL, CAST(0x0000A21D0108FBD0 AS DateTime), NULL, NULL, CAST(9.35 AS Decimal(18, 2)), 2276, CAST(0x0000A21D0108FBD0 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (577, 2276, N'Credit', N'Credit Note', N'CN577', NULL, N'', CAST(0x0000A21D0109EF96 AS DateTime), N'TEST CREDIT', CAST(10.00 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A21D0109EF96 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1666, 3289, N'Credit', N'Card', N'INV11284', NULL, NULL, CAST(0x0000A22B01024718 AS DateTime), NULL, CAST(24.15 AS Decimal(18, 2)), NULL, 3289, CAST(0x0000A22B01024718 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1667, 3289, N'Debit', N'Card', N'INV11284', NULL, NULL, CAST(0x0000A22B01024718 AS DateTime), NULL, NULL, CAST(24.15 AS Decimal(18, 2)), 3289, CAST(0x0000A22B01024718 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1670, 3290, N'Credit', N'Card', N'INV11287', NULL, NULL, CAST(0x0000A22B0103E779 AS DateTime), NULL, CAST(29.75 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B0103E779 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1673, 3286, N'Credit', N'Card', N'INV11291', NULL, NULL, CAST(0x0000A22B0105DF4C AS DateTime), NULL, CAST(9.14 AS Decimal(18, 2)), NULL, 3286, CAST(0x0000A22B0105DF4C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1674, 3286, N'Debit', N'Card', N'INV11291', NULL, NULL, CAST(0x0000A22B0105DF4C AS DateTime), NULL, NULL, CAST(9.14 AS Decimal(18, 2)), 3286, CAST(0x0000A22B0105DF4C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1675, 3293, N'Credit', N'Card', N'INV11292', NULL, NULL, CAST(0x0000A22B0106AED9 AS DateTime), NULL, CAST(6.72 AS Decimal(18, 2)), NULL, 3293, CAST(0x0000A22B0106AED9 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1676, 3293, N'Debit', N'Card', N'INV11292', NULL, NULL, CAST(0x0000A22B0106AED9 AS DateTime), NULL, NULL, CAST(6.72 AS Decimal(18, 2)), 3293, CAST(0x0000A22B0106AED9 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1618, 2277, N'Credit', N'Card', N'INV11236', NULL, NULL, CAST(0x0000A227013A4962 AS DateTime), NULL, CAST(40.06 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A227013A4962 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1619, 2277, N'Debit', N'Card', N'INV11236', NULL, NULL, CAST(0x0000A227013B3CEC AS DateTime), NULL, NULL, CAST(40.06 AS Decimal(18, 2)), 22, CAST(0x0000A227013B3CEC AS DateTime), NULL, NULL)
GO
print 'Processed 200 total records'
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1649, 3289, N'Credit', N'Card', N'INV11257', NULL, NULL, CAST(0x0000A22B00F18F90 AS DateTime), NULL, CAST(72.45 AS Decimal(18, 2)), NULL, 3289, CAST(0x0000A22B00F18F90 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1650, 3289, N'Debit', N'Card', N'INV11257', NULL, NULL, CAST(0x0000A22B00F18F90 AS DateTime), NULL, NULL, CAST(72.45 AS Decimal(18, 2)), 3289, CAST(0x0000A22B00F18F90 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1651, 3290, N'Credit', N'Card', N'INV11258', NULL, NULL, CAST(0x0000A22B00F1BD23 AS DateTime), NULL, CAST(1.18 AS Decimal(18, 2)), NULL, 3290, CAST(0x0000A22B00F1BD23 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1652, 3290, N'Debit', N'Card', N'INV11258', NULL, NULL, CAST(0x0000A22B00F1BD23 AS DateTime), NULL, NULL, CAST(1.18 AS Decimal(18, 2)), 3290, CAST(0x0000A22B00F1BD23 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1653, 3289, N'Credit', N'Card', N'INV11259', NULL, NULL, CAST(0x0000A22B00F1CA52 AS DateTime), NULL, CAST(19.78 AS Decimal(18, 2)), NULL, 3289, CAST(0x0000A22B00F1CA52 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1654, 3289, N'Debit', N'Card', N'INV11259', NULL, NULL, CAST(0x0000A22B00F1CA52 AS DateTime), NULL, NULL, CAST(19.78 AS Decimal(18, 2)), 3289, CAST(0x0000A22B00F1CA52 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1657, 3290, N'Credit', N'Card', N'INV11267', NULL, NULL, CAST(0x0000A22B00F6230A AS DateTime), NULL, CAST(19.78 AS Decimal(18, 2)), NULL, 3290, CAST(0x0000A22B00F6230A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1658, 3290, N'Debit', N'Card', N'INV11267', NULL, NULL, CAST(0x0000A22B00F6230B AS DateTime), NULL, NULL, CAST(19.78 AS Decimal(18, 2)), 3290, CAST(0x0000A22B00F6230B AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1671, 3290, N'Credit', N'Card', N'INV11290', NULL, NULL, CAST(0x0000A22B0105222E AS DateTime), NULL, CAST(3.27 AS Decimal(18, 2)), NULL, 3290, CAST(0x0000A22B0105222E AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1672, 3290, N'Debit', N'Card', N'INV11290', NULL, NULL, CAST(0x0000A22B0105222E AS DateTime), NULL, NULL, CAST(3.27 AS Decimal(18, 2)), 3290, CAST(0x0000A22B0105222E AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1677, 3286, N'Credit', N'Card', N'INV11294', NULL, NULL, CAST(0x0000A22B01096E42 AS DateTime), NULL, CAST(72.54 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B01096E42 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1678, 3292, N'Credit', N'Card', N'INV11296', NULL, NULL, CAST(0x0000A22B0109DC75 AS DateTime), NULL, CAST(9.27 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B0109DC75 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1679, 3292, N'Debit', N'Card', N'INV11296', NULL, NULL, CAST(0x0000A22B0109DC75 AS DateTime), NULL, NULL, CAST(9.27 AS Decimal(18, 2)), 22, CAST(0x0000A22B0109DC75 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1680, 3290, N'Credit', N'Card', N'INV11262', NULL, NULL, CAST(0x0000A22B010A04A6 AS DateTime), NULL, CAST(12.97 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B010A04A6 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1681, 3286, N'Debit', N'Card', N'INV11294', NULL, NULL, CAST(0x0000A22B010AA423 AS DateTime), NULL, NULL, CAST(72.54 AS Decimal(18, 2)), 22, CAST(0x0000A22B010AA423 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1682, 3292, N'Credit', N'Card', N'INV11298', NULL, NULL, CAST(0x0000A22B010D2874 AS DateTime), NULL, CAST(63.19 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B010D2874 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1683, 3289, N'Credit', N'Card', N'INV11289', NULL, NULL, CAST(0x0000A22B010F01B2 AS DateTime), NULL, CAST(42.83 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B010F01B2 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1684, 3289, N'Debit', N'Card', N'INV11289', NULL, NULL, CAST(0x0000A22B010F3F53 AS DateTime), NULL, NULL, CAST(42.83 AS Decimal(18, 2)), 22, CAST(0x0000A22B010F3F53 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1687, 3289, N'Credit', N'Card', N'INV11299', NULL, NULL, CAST(0x0000A22B0118653A AS DateTime), NULL, CAST(197.80 AS Decimal(18, 2)), NULL, 3289, CAST(0x0000A22B0118653A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1688, 3289, N'Debit', N'Card', N'INV11299', NULL, NULL, CAST(0x0000A22B0118653A AS DateTime), NULL, NULL, CAST(197.80 AS Decimal(18, 2)), 3289, CAST(0x0000A22B0118653A AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1691, 3293, N'Credit', N'ECheck', N'INV11301', NULL, NULL, CAST(0x0000A22B011980F8 AS DateTime), NULL, CAST(3.33 AS Decimal(18, 2)), NULL, 3293, CAST(0x0000A22B011980F8 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1692, 3293, N'Debit', N'ECheck', N'INV11301', NULL, NULL, CAST(0x0000A22B011980F9 AS DateTime), NULL, NULL, CAST(3.33 AS Decimal(18, 2)), 3293, CAST(0x0000A22B011980F9 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1693, 3293, N'Credit', N'ECheck', N'INV11302', NULL, NULL, CAST(0x0000A22B011AACD7 AS DateTime), NULL, CAST(3.33 AS Decimal(18, 2)), NULL, 3293, CAST(0x0000A22B011AACD7 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1694, 3293, N'Debit', N'ECheck', N'INV11302', NULL, NULL, CAST(0x0000A22B011AACD7 AS DateTime), NULL, NULL, CAST(3.33 AS Decimal(18, 2)), 3293, CAST(0x0000A22B011AACD7 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1695, 3289, N'Credit', N'Card', N'INV11255', NULL, NULL, CAST(0x0000A22B011C4AD4 AS DateTime), NULL, CAST(-27.77 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B011C4AD4 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1696, 2173, N'Credit', N'Card', N'INV11303', NULL, NULL, CAST(0x0000A22B0121BBF4 AS DateTime), NULL, CAST(19.01 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B0121BBF4 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1697, 2173, N'Debit', N'Card', N'INV11303', NULL, NULL, CAST(0x0000A22B0121BBF4 AS DateTime), NULL, NULL, CAST(19.01 AS Decimal(18, 2)), 22, CAST(0x0000A22B0121BBF4 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1698, 2181, N'Credit', N'Card', N'INV11348', NULL, NULL, CAST(0x0000A22B0124D469 AS DateTime), NULL, CAST(9.58 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B0124D469 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1699, 2181, N'Debit', N'Card', N'INV11348', NULL, NULL, CAST(0x0000A22B0124D469 AS DateTime), NULL, NULL, CAST(9.58 AS Decimal(18, 2)), 22, CAST(0x0000A22B0124D469 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1700, 3292, N'Credit', N'Card', N'INV11351', NULL, NULL, CAST(0x0000A22B01290F9E AS DateTime), NULL, CAST(24.72 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B01290F9E AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1701, 3292, N'Debit', N'Card', N'INV11351', NULL, NULL, CAST(0x0000A22B01290F9E AS DateTime), NULL, NULL, CAST(24.72 AS Decimal(18, 2)), 22, CAST(0x0000A22B01290F9E AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1702, 3293, N'Credit', N'Card', N'INV11352', NULL, NULL, CAST(0x0000A22B0129C053 AS DateTime), NULL, CAST(33.90 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B0129C053 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1703, 3293, N'Debit', N'Card', N'INV11352', NULL, NULL, CAST(0x0000A22B0129C053 AS DateTime), NULL, NULL, CAST(33.90 AS Decimal(18, 2)), 22, CAST(0x0000A22B0129C053 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1704, 3293, N'Credit', N'Card', N'INV11353', NULL, NULL, CAST(0x0000A22B0131C153 AS DateTime), NULL, CAST(24.00 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B0131C153 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1705, 3293, N'Debit', N'Card', N'INV11353', NULL, NULL, CAST(0x0000A22B0131C153 AS DateTime), NULL, NULL, CAST(24.00 AS Decimal(18, 2)), 22, CAST(0x0000A22B0131C153 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1706, 3293, N'Credit', N'Card', N'INV11354', NULL, NULL, CAST(0x0000A22B01380087 AS DateTime), NULL, CAST(207.50 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B01380087 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1707, 3293, N'Debit', N'Card', N'INV11354', NULL, NULL, CAST(0x0000A22B01380087 AS DateTime), NULL, NULL, CAST(207.50 AS Decimal(18, 2)), 22, CAST(0x0000A22B01380087 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1708, 3292, N'Credit', N'Card', N'INV11358', NULL, NULL, CAST(0x0000A22B013E1982 AS DateTime), NULL, CAST(164.70 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B013E1982 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1709, 3292, N'Debit', N'Card', N'INV11358', NULL, NULL, CAST(0x0000A22B013E1982 AS DateTime), NULL, NULL, CAST(164.70 AS Decimal(18, 2)), 22, CAST(0x0000A22B013E1982 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1655, 3290, N'Credit', N'Card', N'INV11266', NULL, NULL, CAST(0x0000A22B00F5E545 AS DateTime), NULL, CAST(49.53 AS Decimal(18, 2)), NULL, 3290, CAST(0x0000A22B00F5E545 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1656, 3290, N'Debit', N'Card', N'INV11266', NULL, NULL, CAST(0x0000A22B00F5E545 AS DateTime), NULL, NULL, CAST(49.53 AS Decimal(18, 2)), 3290, CAST(0x0000A22B00F5E545 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1659, 3289, N'Credit', N'Card', N'INV11265', NULL, NULL, CAST(0x0000A22B00FDABA0 AS DateTime), NULL, CAST(-9.97 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B00FDABA0 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1660, 3292, N'Credit', N'Card', N'INV11272', NULL, NULL, CAST(0x0000A22B00FE3370 AS DateTime), NULL, CAST(39.56 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B00FE3370 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1661, 3292, N'Debit', N'Card', N'INV11272', NULL, NULL, CAST(0x0000A22B00FE3370 AS DateTime), NULL, NULL, CAST(39.56 AS Decimal(18, 2)), 22, CAST(0x0000A22B00FE3370 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1662, 3289, N'Credit', N'Card', N'INV11282', NULL, NULL, CAST(0x0000A22B00FEAD08 AS DateTime), NULL, CAST(20.34 AS Decimal(18, 2)), NULL, 3289, CAST(0x0000A22B00FEAD08 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1663, 3289, N'Debit', N'Card', N'INV11282', NULL, NULL, CAST(0x0000A22B00FEAD08 AS DateTime), NULL, NULL, CAST(20.34 AS Decimal(18, 2)), 3289, CAST(0x0000A22B00FEAD08 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1668, 3289, N'Credit', N'Card', N'INV11285', NULL, NULL, CAST(0x0000A22B01029D1C AS DateTime), NULL, CAST(19.78 AS Decimal(18, 2)), NULL, 3289, CAST(0x0000A22B01029D1C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1669, 3289, N'Debit', N'Card', N'INV11285', NULL, NULL, CAST(0x0000A22B01029D1C AS DateTime), NULL, NULL, CAST(19.78 AS Decimal(18, 2)), 3289, CAST(0x0000A22B01029D1C AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1685, 3290, N'Credit', N'Credit Note', N'CN1685', NULL, N'', CAST(0x0000A22B01183315 AS DateTime), N'test', CAST(200.00 AS Decimal(18, 2)), NULL, 22, CAST(0x0000A22B01183315 AS DateTime), 22, CAST(0x0000A22B01185FA2 AS DateTime))
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1686, 3290, N'Debit', N'Debit Note', N'DN1686', NULL, N'', CAST(0x0000A22B01184621 AS DateTime), N'testing', NULL, CAST(200.00 AS Decimal(18, 2)), 22, CAST(0x0000A22B01184621 AS DateTime), 22, CAST(0x0000A22B011881B6 AS DateTime))
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1689, 3293, N'Credit', N'Card', N'INV11300', NULL, NULL, CAST(0x0000A22B01188D99 AS DateTime), NULL, CAST(118.68 AS Decimal(18, 2)), NULL, 3293, CAST(0x0000A22B01188D99 AS DateTime), NULL, NULL)
INSERT [dbo].[Customer_Ledger_New] ([Customer_Ledger_ID], [User_ID], [Ledger_Type], [Transcation], [Reference], [Amount], [Particulars], [DateOfTranscation], [Remarks], [CreditAmount], [DebitAmount], [Created_By], [Created_On], [Modified_By], [Modified_On]) VALUES (1690, 3293, N'Debit', N'Card', N'INV11300', NULL, NULL, CAST(0x0000A22B01188D99 AS DateTime), NULL, NULL, CAST(118.68 AS Decimal(18, 2)), 3293, CAST(0x0000A22B01188D99 AS DateTime), NULL, NULL)
SET IDENTITY_INSERT [dbo].[Customer_Ledger_New] OFF

JanakiRam

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-09-02 : 09:59:39

i think culprit is UDF [dbo].[Get_LedgerOpenbalance]. Is it doing a recursive call?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

JanakiRam
Starting Member

22 Posts

Posted - 2013-09-02 : 10:17:41

Ya yes Mr.Vikas

JanakiRam

JanakiRam
Starting Member

22 Posts

Posted - 2013-09-02 : 10:18:29

Sry .. Mr.visakh16

JanakiRam

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-09-02 : 10:58:39

quote:
Originally posted by JanakiRam

Sry .. Mr.visakh16

JanakiRam

what exactly is it doing? can you explain?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

JanakiRam
Starting Member

22 Posts

Posted - 2013-09-04 : 00:31:42

As per above mentioned i have used two computed columns Opening Balance and closing Balance these two are not manually saved if any changed based on userid and TranscationDate it will be updated automatically over all the table.

It works fine each user have only 31 records then any user have more than 31 records above mentioned error returns. Please verify

JanakiRam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-09-04 : 12:49:45

You'll need to post the UDF.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources