Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR026
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Matched_Transactions_HIST
Physical Name: NCABR026
Technical Name: NC_Matched_Transactions_HISTSeq 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 SOURCDOC Source Document STR10_Source_Document String 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['NC_Matched_Transactions_HIST'].SOURCDOC AS 'NC_Matched_Transactions_HIST-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
NCABR026 AS ['NC_Matched_Transactions_HIST']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['NC_Matched_Transactions_HIST'].SOURCDOC = ['Source Document Master'].SOURCDOC4 REFRENCE Reference STR30 String 30 5 DSCRIPTN Description STR30 String 30 6 TRXDATE TRX Date DT_Date Date 6 7 USERID User ID STR15_User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['NC_Matched_Transactions_HIST'].USERID AS 'NC_Matched_Transactions_HIST-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
NCABR026 AS ['NC_Matched_Transactions_HIST']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['NC_Matched_Transactions_HIST'].USERID = ['Users Master'].USERID8 NC_Bank_ID NC_Bank_ID STR15_Bank_ID String 15 9 NC_Trx_Date NC_Trx_Date DATE Date 6 10 NC_Reference NC_Reference STR30 String 30 11 NC_Trx_Type NC_Trx_Type STR9 String 9 12 NC_BL_Amount NC_BL_Amount NC_BL_Amount Currency 15 13 BANKID Bank ID STR15_Bank_ID String 15 14 TRXAMNT TRX Amount DLR19_$S2 Currency 19 15 NC_Sequence_Number NC_Sequence_Number NC_Sequence_Number Long Integer 10 16 RECONUM Reconcile Number DLR_Document_Number Currency 19 17 NC_Reconciled_Date NC_Reconciled_Date DATE Date 6 18 NC_Match_Number NC_Match_Number NC_Match_Number Long Integer 10 19 NC_Originating_Trx NC_Originating_Trx INT1 Integer 1 20 NCReconcileJournal NC_Reconcile_Journal LI8_U0 Long Integer 8 21 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['NC_Matched_Transactions_HIST'].CURRNIDX AS 'NC_Matched_Transactions_HIST-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
NCABR026 AS ['NC_Matched_Transactions_HIST']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_Matched_Transactions_HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX22 ORIGAMT Originating Amount DLR19_$S2 Currency 19 23 NC_Bank_Amount NC Bank Amount DLR19_$S2 Currency 19 24 NC_MC_Def_1 NC_MC_Def:Currency ID STR15_Currency_ID String 15 25 NC_MC_Def_2 NC_MC_Def:Currency Index INT3 Integer 3 26 NC_MC_Def_3 NC_MC_Def:Rate Type ID STR15_Rate_Type_ID String 15 27 NC_MC_Def_4 NC_MC_Def:Exchange Table ID STR15_Exchange_Table_ID String 15 28 NC_MC_Def_5 NC_MC_Def:Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 29 NC_MC_Def_6 NC_MC_Def:Exchange Date DT_Date Date 6 30 NC_MC_Def_7 NC_MC_Def:Decimal Places DDL_Decimal_Places Integer 0 31 NC_MC_Def_8 NC_MC_Def:Time TM6 Time 6 32 NC_MC_Def_9 NC_MC_Def:Rate Calc Method INT Integer 0 33 NC_MC_Def_10 NC_MC_Def:View Mode INT Integer 0 34 NC_MC_Def_11 NC_MC_Def:IS MC Trx INT Integer 0 35 NC_MC_Def_12 NC_MC_Def:Expiration Date DT_Date Date 6 36 NC_MC_Def_13 NC_MC_Def:Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 37 NC_MC_Def_14 NC_MC_Def:MC Transaction State INT1 Integer 1