Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR032
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_GL_HIST_AUX
Physical Name: NCABR032
Technical Name: NC_GL_HIST_AUXSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 OPENYEAR 
Open Year INT4_S0 Integer 4 2 JRNENTRY Journal Entry LI8_U0 Long Integer 8 3 RCTRXSEQ Recurring TRX Sequence DLR19_$S2 Currency 19 4 SOURCDOC Source Document STR10_Source_Document String 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['NC_GL_HIST_AUX'].SOURCDOC AS 'NC_GL_HIST_AUX-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
NCABR032 AS ['NC_GL_HIST_AUX']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['NC_GL_HIST_AUX'].SOURCDOC = ['Source Document Master'].SOURCDOC5 REFRENCE Reference STR30 String 30 6 DSCRIPTN Description STR30 String 30 7 TRXDATE TRX Date DT_Date Date 6 8 TRXSORCE TRX Source STR13 String 13 9 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['NC_GL_HIST_AUX'].ACTINDX AS 'NC_GL_HIST_AUX-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCABR032 AS ['NC_GL_HIST_AUX']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_GL_HIST_AUX'].ACTINDX = ['Account Index Master'].ACTINDX10 TRXAMNT TRX Amount DLR19_$S2 Currency 19 11 POLLDTRX Polled Transaction YN Boolean 0 12 LASTUSER Last User User_ID String 15 13 LSTDTEDT Last Date Edited DT_Date Date 6 14 USWHPSTD User Who Posted User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['NC_GL_HIST_AUX'].USWHPSTD AS 'NC_GL_HIST_AUX-User Who Posted'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
NCABR032 AS ['NC_GL_HIST_AUX']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['NC_GL_HIST_AUX'].USWHPSTD = ['Users Master'].USERID15 ORGNTSRC Originating Source STR15 String 15 16 ORGNATYP Originating Type INT Integer 0 17 QKOFSET Quick Offset INT Integer 0 18 SERIES Series DDL_Series Integer 0 19 ORTRXTYP Originating TRX Type INT Integer 0 20 ORCTRNUM Originating Control Number STR20 String 20 21 NC_Orig_ID_600 NC_Orig_ID_600 STR20 String 20 22 ORMSTRID Originating Master ID STR30 String 30 23 NC_Orig_Name_600 NC_Orig_Name_600 STR30 String 30 24 ORMSTRNM Originating Master Name STR64 String 64 25 ORDOCNUM Originating Document Number STR20 String 20 26 ORPSTDDT Originating Posted Date DT_Date Date 6 27 ORTRXSRC Originating TRX Source STR13 String 13 28 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['NC_GL_HIST_AUX'].CURNCYID AS 'NC_GL_HIST_AUX-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
NCABR032 AS ['NC_GL_HIST_AUX']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_GL_HIST_AUX'].CURNCYID = ['Currency Setup'].CURNCYID29 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['NC_GL_HIST_AUX'].CURRNIDX AS 'NC_GL_HIST_AUX-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
NCABR032 AS ['NC_GL_HIST_AUX']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_GL_HIST_AUX'].CURRNIDX = ['Currency Setup'].CURRNIDX30 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['NC_GL_HIST_AUX'].RATETPID AS 'NC_GL_HIST_AUX-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
NCABR032 AS ['NC_GL_HIST_AUX']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['NC_GL_HIST_AUX'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID31 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['NC_GL_HIST_AUX'].EXGTBLID AS 'NC_GL_HIST_AUX-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
NCABR032 AS ['NC_GL_HIST_AUX']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['NC_GL_HIST_AUX'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID32 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 33 EXCHDATE Exchange Date DT_Date Date 6 34 TIME1 Time TM6 Time 6 35 RTCLCMTD Rate Calculation Method GB Integer 0 36 ORIGAMT Originating Amount DLR19_$S2 Currency 19 37 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['NC_GL_HIST_AUX'].NOTEINDX AS 'NC_GL_HIST_AUX-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
NCABR032 AS ['NC_GL_HIST_AUX']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['NC_GL_HIST_AUX'].NOTEINDX = ['Record Notes Master'].NOTEINDX38 NC_Match_Number NC_Match_Number NC_Match_Number Long Integer 10 39 BANKID Bank ID STR15_Bank_ID String 15 40 NC_Marked NC_Marked NC_Marked Boolean 0 41 NC_Matched NC_Matched Boolean Boolean 0 42 NC_Sequence_Number NC_Sequence_Number NC_Sequence_Number Long Integer 10 43 RECONUM Reconcile Number DLR_Document_Number Currency 19 44 NC_Reconciled_Date NC_Reconciled_Date DATE Date 6 45 NC_Originating_Trx NC_Originating_Trx INT1 Integer 1 46 NCReconcileJournal NC_Reconcile_Journal LI8_U0 Long Integer 8 47 NC_Bank_Amount NC Bank Amount DLR19_$S2 Currency 19 48 NC_MC_Def_1 NC_MC_Def:Currency ID STR15_Currency_ID String 15 49 NC_MC_Def_2 NC_MC_Def:Currency Index INT3 Integer 3 50 NC_MC_Def_3 NC_MC_Def:Rate Type ID STR15_Rate_Type_ID String 15 51 NC_MC_Def_4 NC_MC_Def:Exchange Table ID STR15_Exchange_Table_ID String 15 52 NC_MC_Def_5 NC_MC_Def:Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 53 NC_MC_Def_6 NC_MC_Def:Exchange Date DT_Date Date 6 54 NC_MC_Def_7 NC_MC_Def:Decimal Places DDL_Decimal_Places Integer 0 55 NC_MC_Def_8 NC_MC_Def:Time TM6 Time 6 56 NC_MC_Def_9 NC_MC_Def:Rate Calc Method INT Integer 0 57 NC_MC_Def_10 NC_MC_Def:View Mode INT Integer 0 58 NC_MC_Def_11 NC_MC_Def:IS MC Trx INT Integer 0 59 NC_MC_Def_12 NC_MC_Def:Expiration Date DT_Date Date 6 60 NC_MC_Def_13 NC_MC_Def:Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 61 NC_MC_Def_14 NC_MC_Def:MC Transaction State INT1 Integer 1