Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR210
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Unreconciled_GL_TRX_OLD
Physical Name: NCABR210
Technical Name: NC_Unreconciled_GL_TRX_OLDSeq 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_OLD'].SOURCDOC AS 'NC_Unreconciled_GL_TRX_OLD-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
NCABR210 AS ['NC_Unreconciled_GL_TRX_OLD']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['NC_Unreconciled_GL_TRX_OLD'].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_OLD'].ACTINDX AS 'NC_Unreconciled_GL_TRX_OLD-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCABR210 AS ['NC_Unreconciled_GL_TRX_OLD']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_Unreconciled_GL_TRX_OLD'].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_OLD'].USWHPSTD AS 'NC_Unreconciled_GL_TRX_OLD-User Who Posted'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
NCABR210 AS ['NC_Unreconciled_GL_TRX_OLD']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['NC_Unreconciled_GL_TRX_OLD'].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_OLD'].CURNCYID AS 'NC_Unreconciled_GL_TRX_OLD-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
NCABR210 AS ['NC_Unreconciled_GL_TRX_OLD']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_Unreconciled_GL_TRX_OLD'].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_OLD'].CURRNIDX AS 'NC_Unreconciled_GL_TRX_OLD-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
NCABR210 AS ['NC_Unreconciled_GL_TRX_OLD']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_Unreconciled_GL_TRX_OLD'].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_OLD'].RATETPID AS 'NC_Unreconciled_GL_TRX_OLD-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
NCABR210 AS ['NC_Unreconciled_GL_TRX_OLD']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['NC_Unreconciled_GL_TRX_OLD'].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_OLD'].EXGTBLID AS 'NC_Unreconciled_GL_TRX_OLD-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
NCABR210 AS ['NC_Unreconciled_GL_TRX_OLD']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['NC_Unreconciled_GL_TRX_OLD'].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_OLD'].NOTEINDX AS 'NC_Unreconciled_GL_TRX_OLD-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
NCABR210 AS ['NC_Unreconciled_GL_TRX_OLD']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['NC_Unreconciled_GL_TRX_OLD'].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