Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP22
Product: SmartList (1493)
Series:
Display Name: SmartList Bank Reconciliation Explorer
Physical Name: ASIEXP22
Technical Name: ASI_CM_Transactions_ExplorerSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ASI_Favorite_Sequence 
ASI_Favorite_Sequence Long Integer ASI_LI_10_RU 10 2 ASI_Order_By ASI_Order_By Long Integer LI_14 14 3 CMRECNUM Record Number Currency DLR_Document_Number 19 4 sRecNum Record Number String String STR20 20 5 CNTRLTYP Control Type Integer INT1 1 6 DEPOSITED Deposited Boolean Boolean 0 7 MDFUSRID Modified User ID String STR15 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SmartList Bank Reconciliation Explorer'].MDFUSRID AS 'SmartList Bank Reconciliation Explorer-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP22 AS ['SmartList Bank Reconciliation Explorer']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SmartList Bank Reconciliation Explorer'].MDFUSRID = ['Users Master'].USERID8 MODIFDT Modified Date Date DT 8 9 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['SmartList Bank Reconciliation Explorer'].CHEKBKID AS 'SmartList Bank Reconciliation Explorer-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ASIEXP22 AS ['SmartList Bank Reconciliation Explorer']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['SmartList Bank Reconciliation Explorer'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID10 depositnumber Deposit Number String STR20_Document_Number 20 11 RCPTNMBR Receipt Number String STR20_Document_Number 20 12 receiptdate Receipt Date Date DT 8 13 RCPTAMT Receipt Amount Currency DLR19_RBS0_STR$ 19 14 RcpType Receipt Type Integer DDL_Document_Type 0 15 CARDNAME Card Name String STR15_Card_Name 15 16 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SmartList Bank Reconciliation Explorer'].CURNCYID AS 'SmartList Bank Reconciliation Explorer-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
ASIEXP22 AS ['SmartList Bank Reconciliation Explorer']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SmartList Bank Reconciliation Explorer'].CURNCYID = ['Currency Setup'].CURNCYID17 BANKNAME Bank Name String STR30 30 18 BNKBRNCH Bank Branch String STR20 20 19 GLPOSTDT GL Posting Date Date DT 8 20 POSTEDDT Posted Date Date DATE 6 21 PTDUSRID Posted User ID String STR15 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SmartList Bank Reconciliation Explorer'].PTDUSRID AS 'SmartList Bank Reconciliation Explorer-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP22 AS ['SmartList Bank Reconciliation Explorer']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SmartList Bank Reconciliation Explorer'].PTDUSRID = ['Users Master'].USERID22 CMLinkID CMLinkID String STR15_LBU 15 23 RcvdFrom Received From String STR30 30 24 DSCRIPTN Description String STR30 30 25 VOIDED Voided Boolean CB 0 26 VOIDDATE Void Date Date DT 8 27 VOIDPDATE Void GL Posting Date Date DT 8 28 VOIDDESC Void Description String STR30 30 29 USERDEF1 User Defined 1 String STR20 20 30 USERDEF2 User Defined 2 String STR20 20 31 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['SmartList Bank Reconciliation Explorer'].NOTEINDX AS 'SmartList Bank Reconciliation Explorer-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
ASIEXP22 AS ['SmartList Bank Reconciliation Explorer']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SmartList Bank Reconciliation Explorer'].NOTEINDX = ['Record Notes Master'].NOTEINDX32 RCRDSTTS Record Status Integer INT 0 33 SOURCDOC Source Document String STR10_Source_Document 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['SmartList Bank Reconciliation Explorer'].SOURCDOC AS 'SmartList Bank Reconciliation Explorer-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
ASIEXP22 AS ['SmartList Bank Reconciliation Explorer']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['SmartList Bank Reconciliation Explorer'].SOURCDOC = ['Source Document Master'].SOURCDOC34 SRCDOCNUM Source Doc Number String STR20 20 35 SRCDOCTYP Source Doc Type Integer INT 0 36 AUDITTRAIL Audit Trail Code String STR13_LBAU 13 37 ORIGAMT Originating Amount Currency DLR19_$S2 19 38 Checkbook_Amount Checkbook Amount Currency DLR19_$S2 19 39 RATETPID Rate Type ID String STR15_Rate_Type_ID 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['SmartList Bank Reconciliation Explorer'].RATETPID AS 'SmartList Bank Reconciliation Explorer-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
ASIEXP22 AS ['SmartList Bank Reconciliation Explorer']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['SmartList Bank Reconciliation Explorer'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID40 RCVGRATETPID Receiving Rate Type ID String STR15_Rate_Type_ID 15 41 EXGTBLID Exchange Table ID String STR15_Exchange_Table_ID 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['SmartList Bank Reconciliation Explorer'].EXGTBLID AS 'SmartList Bank Reconciliation Explorer-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
ASIEXP22 AS ['SmartList Bank Reconciliation Explorer']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['SmartList Bank Reconciliation Explorer'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID42 XCHGRATE Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 43 Receiving_Exchange_Rate Receiving Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 44 EXCHDATE Exchange Date Date DT_Date 6 45 TIME1 Time Time TM6 6 46 RTCLCMTD Rate Calculation Method Integer GB 0 47 RCVGRTCLCMTD Receiving Rate Calc Method Integer GB 0 48 EXPNDATE Expiration Date Date DT_Date 6 49 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SmartList Bank Reconciliation Explorer'].CURRNIDX AS 'SmartList Bank Reconciliation Explorer-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
ASIEXP22 AS ['SmartList Bank Reconciliation Explorer']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SmartList Bank Reconciliation Explorer'].CURRNIDX = ['Currency Setup'].CURRNIDX50 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 51 RLGANLOS Realized Gain-Loss Amount Currency DLR19_$S2 19 52 Cash_Account_Index Cash Account Index Long Integer LI_14 14 53 Realized_GL_Account_Inde Realized GL Account Index Long Integer LI_14 14 54 DENXRATE Denomination Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 55 MCTRXSTT MC Transaction State Integer INT1 1 56 Receiving_DenomEXRate Receiving Denomination Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 57 Receiving_MC_Transaction Receiving MC Transaction State Integer INT1 1 58 ASI_CM_Document_Status ASI_CM_Document_Status Integer ASI_CM_Document_Status 0 59 CMTrxNum CM Trx Number String STR20_Document_Number 20 60 CMTrxType CM Trx Type Integer DDL 0 61 TRXDATE TRX Date Date DT_Date 6 62 TRXAMNT TRX Amount Currency DLR19_$S2 19 63 paidtorcvdfrom Paid ToRcvd From String STR64 64 64 Recond Reconciled Boolean Boolean 0 65 RECONUM Reconcile Number Currency DLR_Document_Number 19 66 ClrdAmt Cleared Amount Currency DLR19_$S2 19 67 clearedate Cleared Date Date DT 8 68 DEPTYPE Deposit Type Integer DDL_Document_Type 0 69 Xfr_Record_Number Xfr Record Number Currency DLR_Document_Number 19