SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE [dbo].[AuthUser](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](64) NOT NULL,
	[Username] [nvarchar](128) NOT NULL,
	[Email] [nvarchar](128) NOT NULL,
	[FirstName] [nvarchar](32) NULL,
	[LastName] [nvarchar](32) NULL,
	[FilterPortfolios] [bit] NOT NULL,
	[FilterSchedules] [bit] NOT NULL,
	[FilterMasterLeases] [bit] NOT NULL,
	[FilterUDFs] [bit] NOT NULL,

 CONSTRAINT [PK__AuthUser1__3214EC2702084FDA] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF
, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON
, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[AuthUser] ON
INSERT [dbo].[AuthUser] ([ID], [Name], [Username], [Email], [FirstName], [LastName], [FilterPortfolios], [FilterSchedules], [FilterMasterLeases], [FilterUDFs]) VALUES (88, N'Edward C', N'Edward.c@.com', N'88@.com', N'Edward', N'C', 1, 1, 1, 0)
INSERT [dbo].[AuthUser] ([ID], [Name], [Username], [Email], [FirstName], [LastName], [FilterPortfolios], [FilterSchedules], [FilterMasterLeases], [FilterUDFs]) VALUES (14307, N'Camilla Test', N'camilla.T@.com', N'14307@.com', N'Camilla', N'Test', 0, 0, 0, 0)

SET IDENTITY_INSERT [dbo].[AuthUser] OFF

2 rows affected

select * from AuthUser


ID
Name
Username
Email
FirstName
LastName
FilterPortfolios
FilterSchedules
FilterMasterLeases
FilterUDFs


88
Edward C
Edward.c@.com
88@.com
Edward
C
True
True
True
False

14307
Camilla Test
camilla.T@.com
14307@.com
Camilla
Test
False
False
False
False


/****** Object:  Table [dbo].[Portfolio]    Script Date: 12/29/2018 8:16:16 PM ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[Portfolio](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](256) NULL,
	[ShortName] [varchar](5) NULL,
	[DefaultCultureId] [int] NOT NULL,
	[IsoCode] [char](3) NULL,
	[SourceSystemID] [int] NULL,
	[PortfolioID_SrcPK] [int] NULL,
	[API_CodeInSchedule] [nvarchar](125) NULL,
 CONSTRAINT [PK_Portfolio] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[Portfolio] ON
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (1, N'USA', N'US', 4, N'USA', 1, 1, N'US|USA')
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (2, N'Canada', N'CA', 2, N'CAN', 1, 2, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (3, N'United Kingdom', N'UK', 3, N'GBR', 2, 1, N'UK')
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (4, N'India', N'IN', 3, N'IND', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (5, N'Norway', N'NO', 3, N'NOR', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (6, N'Sweden', N'SE', 3, N'SWE', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (7, N'Czech Republic', N'CZ', 31, N'CZE', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (8, N'Slovakia', N'SK', 30, N'SVN', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (9, N'Poland', N'PL', 29, N'POL', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (10, N'Portugal', N'PT', 28, N'PRT', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (11, N'Germany', N'DE', 6, N'DEU', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (12, N'Italy', N'IT', 27, N'ITA', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (13, N'Spain', N'ES', 5, N'ESP', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (14, N'France', N'FR', 7, N'FRA', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (15, N'Brazil', N'BR', 26, N'BRA', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (16, N'Chile', N'CL', 25, N'CHL', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (17, N'Colombia', N'CO', 22, N'COL', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (18, N'Peru', N'PE', 21, N'PER', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (19, N'Costa Rica', N'CR', 20, N'CRI', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (20, N'El Salvador', N'SV', 19, N'SLV', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (21, N'Guatemala', N'GT', 18, N'GTM', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (22, N'Panama', N'PA', 17, N'PAN', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (23, N'Puerto Rico', N'PR', 16, N'PRI', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (24, N'Dominican Republic', N'DO', 15, N'DOM', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (25, N'Honduras', N'HN', 14, N'HND', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (26, N'Mexico', N'MX', 13, N'MEX', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (27, N'China', N'CN', 12, N'CHN', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (28, N'Hong Kong', N'HK', 11, N'HKG', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (29, N'Singapore', N'SG', 33, N'SGP', NULL, NULL, N'SG')
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (30, N'Malaysia', N'MY', 32, N'MYS', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (31, N'Australia', N'AU', 10, N'AUS', NULL, NULL, N'AU|AUS')
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (32, N'New Zealand', N'NZ', 10, N'NZL', NULL, NULL, NULL)
INSERT [dbo].[Portfolio] ([ID], [Name], [ShortName], [DefaultCultureId], [IsoCode], [SourceSystemID], [PortfolioID_SrcPK], [API_CodeInSchedule]) VALUES (33, N'Nicaragua', N'NI', 61, N'ESI', NULL, NULL, NULL)

SET IDENTITY_INSERT [dbo].[Portfolio] OFF
33 rows affected

/****** Object:  Table [dbo].[AuthUserPortfolio]    Script Date: 12/29/2018 8:04:55 PM ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[AuthUserPortfolio](
	[AuthUserId] [int] NOT NULL,
	[PortfolioId] [int] NOT NULL,
 CONSTRAINT [PK_AuthUserPortfolio] PRIMARY KEY CLUSTERED 
(
	[AuthUserId] ASC,
	[PortfolioId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

INSERT [dbo].[AuthUserPortfolio] ([AuthUserId],[PortfolioId])
VALUES
 (88,1), (88,2)
;
2 rows affected

declare @userid integer = 88

select p.*
from Portfolio p
where (
   0 = (select FilterPortfolios from AuthUser where id = @Userid) /* chack at user level for access to all portfolios */
   OR
   p.id in (select PortfolioId from AuthUserPortfolio where AuthUserId = @Userid) /* check by portfolio level */
   )
   


ID
Name
ShortName
DefaultCultureId
IsoCode
SourceSystemID
PortfolioID_SrcPK
API_CodeInSchedule


1
USA
US
4
USA
1
1
US|USA

2
Canada
CA
2
CAN
1
2
null


declare @userid integer = 14307

select p.*
from Portfolio p
where (
   0 = (select FilterPortfolios from AuthUser where id = @Userid) /* chack at user level for access to all portfolios */
   OR
   p.id in (select PortfolioId from AuthUserPortfolio where AuthUserId = @Userid) /* check by portfolio level */
   )
   


ID
Name
ShortName
DefaultCultureId
IsoCode
SourceSystemID
PortfolioID_SrcPK
API_CodeInSchedule


1
USA
US
4
USA
1
1
US|USA

2
Canada
CA
2
CAN
1
2
null

3
United Kingdom
UK
3
GBR
2
1
UK

4
India
IN
3
IND
null
null
null

5
Norway
NO
3
NOR
null
null
null

6
Sweden
SE
3
SWE
null
null
null

7
Czech Republic
CZ
31
CZE
null
null
null

8
Slovakia
SK
30
SVN
null
null
null

9
Poland
PL
29
POL
null
null
null

10
Portugal
PT
28
PRT
null
null
null

11
Germany
DE
6
DEU
null
null
null

12
Italy
IT
27
ITA
null
null
null

13
Spain
ES
5
ESP
null
null
null

14
France
FR
7
FRA
null
null
null

15
Brazil
BR
26
BRA
null
null
null

16
Chile
CL
25
CHL
null
null
null

17
Colombia
CO
22
COL
null
null
null

18
Peru
PE
21
PER
null
null
null

19
Costa Rica
CR
20
CRI
null
null
null

20
El Salvador
SV
19
SLV
null
null
null

21
Guatemala
GT
18
GTM
null
null
null

22
Panama
PA
17
PAN
null
null
null

23
Puerto Rico
PR
16
PRI
null
null
null

24
Dominican Republic
DO
15
DOM
null
null
null

25
Honduras
HN
14
HND
null
null
null

26
Mexico
MX
13
MEX
null
null
null

27
China
CN
12
CHN
null
null
null

28
Hong Kong
HK
11
HKG
null
null
null

29
Singapore
SG
33
SGP
null
null
SG

30
Malaysia
MY
32
MYS
null
null
null

31
Australia
AU
10
AUS
null
null
AU|AUS

32
New Zealand
NZ
10
NZL
null
null
null

33
Nicaragua
NI
61
ESI
null
null
null


