Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR041
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: ABR GL Lines for Consolidation
Physical Name: NCABR041
Technical Name: NC_GL_Consolidate_LinesSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID 
User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ABR GL Lines for Consolidation'].USERID AS 'ABR GL Lines for Consolidation-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
NCABR041 AS ['ABR GL Lines for Consolidation']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ABR GL Lines for Consolidation'].USERID = ['Users Master'].USERID2 NC_Bank_ID NC_Bank_ID STR15_Bank_ID String 15 3 NC_Sequence_Number NC_Sequence_Number NC_Sequence_Number Long Integer 10 4 REFRENCE Reference STR30 String 30 5 ORDOCNUM Originating Document Number STR20 String 20 6 TRXDATE TRX Date DT_Date Date 6 7 NC_Bank_Amount NC Bank Amount DLR19_$S2 Currency 19 8 NC_Marked NC_Marked NC_Marked Boolean 0