SV_Technician_Inventory_Sites (SV01115)

azurecurveProductsWennSoft Products (131)3rd PartySV_Technician_Inventory_Sites (SV01115)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV01115

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: SV_Technician_Inventory_Sites
Physical Name: SV01115
Technical Name: SV_Technician_Inventory_Sites

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Technician SearchTechnicianSTR10_LBAUString1210
2LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['SV_Technician_Inventory_Sites'].LOCNCODE AS 'SV_Technician_Inventory_Sites-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       SV01115 AS ['SV_Technician_Inventory_Sites']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['SV_Technician_Inventory_Sites'].LOCNCODE = ['Site Setup'].LOCNCODE
azurecurveProductsWennSoft Products (131)3rd PartySV_Technician_Inventory_Sites (SV01115)

Leave a Reply

Your email address will not be published. Required fields are marked *