text: --
  -- Script was generated by Devart dbForge Data Generator for SQL Server, Version 4.0.74.0
  -- Product Home Page: http://www.devart.com/dbforge/sql/data-generator/
  -- Script date 07.04.2018 17:59:13
  -- Target server version: 14.00.1000
  -- Target connection string: Connection Timeout=30;Data Source=HOME;Encrypt=False;MultipleActiveResultSets=False;Integrated Security=True;Packet Size=4096;TrustServerCertificate=False
  --
  
  
  
  SET LANGUAGE 'Russian'
  SET DATEFORMAT ymd
  SET ARITHABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
  SET NUMERIC_ROUNDABORT, IMPLICIT_TRANSACTIONS, XACT_ABORT OFF
  GO
  
  --
  -- Backing up database PaymentData
  --
  --
  -- Create backup folder
  --
  IF OBJECT_ID('xp_create_subdir') IS NOT NULL
    EXEC xp_create_subdir N'E:\programms\MSQLS\MSSQL14.MSSQLSERVER\MSSQL\Backup'
  --
  -- Backup database to the file with the name: <database_name>_<yyyy>_<mm>_<dd>_<hh>_<mi>.bak
  --
  DECLARE @db_name SYSNAME
  SET @db_name = N'PaymentData'
  
  DECLARE @filepath NVARCHAR(4000)
  SET @filepath =
  /*define base part*/ N'E:\programms\MSQLS\MSSQL14.MSSQLSERVER\MSSQL\Backup\' + @db_name + '_' +
  /*append date*/ REPLACE(CONVERT(NVARCHAR(10), GETDATE(), 102), '.', '_') + '_' +
  /*append time*/ REPLACE(CONVERT(NVARCHAR(5), GETDATE(), 108), ':', '_') + '.bak'
  
  DECLARE @SQL NVARCHAR(MAX)
  SET @SQL = 
      N'BACKUP DATABASE ' + QUOTENAME(@db_name) + ' TO DISK = @filepath WITH INIT' + 
        CASE WHEN EXISTS(
                  SELECT value
                  FROM sys.configurations
                  WHERE name = 'backup compression default'
            )
          THEN ', COMPRESSION'
          ELSE ''
        END
  
  EXEC sys.sp_executesql @SQL, N'@filepath NVARCHAR(4000)', @filepath = @filepath
  GO
  
  USE PaymentData
  GO
  
  IF DB_NAME() <> N'PaymentData' SET NOEXEC ON
  GO
  
  --
  -- Disabling DML triggers for dbo.PaymentParticipant
  --
  DISABLE TRIGGER ALL ON dbo.PaymentParticipant
  GO
  
  --
  -- Disabling DML triggers for dbo.Project
  --
  DISABLE TRIGGER ALL ON dbo.Project
  GO
  
  --
  -- Disabling DML triggers for dbo.Payment
  --
  DISABLE TRIGGER ALL ON dbo.Payment
  GO
  
  --
  -- Dropping constraints from dbo.Client
  --
  ALTER TABLE dbo.Client
    DROP CONSTRAINT IF EXISTS FK_Client_Oid
  GO
  
  --
  -- Dropping constraints from dbo.Employee
  --
  ALTER TABLE dbo.Employee
    DROP CONSTRAINT IF EXISTS FK_Employee_Head
  ALTER TABLE dbo.Employee
    DROP CONSTRAINT IF EXISTS FK_Employee_Oid
  GO
  
  --
  -- Dropping constraints from dbo.Project
  --
  ALTER TABLE dbo.Project
    DROP CONSTRAINT IF EXISTS FK_Project_Client
  ALTER TABLE dbo.Project
    DROP CONSTRAINT IF EXISTS FK_Project_Foreman
  ALTER TABLE dbo.Project
    DROP CONSTRAINT IF EXISTS FK_Project_Manager
  GO
  
  --
  -- Dropping constraints from dbo.Bank
  --
  ALTER TABLE dbo.Bank
    DROP CONSTRAINT IF EXISTS FK_Bank_AccountType
  ALTER TABLE dbo.Bank
    DROP CONSTRAINT IF EXISTS FK_Bank_Oid
  GO
  
  --
  -- Dropping constraints from dbo.Cashbox
  --
  ALTER TABLE dbo.Cashbox
    DROP CONSTRAINT IF EXISTS FK_Cashbox_AccountType
  ALTER TABLE dbo.Cashbox
    DROP CONSTRAINT IF EXISTS FK_Cashbox_Oid
  GO
  
  --
  -- Dropping constraints from dbo.Payment
  --
  ALTER TABLE dbo.Payment
    DROP CONSTRAINT IF EXISTS FK_Payment_Category
  ALTER TABLE dbo.Payment
    DROP CONSTRAINT IF EXISTS FK_Payment_Payee
  ALTER TABLE dbo.Payment
    DROP CONSTRAINT IF EXISTS FK_Payment_Payer
  ALTER TABLE dbo.Payment
    DROP CONSTRAINT IF EXISTS FK_Payment_Project
  GO
  
  --
  -- Dropping constraints from dbo.Supplier
  --
  ALTER TABLE dbo.Supplier
    DROP CONSTRAINT IF EXISTS FK_Supplier_Oid
  GO
  
  --
  -- Dropping indexes and constraints from dbo.PaymentParticipant
  --
  DROP INDEX IF EXISTS iGCRecord_PaymentParticipant ON PaymentData.dbo.PaymentParticipant
  GO
  DROP INDEX IF EXISTS iObjectType_PaymentParticipant ON PaymentData.dbo.PaymentParticipant
  GO
  
  --
  -- Dropping indexes and constraints from dbo.Employee
  --
  DROP INDEX IF EXISTS iHead_Employee ON PaymentData.dbo.Employee
  GO
  
  --
  -- Dropping indexes and constraints from dbo.Project
  --
  DROP INDEX IF EXISTS iClient_Project ON PaymentData.dbo.Project
  GO
  DROP INDEX IF EXISTS iForeman_Project ON PaymentData.dbo.Project
  GO
  DROP INDEX IF EXISTS iGCRecord_Project ON PaymentData.dbo.Project
  GO
  DROP INDEX IF EXISTS iManager_Project ON PaymentData.dbo.Project
  GO
  
  --
  -- Dropping indexes and constraints from dbo.Bank
  --
  DROP INDEX IF EXISTS iAccountType_Bank ON PaymentData.dbo.Bank
  GO
  ALTER TABLE dbo.Bank
    DROP CONSTRAINT IF EXISTS PK_Bank
  GO
  
  --
  -- Dropping indexes and constraints from dbo.Cashbox
  --
  DROP INDEX IF EXISTS iAccountType_Cashbox ON PaymentData.dbo.Cashbox
  GO
  ALTER TABLE dbo.Cashbox
    DROP CONSTRAINT IF EXISTS PK_Cashbox
  GO
  
  --
  -- Dropping indexes and constraints from dbo.Payment
  --
  DROP INDEX IF EXISTS iCategory_Payment ON PaymentData.dbo.Payment
  GO
  DROP INDEX IF EXISTS iGCRecord_Payment ON PaymentData.dbo.Payment
  GO
  DROP INDEX IF EXISTS iPayee_Payment ON PaymentData.dbo.Payment
  GO
  DROP INDEX IF EXISTS iPayer_Payment ON PaymentData.dbo.Payment
  GO
  DROP INDEX IF EXISTS iProject_Payment ON PaymentData.dbo.Payment
  GO
  ALTER TABLE dbo.Payment
    DROP CONSTRAINT IF EXISTS PK_Payment
  GO
  --
  -- Delete data from the table 'dbo.Supplier'
  --
  TRUNCATE TABLE dbo.Supplier
  GO
  --
  -- Delete data from the table 'dbo.Payment'
  --
  TRUNCATE TABLE dbo.Payment
  GO
  --
  -- Delete data from the table 'dbo.Cashbox'
  --
  TRUNCATE TABLE dbo.Cashbox
  GO
  --
  -- Delete data from the table 'dbo.Bank'
  --
  TRUNCATE TABLE dbo.Bank
  GO
  --
  -- Delete data from the table 'dbo.Project'
  --
  TRUNCATE TABLE dbo.Project
  GO
  --
  -- Delete data from the table 'dbo.Employee'
  --
  TRUNCATE TABLE dbo.Employee
  GO
  --
  -- Delete data from the table 'dbo.Client'
  --
  TRUNCATE TABLE dbo.Client
  GO
  --
  -- Delete data from the table 'dbo.PaymentParticipant'
  --
  TRUNCATE TABLE dbo.PaymentParticipant
  GO
  
  --
  -- Inserting data into table dbo.PaymentParticipant
  --
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('699acaa2-66da-563a-1702-ce5da15ac776', 1969, N'LNQKQ9781P', 2, NULL, 3, '1979-09-08 05:19:47.980', '1979-09-11 02:12:49.644', N'hjoxynhiqreljvxnkydr', 39, 47)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('2f1172a9-1b5d-6fc4-777e-3e3b283cabde', 6668, N'TZPBX7161K', 2, NULL, 1, '1974-02-25 01:35:53.700', '1974-03-12 17:28:03.024', N'hceixlqbakayahsgiyqbqbcvpbcjhcohqnaoaurcydo', 62, 37)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('2f8a5a0d-54fa-587b-5676-66508ad02725', 5269, N'TXKKN1483R', 1, NULL, 3, '2014-01-03 13:04:17.610', '2014-04-27 03:45:10.779', N'gjxpvxualatdktcebeqahhjmrlqjhtehvhbresjqxuizduhdlkybivxcudggoeiqtsrmzccjxmbkaewasjjnqbivmxtamjocpvle', 75, 6)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('6f0fc907-5bf7-6e28-ef96-94965a4eaa62', 8761, N'NSTFD3526N', 2, NULL, 3, '2005-10-24 03:13:11.020', '2006-02-18 00:23:59.128', N'dshcsnagjvxudpwrxzkzkzrlbdpeorsxcdvplccfhpopbatgnhrlydroivfrsyfagdtoqwewspaqdxuimprhniievb', 81, 15)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', 2194, N'GZSHY7839I', 1, NULL, 3, '2009-08-20 22:01:58.070', '2009-10-20 13:24:32.857', N'tdccsukcmxxzjpzkhcytvtzxaciohjquyabifwfptqagvwwfxmokkemscnbqctpvlrrwoggbhgwrmdfepnuwtklxhmlvragdoovk', 72, 77)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('7e919581-5fd4-1caf-5776-66508ad02725', 1824, N'CCLCL4513W', 2, NULL, 2, '1994-04-05 02:04:30.460', '1994-05-04 15:11:57.179', N'j', 9, 68)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('5ebb6116-1627-3f70-0602-eefebbd653b8', 3457, N'AKHTL2179M', 1, NULL, 2, '1998-02-05 21:09:53.780', '1998-05-05 15:54:34.479', N'bixeugelsirdtd', 47, 50)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('3a6dba26-6960-6953-d74b-16e575b61049', 8002, N'LRCPD1125U', 2, NULL, 4, '1970-06-17 11:48:04.280', '1970-10-15 13:28:30.420', N'jcmgznemeyaxfenjmffvbdrqatcwljzjlgxflktniqkxygovsqknoaryfvfj', 7, 38)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('751604f5-1e51-6d47-3f2b-e89ea5388e0b', 8890, N'ABYLL1214R', 1, NULL, 3, '2011-08-13 09:47:33.400', '2011-09-22 11:27:12.639', N'wrilnkilcpijxkitfgrzmyuhhncgcadqbpkgiedzxjukjvrrifevkki', 8, 3)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('5f0a8444-3de1-3f02-eeb6-6f4dd73eba9e', 3985, N'BAJTD1582L', 1, 2, 2, '2016-06-27 14:40:58.780', '2016-07-08 16:18:52.707', N'mibtrodolfscxykmg', 87, 63)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('4abdf3c0-7507-7423-304d-4c0f86f26090', 2469, N'FFFLN7464X', 2, NULL, 3, '1996-02-18 12:06:36.090', '1996-05-26 00:45:42.740', N'uzolmjzfusmqasemarahacwnmzwavktiiarwradelutwywuwmhmzcbbtuzn', 39, 21)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('228bfc03-38db-4741-f096-94965a4eaa62', 8361, N'GZZPK5323C', 2, NULL, 2, '2001-08-26 05:22:02.540', '2001-11-10 12:31:50.359', N'cijgxbfecqeeakqxabxlrmvorlbcvvxcacxzesbwzsgerujrmzkqzaxhomrfougwjtnwqnthamxxjlghxuflrwz', 24, 57)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('26c1e1f8-3a26-53fe-5876-66508ad02725', 7386, N'PBTGK5391F', 2, NULL, 1, '2007-01-01 18:25:50.110', '2007-01-04 22:45:14.593', N'ijxtpkpczvwiwqakwwpxwumwplrbgczfuhwgfqdbiexrbheaehyplkplbgizbnncxjcdlyj', 25, 16)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('49bdab11-1115-7150-d84b-16e575b61049', 9661, N'UHXGY3651W', 2, NULL, 3, '1974-06-30 23:17:49.010', '1974-10-02 10:33:09.533', N'zjjxkndboxahdgedvldsocndbrhtousdmcuigjvkpfgz', 27, 70)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('397bc919-4888-5ab2-402b-e89ea5388e0b', 7834, N'WQZCT1663Z', 2, NULL, 0, '1980-04-18 19:31:55.160', '1980-08-15 09:07:31.034', N'rfnxdmdejaasodqoypibmzizdlrawdy', 10, 48)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('24fee4c1-709c-79d6-1802-ce5da15ac776', 8767, N'JMFKY1615I', 1, NULL, 4, '1975-09-13 19:38:42.330', '1975-12-05 07:26:37.042', N'geyjjujzemaxhdtwoqgbezgtpmcawhhh', 69, 24)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('244bd1b5-7428-4b87-0702-eefebbd653b8', 5809, N'TDNAV1118M', 1, NULL, 3, '2003-11-28 17:31:04.600', '2004-01-28 23:12:46.610', N'thirexwqbxtefntea', 53, 22)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('6c4c1f9b-1644-2620-5976-66508ad02725', 8409, N'FGYFK7131B', 2, 2, 0, '1980-06-17 16:19:00.480', '1980-07-29 08:11:31.289', N'bvszimsmfykkhgigmllwjydldkgnrrnobhdeqcgmggo', 21, 6)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('481c748b-2a85-2a28-efb6-6f4dd73eba9e', 4126, N'CPOGW8574Z', 1, NULL, 2, '1999-08-28 16:21:23.710', '1999-10-27 16:29:01.180', N'pvylxyvwwtdlhofpqeghhlnblufppxxksyahjperhozljbsvqgsgshpuzipvhdsbiojmfbzxowcilxikfmkzmmxrsxenekxaumix', 17, 67)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', 9928, N'BRFJC4523Z', 2, NULL, 0, '2013-01-26 03:51:46.020', '2013-04-10 21:45:06.512', N'xvxwgtachdqctdfildrbbzruojqhheqhrzzueypacgcjqfhjahnzy', 26, 26)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('499200b3-46a5-60a7-f196-94965a4eaa62', 3421, N'TBEKY5243Z', 2, NULL, 2, '1985-07-04 17:09:58.730', '1985-11-03 04:37:22.809', N'wiqjbfuylkfqauvojheiimptatee', 9, 76)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('14735d5d-67ff-5dad-412b-e89ea5388e0b', 3418, N'PSYLZ5529F', 2, NULL, 0, '1979-08-12 17:06:11.730', '1979-09-06 07:00:42.107', N'muvtsychfceiuhbcctqmpksxwgrgeotptsjdpvrrsabnxbwjrepseplnoklwadavwqfa', 72, 24)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('1b3166b4-1301-5956-5a76-66508ad02725', 5957, N'LGVJH8593Y', 2, NULL, 4, '1974-03-30 00:38:28.060', '1974-05-25 22:33:30.388', N'iolusxfgracta', 10, 52)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('5aa02579-73ed-23cd-314d-4c0f86f26090', 5258, N'QYUFG4318K', 1, NULL, 2, '2015-07-23 02:19:33.450', '2015-11-13 19:58:54.081', N'hfnaubuwwwdihubfomsejsgfqjhrlgxbpgpqwnuhwjnvhjlyahousmashmskegfujbkaaxsjhw', 48, 24)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('3f22df3a-3b15-3b5a-787e-3e3b283cabde', 4410, N'DUKKQ8752Z', 2, NULL, 3, '1979-06-09 22:18:30.110', '1979-09-10 17:50:46.438', N'dgxauuvptvwetmwsaheozbndadkcwfcidihtuhvvyubcwisywdkpyztlotxiukiedagsm', 88, 4)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('669afd3f-720a-6e34-1902-ce5da15ac776', 9196, NULL, NULL, 2, 0, '2001-10-30 20:12:41.020', '2002-02-06 15:52:01.558', N'ledoetuyyveexikadksghcnnvgddcgarxeqsdymibveijnnnzkauvmjwtcfe', 8, 98)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('5f00c41b-39dc-51ee-0802-eefebbd653b8', 3198, N'UULCJ7636Y', 2, NULL, 2, '2014-06-30 09:04:59.920', '2014-07-18 18:14:03.680', N'pqrifbaweicgauutkmltexnvqqcsukcvjtyjtqncbpdepswfmicqpndmauwuahupkejkjpbjhkhhybytfwhwxdjzfyfleade', 9, 70)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('336d8f99-255d-646e-f0b6-6f4dd73eba9e', 6765, NULL, NULL, 1, 0, '1981-05-17 13:06:47.520', '1981-09-09 10:59:49.948', N'ytm', 48, 8)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('66a18612-296a-25b0-d94b-16e575b61049', 8514, N'MMWGN7162C', 1, NULL, 3, '1977-05-05 16:32:57.030', '1977-08-22 08:13:36.859', N'orpeqaipvnahtdrxbeitbtfbcqoovfyljaibszxhnrzkpsvkelefb', 75, 83)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('7a311573-456f-56e3-0902-eefebbd653b8', 4545, N'RORCI3739E', 1, NULL, 0, '1995-08-20 22:00:43.210', '1995-12-27 07:20:14.962', N'hrvseuvibuoyjnlgntgdydkgeljsuvh', 1, 24)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('1a361dba-2edd-6ebd-324d-4c0f86f26090', 5701, N'WODGO3283T', 1, NULL, 4, '2000-03-05 13:24:43.910', '2000-05-27 06:07:10.364', N'ujgrvaobowbhnreghxmgttxzfqxksvpwzgpctnzoxweinhtlihdaejydxofxysetaqlobjligokaxketvhrccwogrwwphkl', 63, 25)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('36ce1756-1d21-7373-f1b6-6f4dd73eba9e', 4302, N'LFUKZ3721C', 2, NULL, 1, '1999-12-09 16:30:42.740', '2000-03-30 15:55:08.273', N'tqzgzfyax', 27, 52)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('284445b2-65be-4f66-422b-e89ea5388e0b', 7165, N'GNXAU6726K', 1, NULL, 4, '1972-01-23 11:42:25.860', '1972-05-20 04:36:36.208', N'pjctvplvhplcyqfnzyoddttgnuidrbydnmagmvsgsbyapiytwngvudshkdwvateyqkfv', 57, 48)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('4f7021f5-7800-11be-0a02-eefebbd653b8', 2799, N'HRLHJ6584N', 1, NULL, 4, '2017-11-08 03:26:35.530', '2017-11-15 13:53:37.858', N'gkfarxxkfueyatqjthpjmtzmrovqzjggiaujfqhrhuhbibjeeswkwhwiixzecaucieefkbsflwlivgxudsghqagasmrqrzsqrgh', 63, 74)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('43624c49-472d-4810-f296-94965a4eaa62', 3078, N'ABETE6349T', 2, NULL, 1, '2009-09-17 17:03:58.270', '2009-09-23 22:49:36.197', N'gbh', 39, 26)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('36460dcf-323b-1391-8ec9-bcec0cd444f8', 7540, N'HNCJT1733T', 2, NULL, 3, '2009-01-11 14:38:45.990', '2009-03-21 10:13:11.113', N'ywmlgbgcgyhdvigenbdphffhbuqadrfvolrwjltgpwuyvmxrqokzdfilsbmdhhvutixovk', 60, 39)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('69619ef2-1249-20fa-797e-3e3b283cabde', 2542, N'UUZPU9959P', 1, 2, 1, '1994-02-15 20:25:13.720', '1994-04-11 06:52:01.534', N'jkylhncefrraddgjxcpkujfscgiwmi', 71, 27)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('61e25755-3de1-1adf-8fc9-bcec0cd444f8', 2729, N'PWETI7579I', 2, NULL, 4, '1986-04-04 12:37:30.770', '1986-04-13 00:28:53.726', N'ubgqpxzsnxbzyhqnqbaghseazxjitjgltaoqdzolcsbdedyzbrdqjcxyairwjgxrkywfxptvkqantpfhumcndjhgszwbch', 18, 39)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('1259a17c-69e8-7a1c-da4b-16e575b61049', 8981, N'CYBGN3568Y', 2, NULL, 4, '2015-05-04 05:18:59.350', '2015-09-01 23:11:13.174', N'mfmygzwrbne', 65, 76)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('7959e1dd-2e0b-4306-7a7e-3e3b283cabde', 5444, N'DUMBN9791Q', 2, NULL, 3, '1985-11-13 12:56:01.040', '1986-02-12 03:45:47.188', N'ltsgdoivnedethmydzy', 23, 97)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', 9380, N'DPQPN5615P', 1, NULL, 2, '2000-09-06 22:18:31.490', '2000-10-02 21:00:45.263', N'ngrqgv', 35, 62)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('5e306560-6b07-2cdf-5b76-66508ad02725', 4198, N'EOVTY6373H', 2, NULL, 3, '1983-11-04 15:05:58.540', '1983-12-12 05:15:59.483', N'usxljkmlrapjxcvdtlddaxbdf', 38, 58)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('1a591774-4565-7236-90c9-bcec0cd444f8', 9851, N'NKNPR8358E', 2, NULL, 3, '1991-10-20 04:48:45.320', '1992-01-19 03:40:14.642', N'mjocqdagltilffcmbyzzefzjogis', 26, 91)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('66b0e9ee-53c2-4a98-432b-e89ea5388e0b', 8335, N'CPUTN6236L', 2, NULL, 4, '1974-10-25 19:08:01.580', '1974-11-21 15:11:25.192', N'jhavkxye', 62, 89)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('51d8cc33-7be1-161f-f396-94965a4eaa62', 3855, N'ZMTTI6653N', 1, NULL, 1, '2003-03-04 22:55:23.910', '2003-05-11 02:12:06.452', N'aglxaesrqtwdcaokok', 87, 59)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('1257615f-5ea8-6cd9-0b02-eefebbd653b8', 2555, NULL, NULL, NULL, 0, '2007-12-06 19:45:31.960', '2008-03-04 05:50:32.268', N'bpvuiziiiusknvviwyqyedfoivwbhphmavvnqdulvhjudfgmcbfsikafm', 68, 21)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('37e456ed-14a3-6717-f3b6-6f4dd73eba9e', 9524, N'DYDPX1799Y', 2, NULL, 3, '2001-10-10 18:19:06.980', '2001-12-25 05:33:36.673', N'mh', 71, 55)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('202cad24-4598-16cf-1a02-ce5da15ac776', 8168, N'BSTLX8919Q', 1, NULL, 2, '2009-12-04 09:43:14.510', '2010-01-30 14:56:32.951', N'fd', 2, 24)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('58fc185f-1925-3117-334d-4c0f86f26090', 8219, NULL, NULL, NULL, 3, '1992-08-11 07:15:59.420', '1992-11-19 01:19:54.585', N'vwdbfkabsbjewjftivxcjwvnuecehmtsolahcngnlafuecsiepdpvwzabagjumiokvkxkwltyehesnlqvxgkpo', 82, 98)
  INSERT dbo.PaymentParticipant(Oid, Balance, Name, OptimisticLockField, GCRecord, ObjectType, ActiveFrom, InactiveFrom, BankDetails, Balance2, Balance3) VALUES ('2dc6dc0b-307b-3bde-5c76-66508ad02725', 5133, NULL, NULL, NULL, 4, '2010-05-26 09:22:52.520', '2010-07-03 02:44:44.623', N'lspfkuaysivpwrsylohrfjebzsfuekmdfxifcrzxzfxycbd', 63, 11)
  GO
  
  --
  -- Inserting data into table dbo.Client
  --
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('2dc6dc0b-307b-3bde-5c76-66508ad02725', N'Elwood', N'Coleman', N'(877) 128-5657')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('66b0e9ee-53c2-4a98-432b-e89ea5388e0b', N'Lindsey', N'Fife', N'(615) 958-2687')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('7e919581-5fd4-1caf-5776-66508ad02725', N'Deedra', N'Severson', N'(904) 187-6158')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('699acaa2-66da-563a-1702-ce5da15ac776', N'Rayford', N'Turney', N'(389) 664-8463')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('1259a17c-69e8-7a1c-da4b-16e575b61049', N'Sonny', N'Mattox', N'(224) 768-0727')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('4f7021f5-7800-11be-0a02-eefebbd653b8', N'Hope', N'Seward', N'(434) 643-2196')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('36ce1756-1d21-7373-f1b6-6f4dd73eba9e', N'Chandra', N'Turpin', N'(339) 239-5458')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('37e456ed-14a3-6717-f3b6-6f4dd73eba9e', N'Charolette', N'Kelsey', N'(402) 533-4967')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('5ebb6116-1627-3f70-0602-eefebbd653b8', N'Kim', N'Mattson', N'(326) 891-3864')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('49bdab11-1115-7150-d84b-16e575b61049', N'Randolph', N'Overby', N'(685) 825-8109')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('51d8cc33-7be1-161f-f396-94965a4eaa62', N'Jonah', N'Rushing', N'(791) 539-4168')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('7959e1dd-2e0b-4306-7a7e-3e3b283cabde', N'Adah', N'Cosgrove', N'(266) 681-8929')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('202cad24-4598-16cf-1a02-ce5da15ac776', N'Bernard', N'Bohn', N'(892) 490-6962')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('5f00c41b-39dc-51ee-0802-eefebbd653b8', N'Antonia', N'Kelso', N'(883) 613-5067')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('1257615f-5ea8-6cd9-0b02-eefebbd653b8', N'Jean', N'Mauldin', N'(284) 669-3516')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('43624c49-472d-4810-f296-94965a4eaa62', N'Vincenzo', N'Overstreet', N'(596) 640-1634')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('2f1172a9-1b5d-6fc4-777e-3e3b283cabde', N'Isaac', N'Russ', N'(229) 509-0022')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', N'Terry', N'Coles', N'(905) 230-0670')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', N'Gerry', N'Sewell', N'(726) 780-7028')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('36460dcf-323b-1391-8ec9-bcec0cd444f8', N'Bernardina', N'Tuttle', N'(323) 129-1050')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('3a6dba26-6960-6953-d74b-16e575b61049', N'Kent', N'Sexton', N'(709) 214-4070')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('284445b2-65be-4f66-422b-e89ea5388e0b', N'Adolph', N'Tyler', N'(906) 068-8306')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('2f8a5a0d-54fa-587b-5676-66508ad02725', N'Leif', N'Boisvert', N'(190) 627-1641')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('751604f5-1e51-6d47-3f2b-e89ea5388e0b', N'Adan', N'Kemp', N'(175) 057-8554')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('6f0fc907-5bf7-6e28-ef96-94965a4eaa62', N'Kathey', N'Maupin', N'(889) 518-4429')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('58fc185f-1925-3117-334d-4c0f86f26090', N'Felisa', N'Coley', N'(173) 393-4530')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('397bc919-4888-5ab2-402b-e89ea5388e0b', N'Rachele', N'Kemper', N'(642) 688-5246')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('5f0a8444-3de1-3f02-eeb6-6f4dd73eba9e', N'Adaline', N'Overton', N'(531) 501-8295')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('336d8f99-255d-646e-f0b6-6f4dd73eba9e', N'Maynard', N'Figueroa', N'(547) 074-8716')
  INSERT dbo.Client(Oid, FirstName, SecondName, Phone) VALUES ('1b3166b4-1301-5956-5a76-66508ad02725', N'Dwain', N'Costa', N'(559) 287-6791')
  GO
  
  --
  -- Inserting data into table dbo.Employee
  --
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('43624c49-472d-4810-f296-94965a4eaa62', '1979-06-06 12:20:30.630', N'Sousa', 6, 1999, N'x', 1, '1257615f-5ea8-6cd9-0b02-eefebbd653b8', N'fakhekdndgtzvdykfeknbajrv')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('2dc6dc0b-307b-3bde-5c76-66508ad02725', '1994-10-25 15:19:59.740', N'Welker', 4, 1903, N'nzk', 2, '5aa02579-73ed-23cd-314d-4c0f86f26090', N'bmccgmnjwwohceefboh')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('1257615f-5ea8-6cd9-0b02-eefebbd653b8', '2013-03-28 12:57:43.010', N'Douglass', 0, 115, N'psilghud', 3, '51d8cc33-7be1-161f-f396-94965a4eaa62', N'dsdkyqqoinivlmiqvsailnwiuuxxcsqdufclxhgcksczfkj')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('14735d5d-67ff-5dad-412b-e89ea5388e0b', '1986-04-20 19:54:21.330', N'Pittman', 0, 756, N'nil', 4, '244bd1b5-7428-4b87-0702-eefebbd653b8', N'lskelridxyoqlctdwofnjmbeyqemvuliowqtszhjwbltiaxzwcqeaqegtjqsviwzffcuqbouijqmvbuicibsidtk')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', '2004-02-04 12:39:13.330', N'Godwin', 2, 1030, N'iuvslfvchm', 5, '58fc185f-1925-3117-334d-4c0f86f26090', N'ppfdtlarybahjenrnfvxglmiyjehhgkilicpeajyvhuoijzdrmxlewnwjrymhabm')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('4abdf3c0-7507-7423-304d-4c0f86f26090', '1986-07-11 21:26:07.010', N'Loveless', 9, 586, N'rnjj', 6, '7e919581-5fd4-1caf-5776-66508ad02725', N'cvazuzgqecbfvgwrpheotkbztvdaztslgfripxcudqrpzkpjkwc')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('5aa02579-73ed-23cd-314d-4c0f86f26090', '1988-03-28 15:33:17.050', N'South', 3, 1642, N'tjsxib', 7, '61e25755-3de1-1adf-8fc9-bcec0cd444f8', N'cnhkbcvbomhxbrvjfcdpsawfovsofhrxqjovqnbixgpljelwqrwsxrhbhivwurty')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('58fc185f-1925-3117-334d-4c0f86f26090', '2001-12-30 03:15:30.960', N'Bobbitt', 0, 1282, N'fjfk', 8, '751604f5-1e51-6d47-3f2b-e89ea5388e0b', N'wojyfqpvldnrfhtosswjmcafzgrxkhhjcdlqlubnxpuxifwjufeypxfcapblqpamn')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('244bd1b5-7428-4b87-0702-eefebbd653b8', '2017-10-08 23:28:59.790', N'Dove', 0, 883, N'ycipxmgefo', 9, '2dc6dc0b-307b-3bde-5c76-66508ad02725', N'qfylkluiu')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('228bfc03-38db-4741-f096-94965a4eaa62', '2001-11-19 22:17:18.910', N'Mena', 9, 1646, N'rwjifojuro', 10, '6c4c1f9b-1644-2620-5976-66508ad02725', N'vzylgkelatjjerhzvdvtrpjomrzvrnyveegjfiifukbpbpvoqbwyrlpfgv')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('6c4c1f9b-1644-2620-5976-66508ad02725', '2008-09-22 10:49:35.570', N'Pitts', 0, 186, N'ag', 11, '6c4c1f9b-1644-2620-5976-66508ad02725', N'wnmmnis')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('7a311573-456f-56e3-0902-eefebbd653b8', '2000-12-23 22:58:09.130', N'Cohn', 10, 601, N'y', 12, '1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', N'wmcdybgeopxbxjtjzhbnefdoooawpmzqlqjocxxyemvcnbggjdmgfzadaafymhaxfkgfxnvc')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('7e919581-5fd4-1caf-5776-66508ad02725', '1992-11-29 05:19:44.610', N'Weller', 10, 435, N'hvoqolujrz', 13, '37e456ed-14a3-6717-f3b6-6f4dd73eba9e', N'lrieefdkqvbheowacagcgdxtytbpitadzgvjlulqccuzffxmwfsktdjbzvdkydnnvchzrcbqkzmwomphzasehd')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '1995-06-04 21:45:15.440', N'Bobo', 5, 1872, N'bosextx', 14, '284445b2-65be-4f66-422b-e89ea5388e0b', N'uskuejysbpnzgnufenzknwqn')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('699acaa2-66da-563a-1702-ce5da15ac776', '2010-04-12 18:35:13.980', N'Southard', 2, 821, N'b', 15, '7a311573-456f-56e3-0902-eefebbd653b8', N'lpzeyekhbjqgnvbfqyhpdhhauhozlilrzpalbqsgltzcifgsgwyticblkowovari')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('37e456ed-14a3-6717-f3b6-6f4dd73eba9e', '1971-05-06 12:48:56.380', N'Wellman', 6, 830, N'jdhefn', 16, '3f22df3a-3b15-3b5a-787e-3e3b283cabde', N'oqplidfvrcmvittazvmomemnndtqhhvunawobfhcilscchtiiqdpgiatnczuscdtmgdbthdkdohxsdcqsfhw')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('3f22df3a-3b15-3b5a-787e-3e3b283cabde', '2008-10-20 18:50:06.280', N'Coker', 7, 555, N'crqmnpmm', 17, '669afd3f-720a-6e34-1902-ce5da15ac776', N'puixlahalilfabhpbugoghrgmbbgknwaqzfqexxmabxpzzrpnrdtj')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('36460dcf-323b-1391-8ec9-bcec0cd444f8', '2012-05-12 22:31:34.060', N'Southerland', 2, 445, N'asv', 18, '37e456ed-14a3-6717-f3b6-6f4dd73eba9e', N'mgvaeyazaexqnnzivnranosjmyhafdghfwchmdpeflwikojakmchoyzqzvtozdhgpbxybjsleihkgsyqhvzpbnjffx')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('5ebb6116-1627-3f70-0602-eefebbd653b8', '1989-01-10 19:28:15.840', N'Wells', 6, 947, N'od', 19, '1a591774-4565-7236-90c9-bcec0cd444f8', N'vukzehvbfzjhewzrpamiklwgbbaygcgavyuzgpxqmhckodijbgaloxjaufkbpdxkgmxadmevbshwsewllmpoxuehsbvico')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('5e306560-6b07-2cdf-5b76-66508ad02725', '1992-12-13 23:05:38.770', N'Southern', 5, 693, N'oh', 20, '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', N'clgvfg')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('51d8cc33-7be1-161f-f396-94965a4eaa62', '1994-04-21 08:02:23.610', N'Menard', 8, 214, N'tfbbgbnfm', 21, '43624c49-472d-4810-f296-94965a4eaa62', N'mxsajaaeajlzpvcnheipmaobgqircgkjfadqhvaaackpfazbaswjjthqtcyjcztpehlvhyxkigidflhgrxsmgarsjvbgejm')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('69619ef2-1249-20fa-797e-3e3b283cabde', '1998-01-12 15:29:03.140', N'Bock', 2, 1316, N'vmlhfixzqn', 22, '5aa02579-73ed-23cd-314d-4c0f86f26090', N'htpssojtruavbamncadmypklnkalcqcihcxnbinksscqpzdpcy')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('1a361dba-2edd-6ebd-324d-4c0f86f26090', '2009-05-16 12:30:38.850', N'Colbert', 9, 1637, N'f', 23, '7a311573-456f-56e3-0902-eefebbd653b8', N'jfiulbjstbyjzlixrvobfptgtytjlqegnrmsniufahljrahsuwhsejikeuppbxsunft')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('2f1172a9-1b5d-6fc4-777e-3e3b283cabde', '2005-10-17 08:23:19.990', N'Hurst', 1, 725, N'nasyaqubl', 24, '481c748b-2a85-2a28-efb6-6f4dd73eba9e', N'rqduihtevmsoozbshhzbgj')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('1a591774-4565-7236-90c9-bcec0cd444f8', '2014-02-20 07:47:36.800', N'Place', 0, 1603, N'qlzfgcfe', 25, '751604f5-1e51-6d47-3f2b-e89ea5388e0b', N'whcswehghalcefmpapkwafaxvhzdugnfxbdjglbcgfxrgtqbceagvhtknvbgtg')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('3a6dba26-6960-6953-d74b-16e575b61049', '1994-04-10 15:30:17.510', N'Lovell', 1, 1528, N'xpvwxzs', 26, '228bfc03-38db-4741-f096-94965a4eaa62', N'xfifqwbxwdhaajhebenhogeimibhavbgfsi')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('202cad24-4598-16cf-1a02-ce5da15ac776', '1981-02-12 22:26:38.520', N'Goebel', 4, 334, N'sg', 27, '669afd3f-720a-6e34-1902-ce5da15ac776', N'phiy')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('2f8a5a0d-54fa-587b-5676-66508ad02725', '1980-11-18 00:54:08.820', N'Boehm', 1, 862, N'mgtoefq', 28, '6c4c1f9b-1644-2620-5976-66508ad02725', N'djtapwwfsfecaelpzinijwvcaoqdhhqyhbatlptaqemqcytamvfpdhihxqxryqokejvwchvmjitdtgeptbjo')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('669afd3f-720a-6e34-1902-ce5da15ac776', '1972-09-18 03:37:54.590', N'Welsh', 7, 630, N'o', 29, '49bdab11-1115-7150-d84b-16e575b61049', N'yenhifgfxqmfzdaxlmmjcjgvrjdfixvraiqxihecithomlrzywdugpblbfefsarybsjdhddqvmvjgwbzpcvkewvifgrv')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('26c1e1f8-3a26-53fe-5876-66508ad02725', '1970-03-22 11:53:46.570', N'Hurt', 6, 741, N'pgeao', 30, '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', N'tqxjwoerfxgiiioffptkbf')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('481c748b-2a85-2a28-efb6-6f4dd73eba9e', '1996-05-08 10:57:36.950', N'Mendenhall', 7, 704, N'pgat', 31, '7a311573-456f-56e3-0902-eefebbd653b8', N'fggdcaphxgqzvrsazqhioyvkrkofibxglyjrjxrhsgcdfqjdnyepafuwelpneeqnjmzxdrbyzksttksqanyoajgyiussyd')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('49bdab11-1115-7150-d84b-16e575b61049', '1974-12-16 08:15:27.700', N'Souza', 8, 1199, N'pmfdiy', 32, '5ebb6116-1627-3f70-0602-eefebbd653b8', N'encxxymvozrjnzdpkyvdbnxpvnfglyaeplxsyzzaxbhikzncnjoeekucixyqfrwtyqyfddrmhnxaitoglntfjxmzea')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', '2011-08-30 10:45:35.620', N'Wendt', 0, 311, N'kcmrq', 33, '5f00c41b-39dc-51ee-0802-eefebbd653b8', N'rnznhigbmqdvnkingngqtgvnibfskhbevusxpalchjbqopkqcqvjsckrimp')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('61e25755-3de1-1adf-8fc9-bcec0cd444f8', '1988-12-12 02:45:23.030', N'Colburn', 8, 468, N'bejglcgrc', 34, '51d8cc33-7be1-161f-f396-94965a4eaa62', N'yljzgdkumujvbduvimcggxagdyfgcmnyxufdphuebuag')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('751604f5-1e51-6d47-3f2b-e89ea5388e0b', '2001-10-02 16:45:23.090', N'Bogan', 9, 1378, N'jau', 35, '751604f5-1e51-6d47-3f2b-e89ea5388e0b', N'doqhkgwohuvpwxdcidkzcyvgwavgehcsafpaupznofadgabsktgrfwgbecwzrbjond')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('6f0fc907-5bf7-6e28-ef96-94965a4eaa62', '1980-09-28 02:12:24.730', N'Dover', 2, 763, N'kc', 36, '49bdab11-1115-7150-d84b-16e575b61049', N'yyjpakiueddzeqcgbizkqtdjntesxmhiowiuyvgzwqridmkqmejcrmblrfdqmpekbcvnqcwrnrzayzyilrcrjvf')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('36ce1756-1d21-7373-f1b6-6f4dd73eba9e', '2017-12-17 13:49:47.520', N'Colby', 1, 579, N'xbnwaep', 37, '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', N'lddmbqfkkesngwodssfoplxsnjupzfpl')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('5f00c41b-39dc-51ee-0802-eefebbd653b8', '1997-06-16 23:48:52.350', N'Plante', 7, 1904, N'd', 38, '3f22df3a-3b15-3b5a-787e-3e3b283cabde', N'vzwprmaetgizntiwleajnynlhpsrftbdsbxuuilpvaooruqwpnpyqfwrrzyrpdnnypisfiphawdembptonieqxupyva')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('284445b2-65be-4f66-422b-e89ea5388e0b', '1986-03-06 00:51:59.440', N'Goetz', 1, 1290, N'cjrlp', 39, '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', N'qqzxcivp')
  INSERT dbo.Employee(Oid, BusyUntil, SecondName, Stuff, HourPrice, Patronymic, PlanfixId, Head, PlanfixMoneyRequestTask) VALUES ('5f0a8444-3de1-3f02-eeb6-6f4dd73eba9e', '1996-05-22 03:18:27.920', N'Boggs', 8, 728, N'ckleo', 40, '1a361dba-2edd-6ebd-324d-4c0f86f26090', N'evqwvaivkcxnjik')
  GO
  
  --
  -- Inserting data into table dbo.Project
  --
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('7f9589fa-2b58-5866-1c93-373516031d8e', N'American Space Explore Group', N'3168 Riddle Hill Lane, Denver, Colorado, 89834', '699acaa2-66da-563a-1702-ce5da15ac776', '5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', '3f22df3a-3b15-3b5a-787e-3e3b283cabde', 2, NULL, 56275, 4791, 16625, '1998-11-26 14:19:52.880', 2, '1999-08-20 23:58:23.538', 7, 0.92, 82.82, 3, N'twpilh', N'jqwhktofdggpskbdtxqagvduwcczxdkcthksmagwuzauitnlxviympkohvqouidjbjcatseoyw', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('28186996-5b5b-7729-455f-1885b89fc8fc', N'East Security Corporation', N'1252 Monument Ave, Indianapolis, Indiana, 59078', '7e919581-5fd4-1caf-5776-66508ad02725', '6f0fc907-5bf7-6e28-ef96-94965a4eaa62', '5ebb6116-1627-3f70-0602-eefebbd653b8', 2, NULL, 12987, 691, 11627, '1971-08-24 00:09:36.750', 1, '1972-02-10 18:27:02.969', 2, 139.5, 10.54, 1, N'ghluhzbkqzcpxpaxdfsfwiipgipehqkhjwtsahmuasbsvtxcbkgeuptuonpkfqafjxhjmdokqwryaagavkazspr', N'kbfkjnlqbcuezdsv', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('5b6e9fc7-1e70-4fd4-0448-b983316b8374', N'East K-Mobile Corporation', N'2503 Highland Ct, Austin, TX, 35237', '2dc6dc0b-307b-3bde-5c76-66508ad02725', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '6f0fc907-5bf7-6e28-ef96-94965a4eaa62', 1, NULL, 76059, 4973, 24030, '1999-08-05 23:23:34.790', 2, '2000-09-10 11:18:17.545', 4, 410.55, 57.14, 3, N'evnxjsbex', N'elud', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('1ba4c500-5a33-4cef-3709-69a9b1bfbc32', N'Canadian 2G Wireless Inc.', N'2602 Rushwood Lane, Calyon Bldg, Boise, ID, 73865', '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', '5f00c41b-39dc-51ee-0802-eefebbd653b8', '244bd1b5-7428-4b87-0702-eefebbd653b8', 2, NULL, 84669, 4310, 30871, '1984-08-26 22:06:43.300', 1, '1984-08-30 23:10:37.165', 8, 470.83, 37.07, 10, N'yqgwxtbejcduakydheepnyqxlxkudsshdzyjlizxeylek', N'lgvzgfmturdjyiaiwngzlzleqzlv', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('2643c0f2-5381-7a86-1d93-373516031d8e', N'City Petroleum Corporation', N'2654 Burwood Hwy, Baton Rouge, LA, 32867', '7e919581-5fd4-1caf-5776-66508ad02725', '51d8cc33-7be1-161f-f396-94965a4eaa62', '37e456ed-14a3-6717-f3b6-6f4dd73eba9e', 1, 2, 25518, 7417, 83796, '1989-08-31 15:49:39.260', 0, '1991-01-27 09:11:57.119', 4, 90.12, 56.84, 7, N'rvbgjaxykmgrbmglragkrrmngemamgnunhcrwvocztshq', N'icslrbttshlcaeqqjdzqltvdfoteimxanpkczxjghoiwweostyopfuyfhvxqqsjnbgsutbofeccshazr', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('5c549d77-1e58-4d4e-1fbe-eaf7cc272319', N'Smart High-Technologies Corporation', N'321 East Rock Hill Pkwy, Harrisburg, PA, 69670', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '228bfc03-38db-4741-f096-94965a4eaa62', '7a311573-456f-56e3-0902-eefebbd653b8', 2, NULL, 74544, 3654, 36302, '1979-12-06 05:11:39.020', 1, '1980-01-23 09:13:01.778', 10, 506.67, 20.73, 3, N'sbadagpastjtoilzuvwkpkcxvnkaksxfsrenlcppchvoqfujjsudhaaftbppqgjryqnyuauodvgprrc', N'zcf', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('31a38fa9-4c3b-4cf0-0548-b983316b8374', N'American A-Mobile Co.', N'748 Riverview Avenue, Jackson, Mississippi, 77400', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', '1a361dba-2edd-6ebd-324d-4c0f86f26090', '3a6dba26-6960-6953-d74b-16e575b61049', 2, NULL, 85424, 7070, 79944, '2014-11-18 05:12:24.750', 1, '2017-06-30 06:42:09.163', 8, 815.61, 67.85, 4, N'dcnwcwkhikvfloxn', N'hlqcerdeemdgkupinuzgqjsmgatdkqdamealeidnoszfpgiudoshyradtdwuzbatwljxrwtcditgv', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('4a084a3f-5d99-1372-b433-62dd4e858bad', N'South Development Corp.', N'1948 Fox Hill Lane, Boise, ID, 26196', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '244bd1b5-7428-4b87-0702-eefebbd653b8', '5e306560-6b07-2cdf-5b76-66508ad02725', 1, NULL, 87386, 5109, 10423, '1976-01-05 23:48:28.480', 0, '1977-04-26 12:55:04.542', 7, 5.72, 16.04, 6, N'suoyymhlnnrrmigowztgxgknqipwjpzkvc', N'rnwpaeexqdueeefyieqhkvvlojeqvjyofiyhrljqjeuoiucihdvzu', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('6d825400-4c66-515a-1e93-373516031d8e', N'South High-Technologies Group', N'262 Waterview Ave, Kearns Building, Bismarck, North Dakota, 54712', '1259a17c-69e8-7a1c-da4b-16e575b61049', '5f00c41b-39dc-51ee-0802-eefebbd653b8', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', 1, NULL, 79840, 6506, 48135, '1972-12-30 03:21:57.780', NULL, '1973-02-23 13:27:51.347', 2, 8.45, 5.48, 1, N'xrvaqhxj', N't', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('5a851e09-4a52-7284-0648-b983316b8374', N'Creative Space Explore Inc.', N'407 Woodside Lane, Macy''s Bldg, Saint Paul, MN, 36648', '284445b2-65be-4f66-422b-e89ea5388e0b', '3f22df3a-3b15-3b5a-787e-3e3b283cabde', '699acaa2-66da-563a-1702-ce5da15ac776', 2, NULL, 74221, 5639, 10729, '2007-03-07 14:22:52.680', 2, '2008-10-10 23:31:19.268', 2, 463.8, 3.47, 2, N'oojoxznngphwksrcdpfcjohxtoivrfwetflse', N'gspuoqarvrdifhxzrbirupcppowhqqyrwabalhjjxsyugqvzyxnchawtsxfikcdaqodprythpkvgf', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('1897a8f1-37fc-5c9c-3809-69a9b1bfbc32', N'Flexible T-Mobile Corporation', N'2478 NW Rose Hill Ct, Frankfort, Kentucky, 40649', '699acaa2-66da-563a-1702-ce5da15ac776', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', '58fc185f-1925-3117-334d-4c0f86f26090', NULL, NULL, 96851, 1389, 70901, '1984-06-20 02:16:56.140', 0, NULL, 3, NULL, 46.22, 7, N'am', N'djxnrxrzohldvgpdcgjvxqsxaxihmcfzpogoswffguihijiahmdwjpggphpeaamncictuoiriqvyhss', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('373511c0-68e6-4a3f-20be-eaf7cc272319', N'WorldWide Fossil Fuel Power Corporation', N'766 New Woodhurst St, Kearns Building, Trenton, New Jersey, 51607', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '202cad24-4598-16cf-1a02-ce5da15ac776', '5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', 2, NULL, 94646, 5962, 39793, '1988-09-10 00:06:09.530', 2, '1990-04-17 00:38:53.468', 1, 62.18, 3.07, 1, N'dmsavsa', N'zlroyqxawbqqnogpcjeddfpeykvyytblemhtlgqyytwezbanntjnetfzppznnppfzfodldiixfeknaziqkmx', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('66af213e-6ed1-770c-5c32-9a0257d67b47', N'Pacific Space Explore Co.', N'763 Market Pkwy, Phoenix, AZ, 22164', '5ebb6116-1627-3f70-0602-eefebbd653b8', '6f0fc907-5bf7-6e28-ef96-94965a4eaa62', '43624c49-472d-4810-f296-94965a4eaa62', 1, NULL, 3876, 3707, 94232, '2016-03-28 13:15:31.590', 2, '2018-03-30 10:55:09.237', 4, 422.92, 72.87, 2, N'yhedeybimuddzfbxhdgrvepitixkcpwonkooimkiu', N'ltvwfgaquutfypgtndlcdyarwuppoigzoyjgbgmcfvzklnvdgcgbeblbyowqzpnebsuttnbfofhlfpfacx', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('488ffd9a-7ad8-5a04-cd7e-e08e331d25c7', N'General Management Inc.', N'3776 East Flintwood Avenue, Madison, Wisconsin, 58797', '5f0a8444-3de1-3f02-eeb6-6f4dd73eba9e', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', '1a361dba-2edd-6ebd-324d-4c0f86f26090', NULL, NULL, 69411, 572, 84938, '1971-05-28 19:47:31.170', 0, NULL, 7, NULL, 75.51, 2, N'dhfv', N'eebkuodocnjcqpqufuqfmazghdlxflanresrsinjlemzfiwdoievdqgcvgotgbqebyypoogghvdjxuqeep', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('495ff429-25fd-4337-1f93-373516031d8e', N'Special High-Technologies Inc.', N'1236 W Pine Tree Loop, Guardian Bldg, Nashville, Tennessee, 34228', '1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', '4abdf3c0-7507-7423-304d-4c0f86f26090', '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', 1, NULL, 4805, 1644, 25528, '1987-02-03 04:57:50.810', 0, '1987-02-05 11:14:51.111', 7, 620.98, 63.81, 9, N'hlyherochhqvpnezfytsdpidzijaflgesnxtpnfgsmaqecdknnhrcavzcjwjsfkxgwkvqhdfntcxpqdcygwwhjhkjipch', N'hepzwebx', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('24c4b5df-5d2a-53c2-b533-62dd4e858bad', N'Global Technologies Corporation', N'67 East Rushwood Ln, Superior Building, Olympia, WA, 97251', '284445b2-65be-4f66-422b-e89ea5388e0b', '37e456ed-14a3-6717-f3b6-6f4dd73eba9e', '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', 2, NULL, 10142, 4145, 67495, '1999-10-07 10:38:11.080', 2, '2002-06-27 02:02:34.288', 7, 983.08, NULL, 6, N'gszdsnzzdgvnkzygmrzhtruocduwc', N'nvaqaoinicnvsndfo', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('12e83c52-5faa-79c9-ce7e-e08e331d25c7', N'West Products Inc.', N'3726 Red Deepwood Highway, Equitable Bldg, Tallahassee, FL, 89597', '37e456ed-14a3-6717-f3b6-6f4dd73eba9e', '6f0fc907-5bf7-6e28-ef96-94965a4eaa62', '6f0fc907-5bf7-6e28-ef96-94965a4eaa62', 1, 2, 93224, 7732, 83717, '1982-04-26 02:39:12.400', 1, '1983-10-14 21:30:58.257', 8, 943.2, 11.49, 3, N'phnpzyheysddjrsybgpzrhhlcmwgnc', N'coiaexudnsanefx', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('5126a884-72e7-76eb-3909-69a9b1bfbc32', N'General Space Explore Corp.', N'3084 SE Fox Hill Ct, Carson City, Nevada, 88147', '49bdab11-1115-7150-d84b-16e575b61049', '49bdab11-1115-7150-d84b-16e575b61049', '2dc6dc0b-307b-3bde-5c76-66508ad02725', NULL, NULL, 435, 9736, 69392, '1994-11-07 08:27:06.920', 1, NULL, 4, NULL, 33.78, 10, N'cofdusguzahdvizkhwcojaemybkfjlrxjbliplaiypnlfrvazzveavwvbwaolmnyalzxpynctucoaoqdvvudsckkfporxhsa', N'rzmruemfyxgrzazjiuygjmshupypuvvbikrbpmjgtjofsjixhhdipovhzaftlahsvmyjv', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('436978f8-4c20-1760-21be-eaf7cc272319', N'Advanced D-Mobile Co.', N'1866 Ironwood Way, Enquirer Bldg, Trenton, New Jersey, 28047', '5f00c41b-39dc-51ee-0802-eefebbd653b8', '1a361dba-2edd-6ebd-324d-4c0f86f26090', '284445b2-65be-4f66-422b-e89ea5388e0b', 2, NULL, 94771, 553, 1769, '1996-04-30 08:36:55.090', 1, '1996-05-06 16:21:15.487', 5, 10.84, 83.16, 9, N'aoaaacocmcbbksghlgdacxgvqvj', N'kolauumlhyvbsgpojmthcmjnvrfqaagvxcgpuhitfuvukcaghuxkbwzcoumgbkyhcjdfojcsuknxpomadkeqaya', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('1752b8ca-19e4-4cd1-757d-18b43b6e1561', N'American Computers Corp.', N'260 Riverside Drive, Providence, RI, 26254', '5f00c41b-39dc-51ee-0802-eefebbd653b8', '51d8cc33-7be1-161f-f396-94965a4eaa62', '5ebb6116-1627-3f70-0602-eefebbd653b8', 2, NULL, 91830, 4342, 10314, '1978-12-04 08:09:47.220', 0, '1980-01-11 08:59:25.606', 1, 223.38, 25.32, 7, N'himzcxmsiifhjgeihhrpdhddircdtuixtdgiisctoidqcqausuxeaksgsnvyaoglinzorinmsqduabagyepkva', N'gopx', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('47cb37df-759e-6071-3a09-69a9b1bfbc32', N'Global Transportation Group', N'42 Social Rd, Standard Building, Albany, New York, 54385', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '5e306560-6b07-2cdf-5b76-66508ad02725', '61e25755-3de1-1adf-8fc9-bcec0cd444f8', 2, NULL, 54913, 2971, 50594, '2016-01-04 20:44:26.690', 0, '2018-08-22 08:48:01.338', 6, 784.94, 50.76, 5, N'edtldogutjnchkvfodwwsoxmcwpeggadxufdjgxdwjamfozacazkqfbfuwocwqaoakvsonowjagbrcgvywfbtsdbyhnyzbbmkzed', N'qxwpaeocfnbqrlxgoezfdxgalibsaaozxrbkvrgzytwhopdxxkaijegi', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('1ee39b95-6a6d-4cdf-5d32-9a0257d67b47', N'Western Cars Battery Co.', N'3262 Edgewood Lane, Montgomery, AL, 36482', '5ebb6116-1627-3f70-0602-eefebbd653b8', '1a591774-4565-7236-90c9-bcec0cd444f8', '1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', 2, NULL, 62122, 4701, 25691, '1980-12-04 01:53:54.960', NULL, '1983-03-22 08:07:24.660', 5, 844.9, 69.2, 4, N'mrkpioaabfqsctxxxvxpbnycomxxmdljzfirzxainzwdcdnweaueklop', N'wauzcqhphctyzdhpvjtgpgpyvgzqhnwzattkwznsedjrpihqjiddpezdfvjpqpkzlmlc', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('3f74a4eb-2217-1549-0748-b983316b8374', N'Canadian Telecom Corporation', N'1049 NE Chapel Hill Road, Olympia, Washington, 36243', '49bdab11-1115-7150-d84b-16e575b61049', '6c4c1f9b-1644-2620-5976-66508ad02725', '43624c49-472d-4810-f296-94965a4eaa62', 2, NULL, 61482, 3739, 73493, '2012-02-16 02:11:33.670', 2, '2014-02-03 12:10:47.163', 3, 42.97, 23.23, 3, N'wbwoofjjueojjyjliqwxivtkmiulpjevixrrkkveokyhxawkjbqkugzpzsrivwlbksqh', N'rxshuiazxnwocvthspfnnyckflnyjvyqhjeqtkbmhmxvqjoybwybifubipnswishgjikwmrnhaueio', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('27d08697-48a5-60ae-3014-9ad3d3072fe3', N'Beyond Industry Inc.', N'2285 SW Meadowview Ln, Macy''s Building, Salt Lake City, Utah, 38926', '58fc185f-1925-3117-334d-4c0f86f26090', '202cad24-4598-16cf-1a02-ce5da15ac776', '2dc6dc0b-307b-3bde-5c76-66508ad02725', NULL, NULL, 17510, 248, 74032, '1981-07-24 14:44:57.930', 1, NULL, 4, NULL, NULL, 8, N'sygcwwvuowyhmlkvfklugbgrukvebhhoxtacyqgazjndhanshswwfsemybqyganeoqagckj', N'lfjvfwwcybjyzjnahekmibubqblgvz', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('1c88c2a4-1aa1-1a3e-465f-1885b89fc8fc', N'General Electricity Inc.', N'323 Mountain Loop, 257 Towers Building, Hartford, CT, 90426', '2f8a5a0d-54fa-587b-5676-66508ad02725', '699acaa2-66da-563a-1702-ce5da15ac776', '2dc6dc0b-307b-3bde-5c76-66508ad02725', 2, 1, 53801, 773, 67032, '1970-01-02 08:22:55.090', 0, '1970-07-03 20:30:48.671', 2, 898.8, 25.65, 3, N'lifwnvsbcrbvbdlyypjaubkhkryueqmitxgxvbotmnxgcvegvbjbeuhzsxxvhykofcgazvwrnucmblagvvtqdqqwvqlyzhc', N'pyxvglsnbjwpaufwcdhgtbwbjvcygkkaxisnmcqkayowhbhayaqqtdueiwcwrjvko', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('42b2fa47-5255-25d8-767d-18b43b6e1561', N'Flexible Consulting Corporation', N'2417 W Riverview Lane, Columbia, SC, 47432', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', '1a361dba-2edd-6ebd-324d-4c0f86f26090', '1a591774-4565-7236-90c9-bcec0cd444f8', 1, 1, 66714, 2362, 81424, '1986-01-05 16:38:59.780', 0, '1988-02-10 19:45:23.524', 10, 816.49, 34.94, 3, N'mvqvqzktmhxhntxycnttclulxgwsrdfb', N'leyakgigoyfprwaheokmhdzbnwixtuhxlda', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('202ae9eb-75ea-4f00-3114-9ad3d3072fe3', N'North Thermal Energy Corp.', N'3325 Red Flintwood Ct, Jefferson City, MO, 93893', '699acaa2-66da-563a-1702-ce5da15ac776', '284445b2-65be-4f66-422b-e89ea5388e0b', '7a311573-456f-56e3-0902-eefebbd653b8', NULL, NULL, 82886, 6248, 95309, '2006-02-18 05:25:14.740', 2, NULL, 9, NULL, 57.09, 5, N'tej', N'didblbhhllysqafceewdsenzadndolggxyeadbkhcllhvsbfhqgdxrbnbuujepofcgodxyti', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('39e40431-57bb-7682-b633-62dd4e858bad', N'Home Space Explore Inc.', N'780 SW Rock Hill Blvd, MidAmerican Building, Jefferson City, MO, 78278', '6f0fc907-5bf7-6e28-ef96-94965a4eaa62', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', '5e306560-6b07-2cdf-5b76-66508ad02725', 2, NULL, 70958, 5659, 49203, '1978-05-09 00:03:17.560', 1, '1979-04-30 03:31:36.942', 1, 547.44, 54.93, 10, N'bjucrmevzgtdnvvdajtmdyc', N'wnkrdgxjsf', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('7dbc0370-219d-568a-cf7e-e08e331d25c7', N'Pacific Partners Co.', N'3705 Old Fox Hill Court, Olympia, WA, 93459', '43624c49-472d-4810-f296-94965a4eaa62', '669afd3f-720a-6e34-1902-ce5da15ac776', '5f0a8444-3de1-3f02-eeb6-6f4dd73eba9e', 2, NULL, 87115, 8826, 80538, '1993-12-24 20:29:49.940', 1, '1994-02-26 01:44:18.699', 4, 639.81, 64.09, 8, N'mlgruciufj', N'xipezjlilquzxhluvwtetbtmfzknsfofboizdiezzfnjfqasoitkpffrcnqx', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('2c192596-1720-528a-22be-eaf7cc272319', N'First K-Mobile Inc.', N'2652 Mountain Street, Honolulu, Hawaii, 22654', '51d8cc33-7be1-161f-f396-94965a4eaa62', '228bfc03-38db-4741-f096-94965a4eaa62', '26c1e1f8-3a26-53fe-5876-66508ad02725', 2, NULL, 19135, 435, 48077, '2002-04-06 14:27:18.890', 2, '2002-11-26 09:16:26.942', 6, 59.27, 25.09, 10, N'ysiowzkazfijgl', N'ybavjgcgwauyuxrqloedkacnouognodrrbinurmiqkmccaswejajhzvdgywufxqnnllsbkiihhnxddmwaai', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('1d11b286-78df-2715-475f-1885b89fc8fc', N'Advanced Telemetrics Inc.', N'975 East Front Ct, Des Moines, IA, 63493', '6f0fc907-5bf7-6e28-ef96-94965a4eaa62', '4abdf3c0-7507-7423-304d-4c0f86f26090', '2f8a5a0d-54fa-587b-5676-66508ad02725', 1, NULL, 24029, 8448, 96508, '1976-11-19 15:02:34.760', 0, '1977-02-03 01:59:20.424', 3, 421.44, 50.29, 9, N'gz', N'aoogdrkan', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('6b9b7137-3dd3-7b12-b733-62dd4e858bad', N'Advanced Space Explore Inc.', N'3928 Front Blvd, Appartment 10, Topeka, Kansas, 59925', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', '5e306560-6b07-2cdf-5b76-66508ad02725', '3f22df3a-3b15-3b5a-787e-3e3b283cabde', 2, NULL, 57678, 3316, 45730, '1993-07-19 08:19:43.980', 2, '1994-02-12 15:04:15.077', 6, 141.74, 92.95, 4, N'dvgnalguadsmeybjlggbezqbycgznfzeesihzonuytajfnzjgqlmcbnfgskcawvtppmeduqazfjdmpuquipmhugcewxbf', N'lcryolis', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('3778fd78-672b-358c-5e32-9a0257d67b47', N'West Q-Mobile Inc.', N'769 NW Brentwood Dr, Albany, NY, 95600', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '202cad24-4598-16cf-1a02-ce5da15ac776', '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', 1, NULL, 36082, 2870, 92557, '1997-05-23 15:48:54.100', NULL, '1999-01-29 10:47:01.461', 3, 326.59, 24.34, 6, N'vm', N'aiqhzcjzqjhcfnzcbbvfyxhdsbupjvscexkdpadadnuvrmnvlpnwrgfbjarsojsqaeggt', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('582165db-7775-1bec-2093-373516031d8e', N'Professional Engineering Inc.', N'2993 NW Woodside Hwy, 257 Towers Bldg, Columbia, SC, 90839', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', '669afd3f-720a-6e34-1902-ce5da15ac776', '5f00c41b-39dc-51ee-0802-eefebbd653b8', 1, NULL, 68199, 1292, 75122, '1986-08-05 05:59:35.220', 0, '1988-10-20 07:29:07.344', 5, 115.36, 36.48, 8, N'jtugvfokpcqszbbdhsbvhdpzmxytcfldrgmdfooknzofrgrhgigfeqwxyljomqgsiyqfptd', N'jjcianmgbnffwgkbvrimrylaoflnvkwiffdjshrigobimrfbhgddcfueanvusijyrtaan', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('438f32b0-4d8e-4d3b-777d-18b43b6e1561', N'Global Insurance Group', N'500 SE Riddle Hill Ave, Bartlett Building, Olympia, WA, 05772', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '202cad24-4598-16cf-1a02-ce5da15ac776', 1, NULL, 17498, 7804, 73847, '1995-09-28 00:45:07.390', NULL, '1996-03-12 11:48:12.737', 4, 951.21, 27.52, 3, N'jqedix', N'cbnemgnopijlhdasdhdmfifcugeaoshknddepvcezeochjpbjkjhzoiihgbmjngnubmnnjwaxghipaefqirfohwcm', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('78a4e9cd-56c6-20b7-3b09-69a9b1bfbc32', N'WorldWide Oil Inc.', N'3838 Flintwood Street, Judge Bldg, Dover, DE, 55829', '5ebb6116-1627-3f70-0602-eefebbd653b8', '2dc6dc0b-307b-3bde-5c76-66508ad02725', '4abdf3c0-7507-7423-304d-4c0f86f26090', 2, NULL, 96505, 6230, 92202, '2002-12-14 21:03:59.350', 1, '2003-05-24 18:52:56.555', 6, 3.8, 31.87, 1, N'cdhxgpoiwjeuvpfkhkxjohbtpkheqnuqczqgjvdtleaqezbvrivxnmuxgqbkqrdanjfeycvvxkchmfxlyzumevygfvuie', N'hbdurqcbbfnloph', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('167940ec-16a3-126a-d07e-e08e331d25c7', N'United A-Mobile Corporation', N'2842 Stonewood Ct, Penobscot Bldg, Bismarck, North Dakota, 65981', '66b0e9ee-53c2-4a98-432b-e89ea5388e0b', '37e456ed-14a3-6717-f3b6-6f4dd73eba9e', '6c4c1f9b-1644-2620-5976-66508ad02725', NULL, NULL, 66422, 6578, 18271, '2014-01-11 18:43:32.690', 2, NULL, 7, NULL, NULL, 8, N'cjblocvj', N'gvtwdgawzoinjawjhsrmhxxldyodxhavwsgvaiixoxuivmgmguvrlxefhefbxmapekfahtxpdetdwlzejhetjdhavraeadj', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('170880fb-26de-46be-23be-eaf7cc272319', N'East 5G Wireless Inc.', N'3527 Beachwood Ct, Keith Building, Raleigh, NC, 46725', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', '4abdf3c0-7507-7423-304d-4c0f86f26090', '228bfc03-38db-4741-f096-94965a4eaa62', 1, NULL, 93474, 4580, 13189, '2008-01-08 06:00:49.030', 2, '2008-06-15 01:24:19.437', 1, 558.24, 10.15, 7, N'ngnuwioryoerxjkxhofwqphg', N'teycurmvojxvytykrqldmbuipzdhdtcjtn', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('68510dbd-7f5a-2514-5f32-9a0257d67b47', N'Australian Software Group', N'3030 White Waterview Parkway, Hartford, CT, 01573', '58fc185f-1925-3117-334d-4c0f86f26090', '43624c49-472d-4810-f296-94965a4eaa62', '7a311573-456f-56e3-0902-eefebbd653b8', 2, NULL, 99177, 372, 31560, '2005-10-03 18:25:48.150', NULL, '2005-10-09 17:49:50.391', 7, 24.04, 8.94, 3, N'ldlohkmiepdfxxrciffozvauppftvqnlhphzfjoxbhonv', N'cpbvhrdetyjsbmbcjxfqndkngwmvdjusoqwbkagzijspbxo', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('1bda45a4-5e6a-27d2-3214-9ad3d3072fe3', N'Federal Services Group', N'2936 Hidden Social Ln, Raleigh, NC, 84461', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '3f22df3a-3b15-3b5a-787e-3e3b283cabde', '7e919581-5fd4-1caf-5776-66508ad02725', 1, NULL, 26772, 7575, 14132, '2016-09-03 02:32:08.360', 2, '2016-09-29 23:39:28.922', 7, 8.77, 87.6, 8, N'gzaxbnoosafxxcgrgszthwbwrlgfheuizabvxsdygtz', N'hilfcpsvoiqpcjedtqrkbzicncedvecptheyqpeegrvrttjdbeuavgbrqdsnatltlrpmkgzdedehuaztwb', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('57670afb-1567-17fd-787d-18b43b6e1561', N'Domestic Business Inc.', N'518 Ashwood Pkwy, Standard Building, Albany, NY, 31781', '58fc185f-1925-3117-334d-4c0f86f26090', '202cad24-4598-16cf-1a02-ce5da15ac776', '58fc185f-1925-3117-334d-4c0f86f26090', 1, NULL, 49402, 5784, 91198, '1977-10-02 01:58:13.550', 0, '1979-11-14 05:45:22.344', 7, 633.99, 11.36, 10, N'curgeipcavabmqejhsypmzipgxfncnjhfvpulfsfxghfoyvtrqpcyefjqiibfhbloddpgmoeltrshrgfmyc', N'ewqxsydhrwysewiexcqdbzxtxgnojvrqmtbqltdjnpagjn', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('31bc6e74-7ec1-593a-6032-9a0257d67b47', N'East Investment Inc.', N'768 Red Lake Ave, Comcast Building, Charleston, West Virginia, 20485', '699acaa2-66da-563a-1702-ce5da15ac776', '244bd1b5-7428-4b87-0702-eefebbd653b8', '5e306560-6b07-2cdf-5b76-66508ad02725', 2, NULL, 44929, 986, 36712, '2007-08-07 11:30:21.360', 0, '2008-01-22 12:57:49.630', 5, 2.23, 2.08, 5, N'ncypncbegqmyhgycgbitlxegpfocpbyteqgkheqyfkkyuoylvxznylczamjemsheiazxuriwfsejwbqbeecccbzod', N'wqtvnxjwctruqzltc', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('17907d4e-7c0c-5df6-b833-62dd4e858bad', N'East Insurance Corporation', N'348 E Ski Hill Road, Buhl Bldg, Madison, Wisconsin, 08659', '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '202cad24-4598-16cf-1a02-ce5da15ac776', 1, NULL, 44413, 9108, 49650, '1988-12-19 11:59:28.240', 0, '1991-05-04 12:04:28.198', 6, 282.84, 5.18, 7, N'im', N'yggwizfcauzxgapqddsd', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('5f4ef1d4-6cef-1cfb-0848-b983316b8374', N'Creative Optics Group', N'501 NE Rock Hill Avenue, Montgomery, Alabama, 42156', '202cad24-4598-16cf-1a02-ce5da15ac776', '5f00c41b-39dc-51ee-0802-eefebbd653b8', '26c1e1f8-3a26-53fe-5876-66508ad02725', 1, NULL, 71661, 3104, 46572, '1979-09-19 03:05:53.000', 0, '1982-03-07 15:06:29.464', 2, 471.68, 45.5, 3, N'ieaaxuegkydenwubpwchnqvxtwsilexacnkqaktwilwoaputsdtmpsov', N'xtgukwzjkdcjkbhqofikpyneivjxaaftxbszgauxidtmcymljhmxdyebjourqllfwchhzkacco', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('169b892d-4fb7-2a17-2193-373516031d8e', N'Advanced Computers Corp.', N'1811 Hunting Hill Circle, Austin, Texas, 58343', '5f00c41b-39dc-51ee-0802-eefebbd653b8', '36460dcf-323b-1391-8ec9-bcec0cd444f8', '481c748b-2a85-2a28-efb6-6f4dd73eba9e', 1, NULL, 63583, 3266, 80479, '2012-08-29 13:26:23.560', 0, '2013-04-01 16:39:30.567', 8, 388.34, 72.66, 7, N'dzrdjgpdjfcnkuxwqjxwtkjitcjwsoadpjmdfexknwwhzekvelfphgugzjzaphlerbwbuz', N'oolehaxu', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('6c4ebe20-31c5-1ec9-0948-b983316b8374', N'Western Space Explore Corporation', N'98 Burwood Loop, Little Rock, Arkansas, 54241', '49bdab11-1115-7150-d84b-16e575b61049', '4abdf3c0-7507-7423-304d-4c0f86f26090', '26c1e1f8-3a26-53fe-5876-66508ad02725', 2, NULL, 51712, 6604, 96954, '2002-04-27 23:02:12.340', 0, '2003-01-21 08:12:27.561', 1, 877.1, 9.95, 4, N'hfofwiddjpgjchfuhyllihstoecfagudvgvxzcqulfsgjqgxnalhkxhgjfvfapqbhnxfcjiegwlgmkmcxcdagdi', N'ldipdimavmuzqxomiknoxqsqrygcffexckaetwlseizbvcmfzlmqizuzdqgacsxdngjcrmixajtkgwumrpxzjebgtgfjq', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('3813ed54-50cb-5d88-485f-1885b89fc8fc', N'City Space Explore Inc.', N'766 Pine Tree Cir, Little Rock, Arkansas, 71706', '2f8a5a0d-54fa-587b-5676-66508ad02725', '6f0fc907-5bf7-6e28-ef96-94965a4eaa62', '6f0fc907-5bf7-6e28-ef96-94965a4eaa62', 2, NULL, 78106, 5370, 33248, '1973-10-13 06:45:06.460', 0, '1973-12-02 19:38:17.169', 5, 239.49, 10.13, 9, N'alanqqyxzokagvuldmwffhetzfkwlbdnnukqspxetsumbfehenrtyysnfecrbfszt', N'hhcnruqfuahojscisgwofvotygegkejeocpzjqnrhfbcl', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('1faf0e4a-4d03-3578-3314-9ad3d3072fe3', N'Professional Protection Group', N'424 S Bayview Blvd, MidAmerican Bldg, Helena, MT, 53914', '7959e1dd-2e0b-4306-7a7e-3e3b283cabde', '6c4c1f9b-1644-2620-5976-66508ad02725', '228bfc03-38db-4741-f096-94965a4eaa62', NULL, NULL, 14581, 8031, 48687, '1993-02-01 07:16:10.860', 0, NULL, 4, NULL, 44.92, 7, N'gaqhin', N'kzlshnsnu', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('5346a8b8-32e1-6513-797d-18b43b6e1561', N'Future High-Technologies Inc.', N'3962 Hope Way, Kearns Building, Trenton, NJ, 61150', '2f8a5a0d-54fa-587b-5676-66508ad02725', '61e25755-3de1-1adf-8fc9-bcec0cd444f8', '49bdab11-1115-7150-d84b-16e575b61049', 1, NULL, 28215, 7117, 66108, '1973-12-20 05:11:02.000', 2, '1974-12-25 08:21:30.278', 1, 830.25, 44.46, 8, N'jgpaykaez', N'kekenb', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('6b4b77f4-7e44-245e-2293-373516031d8e', N'Future L-Mobile Inc.', N'230 NE Waterview Circle, First Security Bldg, Frankfort, Kentucky, 52106', '7e919581-5fd4-1caf-5776-66508ad02725', '1a361dba-2edd-6ebd-324d-4c0f86f26090', '49bdab11-1115-7150-d84b-16e575b61049', NULL, 2, 51562, 2236, 33862, '2008-10-31 19:19:32.480', 2, NULL, 8, NULL, 48.82, 1, N'zlgr', N'rhqnuekysivzunkzyotcrikwaeoitljjfxviznqetpysjiyqrattbdcuhlrdgngjgdhdsgjwtxqrrfuimhqkcrkovbxfhmutplyz', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('3ee70979-660a-12d3-6132-9a0257d67b47', N'American W-Mobile Corporation', N'3491 East Rose Hill Lane, Kearns Building, Columbia, SC, 10493', '699acaa2-66da-563a-1702-ce5da15ac776', '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', '699acaa2-66da-563a-1702-ce5da15ac776', 2, NULL, 89274, 681, 78114, '2006-07-01 03:57:52.970', 1, '2008-02-19 15:37:53.663', 2, 656.3, 58.73, 7, N'tnzvkivizpqcefarqyyhqpevyelxwhsxdeaugdeiiyzopxdasbxiehedjjxjgrvtijhjqghkqwjazzhllojyt', N'nghchptqfdnjujhbpfpnquwjnqkluiappdni', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('6759642e-15d6-1ff2-0a48-b983316b8374', N'East Space Research Corporation', N'2196 Church Road, Keith Bldg, Topeka, Kansas, 56438', '49bdab11-1115-7150-d84b-16e575b61049', '5aa02579-73ed-23cd-314d-4c0f86f26090', '2dc6dc0b-307b-3bde-5c76-66508ad02725', 1, NULL, 77582, 4358, 58153, '2006-08-09 07:20:17.090', 2, '2008-07-15 09:10:06.748', 1, 35.8, 44.4, 2, N'pizujd', N'rafyr', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('54469410-116f-3806-3c09-69a9b1bfbc32', N'Pacific Development Group', N'2087 Hazelwood Lane, Plaza Building, Columbus, OH, 69092', '2dc6dc0b-307b-3bde-5c76-66508ad02725', '1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', NULL, NULL, 58748, 934, 71939, '2017-09-02 00:56:30.100', 1, NULL, 4, NULL, 87.71, 0, N'aawlseaijacnwcfnzgwhtvdqyhfhlamptxhujnceylfmcjrgfqgpkgfkoxoebuatzgppemqbagya', N'caopcfbraioqssetupsbslgxgnnutvdvsbsvisjgshxqdhgxrfuddbpqdwaikiuegqoruwjtecx', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('5224197a-4d23-7fee-24be-eaf7cc272319', N'Home Space Explore Group', N'1571 Pine Tree Highway, Montpelier, VT, 85468', '5f00c41b-39dc-51ee-0802-eefebbd653b8', '61e25755-3de1-1adf-8fc9-bcec0cd444f8', '51d8cc33-7be1-161f-f396-94965a4eaa62', 1, NULL, 25511, 1586, 30042, '1975-01-11 17:39:32.960', 1, '1976-02-17 03:33:15.653', 2, 561.06, 5.45, 0, N'ahwclnvleoqzfhoyqnlgdftkyeighxmxnfh', N'ahpdlj', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('795f25d7-204a-4058-d17e-e08e331d25c7', N'Western Engineering Corporation', N'114 Old Riverside Loop, Atlanta, GA, 72597', '58fc185f-1925-3117-334d-4c0f86f26090', '3f22df3a-3b15-3b5a-787e-3e3b283cabde', '69619ef2-1249-20fa-797e-3e3b283cabde', 2, NULL, 84361, 7660, 31415, '1972-06-09 09:10:08.080', 0, '1974-07-02 08:27:57.077', 9, 680.08, 45.42, 2, N'wkcprovocbbnextuuezbop', N'lyahmoelabpybyypaoisaxwfaokmcajuphclaqoth', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('6ea4db4a-59e8-25fc-3d09-69a9b1bfbc32', N'Special High-Technologies Group', N'2190 4th Road, Jackson, MS, 52247', '1b3166b4-1301-5956-5a76-66508ad02725', '699acaa2-66da-563a-1702-ce5da15ac776', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', NULL, NULL, 99468, 767, 91603, '1981-09-24 09:25:42.220', 1, NULL, 9, NULL, 93.27, 4, N'yyolidgdvmjbhxtwejxdnwlxmsmmeqeallqdtcfktprefturovfemffsjscskbbifbaptnd', N'dqbzvdvupyznksjpwjqlzcfkfizxuwetcyzqbploqbocgvthaoslhvtwhrpgalapzxtmijrfwqxlquri', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('617b71b5-3b9d-7c86-495f-1885b89fc8fc', N'Domestic J-Mobile Inc.', N'1933 NW Rushwood Ave, Jefferson City, MO, 30677', '7959e1dd-2e0b-4306-7a7e-3e3b283cabde', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '6f0fc907-5bf7-6e28-ef96-94965a4eaa62', 2, 1, 73654, 3109, 40738, '2017-09-28 06:25:20.190', 1, '2020-04-28 09:23:31.149', 7, 6.58, 20.07, 3, N'hufiylngdgunswnsfmhfamwawuvsonggvrpocaypqwwbyiyczt', N'bxplra', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('384e5dfc-5836-3fa0-b933-62dd4e858bad', N'Special D-Mobile Co.', N'3023 2nd Rd, Standard Bldg, Tallahassee, Florida, 52809', '51d8cc33-7be1-161f-f396-94965a4eaa62', '58fc185f-1925-3117-334d-4c0f86f26090', '5f00c41b-39dc-51ee-0802-eefebbd653b8', 2, NULL, 17781, 2910, 18918, '1994-11-15 02:17:05.540', 0, '1994-11-25 20:40:00.103', 4, 9.73, 75.15, 4, N'igydmujaiqdozahefff', N'ydskqcuonwjxzjlpgkelpcbkxbckjlufakceenfbfnrthwixbklpxunxkjhtylwjqqzfejprfrjmlrymgpw', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('52b2338d-74a9-4bcb-7a7d-18b43b6e1561', N'International H-Mobile Inc.', N'490 Red Riverview Cir, Duke Energy Bldg, Pierre, South Dakota, 84056', '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', '699acaa2-66da-563a-1702-ce5da15ac776', '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', 1, NULL, 67776, 8615, 24891, '2004-12-16 10:13:11.260', 2, '2005-01-14 11:34:43.820', 3, 511.39, 14.41, 0, N'abkvsclrliouaxowqgkfvczrjmcbnaeivfmfe', N'alq', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('44c1a769-7d71-2ee0-6232-9a0257d67b47', N'Advanced Space Explore Group', N'929 E Pine Tree Blvd, Bartlett Building, Pierre, South Dakota, 96599', '1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', '43624c49-472d-4810-f296-94965a4eaa62', '2f8a5a0d-54fa-587b-5676-66508ad02725', 2, NULL, 65640, 4079, 38605, '1992-04-26 11:55:22.160', 2, '1993-11-02 08:58:28.499', 3, 746.67, 74.62, 10, N'pgcc', N'wnrqjfihiqcobfshglfzbjjjvpuxfawfdvlycfvkrwshzpjwtfbpspptgjwvwdubvjiedjkcrx', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('3e24df7d-1d34-689e-3414-9ad3d3072fe3', N'First Mining Co.', N'1705 White Fox Hill Blvd, Bartlett Building, Sacramento, CA, 33166', '49bdab11-1115-7150-d84b-16e575b61049', '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', 2, NULL, 35361, 1979, 61133, '1970-11-07 17:19:20.620', 0, '1971-02-25 05:24:41.003', 9, 98.62, NULL, 5, N'agdpmbtmod', N'urgmnolcnztiglgsbbiysesjoxcebghbgndouzoxlynejcitipbhydqagjxe', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('71ef4cd8-7f35-5b59-4a5f-1885b89fc8fc', N'Federal High-Technologies Group', N'88 1st Parkway, Springfield, IL, 12286', '2f8a5a0d-54fa-587b-5676-66508ad02725', '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', 1, NULL, 22657, 3092, 25494, '1993-12-19 13:00:15.840', 1, '1994-09-04 00:34:24.964', 1, 487.26, 31.87, 3, N'axhmpkoyjkiozlehhygish', N'jrtjrjdiz', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('32a5d5fd-55ba-5e74-25be-eaf7cc272319', N'Home Green Resources Inc.', N'3863 Front Ln, Equitable Building, Tallahassee, FL, 37741', '2dc6dc0b-307b-3bde-5c76-66508ad02725', '669afd3f-720a-6e34-1902-ce5da15ac776', '244bd1b5-7428-4b87-0702-eefebbd653b8', 2, NULL, 55886, 5266, 59882, '2004-09-30 20:31:22.430', NULL, '2005-05-02 04:44:31.175', 7, 226.02, 11.52, 2, N'gxgnjegpwneukiqasnoxwafzqabewnfwxopxagclkffaivtsjauvgboeumsozhhnc', N'qqujgyzqqwkslauatgemolhguggkelpaosdieu', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('384ec334-55ea-63d6-d27e-e08e331d25c7', N'Beyond Nuclear Energy Group', N'50 Parkwood Lane, 66th FL, Phoenix, AZ, 53648', '7959e1dd-2e0b-4306-7a7e-3e3b283cabde', '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', '5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', 1, NULL, 30297, 6741, 64732, '2011-01-17 02:56:08.950', 2, '2013-07-17 18:01:20.587', 4, 41.93, 33.1, 2, N'ukavmhanoeltwlgnetjzbkgshlvqtsfgqjntgfekjuzywgvvbntirtdwxpegi', N'mmcerdouncsrqcsspqapdh', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('48ad7074-68bd-5fb1-3e09-69a9b1bfbc32', N'WorldWide V-Mobile Group', N'3625 Chapel Hill Circle, Little Rock, AR, 50889', '7959e1dd-2e0b-4306-7a7e-3e3b283cabde', '2f8a5a0d-54fa-587b-5676-66508ad02725', '284445b2-65be-4f66-422b-e89ea5388e0b', 2, NULL, 94008, 9290, 78623, '2000-06-02 20:58:53.760', 1, '2001-11-01 02:34:11.984', 7, 609.97, 7.62, 7, N'sxxktjzssbw', N'jyvqwimilkwlgfrdzfnhjxcyajshyzmaxtanxtzoctixwdtkpgnqzllbjtdeddamtjiqysktlczszhckud', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('24772a1a-2649-14d7-2393-373516031d8e', N'WorldWide Z-Mobile Corporation', N'824 Waterview Ct, Charleston, WV, 73693', '397bc919-4888-5ab2-402b-e89ea5388e0b', '3f22df3a-3b15-3b5a-787e-3e3b283cabde', '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', 1, NULL, 78580, 7852, 76721, '1982-03-16 05:28:59.180', 2, '1984-03-04 18:06:25.556', 4, 631.05, 74.76, 7, N'xmrcpjjgexgzo', N'kqhemuzosxpkfnai', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('7f029887-6ee3-1cee-ba33-62dd4e858bad', N'Home High-Technologies Group', N'2209 Rock Hill Drive, 1st Floor, Juneau, AK, 76615', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', '2f8a5a0d-54fa-587b-5676-66508ad02725', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', 2, NULL, 14893, 4061, 57542, '1997-10-06 04:36:10.480', 0, '1998-01-24 14:18:32.202', 4, 600.5, 8.72, 5, N'hswryczvqahbikbrlidmdiutudaqs', N'xikppuznnhamgdavjjactmdsvscxahb', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('68eb14f2-6c91-72a0-26be-eaf7cc272319', N'Domestic High-Technologies Group', N'2923 Church Circle, Salt Lake City, UT, 46078', '36460dcf-323b-1391-8ec9-bcec0cd444f8', '244bd1b5-7428-4b87-0702-eefebbd653b8', '228bfc03-38db-4741-f096-94965a4eaa62', 1, 2, 31760, 6066, 13088, '2012-07-07 22:51:31.770', 2, '2012-10-19 00:38:36.977', 7, 8.55, 90.42, 5, N'ielidbtszdmghhqruwggbhazatybjiqhkfiayfhbeo', N'bezbdftxajtqueznykhcskacisgkioimzpibqvwphpbvyeomaswpeevnnclhbdsqosxotttaz', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('72f9734f-5598-1fd4-0b48-b983316b8374', N'Pacific Products Co.', N'791 White Mount St, Jefferson City, Missouri, 35775', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', '43624c49-472d-4810-f296-94965a4eaa62', 1, NULL, 21774, 173, 67954, '1986-02-02 18:03:13.820', 1, '1986-05-29 01:36:29.515', 10, 838.39, 78.08, 2, N'azvjnnvunnsecjszrgqzdhxfkrjzaafilhmz', N'pjahd', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('266b853c-29e7-2243-7b7d-18b43b6e1561', N'First High-Technologies Inc.', N'2600 South Buttonwood Pkwy, Enquirer Bldg, Montgomery, Alabama, 81436', '397bc919-4888-5ab2-402b-e89ea5388e0b', '669afd3f-720a-6e34-1902-ce5da15ac776', '6f0fc907-5bf7-6e28-ef96-94965a4eaa62', 2, NULL, 98547, 9121, 39851, '1975-05-03 04:38:17.790', 2, '1975-11-10 14:02:46.203', 1, 127.95, 42.25, 2, N'vdfurexjfmqvorussfvpuucykcohwhjhltmxtggroybargbmjiwxmsksizoyjefftgeanlckwgyizqreqataskh', N'uwvqtdswabefomhusbdtx', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('4c562935-59e3-7f89-3514-9ad3d3072fe3', N'North Space Research Corporation', N'1400 Burwood Blvd, Bismarck, ND, 69497', '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', '228bfc03-38db-4741-f096-94965a4eaa62', '14735d5d-67ff-5dad-412b-e89ea5388e0b', 2, NULL, 2198, 9486, 91840, '2009-04-02 19:49:05.830', 1, '2009-08-01 08:45:48.556', 3, 555.21, 4.27, 3, N'vxfeyqmawnipqluvdzdyfczhs', N'fiyrorfrqqqjiyozaytjzdvopmtjukerypjyynckhaimgao', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('35b2aead-6784-4f96-d37e-e08e331d25c7', N'Future Solar Energy Group', N'1753 Chapel Hill Road, Lincoln, NE, 16186', '5ebb6116-1627-3f70-0602-eefebbd653b8', '3f22df3a-3b15-3b5a-787e-3e3b283cabde', '5ebb6116-1627-3f70-0602-eefebbd653b8', 1, NULL, 95317, 3601, 90891, '1991-02-26 04:09:10.730', 0, '1991-05-21 05:06:56.609', 1, 441.93, 46.79, 8, N'abvagtoqnplconfqvcszdixtz', N'bonkxodxqqfju', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('314a6fb8-4bc9-4ff8-2493-373516031d8e', N'General Research Group', N'2970 Cedar Tree Pkwy, MidAmerican Bldg, Cheyenne, Wyoming, 33641', '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', '2dc6dc0b-307b-3bde-5c76-66508ad02725', '5aa02579-73ed-23cd-314d-4c0f86f26090', 2, NULL, 31283, 4862, 10315, '1986-07-08 13:21:48.570', 0, '1986-11-23 10:16:59.666', 9, 143.67, 84.85, 3, N'rzopefdaiwpdwcrlocfuhvgxkikd', N'e', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('3c37d109-2027-2e44-0c48-b983316b8374', N'General Services Inc.', N'3786 Hazelwood Blvd, STE 4078, Charleston, West Virginia, 69084', '5f00c41b-39dc-51ee-0802-eefebbd653b8', '61e25755-3de1-1adf-8fc9-bcec0cd444f8', '5e306560-6b07-2cdf-5b76-66508ad02725', 1, NULL, 91050, 8220, 50652, '1999-05-09 11:32:25.270', 2, '2000-01-13 05:52:25.820', 2, 879.85, 76.42, 5, N'dilpecmkihiqaifntnmcwitsogufzrtcsbfwnmavvgrmwxrzroclhetigqyybnqyenhijeutsleggtszcdenhl', N'ygfgxttqutlanwyyahbgauzfgdedgn', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('351f5379-3782-68ad-3f09-69a9b1bfbc32', N'Pacific High-Technologies Inc.', N'3478 Bayview Drive, Frankfort, Kentucky, 96645', '7e919581-5fd4-1caf-5776-66508ad02725', '669afd3f-720a-6e34-1902-ce5da15ac776', '5e306560-6b07-2cdf-5b76-66508ad02725', 2, NULL, 32692, 9708, 42638, '2017-09-13 17:34:56.850', 0, '2018-06-21 18:54:17.369', 3, 701.06, 88.14, 8, N'hgqdfrzstabpgzmrf', N'thgkmnllteewvuqsagpgawvciakdgwgnpomajizmojfjtiaxupdcmvgrzlvnignyvcfifyafhwzmjk', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('36e2737b-31c8-75e9-6332-9a0257d67b47', N'Beyond J-Mobile Corporation', N'929 Hunting Hill Highway, Dover, Delaware, 35094', '4f7021f5-7800-11be-0a02-eefebbd653b8', '14735d5d-67ff-5dad-412b-e89ea5388e0b', '69619ef2-1249-20fa-797e-3e3b283cabde', 2, NULL, 84535, 5588, 93396, '1970-05-22 12:13:12.590', 0, '1970-11-16 11:43:37.485', 2, 179.15, 51.02, 0, N'ievzbfupfvimdjaawsjzkbgqqhteehvgdavccpckahfgfzrwcztjmkrlmbzpwjzoqctabzjfdtohrmurp', N'tlumygyvhgqgllwcibvygdrxxghynwzcqjfzpjtntvqvbcrawwpzruzafirihljstsvwlfhqepd', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('61bfff58-553d-4bc5-2593-373516031d8e', N'Domestic Management Corp.', N'94 Chapel Hill Loop, Denver, CO, 92870', '36460dcf-323b-1391-8ec9-bcec0cd444f8', '49bdab11-1115-7150-d84b-16e575b61049', '481c748b-2a85-2a28-efb6-6f4dd73eba9e', 1, 1, 79237, 9967, 91695, '1991-08-16 04:05:13.040', 1, '1994-04-18 11:59:22.417', 9, 149.97, 4.98, 3, N'bqyaparmqtfkzxpzyjzlratbanacmgptzubvvmmecnnozkujkpopuudkvvoihw', N'khqgjzeks', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('1ff90f83-3580-7afb-7c7d-18b43b6e1561', N'Australian Renewable Power Co.', N'124 Waterview Loop, STE 38, Providence, RI, 98978', '3a6dba26-6960-6953-d74b-16e575b61049', '49bdab11-1115-7150-d84b-16e575b61049', '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', 2, NULL, 86084, 184, 39565, '2001-12-01 20:20:24.830', 0, '2003-10-18 00:41:27.663', 1, 2.36, NULL, 0, N'ghcidhrutkygxsypqqvgwdjpeluiqgizlryuplnfeievkneawfluitieopsvvlc', N'rskteyavbdszewerkawclbnjmevhizurtnkyeagijmwovbhlvfkvmgtaoxuqncnuxvekjzbtwaq', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('24b42eae-5683-39a4-27be-eaf7cc272319', N'Pacific Broadcasting Inc.', N'434 NW Riverview Avenue, Appartment 58, Topeka, KS, 93865', '3a6dba26-6960-6953-d74b-16e575b61049', '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', '58fc185f-1925-3117-334d-4c0f86f26090', 1, NULL, 20748, 759, 37415, '1983-05-05 16:04:12.030', 2, '1985-01-27 05:11:58.774', 5, 677.35, 14.71, 6, N'tunjimhtcmaenwntumtoehskgkntuqajbnkhdhwmrorkngmoficbhxqvhykyagjfvfvrpopwddmianivfp', N'ncefi', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('7f158ff5-1f71-1116-6432-9a0257d67b47', N'Future T-Mobile Corporation', N'2766 NW Ashwood Cir, Plaza Building, Tallahassee, Florida, 56207', '5f0a8444-3de1-3f02-eeb6-6f4dd73eba9e', '699acaa2-66da-563a-1702-ce5da15ac776', '51d8cc33-7be1-161f-f396-94965a4eaa62', 1, NULL, 65794, 5535, 33085, '2001-08-08 03:12:06.560', 1, '2004-04-21 17:53:58.765', 1, 377.83, 61.42, 8, N'ezbbatmnwlbtnhgbpsxeofjqxqzhfrtjvhzlxhymupwmovnfenppclawiijkqrwuxypddotkkvaadrxlqe', N'zgvcguqlqqlyanfkvdzmlteghzisbeqvcqxolnzkcjayoucbxxojwcagnehjwhggmpaahzeefrqmadatbjo', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('6c13432f-34be-12f9-4b5f-1885b89fc8fc', N'Western Financial Experts Inc.', N'413 N Chapel Hill Circle, Standard Bldg, Providence, RI, 44762', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', '14735d5d-67ff-5dad-412b-e89ea5388e0b', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', 2, NULL, 13920, 903, 20584, '2012-03-03 15:57:14.430', NULL, '2014-06-15 05:02:38.972', 7, 353.48, NULL, 4, N'ucgyj', N'eybtpjwoqbhijjdbailfgafialmepahwiowlbhzmuezsmangjcoavhfrgemxmiszqtjgjeapxo', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('12864082-4424-3ce5-3614-9ad3d3072fe3', N'General Space Research Inc.', N'1718 Old Flintwood Lane, Calyon Building, Denver, Colorado, 84178', '1b3166b4-1301-5956-5a76-66508ad02725', '6c4c1f9b-1644-2620-5976-66508ad02725', '1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', 2, NULL, 66047, 3361, 71743, '2011-05-19 02:10:08.700', 0, '2012-10-06 12:17:34.636', 6, 301.83, 76.75, 3, N'myxyzgzkrzeccwqzvsioopqdodbtyqczmdvksanomccpsbrxiriccbcrxzdpr', N'zblgzxruonzlthfvldaehqzciyzf', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('1f117f94-2792-59e1-7d7d-18b43b6e1561', N'City High-Technologies Co.', N'1488 E Flintwood Highway, Appartment 10, Little Rock, AR, 05843', '51d8cc33-7be1-161f-f396-94965a4eaa62', '244bd1b5-7428-4b87-0702-eefebbd653b8', '51d8cc33-7be1-161f-f396-94965a4eaa62', 2, NULL, 28711, 350, 86815, '1972-11-28 22:57:12.920', 0, '1974-03-18 04:33:10.713', 7, 972.03, 17.93, 9, N'woatddiaekeapubfkdzstlhiqdmpimqjbnznpdvghycrisenawazjsegbrjhmhoawwutcelrkpgivivvenzghwapfgueq', N'yctzvemcpgrjdnujymbxzw', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('78f21e91-5225-5a57-0d48-b983316b8374', N'Canadian A-Mobile Corporation', N'2148 Rock Hill Parkway, Montgomery, AL, 26048', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '699acaa2-66da-563a-1702-ce5da15ac776', '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', 2, NULL, 38039, 5063, 18626, '1992-04-03 17:41:30.240', 1, '1993-02-20 16:31:30.693', 3, 845.88, NULL, 7, N'pegltftlp', N'ucj', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('45df29a3-5008-5f0c-bb33-62dd4e858bad', N'West Coast Space Research Group', N'37 Social Way, Keith Building, Hartford, CT, 89025', '49bdab11-1115-7150-d84b-16e575b61049', '5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', 2, NULL, 14594, 1277, 18567, '1986-10-27 13:59:21.360', 0, '1989-05-27 03:49:38.317', 9, 671.51, 88.25, 8, N'ifiugehghdtoaeaczdzffdzkydtzpiarwaqoquuamnkonbwwzgr', N'tsdnlkwcecqzfpxbybjcqqimyguzrtkigcmqceuijtoghhwndfbvvfqmovjuiyxgagziwkyknvkbfwp', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('27c88b6e-225f-173e-6532-9a0257d67b47', N'American M-Mobile Group', N'181 West Town Circle, Jackson, Mississippi, 10988', '5ebb6116-1627-3f70-0602-eefebbd653b8', '2f8a5a0d-54fa-587b-5676-66508ad02725', '36460dcf-323b-1391-8ec9-bcec0cd444f8', 1, NULL, 56625, 3094, 31981, '1979-01-12 03:45:42.070', 2, '1981-09-15 08:41:13.276', 3, 502.69, NULL, 3, N'dqgwfjefiqdjyjiycbgxbqlokfxjriqpakrwlotwzo', N'feoiedkpscgwihxtfzqyhfprxuytjmaqnm', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('2b79b81d-51eb-2e8e-d47e-e08e331d25c7', N'Home Transportation Corporation', N'3167 West Mountain Court, Pierre, SD, 21229', '5f00c41b-39dc-51ee-0802-eefebbd653b8', '2f8a5a0d-54fa-587b-5676-66508ad02725', '14735d5d-67ff-5dad-412b-e89ea5388e0b', 2, NULL, 44315, 2364, 6246, '2001-07-07 07:30:31.170', NULL, '2002-06-12 09:27:43.376', 7, 875.63, 46.51, 10, N'oaqpoxlbm', N'gnyatdzjnyxldteghwczkwiadywkqhwhjdzqnkpenmagzlnathykz', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('59894768-6485-5662-bc33-62dd4e858bad', N'Canadian Industry Co.', N'55 NW Front Ct, Raleigh, NC, 21383', '43624c49-472d-4810-f296-94965a4eaa62', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', '228bfc03-38db-4741-f096-94965a4eaa62', 1, NULL, 41909, 5179, 65406, '2005-04-22 09:43:35.240', 2, '2006-03-16 07:42:11.602', 8, 496.22, 92.45, 2, N'eewnqxdvaxqwcdrcotxhmynonzyoorggwbjdxdidammmuyeobaduxfijilnblnbiijzlyfbfawwzvwcfeoqdoj', N'nqrleotcokaoipeqzjcwvgmtehrznykvpfqqiocekyinsfydzhiticihbqmmsoeagjebzniwffujkhickyshpgohdhygcuo', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('7e70d606-72c8-2830-4c5f-1885b89fc8fc', N'North C-Mobile Group', N'98 New Fox Hill Way, Keith Bldg, Salt Lake City, UT, 10886', '202cad24-4598-16cf-1a02-ce5da15ac776', '6c4c1f9b-1644-2620-5976-66508ad02725', '2dc6dc0b-307b-3bde-5c76-66508ad02725', 1, 1, 41064, 5720, 6350, '2014-06-01 06:44:25.060', 2, '2015-02-10 18:45:40.241', 7, 645.21, 47.33, 5, N'aoufvmxcpjgaoqadwwqhag', N'xtfqnbistfjfightigsbjwgkyckhtvemlzpnccjxemhsmzkuvbnnxmitgbatlztpbbfsfx', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('685e14d6-366c-5b7a-7e7d-18b43b6e1561', N'Professional 2G Wireless Inc.', N'2348 Hunting Hill Parkway, Phoenix, AZ, 51405', '2dc6dc0b-307b-3bde-5c76-66508ad02725', '49bdab11-1115-7150-d84b-16e575b61049', '244bd1b5-7428-4b87-0702-eefebbd653b8', 1, NULL, 84298, 2710, 7878, '1973-05-01 20:22:05.120', 1, '1975-11-09 21:51:11.716', 8, 996.43, 56.12, 9, N'xabfelbplewaatyet', N'zxirptamadxrqcnoxcnvqfmneckxdtryqvdlmmvejjifsdcbowzebbghmmhwivnuggkcmppijopgcpqctn', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('28f1eb96-2480-27f3-4009-69a9b1bfbc32', N'City H-Mobile Group', N'3096 NW Farmview Highway, MidAmerican Building, Sacramento, CA, 42609', '1259a17c-69e8-7a1c-da4b-16e575b61049', '6f0fc907-5bf7-6e28-ef96-94965a4eaa62', '36460dcf-323b-1391-8ec9-bcec0cd444f8', 1, NULL, 21024, 9510, 94255, '1996-01-18 07:30:23.520', NULL, '1996-08-17 05:00:55.403', 5, 259.86, 9.24, 10, N'ccnmgusdiupbclrhbvcgih', N'ltkezozponqlcrd', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('5dd3992f-743a-77ef-d57e-e08e331d25c7', N'Smart Research Co.', N'338 Red Ski Hill Loop, Judge Building, Des Moines, Iowa, 87156', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '3f22df3a-3b15-3b5a-787e-3e3b283cabde', '244bd1b5-7428-4b87-0702-eefebbd653b8', 2, NULL, 77972, 777, 5827, '2004-04-19 00:25:43.210', 2, '2004-05-20 10:41:19.727', 7, 809.99, 73.65, 8, N'rvdrtxkwbrzeldqnqaaciebvzsakwmnkadgqjltkfnsakspvinnhqrlwanddxseg', N'vajsvitkjfsh', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('7646fdd5-2cad-6d80-3714-9ad3d3072fe3', N'American Investment Co.', N'1303 Meadowview Parkway, Honolulu, Hawaii, 21722', '37e456ed-14a3-6717-f3b6-6f4dd73eba9e', '58fc185f-1925-3117-334d-4c0f86f26090', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', 1, NULL, 46431, 6037, 12941, '1988-12-30 10:38:29.010', 1, '1990-04-03 20:17:00.867', 1, 66.93, 30.27, 4, N'khxapgjsugtpbddpunbefssobzpirxzccxdqyfmetocmpololzuntjdlizogiuurpolzvhiouscfcaexizyompxbsb', N'bzigezevovkfgwqwspbvgslhjlnopbwlsynttbavqvlyzjvexvcwjkymjcjcyrsxhdqioscxovnnirctaszwrirhwwtpoalulzq', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('4275edfc-7af9-7040-4d5f-1885b89fc8fc', N'Future K-Mobile Inc.', N'1319 2nd Lane, Concord, New Hampshire, 57788', '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', '5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', '61e25755-3de1-1adf-8fc9-bcec0cd444f8', 1, NULL, 94474, 9840, 10286, '1994-01-14 23:28:16.170', 0, '1995-11-09 22:42:56.570', 9, 26.67, 2.19, 2, N'kjivomocajnunneyewwfnuujxmmuhnzvrvnhwftkkktasofibvidueerbckmaszuxzqjrzfi', N'lmjqrphwyuoviexfdtkrdbvfcuruxmaddjgzsiyzbfzdzrpesc', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('299b9de4-7744-56f2-6632-9a0257d67b47', N'American T-Mobile Corp.', N'141 North Beachwood Lane, Dover, DE, 72068', '4f7021f5-7800-11be-0a02-eefebbd653b8', '36460dcf-323b-1391-8ec9-bcec0cd444f8', '5f0a8444-3de1-3f02-eeb6-6f4dd73eba9e', 1, NULL, 3374, 8049, 35527, '1994-02-26 23:45:25.720', 2, '1994-05-18 09:32:10.521', 3, 991.88, 19.88, 8, N'jqzyqhaemmwbtddxncpwxhkfqhsceyabwugaozrnfoeilbajxhdaplwoffqo', N'pyfffrglhrfuyfmiisqreopkpsdocmslszkonzuhtrmmgy', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('37117dc9-69a0-3deb-2693-373516031d8e', N'Home High-Technologies Corporation', N'73 Chapel Hill Hwy, Oklahoma City, OK, 23926', '51d8cc33-7be1-161f-f396-94965a4eaa62', '5aa02579-73ed-23cd-314d-4c0f86f26090', '5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', 2, NULL, 93440, 7978, 74500, '1976-07-14 23:34:21.800', 2, '1978-08-17 09:42:22.195', 10, 4.43, 89.36, 8, N'bv', N'rz', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('755a3a81-4cce-7aa8-bd33-62dd4e858bad', N'International Software Group', N'49 Sharp Hill Lane, Hartford, CT, 21579', '4f7021f5-7800-11be-0a02-eefebbd653b8', '69619ef2-1249-20fa-797e-3e3b283cabde', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', 2, NULL, 34566, 7048, 21479, '1982-10-19 09:15:57.810', 1, '1985-03-23 11:43:38.761', 8, 727.54, 29.82, 8, N'ewqknecjrnwxnenjbnnjbeftneqnmsdnjwksbdrkfxrfcyjoew', N'vttiwjzvfnzcrtvegrbithogdguyav', 0)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('1481cbe0-4fc4-7a72-0e48-b983316b8374', N'Advanced High-Technologies Corp.', N'1603 SE Beachwood Ave, Diamond Bldg, Sacramento, CA, 54972', '1b3166b4-1301-5956-5a76-66508ad02725', '5e306560-6b07-2cdf-5b76-66508ad02725', '5ebb6116-1627-3f70-0602-eefebbd653b8', 1, NULL, 66009, 9487, 99789, '1998-12-06 03:27:33.440', 1, '2000-05-13 05:18:41.696', 2, 545.52, 20.89, 7, N'hezsbldymoctnqoagzjmdlyohsijsbwvvqagjxqhqklleegudlijnutkdzbfdbolxzyrrtbbjgagbdrpqjdeo', N'hl', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('41e622cb-637c-2a70-d67e-e08e331d25c7', N'American Petroleum Co.', N'3127 Quailwood Parkway, Montgomery, Alabama, 54569', '2dc6dc0b-307b-3bde-5c76-66508ad02725', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', '3f22df3a-3b15-3b5a-787e-3e3b283cabde', 1, NULL, 74722, 2716, 20009, '1986-11-03 04:51:38.530', NULL, '1989-04-25 04:35:50.955', 2, 647.04, NULL, 9, N'tjvecgujypqmeebadcqgzkqgyttsafedpfaednffnvrusovcewwjaichkrm', N'vifdxwnocdyzvguwyhovvwseuancgeulsfbdfkedinsbsqfpmtisqjnjsty', 1)
  INSERT dbo.Project(Oid, Name, Address, Client, Manager, Foreman, OptimisticLockField, GCRecord, Balance, BalanceByMaterial, BalanceByWork, PlaningStartDate, Status, FinishDate, Area, WorkPriceRate, WorkersPriceRate, RemainderTheAdvance, PlanfixWorkTask, PlanfixChangeRequestTask, UseAnalytics) VALUES ('58eb8d42-5369-57c2-2793-373516031d8e', N'National High-Technologies Inc.', N'415 Burwood Cir, Tallahassee, FL, 54500', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', '5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', 1, 1, 77375, 9078, 48544, '1978-11-20 20:08:44.410', 0, '1979-03-12 20:01:22.510', 3, 744.13, NULL, 8, N'cbzxqrhiffr', N'fgheahwpfntrfmirjeemaovqapsnjsfrfhcpqdpfyibdikihjibjgktxuwiuuaeldxglaaczlcqjuolzgascddn', 1)
  GO
  
  --
  -- Inserting data into table dbo.Bank
  --
  INSERT dbo.Bank(Oid, AccountType) VALUES ('202cad24-4598-16cf-1a02-ce5da15ac776', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('66b0e9ee-53c2-4a98-432b-e89ea5388e0b', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('2dc6dc0b-307b-3bde-5c76-66508ad02725', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('1259a17c-69e8-7a1c-da4b-16e575b61049', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('5aa02579-73ed-23cd-314d-4c0f86f26090', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('7a311573-456f-56e3-0902-eefebbd653b8', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('3f22df3a-3b15-3b5a-787e-3e3b283cabde', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('4f7021f5-7800-11be-0a02-eefebbd653b8', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('1a361dba-2edd-6ebd-324d-4c0f86f26090', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('7959e1dd-2e0b-4306-7a7e-3e3b283cabde', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('1257615f-5ea8-6cd9-0b02-eefebbd653b8', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('7e919581-5fd4-1caf-5776-66508ad02725', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('58fc185f-1925-3117-334d-4c0f86f26090', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('699acaa2-66da-563a-1702-ce5da15ac776', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('37e456ed-14a3-6717-f3b6-6f4dd73eba9e', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('51d8cc33-7be1-161f-f396-94965a4eaa62', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('24fee4c1-709c-79d6-1802-ce5da15ac776', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('14735d5d-67ff-5dad-412b-e89ea5388e0b', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('5ebb6116-1627-3f70-0602-eefebbd653b8', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Bank(Oid, AccountType) VALUES ('43624c49-472d-4810-f296-94965a4eaa62', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  GO
  
  --
  -- Inserting data into table dbo.Cashbox
  --
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('7a311573-456f-56e3-0902-eefebbd653b8', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('3a6dba26-6960-6953-d74b-16e575b61049', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('2dc6dc0b-307b-3bde-5c76-66508ad02725', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('3f22df3a-3b15-3b5a-787e-3e3b283cabde', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('2f8a5a0d-54fa-587b-5676-66508ad02725', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('751604f5-1e51-6d47-3f2b-e89ea5388e0b', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('1a361dba-2edd-6ebd-324d-4c0f86f26090', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('1259a17c-69e8-7a1c-da4b-16e575b61049', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('51d8cc33-7be1-161f-f396-94965a4eaa62', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('202cad24-4598-16cf-1a02-ce5da15ac776', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('1257615f-5ea8-6cd9-0b02-eefebbd653b8', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('14735d5d-67ff-5dad-412b-e89ea5388e0b', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('669afd3f-720a-6e34-1902-ce5da15ac776', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('6f0fc907-5bf7-6e28-ef96-94965a4eaa62', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('244bd1b5-7428-4b87-0702-eefebbd653b8', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('36ce1756-1d21-7373-f1b6-6f4dd73eba9e', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('5f00c41b-39dc-51ee-0802-eefebbd653b8', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('284445b2-65be-4f66-422b-e89ea5388e0b', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('4f7021f5-7800-11be-0a02-eefebbd653b8', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('7959e1dd-2e0b-4306-7a7e-3e3b283cabde', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('228bfc03-38db-4741-f096-94965a4eaa62', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('5f0a8444-3de1-3f02-eeb6-6f4dd73eba9e', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('336d8f99-255d-646e-f0b6-6f4dd73eba9e', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('6c4c1f9b-1644-2620-5976-66508ad02725', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('4abdf3c0-7507-7423-304d-4c0f86f26090', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('58fc185f-1925-3117-334d-4c0f86f26090', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('43624c49-472d-4810-f296-94965a4eaa62', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('1b3166b4-1301-5956-5a76-66508ad02725', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('37e456ed-14a3-6717-f3b6-6f4dd73eba9e', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('7e919581-5fd4-1caf-5776-66508ad02725', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('699acaa2-66da-563a-1702-ce5da15ac776', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('26c1e1f8-3a26-53fe-5876-66508ad02725', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('5ebb6116-1627-3f70-0602-eefebbd653b8', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('36460dcf-323b-1391-8ec9-bcec0cd444f8', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('2f1172a9-1b5d-6fc4-777e-3e3b283cabde', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('5e306560-6b07-2cdf-5b76-66508ad02725', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('66a18612-296a-25b0-d94b-16e575b61049', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('5aa02579-73ed-23cd-314d-4c0f86f26090', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('481c748b-2a85-2a28-efb6-6f4dd73eba9e', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('49bdab11-1115-7150-d84b-16e575b61049', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('69619ef2-1249-20fa-797e-3e3b283cabde', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('1a591774-4565-7236-90c9-bcec0cd444f8', 'c14044c4-0d50-4bce-af32-0639f7738026')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('397bc919-4888-5ab2-402b-e89ea5388e0b', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('61e25755-3de1-1adf-8fc9-bcec0cd444f8', 'f35c264e-9c7f-449b-ba68-f4e71f71e97e')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('66b0e9ee-53c2-4a98-432b-e89ea5388e0b', '2126ef07-0276-4440-b71c-c353516a0946')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('499200b3-46a5-60a7-f196-94965a4eaa62', 'a126415b-734d-4d05-bf68-f888d680c5ba')
  INSERT dbo.Cashbox(Oid, AccountType) VALUES ('24fee4c1-709c-79d6-1802-ce5da15ac776', '2126ef07-0276-4440-b71c-c353516a0946')
  GO
  
  --
  -- Inserting data into table dbo.Payment
  --
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('1f60e54f-196f-45f3-5498-ae38c5379e4b', 93, '7249bf2e-4d51-4a97-b62e-632ffeedc961', '5126a884-72e7-76eb-3909-69a9b1bfbc32', NULL, N'Pariatur unde totam et rerum. Tempora velit. Omnis iusto. Voluptas rerum!', '1980-07-08 13:21:53.660', '43624c49-472d-4810-f296-94965a4eaa62', '2f8a5a0d-54fa-587b-5676-66508ad02725', NULL, NULL, '1998-08-24 21:20:35.000', N'31862', 0, N'82341')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('13a507d0-342d-6292-6de3-2ceaa9cf3765', 22, 'a3228980-1fd3-4570-868b-b3911492664e', '7f9589fa-2b58-5866-1c93-373516031d8e', N'fiem', N'Qui recusandae. Dolorum sed sint. Quod quis! Et velit. Similique omnis.', '1984-09-01 11:26:29.260', '14735d5d-67ff-5dad-412b-e89ea5388e0b', '26c1e1f8-3a26-53fe-5876-66508ad02725', 2, NULL, '1992-04-22 13:53:41.880', N'30090', 0, N'35616')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('6e0dc48e-3eac-6143-9b66-a58ab8ff47ca', 93, '52399204-dd9b-485c-9ebc-78aa27d7e2e8', '37117dc9-69a0-3deb-2693-373516031d8e', N'wsxibxndfcmfsohpfsdxhvjkekxdqbxsuhddoukhealmilxtgxebyi', N'Hic corporis sit quia. Omnis ut. Magni mollitia. Debitis enim.', '1984-04-22 05:37:56.980', '1a591774-4565-7236-90c9-bcec0cd444f8', '284445b2-65be-4f66-422b-e89ea5388e0b', 2, 1, '2014-11-10 06:39:19.020', N'13550', 0, N'99399')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('3650c04e-62b1-6908-5598-ae38c5379e4b', 67, '1ba76857-e16f-4c22-a75f-e79e5722adba', '1897a8f1-37fc-5c9c-3809-69a9b1bfbc32', N'sprnzxciovlqrnxubachxtbdfznpaqdzsyjveovqlvmp', N'Unde sunt et nobis natus.', '2009-03-03 14:38:00.630', '7e919581-5fd4-1caf-5776-66508ad02725', '1259a17c-69e8-7a1c-da4b-16e575b61049', 1, NULL, '1989-04-22 01:30:17.050', N'80185', 0, N'82060')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('6827e1c0-5b98-6d19-831b-27d9d367aeb0', 81, '07ea1363-fd9d-4b15-ac3e-c98407443665', '167940ec-16a3-126a-d07e-e08e331d25c7', N'e', N'Reprehenderit illum enim quasi possimus...', '2013-12-21 12:40:16.260', '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', '61e25755-3de1-1adf-8fc9-bcec0cd444f8', 1, NULL, '1989-11-27 06:28:22.390', N'70235', 0, N'95270')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('1949dae3-4d44-217e-9c66-a58ab8ff47ca', 69, '8aa549ff-ee0f-445d-b539-7ca53116a737', '6ea4db4a-59e8-25fc-3d09-69a9b1bfbc32', N'zdcgzixzyyji', N'Voluptatum quos omnis. A sit. Consectetur et. Amet ut! Laboriosam molestiae.', '1984-05-05 17:49:25.510', '202cad24-4598-16cf-1a02-ce5da15ac776', '336d8f99-255d-646e-f0b6-6f4dd73eba9e', 1, NULL, '2010-02-28 21:26:37.160', N'25376', 1, N'75258')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('4958949d-17c9-454d-841b-27d9d367aeb0', 58, 'ac03d0b4-8060-4e8d-bef2-6b2382500dd0', '1752b8ca-19e4-4cd1-757d-18b43b6e1561', N'dovrbkxtkpyxnrmewqtwmybyyryiybmhlbxaopaznglwdfw', N'Fugiat et pariatur quia doloremque. Quo modi nemo.', '1971-05-11 12:54:00.680', '397bc919-4888-5ab2-402b-e89ea5388e0b', '336d8f99-255d-646e-f0b6-6f4dd73eba9e', 2, NULL, '2009-12-25 09:25:45.450', N'54030', 1, N'51197')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('47782bc9-1bf1-7c7b-6ee3-2ceaa9cf3765', 54, 'bc5546da-69fa-4590-8023-e49a9150dff3', '266b853c-29e7-2243-7b7d-18b43b6e1561', N'szctybjffziizwcpikhbnpeqjhezgtweedowenqudahdtqezgpnavrqcodkztliqmqdhcwccmjlwejszydd', N'Vitae error eos ut. Aut ea at dolorem. At minus!', '2008-01-19 00:11:34.690', '397bc919-4888-5ab2-402b-e89ea5388e0b', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', 1, NULL, '2007-07-20 15:15:53.280', N'58852', 1, N'96299')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('1242d680-4f02-3bbb-9d66-a58ab8ff47ca', 27, 'eeff9d97-f6d1-4318-9391-0a83f7fb9b46', '35b2aead-6784-4f96-d37e-e08e331d25c7', N'czxzkkzfypunpjmcbbqfwbmwhhnekyefzbcxkvynsfjruyjxxmwcxgipufqeknlodzrnupfckaxchefqmtnrmkfbcolzygadny', N'Est a. Doloribus sint itaque nam quia!', '1993-02-03 16:58:49.780', '699acaa2-66da-563a-1702-ce5da15ac776', '336d8f99-255d-646e-f0b6-6f4dd73eba9e', 1, NULL, '1979-03-22 13:34:47.000', N'26634', 1, N'26208')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('114b715b-430f-74cd-d5c6-21b180c0988f', 49, '0d0e2c4b-3bee-405a-a6b3-78dc4d4abb2c', '6b9b7137-3dd3-7b12-b733-62dd4e858bad', N'jxktunxurvbqwgstksywuhntkygxuiacokdzhfnlfnvzbhgvxiedulhqllugkkmgmajbavaicecjvyqxgiysbjgru', N'Et cumque sit dolorem id. Nostrum quam facilis saepe.', '2007-02-09 00:14:10.950', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '499200b3-46a5-60a7-f196-94965a4eaa62', 2, NULL, '2007-06-01 03:41:30.330', N'42721', 0, N'01467')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('234be17d-3820-7daa-5698-ae38c5379e4b', 82, '08a4bad6-f7b6-40ac-ab10-8a7f24ab536b', '5a851e09-4a52-7284-0648-b983316b8374', N'lsveyymusfexjsfenrqqxhctx', N'Nihil nesciunt amet ullam. Beatae recusandae veniam. Voluptatem quisquam.', '2002-12-15 04:01:15.610', '3f22df3a-3b15-3b5a-787e-3e3b283cabde', '69619ef2-1249-20fa-797e-3e3b283cabde', 1, 1, '2016-02-21 21:58:30.040', N'68440', 0, N'26840')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('3564d2c8-2839-5bf7-851b-27d9d367aeb0', 52, 'b747e6e7-817d-4b3c-8bd2-91481acb46a6', '24772a1a-2649-14d7-2393-373516031d8e', N'mzfhnjdtvjaaczabfbiaoclslabkwnthefyucjybudafjtkatjfamqtkduflfch', N'Repudiandae sed beatae molestiae consectetur. Omnis a! Mollitia nostrum. Et.', '2004-07-12 00:38:04.610', '3f22df3a-3b15-3b5a-787e-3e3b283cabde', '1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', 2, NULL, '1977-11-14 07:35:35.680', N'06826', 1, N'98265')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('7fa72f44-2825-2b26-d190-152dfadf6d0d', 30, 'cde5137c-6254-425e-9bc4-e6216658f4d5', '5c549d77-1e58-4d4e-1fbe-eaf7cc272319', N'futvfmgrxzyqbuivpnvidppxzgbxrgwqursquvpubkeffisgreidgyvcitrhlfxkmmwvuvgzlsacwnql', N'Quis odio voluptatem odit iste.', '1974-10-21 21:44:11.030', '5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', '228bfc03-38db-4741-f096-94965a4eaa62', 2, NULL, '1981-09-14 12:01:16.190', N'01752', 0, N'77381')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('26895d47-1420-68d0-9e66-a58ab8ff47ca', 21, '69d0c922-3eea-47fb-9c22-f9c50b2846df', '438f32b0-4d8e-4d3b-777d-18b43b6e1561', N'jacl', N'Sunt deleniti ipsum sequi doloribus. Enim tenetur! Dignissimos et? Est error!', '1974-08-13 16:06:38.510', '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', '336d8f99-255d-646e-f0b6-6f4dd73eba9e', 2, NULL, '2017-03-17 20:10:37.290', N'48208', 0, N'58730')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('23df2104-50d7-1d9c-eadb-93dede770727', 5, 'f601cfb6-93ed-4087-822a-6f2fed3eeb0a', '7f029887-6ee3-1cee-ba33-62dd4e858bad', N'kgfwovyisdomsjqhtcyvckzszfxfpgfzayzulcqgghrnjgbsmzdbewjbyzpfvnkaipuoulwu', N'Omnis ut nam magnam modi.', '1990-08-16 01:57:17.490', '5e306560-6b07-2cdf-5b76-66508ad02725', '1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', 2, NULL, '1986-10-26 09:23:41.300', N'91066', 0, N'80473')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('4c411322-7cb4-657d-6fe3-2ceaa9cf3765', 55, '639d2087-d6b5-4fd0-aefd-a572a4256ca3', '66af213e-6ed1-770c-5c32-9a0257d67b47', N'slmidjerkmnaijehoixjmbodmogjtbzpldfsnmgbocpupjelqklwtxmpmfntsfgfphmun', N'Sint numquam sed et consectetur. Et voluptatem molestias sint veritatis!', '1971-03-27 16:56:22.310', '1b3166b4-1301-5956-5a76-66508ad02725', '5ebb6116-1627-3f70-0602-eefebbd653b8', 1, NULL, '2002-03-03 11:58:45.240', N'73759', 1, N'94740')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('3800012e-758c-1328-861b-27d9d367aeb0', 64, 'a16b0742-af56-4167-b085-ea642223cf2f', '7646fdd5-2cad-6d80-3714-9ad3d3072fe3', N'xmuihbnnclkmqldnlzdsmqunbcuizinbdzuaezwaaioqlmajh', N'Est eos iusto rem. Unde a aut! Quae soluta. Et non.', '2000-04-22 23:43:19.860', '1259a17c-69e8-7a1c-da4b-16e575b61049', '1b3166b4-1301-5956-5a76-66508ad02725', 1, NULL, '1987-03-13 09:51:30.590', N'05933', 1, N'46957')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('4782d29d-4baf-7371-d290-152dfadf6d0d', 32, '052d72eb-46a2-47da-8773-e6737c247f55', '4a084a3f-5d99-1372-b433-62dd4e858bad', N'rp', N'Nesciunt inventore magnam vitae. Sed voluptatem! Sit nisi et nihil voluptates.', '2013-07-24 18:13:12.870', '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', '6f0fc907-5bf7-6e28-ef96-94965a4eaa62', 1, 2, '2002-05-04 03:19:16.330', N'56631', 1, N'49100')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('25a1ce30-4ae1-2133-9f66-a58ab8ff47ca', 74, 'e33864db-6b91-4017-a13c-53ed08e4ea5f', '1ff90f83-3580-7afb-7c7d-18b43b6e1561', N'rgahhxkqgtbwhwdpsghhqvbeorolpngldnac', N'Doloremque dolor illum repellat quia. Quis quae. Qui consequuntur. Voluptates.', '1995-02-10 19:26:03.410', '3f22df3a-3b15-3b5a-787e-3e3b283cabde', '1b3166b4-1301-5956-5a76-66508ad02725', 2, NULL, '1988-11-15 22:22:48.650', N'28477', 0, N'56780')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('2ed98b4b-4f60-6e40-5798-ae38c5379e4b', 18, '3abdc23d-93e0-4727-92ad-faf29216496d', '582165db-7775-1bec-2093-373516031d8e', N'ggfqhdwydtnfbrwpbdpnbwhaldthvbzfsourumrvhilzprryaasiooonmbcpjlfbzdxiagrrkstcgd', N'Et ut non. Voluptatem omnis ad nulla consequatur; fuga officiis.', '1977-02-28 17:08:36.430', '66a18612-296a-25b0-d94b-16e575b61049', '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', 1, NULL, '1971-12-27 17:08:25.890', N'25813', 1, N'42388')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('3d5b1131-38b5-2128-ebdb-93dede770727', 9, '700ab7dd-72ae-4f01-a7e2-1dbc341ed4c2', '42b2fa47-5255-25d8-767d-18b43b6e1561', N'gm', N'Consequatur iure provident commodi assumenda. Qui ipsa; consequuntur;', '1974-09-21 12:48:09.640', '5e306560-6b07-2cdf-5b76-66508ad02725', '336d8f99-255d-646e-f0b6-6f4dd73eba9e', 2, NULL, '2000-12-10 22:32:37.680', N'54518', 1, N'32802')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('193ee03f-15cd-70e7-bd7b-a3ff9b28ff75', 43, '48a33b35-5606-40c3-8b34-0ad2d2036874', '299b9de4-7744-56f2-6632-9a0257d67b47', N'mzxubhvjcsxvavgcvsiqbqvfadqfrlfrwsdrwwpdytoqdyjfbeptlesythdvwxzlcdzot', N'Facilis voluptates. Natus dolore aliquam vero iste. Aut voluptates facilis.', '1982-12-20 21:05:54.450', '26c1e1f8-3a26-53fe-5876-66508ad02725', '202cad24-4598-16cf-1a02-ce5da15ac776', 2, NULL, '1991-06-03 19:40:26.860', N'96555', 1, N'78560')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('3a0a7c7d-432b-6cf9-871b-27d9d367aeb0', 5, '3498d54b-e9b1-4e48-bf1f-27d107f281f1', '48ad7074-68bd-5fb1-3e09-69a9b1bfbc32', N'yvqqzxewcynonoinfdicjwjvtwxjloxigceggjrzbuthliuaytziovnpeccxoyfvdgyqlkspfqxulzurxqdaatxytguzfbi', N'Ut vitae voluptatum. Tempore et fugiat sit quia. Modi harum!', '1999-05-15 19:13:54.080', '61e25755-3de1-1adf-8fc9-bcec0cd444f8', '36ce1756-1d21-7373-f1b6-6f4dd73eba9e', 1, NULL, '2011-01-15 18:49:14.090', N'07607', 0, N'93799')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('6123f364-3fd4-3ffe-3e6b-1629b83affd2', 50, '9e85d735-6c53-4220-ad79-edf820cc7fed', '169b892d-4fb7-2a17-2193-373516031d8e', N'esbcorzjw', N'Explicabo numquam atque in corrupti...', '2002-08-15 06:03:13.760', '3a6dba26-6960-6953-d74b-16e575b61049', '5ebb6116-1627-3f70-0602-eefebbd653b8', 1, NULL, '2012-12-12 20:51:58.320', N'86989', 0, N'67709')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('4520aa7f-492a-3c02-a066-a58ab8ff47ca', 9, 'a9beeccc-6ff2-440f-a768-0f5d95f56f68', '44c1a769-7d71-2ee0-6232-9a0257d67b47', N'brcdgcceccbfihnicno', N'Tempore laboriosam unde dignissimos. Laboriosam nobis! Ab nam. Autem tempore.', '2017-03-17 14:40:22.870', '14735d5d-67ff-5dad-412b-e89ea5388e0b', '336d8f99-255d-646e-f0b6-6f4dd73eba9e', 2, 1, '1976-08-19 01:11:05.080', N'57077', 0, N'00541')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('75c44418-37aa-50bc-70e3-2ceaa9cf3765', 51, 'ba43961f-6903-4c1f-9f7c-2f9afd9c05a0', '4275edfc-7af9-7040-4d5f-1885b89fc8fc', NULL, N'Voluptatem est qui dicta eligendi.', '1978-06-26 11:05:32.940', '51d8cc33-7be1-161f-f396-94965a4eaa62', '1a591774-4565-7236-90c9-bcec0cd444f8', NULL, NULL, '1990-05-17 07:23:35.620', N'49037', 0, N'04826')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('45e44dc8-211f-27ef-881b-27d9d367aeb0', 37, '06897bea-4012-442a-a92b-5327ff546f37', '5c549d77-1e58-4d4e-1fbe-eaf7cc272319', N'kowztbreeryklzidpquzpuwkgdyavsdwbqnbivqmrvthhjwvfpwhijbrdjdityzbmhyfpvlzbmqaeboaink', N'Ad culpa asperiores unde error; quia vero. Ad in! Omnis ea. Quidem magnam...', '1987-03-08 03:57:37.010', '51d8cc33-7be1-161f-f396-94965a4eaa62', '7a311573-456f-56e3-0902-eefebbd653b8', 2, NULL, '2012-09-29 23:40:05.390', N'92422', 0, N'64495')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('42057b24-694d-4ae8-a166-a58ab8ff47ca', 74, '6caa35ef-d394-4a9f-b08f-e6848b41e96c', '78f21e91-5225-5a57-0d48-b983316b8374', N'fjjujgbgrmaafmxduimeknhx', N'Voluptatibus et. Excepturi dolorem dicta inventore ea.', '1971-02-15 02:01:34.870', '51d8cc33-7be1-161f-f396-94965a4eaa62', '336d8f99-255d-646e-f0b6-6f4dd73eba9e', 1, NULL, '1980-10-11 06:01:39.500', N'90287', 0, N'43231')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('7202aaab-47c8-2e5d-5898-ae38c5379e4b', 83, '37425433-0989-4271-a6fd-f32af5bf9b26', '1ff90f83-3580-7afb-7c7d-18b43b6e1561', N'grmyarvr', N'Labore fuga omnis ut reprehenderit. Aspernatur molestiae in rerum velit.', '2014-04-19 23:35:44.630', '69619ef2-1249-20fa-797e-3e3b283cabde', '7959e1dd-2e0b-4306-7a7e-3e3b283cabde', 2, NULL, '2003-10-25 07:16:34.340', N'88184', 1, N'57014')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('7d765e2c-410d-67ac-71e3-2ceaa9cf3765', 6, 'f1362210-ec04-4e4d-8675-353430c3af7f', '1c88c2a4-1aa1-1a3e-465f-1885b89fc8fc', N'uggplbwfgbygohawwrmnez', N'Velit aperiam ex voluptas. Vero assumenda esse rerum officia!', '2011-09-19 09:05:58.190', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', '7a311573-456f-56e3-0902-eefebbd653b8', 2, NULL, '1977-02-08 06:46:06.970', N'87437', 1, N'23395')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('7c3b7b80-7de9-412e-54b6-94da9cd298ec', 51, 'e0d56999-c9a7-4a1b-a995-77fc9e94aa04', '1752b8ca-19e4-4cd1-757d-18b43b6e1561', NULL, N'Dolore veniam. Quae voluptatem libero! Expedita sunt. Est ratione. Ut!', '1978-11-28 17:52:32.940', '5e306560-6b07-2cdf-5b76-66508ad02725', '336d8f99-255d-646e-f0b6-6f4dd73eba9e', NULL, NULL, '1977-02-03 18:06:50.060', N'19425', 0, N'67824')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('4ba825b4-6631-78d1-5998-ae38c5379e4b', 86, '494a13dc-f5b2-4559-b753-28c84173b0e7', '1897a8f1-37fc-5c9c-3809-69a9b1bfbc32', N'akokuslxrdojbniystdigghnmbsbhlzjgqriyijprttzvyxstmfyncvwauvthylcutdyrvzyjclvprmokoadmbltcvikafcfyv', N'Est omnis est rerum pariatur.', '1989-09-04 01:48:07.420', '1259a17c-69e8-7a1c-da4b-16e575b61049', '5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', 2, NULL, '2014-10-26 00:47:46.030', N'89303', 1, N'91575')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('357ec50e-37ed-43fc-d6c6-21b180c0988f', 64, 'c7554c3e-056a-4577-971d-365aadc15a05', '4a084a3f-5d99-1372-b433-62dd4e858bad', N'zdemclsuspjwkmsylzeaijbonnrhfivvpncqflmseejyaiyvwfnimxpdxyddudgnzfexaigifecivhda', N'Ipsam harum eum. Assumenda illo maxime aperiam beatae!', '1985-05-21 00:24:07.760', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', '36460dcf-323b-1391-8ec9-bcec0cd444f8', 1, NULL, '2015-04-29 09:26:08.000', N'45302', 1, N'19834')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('399fc05a-6ef7-1a2d-3f6b-1629b83affd2', 89, '3b66ff7e-6a63-409c-9e21-59c420260ba5', '384e5dfc-5836-3fa0-b933-62dd4e858bad', N'jkauiprfqhtxhhiocjbf', N'Officia totam dolorem dolor. Est commodi; rerum ut. Itaque sapiente;', '1992-09-02 21:25:01.710', '1259a17c-69e8-7a1c-da4b-16e575b61049', '6c4c1f9b-1644-2620-5976-66508ad02725', 2, NULL, '2015-01-19 23:43:28.320', N'23214', 1, N'64092')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('54878d33-29de-72c5-891b-27d9d367aeb0', 36, 'f0f25486-f0e2-4c0a-99d3-068508d13eaf', '42b2fa47-5255-25d8-767d-18b43b6e1561', N'zefzwhgngiamdyeeapijyozmivthcarmhewvhorqwrkehpfgzt', N'Quos consequuntur fuga labore ut. Fugit voluptatem? Sit provident. Vel.', '2002-11-19 13:39:44.470', '669afd3f-720a-6e34-1902-ce5da15ac776', '244bd1b5-7428-4b87-0702-eefebbd653b8', 1, NULL, '2014-07-20 02:24:42.500', N'51343', 1, N'83794')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('7310a7ce-72fc-6d87-55b6-94da9cd298ec', 17, '951faee9-8883-4aef-8cb2-11aac0a245e0', '1ff90f83-3580-7afb-7c7d-18b43b6e1561', N'wdfgweoflmrfecnkiaggtmzvcaoo', N'Et sit aliquid quae. Nihil deleniti est et. Ipsam molestias.', '2013-10-02 14:40:36.010', '1259a17c-69e8-7a1c-da4b-16e575b61049', '751604f5-1e51-6d47-3f2b-e89ea5388e0b', 1, NULL, '1977-11-18 08:40:23.770', N'75699', 1, N'23155')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('34d489e2-6add-5426-d390-152dfadf6d0d', 28, '536199bf-9119-4659-a22b-783d05d4c715', '2643c0f2-5381-7a86-1d93-373516031d8e', N'lgvyikhlfyizuwqjaqkhizxmrstez', N'Consequatur minus illum consequuntur porro. Harum aut.', '1980-09-16 05:57:38.710', '58fc185f-1925-3117-334d-4c0f86f26090', '669afd3f-720a-6e34-1902-ce5da15ac776', 2, NULL, '1994-09-29 05:11:26.190', N'30971', 1, N'03038')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('5499db4b-17be-2f25-72e3-2ceaa9cf3765', 3, '60219579-cc7b-44c3-a5cb-4dca47a93b9e', '266b853c-29e7-2243-7b7d-18b43b6e1561', N'dcoqudiojhviaaykxy', N'Ut dolorem nisi ab repudiandae. Voluptatem eum. Qui sit. Nihil nostrum...', '1986-11-14 17:57:14.140', '7959e1dd-2e0b-4306-7a7e-3e3b283cabde', '5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', 1, 1, '1982-05-27 03:45:59.930', N'50730', 1, N'60007')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('7f333d8e-5137-568f-be7b-a3ff9b28ff75', 18, 'd831594d-d145-40b4-87b4-2a3a7b62a6cd', '5126a884-72e7-76eb-3909-69a9b1bfbc32', N'srizpyfttswceyiugrqagepsinccefggtdbvgiro', N'Error dolorem. Vitae dolor perspiciatis sint et.', '1993-07-28 19:28:57.060', '1257615f-5ea8-6cd9-0b02-eefebbd653b8', '1a361dba-2edd-6ebd-324d-4c0f86f26090', 2, NULL, '1979-03-10 10:48:54.220', N'06712', 1, N'80202')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('3e34c4f2-3a6c-62c5-a266-a58ab8ff47ca', 63, 'c6132b41-dd99-49e3-808e-4436be30c485', '5c549d77-1e58-4d4e-1fbe-eaf7cc272319', N'fkdjikjtuiiycpyobtpmmeteptnkuzwzurtrfsmhgrs', N'Maiores soluta. Blanditiis voluptatem suscipit ab atque.', '2001-06-07 13:10:10.020', '5e306560-6b07-2cdf-5b76-66508ad02725', '51d8cc33-7be1-161f-f396-94965a4eaa62', 1, NULL, '2017-06-18 16:13:07.770', N'54828', 0, N'86963')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('6ff002a7-47b1-79ff-8a1b-27d9d367aeb0', 9, '2450c83a-ce38-4748-b056-f92670410ec4', '5224197a-4d23-7fee-24be-eaf7cc272319', N'ogiefvweoibatopahrwlsithiolmkvuiicbeectsahjlk', N'Molestiae sint possimus. Mollitia unde voluptas qui. Vero officiis natus.', '1998-12-04 13:02:09.480', '58fc185f-1925-3117-334d-4c0f86f26090', '397bc919-4888-5ab2-402b-e89ea5388e0b', 1, NULL, '1970-03-02 08:13:41.560', N'75541', 1, N'16897')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('67cb2614-27d9-36f4-406b-1629b83affd2', 45, 'b994305a-4e7d-4309-baae-2db3da972bed', '42b2fa47-5255-25d8-767d-18b43b6e1561', N'ywmqnlwajahenanihsknefxmgykvoe', N'Recusandae iusto. Quasi illum repudiandae! Fugiat aut. Voluptatum sed! Quia.', '1985-08-20 11:26:33.820', '36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', '1e3453a2-3ef5-5f70-8dc9-bcec0cd444f8', 2, NULL, '2008-09-07 21:17:22.350', N'64166', 1, N'78934')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('32eb6bd6-6c74-4c19-d7c6-21b180c0988f', 86, '6d3c6db4-2e14-4c8b-b5c3-50c9c1ae2a5b', '5dd3992f-743a-77ef-d57e-e08e331d25c7', N'gpbsfhliashnkxcenelxacblnygcoxittdygzgjjtsukhpiaev', N'Quisquam porro suscipit enim. Consequatur quod quaerat veniam inventore.', '2012-09-03 17:45:02.140', '36460dcf-323b-1391-8ec9-bcec0cd444f8', '58fc185f-1925-3117-334d-4c0f86f26090', 1, NULL, '2017-10-27 15:45:59.440', N'75446', 0, N'10303')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('3198e88a-43ba-6e4f-a366-a58ab8ff47ca', 50, 'cdca2762-818e-408a-9e57-08c515c2d87e', '3778fd78-672b-358c-5e32-9a0257d67b47', N'zqbblcpbyxbesvjwgpedkmwjjntilxwbzuisn', N'Dolores sunt error est dicta.', '2012-04-21 20:42:27.660', '5aa02579-73ed-23cd-314d-4c0f86f26090', '669afd3f-720a-6e34-1902-ce5da15ac776', 1, NULL, '1979-09-22 04:23:22.060', N'82415', 1, N'37905')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('446c9f77-34e0-2453-8b1b-27d9d367aeb0', 4, '4dc5f40c-206b-4754-9336-1431dda54072', '617b71b5-3b9d-7c86-495f-1885b89fc8fc', N'jfblpvdbulakrezbgtjrfjhqlsvjmebyvgmszilfamuvcupytrkqwkxpyi', N'Non in sapiente voluptatum. Libero beatae omnis sit. Error eaque.', '1992-05-14 10:57:36.610', '4f7021f5-7800-11be-0a02-eefebbd653b8', '2dc6dc0b-307b-3bde-5c76-66508ad02725', 1, NULL, '1977-09-23 20:41:27.010', N'17667', 1, N'50330')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('5735931e-471e-4e0a-a466-a58ab8ff47ca', 76, 'a3228980-1fd3-4570-868b-b3911492664e', '68eb14f2-6c91-72a0-26be-eaf7cc272319', N'tadirwuekthplcomeciidwbjoberihpcjrbjlvbvgqiisecjthrfbndfyqmwgfzbcwwiroerjfychrprxivogmemu', N'Architecto dolorum sunt. Voluptatem vel. Fuga at; reprehenderit omnis; minus.', '1972-07-04 11:13:07.380', '24fee4c1-709c-79d6-1802-ce5da15ac776', '2f1172a9-1b5d-6fc4-777e-3e3b283cabde', 1, NULL, '2018-02-19 03:55:46.940', N'82506', 0, N'48924')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('74ceacc3-3385-445b-5a98-ae38c5379e4b', 86, 'eeff9d97-f6d1-4318-9391-0a83f7fb9b46', '2643c0f2-5381-7a86-1d93-373516031d8e', N'gierwxplszcrwdyeooekphercexihqbrhhtpnrcxcgzorxpquk', N'Minima dolorem quae. Fugit officia facilis! Perspiciatis beatae consectetur.', '1991-06-02 12:02:39.260', '397bc919-4888-5ab2-402b-e89ea5388e0b', '4f7021f5-7800-11be-0a02-eefebbd653b8', 2, NULL, '2005-12-18 23:55:53.170', N'27014', 0, N'35119')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('24b8283e-35c3-4fc4-73e3-2ceaa9cf3765', 4, '700ab7dd-72ae-4f01-a7e2-1dbc341ed4c2', '582165db-7775-1bec-2093-373516031d8e', N'qyyniahdilitfjzrdfxdjdzyklyzzqlfymwstjmuewquuhmjk', N'Quisquam sit et. Nisi unde quia! Qui aspernatur et consequuntur aut. Voluptas.', '1975-02-25 03:10:28.430', '5984fdaa-1e0e-68c7-3e2b-e89ea5388e0b', '4f7021f5-7800-11be-0a02-eefebbd653b8', 1, NULL, '1991-11-25 22:50:39.960', N'36971', 0, N'11015')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('592d4ad8-3675-2016-ecdb-93dede770727', 59, 'b747e6e7-817d-4b3c-8bd2-91481acb46a6', '71ef4cd8-7f35-5b59-4a5f-1885b89fc8fc', NULL, N'Quae voluptatem quia voluptatem aut. Quis nesciunt nisi molestiae!', '1996-04-11 02:43:46.640', '36460dcf-323b-1391-8ec9-bcec0cd444f8', '51d8cc33-7be1-161f-f396-94965a4eaa62', NULL, NULL, '1983-07-29 19:32:00.710', N'09807', 1, N'03296')
  INSERT dbo.Payment(Oid, Amount, Category, Project, Justification, Comment, Date, Payer, Payee, OptimisticLockField, GCRecord, CreateDate, CheckNumber, IsAuthorized, Number) VALUES ('6462f381-27bb-2826-d490-152dfadf6d0d', 63, 'ba43961f-6903-4c1f-9f7c-2f9afd9c05a0', '41e622cb-637c-2a70-d67e-e08e331d25c7', NULL, N'Incidunt sint repellat quasi voluptatibus. Nesciunt quas! Odio quo;', '1992-04-04 18:19:14.050', '24fee4c1-709c-79d6-1802-ce5da15ac776', '5e306560-6b07-2cdf-5b76-66508ad02725', NULL, NULL, '1989-02-08 11:18:39.470', N'50590', 0, N'56518')
  GO
  
  --
  -- Inserting data into table dbo.Supplier
  --
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('202cad24-4598-16cf-1a02-ce5da15ac776', N'Ambrose Handy', 0, 1, 0)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('36a4260a-7f6c-2ec6-f2b6-6f4dd73eba9e', N'Roxann Perrin', 1, 1, 0)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('36ce1756-1d21-7373-f1b6-6f4dd73eba9e', N'Dave Tabor', 1, 0, 1)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('2f1172a9-1b5d-6fc4-777e-3e3b283cabde', N'Leonardo Adair', 0, 1, 0)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('3a6dba26-6960-6953-d74b-16e575b61049', N'Aurelio Sample', 1, 0, 1)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('1257615f-5ea8-6cd9-0b02-eefebbd653b8', N'Manual Nadeau', 1, 1, 0)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('2dc6dc0b-307b-3bde-5c76-66508ad02725', N'Katina Abel', 1, 0, 1)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('5f00c41b-39dc-51ee-0802-eefebbd653b8', N'Frances Abney', 0, 1, 0)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('284445b2-65be-4f66-422b-e89ea5388e0b', N'Abraham Pfeiffer', 1, 1, 0)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('26c1e1f8-3a26-53fe-5876-66508ad02725', N'Beatrice Medlock', 1, 0, 1)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('58fc185f-1925-3117-334d-4c0f86f26090', N'Demetrius Brinkley', 0, 1, 0)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('36460dcf-323b-1391-8ec9-bcec0cd444f8', N'Dawn Rivers', 0, 0, 1)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('336d8f99-255d-646e-f0b6-6f4dd73eba9e', N'Larita Hammett', 0, 0, 1)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('481c748b-2a85-2a28-efb6-6f4dd73eba9e', N'Elvin Lytle', 1, 0, 1)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('37e456ed-14a3-6717-f3b6-6f4dd73eba9e', N'Scottie Hodge', 1, 1, 0)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('51d8cc33-7be1-161f-f396-94965a4eaa62', N'Adan Cline', 0, 1, 0)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('1b3166b4-1301-5956-5a76-66508ad02725', N'Sadie Obrien', 1, 0, 1)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('5e306560-6b07-2cdf-5b76-66508ad02725', N'Dewitt Alvarado', 1, 1, 0)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('69619ef2-1249-20fa-797e-3e3b283cabde', N'Karan Ackerman', 1, 1, 0)
  INSERT dbo.Supplier(Oid, Contact, ProfitByMaterialAsPayer, ProfitByMaterialAsPayee, CostByMaterialAsPayer) VALUES ('1a591774-4565-7236-90c9-bcec0cd444f8', N'Shonda Alicea', 0, 1, 0)
  GO
  
  --
  -- Creating indexes and constraints for dbo.PaymentParticipant
  --
  CREATE INDEX iObjectType_PaymentParticipant
    ON PaymentData.dbo.PaymentParticipant (ObjectType)
    ON [PRIMARY]
  GO
  CREATE INDEX iGCRecord_PaymentParticipant
    ON PaymentData.dbo.PaymentParticipant (GCRecord)
    ON [PRIMARY]
  GO
  
  --
  -- Creating indexes and constraints for dbo.Employee
  --
  CREATE INDEX iHead_Employee
    ON PaymentData.dbo.Employee (Head)
    ON [PRIMARY]
  GO
  
  --
  -- Creating indexes and constraints for dbo.Project
  --
  CREATE INDEX iManager_Project
    ON PaymentData.dbo.Project (Manager)
    ON [PRIMARY]
  GO
  CREATE INDEX iGCRecord_Project
    ON PaymentData.dbo.Project (GCRecord)
    ON [PRIMARY]
  GO
  CREATE INDEX iForeman_Project
    ON PaymentData.dbo.Project (Foreman)
    ON [PRIMARY]
  GO
  CREATE INDEX iClient_Project
    ON PaymentData.dbo.Project (Client)
    ON [PRIMARY]
  GO
  
  --
  -- Creating indexes and constraints for dbo.Bank
  --
  ALTER TABLE dbo.Bank WITH NOCHECK
    ADD CONSTRAINT PK_Bank PRIMARY KEY CLUSTERED (Oid)
  GO
  CREATE INDEX iAccountType_Bank
    ON PaymentData.dbo.Bank (AccountType)
    ON [PRIMARY]
  GO
  
  --
  -- Creating indexes and constraints for dbo.Cashbox
  --
  ALTER TABLE dbo.Cashbox WITH NOCHECK
    ADD CONSTRAINT PK_Cashbox PRIMARY KEY CLUSTERED (Oid)
  GO
  CREATE INDEX iAccountType_Cashbox
    ON PaymentData.dbo.Cashbox (AccountType)
    ON [PRIMARY]
  GO
  
  --
  -- Creating indexes and constraints for dbo.Payment
  --
  ALTER TABLE dbo.Payment WITH NOCHECK
    ADD CONSTRAINT PK_Payment PRIMARY KEY CLUSTERED (Oid)
  GO
  CREATE INDEX iProject_Payment
    ON PaymentData.dbo.Payment (Project)
    ON [PRIMARY]
  GO
  CREATE INDEX iPayer_Payment
    ON PaymentData.dbo.Payment (Payer)
    ON [PRIMARY]
  GO
  CREATE INDEX iPayee_Payment
    ON PaymentData.dbo.Payment (Payee)
    ON [PRIMARY]
  GO
  CREATE INDEX iGCRecord_Payment
    ON PaymentData.dbo.Payment (GCRecord)
    ON [PRIMARY]
  GO
  CREATE INDEX iCategory_Payment
    ON PaymentData.dbo.Payment (Category)
    ON [PRIMARY]
  GO
  
  --
  -- Creating constraints for dbo.Client
  --
  ALTER TABLE dbo.Client WITH NOCHECK
    ADD CONSTRAINT FK_Client_Oid FOREIGN KEY (Oid) REFERENCES dbo.PaymentParticipant(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  GO
  
  --
  -- Creating constraints for dbo.Employee
  --
  ALTER TABLE dbo.Employee WITH NOCHECK
    ADD CONSTRAINT FK_Employee_Head FOREIGN KEY (Head) REFERENCES dbo.Employee(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  ALTER TABLE dbo.Employee WITH NOCHECK
    ADD CONSTRAINT FK_Employee_Oid FOREIGN KEY (Oid) REFERENCES dbo.PaymentParticipant(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  GO
  
  --
  -- Creating constraints for dbo.Project
  --
  ALTER TABLE dbo.Project WITH NOCHECK
    ADD CONSTRAINT FK_Project_Client FOREIGN KEY (Client) REFERENCES dbo.Client(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  ALTER TABLE dbo.Project WITH NOCHECK
    ADD CONSTRAINT FK_Project_Foreman FOREIGN KEY (Foreman) REFERENCES dbo.Employee(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  ALTER TABLE dbo.Project WITH NOCHECK
    ADD CONSTRAINT FK_Project_Manager FOREIGN KEY (Manager) REFERENCES dbo.Employee(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  GO
  
  --
  -- Creating constraints for dbo.Bank
  --
  ALTER TABLE dbo.Bank WITH NOCHECK
    ADD CONSTRAINT FK_Bank_AccountType FOREIGN KEY (AccountType) REFERENCES dbo.AccountType(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  ALTER TABLE dbo.Bank WITH NOCHECK
    ADD CONSTRAINT FK_Bank_Oid FOREIGN KEY (Oid) REFERENCES dbo.PaymentParticipant(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  GO
  
  --
  -- Creating constraints for dbo.Cashbox
  --
  ALTER TABLE dbo.Cashbox WITH NOCHECK
    ADD CONSTRAINT FK_Cashbox_AccountType FOREIGN KEY (AccountType) REFERENCES dbo.AccountType(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  ALTER TABLE dbo.Cashbox WITH NOCHECK
    ADD CONSTRAINT FK_Cashbox_Oid FOREIGN KEY (Oid) REFERENCES dbo.PaymentParticipant(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  GO
  
  --
  -- Creating constraints for dbo.Payment
  --
  ALTER TABLE dbo.Payment WITH NOCHECK
    ADD CONSTRAINT FK_Payment_Category FOREIGN KEY (Category) REFERENCES dbo.PaymentCategory(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  ALTER TABLE dbo.Payment WITH NOCHECK
    ADD CONSTRAINT FK_Payment_Payee FOREIGN KEY (Payee) REFERENCES dbo.PaymentParticipant(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  ALTER TABLE dbo.Payment WITH NOCHECK
    ADD CONSTRAINT FK_Payment_Payer FOREIGN KEY (Payer) REFERENCES dbo.PaymentParticipant(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  ALTER TABLE dbo.Payment WITH NOCHECK
    ADD CONSTRAINT FK_Payment_Project FOREIGN KEY (Project) REFERENCES dbo.Project(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  GO
  
  --
  -- Creating constraints for dbo.Supplier
  --
  ALTER TABLE dbo.Supplier WITH NOCHECK
    ADD CONSTRAINT FK_Supplier_Oid FOREIGN KEY (Oid) REFERENCES dbo.PaymentParticipant(Oid) ON DELETE NO ACTION ON UPDATE NO ACTION NOT FOR REPLICATION
  GO
  
  --
  -- Enabling DML triggers for dbo.PaymentParticipant
  --
  ENABLE TRIGGER ALL ON dbo.PaymentParticipant
  GO
  
  --
  -- Enabling DML triggers for dbo.Project
  --
  ENABLE TRIGGER ALL ON dbo.Project
  GO
  
  --
  -- Enabling DML triggers for dbo.Payment
  --
  ENABLE TRIGGER ALL ON dbo.Payment
  GO
  
  --
  -- Set NOEXEC to off
  --
  
  SET NOEXEC OFF
  GO