Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/XLFileIn
Product: Excel-Based Budgeting (1878)
Series:
Display Name: XLFileInfo
Physical Name: XLFileIn
Technical Name: XLFileInfoSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 FILEIDX 
FileIndex Long Integer LI_14 14 2 BUDGETID Budget ID String STR15_LBAU 15 Key to the Budget Master (GL00200).
Click to show/hide
SELECT
['XLFileInfo'].BUDGETID AS 'XLFileInfo-Budget ID'
,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID'
FROM
XLFileIn AS ['XLFileInfo']
INNER JOIN
GL00200 AS ['Budget Master']
ON
['XLFileInfo'].BUDGETID = ['Budget Master'].BUDGETID3 fileName fileName String STR255 255 4 Worksht Worksheet String STR31 31