www.carevisioncms.co.uk

Shadow Warrior

Shadow Warrior

Infinity Member
Golden Member
Joined
Jun 14, 2024
Messages
2,617
Reaction score
31,568
Points
113

www.carevisioncms.co.uk
Care Vision is a cloud based care home management system, centred around carers and the people they look after
Date July 2024.
rows 23534 users.
Sample :
Code: 
Data( First Part) : accountPayeeLogsID,contractID,accountPayeeID,accountReference,accountReferenceID,nominal,nominalOther,funding,paymentTerm,paymentTermOther,additionalNote,fundingOther,contactName,contactAddress,contactPostCode,contactPhone,contactEmail,contactFax,openingBalance,ContractImage,isFunding,payeeID,payeeName,contribution,totalContribution,cronDays,invoiceDateDays,invoiceDay,status,cost_centre,is_anonymous_invoice,anonymous_invoice_code,created_at,updated_at,updated_by,deleted_by,created_by,table
16152,14922,15188,Kent County Council (KCC),4834,4011,,LA,,,,,Leanne Silvester,Brook House,CT5 3SS,03000 416333,CPT@govuk,,0,,1,15188,Leanne Silvester,1200,4800,1,7,,1,9,0,,2024-05-16 14:34:16,2024-05-16 16:10:00,,,NULL,tbl_account_payee_logs
643,625,0,1,Pending,,,Bryan Down,Spittle Farm,EX187AN,07557434972,ldown@hotmailcouk,,851.76,3711.24,Private,Payment to be received within 7 days of invoice date,,,,Pam,502,7,0,01,R2,,,0,,,2020-02-28 14:16:03,2020-02-28 14:16:03,,,NULL,tbl_account_payee
4488,4374,0,1,Pending,,,Mary Joan Smith,na,na,na,na,na,754.6,6468,Private,Payment to be received within 7 days of invoice date,,,,SMI002,1027,7,0,01,4000,,,0,,,2022-04-26 10:59:03,2022-12-28 16:48:11,,,NULL,tbl_account_payee
6337,6173,0,1,Pending,,,L B Of Bromley-Emily Penfold,London Borough of Bromley,BR1 3HU,0,na@mailcom,,669.18,2676.72,LA,Payment to be received within 7 days of invoice date,,,,EMP002,245,30,60,,4000,,,0,,,2022-10-21 11:01:55,2022-10-21 11:01:55,,,NULL,tbl_account_payee
7307,7131,0,1,Pending,,,Mary Joan Smith,.,.,.,.,.,10,184.286,LA,Payment to be received within 7 days of invoice date,,,,SMI003,1064,7,0,01,4000,,,0,,,2023-02-01 12:57:59,2023-02-01 12:57:59,,,NULL,tbl_account_payee
1917,1878,0,1,Pending,,,Sheila Shaw,Yorkfield,BB6 7DT,na,na,na,950,10042.9,Private,Payment to be received within 7 days of invoice date,,,,SHA001,909,7,7,,4000,,,0,,,2021-01-26 16:03:47,2021-01-26 16:03:47,,,NULL,tbl_account_payee
3844,3732,0,1,Pending,,,,,-,-,Ninajacobs@hotmailcom,-,0,30,Private,,,,,SU0039,376,,,,4003,,,0,,,2022-03-01 16:52:19,2022-03-01 16:52:19,,,NULL,tbl_account_payee
8732,8524,0,1,Pending,,,L B of Bromley - Frederick Bidwell,London Borough of Bromley,BR1 3UH,0,na@mailcom,,585.74,2342.96,LA,Payment to be received within 7 days of invoice date,,,,FB002,167,30,60,,4000,,,0,,,2023-05-17 16:23:49,2023-05-17 16:23:49,,,NULL,tbl_account_payee
8845,8637,0,1,Pending,,,L B of Bromley- Judith Edgar (JE 123394),London Borough Of Bromley,BR1 3UH,0208 603 3519,Residential@liberatacom,N/A,753.6,3014.4,LA,Payment to be received within 7 days of invoice date,,,,JE002,898,30,60,,4000,,,0,,,2022-11-07 16:17:40,2024-04-12 15:17:51,,,NULL,tbl_account_payee
15058,14792,0,1,Pending,,,John Lofthouse,"THE FIRS RESIDENTIAL HOME FOR THE ELDERLY,9",DE72 3BU,07946748290,terebellum2@gmailcom,,835,3340,Private,Payment to be received within 7 days of invoice date,,,,Madeline Lofthouse,4753,60,7,,Client Contribution,,,0,,,2024-05-10 17:09:15,2024-05-10 17:09:15,,,NULL,tbl_account_payee
9719,9527,0,1,Pending,,,LB Redbridge,-,-,-,n/a@mailcom,-,945.29,3781.16,LA,Payment to be received within 7 days of invoice date,,,,LA0002,335,1,1,,4015,,,0,,,2023-08-25 16:08:32,2023-08-25 16:08:32,,,NULL,tbl_account_payee
3086,2994,0,1,Pending,,,Bristol City Council,NA,NA,NA,NA,NA,187.6,375.2,LA,Other,3 Working days after receipt of remittance,BCC,,Fees - FNC,962,7,7,,"Income account,Resident Fees: Funded Nursing Care",,,0,,,2021-09-21 17:14:16,2021-09-21 17:14:16,,,NULL,tbl_account_payee

