ASIEXP22 - SmartList Bank Reconciliation Explorer | Prospr

ASIEXP22 - SmartList Bank Reconciliation Explorer

Query Builder

Select * from ASIEXP22

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
ASI_Order_By	ASI_Order_By	Long Integer	4	View
CMRECNUM	Record Number	Currency	10	View
sRecNum	Record Number String	String	22	View
CNTRLTYP	Control Type	Integer	2	View
DEPOSITED	Deposited	Boolean	2	View
MDFUSRID	Modified User ID	String	16	View
MODIFDT	Modified Date	Date	4	View
CHEKBKID	Checkbook ID	String	16	View
depositnumber	Deposit Number	String	22	View
RCPTNMBR	Receipt Number	String	22	View
receiptdate	Receipt Date	Date	4	View
RCPTAMT	Receipt Amount	Currency	10	View
RcpType	Receipt Type	Integer	2	View
CARDNAME	Card Name	String	16	View
CURNCYID	Currency ID	String	16	View
BANKNAME	Bank Name	String	32	View
BNKBRNCH	Bank Branch	String	22	View
GLPOSTDT	GL Posting Date	Date	4	View
POSTEDDT	Posted Date	Date	4	View
PTDUSRID	Posted User ID	String	16	View
CMLinkID	CMLinkID	String	16	View
RcvdFrom	Received From	String	32	View
DSCRIPTN	Description	String	32	View
VOIDED	Voided	Boolean	2	View
VOIDDATE	Void Date	Date	4	View
VOIDPDATE	Void GL Posting Date	Date	4	View
VOIDDESC	Void Description	String	32	View
USERDEF1	User Defined 1	String	22	View
USERDEF2	User Defined 2	String	22	View
NOTEINDX	Note Index	Currency	10	View
RCRDSTTS	Record Status	Integer	2	View
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
SRCDOCNUM	Source Doc Number	String	22	View
SRCDOCTYP	Source Doc Type	Integer	2	View
AUDITTRAIL	Audit Trail Code	String	14	View
ORIGAMT	Originating Amount	Currency	10	View
Checkbook_Amount	Checkbook Amount	Currency	10	View
RATETPID	Rate Type ID	String	16	View
RCVGRATETPID	Receiving Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
Receiving_Exchange_Rate	Receiving Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
RCVGRTCLCMTD	Receiving Rate Calc Method	Integer	2	View
EXPNDATE	Expiration Date	Date	4	View
CURRNIDX	Currency Index	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
RLGANLOS	Realized Gain-Loss Amount	Currency	10	View
Cash_Account_Index	Cash Account Index	Long Integer	4	View
Realized_GL_Account_Inde	Realized GL Account Index	Long Integer	4	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View
Receiving_DenomEXRate	Receiving Denomination Exchange Rate	Currency (Variable)	10	View
Receiving_MC_Transaction	Receiving MC Transaction State	Integer	2	View
ASI_CM_Document_Status	ASI_CM_Document_Status	Integer	2	View
CMTrxNum	CM Trx Number	String	22	View
CMTrxType	CM Trx Type	Integer	2	View
TRXDATE	TRX Date	Date	4	View
TRXAMNT	TRX Amount	Currency	10	View
paidtorcvdfrom	Paid ToRcvd From	String	66	View
Recond	Reconciled	Boolean	2	View
RECONUM	Reconcile Number	Currency	10	View
ClrdAmt	Cleared Amount	Currency	10	View
clearedate	Cleared Date	Date	4	View
DEPTYPE	Deposit Type	Integer	2	View
Xfr_Record_Number	Xfr Record Number	Currency	10	View

ASIEXP22 - SmartList Bank Reconciliation Explorer

Query Builder

Customer Service

Information

My Account

Contact Us