Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR412
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_StatementUD_MSTR
Physical Name: NCABR412
Technical Name: NC_StatementUD_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BANKID 
Bank ID STR15_Bank_ID String 15 2 NC_Statement_Number NC_Statement_Number Long Int Long Integer 8 3 LNITMSEQ Line Item Sequence LI_Sequence_Number Long Integer 10 4 NC_String_10_1 NC String 10[1] STR10 String 10 5 NC_String_10_2 NC String 10[2] STR10 String 10 6 NC_String_10_3 NC String 10[3] STR10 String 10 7 NC_String_10_4 NC String 10[4] STR10 String 10 8 NC_String_30_1 NC String 30[1] STR30 String 30 9 NC_String_30_2 NC String 30[2] STR30 String 30 10 NC_String_30_3 NC String 30[3] STR30 String 30 11 NC_String_30_4 NC String 30[4] STR30 String 30 12 NC_String_30_5 NC String 30[5] STR30 String 30 13 NC_String_30_6 NC String 30[6] STR30 String 30 14 NC_String_80_1 NC String 80[1] STR80 String 80 15 NC_String_80_2 NC String 80[2] STR80 String 80 16 NC_LongInt_1 NC LongInt[1] Long Int Long Integer 8 17 NC_LongInt_2 NC LongInt[2] Long Int Long Integer 8 18 NC_LongInt_3 NC LongInt[3] Long Int Long Integer 8 19 NC_LongInt_4 NC LongInt[4] Long Int Long Integer 8 20 NC_LongInt_5 NC LongInt[5] Long Int Long Integer 8 21 NC_LongInt_6 NC LongInt[6] Long Int Long Integer 8 22 NC_Dollar_1 NC Dollar[1] Dollar19 Currency 19 23 NC_Dollar_2 NC Dollar[2] Dollar19 Currency 19 24 NC_Date8 NC Date8 DATE_LONG Date 8 25 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['NC_StatementUD_MSTR'].ACTINDX AS 'NC_StatementUD_MSTR-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCABR412 AS ['NC_StatementUD_MSTR']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_StatementUD_MSTR'].ACTINDX = ['Account Index Master'].ACTINDX