ASIEXP22 - SmartList Bank Reconciliation Explorer
Dynamics GP table ASIEXP22 (SmartList Bank Reconciliation Explorer) contains 69 columns including ASI_Favorite_Sequence, ASI_Order_By, CMRECNUM....
SQL Query Builder
69 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| ASI_Favorite_Sequence | ASI_Favorite_Sequence | Long Integer | 4 | ||
| ASI_Order_By | ASI_Order_By | Long Integer | 4 | ||
| CMRECNUM | Record Number | Currency | 10 | ||
| sRecNum | Record Number String | String | 22 | ||
| CNTRLTYP | Control Type | Integer | 2 | ||
Control Type values (3) 0 = Voucher types1 = Payment types2 = Printed alignment forms | |||||
| DEPOSITED | Deposited | Boolean | 2 | ||
| MDFUSRID | Modified User ID | String | 16 | ||
| MODIFDT | Modified Date | Date | 4 | ||
| CHEKBKID | Checkbook ID | String | 16 | ||
| depositnumber | Deposit Number | String | 22 | ||
| RCPTNMBR | Receipt Number | String | 22 | ||
| receiptdate | Receipt Date | Date | 4 | ||
| RCPTAMT | Receipt Amount | Currency | 10 | ||
| RcpType | Receipt Type | Integer | 2 | ||
| CARDNAME | Card Name | String | 16 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| BANKNAME | Bank Name | String | 32 | ||
| BNKBRNCH | Bank Branch | String | 22 | ||
| GLPOSTDT | GL Posting Date | Date | 4 | ||
| POSTEDDT | Posted Date | Date | 4 | ||
| PTDUSRID | Posted User ID | String | 16 | ||
| CMLinkID | CMLinkID | String | 16 | ||
| RcvdFrom | Received From | String | 32 | ||
| DSCRIPTN | Description | String | 32 | ||
| VOIDED | Voided | Boolean | 2 | ||
| VOIDDATE | Void Date | Date | 4 | ||
| VOIDPDATE | Void GL Posting Date | Date | 4 | ||
| VOIDDESC | Void Description | String | 32 | ||
| USERDEF1 | User Defined 1 | String | 22 | ||
| USERDEF2 | User Defined 2 | String | 22 | ||
| NOTEINDX | Note Index | Currency | 10 | ||
| RCRDSTTS | Record Status | Integer | 2 | ||
| SOURCDOC | Source Document1= Invoice2= Finance Charge3= Miscellaneous Charges4= Return5= Credit Memo | String | 12 | ||
| SRCDOCNUM | Source Doc Number | String | 22 | ||
| SRCDOCTYP | Source Doc Type | Integer | 2 | ||
| AUDITTRAIL | Audit Trail Code | String | 14 | ||
| ORIGAMT | Originating Amount | Currency | 10 | ||
| Checkbook_Amount | Checkbook Amount | Currency | 10 | ||
| RATETPID | Rate Type ID | String | 16 | ||
| RCVGRATETPID | Receiving Rate Type ID | String | 16 | ||
| EXGTBLID | Exchange Table ID | String | 16 | ||
| XCHGRATE | Exchange Rate | Currency (Variable) | 10 | ||
| Receiving_Exchange_Rate | Receiving Exchange Rate | Currency (Variable) | 10 | ||
| EXCHDATE | Exchange Date | Date | 4 | ||
| TIME1 | Time | Time | 4 | ||
| RTCLCMTD | Rate Calculation Method | Integer | 2 | ||
| RCVGRTCLCMTD | Receiving Rate Calc Method | Integer | 2 | ||
| EXPNDATE | Expiration Date | Date | 4 | ||
| CURRNIDX | Currency Index | Integer | 2 | ||
| DECPLCUR | Decimal Places Currency | Integer | 2 | ||
| RLGANLOS | Realized Gain-Loss Amount | Currency | 10 | ||
| Cash_Account_Index | Cash Account Index | Long Integer | 4 | ||
| Realized_GL_Account_Inde | Realized GL Account Index | Long Integer | 4 | ||
| DENXRATE | Denomination Exchange Rate | Currency (Variable) | 10 | ||
| MCTRXSTT | MC Transaction State0 = Euro currency is not created or no denomination currencies are enabled.1 = Originating is not a denomination; Functional is not a denomination2 = 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 | ||
| Receiving_DenomEXRate | Receiving Denomination Exchange Rate | Currency (Variable) | 10 | ||
| Receiving_MC_Transaction | Receiving MC Transaction State | Integer | 2 | ||
| ASI_CM_Document_Status | ASI_CM_Document_Status | Integer | 2 | ||
| CMTrxNum | CM Trx Number | String | 22 | ||
| CMTrxType | CM Trx Type | Integer | 2 | ||
| TRXDATE | TRX Date | Date | 4 | ||
| TRXAMNT | TRX Amount | Currency | 10 | ||
| paidtorcvdfrom | Paid ToRcvd From | String | 66 | ||
| Recond | Reconciled | Boolean | 2 | ||
| RECONUM | Reconcile Number | Currency | 10 | ||
| ClrdAmt | Cleared Amount | Currency | 10 | ||
| clearedate | Cleared Date | Date | 4 | ||
| DEPTYPE | Deposit Type | Integer | 2 | ||
| Xfr_Record_Number | Xfr Record Number | Currency | 10 | ||
Related Tables
Tables that share columns with ASIEXP22. Click "Join" to add to your query.