Print 'Doing pre run Checks to ensure script not already run'; Select * from Script_History where Script_Name='ReleaseJuly2024Week2'; if @@ROWCOUNT!=0 BEGIN RAISERROR('THIS SCRIPT HAS ALREADY BEEN RUN ON THIS SERVER, CANNOT CONTINUE, PLEASE CONTACT DEV',11,1); RETURN; END GO IF (SELECT COUNT(0) FROM System_Function WHERE Function_Key_Word = 'AllowEWallet') = 0 insert into System_Function (Description,Tool_Tip_Text,Allow_Check_List,Requires_Authentification,Function_Key_Word,RightSet,IsMenuBased) values ('Allow EWallet buyshop','None',0,1,'AllowEWallet',1,0) GO IF (SELECT COUNT(0) FROM System_Function_Profile WHERE System_Function_ID = (select top 1 System_Function_id from System_Function where Function_Key_Word = 'AllowEwallet')) = 0 insert into System_Function_Profile (Profile_ID,System_Function_ID,Right_Type_ID) values (1,(select top 1 System_Function_id from System_Function where Function_Key_Word = 'AllowEwallet'),5); insert into System_Function_Profile (Profile_ID,System_Function_ID,Right_Type_ID) values (2, (select top 1 System_Function_id from System_Function where Function_Key_Word = 'AllowEwallet'), 5); insert into System_Function_Profile (Profile_ID,System_Function_ID,Right_Type_ID) values (3, (select top 1 System_Function_id from System_Function where Function_Key_Word = 'AllowEwallet'),5); GO SET IDENTITY_INSERT Payment_Method ON IF (SELECT COUNT(0) FROM Payment_Method WHERE Description = 'EWallet') = 0 insert into Payment_Method (Payment_Method_ID,Description) values (5,'EWallet'); GO SET IDENTITY_INSERT Payment_Method OFF SET IDENTITY_INSERT Cash_Up_Category ON IF (SELECT COUNT(0) FROM Cash_Up_Category WHERE Description = 'Outright Buy EWallet') = 0 insert into Cash_Up_Category (Cash_Up_Category_ID,Description,Cash_Up_Group_ID) values (47, 'Outright Buy EWallet',4); Go if (SELECT COUNT(0) FROM Cash_Up_Category WHERE Description = 'House Buy EWallet') = 0 insert into Cash_Up_Category (Cash_Up_Category_ID,Description,Cash_Up_Group_ID) values (48, 'House Buy EWallet',4); Go if (SELECT COUNT(0) FROM Cash_Up_Category WHERE Description = 'SSB EWallet') = 0 insert into Cash_Up_Category (Cash_Up_Category_ID,Description,Cash_Up_Group_ID) values (49, 'SSB EWallet',4); Go if (SELECT COUNT(0) FROM Cash_Up_Category WHERE Description = 'Consignment Buy EWallet') = 0 insert into Cash_Up_Category (Cash_Up_Category_ID,Description,Cash_Up_Group_ID) values (50, 'Consignment Buy EWallet',4); Go SET IDENTITY_INSERT Cash_Up_Category OFF GO if (SELECT COUNT(0) FROM SystemSetting WHERE SettingKey = 'BuyshopEWallet') = 0 insert into SystemSetting (SettingKey, SettingCategoryId, SettingValueBit,TypeFlag) values ('BuyshopEWallet',1,0,4) Go if (SELECT COUNT(0) FROM System_User_function WHERE System_Function_ID = (select top 1 System_Function_id from System_Function where Function_Key_Word = 'AllowEwallet')) = 0 insert into System_User_function (System_User_ID,System_Function_ID,Right_Type_ID,Store_ID) select system_user_id,(select top 1 System_Function_id from System_Function where Function_Key_Word = 'AllowEwallet'), 5,1 from [System_User] where Locked = 0 and System_User_ID in (select System_User_ID from System_User_Profile where Profile_ID in (1,2,3)); Go /****** Object: StoredProcedure [dbo].[spGetSSBInitFees] Script Date: 04 Jan 2024 07:42:09 ******/ DROP PROCEDURE [dbo].[spGetSSBInitFees] GO /****** Object: StoredProcedure [dbo].[spGetSSBInitFees] Script Date: 04 Jan 2024 07:42:09 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[spGetSSBInitFees] @cashierSessionId bigint AS BEGIN SET NOCOUNT ON; SELECT a.AmountPaid, a.Payment_Method_ID AS PaymentMethodType, a.Payment_Method_ID AS PaymentMethod FROM (SELECT ISNULL(SUM(sp.Amount_Paid), 0) AS AmountPaid, bt.Buyshop_Transaction_ID, bt.Payment_Method_ID FROM SSB_Payment sp INNER JOIN ssb sb ON sb.SSB_ID = sp.SSB_ID INNER JOIN Buyshop_Trans_SSB bts ON bts.SSB_ID = sb.SSB_ID INNER JOIN Buyshop_Transaction bt ON bt.Buyshop_Transaction_ID = bts.Buyshop_Transaction_ID INNER JOIN Cashier_Session cs ON cs.Cashier_Session_ID = sp.Cashier_Session_ID WHERE sp.SSB_Payment_Type_ID = 2 AND -- Initiation Fee bt.Payment_Method_ID IN (1, 4, 5) AND -- EFT/Cash/EWallet cs.Cashier_Session_ID = @cashierSessionId GROUP BY bt.Buyshop_Transaction_ID, bt.Payment_Method_ID) a END GO IF COL_LENGTH('cmr_supplementary', 'ReconBuyshopEWallet') IS NULL BEGIN alter table cmr_supplementary add ReconBuyshopEWallet decimal (18,2); END GO IF OBJECT_ID('AdditionalServiceItem', 'U') IS NULL BEGIN CREATE TABLE [dbo].AdditionalServiceItem( AdditionalServiceItemId [bigint] IDENTITY(1,1) NOT NULL, Barcode [varchar](250) NOT NULL, Product [varchar](250) NOT NULL, Description [varchar](250) NOT NULL, Price [decimal](8, 2) NULL default 0, [IsActive] [bit] NOT NULL default 1, CONSTRAINT PK_AdditionalServiceItem PRIMARY KEY CLUSTERED( AdditionalServiceItemId ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009900416861', '1Voucher Own Amount','1Voucher Own Amount',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419678', 'DSTV','DSTV',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419692', 'Ecocash','Ecocash',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419630', 'eeziAirtime Top Up','eeziAirtime Top Up',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419715', 'eeziPower','eeziPower',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419708', 'Electricity','Electricity',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500132', 'Flash Payments','Flash Payments',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419647', 'Flash Voucher Top Up','Flash Voucher Top Up',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124619 ', 'Global Airtime','Global Airtime',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500200', 'Global Data','Global Data',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500835', 'Global Electricity','Global Electricity',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419661', 'Lotto','Lotto',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124978 ', 'Mama Money','Mama Money Own Amount',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077563', 'Mukuru','R330 - R40000',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077532', 'Netflix','R250 - R1000',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419685', 'Pay with Flash','Pay with Flash',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009900416854', 'Pay@','Pay@',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124985 ', 'PayCity','PayCity Own Amount',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419753', 'Pinless Airtime','Cell C',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419746', 'Pinless Airtime','MTN',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419760', 'Pinless Airtime','Telkom Mobile',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717340', 'Pinless Airtime','Virgin Mobile',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419777', 'Pinless Airtime','Vodacom',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721764', 'Roblox Gift Card ZA','Roblox Gift Card ZA',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419739', 'Send Flash','Send Flash',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124992 ', 'Tenacity','Tenacity Own Amount',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720149', 'Uber','Uber own amount',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720347', 'Uber Eats','Uber Eats own amount',0); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419920', 'eeziAirtime Voucher',' R2',2); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077709', 'MTN Airtime Voucher','R2',2); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722327', 'MTN Data Top Up','R2 (50MB Whatsapp Daily)',2); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722204', 'MTN Data Voucher','R2 (50MB Whatsapp Daily)',2); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720088', 'MTN Voice Voucher','R2 (Daily 10 Min On-Net Voice)',2); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077716', 'Vodacom Airtime Voucher','R2',2); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721306', 'eeziAirtime Voucher','R3',3); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721443', 'MTN Data Top Up','R3 (30MB Hourly)',3); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721542', 'MTN Data Voucher','R3 (30MB Hourly)',3); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500101', 'MTN Voice Voucher','R3 (Daily 5 Min All-Net Voice)',3); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500972', 'Vodacom Data Top Up','R3 (50MB WhatsApp 1 day)',3); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720422', 'Vodacom Data Voucher','R3 (50MB WhatsApp 1 day)',3); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720460', 'Cell C Data Voucher','R4.99 (30MB Daily)',4.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722334', 'MTN Data Top Up','R4.99 (150MB Whatsapp 3 Day)',4.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722211', 'MTN Data Voucher','R4.99 (150MB Whatsapp 3 Day)',4.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720699', 'Telkom Data Voucher','R4.99 (150MB WhatsApp Daily)',4.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720439', 'Vodacom Data Voucher','R4.99 (250MB WhatsApp 1 day)',4.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009900416878', '1Voucher','R5',5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717821', 'Cell C Airtime Voucher','R5',5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124152 ', 'Cell C Data Top Up','R5(All-In-One Bundle 30MB)',5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124190 ', 'Cell C Data Voucher','R5(All-In-One Bundle 30MB)',5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717760', 'eeziAirtime Voucher','R5',5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717968', 'MTN Airtime Voucher','R5',5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077792', 'MTN Data Top Up','R5 (30MB Daily)',5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077884', 'MTN Data Voucher','R5 (30MB Daily)',5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500095', 'MTN Voice Voucher','R5 (Daily 10 Min All-Net Voice)',5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717920', 'Telkom Airtime Voucher','R5',5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717876', 'Vodacom Airtime Voucher','R5',5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419982', 'Vodacom Data Voucher','R5 (50MB Power Hour)',5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720118', 'Cell C Data Voucher','R5.01 (250MB Facebook Daily)',5.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722228', 'MTN Data Voucher','R5.01 (250MB Whatsapp Daily)',5.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500088', 'MTN Voice Voucher','R5.01 (Daily 55 Min On-Net Voice)',5.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720705', 'Telkom Data Voucher','R5.01 (50MB Weekly)',5.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722341', 'MTN Data Top Up','R5.02 (200MB Facebook Daily)',5.02); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722235', 'MTN Data Voucher','R5.02 (200MB Facebook Daily)',5.02); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721207', 'FIFA Points 50 ZAF','R5.99',5.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722587', 'MTN Data Top Up','R6 (120MB Hourly)',6); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722594', 'MTN Data Voucher','R6 (120MB Hourly)',6); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500989', 'Vodacom Data Top Up','R6 (100MB WhatsApp 3 days)',6); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720446', 'Vodacom Data Voucher','R6 (100MB WhatsApp 3 days)',6); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722440', 'MTN Data Voucher','R7 (250MB Facebook & Instagram Daily) ',7); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500118', 'MTN Voice Voucher','R7 (Daily 15 Min All-Net Voice)',7); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124770 ', 'Telkom Data Top Up','R7 (35MB + 35MB)',7); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124732 ', 'Telkom Data Voucher','R7 (35MB + 35 MB) ',7); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721900', 'EA-40 FC POINTS ZAF','R7.99',7.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721115', 'Cell C Data Voucher','R8.99 (500MB TikTok Daily)',8.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720101', 'Cell C Data Top Up','R9 (500MB Facebook Daily)',9); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721122', 'Cell C Data Voucher','R9 (500MB Facebook Daily)',9); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077952', 'Vodacom Data Top Up','R9 (60MB Daily)',9); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124886 ', 'Vodacom Data Voucher','R9 (60MB Daily)',9); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721139', 'Cell C Data Voucher','R9.98 (350MB Facebook Weekly)',9.98); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722525', 'MTN Data Top Up','R9.98 (60MB Weekly )',9.98); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722457', 'MTN Data Voucher','R9.98 (60MB Weekly)',9.98); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720477', 'Cell C Data Voucher','R9.99 (80MB Daily)',9.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721702', 'MTN Data Voucher','R9.99 (300MB Social Pass Daily)',9.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009900416885', '1Voucher','R10',10); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717838', 'Cell C Airtime Voucher','R10',10); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124480 ', 'Cell C Data Top Up','R10 (WhatsApp 300MB 3 Days)',10); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124510 ', 'Cell C Data Voucher','R10 (WhatsApp 300MB 3 Days)',10); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717777', 'eeziAirtime Voucher','R10',10); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717975', 'MTN Airtime Voucher','R10',10); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722358', 'MTN Data Top Up','R10 (300MB Whatsapp Weekly)',10); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722242', 'MTN Data Voucher','R10 (300MB Whatsapp Weekly)',10); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717937', 'Telkom Airtime Voucher','R10',10); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720897', 'Telkom Data Top Up','R10 (150MB Daily)',10); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720903', 'Telkom Data Voucher','R10 (150MB Daily)',10); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419784', 'Vodacom Airtime Voucher',' R10',10); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419111', 'Worldcall Airtime Voucher','R10',10); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124626 ', 'Cell C Data Voucher','R10.01 (60MB 7 Days)',10.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720958', 'MTN Data Top Up','R10.01 (100MB Daily)',10.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720910', 'MTN Data Voucher','R10.01 (100MB Daily)',10.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720712', 'Telkom Data Voucher','R10.01 (300MB WhatsApp Weekly)',10.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722365', 'MTN Data Top Up','R10.02 (1GB Whatsapp Daily)',10.02); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722259', 'MTN Data Voucher','R10.02 (1GB Whatsapp Daily)',10.02); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721214', 'FIFA Points 100 ZAF','R11.99',11.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722372', 'MTN Data Top Up','R11.99 (1GB WhatsApp 3 Day)',11.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722266', 'MTN Data Voucher','R11.99 (1GB WhatsApp 3 Day)',11.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717784', 'eeziAirtime Voucher','R12',12); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419234', 'MTN Data Top Up','R12 (70MB Weekly)',12); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717142', 'MTN Data Voucher','R12 (70MB Weekly)',12); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717883', 'Vodacom Airtime Voucher','R12',12); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124053', 'Vodacom Data Top Up','R12 (50MB)',12); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124107', 'Vodacom Data Voucher','R12 (50MB)',12); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720453', 'Vodacom Data Voucher','R12 (250MB WhatsApp 7 days)',12); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077785', 'MTN Data Top Up','R12.01 (1GB Hourly)',12.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077877', 'MTN Data Voucher','R12.01 (1GB Hourly)',12.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124787 ', 'Telkom Data Top Up','R14 (75MB + 75MB) ',14); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124749 ', 'Telkom Data Voucher','R14 (75MB + 75MB)',14); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720354', 'Cell C Data Voucher','R14.98 (WhatsApp 500MB 7 days)',14.98); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720484', 'Cell C Data Voucher','R14.99 (150MB Daily)',14.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124169 ', 'Cell C Data Top Up','R15(All-In-One Bundles 120MB)',15); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124206 ', 'Cell C Data Voucher','R15(All-In-One Bundles 120MB)',15); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721313', 'eeziAirtime Voucher','R15',15); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717982', 'MTN Airtime Voucher','R15',15); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077815', 'MTN Data Top Up','R15 (200MB Daily)',15); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077907', 'MTN Data Voucher','R15 (200MB Daily)',15); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720804', 'Telkom Data Top Up','R15 (Unlimited WhatsApp Daily)',15); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720729', 'Telkom Data Voucher','R15 (Unlimited WhatsApp Daily)',15); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077969', 'Vodacom Data Top Up','R15 (100MB Daily)',15); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124893 ', 'Vodacom Data Voucher','R15 (100MB Daily)',15); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722532', 'MTN Data Top Up','R15.01 (100MB Weekly)',15.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722464', 'MTN Data Voucher','R15.01 (100MB Weekly)',15.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720736', 'Telkom Data Voucher','R15.01 (100MB Weekly)',15.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720620', 'Cell C Data Top Up','R17 (300MB Daily)',17); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720491', 'Cell C Data Voucher','R17 (300MB Daily)',17); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419395', 'MTN Data Top Up','R17 (120MB Weekly)',17); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717081', 'MTN Data Voucher','R17 (120MB Weekly)',17); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009900416953', 'Vodacom Data Top Up','R17 (Weekly 120MB)',17); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500668', 'Vodacom Data Voucher','R17 (Weekly 120MB)',17); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721146', 'Cell C Data Voucher','R18.98 (1GB Facebook Weekly)',18.98); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720507', 'Cell C Data Voucher','R18.99 (150MB 7 Days)',18.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720637', 'Cell C Data Top Up','R19 (600MB Daily)',19); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720514', 'Cell C Data Voucher','R19 (600MB Daily)',19); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720521', 'Cell C Data Voucher','R19.01 (100MB)',19.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721917', 'EA-100 FC POINTS ZAF','R19.99',19.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721221', 'FIFA Points 150 ZAF','R19.99',19.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722556', 'MTN Data Top Up','R19.99 (120MB Monthly)',19.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722471', 'MTN Data Voucher','R19.99 (120MB Monthly)',19.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009900416892', '1Voucher','R20',20); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717845', 'Cell C Airtime Voucher','R20',20); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124497 ', 'Cell C Data Top Up','R20 (WhatsApp 600MB 15 Days)',20); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124527 ', 'Cell C Data Voucher','R20 (WhatsApp 600MB 15 Days)',20); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717791', 'eeziAirtime Voucher','R20',20); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419142', 'Flash Voucher','R20',20); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500965', 'MTN Airtime Voucher','R20',20); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722389', 'MTN Data Top Up','R20 (1GB Facebook Weekly)',20); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722488', 'MTN Data Voucher','R20 (1GB Facebook Weekly)',20); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721078', 'Razer Gold Voucher ','R20 ($1)',20); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717944', 'Telkom Airtime Voucher','R20',20); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720811', 'Telkom Data Top Up','R20 (750MB WhatsApp Weekly)',20); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720743', 'Telkom Data Voucher','R20 (750MB WhatsApp Weekly)',20); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722549', 'MTN Data Top Up','R20.01 (1GB Whatsapp Weekly)',20.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722495', 'MTN Data Voucher','R20.01 (1GB Whatsapp Weekly)',20.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500460', 'Free Fire Diamonds Voucher ','R22,50 (100 diamonds)',22.5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500415', 'PUBG Mobile Unknown Cash (UC) Voucher','R22,50 (60 UC)',22.5); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500033', 'Econet Airtime Voucher','R23',23); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419807', 'Cell C Airtime Voucher',' R25',25); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720644', 'Cell C Data Top Up','R25 (1GB Daily)',25); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720538', 'Cell C Data Voucher','R25 (1GB Daily)',25); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419401', 'MTN Data Top Up','R25 (200MB Weekly)',25); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717074', 'MTN Data Voucher','R25 (200MB Weekly)',25); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720545', 'Cell C Data Voucher','R28.99 (150MB)',28.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500224', 'MTN Data Top Up','R29 (200MB)',29); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500149', 'MTN Data Voucher','R29 (200MB)',29); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077051', 'Telkom Data Top Up','R29 (300MB Free Me 14 Days)',29); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124008', 'Telkom Data Voucher','R29 (300MB Free Me 14 Days)',29); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717890', 'Vodacom Airtime Voucher','R29',29); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124060', 'Vodacom Data Top Up','R29 (200MB)',29); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124114', 'Vodacom Data Voucher','R29 (200MB)',29); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720552', 'Cell C Data Voucher','R29.01 (250MB 7 Days)',29.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722563', 'MTN Data Top Up','R29.01 (1GB Everyday Daily)',29.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722501', 'MTN Data Voucher','R29.01 (1GB Everyday Daily)',29.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124756 ', 'Telkom Data Voucher','R29.01 (150MB + 150MB)',29.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500897', 'Vodacom Data Voucher','R29.01 (Weekly 250MB)',29.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720750', 'Telkom Data Voucher','R29.99 (250MB Weekly)',29.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124961 ', '1Voucher','R30',30); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419814', 'Cell C Airtime Voucher',' R30',30); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717807', 'eeziAirtime Voucher','R30',30); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717999', 'MTN Airtime Voucher','R30',30); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500231', 'MTN Data Top Up','R30 (1GB Whatsapp 20 days)',30); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500156', 'MTN Data Voucher','R30 (1GB Whatsapp 20 days)',30); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717951', 'Telkom Airtime Voucher','R30',30); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720828', 'Telkom Data Top Up','R30 (750MB WhatsApp Monthly)',30); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720767', 'Telkom Data Voucher','R30 (750MB WhatsApp Monthly)',30); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124565 ', 'Cell C Data Voucher','R34.99 (250MB)',34.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419821', 'Cell C Airtime Voucher',' R35',35); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721641', 'Cell C Data Top Up','R35 (Whatsapp Bundle 1GB)',35); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721658', 'Cell C Data Voucher','R35 (Whatsapp Bundle 1GB)',35); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721320', 'eeziAirtime Voucher','R35',35); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722402', 'MTN Data Top Up','R35 (1GB Whatsapp Monthly)',35); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722297', 'MTN Data Voucher','R35 (1GB Whatsapp Monthly)',35); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720835', 'Telkom Data Top Up','R35 (Unlimited WhatsApp Weekly)',35); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720774', 'Telkom Data Voucher','R35 (Unlimited WhatsApp Weekly)',35); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721108', 'Vodacom Data Voucher','R35 (1GB WhatsApp Monthly)',35); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720569', 'Cell C Data Voucher','R35.01 (2GB Daily)',35.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722419', 'MTN Data Top Up','R35.01 (1GB Facebook Monthly)',35.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722303', 'MTN Data Voucher','R35.01 (1GB Facebook Monthly)',35.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721665', 'Cell C Data Voucher','R35.02(All-In-One Bundle 300MB)',35.02); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077525', 'Telkom Data Top Up','R39 (600MB FreeMe 14 days)',39); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124015', 'Telkom Data Voucher','R39 (600MB FreeMe 14 days)',39); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721337', 'eeziAirtime Voucher','R40',40); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077822', 'MTN Data Top Up','R40 (400MB Weekly)',40); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077914', 'MTN Data Voucher','R40 (400MB Weekly)',40); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721085', 'Razer Gold Voucher ','R40 ($2)',40); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720842', 'Telkom Data Top Up','R40 (1.5GB WhatsApp Monthly)',40); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720781', 'Telkom Data Voucher','R40 (1.5GB WhatsApp Monthly)',40); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722518', 'MTN Data Voucher','R40.01 (1GB Social Pass Weekly)',40.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500477', 'Free Fire Diamonds Voucher ','R45 (210 diamonds)',45); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720255', 'Cell C Data Voucher','R45.01 (Home Connecta LTE 2GB+2GB 14 Days)',45.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720576', 'Cell C Data Voucher','R48.99 (350MB)',48.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720651', 'Cell C Data Top Up','R49 (500MB 7 Days)',49); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720583', 'Cell C Data Voucher','R49 (500MB 7 Days)',49); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124640', 'MTN Data Top Up','R49 (2GB Everyday Daily)',49); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124671 ', 'MTN Data Voucher','R49 (2GB Everyday Daily)',49); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124121', 'Telkom Data Top Up','R49 (3GB + 3GB LTE)',49); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124077', 'Telkom Data Voucher','R49 (3GB + 3GB LTE)',49); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500057', 'Vodacom Data Top Up','R49 (350MB)',49); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500040', 'Vodacom Data Voucher','R49 (250MB)',49); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500248', 'MTN Data Top Up','R49.01 (350MB)',49.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500163', 'MTN Data Voucher','R49.01 (350MB)',49.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124763 ', 'Telkom Data Voucher','R49.01 (300MB + 300MB)',49.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720682', 'Vodacom Data Voucher','R49.01 (Weekly 500MB)',49.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009900416700', '1Voucher','R50',50); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717852', 'Cell C Airtime Voucher','R50',50); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500842', 'Cell C Data Top Up','R50 (All-In-One Bundle 450MB)',50); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717814', 'eeziAirtime Voucher','R50',50); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419159', 'Flash Voucher','R50',50); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720415', 'MTN Airtime Voucher','R50',50); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722426', 'MTN Data Top Up','R50 (2GB WhatsApp Monthly)',50); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722310', 'MTN Data Voucher','R50 (2GB WhatsApp Monthly)',50); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720095', 'MTN Voice Voucher','R50 (Monthly 350 Min On-Net Voice)',50); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721436', 'Netflix','R50',50); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500330', 'Sony PlayStation Store Wallet Top Up','R50',50); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009900416908', 'Telkom Airtime Voucher','R50',50); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419128', 'Worldcall Airtime Voucher','R50',50); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720132', 'MTN Data Top Up','R55 (500MB Everyday Weekly)',55); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720125', 'MTN Data Voucher','R55 (500MB Everyday Weekly)',55); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717906', 'Vodacom Airtime Voucher','R55',55); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720200', 'Cell C Data Top Up','R59 (Home Connecta LTE 2GB+2GB+40min)',59); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720262', 'Cell C Data Voucher','R59 (Home Connecta LTE 2GB+2GB+40min)',59); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721238', 'FIFA Points 500 ZAF','R59.99',59.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722600', 'Cell C Airtime Voucher','R60',60); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721344', 'eeziAirtime Voucher','R60',60); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419005', 'MTN Airtime Voucher','R60',60); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721610', 'MTN Data Voucher','R65 (1GB Weekly)',65); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721528', 'MTN Data Top Up','R65.01 (500MB)',65.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721627', 'MTN Data Voucher','R65.01 (500MB)',65.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077211', 'Spotify 1 Month','R66',66); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720590', 'Cell C Data Voucher','R68.99 (600MB)',68.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720668', 'Cell C Data Top Up','R69 (1GB 7 Days)',69); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720606', 'Cell C Data Voucher','R69 (1GB 7 Days)',69); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124084', 'Vodacom Data Top Up','R69 (500MB)',69); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124138', 'Vodacom Data Voucher','R69 (500MB)',69); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419838', 'Cell C Airtime Voucher',' R70',70); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721351', 'eeziAirtime Voucher','R70',70); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721757', 'MTN Data Top Up','R75 (2GB Social Pass Monthly)',75); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721740', 'MTN Data Voucher','R75 (2GB Social Pass Monthly)',75); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721535', 'MTN Data Top Up','R79 (1GB)',79); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721634', 'MTN Data Voucher','R79 (1GB)',79); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500637', 'Telkom Data Voucher','R79 (1GB + 1GB)',79); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721368', 'eeziAirtime Voucher','R80',80); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720156', 'Steam Wallet Code','R80',80); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720033', 'Cell C Data Top Up','R85 (1GB)',85); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720057', 'Cell C Data Voucher','R85 (1GB)',85); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124091', 'Vodacom Data Top Up','R85 (1GB)',85); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124145', 'Vodacom Data Voucher','R85 (1GB)',85); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720217', 'Cell C Data Top Up','R89 (7GB-1GBx7Days Day by Day)',89); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720279', 'Cell C Data Voucher','R89 (7GB-1GBx7Days Day by Day)',89); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500644', 'Telkom Data Voucher','R89 (1.5GB + 1.5GB)',89); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720286', 'Cell C Data Voucher','R89.01 (Home Connecta LTE 6GB+6GB)',89.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721375', 'eeziAirtime Voucher','R90',90); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124183 ', 'Cell C Data Top Up','R95(All-In-One Bundle 1GB)',95); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124220 ', 'Cell C Data Voucher','R95(All-In-One Bundle 1GB)',95); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720613', 'Cell C Data Voucher','R98.98 (2GB 7 days)',98.98); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720293', 'Cell C Data Voucher','R98.99 (7.5GB-250MBx30Days Day by Day)',98.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500279', 'MTN Data Top Up','R98.99 (Weekly 2GB)',98.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500194', 'MTN Data Voucher','R98.99 (Weekly 2GB)',98.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500828', 'Cell C Data Top Up','R99 (1.5GB + 1.5GB)',99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720064', 'Cell C Data Voucher','R99 (1.5GB + 1.5GB)',99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500286', 'MTN Data Top Up','R99 (1.5GB)',99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720330', 'MTN Data Voucher','R99 (1.5GB)',99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720675', 'Netflix','R99',99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077143', 'Telkom Data Top Up','R99 (1.2GB Free Me)',99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124022', 'Telkom Data Voucher','R99 (1.2GB Free Me)',99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500910', 'Vodacom Data Top Up','R99 (Weekly 2GB)',99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500903', 'Vodacom Data Voucher','R99 (Weekly 2GB)',99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720002', 'Cell C Data Voucher','R99.01 (Home Connecta LTE 5GB + 5GB + 30mins)',99.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124657 ', 'MTN Data Top Up','R99.01 (1GB Everyday Weekly)',99.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124688 ', 'MTN Data Voucher','R99.01 (1GB Everyday Weekly)',99.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124817 ', 'Telkom Data Voucher','R99.01 (7.5GB + 7.5GB LTE)',99.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712722570', 'MTN Data Top Up','R99.02 (2GB Whatsapp Monthly)',99.02); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721924', 'EA-520 FC POINTS ZAF','R99.99',99.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009900416717', '1Voucher','R100',100); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717869', 'Cell C Airtime Voucher','R100',100); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419012', 'eeziAirtime Voucher','R100',100); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419166', 'Flash Voucher','R100',100); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077419', 'MTN Airtime Voucher','R100',100); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500446', 'Razer Gold Voucher ','R100 ($5)',100); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500347', 'Sony PlayStation Store Wallet Top Up','R100',100); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009900416915', 'Telkom Airtime Voucher','R100',100); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720859', 'Telkom Data Top Up','R100 (Unlimited WhatsApp Monthly)',100); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720798', 'Telkom Data Voucher','R100 (Unlimited WhatsApp Monthly)',100); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419135', 'Worldcall Airtime Voucher','R100',100); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717913', 'Vodacom Airtime Voucher','R110',110); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500484', 'Free Fire Diamonds Voucher ','R112 (530 diamonds)',112); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500422', 'PUBG Mobile Unknown Cash (UC) Voucher','R112 ( 300 + 25 UC)',112); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721399', 'Valorant 475 VP','R112',112); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721245', 'FIFA Points 1050 ZAF','R119.99',119.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077587', 'Telkom Data Top Up','R139 (1.8GB Free Me)',139); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124039', 'Telkom Data Voucher','R139 (1.8GB Free Me)',139); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500293', 'MTN Data Top Up','R149 (2GB+2GB)',149); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500217', 'MTN Data Voucher','R149 (2GB+2GB)',149); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124862 ', 'Telkom Data Top Up','R149 (10GB + 10GB LTE)',149); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124855 ', 'Telkom Data Voucher','R149 (10GB + 10GB LTE)',149); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009900416724', '1Voucher','R150',150); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419845', 'Cell C Airtime Voucher',' R150',150); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721382', 'eeziAirtime Voucher','R150',150); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124466 ', 'Roblox $10 Roblox credit','R150',150); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500354', 'Sony PlayStation Store Wallet Top Up','R150',150); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720163', 'Steam Wallet Code','R150',150); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419791', 'MTN Airtime Voucher',' R180',180); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077204', 'Telkom Data Top Up','R189 (3.5GB Free Me)',189); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124046', 'Telkom Data Voucher','R189 (3.5GB Free Me)',189); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077594', 'Spotify 3 Month','R190',190); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500309', 'MTN Data Top Up','R199 (3GB+3GB)',199); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720026', 'Cell C Data Voucher','R199.01 (Home Connecta LTE 10GB + 10GB + 60mins)',199.01); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721931', 'EA-1070 FC POINTS ZAF','R199.99',199.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009900416731', '1Voucher','R200',200); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717531', 'Cell C Airtime Voucher','R200',200); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419173', 'Flash Voucher','R200',200); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500453', 'Razer Gold Voucher ','R200 ($10)',200); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500361', 'Sony PlayStation Store Wallet Top Up','R200',200); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500439', 'PUBG Mobile Unknown Cash (UC) Voucher','R224 ( 600 + 60 UC)',224); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500491', 'Free Fire Diamonds Voucher ','R225 (1080 diamonds)',225); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721405', 'Valorant 1000 VP','R225',225); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721252', 'FIFA Points 2200 ZAF','R229.99',229.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500873', 'Vodacom Data Top Up','R249 (4GB)',249); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009900416748', '1Voucher','R250',250); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419180', 'Flash Voucher','R250',250); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721887', 'Netflix Gift Card','R250',250); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500378', 'Sony PlayStation Store Wallet Top Up','R250',250); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720170', 'Steam Wallet Code','R250',250); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419968', 'Vodacom Airtime Voucher','R275',275); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009801717333', 'Cell C Data Top Up','R299 (6GB + 6GB)',299); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009880419197', 'Flash Voucher','R300',300); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500385', 'Sony PlayStation Store Wallet Top Up','R300',300); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721047', 'PlayStation Plus Essential 3 Months South Africa','R319',319); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500316', 'MTN Data Top Up','R349 (6GB+6GB)',349); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124589 ', 'Vodacom Data Top Up','R349 (6GB)',349); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009881077242', 'Spotify 6 Month','R360',360); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721948', 'EA-2200 FC POINTS ZAF','R399.99',399.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721092', 'Razer Gold Voucher ','R400 ($20)',400); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721412', 'Valorant 2050 VP','R449',449); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124473 ', 'Roblox $30 Roblox credit','R450',450); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500323', 'MTN Data Top Up','R469 (10GB+10GB)',469); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124596 ', 'Vodacom Data Top Up','R469 (10GB)',469); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712720187', 'Steam Wallet Code','R500',500); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721054', 'PlayStation Plus Extra 3 Months South Africa','R519',519); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009888500880', 'Vodacom Data Top Up','R529 (15GB)',529); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721429', 'Valorant 2575 VP','R560',560); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721269', 'FIFA Points 5750 ZAF','R599.99',599.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721061', 'PlayStation Plus Deluxe 3 Month South Africa','R609',609); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721511', 'MTN Data Top Up','R650(1GB Weekly)',650); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009897124602 ', 'Vodacom Data Top Up','R699 (30GB)',699); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721177', 'PlayStation Plus Essential 12 Months South Africa','R749',749); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721955', 'EA-5750 FC POINTS ZAF','R999.99',999.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721894', 'Sony PlayStation Store Wallet Top Up','R1000',1000); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721276', 'FIFA Points 12000 ZAF','R1199.99',1199.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721184', 'PlayStation Plus Extra 12 Months South Africa','R1,239',1239); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721191', 'PlayStation Plus Deluxe 12 Month South Africa','R1,429',1429); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721283', 'FIFA Points 17500 ZAF','R1699.99',1699.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721962', 'EA-12000 FC POINTS ZAF','R1 999.99',1999.99); INSERT INTO AdditionalServiceItem (Barcode ,Product,Description,Price ) VALUES('6009712721290', 'FIFA Points 26000 ZAF','R2299.99',2299.99); GO IF OBJECT_ID('AdditionalServiceItemSales', 'U') IS NULL BEGIN CREATE TABLE [dbo].[AdditionalServiceItemSales]( [AdditionalServiceItemSalesId] [bigint] IDENTITY(1,1) NOT NULL, [AdditionalServiceItemId] [bigint] NOT NULL, [SalesTransactionId] [bigint] NOT NULL, [PriceInclVat] [decimal](8, 2) NOT NULL, [Vat] [decimal](8, 2) NOT NULL, PRIMARY KEY CLUSTERED ( [AdditionalServiceItemSalesId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] ALTER TABLE [dbo].[AdditionalServiceItemSales] ADD DEFAULT ((0)) FOR [PriceInclVat] ALTER TABLE [dbo].[AdditionalServiceItemSales] ADD DEFAULT ((0)) FOR [Vat] ALTER TABLE [dbo].[AdditionalServiceItemSales] WITH CHECK ADD CONSTRAINT [FK_AdditionalServiceItemSale] FOREIGN KEY([AdditionalServiceItemId]) REFERENCES [dbo].[AdditionalServiceItem] ([AdditionalServiceItemId]) ALTER TABLE [dbo].[AdditionalServiceItemSales] CHECK CONSTRAINT [FK_AdditionalServiceItemSale] ALTER TABLE [dbo].[AdditionalServiceItemSales] WITH CHECK ADD CONSTRAINT [FK_SalesTransactionAdditionalServiceItemSale] FOREIGN KEY ([SalesTransactionId]) REFERENCES [dbo].[Sales_Transaction] ([Sales_Transaction_ID]) ALTER TABLE [dbo].[AdditionalServiceItemSales] CHECK CONSTRAINT [FK_SalesTransactionAdditionalServiceItemSale] CREATE INDEX idx_salestransactionid ON [dbo].[AdditionalServiceItemSales] (SalesTransactionId) CREATE INDEX idx_additionalserviceitemid ON [dbo].[AdditionalServiceItemSales] (AdditionalServiceItemId) END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[GetRetailAdditionalServicesSales] @cashierSessionId bigint AS BEGIN SET NOCOUNT ON; SELECT asis.SalesTransactionId, asis.AdditionalServiceItemId, asis.PriceInclVat, asis.Vat, asi.Product FROM Sales_Transaction AS st INNER JOIN AdditionalServiceItemSales AS asis ON st.Sales_Transaction_ID = asis.SalesTransactionId INNER JOIN Cashier_Session AS cs ON cs.Cashier_Session_ID = st.Cashier_Session_ID INNER JOIN additionalserviceitem AS asi ON asi.additionalserviceitemid = asis.additionalserviceitemid WHERE (st.Sales_Status_ID = 4) AND (st.Sales_Transaction_Type_ID = 1) AND cs.Cashier_Session_ID = @cashierSessionId END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[GetPeriodRetailAdditionalItemSales] @fromDate datetime, @toDate datetime AS BEGIN SET NOCOUNT ON; SELECT ISNULL(asis.PriceInclVat, 0) AS TotalPrice, ISNULL(asis.Vat, 0) AS TotalVat FROM Sales_Transaction AS st INNER JOIN AdditionalServiceItemSales AS asis ON st.Sales_Transaction_ID = asis.SalesTransactionId INNER JOIN Cashier_Session AS cs ON cs.Cashier_Session_ID = st.Cashier_Session_ID INNER JOIN Trading_Day AS td ON td.Trading_Day_ID = cs.Trading_Day_ID WHERE (st.Sales_Status_ID = 4) AND (st.Sales_Transaction_Type_ID = 1) AND td.Trading_Date >= @fromDate AND td.Trading_Date <= @toDate END GO IF OBJECT_ID('GetRetailAdditionalServicesPerSale', 'P') IS NOT NULL BEGIN DROP PROCEDURE [dbo].[GetRetailAdditionalServicesPerSale] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[GetRetailAdditionalServicesPerSale] @cashierSessionId BIGINT, @salesTransactionId BIGINT AS BEGIN SELECT asis.SalesTransactionId, asis.AdditionalServiceItemId, asis.PriceInclVat, asis.Vat, asi.Product FROM Sales_Transaction AS st INNER JOIN AdditionalServiceItemSales AS asis ON st.Sales_Transaction_ID = asis.SalesTransactionId INNER JOIN Cashier_Session AS cs ON cs.Cashier_Session_ID = st.Cashier_Session_ID INNER JOIN additionalserviceitem AS asi ON asi.additionalserviceitemid = asis.additionalserviceitemid WHERE (st.Sales_Status_ID = 4) AND (st.Sales_Transaction_Type_ID = 1) AND cs.Cashier_Session_ID = @cashierSessionId AND st.Sales_Transaction_ID = @salesTransactionId END GO IF OBJECT_ID('GetOtherServicesItemSales', 'P') IS NOT NULL BEGIN DROP PROCEDURE [dbo].[GetOtherServicesItemSales] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[GetOtherServicesItemSales] @fromDate datetime, @toDate datetime AS BEGIN SET NOCOUNT ON; SELECT -- Why is `Date` and `TimeStamp` split into two columns? FORMAT(st.Created, 'yyyy-MM-dd') AS [Date], FORMAT(st.Created, 'hh:mm:ss') AS [TimeStamp], st.Transaction_Number AS TransactionNumber, asi.Barcode, asi.[Description], ISNULL(asi.Price, 0) AS UnitCost, (SELECT COUNT(AdditionalServiceItemSalesId) FROM AdditionalServiceItemSales a WHERE a.AdditionalServiceItemSalesId = asis.AdditionalServiceItemSalesId) AS Quantity, ISNULL(asis.PriceInclVat, 0) AS TotalValue, -- multiple items will all have the same value here?? ISNULL(CONCAT(su.First_Name, SPACE(1), su.Surname), 'NA') AS Cashier, tt.[Description] AS TenderType FROM AdditionalServiceItemSales asis INNER JOIN AdditionalServiceItem asi ON asis.AdditionalServiceItemId = asi.AdditionalServiceItemId INNER JOIN Sales_Transaction st ON asis.SalesTransactionId = st.Sales_Transaction_ID INNER JOIN Cashier_Session cs ON cs.Cashier_Session_ID = st.Cashier_Session_ID INNER JOIN [System_User] su ON su.System_User_ID = cs.System_User_ID INNER JOIN Tender t ON t.Source_Document_ID = st.Sales_Transaction_ID INNER JOIN Tender_Type tt ON tt.Tender_Type_ID = t.Tender_Type_ID WHERE st.Created BETWEEN concat(format(@fromDate, 'yyyy-MM-dd'), space(1), ' 00:00:00') AND concat(format(@toDate, 'yyyy-MM-dd'), space(1), ' 23:59:59') -- `Starting` and `Ending` dates are inclusive when using BETWEEN AND t.Tender_Amount > 0 -- this eliminates those duplicate tender records with R0.00 AND st.Sales_Status_ID = 4 END GO IF NOT EXISTS ( SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Lay_Bye' AND (COLUMN_NAME = 'LaybyTypeId' OR COLUMN_NAME = 'CollectionDate') ) BEGIN ALTER TABLE dbo.Lay_Bye ADD LaybyTypeId INT DEFAULT 1 , CollectionDate DATETIME NULL; END; GO IF NOT EXISTS ( SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'purchase_order' AND COLUMN_NAME = 'LaybyId' ) BEGIN ALTER TABLE dbo.purchase_order ADD LaybyId BIGINT NULL; END; GO IF (SELECT COUNT(AccountNumber) FROM SageAccountDetail WHERE AccountNumber = 'AEL00361') = 0 BEGIN INSERT INTO SageAccountDetail(AccountName, AccountNumber, AccountType, Vatable, Description) VALUES('CurrentAssets', 'AEL00361', 'BankTransaction', 0, 'Other services account') END GO IF (SELECT COUNT(AccountNumber) FROM SageAccountDetail WHERE AccountNumber = 'AEL03710') = 0 BEGIN INSERT INTO SageAccountDetail(AccountName, AccountNumber, AccountType, Vatable, Description) VALUES('ControlAccountEWallet', 'AEL03710', 'BankTransaction', 0, 'Control Account - EWallet') END IF (SELECT COUNT(SettingKey) FROM SystemSetting WHERE SettingKey = 'AdditionalServicesEnabled') = 0 BEGIN INSERT INTO SystemSetting(SettingKey, SettingCategoryId, SettingValueBit, TypeFlag) VALUES('AdditionalServicesEnabled', 1, 0, 4) END GO IF (SELECT COUNT(SettingKey) FROM SystemSetting WHERE SettingKey = 'DefaultDepositPercentage') = 1 BEGIN UPDATE SystemSetting SET SettingValueDecimal = 100 WHERE SettingKey = 'DefaultDepositPercentage' END IF OBJECT_ID(N'GetLaybyMovementReport', N'P') IS NOT NULL BEGIN DROP PROCEDURE [dbo].[GetLaybyMovementReport] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[GetLaybyMovementReport] @_FromDate DATETIME, @_ToDate DATETIME AS BEGIN SELECT Lay_Bye_ID AS LaybyID, Stock_Item_ID AS StockItemID, Customer_ID AS CustomerID, Purchase_Amount AS PurchaseAmount, Inception_Date AS InceptionDate, [Expiry_Date] AS ExpiryDate, Contract_Number AS ContractNumber, Approved_By_ID AS ApprovedByID, Cancelled AS Cancelled, Cancellation_Fee_Percentage AS CancellationFeePercentage, Cancellation_Fee AS CancellationFee, Collected_By_Name AS CollectedByName, Collected_By_ID_Number AS CollectedByIdNumber, Identity_Type_ID AS IdentityTypeID, Sales_Transaction_ID AS SalesTransactionID, Cancellation_Approver_ID AS CancellationApproverID, Store_ID AS StoreID, Lay_Bye_Status_ID AS LaybyStatusID, Serial_Number AS SerialNumber, Date_Closed AS DateClosed, Refunded, Date_Refunded AS DateRefunded, User_Refunded_ID AS UserRefundedID, PurchaseAmountVat AS PurchaseAmountVat, cancellationFeeVat AS CancellationFeeVat, TermId AS TermID, LaybyFinalMovementDate, StockType, Product, LaybyStatus AS [Status], LaybyType, UnitCost, Paid, Due, SalesPerson, Cancellor, StockCode, PurchaseDate FROM (SELECT Lay_Bye_ID, l.Stock_Item_ID, Customer_ID, Purchase_Amount, Inception_Date, [Expiry_Date], Contract_Number, Approved_By_ID, Cancelled, Cancellation_Fee_Percentage, Cancellation_Fee, Collected_By_Name, Collected_By_ID_Number, Identity_Type_ID, l.Sales_Transaction_ID, Cancellation_Approver_ID, l.Store_ID, l.Lay_Bye_Status_ID, l.Serial_Number, Date_Closed, Refunded, Date_Refunded, User_Refunded_ID, PurchaseAmountVat, cancellationFeeVat, TermId, (CASE WHEN l.Lay_Bye_Status_ID = 3 THEN Date_Closed ELSE Date_Refunded END) AS LaybyFinalMovementDate, ist.Description AS StockType, p.Description AS Product, lbs.Description AS LaybyStatus, lbt.Description AS LaybyType, (SELECT stl.Unit_Cost FROM Sales_Transaction_Line stl WHERE stl.Sales_Transaction_ID = st.Sales_Transaction_ID) AS UnitCost, ISNULL((SELECT SUM(lbp.Amount_Paid) FROM Lay_Bye_Payment lbp WHERE lbp.Lay_Bye_ID = l.Lay_Bye_ID), 0) AS Paid, ISNULL((l.Purchase_Amount - (ISNULL((SELECT SUM(lbp.Amount_Paid) FROM Lay_Bye_Payment lbp WHERE lbp.Lay_Bye_ID = l.Lay_Bye_ID), 0))), 0) AS Due, (SELECT CONCAT(su.First_Name, SPACE(1), su.Surname) FROM [System_User] su WHERE su.System_User_ID = st.Sales_Person_ID) AS SalesPerson, (SELECT CONCAT(su.First_Name, SPACE(1), su.Surname) FROM [System_User] su WHERE su.System_User_ID = l.Cancellation_Approver_ID) AS Cancellor, si.Stock_Code AS StockCode, si.Original_Purchase_Date AS PurchaseDate FROM Lay_Bye AS l INNER JOIN Stock_Item si ON si.Stock_Item_ID = l.Stock_Item_ID INNER JOIN Item_Stock_Type ist ON ist.Item_Stock_Type_ID = si.Item_Stock_Type_ID INNER JOIN Product p ON p.Product_ID = si.Product_ID INNER JOIN Lay_Bye_Status lbs ON lbs.Lay_Bye_Status_ID = l.Lay_Bye_Status_ID LEFT OUTER JOIN LayByType lbt ON lbt.LayByTypeId = l.LaybyTypeId INNER JOIN Sales_Transaction st ON st.Sales_Transaction_ID = l.Sales_Transaction_ID WHERE (l.Lay_Bye_Status_ID IN (2, 3))) AS a WHERE (LaybyFinalMovementDate IS NOT NULL) AND (CONVERT(DATE, LaybyFinalMovementDate) BETWEEN @_FromDate AND @_ToDate) END GO IF OBJECT_ID(N'dbo.LaybyAsAt', N'U') IS NULL BEGIN CREATE TABLE LaybyAsAt ( LaybyAsAtID BIGINT NOT NULL IDENTITY (1, 1) PRIMARY KEY, LaybyID BIGINT NOT NULL FOREIGN KEY REFERENCES Lay_Bye (Lay_Bye_ID), StockItemID BIGINT NOT NULL FOREIGN KEY REFERENCES Stock_Item (Stock_Item_ID), SellerID BIGINT NOT NULL FOREIGN KEY REFERENCES Seller (Seller_ID), TradingDayID BIGINT NOT NULL FOREIGN KEY REFERENCES Trading_Day (Trading_Day_ID), TradingDay DATETIME NOT NULL, PurchaseAmount DECIMAL(18, 2) DEFAULT (0), PurchaseAmountVat DECIMAL(18, 2) DEFAULT (0), AmountPaid DECIMAL(18, 2) DEFAULT (0), InceptionDate DATETIME NOT NULL, ExpiryDate DATETIME NOT NULL, ContractNumber VARCHAR(50) NOT NULL, ApprovedByID BIGINT NOT NULL, CancelledDate DATETIME, CancellationFeePercentage DECIMAL(5, 3) DEFAULT (1), CancellationFee DECIMAL(18, 2) DEFAULT (0), CancellationFeeVat DECIMAL(18, 2) DEFAULT (0), CollectedBy VARCHAR(250), CollectedByIdNumber VARCHAR(250), IdentityTypeID INT, SalesTransactionID BIGINT NOT NULL FOREIGN KEY REFERENCES Sales_Transaction(Sales_Transaction_ID), CancellationApprovedByID BIGINT, StoreID BIGINT NOT NULL, LaybyStatusID BIGINT NOT NULL FOREIGN KEY REFERENCES Lay_Bye_Status(Lay_Bye_Status_ID), SerialNumber VARCHAR(50), DateClosed DATETIME, TermID INT ); END IF OBJECT_ID(N'dbo.GetLaybyAsAt', N'P') IS NOT NULL BEGIN DROP PROCEDURE [dbo].[GetLaybyAsAt] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[GetLaybyAsAt] AS BEGIN SELECT Lay_Bye_ID AS LaybyID, Stock_Item_ID AS StockItemID, Customer_ID AS SellerID, Purchase_Amount AS PurchaseAmount, Inception_Date AS InceptionDate, [Expiry_Date] AS ExpiryDate, Contract_Number AS ContractNumber, Approved_By_ID AS ApprovedByID, Cancelled AS Cancelled, Cancellation_Fee_Percentage AS CancellationFeePercentage, Cancellation_Fee AS CancellationFee, Collected_By_Name AS CollectedByName, Collected_By_ID_Number AS CollectedByIdNumber, Identity_Type_ID AS IdentityTypeID, Sales_Transaction_ID AS SalesTransactionID, Cancellation_Approver_ID AS CancellationApprovedByID, Store_ID AS StoreID, Lay_Bye_Status_ID AS LaybyStatusID, Serial_Number AS SerialNumber, Date_Closed AS DateClosed, PurchaseAmountVat AS PurchaseAmountVat, cancellationFeeVat AS CancellationFeeVat, ISNULL(TermId, 3) AS TermID, (SELECT TOP(1) Trading_Day_ID FROM Trading_Day ORDER BY 1 DESC) AS TradingDayID, (SELECT TOP(1) Trading_Date FROM Trading_Day ORDER BY 1 DESC) AS TradingDay, ISNULL((SELECT SUM(Amount_Paid) FROM Lay_Bye_Payment WHERE Lay_Bye_ID = l.Lay_Bye_ID), 0.0) AS AmountPaid FROM Lay_Bye l WHERE Lay_Bye_Status_ID != 3 AND Refunded IS NULL END GO IF OBJECT_ID(N'dbo.GetLaybyAsAtReport', N'P') IS NOT NULL BEGIN DROP PROCEDURE [dbo].[GetLaybyAsAtReport] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[GetLaybyAsAtReport] @_FromDate DATETIME, @_ToDate DATETIME AS BEGIN SELECT l.LayByID, l.StockItemID, l.SellerID, l.PurchaseAmount, l.InceptionDate, l.ExpiryDate, l.ContractNumber, l.ApprovedByID, l.CancelledDate, l.CancellationFeePercentage, l.CancellationFee, l.CollectedBy, l.CollectedByIdNumber, l.IdentityTypeID, l.SalesTransactionID, l.CancellationApprovedByID, l.StoreID, l.LaybyStatusID, l.SerialNumber, l.DateClosed, l.PurchaseAmountVat, l.CancellationFeeVat, l.TermID, l.TradingDayID, l.TradingDay, l.AmountPaid, ist.Description AS StockType, (SELECT lbt.Description FROM LayByType lbt WHERE lbt.LayByTypeId = (SELECT TOP(1) lb.LaybyTypeId FROM Lay_Bye lb WHERE lb.Lay_Bye_ID = l.LaybyID)) AS LaybyType, si.Stock_Code AS StockCode, p.Product_Code AS ProductCode, p.Description AS [Description], CONCAT(s.First_Name, SPACE(1), s.Surname) AS Customer, s.ID_Number AS IdNumber, s.Email_Address AS Email, s.Cell_Number AS CellNumber, lbs.Description AS LaybyStatus, (SELECT Unit_Cost FROM Sales_Transaction_Line stl WHERE stl.Sales_Transaction_ID = l.SalesTransactionID) AS UnitCostIncl, ISNULL(l.PurchaseAmount - (ISNULL((SELECT SUM(Amount_Paid) FROM Lay_Bye_Payment WHERE Lay_Bye_ID = l.LaybyID), 0.0)), 0.0) AS AmountDue, (SELECT CONCAT(su.First_Name, SPACE(1), su.Surname) FROM [System_User] su INNER JOIN Sales_Transaction st ON st.Sales_Person_ID = su.System_User_ID WHERE st.Sales_Transaction_ID = l.SalesTransactionID) AS SalesPerson FROM LaybyAsAt l LEFT OUTER JOIN Stock_Item si ON si.Stock_Item_ID = l.StockItemID LEFT OUTER JOIN Item_Stock_Type ist ON ist.Item_Stock_Type_ID = si.Item_Stock_Type_ID LEFT OUTER JOIN Product p ON p.Product_ID = si.Product_ID LEFT OUTER JOIN Seller s ON s.Seller_ID = l.SellerID LEFT OUTER JOIN Lay_Bye_Status lbs on lbs.Lay_Bye_Status_ID = l.LaybyStatusID WHERE l.TradingDay >= @_FromDate AND l.TradingDay <= @_ToDate ORDER BY l.LaybyID END GO IF OBJECT_ID(N'dbo.SaveLaybyAsAt', N'P') IS NOT NULL BEGIN DROP PROCEDURE [dbo].[SaveLaybyAsAt] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[SaveLaybyAsAt] @_LaybyID BIGINT, @_StockItemID BIGINT, @_SellerID BIGINT, @_PurchaseAmount DECIMAL(18, 2), @_InceptionDate DATETIME, @_ExpiryDate DATETIME, @_ContractNumber TEXT, @_ApprovedByID BIGINT, @_Cancelled DATETIME, @_CancellationFeePercentage DECIMAL(5, 3), @_CancellationFee DECIMAL(18, 2), @_CollectedByName VARCHAR(250), @_CollectedByIdNumber VARCHAR(250), @_IdentityTypeID INT, @_SalesTransactionID BIGINT, @_CancellationApprovedByID BIGINT, @_StoreID BIGINT, @_LaybyStatusID BIGINT, @_SerialNumber VARCHAR(100), @_DateClosed DATETIME, @_PurchaseAmountVat DECIMAL(18, 2), @_CancellationFeeVat DECIMAL(18, 2), @_TermID INT, @_AmountPaid DECIMAL(18, 2), @_TradingDayID BIGINT, @_TradingDay DATETIME AS BEGIN SET NOCOUNT ON; BEGIN TRY BEGIN TRAN INSERT INTO LaybyAsAt( LaybyID, StockItemID, SellerID, PurchaseAmount, InceptionDate, ExpiryDate, ContractNumber, ApprovedByID, CancelledDate, CancellationFeePercentage, CancellationFee, CollectedBy, CollectedByIdNumber, IdentityTypeID, SalesTransactionID, CancellationApprovedByID, StoreID, LaybyStatusID, SerialNumber, DateClosed, PurchaseAmountVat, CancellationFeeVat, TermID, AmountPaid, TradingDayID, TradingDay) VALUES(@_LaybyID, @_StockItemID, @_SellerID, @_PurchaseAmount, @_InceptionDate, @_ExpiryDate, @_ContractNumber, @_ApprovedByID, @_Cancelled, @_CancellationFeePercentage, @_CancellationFee, @_CollectedByName, @_CollectedByIdNumber, @_IdentityTypeID, @_SalesTransactionID, @_CancellationApprovedByID, @_StoreID, @_LaybyStatusID, @_SerialNumber, @_DateClosed, @_PurchaseAmountVat, @_CancellationFeeVat, @_TermID, @_AmountPaid, @_TradingDayID, @_TradingDay) COMMIT TRAN END TRY BEGIN CATCH ROLLBACK TRAN END CATCH END GO IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'LayByType') BEGIN CREATE TABLE LayByType ( LayByTypeId INT PRIMARY KEY IDENTITY(1,1), [Description] VARCHAR(20) NOT NULL ); END; GO SET IDENTITY_INSERT LayByType ON INSERT INTO LayByType (LayByTypeId, Description) VALUES (1, 'Instore Laybys'); INSERT INTO LayByType (LayByTypeId, Description) VALUES (2, 'CCW Laybys'); SET IDENTITY_INSERT LayByType OFF IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'LaybyHQSet') BEGIN CREATE TABLE LaybyHQSet ( ID BIGINT PRIMARY KEY IDENTITY(1,1), LoadedDate DATETIME NOT NULL, IsActiveSet BIT DEFAULT 1, LoadedBy VARCHAR(250) NOT NULL ); END; GO IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'LaybyHQSetDetail') BEGIN CREATE TABLE LaybyHQSetDetail ( ID BIGINT PRIMARY KEY IDENTITY(1,1), HQMasterId BIGINT NOT NULL, LaybyHQSetId BIGINT NOT NULL, FOREIGN KEY (LaybyHQSetId) REFERENCES LaybyHQSet(ID) ); END; GO IF NOT EXISTS ( SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Lay_Bye' AND (COLUMN_NAME = 'LaybyTypeId' OR COLUMN_NAME = 'CollectionDate') ) BEGIN ALTER TABLE dbo.Lay_Bye ADD LaybyTypeId INT DEFAULT 1 REFERENCES LayByType(LayByTypeId), CollectionDate DATETIME NULL; END; GO IF NOT EXISTS ( SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'purchase_order' AND COLUMN_NAME = 'LaybyId' ) BEGIN ALTER TABLE dbo.purchase_order ADD LaybyId BIGINT NULL; END; GO IF (select count(1) from SystemSetting where SettingKey = 'CcwLayby') = 0 BEGIN INSERT INTO SystemSetting (SettingKey, SettingCategoryId, SettingValueBit, SettingValueInt, TypeFlag) VALUES ('CcwLayby', 1, 0, 30, 4) END GO IF (select count(1) from SystemSetting where SettingKey = 'CcwLayby') = 0 BEGIN INSERT INTO SystemSetting (SettingKey, SettingCategoryId, SettingValueBit, SettingValueInt, TypeFlag) VALUES ('CcwLayby', 1, 0, 30, 4) END IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'LayByType') BEGIN CREATE TABLE LayByType ( LayByTypeId INT PRIMARY KEY IDENTITY(1,1), [Description] VARCHAR(20) NOT NULL ); END; GO IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'LaybyHQSet') BEGIN CREATE TABLE LaybyHQSet ( ID BIGINT PRIMARY KEY IDENTITY(1,1), LoadedDate DATETIME NOT NULL, IsActiveSet BIT DEFAULT 1, LoadedBy VARCHAR(250) NOT NULL ); END; GO IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'LaybyHQSetDetail') BEGIN CREATE TABLE LaybyHQSetDetail ( ID BIGINT PRIMARY KEY IDENTITY(1,1), HQMasterId BIGINT NOT NULL, LaybyHQSetId BIGINT NOT NULL, FOREIGN KEY (LaybyHQSetId) REFERENCES LaybyHQSet(ID) ); END; GO IF NOT EXISTS ( SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Lay_Bye' AND (COLUMN_NAME = 'LaybyTypeId' OR COLUMN_NAME = 'CollectionDate') ) BEGIN ALTER TABLE dbo.Lay_Bye ADD LaybyTypeId INT DEFAULT 1 REFERENCES LayByType(LayByTypeId), CollectionDate DATETIME NULL; END; GO IF NOT EXISTS ( SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'purchase_order' AND COLUMN_NAME = 'LaybyId' ) BEGIN ALTER TABLE dbo.purchase_order ADD LaybyId BIGINT NULL; END; GO IF (select count(1) from System_Default where Default_Name = 'CashposApiV2') = 0 BEGIN INSERT INTO System_Default (Default_Name, Default_Value) VALUES ('CashposApiV2', 'https://localhost:44329/api/') END IF (SELECT COUNT(0) FROM SystemSetting WHERE SettingKey = 'OnlineLaybyPaymentsInterval') = 0 BEGIN INSERT INTO SystemSetting(SettingKey, SettingCategoryId, SettingValueInt, SettingValueBit, TypeFlag) VALUES('OnlineLaybyPaymentsInterval', 1, 30, 0, 4) END GO IF (SELECT COUNT(0) FROM SystemSetting WHERE SettingKey = 'OnlineLaybyInterval') = 0 BEGIN INSERT INTO SystemSetting(SettingKey, SettingCategoryId, SettingValueInt, TypeFlag) VALUES('OnlineLaybyInterval', 1, 15, 4) END GO IF (SELECT COUNT(0) FROM CPProcess WHERE Description = 'LaybyPayments') = 0 BEGIN INSERT INTO CPProcess(Description) VALUES('LaybyPayments') END GO IF (SELECT COUNT(0) FROM CPProcess WHERE Description = 'OnlineLayby') = 0 BEGIN INSERT INTO CPProcess(Description) VALUES('OnlineLayby') END GO Print 'Insert into script history if everything else is cool'; Insert into Script_History (RunDate,Script_Name) Values (CURRENT_TIMESTAMP,'ReleaseJuly2024Week2'); IF @@ERROR != 0 BEGIN RAISERROR ('UNABLE TO CONTINUE WITH SCRIPT', 11, 1); RETURN; END GO