-
Provides a list of all macros in the database including their components, accessories and alternatives You can execute this query using Excel Query Builder in RentalPoint..... WITH CTE AS ( SELECT ISNULL(...
-
Provides a list of all packages in the database including their components, accessories and alternatives You can execute this query using Excel Query Builder in RentalPoint..... WITH CTE AS ( SELECT ISN...
-
Provides a list of all packages in the database including their components, accessories and alternatives You can execute this query using Excel Query Builder in RentalPoint..... WITH CTE AS ( SELECT ISNULL(I...
-
Provides a list of all packages and macros in the database including their components, accessories and alternatives You can execute this query using Excel Query Builder in RentalPoint..... WITH CTE AS ( SELECT ...
-
Print barcode label for an asset or for all assets belonging to a product
-
/* Lists all assets in the Database */ SELECT I.groupfld AS [Group], g.group_descv6 AS [Group Desc], i.category AS [Category], c.cat_descv6 AS [Category Desc], A.pr...
-
RTF Insert fields are used to merge data from your RentalPoint Database with your MS Word template. Fields are available via the RentalPointInsertFieldModules.dll file or see our list of RTF Insert fields . Colour Insert Fields INSERT FIEL...
-
SELECT c.contactname AS [CONTACT NAME], c.firstname AS [FIRSTNAME], c.midname AS [MIDDLE NAME], c.surname AS [SURNAME], c.adr1 AS [ADDRESS 1], c.adr2 AS [ADDR...
-
/* All gear that didn't make it back from a show within date range, include warehouse status of the booking */ DECLARE @StartDate AS VARCHAR(20) DECLARE @EndDate AS VARCHAR(20) SET @StartDate = '2024-03-30' SET @EndDate = '2024-07-01' sele...
-
/* Shows all invoices with outstanding balance based on closing date with an outstanding amount greater than InvValue */ DECLARE @ClosingDate AS VARCHAR (20) DECLARE @InvValue FLOAT SET @ClosingDate = '2024-2-1' SET @InvValue = 1 SELECT B.b...