Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR208
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Deposit_LINE
Physical Name: NCABR208
Technical Name: NC_Deposit_LINESeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 OPENYEAR Open Year INT4_S0 Integer 4 2 depositnumber Deposit Number STR20_Document_Number String 20 3 JRNENTRY Journal Entry LI8_U0 Long Integer 8 4 RCTRXSEQ Recurring TRX Sequence DLR19_$S2 Currency 19 5 SOURCDOC Source Document STR10_Source_Document String 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['NC_Deposit_LINE'].SOURCDOC AS 'NC_Deposit_LINE-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
NCABR208 AS ['NC_Deposit_LINE']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['NC_Deposit_LINE'].SOURCDOC = ['Source Document Master'].SOURCDOC
6 REFRENCE Reference STR30 String 30 7 DSCRIPTN Description STR30 String 30 8 TRXDATE TRX Date DT_Date Date 6 9 TRXSORCE TRX Source STR13 String 13 10 ACTINDX Account Index LI_14 Long Integer 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['NC_Deposit_LINE'].ACTINDX AS 'NC_Deposit_LINE-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCABR208 AS ['NC_Deposit_LINE']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_Deposit_LINE'].ACTINDX = ['Account Index Master'].ACTINDX
11 TRXAMNT TRX Amount DLR19_$S2 Currency 19 12 POLLDTRX Polled Transaction YN Boolean 0 13 LASTUSER Last User User_ID String 15 14 LSTDTEDT Last Date Edited DT_Date Date 6 15 USWHPSTD User Who Posted User_ID String 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['NC_Deposit_LINE'].USWHPSTD AS 'NC_Deposit_LINE-User Who Posted'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
NCABR208 AS ['NC_Deposit_LINE']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['NC_Deposit_LINE'].USWHPSTD = ['Users Master'].USERID
16 ORGNTSRC Originating Source STR15 String 15 17 ORGNATYP Originating Type INT Integer 0 18 QKOFSET Quick Offset INT Integer 0 19 SERIES Series DDL_Series Integer 0 20 ORTRXTYP Originating TRX Type INT Integer 0 21 ORCTRNUM Originating Control Number STR20 String 20 22 ORMSTRID Originating Master ID STR30 String 30 23 NC_Orig_ID_600 NC_Orig_ID_600 STR20 String 20 24 ORMSTRNM Originating Master Name STR64 String 64 25 NC_Orig_Name_600 NC_Orig_Name_600 STR30 String 30 26 ORDOCNUM Originating Document Number STR20 String 20 27 ORPSTDDT Originating Posted Date DT_Date Date 6 28 ORTRXSRC Originating TRX Source STR13 String 13 29 CURNCYID Currency ID STR15_Currency_ID String 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['NC_Deposit_LINE'].CURNCYID AS 'NC_Deposit_LINE-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
NCABR208 AS ['NC_Deposit_LINE']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_Deposit_LINE'].CURNCYID = ['Currency Setup'].CURNCYID
30 CURRNIDX Currency Index INT3 Integer 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['NC_Deposit_LINE'].CURRNIDX AS 'NC_Deposit_LINE-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
NCABR208 AS ['NC_Deposit_LINE']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['NC_Deposit_LINE'].CURRNIDX = ['Currency Setup'].CURRNIDX
31 RATETPID Rate Type ID STR15_Rate_Type_ID String 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['NC_Deposit_LINE'].RATETPID AS 'NC_Deposit_LINE-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
NCABR208 AS ['NC_Deposit_LINE']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['NC_Deposit_LINE'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
32 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['NC_Deposit_LINE'].EXGTBLID AS 'NC_Deposit_LINE-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
NCABR208 AS ['NC_Deposit_LINE']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['NC_Deposit_LINE'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
33 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 34 EXCHDATE Exchange Date DT_Date Date 6 35 TIME1 Time TM6 Time 6 36 RTCLCMTD Rate Calculation Method GB Integer 0 37 ORIGAMT Originating Amount DLR19_$S2 Currency 19 38 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['NC_Deposit_LINE'].NOTEINDX AS 'NC_Deposit_LINE-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
NCABR208 AS ['NC_Deposit_LINE']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['NC_Deposit_LINE'].NOTEINDX = ['Record Notes Master'].NOTEINDX
39 NC_Match_Number NC_Match_Number NC_Match_Number Long Integer 10 40 BANKID Bank ID STR15_Bank_ID String 15 41 NC_Marked NC_Marked NC_Marked Boolean 0 42 NC_Matched NC_Matched Boolean Boolean 0 43 NC_Sequence_Number NC_Sequence_Number NC_Sequence_Number Long Integer 10 44 NC_Bank_Amount NC Bank Amount DLR19_$S2 Currency 19 45 NC_MC_Def_1 NC_MC_Def:Currency ID STR15_Currency_ID String 15 46 NC_MC_Def_2 NC_MC_Def:Currency Index INT3 Integer 3 47 NC_MC_Def_3 NC_MC_Def:Rate Type ID STR15_Rate_Type_ID String 15 48 NC_MC_Def_4 NC_MC_Def:Exchange Table ID STR15_Exchange_Table_ID String 15 49 NC_MC_Def_5 NC_MC_Def:Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 50 NC_MC_Def_6 NC_MC_Def:Exchange Date DT_Date Date 6 51 NC_MC_Def_7 NC_MC_Def:Decimal Places DDL_Decimal_Places Integer 0 52 NC_MC_Def_8 NC_MC_Def:Time TM6 Time 6 53 NC_MC_Def_9 NC_MC_Def:Rate Calc Method INT Integer 0 54 NC_MC_Def_10 NC_MC_Def:View Mode INT Integer 0 55 NC_MC_Def_11 NC_MC_Def:IS MC Trx INT Integer 0 56 NC_MC_Def_12 NC_MC_Def:Expiration Date DT_Date Date 6 57 NC_MC_Def_13 NC_MC_Def:Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 14 58 NC_MC_Def_14 NC_MC_Def:MC Transaction State INT1 Integer 1