Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR304
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Unreconciled_GL_TRX
Physical Name: NCABR304
Technical Name: NC_Unreconciled_GL_TRXSeq 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_Unreconciled_GL_TRX'].SOURCDOC AS 'NC_Unreconciled_GL_TRX-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
NCABR304 AS ['NC_Unreconciled_GL_TRX']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['NC_Unreconciled_GL_TRX'].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_Unreconciled_GL_TRX'].ACTINDX AS 'NC_Unreconciled_GL_TRX-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCABR304 AS ['NC_Unreconciled_GL_TRX']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_Unreconciled_GL_TRX'].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_Unreconciled_GL_TRX'].USWHPSTD AS 'NC_Unreconciled_GL_TRX-User Who Posted'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
NCABR304 AS ['NC_Unreconciled_GL_TRX']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['NC_Unreconciled_GL_TRX'].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 ORMSTRID Originating Master ID STR30 String 30 22 ORMSTRNM Originating Master Name STR64 String 64 23 ORDOCNUM Originating Document Number STR20 String 20 24 ORPSTDDT Originating Posted Date DT_Date Date 6 25 ORTRXSRC Originating TRX Source STR13 String 13 26 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['NC_Unreconciled_GL_TRX'].CURNCYID AS 'NC_Unreconciled_GL_TRX-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
NCABR304 AS ['NC_Unreconciled_GL_TRX']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_Unreconciled_GL_TRX'].CURNCYID = ['Currency Setup'].CURNCYID27 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['NC_Unreconciled_GL_TRX'].CURRNIDX AS 'NC_Unreconciled_GL_TRX-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
NCABR304 AS ['NC_Unreconciled_GL_TRX']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_Unreconciled_GL_TRX'].CURRNIDX = ['Currency Setup'].CURRNIDX28 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['NC_Unreconciled_GL_TRX'].RATETPID AS 'NC_Unreconciled_GL_TRX-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
NCABR304 AS ['NC_Unreconciled_GL_TRX']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['NC_Unreconciled_GL_TRX'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID29 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['NC_Unreconciled_GL_TRX'].EXGTBLID AS 'NC_Unreconciled_GL_TRX-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
NCABR304 AS ['NC_Unreconciled_GL_TRX']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['NC_Unreconciled_GL_TRX'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID30 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 31 EXCHDATE Exchange Date DT_Date Date 6 32 TIME1 Time TM6 Time 6 33 RTCLCMTD Rate Calculation Method GB Integer 0 34 ORIGAMT Originating Amount DLR19_$S2 Currency 19 35 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['NC_Unreconciled_GL_TRX'].NOTEINDX AS 'NC_Unreconciled_GL_TRX-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
NCABR304 AS ['NC_Unreconciled_GL_TRX']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['NC_Unreconciled_GL_TRX'].NOTEINDX = ['Record Notes Master'].NOTEINDX36 BANKID Bank ID STR15_Bank_ID String 15 37 NC_Sequence_Number NC_Sequence_Number NC_Sequence_Number Long Integer 10 38 NC_Bank_Amount NC Bank Amount DLR19_$S2 Currency 19 39 NC_MC_Def_1 NC_MC_Def:Currency ID STR15_Currency_ID String 15 40 NC_MC_Def_2 NC_MC_Def:Currency Index INT3 Integer 3 41 NC_MC_Def_3 NC_MC_Def:Rate Type ID STR15_Rate_Type_ID String 15 42 NC_MC_Def_4 NC_MC_Def:Exchange Table ID STR15_Exchange_Table_ID String 15 43 NC_MC_Def_5 NC_MC_Def:Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 44 NC_MC_Def_6 NC_MC_Def:Exchange Date DT_Date Date 6 45 NC_MC_Def_7 NC_MC_Def:Decimal Places DDL_Decimal_Places Integer 0 46 NC_MC_Def_8 NC_MC_Def:Time TM6 Time 6 47 NC_MC_Def_9 NC_MC_Def:Rate Calc Method INT Integer 0 48 NC_MC_Def_10 NC_MC_Def:View Mode INT Integer 0 49 NC_MC_Def_11 NC_MC_Def:IS MC Trx INT Integer 0 50 NC_MC_Def_12 NC_MC_Def:Expiration Date DT_Date Date 6 51 NC_MC_Def_13 NC_MC_Def:Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 52 NC_MC_Def_14 NC_MC_Def:MC Transaction State INT1 Integer 1