Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00947
Product: FieldService (949)
Series:
Display Name: SVC Tech Inventory Template Items
Physical Name: SVC00947
Technical Name: svcTechIVTemplateItemsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 SVC_Tech_Inventory_ID 
SVC Tech Inventory ID String STR10_LBAU 10 2 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['SVC Tech Inventory Template Items'].ITEMNMBR AS 'SVC Tech Inventory Template Items-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SVC00947 AS ['SVC Tech Inventory Template Items']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SVC Tech Inventory Template Items'].ITEMNMBR = ['Item Master'].ITEMNMBR3 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 4 QTY_Required QTY Required Currency DLR17_QTY_RBS0_UTR 17 5 UOFM U Of M String U_Of_M 8 6 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['SVC Tech Inventory Template Items'].NOTEINDX AS 'SVC Tech Inventory Template Items-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SVC00947 AS ['SVC Tech Inventory Template Items']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SVC Tech Inventory Template Items'].NOTEINDX = ['Record Notes Master'].NOTEINDX