Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/XLImport
Product: Excel-Based Budgeting (1878)
Series:
Display Name: XLImport
Physical Name: XLImport
Technical Name: XLImportSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['XLImport'].USERID AS 'XLImport-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
XLImport AS ['XLImport']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['XLImport'].USERID = ['Users Master'].USERID2 BUDGETID Budget ID String STR15_LBAU 15 Key to the Budget Master (GL00200).
Click to show/hide
SELECT
['XLImport'].BUDGETID AS 'XLImport-Budget ID'
,['Budget Master'].BUDGETID AS 'Budget Master-Budget ID'
FROM
XLImport AS ['XLImport']
INNER JOIN
GL00200 AS ['Budget Master']
ON
['XLImport'].BUDGETID = ['Budget Master'].BUDGETID3 ACTNUMBR_1 Account Number:Account_Segment_Pool1 String Account_Segment_Pool1 6 4 ACTNUMBR_2 Account Number:Account_Segment_Pool2 String Account_Segment_Pool2 6 5 ACTNUMBR_3 Account Number:Account_Segment_Pool3 String Account_Segment_Pool3 6 6 ACTNUMBR_4 Account Number:Account_Segment_Pool4 String Account_Segment_Pool4 6 7 ACTNUMBR_5 Account Number:Account_Segment_Pool5 String Account_Segment_Pool5 6 8 ACTNUMBR_6 Account Number:Account_Segment_Pool6 String Account_Segment_Pool6 6 9 ACTNUMBR_7 Account Number:Account_Segment_Pool7 String Account_Segment_Pool7 6 10 ACTNUMBR_8 Account Number:Account_Segment_Pool8 String Account_Segment_Pool8 6 11 ACTNUMBR_9 Account Number:Account_Segment_Pool9 String Account_Segment_Pool9 6 12 ACTNUMBR_10 Account Number:Account_Segment_Pool10 String Account_Segment_Pool10 6 13 PERIODDT Period Date Date DT_Date 6 14 PERIODID Period ID Integer INT3 3 15 BUDGETAMT Budget Amount Currency DLR19_$S2 19 16 ACCATNUM Account Category Number Integer INT2_U0 2 Key to the Account Category Master (GL00102).
Click to show/hide
SELECT
['XLImport'].ACCATNUM AS 'XLImport-Account Category Number'
,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number'
FROM
XLImport AS ['XLImport']
INNER JOIN
GL00102 AS ['Account Category Master']
ON
['XLImport'].ACCATNUM = ['Account Category Master'].ACCATNUM17 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['XLImport'].ACTINDX AS 'XLImport-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
XLImport AS ['XLImport']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['XLImport'].ACTINDX = ['Account Index Master'].ACTINDX