SmartList Bank Reconciliation Explorer (ASIEXP22)

azurecurveProductsSmartList (1493)PathnameSmartList Bank Reconciliation Explorer (ASIEXP22)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP22

Product: SmartList (1493)
Series: Pathname

Display Name: SmartList Bank Reconciliation Explorer
Physical Name: ASIEXP22
Technical Name: ASI_CM_Transactions_Explorer

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
2ASI_Order_By SearchASI_Order_ByLI_14Long Integer414
3CMRECNUM SearchRecord NumberDLR_Document_NumberCurrency1019
4sRecNum SearchRecord Number StringSTR20String2220
5CNTRLTYP SearchControl TypeINT1Integer21
6DEPOSITED SearchDepositedBooleanBoolean20
7MDFUSRID SearchModified User IDSTR15String1615
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'].USERID
8MODIFDT SearchModified DateDTDate48
9CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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'].CHEKBKID
10depositnumber SearchDeposit NumberSTR20_Document_NumberString2220
11RCPTNMBR SearchReceipt NumberSTR20_Document_NumberString2220
12receiptdate SearchReceipt DateDTDate48
13RCPTAMT SearchReceipt AmountDLR19_RBS0_STR$Currency1019
14RcpType SearchReceipt TypeDDL_Document_TypeInteger20
15CARDNAME SearchCard NameSTR15_Card_NameString1615
16CURNCYID SearchCurrency IDSTR15_Currency_IDString1615
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'].CURNCYID
17BANKNAME SearchBank NameSTR30String3230
18BNKBRNCH SearchBank BranchSTR20String2220
19GLPOSTDT SearchGL Posting DateDTDate48
20POSTEDDT SearchPosted DateDATEDate46
21PTDUSRID SearchPosted User IDSTR15String1615
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'].USERID
22CMLinkID SearchCMLinkIDSTR15_LBUString1615
23RcvdFrom SearchReceived FromSTR30String3230
24DSCRIPTN SearchDescriptionSTR30String3230
25VOIDED SearchVoidedCBBoolean20
26VOIDDATE SearchVoid DateDTDate48
27VOIDPDATE SearchVoid GL Posting DateDTDate48
28VOIDDESC SearchVoid DescriptionSTR30String3230
29USERDEF1 SearchUser Defined 1STR20String2220
30USERDEF2 SearchUser Defined 2STR20String2220
31NOTEINDX SearchNote IndexDLR14Currency1014
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'].NOTEINDX
32RCRDSTTS SearchRecord StatusINTInteger20
33SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
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'].SOURCDOC
34SRCDOCNUM SearchSource Doc NumberSTR20String2220
35SRCDOCTYP SearchSource Doc TypeINTInteger20
36AUDITTRAIL SearchAudit Trail CodeSTR13_LBAUString1413
37ORIGAMT SearchOriginating AmountDLR19_$S2Currency1019
38Checkbook_Amount SearchCheckbook AmountDLR19_$S2Currency1019
39RATETPID SearchRate Type IDSTR15_Rate_Type_IDString1615
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'].RATETPID
40RCVGRATETPID SearchReceiving Rate Type IDSTR15_Rate_Type_IDString1615
41EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString1615
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'].EXGTBLID
42XCHGRATE SearchExchange RateDLR14_Exchange_RateCurrency (Variable)1014
43Receiving_Exchange_Rate SearchReceiving Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
44EXCHDATE SearchExchange DateDT_DateDate46
45TIME1 SearchTimeTM6Time46
46RTCLCMTD SearchRate Calculation MethodGBInteger20
47RCVGRTCLCMTD SearchReceiving Rate Calc MethodGBInteger20
48EXPNDATE SearchExpiration DateDT_DateDate46
49CURRNIDX SearchCurrency IndexINT3Integer23
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'].CURRNIDX
50DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
51RLGANLOS SearchRealized Gain-Loss AmountDLR19_$S2Currency1019
52Cash_Account_Index SearchCash Account IndexLI_14Long Integer414
53Realized_GL_Account_Inde SearchRealized GL Account IndexLI_14Long Integer414
54DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
55MCTRXSTT SearchMC Transaction StateINT1Integer21
56Receiving_DenomEXRate SearchReceiving Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
57Receiving_MC_Transaction SearchReceiving MC Transaction StateINT1Integer21
58ASI_CM_Document_Status SearchASI_CM_Document_StatusASI_CM_Document_StatusInteger20
59CMTrxNum SearchCM Trx NumberSTR20_Document_NumberString2220
60CMTrxType SearchCM Trx TypeDDLInteger20
61TRXDATE SearchTRX DateDT_DateDate46
62TRXAMNT SearchTRX AmountDLR19_$S2Currency1019
63paidtorcvdfrom SearchPaid ToRcvd FromSTR64String6664
64Recond SearchReconciledBooleanBoolean20
65RECONUM SearchReconcile NumberDLR_Document_NumberCurrency1019
66ClrdAmt SearchCleared AmountDLR19_$S2Currency1019
67clearedate SearchCleared DateDTDate48
68DEPTYPE SearchDeposit TypeDDL_Document_TypeInteger20
69Xfr_Record_Number SearchXfr Record NumberDLR_Document_NumberCurrency1019
azurecurveProductsSmartList (1493)PathnameSmartList Bank Reconciliation Explorer (ASIEXP22)

Leave a Reply

Your email address will not be published. Required fields are marked *