Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR003
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Unreconciled_GL_TRX_VOLD
Physical Name: NCABR003
Technical Name: NC_Unreconciled_GL_TRX_VOLDSeq 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_VOLD'].SOURCDOC AS 'NC_Unreconciled_GL_TRX_VOLD-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
NCABR003 AS ['NC_Unreconciled_GL_TRX_VOLD']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['NC_Unreconciled_GL_TRX_VOLD'].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_VOLD'].ACTINDX AS 'NC_Unreconciled_GL_TRX_VOLD-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCABR003 AS ['NC_Unreconciled_GL_TRX_VOLD']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_Unreconciled_GL_TRX_VOLD'].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_VOLD'].USWHPSTD AS 'NC_Unreconciled_GL_TRX_VOLD-User Who Posted'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
NCABR003 AS ['NC_Unreconciled_GL_TRX_VOLD']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['NC_Unreconciled_GL_TRX_VOLD'].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 NC_Orig_ID_600 NC_Orig_ID_600 STR20 String 20 23 ORMSTRNM Originating Master Name STR64 String 64 24 NC_Orig_Name_600 NC_Orig_Name_600 STR30 String 30 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_Unreconciled_GL_TRX_VOLD'].CURNCYID AS 'NC_Unreconciled_GL_TRX_VOLD-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
NCABR003 AS ['NC_Unreconciled_GL_TRX_VOLD']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_Unreconciled_GL_TRX_VOLD'].CURNCYID = ['Currency Setup'].CURNCYID29 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['NC_Unreconciled_GL_TRX_VOLD'].CURRNIDX AS 'NC_Unreconciled_GL_TRX_VOLD-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
NCABR003 AS ['NC_Unreconciled_GL_TRX_VOLD']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_Unreconciled_GL_TRX_VOLD'].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_Unreconciled_GL_TRX_VOLD'].RATETPID AS 'NC_Unreconciled_GL_TRX_VOLD-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
NCABR003 AS ['NC_Unreconciled_GL_TRX_VOLD']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['NC_Unreconciled_GL_TRX_VOLD'].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_Unreconciled_GL_TRX_VOLD'].EXGTBLID AS 'NC_Unreconciled_GL_TRX_VOLD-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
NCABR003 AS ['NC_Unreconciled_GL_TRX_VOLD']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['NC_Unreconciled_GL_TRX_VOLD'].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_Unreconciled_GL_TRX_VOLD'].NOTEINDX AS 'NC_Unreconciled_GL_TRX_VOLD-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
NCABR003 AS ['NC_Unreconciled_GL_TRX_VOLD']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['NC_Unreconciled_GL_TRX_VOLD'].NOTEINDX = ['Record Notes Master'].NOTEINDX38 BANKID Bank ID STR15_Bank_ID String 15 39 NC_Sequence_Number NC_Sequence_Number NC_Sequence_Number Long Integer 10