/****** Object:  Table [dbo].[AuthUserFilter]    Script Date: 12/29/2018 8:04:54 PM ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[AuthUserFilter](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[FilterType] [nchar](1) NOT NULL,
	[Include] [nvarchar](64) NOT NULL,
 CONSTRAINT [PK_AuthUserFilter] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
/****** Object:  Table [dbo].[AuthUserMasterLease]    Script Date: 12/29/2018 8:04:55 PM ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[AuthUserMasterLease](
	[AuthUserId] [int] NOT NULL,
	[MasterLeaseId] [int] NOT NULL,
 CONSTRAINT [PK_AuthUserMasterLease] PRIMARY KEY CLUSTERED 
(
	[AuthUserId] ASC,
	[MasterLeaseId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]


INSERT [dbo].[AuthUserMasterLease] ([AuthUserId],[MasterLeaseId])
VALUES
 (88,1), (88,2)
;
2 rows affected

/****** Object:  Table [dbo].[AuthUserSchedule]    Script Date: 12/29/2018 8:04:55 PM ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[AuthUserSchedule](
	[AuthUserId] [int] NOT NULL,
	[ScheduleId] [int] NOT NULL,
 CONSTRAINT [PK_AuthUserSchedule] PRIMARY KEY CLUSTERED 
(
	[AuthUserId] ASC,
	[ScheduleId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[AuthUserFilter] ON 

INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (11014, 1206, N'U', N'0625')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (11129, 1242, N'U', N'0133')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (13582, 1326, N'U', N'8423')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (18228, 1718, N'U', N'test')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (18306, 2048, N'U', N'1003')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (18536, 2162, N'U', N'MKIC-FG')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (18537, 2162, N'U', N'MKIC')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (19308, 3703, N'U', N'29602A')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (19309, 3703, N'U', N'92231A')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (19310, 3703, N'U', N'92618A')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20383, 5053, N'U', N'29602A')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20778, 5171, N'U', N'Actuant Electrical')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20779, 5171, N'U', N'Actuant Energy')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20780, 5171, N'U', N'BW Elliott')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20781, 5171, N'U', N'Corporate')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20782, 5171, N'U', N'Corporate AP')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20783, 5171, N'U', N'Corporate Audit')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20784, 5171, N'U', N'Corporate CEO')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20785, 5171, N'U', N'Corporate Collections')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20786, 5171, N'U', N'Corporate Energy')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20787, 5171, N'U', N'Corporate Engineered Solutions')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20788, 5171, N'U', N'Corporate Finance')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20789, 5171, N'U', N'Corporate HR')
INSERT [dbo].[AuthUserFilter] ([ID], [UserID], [FilterType], [Include]) VALUES (20790, 5171, N'U', N'Corporate Industrial Segment')

SET IDENTITY_INSERT [dbo].[AuthUserFilter] OFF
24 rows affected

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[masterlease](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[LeaseNo] [nvarchar](80) NOT NULL,
	[AccountRepID] [int] NULL,
	[CustomerName] [nvarchar](100) NOT NULL,
	[UdFilterLabel] [nvarchar](32) NULL,
	[UdfLabel1] [nvarchar](32) NULL,
	[UdfLabel2] [nvarchar](32) NULL,
	[UdfLabel3] [nvarchar](32) NULL,
	[UdfLabel4] [nvarchar](32) NULL,
	[UdfLabel5] [nvarchar](32) NULL,
	[UdfLabel6] [nvarchar](32) NULL,
	[UdfLabel7] [nvarchar](32) NULL,
	[UdfLabel8] [nvarchar](32) NULL,
	[UdfLabel9] [nvarchar](32) NULL,
	[UdfLabel10] [nvarchar](32) NULL,
	[WhenUpdated] [datetime] NOT NULL,
	[Deleted] [bit] NOT NULL,
	[DeletedDate] [date] NULL,
	[PortfolioID] [int] NULL,
	[Active] [bit] NOT NULL,
	[International] [bit] NOT NULL,
	[LastModified] [datetime] NULL,
	[ExternalID] [nvarchar](50) NULL,
	[ExternalSourceId] [int] NULL,
	[ShowArchivedData] [bit] NOT NULL,
	[KeyCdfColumn] [int] NULL
) ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[masterlease] ON 

INSERT [dbo].[masterlease] ([ID], [LeaseNo], [AccountRepID], [CustomerName], [UdFilterLabel], [UdfLabel1], [UdfLabel2], [UdfLabel3], [UdfLabel4], [UdfLabel5], [UdfLabel6], [UdfLabel7], [UdfLabel8], [UdfLabel9], [UdfLabel10], [WhenUpdated], [Deleted], [DeletedDate], [PortfolioID], [Active], [International], [LastModified], [ExternalID], [ExternalSourceId], [ShowArchivedData], [KeyCdfColumn]) VALUES (1, N'104972', 82, N'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2013-02-04T18:10:41.620' AS DateTime), 1, CAST(N'2015-08-29' AS Date), 1, 1, 0, CAST(N'2015-06-22T20:15:19.990' AS DateTime), NULL, NULL, 0, NULL)
INSERT [dbo].[masterlease] ([ID], [LeaseNo], [AccountRepID], [CustomerName], [UdFilterLabel], [UdfLabel1], [UdfLabel2], [UdfLabel3], [UdfLabel4], [UdfLabel5], [UdfLabel6], [UdfLabel7], [UdfLabel8], [UdfLabel9], [UdfLabel10], [WhenUpdated], [Deleted], [DeletedDate], [PortfolioID], [Active], [International], [LastModified], [ExternalID], [ExternalSourceId], [ShowArchivedData], [KeyCdfColumn]) VALUES (2, N'107414', 81, N'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2013-02-04T18:10:41.620' AS DateTime), 1, CAST(N'2016-05-31' AS Date), 1, 1, 0, CAST(N'2015-06-22T20:15:19.990' AS DateTime), NULL, NULL, 0, NULL)
INSERT [dbo].[masterlease] ([ID], [LeaseNo], [AccountRepID], [CustomerName], [UdFilterLabel], [UdfLabel1], [UdfLabel2], [UdfLabel3], [UdfLabel4], [UdfLabel5], [UdfLabel6], [UdfLabel7], [UdfLabel8], [UdfLabel9], [UdfLabel10], [WhenUpdated], [Deleted], [DeletedDate], [PortfolioID], [Active], [International], [LastModified], [ExternalID], [ExternalSourceId], [ShowArchivedData], [KeyCdfColumn]) VALUES (3, N'110602A', 79, N'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2013-02-04T18:10:41.620' AS DateTime), 1, CAST(N'2016-01-02' AS Date), 1, 1, 0, CAST(N'2015-06-22T20:15:19.990' AS DateTime), NULL, NULL, 0, NULL)
INSERT [dbo].[masterlease] ([ID], [LeaseNo], [AccountRepID], [CustomerName], [UdFilterLabel], [UdfLabel1], [UdfLabel2], [UdfLabel3], [UdfLabel4], [UdfLabel5], [UdfLabel6], [UdfLabel7], [UdfLabel8], [UdfLabel9], [UdfLabel10], [WhenUpdated], [Deleted], [DeletedDate], [PortfolioID], [Active], [International], [LastModified], [ExternalID], [ExternalSourceId], [ShowArchivedData], [KeyCdfColumn]) VALUES (4, N'116817', 72, N'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2013-02-04T18:10:41.620' AS DateTime), 1, CAST(N'2015-06-13' AS Date), 1, 1, 0, CAST(N'2015-06-22T20:15:19.990' AS DateTime), NULL, NULL, 0, NULL)
INSERT [dbo].[masterlease] ([ID], [LeaseNo], [AccountRepID], [CustomerName], [UdFilterLabel], [UdfLabel1], [UdfLabel2], [UdfLabel3], [UdfLabel4], [UdfLabel5], [UdfLabel6], [UdfLabel7], [UdfLabel8], [UdfLabel9], [UdfLabel10], [WhenUpdated], [Deleted], [DeletedDate], [PortfolioID], [Active], [International], [LastModified], [ExternalID], [ExternalSourceId], [ShowArchivedData], [KeyCdfColumn]) VALUES (5, N'119720', 82, N'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2013-02-04T18:10:41.620' AS DateTime), 0, NULL, 1, 1, 0, CAST(N'2015-06-22T20:15:19.990' AS DateTime), N'14', NULL, 0, NULL)
INSERT [dbo].[masterlease] ([ID], [LeaseNo], [AccountRepID], [CustomerName], [UdFilterLabel], [UdfLabel1], [UdfLabel2], [UdfLabel3], [UdfLabel4], [UdfLabel5], [UdfLabel6], [UdfLabel7], [UdfLabel8], [UdfLabel9], [UdfLabel10], [WhenUpdated], [Deleted], [DeletedDate], [PortfolioID], [Active], [International], [LastModified], [ExternalID], [ExternalSourceId], [ShowArchivedData], [KeyCdfColumn]) VALUES (6, N'130819', NULL, N'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2013-02-04T18:10:41.620' AS DateTime), 0, NULL, 1, 1, 0, CAST(N'2015-06-22T20:15:19.990' AS DateTime), N'15', NULL, 0, NULL)
INSERT [dbo].[masterlease] ([ID], [LeaseNo], [AccountRepID], [CustomerName], [UdFilterLabel], [UdfLabel1], [UdfLabel2], [UdfLabel3], [UdfLabel4], [UdfLabel5], [UdfLabel6], [UdfLabel7], [UdfLabel8], [UdfLabel9], [UdfLabel10], [WhenUpdated], [Deleted], [DeletedDate], [PortfolioID], [Active], [International], [LastModified], [ExternalID], [ExternalSourceId], [ShowArchivedData], [KeyCdfColumn]) VALUES (7, N'131582', 81, N'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2013-02-04T18:10:41.620' AS DateTime), 0, NULL, 1, 1, 0, CAST(N'2015-06-22T20:15:19.990' AS DateTime), N'17', NULL, 0, NULL)
INSERT [dbo].[masterlease] ([ID], [LeaseNo], [AccountRepID], [CustomerName], [UdFilterLabel], [UdfLabel1], [UdfLabel2], [UdfLabel3], [UdfLabel4], [UdfLabel5], [UdfLabel6], [UdfLabel7], [UdfLabel8], [UdfLabel9], [UdfLabel10], [WhenUpdated], [Deleted], [DeletedDate], [PortfolioID], [Active], [International], [LastModified], [ExternalID], [ExternalSourceId], [ShowArchivedData], [KeyCdfColumn]) VALUES (8, N'131841', 75, N'test', N'Budget Code', N'Asset Tag', N'Department', N'Budget Code', NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2013-02-04T18:10:41.620' AS DateTime), 0, NULL, 1, 1, 0, CAST(N'2015-06-22T20:15:19.990' AS DateTime), N'18', NULL, 0, 3)

SET IDENTITY_INSERT [dbo].[masterlease] OFF
8 rows affected

declare @userid integer = 88

select ml.*
from masterlease ml
where (
   0 = (select FilterMasterLeases from AuthUser where id = @Userid) /* chack at user level for access to all portfolios */
   OR
   ml.id in (select MasterLeaseId from AuthUserMasterLease where AuthUserId = @Userid) /* check by object instance level */
   )
   


ID
LeaseNo
AccountRepID
CustomerName
UdFilterLabel
UdfLabel1
UdfLabel2
UdfLabel3
UdfLabel4
UdfLabel5
UdfLabel6
UdfLabel7
UdfLabel8
UdfLabel9
UdfLabel10
WhenUpdated
Deleted
DeletedDate
PortfolioID
Active
International
LastModified
ExternalID
ExternalSourceId
ShowArchivedData
KeyCdfColumn


1
104972
82
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
True
29/08/2015 00:00:00
1
True
False
22/06/2015 20:15:19
null
null
False
null

2
107414
81
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
True
31/05/2016 00:00:00
1
True
False
22/06/2015 20:15:19
null
null
False
null


declare @userid integer = 14307

select ml.*
from masterlease ml
where (
   0 = (select FilterMasterLeases from AuthUser where id = @Userid) /* chack at user level for access to all portfolios */
   OR
   ml.id in (select MasterLeaseId from AuthUserMasterLease where AuthUserId = @Userid) /* check by object instance level */
   )
   


ID
LeaseNo
AccountRepID
CustomerName
UdFilterLabel
UdfLabel1
UdfLabel2
UdfLabel3
UdfLabel4
UdfLabel5
UdfLabel6
UdfLabel7
UdfLabel8
UdfLabel9
UdfLabel10
WhenUpdated
Deleted
DeletedDate
PortfolioID
Active
International
LastModified
ExternalID
ExternalSourceId
ShowArchivedData
KeyCdfColumn


1
104972
82
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
True
29/08/2015 00:00:00
1
True
False
22/06/2015 20:15:19
null
null
False
null

2
107414
81
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
True
31/05/2016 00:00:00
1
True
False
22/06/2015 20:15:19
null
null
False
null

