Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR309
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_GL_Extracted_Fields
Physical Name: NCABR309
Technical Name: NC_GL_Extracted_FieldsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 JRNENTRY 
Journal Entry LI8_U0 Long Integer 8 2 RCTRXSEQ Recurring TRX Sequence DLR19_$S2 Currency 19 3 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['NC_GL_Extracted_Fields'].ACTINDX AS 'NC_GL_Extracted_Fields-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCABR309 AS ['NC_GL_Extracted_Fields']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_GL_Extracted_Fields'].ACTINDX = ['Account Index Master'].ACTINDX4 TRXDATE TRX Date DT_Date Date 6 5 NC_Sequence_Number NC_Sequence_Number NC_Sequence_Number Long Integer 10 6 BANKID Bank ID STR15_Bank_ID String 15 7 CSHRCTYP Cash Receipt Type GB Integer 0 8 CHEKNMBR Check Number STR20_Document_Number String 20 9 CARDNAME Card Name STR15_Card_Name String 15 10 CSPORNBR Customer Purchase Order Number Document_Number String 20 11 NCEXFLD1 NC Extra Field 1 STR50 String 50 12 NCEXFLD2 NC Extra Field 2 STR50 String 50 13 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['NC_GL_Extracted_Fields'].CUSTNMBR AS 'NC_GL_Extracted_Fields-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
NCABR309 AS ['NC_GL_Extracted_Fields']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['NC_GL_Extracted_Fields'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR14 CPRCSTNM Corporate Customer Number STR15_RM_Customer_Number String 15 15 TRXDSCRN Transaction Description STR30 String 30 16 TRXSORCE TRX Source STR13 String 13 17 VCHRNMBR Voucher Number STR20_LBAU String 20 18 DOCNUMBR Document Number STR20_Document_Number String 20 19 REFRENCE Reference STR30 String 30 20 DSCRIPTN Description STR30 String 30