Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR202
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Format_HDR
Physical Name: NCABR202
Technical Name: NC_Format_HDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Format_ID 
Format ID STR30_LBAU String 30 2 Format_Description Format Description STR50 String 50 3 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['NC_Format_HDR'].NOTEINDX AS 'NC_Format_HDR-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
NCABR202 AS ['NC_Format_HDR']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['NC_Format_HDR'].NOTEINDX = ['Record Notes Master'].NOTEINDX4 File_Format File Format File_Format_DDL Integer 0 5 Skip_Rows Skip Rows INT3_RUO Integer 3 6 NC_Skip_FTR_Rows NC_Skip_FTR_Rows INT3_RUO Integer 3 7 Pathname Pathname STR255 String 255 8 Require_Bank_ID Require Bank ID Boolean Boolean 0 9 NC_Signed NC Signed boolean Boolean 0 10 Exclude Exclude CB_Exclude Boolean 0 11 Exclude_String Exclude String STR20 String 20 12 NC_Type_Present NC Type Present Boolean Boolean 0 13 NC_Field_Separator NC Field Separator STR10 String 10 14 NC_Field_Delimiter NC Field Delimiter STR3 String 3