Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR301
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Extract_Exception_WORK_12005c
Physical Name: NCABR301
Technical Name: NC_Extract_Exception_WORK_12005cSeq 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 TRXDATE TRX Date DT_Date Date 6 5 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['NC_Extract_Exception_WORK_12005c'].ACTINDX AS 'NC_Extract_Exception_WORK_12005c-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCABR301 AS ['NC_Extract_Exception_WORK_12005c']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_Extract_Exception_WORK_12005c'].ACTINDX = ['Account Index Master'].ACTINDX6 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 7 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['NC_Extract_Exception_WORK_12005c'].CURNCYID AS 'NC_Extract_Exception_WORK_12005c-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
NCABR301 AS ['NC_Extract_Exception_WORK_12005c']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_Extract_Exception_WORK_12005c'].CURNCYID = ['Currency Setup'].CURNCYID8 BANKID Bank ID STR15_Bank_ID String 15 9 DEBITAMT Debit Amount DLR19_$S2 Currency 19 10 CRDTAMNT Credit Amount DLR19_$S2 Currency 19 11 ORCTRNUM Originating Control Number STR20 String 20 12 NC_Orig_ID_600 NC_Orig_ID_600 STR20 String 20 13 ORDOCNUM Originating Document Number STR20 String 20 14 ORMSTRID Originating Master ID STR30 String 30 15 ORGNTSRC Originating Source STR15 String 15 16 ORTRXSRC Originating TRX Source STR13 String 13 17 ORTRXTYP Originating TRX Type INT Integer 0 18 ORGNATYP Originating Type INT Integer 0 19 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 20 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['NC_Extract_Exception_WORK_12005c'].EXGTBLID AS 'NC_Extract_Exception_WORK_12005c-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
NCABR301 AS ['NC_Extract_Exception_WORK_12005c']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['NC_Extract_Exception_WORK_12005c'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID21 RTCLCMTD Rate Calculation Method GB Integer 0 22 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['NC_Extract_Exception_WORK_12005c'].RATETPID AS 'NC_Extract_Exception_WORK_12005c-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
NCABR301 AS ['NC_Extract_Exception_WORK_12005c']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['NC_Extract_Exception_WORK_12005c'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID23 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 24 MCTRXSTT MC Transaction State INT1 Integer 1 25 MKTOPROC Marked To Process CB Boolean 0