/****** Object:  Table [dbo].[publ_WholesalerOrders]    Script Date: 2020/02/06 15:18:11 ******/

USE [Framework_REAP-1]
IF((SELECT COUNT(*) FROM dbo.pal_Surface WHERE name = 'WholesalerOrders') = 1)
BEGIN

UPDATE pal_Surface SET isPublished = 1 WHERE name = 'WholesalerOrders';
END;

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'publ_WholesalerOrders')
BEGIN

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[publ_WholesalerOrders](
	[itemID] [int] NOT NULL,
	[isActive] [bit] NULL,
	[surfaceId] [int] NOT NULL,
	[ParentSurfaceItemId] [int] NULL,
	[WholesalerOrders_WholesalerDetails_WholesalerLogo] [varchar](max) NULL,
	[OrderManagement_OrderManagement_RetailerName] [varchar](max) NULL,
	[WholesalerOrders_WholesalerDetails_OrderNumber] [varchar](max) NULL,
	[WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT] [decimal](18, 2) NULL,
	[WholesalerOrders_OrderManagement_ContactName] [varchar](max) NULL,
	[WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT] [decimal](18, 2) NULL,
	[WholesalerOrders_OrderManagement_EmailAddress] [varchar](max) NULL,
	[WholesalerOrders_WholesalerDetails_Area] [varchar](max) NULL,
	[WholesalerOrders_WholesalerDetails_OrderEmail] [varchar](max) NULL,
	[WholesalerOrders_WholesalerDetails_PhoneNumber] [varchar](max) NULL,
	[WholesalerOrders_WholesalerDetails_WholesalerUniqueName] [varchar](max) NULL,
	[WholesalerOrders_OrderManagement_MobileNumber] [varchar](max) NULL,
	[WholesalerOrders_OrderManagement_OrderNotes] [text] NULL,
	[WholesalerOrders_WholesalerDetails_Address] [varchar](max) NULL,
	[OrderManagement_OrderManagement_WholesalerInstructions] [text] NULL,
	[WholesalerOrders_WholesalerDetails_OrderAdminFee] [decimal](18, 2) NULL,
	[WholesalerOrders_WholesalerDetails_ConfirmedAdminFee] [decimal](18, 2) NULL,
	[OrderManagement_OrderManagement_OrderDate] [datetime] NULL,
	[WholesalerOrders_OrderManagement_EstimateCollectionDate] [datetime] NULL,
	[WholesalerOrders_WholesalerDetails_PromotionExpires] [datetime] NULL,
	[WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT] [decimal](18, 2) NULL,
	[OrderManagement_OrderManagement_WholesalerOrderStatus] [int] NULL,
	[WholesalerOrders_WholesalerDetails_BalanceAfterOrdering] [decimal](18, 2) NULL,
	[WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT] [decimal](18, 2) NULL,
	[WholesalerOrders_OrderManagement_PrintOrder] [varchar](max) NULL,
	[WholesalerOrders_OrderManagement_EmailOrder] [varchar](max) NULL,
	[WholesalerOrders_WholesalerDetails_REAPtechAdminFee] [decimal](18, 2) NULL,
	[WholesalerOrders_WholesalerDetails_ExtraGPZARTotal] [decimal](18, 2) NULL,
	[WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal] [decimal](18, 2) NULL,
	[WholesalerOrders_WholesalerDetails_OrderStatus] [varchar](max) NULL,
	[WholesalerOrders_WholesalerDetails_AvailableBalance] [decimal](18, 2) NULL,
	[WholesalerOrders_WholesalerDetails_LastUpdate] [varchar](max) NULL,
	[WholesalerOrders_WholesalerDetails_UpdatedBy] [varchar](max) NULL,
	[WholesalerOrders_WholesalerDetails_SendOrder] [varchar](max) NULL,
	[WholesalerOrders_WholesalerDetails_OrderCreated] [varchar](max) NULL,
	[WholesalerOrders_WholesalerDetails_AccountTopup] [varchar](max) NULL,
	[recId] [int] IDENTITY(1,1) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[recId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[publ_WholesalerOrders] ON 

INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (58506, 1, 3094, 58302, N'7006/c3bbb9a0-0f3f-4741-aac4-e2982bef3488.png', N'Southern Superspar', N'S0001-PO-1', CAST(98178.16 AS Decimal(18, 2)), N'', CAST(0.00 AS Decimal(18, 2)), N'', N'Pretoria', N'sales@advancecashncarry.co.za', N'0123796050', N'Advance Cash and Carry (Pretoria)', N'', N'', N', , , , , ', N'', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2020-01-20T00:00:00.000' AS DateTime), CAST(N'2020-01-22T00:00:00.000' AS DateTime), CAST(N'2020-01-22T00:00:00.000' AS DateTime), CAST(112904.88 AS Decimal(18, 2)), 1539, CAST(-37095.12 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(18994.64 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Order Received', CAST(18805.10 AS Decimal(18, 2)), N'2020-01-20 11:03:00 (last updated on 2020-01-30 20:58:00)', N'', NULL, N'2020/01/20', NULL, 1)
INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (58999, 1, 3094, 58302, N'7002/4f71ff77-c290-4a88-8473-4c2ff7fe52e4.png', N'Southern Superspar', N'S0001-PO-2', CAST(31425.50 AS Decimal(18, 2)), N'', CAST(0.00 AS Decimal(18, 2)), N'', N'Crown Mines', N'orders@africacnc.co.za', N'0116616600', N'Africa Cash and Carry (Crown Mines)', N'', N'', N', , , , , ', N'', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2020-01-20T00:00:00.000' AS DateTime), CAST(N'2020-01-22T00:00:00.000' AS DateTime), CAST(N'2020-01-26T00:00:00.000' AS DateTime), CAST(36139.33 AS Decimal(18, 2)), 1539, CAST(-113860.67 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(6021.02 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Order Received', CAST(18805.10 AS Decimal(18, 2)), N'2020-01-20 11:32:00 (last updated on 2020-01-30 20:59:00)', N'', NULL, N'2020/01/20', NULL, 2)
INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (77844, 1, 3094, 76415, N'7006/03f2cb31-a4d9-4fc2-9cba-84e9cb35b5ab.png', N'Southern Superspar', N'S0004-PO-3', CAST(33376.14 AS Decimal(18, 2)), N'Dylan Reevell', CAST(0.00 AS Decimal(18, 2)), N'dylan@evolutionsoftware.co.za', N'Pretoria', N'sales@advancecashncarry.co.za', N'0123796050', N'Advance Cash and Carry (Pretoria)', N'', N'', N', , , , , ', N'Only supply items on promotion. 
Please quote for delivery to Germiston.', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(N'2020-02-07T00:00:00.000' AS DateTime), CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(38382.56 AS Decimal(18, 2)), 1537, CAST(19897.16 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(7475.40 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Order Placed (Unpaid)', CAST(203508.10 AS Decimal(18, 2)), N'2020-02-05 08:42:00 (last updated on 2020-02-05 21:39:00)', N'Mark Gouveia (last updated by Dylan Reevell)', NULL, N'2020/02/05', NULL, 3)
INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (77854, 1, 3094, 76415, N'7139/fc971d26-dac6-47ef-ba4b-cca20abf845c.PNG', N'Southern Superspar', N'S0004-PO-4', CAST(12262.20 AS Decimal(18, 2)), N'Dylan Reevell', CAST(0.00 AS Decimal(18, 2)), N'dylan@evolutionsoftware.co.za', N'Springs', N'orders@reaptech.io', N'0118133141', N'Ohlanga Cash and Carry (Springs)', N'', N'', N', , , , , ', N'Only supply items on promotion. 
Please quote for delivery to Germiston.', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(N'2020-02-07T00:00:00.000' AS DateTime), CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(14101.53 AS Decimal(18, 2)), 1537, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(1929.84 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Order Placed (Unpaid)', CAST(203508.10 AS Decimal(18, 2)), N'2020-02-05 08:51:00 (last updated on 2020-02-05 21:43:00)', N'Mark Gouveia (last updated by Dylan Reevell)', NULL, N'2020/02/05', NULL, 4)
INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (77858, 1, 3094, 76415, N'6555/66b39e62-5ec1-4fa7-a112-d413420dee01.png', N'Southern Superspar', N'S0004-PO-5', CAST(25969.52 AS Decimal(18, 2)), N'Dylan Reevell', CAST(0.00 AS Decimal(18, 2)), N'dylan@evolutionsoftware.co.za', N'Devland', N'info@devland.co.za', N'0119898800', N'Devland Cash & Carry (Devland)', N'', N'', N', , , , , ', N'Only supply items on promotion. 
Please quote for delivery to Germiston.', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(N'2020-02-07T00:00:00.000' AS DateTime), CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(29864.95 AS Decimal(18, 2)), 1537, CAST(11059.85 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(2819.16 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Order Placed (Unpaid)', CAST(203508.10 AS Decimal(18, 2)), N'2020-02-05 08:53:00 (last updated on 2020-02-05 21:26:00)', N'Mark Gouveia (last updated by Dylan Reevell)', NULL, N'2020/02/05', NULL, 5)
INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (77861, 1, 3094, 76415, N'4158/b2fbd215-ba5f-4719-ac0e-f3e5df63f920.png', N'Southern Superspar', N'S0004-PO-6', CAST(29904.84 AS Decimal(18, 2)), N'', CAST(0.00 AS Decimal(18, 2)), N'', N'Crown Mines', N'orders@ccnc.co.za', N'0105942085', N'Continental Cash & Carry (Crown Mines)', N'', N'', N', , , , , ', N'Only supply items on promotion. 
Please quote for delivery to Germiston.', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(N'2020-02-07T00:00:00.000' AS DateTime), CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(34390.57 AS Decimal(18, 2)), 1537, CAST(-169117.53 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(11319.06 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Order Placed (Unpaid)', CAST(203508.10 AS Decimal(18, 2)), N'2020-02-05 08:54:00 (last updated on 2020-02-05 21:24:00)', N'Mark Gouveia (last updated by Dylan Reevell)', NULL, N'2020/02/05', NULL, 6)
INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (77893, 1, 3094, 76415, N'7002/4f71ff77-c290-4a88-8473-4c2ff7fe52e4.png', N'Southern Superspar', N'S0004-PO-7', CAST(16980.36 AS Decimal(18, 2)), N'Dylan Reevell', CAST(0.00 AS Decimal(18, 2)), N'dylan@evolutionsoftware.co.za', N'Crown Mines', N'orders@africacnc.co.za', N'0116616600', N'Africa Cash and Carry (Crown Mines)', N'', N'', N', , , , , ', N'Only supply items on promotion. 
Please quote for delivery to Germiston.', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(N'2020-02-07T00:00:00.000' AS DateTime), CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(19527.41 AS Decimal(18, 2)), 1537, CAST(722.31 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(8910.84 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Order Placed (Unpaid)', CAST(18805.10 AS Decimal(18, 2)), N'2020-02-05 09:19:00 (last updated on 2020-02-05 21:17:00)', N'Mark Gouveia (last updated by Dylan Reevell)', NULL, N'2020/02/05', NULL, 7)
INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (77895, 1, 3094, 76415, N'7140/6c3256f5-5c1e-4792-8352-29f86864e23a.png', N'Southern Superspar', N'S0004-PO-8', CAST(28930.02 AS Decimal(18, 2)), N'Dylan Reevell', CAST(0.00 AS Decimal(18, 2)), N'dylan@evolutionsoftware.co.za', N'Silverton', N'sales.silverton@kitkatgroup.com', N'0128049008', N'Kit Kat Cash and Carry (Silverton)', N'', N'', N', , , , , ', N'Only supply items on promotion. 
Please quote for delivery to Germiston.', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(N'2020-02-07T00:00:00.000' AS DateTime), CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(33269.52 AS Decimal(18, 2)), 1537, CAST(-170238.58 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(6235.66 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Order Placed (Unpaid)', CAST(203508.10 AS Decimal(18, 2)), N'2020-02-05 09:22:00 (last updated on 2020-02-05 23:59:00)', N'Mark Gouveia (last updated by Dylan Reevell)', NULL, N'2020/02/05', NULL, 8)
INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (77900, 1, 3094, 76415, N'9819/e4bd4bd4-cdb4-4c89-8208-17560460e217.PNG', N'Southern Superspar', N'S0004-PO-9', CAST(360.00 AS Decimal(18, 2)), N'', CAST(0.00 AS Decimal(18, 2)), N'', N'Springs', N'orders@jumbo.co.za', N'', N'Jumbo Cash & Carry (Springs)', N'', N'', N', , , , , ', N'', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(414.00 AS Decimal(18, 2)), 1538, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(12.84 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Order Placed (Unpaid)', CAST(18805.10 AS Decimal(18, 2)), N'2020-02-05 09:24:00 (last updated on 2020-02-05 18:30:00)', N'Mark Gouveia (last updated by Dylan Reevell)', NULL, N'2020/02/05', NULL, 9)
INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (78690, 1, 3094, 76415, N'7530/00e69890-a8a5-4555-b29a-0c4c86e9354d.jpg', N'Southern Superspar', N'S0004-PO-10', CAST(2138.40 AS Decimal(18, 2)), N'', CAST(0.00 AS Decimal(18, 2)), N'', N'Pretoria West', N'orders@reaptech.io', N'0123270472', N'Unimart Cash & Carry (Pretoria West)', N'', N'', N', , , , , ', N'', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(2459.16 AS Decimal(18, 2)), 1538, CAST(-16345.94 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(748.80 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Order Placed (Unpaid)', CAST(18805.10 AS Decimal(18, 2)), N'2020-02-05 11:28:00 (last updated on 2020-02-05 18:31:00)', N'', NULL, N'2020/02/05', NULL, 10)
INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (79801, 1, 3094, 76415, N'7505/8018a53d-1d76-4576-9a0b-2b14626e6700.png', N'Southern Superspar', N'S0004-PO-11', CAST(5957.00 AS Decimal(18, 2)), N'', CAST(0.00 AS Decimal(18, 2)), N'', N'Crown Mines', N'orders@reaptech.io', N'0118300030', N'Rapid Distributions (Crown Mines)', N'', N'', N', , , , , ', N'', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(6850.55 AS Decimal(18, 2)), 1538, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(1048.60 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Order Placed (Unpaid)', CAST(18805.10 AS Decimal(18, 2)), N'2020-02-05 15:34:00 (last updated on 2020-02-05 19:04:00)', N'Dylan Reevell (last updated by Dylan Reevell)', NULL, N'2020/02/05', NULL, 11)
INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (81428, 1, 3094, 81424, N'7139/fc971d26-dac6-47ef-ba4b-cca20abf845c.PNG', N'Dylan Test Retailer', N'S0005-PO-12', CAST(403.44 AS Decimal(18, 2)), N'', CAST(0.00 AS Decimal(18, 2)), N'', N'Springs', N'telesales@tradeportdc.com', N'0118133334', N'Ohlanga Cash and Carry (Springs)', N'', N'', N'Cnr Gold and Industry Roads,  Springs,  ,  Gauteng,  South Africa,  , ', N'', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(463.96 AS Decimal(18, 2)), 1551, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(-151.44 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Promotion Expired', CAST(0.00 AS Decimal(18, 2)), N'2020-02-06 14:09:00', N'Dylan Reevell', NULL, N'', NULL, 12)
INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (81431, 1, 3094, 81424, N'6555/66b39e62-5ec1-4fa7-a112-d413420dee01.png', N'Dylan Test Retailer', N'S0005-PO-13', CAST(365.16 AS Decimal(18, 2)), N'', CAST(0.00 AS Decimal(18, 2)), N'', N'Devland', N'info@devland.co.za', N'0119898800', N'Devland Cash & Carry (Devland)', N'', N'', N'Cnr Klepkas and Piston Road,  Devland,  ,  Gauteng,  South Africa,  , ', N'', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(419.93 AS Decimal(18, 2)), 1551, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(-121.56 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Promotion Expired', CAST(0.00 AS Decimal(18, 2)), N'2020-02-06 14:22:00', N'Dylan Reevell', NULL, N'', NULL, 13)
INSERT [dbo].[publ_WholesalerOrders] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [WholesalerOrders_WholesalerDetails_WholesalerLogo], [OrderManagement_OrderManagement_RetailerName], [WholesalerOrders_WholesalerDetails_OrderNumber], [WholesalerOrders_WholesalerDetails_TotalOrderAmountExclVAT], [WholesalerOrders_OrderManagement_ContactName], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountExclVAT], [WholesalerOrders_OrderManagement_EmailAddress], [WholesalerOrders_WholesalerDetails_Area], [WholesalerOrders_WholesalerDetails_OrderEmail], [WholesalerOrders_WholesalerDetails_PhoneNumber], [WholesalerOrders_WholesalerDetails_WholesalerUniqueName], [WholesalerOrders_OrderManagement_MobileNumber], [WholesalerOrders_OrderManagement_OrderNotes], [WholesalerOrders_WholesalerDetails_Address], [OrderManagement_OrderManagement_WholesalerInstructions], [WholesalerOrders_WholesalerDetails_OrderAdminFee], [WholesalerOrders_WholesalerDetails_ConfirmedAdminFee], [OrderManagement_OrderManagement_OrderDate], [WholesalerOrders_OrderManagement_EstimateCollectionDate], [WholesalerOrders_WholesalerDetails_PromotionExpires], [WholesalerOrders_WholesalerDetails_TotalOrderAmountInclVAT], [OrderManagement_OrderManagement_WholesalerOrderStatus], [WholesalerOrders_WholesalerDetails_BalanceAfterOrdering], [WholesalerOrders_WholesalerDetails_ConfirmedOrderAmountInclVAT], [WholesalerOrders_OrderManagement_PrintOrder], [WholesalerOrders_OrderManagement_EmailOrder], [WholesalerOrders_WholesalerDetails_REAPtechAdminFee], [WholesalerOrders_WholesalerDetails_ExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_ConfirmedExtraGPZARTotal], [WholesalerOrders_WholesalerDetails_OrderStatus], [WholesalerOrders_WholesalerDetails_AvailableBalance], [WholesalerOrders_WholesalerDetails_LastUpdate], [WholesalerOrders_WholesalerDetails_UpdatedBy], [WholesalerOrders_WholesalerDetails_SendOrder], [WholesalerOrders_WholesalerDetails_OrderCreated], [WholesalerOrders_WholesalerDetails_AccountTopup], [recId]) VALUES (81434, 1, 3094, 81424, N'7006/03f2cb31-a4d9-4fc2-9cba-84e9cb35b5ab.png', N'Dylan Test Retailer', N'S0005-PO-14', CAST(278.00 AS Decimal(18, 2)), N'', CAST(0.00 AS Decimal(18, 2)), N'', N'Pretoria', N'sales@advancecashncarry.co.za', N'0123796050', N'Advance Cash and Carry (Pretoria)', N'', N'', N'Cnr Moot Street and Es''kia Mphahlele Drive,  Hermanstad,  Pretoria,  Gauteng,  South Africa,  , ', N'', CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(N'2020-02-05T00:00:00.000' AS DateTime), CAST(319.70 AS Decimal(18, 2)), 1551, CAST(0.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), NULL, NULL, CAST(0.00 AS Decimal(18, 2)), CAST(126.00 AS Decimal(18, 2)), CAST(0.00 AS Decimal(18, 2)), N'Promotion Expired', CAST(0.00 AS Decimal(18, 2)), N'2020-02-06 14:23:00', N'Dylan Reevell', NULL, N'', NULL, 14)
SET IDENTITY_INSERT [dbo].[publ_WholesalerOrders] OFF;

END;