SmartList Bank Reconciliation Explorer (ASIEXP22)

azurecurve Products SmartList (1493)PathnameSmartList Bank Reconciliation Explorer (ASIEXP22)

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

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

Seq 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'].USERID
8	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'].CHEKBKID
10	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'].CURNCYID
17	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'].USERID
22	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'].NOTEINDX
32	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'].SOURCDOC
34	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'].RATETPID
40	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'].EXGTBLID
42	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'].CURRNIDX
50	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

azurecurve Products SmartList (1493)PathnameSmartList Bank Reconciliation Explorer (ASIEXP22)

Leave a Reply Cancel reply