SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

JanakiRam
Starting Member

India
22 Posts

Posted - 08/31/2013 :  15:11:11  Show Profile  Reply with Quote
'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

USA
37133 Posts

Posted - 08/31/2013 :  18:51:36  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

JanakiRam
Starting Member

India
22 Posts

Posted - 09/02/2013 :  03:04:18  Show Profile  Reply with Quote

/****** 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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 09/02/2013 :  09:59:39  Show Profile  Reply with Quote
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
Go to Top of Page

JanakiRam
Starting Member

India
22 Posts

Posted - 09/02/2013 :  10:17:41  Show Profile  Reply with Quote
Ya yes Mr.Vikas

JanakiRam
Go to Top of Page

JanakiRam
Starting Member

India
22 Posts

Posted - 09/02/2013 :  10:18:29  Show Profile  Reply with Quote
Sry .. Mr.visakh16

JanakiRam
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 09/02/2013 :  10:58:39  Show Profile  Reply with Quote
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
Go to Top of Page

JanakiRam
Starting Member

India
22 Posts

Posted - 09/04/2013 :  00:31:42  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 09/04/2013 :  12:49:45  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 2.39 seconds. Powered By: Snitz Forums 2000