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 TypeLength
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer10
2ASI_Order_By SearchASI_Order_ByLI_14Long Integer14
3CMRECNUM SearchRecord NumberDLR_Document_NumberCurrency19
4sRecNum SearchRecord Number StringSTR20String20
5CNTRLTYP SearchControl TypeINT1Integer1
6DEPOSITED SearchDepositedBooleanBoolean0
7MDFUSRID SearchModified User IDSTR15String15
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 DateDTDate8
9CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString15
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_NumberString20
11RCPTNMBR SearchReceipt NumberSTR20_Document_NumberString20
12receiptdate SearchReceipt DateDTDate8
13RCPTAMT SearchReceipt AmountDLR19_RBS0_STR$Currency19
14RcpType SearchReceipt TypeDDL_Document_TypeInteger0
15CARDNAME SearchCard NameSTR15_Card_NameString15
16CURNCYID SearchCurrency IDSTR15_Currency_IDString15
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 NameSTR30String30
18BNKBRNCH SearchBank BranchSTR20String20
19GLPOSTDT SearchGL Posting DateDTDate8
20POSTEDDT SearchPosted DateDATEDate6
21PTDUSRID SearchPosted User IDSTR15String15
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_LBUString15
23RcvdFrom SearchReceived FromSTR30String30
24DSCRIPTN SearchDescriptionSTR30String30
25VOIDED SearchVoidedCBBoolean0
26VOIDDATE SearchVoid DateDTDate8
27VOIDPDATE SearchVoid GL Posting DateDTDate8
28VOIDDESC SearchVoid DescriptionSTR30String30
29USERDEF1 SearchUser Defined 1STR20String20
30USERDEF2 SearchUser Defined 2STR20String20
31NOTEINDX SearchNote IndexDLR14Currency14
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 StatusINTInteger0
33SOURCDOC SearchSource DocumentSTR10_Source_DocumentString10
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 NumberSTR20String20
35SRCDOCTYP SearchSource Doc TypeINTInteger0
36AUDITTRAIL SearchAudit Trail CodeSTR13_LBAUString13
37ORIGAMT SearchOriginating AmountDLR19_$S2Currency19
38Checkbook_Amount SearchCheckbook AmountDLR19_$S2Currency19
39RATETPID SearchRate Type IDSTR15_Rate_Type_IDString15
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_IDString15
41EXGTBLID SearchExchange Table IDSTR15_Exchange_Table_IDString15
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)14
43Receiving_Exchange_Rate SearchReceiving Exchange RateDLR14_Exchange_RateCurrency (Variable)14
44EXCHDATE SearchExchange DateDT_DateDate6
45TIME1 SearchTimeTM6Time6
46RTCLCMTD SearchRate Calculation MethodGBInteger0
47RCVGRTCLCMTD SearchReceiving Rate Calc MethodGBInteger0
48EXPNDATE SearchExpiration DateDT_DateDate6
49CURRNIDX SearchCurrency IndexINT3Integer3
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_DollarsInteger0
51RLGANLOS SearchRealized Gain-Loss AmountDLR19_$S2Currency19
52Cash_Account_Index SearchCash Account IndexLI_14Long Integer14
53Realized_GL_Account_Inde SearchRealized GL Account IndexLI_14Long Integer14
54DENXRATE SearchDenomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
55MCTRXSTT SearchMC Transaction StateINT1Integer1
56Receiving_DenomEXRate SearchReceiving Denomination Exchange RateDLR14_Exchange_RateCurrency (Variable)14
57Receiving_MC_Transaction SearchReceiving MC Transaction StateINT1Integer1
58ASI_CM_Document_Status SearchASI_CM_Document_StatusASI_CM_Document_StatusInteger0
59CMTrxNum SearchCM Trx NumberSTR20_Document_NumberString20
60CMTrxType SearchCM Trx TypeDDLInteger0
61TRXDATE SearchTRX DateDT_DateDate6
62TRXAMNT SearchTRX AmountDLR19_$S2Currency19
63paidtorcvdfrom SearchPaid ToRcvd FromSTR64String64
64Recond SearchReconciledBooleanBoolean0
65RECONUM SearchReconcile NumberDLR_Document_NumberCurrency19
66ClrdAmt SearchCleared AmountDLR19_$S2Currency19
67clearedate SearchCleared DateDTDate8
68DEPTYPE SearchDeposit TypeDDL_Document_TypeInteger0
69Xfr_Record_Number SearchXfr Record NumberDLR_Document_NumberCurrency19
azurecurveProductsSmartList (1493)PathnameSmartList Bank Reconciliation Explorer (ASIEXP22)

Leave a Reply

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