Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR211
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Import_Definitions_Master_93zk
Physical Name: NCABR211
Technical Name: NC_Import_Definitions_Master_93zkSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Import_Definition_ID 
Import Definition ID STR20_LBAU String 20 2 Import_Description Import Description STR50 String 50 3 Import_Format Import Format Import Format Integer 0 4 Import_File_Name Import File Name STR255 String 255 5 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 6 Save_File_Name Save File Name STR255 String 255 7 Error_Handling Error Handling Error Handling Integer 0 8 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['NC_Import_Definitions_Master_93zk'].NOTEINDX AS 'NC_Import_Definitions_Master_93zk-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
NCABR211 AS ['NC_Import_Definitions_Master_93zk']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['NC_Import_Definitions_Master_93zk'].NOTEINDX = ['Record Notes Master'].NOTEINDX9 Format_ID Format ID STR30_LBAU String 30 10 BANKID Bank ID STR15_Bank_ID String 15 11 Preserve_Sign Preserve Sign NC_Preserve_Sign Boolean 0 12 Skip_Last_Line Skip Last Line NC_SkipLast_Line Boolean 0 13 NC_Auto_Create_GL_Trxs NC_Auto_Create_GL_Trxs NC_Auto_Create_GL_Trxs Boolean 0 14 NC_Auto_Post_Account_Str NC_Auto_Post_Account_Str NC_STR128 String 128 15 NC_Auto_Propose NC_Auto_Propose NC_Auto_Propose_CB Boolean 0 16 NC_Auto_Reconcile NC Auto Reconcile CB Boolean 0 17 NC_Default_Sort_Code NC_Default_Sort_Code STR9 String 9