Data( Second Part) : accountPayeeID,contractID,openingBalance,isFunding,accountStatus,paidFeeAt,paidFeeBy,contactName,contactAddress,contactPostCode,contactPhone,contactEmail,contactFax,contribution,totalContribution,funding,paymentTerm,paymentTermOther,additionalNote,fundingOther,accountReference,accountReferenceID,cronDays,invoiceDateDays,invoiceDay,nominal,nominalOther,cost_centre,is_anonymous_invoice,anonymous_invoice_code,ContractImage,created_at,updated_at,updated_by,deleted_by,created_by,table
1926,1786,1825,,571,4003,,Other,,,,Sundries,,,,,,,0,,1,1825,,0,28,,,,0,,0,,2021-01-05 15:00:21,2021-01-05 15:00:21,,,NULL,tbl_account_payee_logs
11779,10783,10977,POR001,2794,4000,,LA,,,,,N/A,N/A,N/A,N/A,N/A,N/A,0,,1,10977,N/A,1123.62,4815.51,7,0,Last Day of the Month,1,,0,,2023-11-23 17:11:19,2024-05-01 13:29:30,,,NULL,tbl_account_payee_logs
8830,7914,8112,HOL014,1557,4000,,LA,Payment to be received within 7 days of invoice date,,,,Mary Holland - LCC,.,.,.,.,.,0,,1,8112,Mary Holland - LCC,849.34,3640.03,7,0,01,0,,0,,2023-03-29 12:53:04,2023-03-29 12:53:04,,,NULL,tbl_account_payee_logs
15152,14040,14264,PF002,4536,4000,,LA,,,,,L B OF Bromley - Patricia French,London Borough Of Bromley,BR1 3UH,02084643333,Residential@liberatacom,N/A,0,,1,14264,L B OF Bromley - Patricia French,1380,5322.86,7,7,,0,,0,,2024-04-29 16:25:53,2024-04-29 16:25:53,,,NULL,tbl_account_payee_logs
8321,4668,4782,FNC,1210,4002,,PCT,,,,,"Beds,Luton,Milton Keynes CCG",Unknown,Unknown,07584207308,blmkccgchc@net,Unknown,0,,1,4782,"Beds,Luton,Milton Keynes CCG",219.71,973.001,30,30,,1,,0,,2023-03-15 11:44:04,2023-03-27 17:01:14,,,NULL,tbl_account_payee_logs
10056,9086,9278,LA0002,335,4015,,LA,Payment to be received within 7 days of invoice date,,,,LB Redbridge,-,-,-,n/a@mailcom,-,0,,1,9278,LB Redbridge,1126.67,4506.68,1,1,,0,,0,,2023-07-10 11:14:03,2023-07-10 11:14:03,,,NULL,tbl_account_payee_logs
3193,2854,2932,BID001,1012,4000,,LA,Payment to be received within 7 days of invoice date,,,,Jeffrey Biddulph,na,na,na,na,na,0,,1,2932,Jeffrey Biddulph,699.18,2297.31,7,7,,0,,0,,2021-08-09 16:56:50,2021-08-09 16:56:50,,,NULL,tbl_account_payee_logs
10585,9607,9799,,1267,4100,,Private,,,,,,,,,,,0,,1,9799,,0,10,,,,0,,0,,2023-09-07 09:05:36,2023-09-07 09:05:36,,,NULL,tbl_account_payee_logs
7457,7279,0,1,Pending,,,Natasha Garner,"Priory House,Monks Walk",SG17 5TQ,03003006691,natashagarner@centralbedfordshiregovuk,,695,99.2857,LA,Payment to be received within 7 days of invoice date,,,,Central Beds,1211,30,30,,4001,,,0,,,2023-02-21 19:03:10,2023-02-21 19:03:10,,,NULL,tbl_account_payee
To see this hidden content, you must reply and react with one of the following reactions : Like Like, Love Love, Haha Haha, Wow Wow
 
You must log in or register to reply here.
Top