3
110602A
79
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
True
02/01/2016 00:00:00
1
True
False
22/06/2015 20:15:19
null
null
False
null

4
116817
72
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
True
13/06/2015 00:00:00
1
True
False
22/06/2015 20:15:19
null
null
False
null

5
119720
82
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
False
null
1
True
False
22/06/2015 20:15:19
14
null
False
null

6
130819
null
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
False
null
1
True
False
22/06/2015 20:15:19
15
null
False
null

7
131582
81
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
False
null
1
True
False
22/06/2015 20:15:19
17
null
False
null

8
131841
75
test
Budget Code
Asset Tag
Department
Budget Code
null
null
null
null
null
null
null
04/02/2013 18:10:41
False
null
1
True
False
22/06/2015 20:15:19
18
null
False
3


/****** Object:  Table [dbo].[schedule]    Script Date: 12/29/2018 10:59:23 PM ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[schedule](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Sched] [nvarchar](32) NOT NULL,
	[MasterLeaseID] [int] NOT NULL,
	[DateLeaseStarted] [date] NULL,
	[Term] [int] NULL,
	[TermUnitCode] [nchar](1) NULL,
	[DateLeaseEnds] [date] NULL,
	[Billing] [nvarchar](40) NULL,
	[Rent] [money] NULL,
	[Tax] [money] NULL,
	[LesseeCode] [nvarchar](64) NULL,
	[LesseeName] [nvarchar](100) NULL,
	[Insurance] [nvarchar](64) NULL,
	[FreqCode] [nvarchar](2) NULL,
	[PayFormCode] [nvarchar](2) NULL,
	[CurrCode] [nvarchar](10) NULL,
	[Ordering] [nvarchar](30) NULL,
	[Location] [nvarchar](100) NULL,
	[DateDeleted] [date] NULL,
	[AccountRepID] [int] NULL,
	[Deleted] [bit] NOT NULL,
	[International] [bit] NOT NULL,
	[Status] [int] NOT NULL,
	[DeleteDate] [date] NULL,
	[LastModified] [datetime] NULL,
	[ExternalID] [nvarchar](50) NULL,
	[ExternalSourceId] [int] NULL,
	[DebtRate] [decimal](18, 2) NULL,
	[NewHardwareCost] [decimal](18, 2) NULL,
	[OriginalEquipmentCost] [decimal](18, 2) NULL,
	[Margin] [decimal](18, 2) NULL,
	[ResidualValue] [decimal](18, 2) NULL,
	[FinalPV] [decimal](18, 2) NULL,
	[InterimRent] [decimal](18, 2) NULL,
	[VendorInvoiceTotal] [decimal](18, 2) NULL,
	[ScheduleInsurance] [decimal](18, 2) NULL,
	[Comment] [nvarchar](4000) NULL,
	[USGAAPType] [nvarchar](20) NULL
) ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[schedule] ON 

INSERT [dbo].[schedule] ([ID], [Sched], [MasterLeaseID], [DateLeaseStarted], [Term], [TermUnitCode], [DateLeaseEnds], [Billing], [Rent], [Tax], [LesseeCode], [LesseeName], [Insurance], [FreqCode], [PayFormCode], [CurrCode], [Ordering], [Location], [DateDeleted], [AccountRepID], [Deleted], [International], [Status], [DeleteDate], [LastModified], [ExternalID], [ExternalSourceId], [DebtRate], [NewHardwareCost], [OriginalEquipmentCost], [Margin], [ResidualValue], [FinalPV], [InterimRent], [VendorInvoiceTotal], [ScheduleInsurance], [Comment], [USGAAPType]) VALUES (8, N'174', 5, CAST(N'2011-06-01' AS Date), 36, NULL, CAST(N'2014-05-31' AS Date), N'MONTHLY IN ADVANCE', 2982.7100, 0.0000, N'test', N'test', NULL, N'M ', N'AD', N'USD', NULL, NULL, NULL, 82, 0, 0, 2, NULL, CAST(N'2017-12-02T05:27:18.900' AS DateTime), NULL, NULL, NULL, NULL, CAST(115845.38 AS Decimal(18, 2)), NULL, CAST(3689.00 AS Decimal(18, 2)), NULL, CAST(0.00 AS Decimal(18, 2)), NULL, NULL, NULL, NULL)
INSERT [dbo].[schedule] ([ID], [Sched], [MasterLeaseID], [DateLeaseStarted], [Term], [TermUnitCode], [DateLeaseEnds], [Billing], [Rent], [Tax], [LesseeCode], [LesseeName], [Insurance], [FreqCode], [PayFormCode], [CurrCode], [Ordering], [Location], [DateDeleted], [AccountRepID], [Deleted], [International], [Status], [DeleteDate], [LastModified], [ExternalID], [ExternalSourceId], [DebtRate], [NewHardwareCost], [OriginalEquipmentCost], [Margin], [ResidualValue], [FinalPV], [InterimRent], [VendorInvoiceTotal], [ScheduleInsurance], [Comment], [USGAAPType]) VALUES (863, N'065', 112, CAST(N'2012-01-01' AS Date), 48, NULL, CAST(N'2015-12-31' AS Date), N'QUARTERLY IN ADVANCE', 499.4400, 31.2300, N'test', N'test', NULL, N'Q ', N'AD', N'USD', NULL, NULL, NULL, 79, 0, 0, 2, NULL, CAST(N'2017-12-02T05:27:18.900' AS DateTime), NULL, NULL, NULL, NULL, CAST(8172.88 AS Decimal(18, 2)), NULL, CAST(351.00 AS Decimal(18, 2)), NULL, CAST(0.00 AS Decimal(18, 2)), NULL, NULL, NULL, NULL)
INSERT [dbo].[schedule] ([ID], [Sched], [MasterLeaseID], [DateLeaseStarted], [Term], [TermUnitCode], [DateLeaseEnds], [Billing], [Rent], [Tax], [LesseeCode], [LesseeName], [Insurance], [FreqCode], [PayFormCode], [CurrCode], [Ordering], [Location], [DateDeleted], [AccountRepID], [Deleted], [International], [Status], [DeleteDate], [LastModified], [ExternalID], [ExternalSourceId], [DebtRate], [NewHardwareCost], [OriginalEquipmentCost], [Margin], [ResidualValue], [FinalPV], [InterimRent], [VendorInvoiceTotal], [ScheduleInsurance], [Comment], [USGAAPType]) VALUES (864, N'066', 112, CAST(N'2012-05-01' AS Date), 36, NULL, CAST(N'2015-04-30' AS Date), N'MONTHLY IN ADVANCE', 81.5500, 8.1600, N'test', N'test', NULL, N'M ', N'AD', N'USD', NULL, NULL, NULL, 79, 0, 0, 2, NULL, CAST(N'2018-10-18T04:40:32.810' AS DateTime), NULL, NULL, NULL, NULL, CAST(49342.79 AS Decimal(18, 2)), NULL, CAST(460.00 AS Decimal(18, 2)), NULL, CAST(0.00 AS Decimal(18, 2)), NULL, NULL, NULL, NULL)
INSERT [dbo].[schedule] ([ID], [Sched], [MasterLeaseID], [DateLeaseStarted], [Term], [TermUnitCode], [DateLeaseEnds], [Billing], [Rent], [Tax], [LesseeCode], [LesseeName], [Insurance], [FreqCode], [PayFormCode], [CurrCode], [Ordering], [Location], [DateDeleted], [AccountRepID], [Deleted], [International], [Status], [DeleteDate], [LastModified], [ExternalID], [ExternalSourceId], [DebtRate], [NewHardwareCost], [OriginalEquipmentCost], [Margin], [ResidualValue], [FinalPV], [InterimRent], [VendorInvoiceTotal], [ScheduleInsurance], [Comment], [USGAAPType]) VALUES (865, N'067', 112, CAST(N'2012-04-01' AS Date), 48, NULL, CAST(N'2016-03-31' AS Date), N'QUARTERLY IN ADVANCE', 233.2500, 14.5700, N'test', N'test', NULL, N'Q ', N'AD', N'USD', NULL, NULL, NULL, 79, 0, 0, 2, NULL, CAST(N'2018-12-04T08:15:10.127' AS DateTime), NULL, NULL, NULL, NULL, CAST(1638.12 AS Decimal(18, 2)), NULL, CAST(240.00 AS Decimal(18, 2)), NULL, CAST(0.00 AS Decimal(18, 2)), NULL, NULL, NULL, NULL)
INSERT [dbo].[schedule] ([ID], [Sched], [MasterLeaseID], [DateLeaseStarted], [Term], [TermUnitCode], [DateLeaseEnds], [Billing], [Rent], [Tax], [LesseeCode], [LesseeName], [Insurance], [FreqCode], [PayFormCode], [CurrCode], [Ordering], [Location], [DateDeleted], [AccountRepID], [Deleted], [International], [Status], [DeleteDate], [LastModified], [ExternalID], [ExternalSourceId], [DebtRate], [NewHardwareCost], [OriginalEquipmentCost], [Margin], [ResidualValue], [FinalPV], [InterimRent], [VendorInvoiceTotal], [ScheduleInsurance], [Comment], [USGAAPType]) VALUES (866, N'068', 112, CAST(N'2012-07-01' AS Date), 48, NULL, CAST(N'2016-06-30' AS Date), N'QUARTERLY IN ADVANCE', 5401.4800, 337.5000, N'test', N'test', NULL, N'Q ', N'AD', N'USD', NULL, NULL, NULL, 79, 0, 0, 2, NULL, CAST(N'2018-12-04T08:15:10.127' AS DateTime), NULL, NULL, NULL, NULL, CAST(52835.08 AS Decimal(18, 2)), NULL, CAST(4229.00 AS Decimal(18, 2)), NULL, CAST(0.00 AS Decimal(18, 2)), NULL, NULL, NULL, NULL)
INSERT [dbo].[schedule] ([ID], [Sched], [MasterLeaseID], [DateLeaseStarted], [Term], [TermUnitCode], [DateLeaseEnds], [Billing], [Rent], [Tax], [LesseeCode], [LesseeName], [Insurance], [FreqCode], [PayFormCode], [CurrCode], [Ordering], [Location], [DateDeleted], [AccountRepID], [Deleted], [International], [Status], [DeleteDate], [LastModified], [ExternalID], [ExternalSourceId], [DebtRate], [NewHardwareCost], [OriginalEquipmentCost], [Margin], [ResidualValue], [FinalPV], [InterimRent], [VendorInvoiceTotal], [ScheduleInsurance], [Comment], [USGAAPType]) VALUES (1349, N'026', 182, CAST(N'2012-01-01' AS Date), 36, NULL, CAST(N'2014-12-31' AS Date), N'MONTHLY IN ADVANCE', 85.5900, 7.1200, N'test', N'test', NULL, N'M ', N'AD', N'USD', NULL, NULL, NULL, 82, 0, 0, 2, NULL, CAST(N'2018-04-04T04:08:52.860' AS DateTime), NULL, NULL, NULL, NULL, CAST(2817.80 AS Decimal(18, 2)), NULL, CAST(248.00 AS Decimal(18, 2)), NULL, CAST(0.00 AS Decimal(18, 2)), NULL, NULL, NULL, NULL)
INSERT [dbo].[schedule] ([ID], [Sched], [MasterLeaseID], [DateLeaseStarted], [Term], [TermUnitCode], [DateLeaseEnds], [Billing], [Rent], [Tax], [LesseeCode], [LesseeName], [Insurance], [FreqCode], [PayFormCode], [CurrCode], [Ordering], [Location], [DateDeleted], [AccountRepID], [Deleted], [International], [Status], [DeleteDate], [LastModified], [ExternalID], [ExternalSourceId], [DebtRate], [NewHardwareCost], [OriginalEquipmentCost], [Margin], [ResidualValue], [FinalPV], [InterimRent], [VendorInvoiceTotal], [ScheduleInsurance], [Comment], [USGAAPType]) VALUES (2263, N'002', 412, CAST(N'2011-08-01' AS Date), 60, NULL, CAST(N'2016-07-31' AS Date), N'MONTHLY IN ADVANCE', 672.5000, 87.4500, N'test', N'test', NULL, N'M ', N'AD', N'CAD', NULL, NULL, NULL, 87, 0, 0, 2, NULL, CAST(N'2018-01-27T05:20:32.207' AS DateTime), NULL, NULL, NULL, NULL, CAST(33527.00 AS Decimal(18, 2)), NULL, CAST(675.00 AS Decimal(18, 2)), NULL, CAST(0.00 AS Decimal(18, 2)), NULL, NULL, NULL, NULL)
INSERT [dbo].[schedule] ([ID], [Sched], [MasterLeaseID], [DateLeaseStarted], [Term], [TermUnitCode], [DateLeaseEnds], [Billing], [Rent], [Tax], [LesseeCode], [LesseeName], [Insurance], [FreqCode], [PayFormCode], [CurrCode], [Ordering], [Location], [DateDeleted], [AccountRepID], [Deleted], [International], [Status], [DeleteDate], [LastModified], [ExternalID], [ExternalSourceId], [DebtRate], [NewHardwareCost], [OriginalEquipmentCost], [Margin], [ResidualValue], [FinalPV], [InterimRent], [VendorInvoiceTotal], [ScheduleInsurance], [Comment], [USGAAPType]) VALUES (2446, N'023', 55, CAST(N'2011-10-01' AS Date), 60, NULL, CAST(N'2016-09-30' AS Date), N'MONTHLY IN ADVANCE', 726.8700, 64.6900, N'test', N'test', NULL, N'M ', N'AD', N'USD', NULL, NULL, NULL, 3706, 0, 0, 2, NULL, CAST(N'2018-06-19T03:49:39.090' AS DateTime), NULL, NULL, NULL, NULL, CAST(49981.85 AS Decimal(18, 2)), NULL, CAST(656.00 AS Decimal(18, 2)), NULL, CAST(0.00 AS Decimal(18, 2)), NULL, NULL, NULL, NULL)

SET IDENTITY_INSERT [dbo].[schedule] OFF
8 rows affected

/****** Object:  Table [dbo].[Unit]    Script Date: 12/29/2018 10:17:58 PM ******/
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[Unit](
	[ID] [bigint] NOT NULL,
	[ScheduleID] [int] NOT NULL,
	[SerialNo] [nvarchar](64) NULL,
	[Manufacturer] [nvarchar](64) NULL,
	[Model] [nvarchar](250) NULL,
	[Vendor] [nvarchar](64) NULL,
	[Quantity] [int] NULL,
	[DateAccepted] [date] NULL,
	[DateReturned] [date] NULL,
	[SiteName] [nvarchar](256) NULL,
	[SiteAddress] [nvarchar](256) NULL,
	[SiteAddress2] [nvarchar](256) NULL,
	[SiteCity] [nvarchar](256) NULL,
	[SiteState] [nvarchar](256) NULL,
	[SiteZip] [nvarchar](256) NULL,
	[SiteCountryCode] [nchar](3) NULL,
	[BillName] [nvarchar](256) NULL,
	[BillToAttn] [nvarchar](40) NULL,
	[BillAddress] [nvarchar](256) NULL,
	[BillAddress2] [nvarchar](256) NULL,
	[BillCity] [nvarchar](256) NULL,
	[BillState] [nvarchar](256) NULL,
	[BillZip] [nvarchar](256) NULL,
	[BillCountryCode] [nchar](3) NULL,
	[RemitName] [nvarchar](256) NULL,
	[RemitToAttn] [nvarchar](40) NULL,
	[RemitAddress] [nvarchar](256) NULL,
	[RemitAddress2] [nvarchar](256) NULL,
	[RemitCity] [nvarchar](256) NULL,
	[RemitState] [nvarchar](256) NULL,
	[RemitZip] [nvarchar](256) NULL,
	[RemitCountryCode] [nchar](3) NULL,
	[Rent] [money] NULL,
	[Tax] [money] NULL,
	[AssetInfo] [nvarchar](max) NULL,
	[DateIn] [date] NULL,
	[CustomerRef] [nvarchar](100) NULL,
	[UdFilterValue] [nvarchar](50) NULL,
	[Udf1] [nvarchar](50) NULL,
	[Udf2] [nvarchar](50) NULL,
	[Udf3] [nvarchar](50) NULL,
	[Udf4] [nvarchar](50) NULL,
	[Udf5] [nvarchar](50) NULL,
	[Udf6] [nvarchar](50) NULL,
	[Udf7] [nvarchar](50) NULL,
	[Udf8] [nvarchar](50) NULL,
	[Udf9] [nvarchar](50) NULL,
	[Udf10] [nvarchar](50) NULL,
	[CSIDataLocked] [bit] NOT NULL,
	[CustomerDataLocked] [bit] NOT NULL,
	[InventoryId] [int] NULL,
	[Deleted] [bit] NOT NULL,
	[DateDeleted] [date] NULL,
	[Description] [nvarchar](1000) NULL,
	[Returned] [bit] NULL,
	[UnitInsurance] [decimal](18, 2) NULL,
	[SiteLocale] [nvarchar](256) NULL,
	[SiteRegion] [nvarchar](256) NULL,
	[BillLocale] [nvarchar](256) NULL,
	[BillRegion] [nvarchar](256) NULL,
	[RemitLocale] [nvarchar](256) NULL,
	[RemitRegion] [nvarchar](256) NULL,
	[ExternalID] [nvarchar](50) NULL,
	[GeographyCoordinates] [nvarchar](100) NULL,
	[NonCsiLeased] [bit] NOT NULL,
	[LastModified] [datetime] NULL,
	[ExternalSourceId] [int] NULL,
	[Category] [nvarchar](50) NULL,
	[DateCreated] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

INSERT [dbo].[Unit] ([ID], [ScheduleID], [SerialNo], [Manufacturer], [Model], [Vendor], [Quantity], [DateAccepted], [DateReturned], [SiteName], [SiteAddress], [SiteAddress2], [SiteCity], [SiteState], [SiteZip], [SiteCountryCode], [BillName], [BillToAttn], [BillAddress], [BillAddress2], [BillCity], [BillState], [BillZip], [BillCountryCode], [RemitName], [RemitToAttn], [RemitAddress], [RemitAddress2], [RemitCity], [RemitState], [RemitZip], [RemitCountryCode], [Rent], [Tax], [AssetInfo], [DateIn], [CustomerRef], [UdFilterValue], [Udf1], [Udf2], [Udf3], [Udf4], [Udf5], [Udf6], [Udf7], [Udf8], [Udf9], [Udf10], [CSIDataLocked], [CustomerDataLocked], [InventoryId], [Deleted], [DateDeleted], [Description], [Returned], [UnitInsurance], [SiteLocale], [SiteRegion], [BillLocale], [BillRegion], [RemitLocale], [RemitRegion], [ExternalID], [GeographyCoordinates], [NonCsiLeased], [LastModified], [ExternalSourceId], [Category], [DateCreated]) VALUES (7000045, 35264, N'3CQ6110T8G', N'HP', N'23" LED MONITOR', N'test', 1, CAST(N'2016-07-06' AS Date), NULL, NULL, N'test', NULL, N'CAMPBELLFORD', N'ON', N'K0L 1L0', N'CAN', N'test', N'test', N'test', N'', N'Mississauga', N'ON', N'L5T 2J1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4.5900, 0.6000, N'(1) Main Box', CAST(N'2018-12-29' AS Date), N'017', NULL, N'017', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 2711863, 0, NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, CAST(N'2018-12-29T08:33:51.973' AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[Unit] ([ID], [ScheduleID], [SerialNo], [Manufacturer], [Model], [Vendor], [Quantity], [DateAccepted], [DateReturned], [SiteName], [SiteAddress], [SiteAddress2], [SiteCity], [SiteState], [SiteZip], [SiteCountryCode], [BillName], [BillToAttn], [BillAddress], [BillAddress2], [BillCity], [BillState], [BillZip], [BillCountryCode], [RemitName], [RemitToAttn], [RemitAddress], [RemitAddress2], [RemitCity], [RemitState], [RemitZip], [RemitCountryCode], [Rent], [Tax], [AssetInfo], [DateIn], [CustomerRef], [UdFilterValue], [Udf1], [Udf2], [Udf3], [Udf4], [Udf5], [Udf6], [Udf7], [Udf8], [Udf9], [Udf10], [CSIDataLocked], [CustomerDataLocked], [InventoryId], [Deleted], [DateDeleted], [Description], [Returned], [UnitInsurance], [SiteLocale], [SiteRegion], [BillLocale], [BillRegion], [RemitLocale], [RemitRegion], [ExternalID], [GeographyCoordinates], [NonCsiLeased], [LastModified], [ExternalSourceId], [Category], [DateCreated]) VALUES (7000046, 35264, N'CN45520HBR', N'HP', N'23" LED MONITOR', N'test', 1, CAST(N'2016-07-06' AS Date), NULL, NULL, N'test', NULL, N'FREDERICTON', N'NB', N'E3A 0T3', N'CAN', N'test', N'test', N'test', N'', N'Mississauga', N'ON', N'L5T 2J1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4.3500, 0.6500, N'(1) Main Box', CAST(N'2018-12-29' AS Date), N'337', NULL, N'337', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 2711757, 0, NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, CAST(N'2018-12-29T08:33:51.973' AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[Unit] ([ID], [ScheduleID], [SerialNo], [Manufacturer], [Model], [Vendor], [Quantity], [DateAccepted], [DateReturned], [SiteName], [SiteAddress], [SiteAddress2], [SiteCity], [SiteState], [SiteZip], [SiteCountryCode], [BillName], [BillToAttn], [BillAddress], [BillAddress2], [BillCity], [BillState], [BillZip], [BillCountryCode], [RemitName], [RemitToAttn], [RemitAddress], [RemitAddress2], [RemitCity], [RemitState], [RemitZip], [RemitCountryCode], [Rent], [Tax], [AssetInfo], [DateIn], [CustomerRef], [UdFilterValue], [Udf1], [Udf2], [Udf3], [Udf4], [Udf5], [Udf6], [Udf7], [Udf8], [Udf9], [Udf10], [CSIDataLocked], [CustomerDataLocked], [InventoryId], [Deleted], [DateDeleted], [Description], [Returned], [UnitInsurance], [SiteLocale], [SiteRegion], [BillLocale], [BillRegion], [RemitLocale], [RemitRegion], [ExternalID], [GeographyCoordinates], [NonCsiLeased], [LastModified], [ExternalSourceId], [Category], [DateCreated]) VALUES (7000047, 35264, N'MXL5510L8L', N'HP', N'ELITEDESK 800 G1 CI5 QC 3.3GHZ', N'test', 1, CAST(N'2016-05-19' AS Date), NULL, NULL, N'test', NULL, N'NEW GLASGOW', N'NS', N'B2H 2J6', N'CAN', N'test', N'test', N'test', N'', N'Mississauga', N'ON', N'L5T 2J1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 34.6300, 5.2000, N'(1) Main Box|(1) STARTECH  DESKTOP FEATURE', CAST(N'2018-12-29' AS Date), N'067', NULL, N'067', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 2672341, 0, NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, CAST(N'2018-12-29T08:33:51.973' AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[Unit] ([ID], [ScheduleID], [SerialNo], [Manufacturer], [Model], [Vendor], [Quantity], [DateAccepted], [DateReturned], [SiteName], [SiteAddress], [SiteAddress2], [SiteCity], [SiteState], [SiteZip], [SiteCountryCode], [BillName], [BillToAttn], [BillAddress], [BillAddress2], [BillCity], [BillState], [BillZip], [BillCountryCode], [RemitName], [RemitToAttn], [RemitAddress], [RemitAddress2], [RemitCity], [RemitState], [RemitZip], [RemitCountryCode], [Rent], [Tax], [AssetInfo], [DateIn], [CustomerRef], [UdFilterValue], [Udf1], [Udf2], [Udf3], [Udf4], [Udf5], [Udf6], [Udf7], [Udf8], [Udf9], [Udf10], [CSIDataLocked], [CustomerDataLocked], [InventoryId], [Deleted], [DateDeleted], [Description], [Returned], [UnitInsurance], [SiteLocale], [SiteRegion], [BillLocale], [BillRegion], [RemitLocale], [RemitRegion], [ExternalID], [GeographyCoordinates], [NonCsiLeased], [LastModified], [ExternalSourceId], [Category], [DateCreated]) VALUES (7000048, 35264, N'CN46111DD5', N'HP', N'23" LED MONITOR', N'test', 1, CAST(N'2016-07-06' AS Date), NULL, NULL, N'test', NULL, N'Gloucester', N'ON', N'K1T 0K8', N'CAN', N'test', N'test', N'test', N'', N'Mississauga', N'ON', N'L5T 2J1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4.5900, 0.6000, N'(1) Main Box', CAST(N'2018-12-29' AS Date), N'659', NULL, N'659', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 2711780, 0, NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, CAST(N'2018-12-29T08:33:51.973' AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[Unit] ([ID], [ScheduleID], [SerialNo], [Manufacturer], [Model], [Vendor], [Quantity], [DateAccepted], [DateReturned], [SiteName], [SiteAddress], [SiteAddress2], [SiteCity], [SiteState], [SiteZip], [SiteCountryCode], [BillName], [BillToAttn], [BillAddress], [BillAddress2], [BillCity], [BillState], [BillZip], [BillCountryCode], [RemitName], [RemitToAttn], [RemitAddress], [RemitAddress2], [RemitCity], [RemitState], [RemitZip], [RemitCountryCode], [Rent], [Tax], [AssetInfo], [DateIn], [CustomerRef], [UdFilterValue], [Udf1], [Udf2], [Udf3], [Udf4], [Udf5], [Udf6], [Udf7], [Udf8], [Udf9], [Udf10], [CSIDataLocked], [CustomerDataLocked], [InventoryId], [Deleted], [DateDeleted], [Description], [Returned], [UnitInsurance], [SiteLocale], [SiteRegion], [BillLocale], [BillRegion], [RemitLocale], [RemitRegion], [ExternalID], [GeographyCoordinates], [NonCsiLeased], [LastModified], [ExternalSourceId], [Category], [DateCreated]) VALUES (7000049, 35264, N'17501102909154', N'DYMO', N'LABEL WRITER 450 THERMAL PRINTER', N'test', 1, CAST(N'2016-07-06' AS Date), NULL, NULL, N'test', NULL, N'CHELMSFORD', N'ON', N'P0M 1L0', N'CAN', N'test', N'test', N'test', N'', N'Mississauga', N'ON', N'L5T 2J1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2.0300, 0.2600, N'(1) Main Box', CAST(N'2018-12-29' AS Date), N'244', NULL, N'244', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 2711465, 0, NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, CAST(N'2018-12-29T08:33:51.973' AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[Unit] ([ID], [ScheduleID], [SerialNo], [Manufacturer], [Model], [Vendor], [Quantity], [DateAccepted], [DateReturned], [SiteName], [SiteAddress], [SiteAddress2], [SiteCity], [SiteState], [SiteZip], [SiteCountryCode], [BillName], [BillToAttn], [BillAddress], [BillAddress2], [BillCity], [BillState], [BillZip], [BillCountryCode], [RemitName], [RemitToAttn], [RemitAddress], [RemitAddress2], [RemitCity], [RemitState], [RemitZip], [RemitCountryCode], [Rent], [Tax], [AssetInfo], [DateIn], [CustomerRef], [UdFilterValue], [Udf1], [Udf2], [Udf3], [Udf4], [Udf5], [Udf6], [Udf7], [Udf8], [Udf9], [Udf10], [CSIDataLocked], [CustomerDataLocked], [InventoryId], [Deleted], [DateDeleted], [Description], [Returned], [UnitInsurance], [SiteLocale], [SiteRegion], [BillLocale], [BillRegion], [RemitLocale], [RemitRegion], [ExternalID], [GeographyCoordinates], [NonCsiLeased], [LastModified], [ExternalSourceId], [Category], [DateCreated]) VALUES (7000066, 35264, N'061621163', N'HERO', N'A260-12E ARCHIMEDE COLORANT DISPENSE SYSTEM', N'test', 1, CAST(N'2016-06-22' AS Date), NULL, NULL, N'test', NULL, N'ROTHESAY', N'NB', N'E2E 2R3', N'CAN', N'test', N'test', N'test', N'', N'Mississauga', N'ON', N'L5T 2J1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 216.4600, 32.4700, N'(1) Main Box', CAST(N'2018-12-29' AS Date), N'476', NULL, N'476', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 2631952, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, CAST(N'2018-12-29T08:33:51.973' AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[Unit] ([ID], [ScheduleID], [SerialNo], [Manufacturer], [Model], [Vendor], [Quantity], [DateAccepted], [DateReturned], [SiteName], [SiteAddress], [SiteAddress2], [SiteCity], [SiteState], [SiteZip], [SiteCountryCode], [BillName], [BillToAttn], [BillAddress], [BillAddress2], [BillCity], [BillState], [BillZip], [BillCountryCode], [RemitName], [RemitToAttn], [RemitAddress], [RemitAddress2], [RemitCity], [RemitState], [RemitZip], [RemitCountryCode], [Rent], [Tax], [AssetInfo], [DateIn], [CustomerRef], [UdFilterValue], [Udf1], [Udf2], [Udf3], [Udf4], [Udf5], [Udf6], [Udf7], [Udf8], [Udf9], [Udf10], [CSIDataLocked], [CustomerDataLocked], [InventoryId], [Deleted], [DateDeleted], [Description], [Returned], [UnitInsurance], [SiteLocale], [SiteRegion], [BillLocale], [BillRegion], [RemitLocale], [RemitRegion], [ExternalID], [GeographyCoordinates], [NonCsiLeased], [LastModified], [ExternalSourceId], [Category], [DateCreated]) VALUES (7000068, 35264, N'17501102909151', N'DYMO', N'LABEL WRITER 450 THERMAL PRINTER', N'test', 1, CAST(N'2016-07-06' AS Date), NULL, NULL, N'test', NULL, N'COBOURG', N'ON', N'K9A 5T9', N'CAN', N'test', N'test', N'test', N'', N'Mississauga', N'ON', N'L5T 2J1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2.0300, 0.2600, N'(1) Main Box', CAST(N'2018-12-29' AS Date), N'023', NULL, N'023', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 2711500, 0, NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, CAST(N'2018-12-29T08:33:51.973' AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[Unit] ([ID], [ScheduleID], [SerialNo], [Manufacturer], [Model], [Vendor], [Quantity], [DateAccepted], [DateReturned], [SiteName], [SiteAddress], [SiteAddress2], [SiteCity], [SiteState], [SiteZip], [SiteCountryCode], [BillName], [BillToAttn], [BillAddress], [BillAddress2], [BillCity], [BillState], [BillZip], [BillCountryCode], [RemitName], [RemitToAttn], [RemitAddress], [RemitAddress2], [RemitCity], [RemitState], [RemitZip], [RemitCountryCode], [Rent], [Tax], [AssetInfo], [DateIn], [CustomerRef], [UdFilterValue], [Udf1], [Udf2], [Udf3], [Udf4], [Udf5], [Udf6], [Udf7], [Udf8], [Udf9], [Udf10], [CSIDataLocked], [CustomerDataLocked], [InventoryId], [Deleted], [DateDeleted], [Description], [Returned], [UnitInsurance], [SiteLocale], [SiteRegion], [BillLocale], [BillRegion], [RemitLocale], [RemitRegion], [ExternalID], [GeographyCoordinates], [NonCsiLeased], [LastModified], [ExternalSourceId], [Category], [DateCreated]) VALUES (7000070, 35264, N'061609634', N'HERO', N'A460-12E EUREKA COLORANT DISPENSE SYSTEM', N'test', 1, CAST(N'2016-07-21' AS Date), NULL, NULL, N'test', NULL, N'Hamilton', N'ON', N'L8H 2V4', N'CAN', N'test', N'test', N'test', N'', N'Mississauga', N'ON', N'L5T 2J1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 356.3000, 46.3200, N'(1) Main Box', CAST(N'2018-12-29' AS Date), N'129', NULL, N'129', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 2691571, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, CAST(N'2018-12-29T08:33:51.973' AS DateTime), NULL, NULL, NULL)
INSERT [dbo].[Unit] ([ID], [ScheduleID], [SerialNo], [Manufacturer], [Model], [Vendor], [Quantity], [DateAccepted], [DateReturned], [SiteName], [SiteAddress], [SiteAddress2], [SiteCity], [SiteState], [SiteZip], [SiteCountryCode], [BillName], [BillToAttn], [BillAddress], [BillAddress2], [BillCity], [BillState], [BillZip], [BillCountryCode], [RemitName], [RemitToAttn], [RemitAddress], [RemitAddress2], [RemitCity], [RemitState], [RemitZip], [RemitCountryCode], [Rent], [Tax], [AssetInfo], [DateIn], [CustomerRef], [UdFilterValue], [Udf1], [Udf2], [Udf3], [Udf4], [Udf5], [Udf6], [Udf7], [Udf8], [Udf9], [Udf10], [CSIDataLocked], [CustomerDataLocked], [InventoryId], [Deleted], [DateDeleted], [Description], [Returned], [UnitInsurance], [SiteLocale], [SiteRegion], [BillLocale], [BillRegion], [RemitLocale], [RemitRegion], [ExternalID], [GeographyCoordinates], [NonCsiLeased], [LastModified], [ExternalSourceId], [Category], [DateCreated]) VALUES (7000077, 35264, N'17501102980651', N'DYMO', N'LABEL WRITER 450 THERMAL PRINTER', N'test', 1, CAST(N'2016-11-30' AS Date), NULL, NULL, N'test', NULL, N'PENTICTON', N'BC', N'V2A 8N2', N'CAN', N'test', N'test', N'test', N'', N'Mississauga', N'ON', N'L5T 2J1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.8700, 0.2200, N'(1) Main Box', CAST(N'2018-12-29' AS Date), N'351', NULL, N'351', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 2846756, 0, NULL, N'', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, CAST(N'2018-12-29T08:33:51.973' AS DateTime), NULL, NULL, NULL)
9 rows affected

select 
    au.id, aus.*, aup.*, audf.*
FROM dbo.AuthUser au
LEFT JOIN AuthUserSchedule aus         ON au.id = aus.AuthUserId
LEFT JOIN dbo.AuthUserPortfolio aup    ON au.id = aup.AuthUserId
LEFT JOIN dbo.AuthUserMasterLease auml ON au.id = auml.AuthUserId
LEFT JOIN AuthUserFilter audf          ON au.id = audf.UserId


id
AuthUserId
ScheduleId
AuthUserId
PortfolioId
ID
UserID
FilterType
Include


88
null
null
88
1
null
null
null
null

88
null
null
88
1
null
null
null
null

88
null
null
88
2
null
null
null
null

88
null
null
88
2
null
null
null
null

14307
null
null
null
null
null
null
null
null


select * from AuthUser


ID
Name
Username
Email
FirstName
LastName
FilterPortfolios
FilterSchedules
FilterMasterLeases
FilterUDFs


88
Edward C
Edward.c@.com
88@.com
Edward
C
True
True
True
False

14307
Camilla Test
camilla.T@.com
14307@.com
Camilla
Test
False
False
False
False


select * from AuthUserPortfolio


AuthUserId
PortfolioId


88
1

88
2


select * from AuthUserFilter


ID
UserID
FilterType
Include


11014
1206
U
0625

11129
1242
U
0133

13582
1326
U
8423

18228
1718
U
test

18306
2048
U
1003

18536
2162
U
MKIC-FG

18537
2162
U
MKIC

19308
3703
U
29602A

19309
3703
U
92231A

19310
3703
U
92618A

20383
5053
U
29602A

20778
5171
U
Actuant Electrical

20779
5171
U
Actuant Energy

20780
5171
U
BW Elliott

20781
5171
U
Corporate

20782
5171
U
Corporate AP

20783
5171
U
Corporate Audit

20784
5171
U
Corporate CEO

20785
5171
U
Corporate Collections

20786
5171
U
Corporate Energy

20787
5171
U
Corporate Engineered Solutions

20788
5171
U
Corporate Finance

20789
5171
U
Corporate HR

20790
5171
U
Corporate Industrial Segment


select * from Portfolio


ID
Name
ShortName
DefaultCultureId
IsoCode
SourceSystemID
PortfolioID_SrcPK
API_CodeInSchedule


1
USA
US
4
USA
1
1
US|USA

2
Canada
CA
2
CAN
1
2
null

3
United Kingdom
UK
3
GBR
2
1
UK

4
India
IN
3
IND
null
null
null

5
Norway
NO
3
NOR
null
null
null

6
Sweden
SE
3
SWE
null
null
null

7
Czech Republic
CZ
31
CZE
null
null
null

8
Slovakia
SK
30
SVN
null
null
null

9
Poland
PL
29
POL
null
null
null

10
Portugal
PT
28
PRT
null
null
null

11
Germany
DE
6
DEU
null
null
null

12
Italy
IT
27
ITA
null
null
null

13
Spain
ES
5
ESP
null
null
null

14
France
FR
7
FRA
null
null
null

15
Brazil
BR
26
BRA
null
null
null

16
Chile
CL
25
CHL
null
null
null

17
Colombia
CO
22
COL
null
null
null

18
Peru
PE
21
PER
null
null
null

19
Costa Rica
CR
20
CRI
null
null
null

20
El Salvador
SV
19
SLV
null
null
null

21
Guatemala
GT
18
GTM
null
null
null

22
Panama
PA
17
PAN
null
null
null

23
Puerto Rico
PR
16
PRI
null
null
null

24
Dominican Republic
DO
15
DOM
null
null
null

25
Honduras
HN
14
HND
null
null
null

26
Mexico
MX
13
MEX
null
null
null

27
China
CN
12
CHN
null
null
null

28
Hong Kong
HK
11
HKG
null
null
null

29
Singapore
SG
33
SGP
null
null
SG

30
Malaysia
MY
32
MYS
null
null
null

31
Australia
AU
10
AUS
null
null
AU|AUS

32
New Zealand
NZ
10
NZL
null
null
null

33
Nicaragua
NI
61
ESI
null
null
null


select * from masterlease


ID
LeaseNo
AccountRepID
CustomerName
UdFilterLabel
UdfLabel1
UdfLabel2
UdfLabel3
UdfLabel4
UdfLabel5
UdfLabel6
UdfLabel7
UdfLabel8
UdfLabel9
UdfLabel10
WhenUpdated
Deleted
DeletedDate
PortfolioID
Active
International
LastModified
ExternalID
ExternalSourceId
ShowArchivedData
KeyCdfColumn


1
104972
82
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
True
29/08/2015 00:00:00
1
True
False
22/06/2015 20:15:19
null
null
False
null

2
107414
81
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
True
31/05/2016 00:00:00
1
True
False
22/06/2015 20:15:19
null
null
False
null

3
110602A
79
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
True
02/01/2016 00:00:00
1
True
False
22/06/2015 20:15:19
null
null
False
null

4
116817
72
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
True
13/06/2015 00:00:00
1
True
False
22/06/2015 20:15:19
null
null
False
null

5
119720
82
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
False
null
1
True
False
22/06/2015 20:15:19
14
null
False
null

6
130819
null
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
False
null
1
True
False
22/06/2015 20:15:19
15
null
False
null

7
131582
81
test
null
null
null
null
null
null
null
null
null
null
null
04/02/2013 18:10:41
False
null
1
True
False
22/06/2015 20:15:19
17
null
False
null

8
131841
75
test
Budget Code
Asset Tag
Department
Budget Code
null
null
null
null
null
null
null
04/02/2013 18:10:41
False
null
1
True
False
22/06/2015 20:15:19
18
null
False
3


select * from schedule


ID
Sched
MasterLeaseID
DateLeaseStarted
Term
TermUnitCode
DateLeaseEnds
Billing
Rent
Tax
LesseeCode
LesseeName
Insurance
FreqCode
PayFormCode
CurrCode
Ordering
Location
DateDeleted
AccountRepID
Deleted
International
Status
DeleteDate
LastModified
ExternalID
ExternalSourceId
DebtRate
NewHardwareCost
OriginalEquipmentCost
Margin
ResidualValue
FinalPV
InterimRent
VendorInvoiceTotal
ScheduleInsurance
Comment
USGAAPType


8
174
5
01/06/2011 00:00:00
36
null
31/05/2014 00:00:00
MONTHLY IN ADVANCE
2982.7100
0.0000
test
test
null
M
AD
USD
null
null
null
82
False
False
2
null
02/12/2017 05:27:18
null
null
null
null
115845.38
null
3689.00
null
0.00
null
null
null
null

863
065
112
01/01/2012 00:00:00
48
null
31/12/2015 00:00:00
QUARTERLY IN ADVANCE
499.4400
31.2300
test
test
null
Q
AD
USD
null
null
null
79
False
False
2
null
02/12/2017 05:27:18
null
null
null
null
8172.88
null
351.00
null
0.00
null
null
null
null

864
066
112
01/05/2012 00:00:00
36
null
30/04/2015 00:00:00
MONTHLY IN ADVANCE
81.5500
8.1600
test
test
null
M
AD
USD
null
null
null
79
False
False
2
null
18/10/2018 04:40:32
null
null
null
null
49342.79
null
460.00
null
0.00
null
null
null
null

865
067
112
01/04/2012 00:00:00
48
null
31/03/2016 00:00:00
QUARTERLY IN ADVANCE
233.2500
14.5700
test
test
null
Q
AD
USD
null
null
null
79
False
False
2
null
04/12/2018 08:15:10
null
null
null
null
1638.12
null
240.00
null
0.00
null
null
null
null

866
068
112
01/07/2012 00:00:00
48
null
30/06/2016 00:00:00
QUARTERLY IN ADVANCE
5401.4800
337.5000
test
test
null
Q
AD
USD
null
null
null
79
False
False
2
null
04/12/2018 08:15:10
null
null
null
null
52835.08
null
4229.00
null
0.00
null
null
null
null

1349
026
182
01/01/2012 00:00:00
36
null
31/12/2014 00:00:00
MONTHLY IN ADVANCE
85.5900
7.1200
test
test
null
M
AD
USD
null
null
null
82
False
False
2
null
04/04/2018 04:08:52
null
null
null
null
2817.80
null
248.00
null
0.00
null
null
null
null

2263
002
412
01/08/2011 00:00:00
60
null
31/07/2016 00:00:00
MONTHLY IN ADVANCE
672.5000
87.4500
test
test
null
M
AD
CAD
null
null
null
87
False
False
2
null
27/01/2018 05:20:32
null
null
null
null
33527.00
null
675.00
null
0.00
null
null
null
null

2446
023
55
01/10/2011 00:00:00
60
null
30/09/2016 00:00:00
MONTHLY IN ADVANCE
726.8700
64.6900
test
test
null
M
AD
USD
null
null
null
3706
False
False
2
null
19/06/2018 03:49:39
null
null
null
null
49981.85
null
656.00
null
0.00
null
null
null
null


select * from Unit
;


ID
ScheduleID
SerialNo
Manufacturer
Model
Vendor
Quantity
DateAccepted
DateReturned
SiteName
SiteAddress
SiteAddress2
SiteCity
SiteState
SiteZip
SiteCountryCode
BillName
BillToAttn
BillAddress
BillAddress2
BillCity
BillState
BillZip
BillCountryCode
RemitName
RemitToAttn
RemitAddress
RemitAddress2
RemitCity
RemitState
RemitZip
RemitCountryCode
Rent
Tax
AssetInfo
DateIn
CustomerRef
UdFilterValue
Udf1
Udf2
Udf3
Udf4
Udf5
Udf6
Udf7
Udf8
Udf9
Udf10
CSIDataLocked
CustomerDataLocked
InventoryId
Deleted
DateDeleted
Description
Returned
UnitInsurance
SiteLocale
SiteRegion
BillLocale
BillRegion
RemitLocale
RemitRegion
ExternalID
GeographyCoordinates
NonCsiLeased
LastModified
ExternalSourceId
Category
DateCreated


7000045
35264
3CQ6110T8G
HP
23" LED MONITOR
test
1
06/07/2016 00:00:00
null
null
test
null
CAMPBELLFORD
ON
K0L 1L0
CAN
test
test
test

Mississauga
ON
L5T 2J1
null
null
null
null
null
null
null
null
null
4.5900
0.6000
(1) Main Box
29/12/2018 00:00:00
017
null
017
null
null
null
null
null
null
null
null
null
False
False
2711863
False
null

null
null
null
null
null
null
null
null
null
null
False
29/12/2018 08:33:51
null
null
null

7000046
35264
CN45520HBR
HP
23" LED MONITOR
test
1
06/07/2016 00:00:00
null
null
test
null
FREDERICTON
NB
E3A 0T3
CAN
test
test
test

Mississauga
ON
L5T 2J1
null
null
null
null
null
null
null
null
null
4.3500
0.6500
(1) Main Box
29/12/2018 00:00:00
337
null
337
null
null
null
null
null
null
null
null
null
False
False
2711757
False
null

null
null
null
null
null
null
null
null
null
null
False
29/12/2018 08:33:51
null
null
null

7000047
35264
MXL5510L8L
HP
ELITEDESK 800 G1 CI5 QC 3.3GHZ
test
1
19/05/2016 00:00:00
null
null
test
null
NEW GLASGOW
NS
B2H 2J6
CAN
test
test
test

Mississauga
ON
L5T 2J1
null
null
null
null
null
null
null
null
null
34.6300
5.2000
(1) Main Box|(1) STARTECH  DESKTOP FEATURE
29/12/2018 00:00:00
067
null
067
null
null
null
null
null
null
null
null
null
False
False
2672341
False
null

null
null
null
null
null
null
null
null
null
null
False
29/12/2018 08:33:51
null
null
null

7000048
35264
CN46111DD5
HP
23" LED MONITOR
test
1
06/07/2016 00:00:00
null
null
test
null
Gloucester
ON
K1T 0K8
CAN
test
test
test

Mississauga
ON
L5T 2J1
null
null
null
null
null
null
null
null
null
4.5900
0.6000
(1) Main Box
29/12/2018 00:00:00
659
null
659
null
null
null
null
null
null
null
null
null
False
False
2711780
False
null

null
null
null
null
null
null
null
null
null
null
False
29/12/2018 08:33:51
null
null
null

7000049
35264
17501102909154
DYMO
LABEL WRITER 450 THERMAL PRINTER
test
1
06/07/2016 00:00:00
null
null
test
null
CHELMSFORD
ON
P0M 1L0
CAN
test
test
test

Mississauga
ON
L5T 2J1
null
null
null
null
null
null
null
null
null
2.0300
0.2600
(1) Main Box
29/12/2018 00:00:00
244
null
244
null
null
null
null
null
null
null
null
null
False
False
2711465
False
null

null
null
null
null
null
null
null
null
null
null
False
29/12/2018 08:33:51
null
null
null

7000066
35264
061621163
HERO
A260-12E ARCHIMEDE COLORANT DISPENSE SYSTEM
test
1
22/06/2016 00:00:00
null
null
test
null
ROTHESAY
NB
E2E 2R3
CAN
test
test
test

Mississauga
ON
L5T 2J1
null
null
null
null
null
null
null
null
null
216.4600
32.4700
(1) Main Box
29/12/2018 00:00:00
476
null
476
null
null
null
null
null
null
null
null
null
False
False
2631952
False
null
null
null
null
null
null
null
null
null
null
null
null
False
29/12/2018 08:33:51
null
null
null

7000068
35264
17501102909151
DYMO
LABEL WRITER 450 THERMAL PRINTER
test
1
06/07/2016 00:00:00
null
null
test
null
COBOURG
ON
K9A 5T9
CAN
test
test
test

Mississauga
ON
L5T 2J1
null
null
null
null
null
null
null
null
null
2.0300
0.2600
(1) Main Box
29/12/2018 00:00:00
023
null
023
null
null
null
null
null
null
null
null
null
False
False
2711500
False
null

null
null
null
null
null
null
null
null
null
null
False
29/12/2018 08:33:51
null
null
null

7000070
35264
061609634
HERO
A460-12E EUREKA COLORANT DISPENSE SYSTEM
test
1
21/07/2016 00:00:00
null
null
test
null
Hamilton
ON
L8H 2V4
CAN
test
test
test

Mississauga
ON
L5T 2J1
null
null
null
null
null
null
null
null
null
356.3000
46.3200
(1) Main Box
29/12/2018 00:00:00
129
null
129
null
null
null
null
null
null
null
null
null
False
False
2691571
False
null
null
null
null
null
null
null
null
null
null
null
null
False
29/12/2018 08:33:51
null
null
null

7000077
35264
17501102980651
DYMO
LABEL WRITER 450 THERMAL PRINTER
test
1
30/11/2016 00:00:00
null
null
test
null
PENTICTON
BC
V2A 8N2
CAN
test
test
test

Mississauga
ON
L5T 2J1
null
null
null
null
null
null
null
null
null
1.8700
0.2200
(1) Main Box
29/12/2018 00:00:00
351
null
351
null
null
null
null
null
null
null
null
null
False
False
2846756
False
null

null
null
null
null
null
null
null
null
null
null
False
29/12/2018 08:33:51
null
null
null

id	AuthUserId	ScheduleId	AuthUserId	PortfolioId	ID	UserID	FilterType	Include
88	null	null	88	1	null	null	null	null
88	null	null	88	1	null	null	null	null
88	null	null	88	2	null	null	null	null
88	null	null	88	2	null	null	null	null
14307	null	null	null	null	null	null	null	null

ID	Name	Username	Email	FirstName	LastName	FilterPortfolios	FilterSchedules	FilterMasterLeases	FilterUDFs
88	Edward C	Edward.c@.com	88@.com	Edward	C	True	True	True	False
14307	Camilla Test	camilla.T@.com	14307@.com	Camilla	Test	False	False	False	False

ID	Name	ShortName	DefaultCultureId	IsoCode	SourceSystemID	PortfolioID_SrcPK	API_CodeInSchedule
1	USA	US	4	USA	1	1	US\|USA
2	Canada	CA	2	CAN	1	2	null
3	United Kingdom	UK	3	GBR	2	1	UK
4	India	IN	3	IND	null	null	null
5	Norway	NO	3	NOR	null	null	null
6	Sweden	SE	3	SWE	null	null	null
7	Czech Republic	CZ	31	CZE	null	null	null
8	Slovakia	SK	30	SVN	null	null	null
9	Poland	PL	29	POL	null	null	null
10	Portugal	PT	28	PRT	null	null	null
11	Germany	DE	6	DEU	null	null	null
12	Italy	IT	27	ITA	null	null	null
13	Spain	ES	5	ESP	null	null	null
14	France	FR	7	FRA	null	null	null
15	Brazil	BR	26	BRA	null	null	null
16	Chile	CL	25	CHL	null	null	null
17	Colombia	CO	22	COL	null	null	null
18	Peru	PE	21	PER	null	null	null
19	Costa Rica	CR	20	CRI	null	null	null
20	El Salvador	SV	19	SLV	null	null	null
21	Guatemala	GT	18	GTM	null	null	null
22	Panama	PA	17	PAN	null	null	null
23	Puerto Rico	PR	16	PRI	null	null	null
24	Dominican Republic	DO	15	DOM	null	null	null
25	Honduras	HN	14	HND	null	null	null
26	Mexico	MX	13	MEX	null	null	null
27	China	CN	12	CHN	null	null	null
28	Hong Kong	HK	11	HKG	null	null	null
29	Singapore	SG	33	SGP	null	null	SG
30	Malaysia	MY	32	MYS	null	null	null
31	Australia	AU	10	AUS	null	null	AU\|AUS
32	New Zealand	NZ	10	NZL	null	null	null
33	Nicaragua	NI	61	ESI	null	null	null

ID	LeaseNo	AccountRepID	CustomerName	UdFilterLabel	UdfLabel1	UdfLabel2	UdfLabel3	UdfLabel4	UdfLabel5	UdfLabel6	UdfLabel7	UdfLabel8	UdfLabel9	UdfLabel10	WhenUpdated	Deleted	DeletedDate	PortfolioID	Active	International	LastModified	ExternalID	ExternalSourceId	ShowArchivedData	KeyCdfColumn
1	104972	82	test	null	null	null	null	null	null	null	null	null	null	null	04/02/2013 18:10:41	True	29/08/2015 00:00:00	1	True	False	22/06/2015 20:15:19	null	null	False	null
2	107414	81	test	null	null	null	null	null	null	null	null	null	null	null	04/02/2013 18:10:41	True	31/05/2016 00:00:00	1	True	False	22/06/2015 20:15:19	null	null	False	null

ID	UserID	FilterType	Include
11014	1206	U	0625
11129	1242	U	0133
13582	1326	U	8423
18228	1718	U	test
18306	2048	U	1003
18536	2162	U	MKIC-FG
18537	2162	U	MKIC
19308	3703	U	29602A
19309	3703	U	92231A
19310	3703	U	92618A
20383	5053	U	29602A
20778	5171	U	Actuant Electrical
20779	5171	U	Actuant Energy
20780	5171	U	BW Elliott
20781	5171	U	Corporate
20782	5171	U	Corporate AP
20783	5171	U	Corporate Audit
20784	5171	U	Corporate CEO
20785	5171	U	Corporate Collections
20786	5171	U	Corporate Energy
20787	5171	U	Corporate Engineered Solutions
20788	5171	U	Corporate Finance
20789	5171	U	Corporate HR
20790	5171	U	Corporate Industrial Segment

ID	Sched	MasterLeaseID	DateLeaseStarted	Term	TermUnitCode	DateLeaseEnds	Billing	Rent	Tax	LesseeCode	LesseeName	Insurance	FreqCode	PayFormCode	CurrCode	Ordering	Location	DateDeleted	AccountRepID	Deleted	International	Status	DeleteDate	LastModified	ExternalID	ExternalSourceId	DebtRate	NewHardwareCost	OriginalEquipmentCost	Margin	ResidualValue	FinalPV	VendorInvoiceTotal	ScheduleInsurance	Comment	USGAAPType
8	174	5	01/06/2011 00:00:00	36	null	31/05/2014 00:00:00	MONTHLY IN ADVANCE	2982.7100	0.0000	test	test	null	M	AD	USD	null	null	null	82	False	False	2	null	02/12/2017 05:27:18	null	null	null	null	115845.38	null	3689.00	null	null	null	null	null
863	065	112	01/01/2012 00:00:00	48	null	31/12/2015 00:00:00	QUARTERLY IN ADVANCE	499.4400	31.2300	test	test	null	Q	AD	USD	null	null	null	79	False	False	2	null	02/12/2017 05:27:18	null	null	null	null	8172.88	null	351.00	null	null	null	null	null
864	066	112	01/05/2012 00:00:00	36	null	30/04/2015 00:00:00	MONTHLY IN ADVANCE	81.5500	8.1600	test	test	null	M	AD	USD	null	null	null	79	False	False	2	null	18/10/2018 04:40:32	null	null	null	null	49342.79	null	460.00	null	null	null	null	null
865	067	112	01/04/2012 00:00:00	48	null	31/03/2016 00:00:00	QUARTERLY IN ADVANCE	233.2500	14.5700	test	test	null	Q	AD	USD	null	null	null	79	False	False	2	null	04/12/2018 08:15:10	null	null	null	null	1638.12	null	240.00	null	null	null	null	null
866	068	112	01/07/2012 00:00:00	48	null	30/06/2016 00:00:00	QUARTERLY IN ADVANCE	5401.4800	337.5000	test	test	null	Q	AD	USD	null	null	null	79	False	False	2	null	04/12/2018 08:15:10	null	null	null	null	52835.08	null	4229.00	null	null	null	null	null
1349	026	182	01/01/2012 00:00:00	36	null	31/12/2014 00:00:00	MONTHLY IN ADVANCE	85.5900	7.1200	test	test	null	M	AD	USD	null	null	null	82	False	False	2	null	04/04/2018 04:08:52	null	null	null	null	2817.80	null	248.00	null	null	null	null	null
2263	002	412	01/08/2011 00:00:00	60	null	31/07/2016 00:00:00	MONTHLY IN ADVANCE	672.5000	87.4500	test	test	null	M	AD	CAD	null	null	null	87	False	False	2	null	27/01/2018 05:20:32	null	null	null	null	33527.00	null	675.00	null	null	null	null	null
2446	023	55	01/10/2011 00:00:00	60	null	30/09/2016 00:00:00	MONTHLY IN ADVANCE	726.8700	64.6900	test	test	null	M	AD	USD	null	null	null	3706	False	False	2	null	19/06/2018 03:49:39	null	null	null	null	49981.85	null	656.00	null	null	null	null	null

ID	ScheduleID	SerialNo	Manufacturer	Model	Vendor	Quantity	DateAccepted	DateReturned	SiteName	SiteAddress	SiteAddress2	SiteCity	SiteState	SiteZip	SiteCountryCode	BillName	BillToAttn	BillAddress	BillCity	BillState	BillZip	BillCountryCode	RemitName	RemitToAttn	RemitAddress	RemitAddress2	RemitCity	RemitState	RemitZip	RemitCountryCode	Rent	Tax	AssetInfo	DateIn	CustomerRef	UdFilterValue	Udf1	Udf2	Udf3	Udf4	Udf5	Udf6	Udf7	Udf8	Udf9	Udf10	CSIDataLocked	CustomerDataLocked	InventoryId	Deleted	DateDeleted	Description	Returned	UnitInsurance	SiteLocale	SiteRegion	BillLocale	BillRegion	RemitLocale	RemitRegion	ExternalID	GeographyCoordinates	NonCsiLeased	LastModified	ExternalSourceId	Category	DateCreated
7000045	35264	3CQ6110T8G	HP	23" LED MONITOR	test	1	06/07/2016 00:00:00	null	null	test	null	CAMPBELLFORD	ON	K0L 1L0	CAN	test	test	test	Mississauga	ON	L5T 2J1	null	null	null	null	null	null	null	null	null	4.5900	0.6000	(1) Main Box	29/12/2018 00:00:00	017	null	017	null	null	null	null	null	null	null	null	null	False	False	2711863	False	null		null	null	null	null	null	null	null	null	null	null	False	29/12/2018 08:33:51	null	null	null
7000046	35264	CN45520HBR	HP	23" LED MONITOR	test	1	06/07/2016 00:00:00	null	null	test	null	FREDERICTON	NB	E3A 0T3	CAN	test	test	test	Mississauga	ON	L5T 2J1	null	null	null	null	null	null	null	null	null	4.3500	0.6500	(1) Main Box	29/12/2018 00:00:00	337	null	337	null	null	null	null	null	null	null	null	null	False	False	2711757	False	null		null	null	null	null	null	null	null	null	null	null	False	29/12/2018 08:33:51	null	null	null
7000047	35264	MXL5510L8L	HP	ELITEDESK 800 G1 CI5 QC 3.3GHZ	test	1	19/05/2016 00:00:00	null	null	test	null	NEW GLASGOW	NS	B2H 2J6	CAN	test	test	test	Mississauga	ON	L5T 2J1	null	null	null	null	null	null	null	null	null	34.6300	5.2000	(1) Main Box\|(1) STARTECH DESKTOP FEATURE	29/12/2018 00:00:00	067	null	067	null	null	null	null	null	null	null	null	null	False	False	2672341	False	null		null	null	null	null	null	null	null	null	null	null	False	29/12/2018 08:33:51	null	null	null
7000048	35264	CN46111DD5	HP	23" LED MONITOR	test	1	06/07/2016 00:00:00	null	null	test	null	Gloucester	ON	K1T 0K8	CAN	test	test	test	Mississauga	ON	L5T 2J1	null	null	null	null	null	null	null	null	null	4.5900	0.6000	(1) Main Box	29/12/2018 00:00:00	659	null	659	null	null	null	null	null	null	null	null	null	False	False	2711780	False	null		null	null	null	null	null	null	null	null	null	null	False	29/12/2018 08:33:51	null	null	null
7000049	35264	17501102909154	DYMO	LABEL WRITER 450 THERMAL PRINTER	test	1	06/07/2016 00:00:00	null	null	test	null	CHELMSFORD	ON	P0M 1L0	CAN	test	test	test	Mississauga	ON	L5T 2J1	null	null	null	null	null	null	null	null	null	2.0300	0.2600	(1) Main Box	29/12/2018 00:00:00	244	null	244	null	null	null	null	null	null	null	null	null	False	False	2711465	False	null		null	null	null	null	null	null	null	null	null	null	False	29/12/2018 08:33:51	null	null	null
7000066	35264	061621163	HERO	A260-12E ARCHIMEDE COLORANT DISPENSE SYSTEM	test	1	22/06/2016 00:00:00	null	null	test	null	ROTHESAY	NB	E2E 2R3	CAN	test	test	test	Mississauga	ON	L5T 2J1	null	null	null	null	null	null	null	null	null	216.4600	32.4700	(1) Main Box	29/12/2018 00:00:00	476	null	476	null	null	null	null	null	null	null	null	null	False	False	2631952	False	null	null	null	null	null	null	null	null	null	null	null	null	False	29/12/2018 08:33:51	null	null	null
7000068	35264	17501102909151	DYMO	LABEL WRITER 450 THERMAL PRINTER	test	1	06/07/2016 00:00:00	null	null	test	null	COBOURG	ON	K9A 5T9	CAN	test	test	test	Mississauga	ON	L5T 2J1	null	null	null	null	null	null	null	null	null	2.0300	0.2600	(1) Main Box	29/12/2018 00:00:00	023	null	023	null	null	null	null	null	null	null	null	null	False	False	2711500	False	null		null	null	null	null	null	null	null	null	null	null	False	29/12/2018 08:33:51	null	null	null
7000070	35264	061609634	HERO	A460-12E EUREKA COLORANT DISPENSE SYSTEM	test	1	21/07/2016 00:00:00	null	null	test	null	Hamilton	ON	L8H 2V4	CAN	test	test	test	Mississauga	ON	L5T 2J1	null	null	null	null	null	null	null	null	null	356.3000	46.3200	(1) Main Box	29/12/2018 00:00:00	129	null	129	null	null	null	null	null	null	null	null	null	False	False	2691571	False	null	null	null	null	null	null	null	null	null	null	null	null	False	29/12/2018 08:33:51	null	null	null
7000077	35264	17501102980651	DYMO	LABEL WRITER 450 THERMAL PRINTER	test	1	30/11/2016 00:00:00	null	null	test	null	PENTICTON	BC	V2A 8N2	CAN	test	test	test	Mississauga	ON	L5T 2J1	null	null	null	null	null	null	null	null	null	1.8700	0.2200	(1) Main Box	29/12/2018 00:00:00	351	null	351	null	null	null	null	null	null	null	null	null	False	False	2846756	False	null		null	null	null	null	null	null	null	null	null	null	False	29/12/2018 08:33:51	null	null	null